A data engineer needs to query data that resides in an external Azure Data Lake Storage Gen2 account from a KQL database in Real-Time Intelligence. Which option should the engineer use?

Use a dataflow to import the data into the KQL database.

Create a OneLake shortcut to the external storage location.

Use a Spark notebook to query the external data directly.

Create a native table and copy the data into it.

A healthcare organization has an existing delta table in a lakehouse that is updated by a nightly batch job. They want to make this data queryable in a KQL database for ad-hoc analysis, but the data is not frequently accessed and query performance is not critical. What should you do?

Copy the delta table into a native table in the KQL database.

Create a OneLake shortcut with query acceleration enabled.

Create a standard OneLake shortcut in the KQL database pointing to the delta table.

Use Spark to read the delta table and write the results to a KQL database on demand.

A network monitoring team needs to identify servers that have not sent a heartbeat in the last 5 minutes. Heartbeats are stored in a KQL database. Which KQL query should they use?

Heartbeats | summarize LastBeat = max(TimeGenerated) by Server | where LastBeat < ago(5m)

Heartbeats | summarize count() by Server | where count() == 0

Heartbeats | where TimeGenerated < ago(5m) | distinct Server

Heartbeats | where TimeGenerated > ago(5m) | distinct Server

What is the primary purpose of an Eventstream in Microsoft Fabric?

To manage user access to Fabric workspaces.

To create data visualizations for real-time dashboards.

To store historical data for batch analytics.

To capture, transform, and route real-time events to various destinations.

Microsoft Certified:Fabric Data Engineer Associate

Domain 2Objective 3

Ingest and Transform Streaming Data DP-700 Practice Questions (Page 3)

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

25questions here

5free pages

7concepts

30–35%of the exam

Questions 11–15

11foundation · easy
A data engineer needs to query data that resides in an external Azure Data Lake Storage Gen2 account from a KQL database in Real-Time Intelligence. Which option should the engineer use?
Select an answer first
12foundation · easy
Which of the following is a common destination for an Eventstream in Microsoft Fabric?
Select an answer first
13application · medium
A healthcare organization has an existing delta table in a lakehouse that is updated by a nightly batch job. They want to make this data queryable in a KQL database for ad-hoc analysis, but the data is not frequently accessed and query performance is not critical. What should you do?
Select an answer first
14application · medium
A network monitoring team needs to identify servers that have not sent a heartbeat in the last 5 minutes. Heartbeats are stored in a KQL database. Which KQL query should they use?
Select an answer first
15foundation · easy
What is the primary purpose of an Eventstream in Microsoft Fabric?
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.