DP-600 practice questions 41–50

1. Question 41 · 190 in bank

   DRAG DROP - You have a Fabric workspace that contains a Dataflow Gen2 query. The query returns the following data.

   

   You need to filter the results to ensure that only the latest version of each customer’s record is retained. The solution must ensure that no new columns are loaded to the semantic model. Which four actions should you perform in sequence in Power Query Editor? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   Explanation

   Step 1: Group by CustomerID and calculate the max version date per customer ID This step groups the data by CustomerID and determines the maximum VersionDate for each customer. This identifies the latest record for each customer. Step 2: Expand the All Rows detail column This step expands the detail column, making all the data within each group accessible. This is necessary to access the other columns associated with the maximum VersionDate. Step 3: Filter the query where the version date value equals the max version date value This step filters the data, keeping only the rows where the VersionDate matches the maximum VersionDate calculated in Step 1. This ensures that only the latest record for each customer is retained. Step 4: Remove duplicates based on CustomerID This step removes any remaining duplicate rows based on CustomerID. Since we've already filtered for the latest record, this step ensures only one record per customer remains.

   Source: Adapted from community discussion — wgaignard2

   

   Next question

2. Question 42 · 190 in bank

   You have a Fabric tenant that contains a warehouse. You use a dataflow to load a new dataset from OneLake to the warehouse. You need to add a PowerQuery step to identify the maximum values for the numeric columns. Which function should you include in the step?

   • ATable.MaxN
   • BTable.Max
   • CTable.Range
   • DTable.Profile

   Show answer

   Answer: D

   Explanation

   I think it should be C Table.Profile - for EACH COLUMN maximum https://learn.microsoft.com/en-us/powerquery-m/table-profile Table.Max return 1 row for SPECIFIC COLUMN https://learn.microsoft.com/en-us/powerquery-m/table-max Table.MaxN works similar like Max but we have additional condion https://learn.microsoft.com/en-us/powerquery-m/table-maxn Table.Range https://learn.microsoft.com/en-us/powerquery-m/table-range

   Source: Adapted from community discussion — wojciech_wie

   References

   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn

   Next question

3. Question 43 · 190 in bank

   HOTSPOT - You have a Microsoft Power Bl project that contains a file named definition.pbir. definition.pbir contains the following JSON.

   

   For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   Explanation

   No, No, Yes 1. 1.0 isn't legacy format. It is a modern format. The Version would be blank if it was legacy. 2. The connection is null, and it looks like it is referencing a file, so it doesn't seem to be using the Service. 3. Since the semantic model is referenced locally (via byPath), Power BI Desktop can load the dataset file and allow edits to the model. This behavior aligns with how local datasets are treated in Power BI Desktop. Hope this helps!

   Source: Adapted from community discussion — testtaker45

   References

   • Microsoft Learn

   

   Next question

4. Question 44 · 190 in bank

   You have a Fabric tenant that contains a workspace named Workspace1. You plan to deploy a semantic model named Model1 by using the XMLA endpoint. You need to optimize the deployment of Model1. The solution must minimize how long it takes to deploy Model1. What should you do in Workspace1?

   • ASelect Small semantic model storage format.
   • BSelect Users can edit data models in the Power BI service.
   • CSet Enable Cache for Shortcuts to On.
   • DSelect Large semantic model storage format.

   Show answer

   Answer: D

   Explanation

   From Microsoft learn : If you're planning to use XMLA endpoint-based tools for semantic model write operations, be sure to enable the setting, even for semantic models that you wouldn't necessarily characterize as a large semantic model. When enabled, the large semantic model storage format can improve XMLA write operations performance. https://learn.microsoft.com/en-us/power-bi/enterprise/service-premium-large-models

   Source: Adapted from community discussion — 02d22cb

   References

   • Microsoft Learn

   Next question

5. Question 45 · 190 in bank

   You have a Microsoft Power BI project that contains a semantic model. You plan to use Azure DevOps for version control. You need to modify the .gitignore file to prevent the data values from the data sources from being pushed to the repository. Which file should you reference?

   • AunappliedChanges.json
   • Bcache.abf
   • ClocalSettings.json
   • Dmodel.bim

   Show answer

   Answer: B

   Explanation

   B. cache.abf Justification: This file contains the cached data for the semantic model. It is a binary file and can be very large. Excluding this file from version control is necessary to prevent pushing large amounts of unnecessary data, and will prevent data from data sources from being pushed to the repository. Why it's the correct option: Contains the cached data from the data model.

   Source: Adapted from community discussion — pk07

   Next question

6. Question 46 · 190 in bank

   You have a Fabric tenant that contains a workspace named Workspace1. Workspace1 uses Pro license mode and contains a semantic model named Model1. You need to ensure that Model1 supports XMLA connections. Which setting should modify?

   • AUsers can edit data models in the Power BI service
   • BEnforce strict access control for all data connection types
   • CEnable Cache for Shortcuts
   • DLicense mode

   Show answer

   Answer: D

   References

   • Microsoft Learn

   Next question

7. Question 47 · 190 in bank

   You have a Fabric tenant that contains a complex semantic model. The model is based on a star schema and contains many tables, including a fact table named Sales. You need to visualize a diagram of the model. The diagram must contain only the Sales table and related tables. What should you use from Microsoft Power BI Desktop?

   • Adata categories
   • BData view
   • CModel view
   • DDAX query view

   Show answer

   Answer: C

   Explanation

   ChatGPT: The correct answer is C. Model view Explanation: The Model view in Microsoft Power BI Desktop allows you to visualize the relationships between tables in a semantic model. It displays a diagram of the data model, where you can focus on specific tables, such as the Sales fact table and its related tables, by arranging or filtering the view. This is the ideal tool for analyzing the structure of a star schema and understanding table relationships.

   Source: Adapted from community discussion — zmeya

   Next question

8. Question 48 · 190 in bank

   HOTSPOT - You have a Fabric tenant that contains a lakehouse named LH1. You need to deploy a new semantic model. The solution must meet the following requirements: • Support complex calculated columns that include aggregate functions, calculated tables, and Multidimensional Expressions (MDX) user hierarchies. • Minimize page rendering times. How should you configure the model? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   Explanation

   correct : Mode: Import Provides the necessary support for calculated columns, calculated tables, and MDX hierarchies while optimizing performance. Query Caching: On Ensures minimal page rendering times by enabling caching.

   Source: Adapted from community discussion — 50cd6b8

   

   Next question

9. Question 49 · 190 in bank

   HOTSPOT - You have the following KQL query.

   

   For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   Explanation

   Yes Yes No The code is pretty easy to read. Try to say what each line says. Symbols Explination != means 'is not' >= means greater than or equal to > means greater than. Hope this helps!

   Source: Adapted from community discussion — testtaker45

   

   Next question

10. Question 50 · 190 in bank

    HOTSPOT - You have a Fabric lakehouse named Lakehouse1 that contains the following data.

    

    You need build a T-SQL statement that will return the total sales amount by OrderDate only for the days that are holidays in Australia. The total sales amount must sum the quantity multiplied by the price on each row in the dbo.sales table. How should you complete the statement? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

    

    This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

    Show the answer figure

    Answer: See figure below

    Explanation

    Sum(s.Quantity * s.UnitPrice), Inner So I think the first one is just syntax. Ensure it looks correct. For the type of Joins, they only want it if it is Australia. Inner will only bring over the matches, making it an ideal Join Type. To be fair, I had to look it up, but once I learned that I wanted to share.

    Source: Adapted from community discussion — testtaker45

    

    Next question

Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page

DP-600 practice, question 41. 190 questions available.