You are configuring a deployment pipeline for a solution that includes a lakehouse, a dataflow, and a semantic model. The dataflow uses an on-premises data gateway, and the semantic model depends on the dataflow. You need to ensure that the deployment to the test stage does not fail due to missing gateway credentials. What should you do?

Configure the gateway connection as a stage-level parameter in the deployment pipeline.

Deploy the semantic model first, then the dataflow.

Use the XMLA endpoint to bypass the gateway for the semantic model.

Disable the dataflow in the test stage and manually create a new one.

What is the purpose of a Power BI template (.pbit) file?

To encrypt the report for secure distribution

To provide a reusable starting point for reports with predefined visuals and data model

To store a snapshot of the data used in a report

To automatically refresh the dataset when opened

Which of the following tools can connect to a Power BI semantic model via the XMLA endpoint?

SQL Server Management Studio (SSMS)

What is the purpose of impact analysis in Microsoft Fabric?

To identify which downstream items might be affected by changes to a data source or semantic model

To optimize the storage of data in the lakehouse

To measure the performance of a semantic model

To automatically fix broken data connections

When you save a Power BI Desktop project (.pbip) to a local folder, what is stored in that folder?

A set of text files representing the report and semantic model definitions

A single .pbix file containing the entire report

A compressed archive of the underlying data

A database file that can be opened in SQL Server Management Studio

Microsoft Certified:Fabric Analytics Engineer Associate

Domain 1Objective 2

Maintain the Analytics Development Lifecycle DP-600 Practice Questions (Page 6)

Part of the Maintain a data analytics solution domain, which accounts for 25–30% of the DP-600 exam. Microsoft does not publish an official question count, but from its 100-minute exam (~40–65 total, ~10–20 in this domain), expect 5–10 from this objective — we provide 42 practice questions to prepare you well beyond it. (estimate)

42questions here

9free pages

8concepts

25–30%of the exam

Questions 26–30

26expert · hard
You are configuring a deployment pipeline for a solution that includes a lakehouse, a dataflow, and a semantic model. The dataflow uses an on-premises data gateway, and the semantic model depends on the dataflow. You need to ensure that the deployment to the test stage does not fail due to missing gateway credentials. What should you do?
Select an answer first
27foundation · easy
What is the purpose of a Power BI template (.pbit) file?
Select an answer first
28foundation · easy
Which of the following tools can connect to a Power BI semantic model via the XMLA endpoint?
Select an answer first
29foundation · easy
What is the purpose of impact analysis in Microsoft Fabric?
Select an answer first
30foundation · easy
When you save a Power BI Desktop project (.pbip) to a local folder, what is stored in that folder?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DP-600

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Microsoft. “DP-600” is a trademark of its owner, used for identification only.