Exam Code: DP-600
Exam Questions: 169
Microsoft Certified: Fabric Analytics Engineer Associate
Updated: 25 Nov, 2025
Viewing Page : 1 - 17
Practicing : 1 - 5 of 169 Questions
Question 1

You have a Fabric tenant that contains a warehouse. Several times a day. the performance of all warehouse queries degrades. You suspect that Fabric is throttling the compute used by the warehouse. What should you use to identify whether throttling is occurring? 

Options :
Answer: D

Question 2

You have a Fabric tenant that contains a lakehouse named lakehouse1. Lakehouse1 contains a table named Table1. You are creating a new data pipeline. You plan to copy external data to Table1. The schema of the external data changes regularly. You need the copy operation to meet the following requirements: Replace Table1 with the schema of the external data. Replace all the data in Table1 with the rows in the external data. You add a Copy data activity to the pipeline. What should you do for the Copy data activity?

Options :
Answer: B

Question 3

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.

Options :
Answer: B,D,E

Question 4

You need to refresh the Orders table of the Online Sales department. The solution must meet the semantic model requirements. What should you include in the solution? 

Options :
Answer: C

Question 5

You have a Fabric tenant. You are creating a Fabric Data Factory pipeline. You have a stored procedure that returns the number of active customers and their average sales for the current month. You need to add an activity that will execute the stored procedure in a warehouse. The returned values must be available to the downstream activities of the pipeline. Which type of activity should you add?Script

Options :
Answer: A

Viewing Page : 1 - 17
Practicing : 1 - 5 of 169 Questions

© Copyrights FreePDFQuestions 2025. All Rights Reserved

We use cookies to ensure that we give you the best experience on our website (FreePDFQuestions). If you continue without changing your settings, we'll assume that you are happy to receive all cookies on the FreePDFQuestions.