A multinational retailer operates in multiple time zones and loads sales data from each region into a central Fabric warehouse. Each region provides a nightly export with a local timestamp. The warehouse must have a consistent global time zone for reporting. The team also needs to handle late-arriving data from the previous day. What should you implement?

Use a mapping table to convert local timestamps to UTC during the load and use a watermark that accounts for late-arriving data by using the load time.

Use a single scheduled load that runs at midnight UTC and loads all regions' data from the previous day.

Load each region's data with its local timestamp and convert to UTC during reporting queries.

Load all data as-is and rely on the reporting layer to handle time zone conversions.

Which scenario is the best fit for a full data load pattern?

Updating only the rows that changed since the last load

Loading a small dimension table that replaces its contents nightly

Appending millions of new sales transactions every hour

Ingesting sensor readings continuously from IoT devices

Microsoft Certified:Fabric Data Engineer Associate

Domain 2Objective 1

Design and Implement Loading Patterns DP-700 Practice Questions (Page 1)

Part of the Ingest and transform data domain, which accounts for 30–35% of the DP-700 exam. Microsoft does not publish an official question count, but from its 100-minute exam (~40–65 total, ~12–23 in this domain), expect 4–8 from this objective — we provide 35 practice questions to prepare you well beyond it. (estimate)

35questions here

7free pages

7concepts

30–35%of the exam

Questions 1–5

1expert · hard
A multinational retailer operates in multiple time zones and loads sales data from each region into a central Fabric warehouse. Each region provides a nightly export with a local timestamp. The warehouse must have a consistent global time zone for reporting. The team also needs to handle late-arriving data from the previous day. What should you implement?
Select an answer first
2foundation · easy
Which Fabric feature allows you to create a live stream that can be consumed by multiple destinations without writing custom code?
Select an answer first
3foundation · easy
Which scenario is the best fit for a full data load pattern?
Select an answer first
4foundation · easy
A data engineer needs to load the complete contents of a source table into a Fabric warehouse every night. Which loading pattern does this describe?
Select an answer first
5foundation · easy
A data engineer wants to load only the rows that were inserted or updated since the previous load. Which loading pattern should be used?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DP-700

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-700” is a trademark of its owner, used for identification only.

Design and Implement Loading Patterns DP-700 Practice Questions (Page 1)

Questions 1–5

Which Fabric feature allows you to create a live stream that can be consumed by multiple destinations without writing custom code?

Which scenario is the best fit for a full data load pattern?

A data engineer needs to load the complete contents of a source table into a Fabric warehouse every night. Which loading pattern does this describe?

A data engineer wants to load only the rows that were inserted or updated since the previous load. Which loading pattern should be used?

Keep studying — Ingest and transform data