DP-600 MICROSOFT FABRIC
ANALYTICS ENGINEER ASSOCIATE
2026/2027 | 120 VERIFIED PRACTICE
QUESTIONS WITH ANSWERS &
DETAILED RATIONALES | FABRIC
ANALYTICS ENGINEER EXAM PREP
Domain 1: Maintain a Data Analytics Solution (25–30%)
1. A workspace admin wants to prevent a specific Contributor from opening a
single warehouse in an otherwise shared workspace. What should they
configure?
A) Change the user's workspace role to Viewer for everyone
B) A sensitivity label on the workspace
C) Row-level security on the warehouse's tables
D) Item-level access control on that specific warehouse
Correct: D. Rationale: Item-level access control restricts access to one specific item
without altering the user's broader workspace role or affecting other items.
Downgrading the workspace role (A) affects everything, while RLS (C) filters rows, not
item access.
2. Which feature allows a Fabric workspace to enforce version control for Power
BI items such as reports and semantic models?
A) Deployment pipelines
B) Git integration
C) XMLA endpoint
D) OneLake shortcuts
Correct: B. Rationale: Git integration connects a workspace to an Azure DevOps
repository, enabling version control, branching, and collaboration on Power BI items
(.pbip, .pbit, etc.). Deployment pipelines (A) handle promotion across stages, not source
control.
3. A team needs to deploy semantic models from a development workspace to
a test workspace and then to production. Which Fabric feature should they use?
A) Git integration
,B) Deployment pipelines
C) Power BI template files (.pbit)
D) XMLA endpoint scripting
Correct: B. Rationale: Deployment pipelines provide a structured, stage-based
promotion process (Development → Test → Production) for Fabric items, including
semantic models, reports, and dataflows.
4. An administrator must apply a sensitivity label to a lakehouse so that
downstream reports inherit the same classification. What should they do?
A) Apply the label directly to each report
B) Apply the label to the workspace
C) Apply the label to the lakehouse item
D) Use row-level security on the lakehouse
Correct: C. Rationale: Sensitivity labels applied to Fabric items (such as lakehouses or
semantic models) can propagate to downstream items, helping maintain consistent
data protection. Applying labels individually to reports (A) is manual and error-prone.
5. Which artifact enables impact analysis when a lakehouse table schema
changes?
A) Deployment pipelines
B) Lineage view in the workspace
C) Git history
D) XMLA endpoint
Correct: B. Rationale: The lineage view visualizes dependencies between Fabric items
(lakehouses, dataflows, semantic models, reports), allowing engineers to identify
downstream effects of schema changes.
6. A company wants to reuse a standardized semantic model across multiple
reports without duplicating the model. What should they create?
A) A Power BI template (.pbit)
B) A shared semantic model
C) A dataflow Gen2
D) A lakehouse shortcut
Correct: B. Rationale: A shared semantic model (also known as a shared dataset) allows
multiple reports to connect to the same model, ensuring consistency and reducing
duplication.
7. What is the primary purpose of the XMLA endpoint in Microsoft Fabric?
A) To ingest streaming data
B) To deploy and manage semantic models programmatically
C) To create OneLake shortcuts
D) To run Spark notebooks
Correct: B. Rationale: The XMLA endpoint enables tools like Tabular Editor, SQL Server
, Management Studio, and PowerShell scripts to deploy, manage, and refresh semantic
models.
8. Which Power BI file format supports source control integration in Fabric?
A) .pbix
B) .pbit
C) .pbip
D) .rdl
Correct: C. Rationale: Power BI Desktop projects (.pbip) store report and model
definitions as text-based files, making them suitable for Git version control.
9. A governance team wants to mark a certified semantic model so that
business users can trust its quality. What should they use?
A) Sensitivity labels
B) Endorsement (Promotion or Certification)
C) Row-level security
D) Deployment pipelines
Correct: B. Rationale: Fabric supports endorsement through Promotion and
Certification, signaling to users that an item meets organizational quality standards.
10. Which security feature allows filtering rows in a semantic model based on
the identity of the user viewing a report?
A) Column-level security
B) Row-level security (RLS)
C) Object-level security
D) File-level security
Correct: B. Rationale: RLS restricts data access at the row level by applying DAX filter
expressions based on user identity or group membership.
11. What is the recommended way to manage reusable Power BI assets such as
data source files (.pbids) across a team?
A) Store them in a personal OneDrive folder
B) Share them via email attachments
C) Store them in a Git repository integrated with the Fabric workspace
D) Recreate them manually for each project
Correct: C. Rationale: Git integration allows teams to version, share, and reuse asset
files consistently across projects.
12. A workspace uses deployment pipelines. What happens to the semantic
model when it is promoted from Development to Test?
A) The model is copied, and the copy in Test is independent of Development
B) The model is moved, and Development no longer contains it
C) The model is synchronized, and both stages point to the same underlying model
D) The model is deleted from Development after promotion
ANALYTICS ENGINEER ASSOCIATE
2026/2027 | 120 VERIFIED PRACTICE
QUESTIONS WITH ANSWERS &
DETAILED RATIONALES | FABRIC
ANALYTICS ENGINEER EXAM PREP
Domain 1: Maintain a Data Analytics Solution (25–30%)
1. A workspace admin wants to prevent a specific Contributor from opening a
single warehouse in an otherwise shared workspace. What should they
configure?
A) Change the user's workspace role to Viewer for everyone
B) A sensitivity label on the workspace
C) Row-level security on the warehouse's tables
D) Item-level access control on that specific warehouse
Correct: D. Rationale: Item-level access control restricts access to one specific item
without altering the user's broader workspace role or affecting other items.
Downgrading the workspace role (A) affects everything, while RLS (C) filters rows, not
item access.
2. Which feature allows a Fabric workspace to enforce version control for Power
BI items such as reports and semantic models?
A) Deployment pipelines
B) Git integration
C) XMLA endpoint
D) OneLake shortcuts
Correct: B. Rationale: Git integration connects a workspace to an Azure DevOps
repository, enabling version control, branching, and collaboration on Power BI items
(.pbip, .pbit, etc.). Deployment pipelines (A) handle promotion across stages, not source
control.
3. A team needs to deploy semantic models from a development workspace to
a test workspace and then to production. Which Fabric feature should they use?
A) Git integration
,B) Deployment pipelines
C) Power BI template files (.pbit)
D) XMLA endpoint scripting
Correct: B. Rationale: Deployment pipelines provide a structured, stage-based
promotion process (Development → Test → Production) for Fabric items, including
semantic models, reports, and dataflows.
4. An administrator must apply a sensitivity label to a lakehouse so that
downstream reports inherit the same classification. What should they do?
A) Apply the label directly to each report
B) Apply the label to the workspace
C) Apply the label to the lakehouse item
D) Use row-level security on the lakehouse
Correct: C. Rationale: Sensitivity labels applied to Fabric items (such as lakehouses or
semantic models) can propagate to downstream items, helping maintain consistent
data protection. Applying labels individually to reports (A) is manual and error-prone.
5. Which artifact enables impact analysis when a lakehouse table schema
changes?
A) Deployment pipelines
B) Lineage view in the workspace
C) Git history
D) XMLA endpoint
Correct: B. Rationale: The lineage view visualizes dependencies between Fabric items
(lakehouses, dataflows, semantic models, reports), allowing engineers to identify
downstream effects of schema changes.
6. A company wants to reuse a standardized semantic model across multiple
reports without duplicating the model. What should they create?
A) A Power BI template (.pbit)
B) A shared semantic model
C) A dataflow Gen2
D) A lakehouse shortcut
Correct: B. Rationale: A shared semantic model (also known as a shared dataset) allows
multiple reports to connect to the same model, ensuring consistency and reducing
duplication.
7. What is the primary purpose of the XMLA endpoint in Microsoft Fabric?
A) To ingest streaming data
B) To deploy and manage semantic models programmatically
C) To create OneLake shortcuts
D) To run Spark notebooks
Correct: B. Rationale: The XMLA endpoint enables tools like Tabular Editor, SQL Server
, Management Studio, and PowerShell scripts to deploy, manage, and refresh semantic
models.
8. Which Power BI file format supports source control integration in Fabric?
A) .pbix
B) .pbit
C) .pbip
D) .rdl
Correct: C. Rationale: Power BI Desktop projects (.pbip) store report and model
definitions as text-based files, making them suitable for Git version control.
9. A governance team wants to mark a certified semantic model so that
business users can trust its quality. What should they use?
A) Sensitivity labels
B) Endorsement (Promotion or Certification)
C) Row-level security
D) Deployment pipelines
Correct: B. Rationale: Fabric supports endorsement through Promotion and
Certification, signaling to users that an item meets organizational quality standards.
10. Which security feature allows filtering rows in a semantic model based on
the identity of the user viewing a report?
A) Column-level security
B) Row-level security (RLS)
C) Object-level security
D) File-level security
Correct: B. Rationale: RLS restricts data access at the row level by applying DAX filter
expressions based on user identity or group membership.
11. What is the recommended way to manage reusable Power BI assets such as
data source files (.pbids) across a team?
A) Store them in a personal OneDrive folder
B) Share them via email attachments
C) Store them in a Git repository integrated with the Fabric workspace
D) Recreate them manually for each project
Correct: C. Rationale: Git integration allows teams to version, share, and reuse asset
files consistently across projects.
12. A workspace uses deployment pipelines. What happens to the semantic
model when it is promoted from Development to Test?
A) The model is copied, and the copy in Test is independent of Development
B) The model is moved, and Development no longer contains it
C) The model is synchronized, and both stages point to the same underlying model
D) The model is deleted from Development after promotion
