DP-600
Fabric Analytics Engineer Associate
24 lessons · 229 questions · Recently updated
DP-600 practice test questions in the style of the real exam, a free 10-question mock test you can take without an account, and a full 50-question timed mock exam. Every answer comes with an explanation.
📖 Free study guideFull practice exam
50 questions · 100 minutes · timed, scored by domain · drawn from a bank of 205
Lessons by domain
Every lesson ends with a practice scenario on what you just read, with an explanation for every answer.
- FreeOpen
Domain 1: Maintain a data analytics solution
7 lessons · 7 practice scenarios
- 🔒 Questions: ProOpen
Domain 2: Prepare data
9 lessons · 9 practice scenarios
- 🔒 Questions: ProOpen
Domain 3: Implement and manage semantic models
8 lessons · 8 practice scenarios
Free DP-600 sample questions
5 questions from the DP-600 practice test, with the answer and an explanation for each. They are original scenarios written from the public exam outline, not real exam questions.
Question 1
A company will publish Power BI reports from one workspace to 1,500 employees who have only free Fabric licenses. The company doesn't want to buy individual Pro or Premium Per User licenses for these viewers. What is the smallest capacity that meets the requirement?
- A.F2
- B.F64
- C.F32
- D.F16
Show answer and explanation
Correct answer: B
From F64 upward, users with a free license can view Power BI content published to the capacity. On smaller F SKUs, every viewer needs a Pro or Premium Per User license.
F32, F16 and F2 all run Fabric workloads, but report viewers on them would each need a paid license, which the company wants to avoid.
From the lesson Plan and Configure the Analytics Environment.
Question 2
A certified semantic model lives in the Finance BI workspace. Thirty analysts in other departments must be able to create their own reports on this model. They must not edit the model or see the workspace's other items. What should you grant them?
- A.The Contributor role in the Finance BI workspace
- B.The Viewer role in the Finance BI workspace
- C.Write permission on the semantic model
- D.Build permission on the semantic model
Show answer and explanation
Correct answer: D
Build permission on a shared semantic model lets users create new reports on it (live connection), analyze it in Excel and query it, without changing the model and without joining the workspace.
Contributor lets them edit every item in the workspace. Viewer exposes the workspace's items and doesn't by itself let people create content there. Write permission would let them change the model itself.
From the lesson Workspace and Item Access, and Data Sharing.
Question 3
Analysts query a Fabric warehouse with T-SQL. They must be able to read every column of dbo.Employee except Salary, and a query that asks for Salary must fail rather than return disguised values. What should you implement?
- A.A OneLake security role on the warehouse's Files folder
- B.Column-level security: GRANT SELECT on dbo.Employee for every column except Salary
- C.A dynamic data mask on the Salary column
- D.A row-level security policy on dbo.Employee
Show answer and explanation
Correct answer: B
Column-level security grants SELECT only on the listed columns. A query that references Salary is denied, which is what the requirement asks for.
A mask still returns the column, just with disguised values, and users who can query can infer the real ones. Row-level security filters rows, not columns. OneLake security roles control lakehouse data read through OneLake and Spark, not T-SQL column access in a warehouse.
From the lesson Row-, Column-, Object- and File-Level Access Control.
Question 4
A semantic model has the protected sensitivity label Highly Confidential. A user with view access exports a table visual from a report on the model to Excel. What happens to the exported file?
- A.The export is always blocked when a model has a label.
- B.The file is exported without a label, because labels only apply inside Fabric.
- C.The file gets the organization's default label instead.
- D.The Excel file carries the Highly Confidential label and its protection.
Show answer and explanation
Correct answer: D
Sensitivity labels follow data when it's exported to supported file types such as Excel, PowerPoint and PDF. A protected label's encryption keeps applying outside Fabric.
Labels don't block exports by themselves (admins can restrict export through other settings or policies). The label isn't dropped at the Fabric boundary, which is the whole point of export protection, and the item's own label is used rather than a default one.
From the lesson Sensitivity Labels and Endorsement.
Question 5
Your BI team wants every change to measures and relationships in a Power BI model to be reviewed in Azure Repos pull requests, with a readable line-by-line diff. What should the developers do?
- A.Compare stages in a deployment pipeline before each deployment.
- B.Save their work as Power BI Desktop projects (.pbip), so the model is stored as TMDL text files, and commit those files.
- C.Commit the .pbix files to the repository.
- D.Export a .pbit template after each change and commit it.
Show answer and explanation
Correct answer: B
A .pbip project stores the model as TMDL text files and the report as PBIR files. Git shows exactly which measure or relationship changed, so reviewers can comment on it in a pull request.
A .pbix is a binary file, and Git can't show a meaningful diff for it. A .pbit is also a single packaged file. A deployment pipeline's compare view shows differences between stages after the fact; it isn't a review step in source control.
From the lesson Version Control and Power BI Desktop Projects (.pbip).