In a Fabric lakehouse, what is the primary way to add a new table to an existing dataset?

Load data into a new table in the lakehouse using a Dataflow or Notebook

Add a column to an existing table and call it a new table

Create a view that references the new table

Use the 'New Table' button in Power BI Desktop

A Fabric warehouse currently has a fact table for online orders. The team needs to support analysis by customer demographics. The customer data exists in a separate operational database. What should the team do to enrich the warehouse model?

Ingest the customer data into a new dimension table in the warehouse and create a relationship to the fact table.

Add customer attributes as new columns directly to the fact table.

Create a stored procedure that queries the operational database on demand.

Create a view that joins the fact table to the operational customer table directly.

A Fabric lakehouse contains a Customer table with a column named Status that can have values 'Active', 'Inactive', or NULL. You need to create a dataset that includes only customers who are not explicitly marked as 'Inactive'. Which filter condition should you use?

Status IS NULL OR Status = 'Active'

Status IS NOT NULL AND Status <> 'Inactive'

In a Fabric warehouse, what is the primary purpose of creating a view?

To automatically refresh data from source systems on a schedule

To encapsulate a query as a virtual table that can be referenced like a table

To store a physical copy of the query results for faster access

To enforce data integrity constraints on the underlying tables

Microsoft Certified:Fabric Analytics Engineer Associate

Domain 2Objective 2

Transform Data DP-600 Practice Questions (Page 2)

Part of the Prepare data domain, which accounts for 45–50% of the DP-600 exam. Microsoft does not publish an official question count, but from its 100-minute exam (~40–65 total, ~18–33 in this domain), expect 6–11 from this objective — we provide 59 practice questions to prepare you well beyond it. (estimate)

59questions here

12free pages

15concepts

45–50%of the exam

Questions 6–10

6foundation · easy
In a Fabric lakehouse, what is the primary way to add a new table to an existing dataset?
Select an answer first
7application · medium
A Fabric warehouse currently has a fact table for online orders. The team needs to support analysis by customer demographics. The customer data exists in a separate operational database. What should the team do to enrich the warehouse model?
Select an answer first
8foundation · easy
In Power Query, which step is used to keep only rows that meet a condition?
Select an answer first
9application · medium
A Fabric lakehouse contains a Customer table with a column named Status that can have values 'Active', 'Inactive', or NULL. You need to create a dataset that includes only customers who are not explicitly marked as 'Inactive'. Which filter condition should you use?
Select an answer first
10foundation · easy
In a Fabric warehouse, what is the primary purpose of creating a view?
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.