PL-300 questions and answers

 Question #29 Topic 1 HOTSPOT - 


You have a folder of monthly transaction extracts. You plan to create a report to analyze the transaction data. You receive the following email message: `Hi, I've put 24 files of monthly transaction data onto the shared drive. File Transactions201801.csv through Transaction201812.csv have four columns while files Transactions201901.csv through Transaction201912.csv have the same four columns plus an additional three columns. Each file contains 10 to 50 transactions.` You get data from the folder and select Combine & Load. The Combine Files dialog box is shown in the exhibit. (Click the Exhibit tab.)
x













 https://www.examtopics.com/exams/microsoft/da-100/custom-view/ 26/169 

The columns used are based on the entire dataset. The additional columns in the 2019 files will be detected. Box 3: Yes - Note: Under the hoods, Power BI will automatically detect which delimiter to use, and may even promote the first row as headers. You can manually change the delimiter, or define how Power BI should handle data types. You can set it to automatically detect data types based on first 200 rows, or the entire dataset or you can even opt out the detection of data types.







Reference: https://support.microsoft.com/en-us/office/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f588221c7098







Reference: https://community.powerbi.com/t5/Desktop/Error-calculating-QOQ-using-quick-measure/m-p/547054




You have a custom connector that returns ID, From, To, Subject, Body, and Has Attachments for every email sent during the past year. More than 10 million records are returned. You build a report analyzing the internal networks of employees based on whom they send emails to. You need to prevent report recipients from reading the analyzed emails. The solution must minimize the model size. What should you do? A. Implement row-level security (RLS) so that the report recipients can only see results based on the emails they sent. B. Remove the Subject and Body columns during the import. C. From Model view, set the Subject and Body columns to Hidden. Correct Answer: B Incorrect Answers: A, C: Does not reduce the size of the model. Community vote distribution B (100%) Question #33 Topic 1 Your company has training videos that are published to YouTube. You need to surface the videos directly in a Microsoft Power BI dashboard. Which type of tile should you add? 

A. video B. custom streaming data C. text box D. web content


 Correct Answer: B The only way to visualize a streaming dataset is to add a tile and use the streaming dataset as a custom streaming data source.


 Reference: https://docs.microsoft.com/en-us/power-bi/connect-data/service-real-time-streaming Community vote distribution A (100%)






Question #1 Topic 2 You build a report to analyze customer transactions from a database that contains the tables shown in the following table. You import the tables. Which relationship should you use to link the tables? 

A. many-to-many between Customer and Transaction 
B. one-to-many from Transaction to Customer
 C. one-to-many from Customer to Transaction 
D. one-to-one between Customer and Transaction 



Correct Answer: C Each customer can have many transactions. For each transaction there is exactly one customer





HOTSPOT - You have a Power BI report. You need to create a calculated table to return the 100 highest spending customers. How should you complete the DAX expression? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area:




























Comments

Post a Comment

Popular posts from this blog

renewal of DP-300 exam questions

Image
  According to Microsoft SQL Server configuration best practices, what should you do to configure cach According to Microsoft SQL Server configuration best practices, what should you do to configure caching on volumes that host log files? Select only one answer. Enable read caching only. Enable write caching only. Enable read and write caching. Disable all caching. You plan to deploy Microsoft SQL Server 2019 to an Azure virtual machine that has eight CPUs and four disks. You expect that SQL Server will run tempdb heavy-workloads. You need to optimize the performance of tempdb. What should you do? Select only one answer. Store tempdb in eight files of the same size. Store tempdb in four files. Configure one of the files to have the size matching the amount of memory allocated to SQL Server. Enable trace flag 1117. Enable trace flag 1118. : You plan to implement SQL Server on an Azure virtual machine that has managed disks. You need to ensure that the virtual machine disks hosting t...
Read more

DP-300 dumps

Image
 Question #1 Topic 1 You have 20 Azure SQL databases provisioned by using the vCore purchasing model. You plan to create an Azure SQL Database elastic pool and add the 20 databases. Which three metrics should you use to size the elastic pool to meet the demands of your workload? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point. A. total size of all the databases B. geo-replication support C. number of concurrently peaking databases * peak CPU utilization per database D. maximum number of concurrent sessions for all the databases E. total number of databases * average CPU utilization per database Correct Answer: ACE  CE: Estimate the vCores needed for the pool as follows: For vCore-based purchasing model: MAX(<Total number of DBs X average vCore utilization per DB>, <Number of concurrently peaking DBs X Peak vCore utilization per DB) A: Estimate the storage space needed for the pool by adding the number of bytes needed for ...
Read more

DP-300(30-60 questions)

Image
  You have an Azure virtual machine named VM1 on a virtual network named VNet1. Outbound traffic from VM1 to the internet is blocked. You have an Azure SQL database named SqlDb1 on a logical server named SqlSrv1. You need to implement connectivity between VM1 and SqlDb1 to meet the following requirements: ✑ Ensure that all traffic to the public endpoint of SqlSrv1 is blocked. ✑ Minimize the possibility of VM1 exfiltrating data stored in SqlDb1.  What should you create on VNet1?  A. a VPN gateway  B. a service endpoint  C. a private link  D. an ExpressRoute gateway  Correct Answer: C  You have 40 Azure SQL databases, each for a different customer. All the databases reside on the same Azure SQL Database server. You need to ensure that each customer can only connect to and access their respective database. Which two actions should you perform? Each correct answer presents part of the solution.  NOTE: Each correct selection is worth one point. A. Imp...
Read more