A manufacturing company needs to load a large historical dataset of sensor readings into a Fabric lakehouse for the first time. The data is in Parquet format and spans five years. The engineer must ensure the load completes quickly and the data is queryable. What should the engineer do?

Use a SQL endpoint to bulk load the Parquet files.

Use a Dataflow Gen2 to copy the Parquet files into the lakehouse.

Use a single Spark notebook to read all Parquet files and write to a delta table.

Load the Parquet files directly into the lakehouse without converting to delta.

When implementing a streaming load, what is the primary advantage of using a KQL database as the destination?

It is the only destination that supports streaming ingestion

It automatically creates Power BI dashboards

It is optimized for high-volume, time-series data ingestion and querying

It eliminates the need for data transformation

Microsoft Certified:Fabric Data Engineer Associate

Domain 2Objective 1

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

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 26–30

26foundation · easy
In a dimensional model, which table contains the descriptive attributes that provide context for measures?
Select an answer first
27foundation · easy
Which Fabric service is designed to ingest and process streaming data in real time?
Select an answer first
28application · medium
A manufacturing company needs to load a large historical dataset of sensor readings into a Fabric lakehouse for the first time. The data is in Parquet format and spans five years. The engineer must ensure the load completes quickly and the data is queryable. What should the engineer do?
Select an answer first
29foundation · easy
When implementing a streaming load, what is the primary advantage of using a KQL database as the destination?
Select an answer first
30foundation · easy
Which component is commonly used as the ingestion endpoint in a streaming data pattern?
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 6)

Questions 26–30

In a dimensional model, which table contains the descriptive attributes that provide context for measures?

Which Fabric service is designed to ingest and process streaming data in real time?

A manufacturing company needs to load a large historical dataset of sensor readings into a Fabric lakehouse for the first time. The data is in Parquet format and spans five years. The engineer must ensure the load completes quickly and the data is queryable. What should the engineer do?

When implementing a streaming load, what is the primary advantage of using a KQL database as the destination?

Which component is commonly used as the ingestion endpoint in a streaming data pattern?

Keep studying — Ingest and transform data