Logo ExamsQA
Exit
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
You have a Fabric tenant that contains a data pipeline. You need to ensure that the pipeline runs every four hours on Mondays and Fridays. To what should you set Repeat for the schedule?
Options
A By the minute
B Hourly
C Weekly
D Daily
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

2
Question
You have a Fabric workspace that contains a DirectQuery semantic model. The model queries a data source that has 500 million rows. You have a Microsoft Power Bl report named Report1 that uses the model. Report! contains visuals on multiple pages. You need to reduce the query execution time for the visuals on all the pages.

What are two features that you can use? Each correct answer presents a complete solution.

NOTE: Each correct answer is worth one point.
Select 2
Options
A OneLake integration
B automatic aggregation
C query caching
D user-defined aggregations
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

3
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!

4
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!

5
Question
You have a Fabric tenant that contains a workspace named Workspace1. Workspace1 contains a data pipeline named Pipeline1 and a lakehouse named Lakehouse1.

You perform the following actions: Create a workspace named Workspace2. Create a deployment pipeline named DeployPipeline1 that will deploy items from Workspace1 to Workspace2. Add a folder named Folder1 to Workspace1. Move Lakehouse1 to Folder1. Run DeployPipeline1.

Which structure will Workspace2 have when DeployPipeline1 is complete?
Options
A \Folder1Lakehouse1
B \Pipeline1 \Lakehouse1
C \Folder1\Pipeline1 \Folder1\Lakehouse1
D \Pipeline1 \Folder1\Lakehouse1
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.