PL-300: Microsoft Power BI Data Analyst

PL-300: Microsoft Power BI Data Analyst practice questions, page 12 of 17, with answer review and explanations.

Question 56

You plan to create a Power BI semantic model named Model1 that will contain data from an Azure SQL database. Model1 will have the following tables. You create DimDate and DimProduct by using import storage mode. You need to configure the storage mode for each remaining table. The solution must meet the following requirements: • The data in FactSales must be available within five minutes of being available in the source data. • The query response time for reports connected to the model must be minimized. Which storage mode should you configure for each table? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Question 57

You use Power BI Desktop to import two tables named Customer and Contacts. The Customer table contains the following columns: • Customer_Name • Customer ID • Website The Contacts table contains the following columns: • Contact ID • Contact Email • Contact Name • Customer Name A web-based contact form is used to fill the Contacts table. The data is not sanitized. You need to create a merge for the Customer and Contacts tables. What should you do?

  1. Set Join Kind to Full Outer.
  2. Disable fuzzy matching.
  3. Set Join Kind to Left Outer.
  4. Enable fuzzy matching.

Question 58

You have a Power BI semantic model that imports data from a Microsoft SQL Server database and an Oracle database. The semantic model is deployed to the Power BI service. Parameters are already used for the SQL Server data source. You are planning to make change to the semantic model that will ensure consistent behavior across all the data sources. You need to enable parameterization for the Oracle data source. The solution must minimize changes to the existing model. What should you do?

  1. From Power BI Desktop, modify the Oracle data source to use a parameter, and then republish the model to the Power BI service.
  2. From the Power BI service, modify the parameters of the SQL Server data source.
  3. From the Power BI service, create a new semantic model that uses the existing model as a data source, and then parameterize the new model.
  4. From the Power BI service, set a parameter value for the model.

Question 59

You have a Power BI Desktop file that loads a CSV file into a query named Sales by using Power Query. Sales includes a column named SaleDate. You discover that SaleDate contains unexpected and null values. You need to ensure that the Sales query performs data profiling over the entire dataset and returns a summary table that counts Valid, Error, and Empty values for SaleDate. How should you complete the Power Query M code? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Question 60

You have a Microsoft Power BI Desktop model that contains an M parameter named CountryParameter of type text and a table named Sales. Sales contains a column named Country. A report page uses a slicer on Country. The slicer is configured to allow only one selected value at a time. You need to ensure that the slicer selection is applied to the source query text. How should you complete the M code? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.