DP-600 Microsoft · Analytics Engineer
Implementing Analytics Solutions Using Microsoft Fabric. Practice exam aligned to the DP-600 skills measured (October 2026): maintaining a data analytics solution, preparing data with SQL, KQL and DAX, and implementing and optimizing semantic models in Microsoft Fabric.
Take the free DP-600 diagnostic10 questions, no card needed
3 questions from the free diagnostic, with answers and explanations.
A lakehouse must use files that stay in an existing Azure Data Lake Storage Gen2 account, without copying them into OneLake. What should you create?
Answer: A (A OneLake shortcut)
Shortcuts point to data in another location (ADLS Gen2, S3, another OneLake item) so it can be used in place, with no copy.
A team wants to move Fabric items from a development workspace to test and then to production, comparing the stages before each move. Which feature should they use?
Answer: A (Deployment pipelines)
Deployment pipelines map workspaces to stages, show the differences between stages and deploy content from one stage to the next.
In a Dataflow Gen2, you have two queries, Sales2025 and Sales2026, with the same columns. You need one query that contains the rows of both. Which operation should you use?
Answer: A (Append queries)
Append stacks the rows of tables that have the same columns. Merge joins tables side by side on matching keys.
Share of practice questions per skill area.
Build enterprise analytics solutions and semantic models in Microsoft Fabric.
Yes. Create a free account and take the DP-600 free diagnostic: 10 questions across every skill area of the exam, with a study plan for the topics to work on. You can retake it as often as you like.
Each full practice test has 40 questions with a 90-minute timer, and you pass at 70%. There are 6 practice tests plus a harder challenge test, with 350 questions in total.
Single choice, multiple select, hotspot (drop-down and yes/no), drag-and-drop matching, drag-and-drop select and place, case studies and exhibits (screenshots, diagrams and code), the same formats you meet on the real exam.
No. They are original questions written for ExamKite and mapped to the Microsoft skills outline, never copied from the real exam. Using leaked exam questions breaks the certification provider's exam rules and can get your certification revoked.
More answers in the full FAQ.
Start with the free diagnostic and get a study plan for the topics you miss.
