PL-300 Free Practice Questions — Page 2

Question 11

HOTSPOT - You have a semantic model that contains a table named Sales. The table contains the following columns: • Order ID • Product ID • Sales Date • Sales Amount You need to create a DAX measure that will return the total sales amount for the same dates from the previous year. How should you complete the measure? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Question 12

You attempt to open a PBIX file in Microsoft Power BI Desktop and receive the following error message in Power Query Editor. DataSource.Error: Could not find file D:\Data.txt. How should you resolve the issue?

Question 13

You have a semantic model named Model1. You need to ensure that users can verify that the data in Model1 meets corporate standards. What should you do?

Question 14

HOTSPOT - You have a query that contains customer data in Power Query Editor as 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.

Question 15

You use Power BI Desktop to create a report named RPT1 that loads data from a Microsoft Excel file named File1. File1 is located in a network share. File1 is moved to a different folder. When you open RPT1 in Power BI Desktop, you discover that the report displays outdated data. You need to ensure that the data in File1 refreshes properly. What should you do?

Question 16

HOTSPOT - You plan to use Power Query Editor to get data from an API. The API returns a JSON response. You have a username and password for the API. Which data source and authentication method should you use to connect to the API? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Question 17

You have a table named DIMCountries that contains a column named Country as shown in the following table. You plan to use DIMCountries as a dimension in a report. You need to ensure that the Country column in DIMCountries lists each country only once. Which two actions should you perform on the Country column? Each correct answer presents part of the solution. NOTE: Each correct answer is worth one point.

Question 19

HOTSPOT - You use Power Query Editor to ingest data into Power BI Desktop. The total dataset contains 250,000 rows. All the rows match the format of the data as shown in the following exhibit. You need to optimize the data model size of the table. Which type of data should you use for the Value column and the Datetime column? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Question 20

HOTSPOT - You have a semantic model that has the relationships 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.

Question 21

HOTSPOT - You import a Microsoft Excel spreadsheet into Power Query Editor and name the query Sales_Spreadsheet. Sales_Spreadsheet contains the following columns: • Customer ID • Customer Name • Date • Total Sales Amount You plan to use the Sales Spreadsheet query to load two tables named Customer and Sales into the associated semantic model. The tables relate to each other on the Customer ID column of each query. The solution must meet the following requirements: • The Customer query must contain the Customer ID and Customer Name columns. • The Sales query must contain the Customer ID, Date, and Total Sales Amount columns. • Power Query logic must be consolidated to avoid the duplication of logic across the queries and ensure that only one location is used to update the logic. You need to identify how to create the Sales query, and what to do to the Sales_Spreadsheet query before loading the model? What should you do? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.