A financial services company wants to continuously replicate data from an Azure SQL Database into Fabric OneLake for near-real-time analytics. The analytics team needs to run T-SQL aggregations on the replicated data. The company wants to avoid building and maintaining custom pipelines. What should you configure?

Create a data pipeline with a Copy activity scheduled every 15 minutes.

Create a shortcut in OneLake pointing to the Azure SQL Database.

Use a Dataflow Gen2 to load data into a lakehouse on a schedule.

Set up Fabric mirrored database from Azure SQL Database to OneLake.

What is the primary goal of denormalizing data for a read-heavy workload?

To reduce the number of joins required during querying

Microsoft Certified:Fabric Data Engineer Associate

Domain 2Objective 2

Ingest and Transform Batch Data DP-700 Practice Questions (Page 5)

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 48 practice questions to prepare you well beyond it. (estimate)

48questions here

10free pages

13concepts

30–35%of the exam

Questions 21–25

21foundation · easy
Which KQL operator is used to filter rows based on a condition?
Select an answer first
22foundation · easy
Which PySpark DataFrame method is used to remove duplicate rows from a dataset?
Select an answer first
23application · medium
A financial services company wants to continuously replicate data from an Azure SQL Database into Fabric OneLake for near-real-time analytics. The analytics team needs to run T-SQL aggregations on the replicated data. The company wants to avoid building and maintaining custom pipelines. What should you configure?
Select an answer first
24foundation · easy
A batch ingestion pipeline must store raw CSV files that will be read by multiple analytics engines in Microsoft Fabric. Which data store should be selected to meet this requirement?
Select an answer first
25foundation · easy
What is the primary goal of denormalizing data for a read-heavy workload?
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.

Ingest and Transform Batch Data DP-700 Practice Questions (Page 5)

Questions 21–25

Which KQL operator is used to filter rows based on a condition?

Which PySpark DataFrame method is used to remove duplicate rows from a dataset?

A batch ingestion pipeline must store raw CSV files that will be read by multiple analytics engines in Microsoft Fabric. Which data store should be selected to meet this requirement?

What is the primary goal of denormalizing data for a read-heavy workload?

Keep studying — Ingest and transform data