Official Bank 0/171

Microsoft Implementing Analytics Solutions Using Microsoft Fabric (DP-600) - Microsoft Exam Questions

Last updated on June 22, 2026

97% Exam Compliance
171 Total Questions
1
Question
HOTSPOT You have a Fabric tenant that contains a warehouse named Warehouse1. Warehouse1 contains three schemas named schemaA, schemaB. and schemaC You need to ensure that a user named User1 can truncate tables in schemaA only.

How should you complete the T-SQL statement? To answer, select the appropriate options in the
HOTSPOT
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

2
Question
HOTSPOT You have the source data model shown in the following exhibit.

Exhibit

key. The primary keys of the tables are indicated by a key symbol beside the columns involved in each You need to create a dimensional data model that will enable the analysis of order items by date, product, and customer. What should you include in the solution? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Exhibit
HOTSPOT
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

3
Question
You need to provide Power Bl developers with access to the pipeline. The solution must meet the following requirements:

• Ensure that the developers can deploy items to the workspaces for Development and Test.

• Prevent the developers from deploying items to the workspace for Production.

• Follow the principle of least privilege.

Which three levels of access should you assign to the developers? Each correct answer presents part of the solution. NOTE: Each correct answer is worth one point.
Select 3
Options
A Build permission to the production semantic models
B Admin access to the deployment pipeline
C Viewer access to the Production workspace
D Contributor access to the Production workspace
E Viewer access to the Development and Test workspaces
F Contributor access to the Development and Test workspaces
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

4
Question
HOTSPOT You have a Fabric warehouse that contains a table named Sales.Products. Sales.Products contains the

Exhibit

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

Exhibit

How should you complete the code? To answer, select the appropriate options in the answer area. following columns.

Exhibit
HOTSPOT
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

5
Question
HOTSPOT You have a Fabric warehouse that contains a table named Sales.Orders. Sales.Orders contains the

Exhibit

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

Exhibit

How should you complete the code? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Exhibit
HOTSPOT
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

Finish Practice?

Are you sure you want to finish? This will end your practice session.