DP-600 practice questions 171–180

1. Question 171 · 190 in bank

   HOTSPOT - You have a Fabric warehouse that contains a table named Sales.Orders. Sales.Orders contains the following columns.

   

   You need to write a T-SQL query that will return the following columns.

   

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

   Explanation

   Just echecked it. Date trunc returns the first date of the month and datepart just the month number. So given answer is correct.

   Source: Adapted from community discussion — e0f0ce6

   References

   • Microsoft Learn
   • Microsoft Learn

   

   Next question

2. Question 172 · 190 in bank

   Select 2

   You have a Fabric workspace named Workspace1. You need to create a semantic model named Model1 and publish Model1 to Workspace1. The solution must meet the following requirements: • Can revert to previous versions of Model1 as required. • Identifies differences between saved versions of Model1. • Uses Microsoft Power Bl=I Desktop to publish to Workspace1. • Can edit item definition files by using Microsoft Visual Studio Code. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

   • AEnable Git integration for Workspace1.
   • BSave Model1 in Power BI Desktop as a PBIT file.
   • CEnable users to edit data models in the Power BI service.
   • DSave Model1 in Power BI Desktop as a PBIP file.

   Show answer

   Answer: AD

   Next question

3. Question 173 · 190 in bank

   You have a Fabric workspace named Workspace1 that contains an eventstream named Eventstream1. Eventstream1 reads data from an Azure event hub named Eventhub1. Eventhub1 contains the following columns.

   

   You need to add a continuous percentile calculation to the Payload column. The solution must minimize development effort. What should you do?

   • AAdd a KQL queryset to Workspace1.
   • BAdd a Group by transformation to Eventstream1.
   • CAdd a Manage fields transformation to Eventstream1.
   • DAdd an Aggregate transformation to Eventstream1.

   Show answer

   Answer: D

   Next question

4. Question 174 · 190 in bank

   Select 2

   You have a Fabric warehouse that contains a table named Table1. Table1 contains three columns named SalesAmount, ProductCategory, and TransactionDate. You need to create a Microsoft Power BI query that will calculate the total sales amount of each product category for transactions that occurred during the last quarter. Which two actions should you perform in the visual query editor? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

   • AFor the TransactionDate column, select Remove duplicates.
   • BFor the TransactionDate column, select Keep top rows and set Number of rows to 90.
   • CFor the TransactionDate column, select Filter rows and set the value to last quarter.
   • DFor the ProductCategory column, select Group by and sum the SalesAmount column.
   • EFor the SalesAmount column, select Transformation number column - Standard, select Add, and then set the value to 90.

   Show answer

   Answer: CD

   Next question

5. Question 175 · 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 Power Query step to identify the maximum values for the numeric columns. Which function should you include in the step?

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

   Show answer

   Answer: C

   Next question

6. Question 176 · 190 in bank

   You have a Fabric tenant that contains the workspaces shown in the following table.

   

   You have a deployment pipeline named Pipeline1 that deploys items from Workspace_DEV to Workspace_TEST. In Pipeline1, all items that have matching names are paired. You deploy the contents of Workspace_DEV to Workspace_TEST by using Pipeline1. What will the contents of Workspace_TEST be once the deployment is complete?

   • ALakehouse2 - Notebook2 - SemanticModel1 -
   • BLakehouse1 - Notebook1 - Pipeline1 - SemanticModel1 -
   • CLakehouse1 - Lakehouse2 - Notebook1 - Notebook2 - Pipeline1 - SemanticModel1 -
   • DLakehouse2 - Notebook2 - Pipeline1 - SemanticModel1

   Show answer

   Answer: C

   Next question

7. Question 177 · 190 in bank

   You have a Fabric tenant that contains two workspaces named Workspace1 and Workspace2. Workspace1 is used as the development environment. Workspace2 is used as the production environment. Each environment uses a different storage account. Workspace1 contains a Dataflow Gen2 named Dataflow1. The data source of Dataflow1 is a CSV file in blob storage. You plan to implement a deployment pipeline to deploy items from Workspace1 to Workspace2. You need to ensure that the data source references the correct location in the production environment. What should you do?

   • ACreate a data source rule only.
   • BCreate a parameter rule only.
   • CCreate a data source rule and a parameter rule.
   • DAfter implementing the deployment pipeline, manually change the data source

   Show answer

   Answer: C

   Next question

8. Question 178 · 190 in bank

   You have a semantic model named Model1 that contains data that relates to customers and their bank account balances. Model1 has the following tables and columns.

   

   A customer can have one or more accounts. Each account can be associated to multiple customers. You need to ensure that users can query Model1 to identify the total transaction amounts by customer. What should you add to Model1?

   • Aa many-to-many relationship between FactTransaction and Dim Customer
   • Ba bridge table with relationships to DimCustomer and DimAccount
   • Ca bridge table with relationships to FactTransaction and DimCustomer
   • Dthe CustomerKey column in FactTransaction and a relationship to DimCustomer

   Show answer

   Answer: B

   Next question

9. Question 179 · 190 in bank

   You have a Fabric tenant that contains 30 CSV files in OneLake. The files are updated daily. You create a Microsoft Power BI semantic model named Model1 that uses the CSV files as a data source. You configure incremental refresh for Model1 and publish the model to an F64 capacity in the Fabric tenant. When you initiate a refresh of Model1, the refresh fails after running out of resources. What is a possible cause of the failure?

   • AXMLA Endpoint is set to Read Only.
   • BQuery folding is occurring.
   • CThe data type of the column used to partition the data has changed.
   • DOnly refresh complete days is selected.
   • EQuery folding is NOT occurring.

   Show answer

   Answer: E

   Next question

10. Question 180 · 190 in bank

    Select 2

    You have a Fabric workspace named Workspace1 that contains a lakehouse named Lakehouse1 and a user named User1. You need to ensure that User1 can read all the data in Lakehouse1. The solution must follow the principle of least privilege. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

    • AAssign the Contributor role to User1.
    • BSelect Read all Apache Spark.
    • CAssign the Viewer role to User1.
    • DShare Lakehouse1 by using item permissions.
    • EAssign the Member role to User1.

    Show answer

    Answer: BD

    Next question

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

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