Microsoft Power BI Data Analyst (PL-300) - Microsoft Actual Exam Questions

HOTSPOT You have the data lineage shown in the following exhibit. Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point.

You create a dataset sourced from dozens of flat files in Azure Blob storage. The dataset uses incremental refresh. From powerbi.com, you deploy the dataset and several related reports to Microsoft Power BI Premium capacity. You discover that the dataset refresh fails after the refresh runs out of resources. What is a possible cause of the issue?

You have a PBiX file that imports several tables from an Azure SQL database. The data will be migrated to another Azure SQL database. You need to change the connections in the PBIX file. The solution must minimize administrative effort. What should you do?

You maintain a Power Bl workspace that contains a supplier quality dashboard. The dashboard contains 10 card visuals, two map visuals and five bar chart visuals. The dashboard mobile layout is shown in the exhibit. (Click the Exhibit tab.) You need to modify the dashboard mobile layout to meet the following requirements: • Only show single-value visuals. • Minimize scrolling. What should you do?

HOTSPOT You have two tables named Customers and Invoice in a Power BI model. The Customers table contains the following fields: CustomerID Customer City Customer State Customer Name Customer Address 1 Customer Address 2 Customer Postal Code The Invoice table contains the following fields: Order ID Invoice ID Invoice Date Customer ID Total Amount Total Item Count The Customers table is related to the Invoice table through the Customer ID columns. A customer can have many invoices within one month. The Power BI model must provide the following information: The number of customers invoiced in each state last month The average invoice amount per customer in each postal code You need to define the relationship from the Customers table to the Invoice table. The solution must optimize query performance. What should you configure? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.