Microsoft Certified: Fabric Analytics Engineer Associate · DP-600
Test your free DP-600 learning scope
Sign in to practice every question included in the free learning topics, review explanations, and save your results.
How free practice works
Build confidence before your next step
Your account keeps attempts, review data, and the free study tools connected.
- 1
Sign in or register
Create a free account before starting a test.
- 2
Answer included questions
Practice questions from the included free learning topics.
- 3
Review your results
See explanations and knowledge-domain feedback immediately.
Your free test
Practice the included free learning topics
Each attempt selects from the questions inside the administrator-selected free learning topics.
Public question sample
Preview the question format
See the answer and explanation before starting your own practice test. This sample remains the same while it is available.
You are creating a Dataflow Gen2 that must read dbo.Order from the SalesOps SQL database. Before adding transformations, you must verify that the selected source contains OrderID, OrderDate, and NetAmount. You have already chosen the SQL connector, supplied the server and database endpoint, and authenticated successfully. The database contains several similarly named order tables. What should you do next?
- A.In Navigator, select dbo.Order and inspect its preview to confirm the expected columns and sample values.Correct answer
- B.Configure the dataflow destination and run the first refresh, then validate the source columns in the loaded output.
- C.In Navigator, select dbo.OrderArchive because it has more preview rows, and filter it to current orders during transformation.
- D.Close Navigator and create a blank query that declares the expected order columns without previewing the SQL table.
Why this is correct
Successful authentication confirms access to the SQL endpoint, but it does not confirm that the required source object has been selected or that its data has the expected structure. Because the dataflow must read dbo.Order and verify its columns before transformations begin, the data engineer should select that table in Navigator and inspect its preview.
Subject coverage
Knowledge domains covered in this subject
These weights describe the full subject blueprint. Free-test questions are selected randomly from the available question pool.
Maintain a data analytics solution (25–30%)25%
Prepare data (45–50%)50%
Implement and manage semantic models (25–30%)25%