A Fabric lakehouse table stores order dates as strings in the format 'YYYYMMDD'. The team needs to filter orders placed in the last 30 days. The date column is used in many queries. What should they do to enable efficient date filtering?

Use string comparisons with the 'YYYYMMDD' format.

Create a new calculated column that extracts the year, month, and day as separate integer columns.

Convert the string column to a date data type and use date comparisons in queries.

Leave the column as a string and use LIKE for date patterns.

A Fabric warehouse receives daily incremental updates from a source system. The updates include new records and changes to existing records. The team needs to apply these updates to a target table while preserving a full history of changes. The target table has a surrogate key and a natural business key. What is the best approach?

Use a stored procedure that inserts a new row for every change and marks the previous row as inactive.

Use an UPDATE statement that overwrites the existing row.

Use a DELETE and INSERT for each changed record.

Use a MERGE statement that updates the existing row and inserts a new row for changes.

Microsoft Certified:Fabric Analytics Engineer Associate

Domain 2Objective 2

Transform Data DP-600 Practice Questions (Page 8)

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 36–40

36application · medium
A Fabric lakehouse table stores order dates as strings in the format 'YYYYMMDD'. The team needs to filter orders placed in the last 30 days. The date column is used in many queries. What should they do to enable efficient date filtering?
Select an answer first
37foundation · easy
Which SQL statement is used to create a view in a Fabric warehouse?
Select an answer first
38foundation · easy
In PySpark, which method is used to perform aggregations like sum or average on a DataFrame?
Select an answer first
39expert · hard
A Fabric warehouse receives daily incremental updates from a source system. The updates include new records and changes to existing records. The team needs to apply these updates to a target table while preserving a full history of changes. The target table has a surrogate key and a natural business key. What is the best approach?
Select an answer first
40foundation · easy
What is the central table in a star schema that contains quantitative measures?
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.

Transform Data DP-600 Practice Questions (Page 8)

Questions 36–40

A Fabric lakehouse table stores order dates as strings in the format 'YYYYMMDD'. The team needs to filter orders placed in the last 30 days. The date column is used in many queries. What should they do to enable efficient date filtering?

Which SQL statement is used to create a view in a Fabric warehouse?

In PySpark, which method is used to perform aggregations like sum or average on a DataFrame?

What is the central table in a star schema that contains quantitative measures?

Keep studying — Prepare data