DP-600 practice questions 71–80

1. Question 71 · 190 in bank

   HOTSPOT - You have two Microsoft Power BI queries named Employee and Retired Roles. You need to merge the Employee query with the Retired Roles query. The solution must ensure that duplicate rows in each query are removed. Which column and Join Kind should you use in Power Query Editor? To answer, select the appropriate options in the answer area. NOTE: Each correct answer 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

   

   Next question

2. Question 72 · 190 in bank

   You have a Fabric tenant that contains a Microsoft Power BI report named Report1. Report1 includes a Python visual. Data displayed by the visual is grouped automatically and duplicate rows are NOT displayed. You need all rows to appear in the visual. What should you do?

   • AReference the columns in the Python code by index.
   • BModify the Sort Column By property for all columns.
   • CAdd a unique field to each row.
   • DModify the Summarize By property for all columns.

   Show answer

   Answer: C

   Explanation

   A - often the Microsoft learn pages give you the exact answer: Under tips on the link I posted: In some cases, you might not want automatic grouping to occur, or you might want all rows to appear, including duplicates. In those cases, you can add an index field to your dataset that causes all rows to be considered unique and prevents grouping. https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-python-visuals There are always multiple approaches in application but if you do the MS exam give the MS answer.

   Source: Adapted from community discussion — TashaP

   References

   • Microsoft Learn

   Next question

3. Question 73 · 190 in bank

   You have a Fabric tenant that contains a workspace named Workspace1 and a user named User1. Workspace1 contains a warehouse named DW1. You share DW1 with User1 and assign User1 the default permissions for DW1. What can User1 do?

   • ABuild reports by using the default dataset.
   • BRead data from the tables in DW1.
   • CConnect to DW1 via the Azure SQL Analytics endpoint.
   • DRead the underlying Parquet files from OneLake.

   Show answer

   Answer: C

   Explanation

   https://learn.microsoft.com/en-us/fabric/data-warehouse/share-warehouse-manage-permissions#share-a-warehouse "If no additional permissions are selected - The shared recipient by default receives "Read" permission, which only allows the recipient to connect to the SQL analytics endpoint"

   Source: Adapted from community discussion — Azure_2023

   References

   • Microsoft Learn

   Next question

4. Question 74 · 190 in bank

   DRAG DROP - You have a Fabric workspace named Workspace1. You have three groups named Group1, Group2, and Group3. You need to assign a workspace role to each group. The solution must follow the principle of least privilege and meet the following requirements: • Group1 must be able to write data to Workspace1, but be unable to add members to Workspace1. • Group2 must be able to configure and maintain the settings of Workspace1. • Group3 must be able to write data and add members to Workspace1, but be unable to delete Workspace1. Which workspace role should you assign to each group? To answer, drag the appropriate roles to the correct groups. Each role may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. 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

   Group1: Member The Member role allows users to contribute data and work with the content in the workspace, but does not grant permission to modify workspace membership. Group2: Admin The Admin role grants full control over workspace settings, including managing the workspace settings but not the actual data content. Group3: Contributor The Contributor role allows for adding data and managing workspace membership, but prevents workspace deletion, which satisfies the requirement of not allowing the deletion of Workspace1.

   Source: Adapted from community discussion — wemoe

   References

   • Microsoft Learn

   

   Next question

5. Question 75 · 190 in bank

   You have a Fabric tenant named Tenant1 that contains a lakehouse named Lakehouse1. You need to add data to Lakehouse1 from a CSV file in an Azure Storage account outside of Fabric. The solution must minimize development effort. What should you use to add the data?

   • Acopy job
   • Bshortcut
   • Cpipeline
   • DDataflow Gen2

   Show answer

   Answer: B

   Explanation

   Lakehouse Shortcuts are a minimal effort solution in Fabric to reference external data. This allows you to avoid complex development processes (like writing custom scripts or transforming the data manually) and still make the external data available within Lakehouse1. Shortcuts in Fabric Lakehouses enable you to connect to external data sources (such as data in Azure Storage accounts) directly, without physically copying the data into Lakehouse1. This solution allows you to easily access and work with the CSV data as if it were part of your Lakehouse1 data store, making it a highly efficient and low-code approach.

   Source: Adapted from community discussion — wemoe

   Next question

6. Question 76 · 190 in bank

   HOTSPOT - You have a Fabric warehouse that contains a table named Table1. Table1 contains the following data.

   

   You need to create a T-SQL statement that meets the following requirements: • Outputs the item name of each item and returns a null value if the item name is longer than 20 characters • Outputs the PurchaseDate value in the format of МММ dd, yy 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

   

   Next question

7. Question 77 · 190 in bank

   HOTSPOT - You have a Fabric workspace that contains a warehouse named Warehouse1. Warehouse1 contains the following data.

   

   You need to create a T-SQL statement that will denormalize the tables and include the ContractType and StartDate attributes in the results. The solution must meet the following requirements: • Include attributes from matching rows in the Contract table. • Ensure that all the rows from the Employee table are preserved. • Return the total number of employees per contract type for all the contract types that have more than two employees. 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

   

   Next question

8. Question 78 · 190 in bank

   HOTSPOT - You have a KQL database that contains a table named Readings. You need to query Readings and return the results shown in the following table.

   

   How should you complete the query? 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

   

   Next question

9. Question 79 · 190 in bank

   HOTSPOT - You have a Fabric workspace that contains a warehouse named DW1. DW1 contains the following tables and columns.

   

   You need to summarize order quantities by year and product. The solution must include the yearly sum of order quantities for all the products in each row. How should you complete the T-SQL 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

   

   Next question

10. Question 80 · 190 in bank

    DRAG DROP - You have a Fabric tenant that contains a semantic model. The model contains data about retail stores. You need to write a DAX query that will be executed by using the XMLA endpoint. The query must return a table of stores that have opened since December 1, 2023. How should you complete the DAX expression? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. 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

    I have tested it in dax.do changing fields and ans is DEFINE, EVALUATE and SUMMARIZE: DEFINE VAR _SalesSince = DATE ( 2000, 12, 01 ) EVALUATE FILTER ( SUMMARIZE ( 'Product', 'Product'[Product Name], 'Product'[Available Date] ), 'Product'[Available Date] >= _SalesSince )

    Source: Adapted from community discussion — seaverick

    References

    • Microsoft Learn
    • Microsoft Learn

    

    Next question

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

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