PL-300 Practice Test

PL-300 Practice Test practice questions, page 12 of 16, 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 CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date and time each complaint occurred. The data in Logged is in the following format: 2018-12-31 at 08:59. You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy. What should you do?

  1. Change the data type of the Logged column to Date.
  2. Split the Logged column by using at as the delimiter.
  3. Add a conditional column that outputs 2018 if the Logged column starts with 2018 and set the data type of the new column to Whole Number.
  4. Apply the Parse function from the Date transformations options to the Logged column.

Question 60

You have a Microsoft Power BI report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace in shared capacity of powerbi.com. The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows. The dataset is scheduled to refresh twice a day at 08:00 and 17:00. The report is a single page that contains 15 AppSource visuals and 10 default visuals. Users say that the report is slow to load the visuals when they access and interact with the report. You need to recommend a solution to improve the performance of the report. What should you recommend?

  1. Enable visual interactions.
  2. Change any DAX measures to use iterator functions.
  3. Implement row-level security (RLS).
  4. Remove unused columns from tables in the data model.