PL-300: Microsoft Power BI Data Analyst practice questions, page 13 of 17, with answer review and explanations.
Question 61
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?
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.
Split the Logged column by using “at” as the delimiter.
Apply a transformation to extract the last 11 characters of the Logged column and set the data type of the new column to Date.
Create a column by example that starts with 2018-12-31.
Question 62
You have a Power BI Desktop file. You need to build a query that imports a CSV file named Sales.csv from a public website by using Power Query, promotes headers, and then applies column type changes. The solution must ensure that Sales.csv is requested only once during refreshes. 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 63
You have a Power BI Desktop file named File1 that contains four queries named Query1, Query2, Query3, and Query4. Query1 connects to a third-party web service named Web1 and has Enable load disabled. Query2, Query3, and Query4 are created by referencing Query1, and each query applies different transformations before loading to a semantic model named Model1. When you refresh Model1, separate requests are sent to Web1 for Query2, Query3, and Query4. You need to reduce the number of times data from Web1 is retrieved during a refresh. The solution must ensure that all the tables in Model1 are refreshed. What should you do?
For File1, clear Allow data preview to download in the background.
In Query1, configure Table.Buffer.
Convert Query1 into a Power BI dataflow.
Convert Query1 into a Microsoft Power Automate flow.
Question 64
You have a Power BI Desktop file named File1.pbix that contains a query named Query1. You have a CSV file named File1.csv that contains three columns named OrderDate, OrderID, and ProductID. Query1 imports File1.csv by using Power Query and includes transformation steps that remove top rows, promote headers, and change multiple column data types. You plan to create two additional queries: ● Query2 will filter rows to the last 30 days. ● Query3 will group rows by ProductID to create a summary table. You need to create the additional queries. The solution must meet the following requirements: ● Changes to the cleanup steps in Query1 must automatically be reflected in Query2. ● Query3 must continue to use the current cleanup logic even if Query1 changes later. ● Only the final output queries must load to the semantic model. What should you do?
duplicate Query1 for Query2, duplicate Query1 for Query3, and clear Enable load for Query1
reference Query1 for Query2, reference Query1 for Query3, and clear Enable load for Query1
reference Query1 for Query2, duplicate Query1 for Query3 and clear Enable load for Query1
duplicate Query1 for Query2, reference Query1 for Query3, and clear Enable load for Query1
Question 65
You have a Microsoft Power BI Desktop model in Power Query named Model1 that contains the following queries: For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.