DP-600 Exam Question 21

You have a Fabric tenant that contains a workspace named Workspace1. Workspace1 contains a lakehouse named Lakehouse1 and a warehouse named Warehouse1.
You need to create a new table in Warehouse1 named POSCustomers by querying the customer table in Lakehouse1.
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.

DP-600 Exam Question 22

You have a Microsoft Power Bl semantic model that contains measures. The measures use multiple calculate functions and a filter function.
You are evaluating the performance of the measures.
In which use case will replacing the filter function with the keepfilters function reduce execution time?
  • DP-600 Exam Question 23

    You have a Fabric tenant that contains a data warehouse.
    You need to load rows into a large Type 2 slowly changing dimension (SCD). The solution must minimize resource usage. Which T-SQL statement should you use?
  • DP-600 Exam Question 24

    You have a Fabric warehouse that contains a table named Sales.Products. Sales.Products 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.

    DP-600 Exam Question 25

    You need to recommend a solution to prepare the tenant for the PoC.
    Which two actions should you recommend performing from the Fabric Admin portal? Each correct answer presents part of the solution.
    NOTE: Each correct answer is worth one point.