DP-700 Practice Test

DP-700 Practice Test practice questions, page 7 of 7, with answer review and explanations.

Question 31

You have a Fabric workspace that contains a warehouse named Warehouse1. In Warehouse1, you create a table named DimCustomer by running the following statement. You need to set the Customerkey column as a primary key of the DimCustomer table. Which three code segments should you run in sequence? To answer, move the appropriate code segments from the list of code segments to the answer area and arrange them in the correct order.

Question 32

You have a Fabric workspace that contains a semantic model named Model1. You need to dynamically execute and monitor the refresh progress of Model1. What should you use?

  1. dynamic management views in Microsoft SQL Server Management Studio (SSMS)
  2. Monitoring hub
  3. dynamic management views in Azure Data Studio
  4. a semantic link in a notebook