cert
cert-1
cert-2

Pass Microsoft DP-700 Exam in First Attempt Guaranteed!

Get 100% Latest Exam Questions, Accurate & Verified Answers to Pass the Actual Exam!
30 Days Free Updates, Instant Download!

cert-5
cert-6
DP-700 Exam - Verified By Experts
DP-700 Premium Bundle
$14.99

DP-700 Premium Bundle

$74.99
$89.98
  • Premium File 160 Questions & Answers. Last update: Nov 10, 2026
  • Training Course 160 Video Lectures
 
$89.98
$74.99
accept 159 downloads in last 7 days
block-screenshots
Purchase Microsoft DP-700 Exam Training Products Individually
Microsoft DP-700 Premium File
Premium File 160 Q&A
$76.99$69.99
Microsoft DP-700 Video Training Course
Training Course 160 Lectures
$21.99 $19.99
Microsoft DP-700 Practice Test 26

Question 250

An Eventhouse shortcut to a massive Delta table reports acceleration progress unknown. Which command provides diagnostic statistics?

  1. Optimize source Delta file layout and count where the owning system permits it.
  2. Update the external Delta table schema definition and re-evaluate its acceleration policy.
  3. Use the supported external-table query-acceleration statistics command for that table.
  4. Include applicable OneLake premium cache and indexing consumption in the cost model.

Explanation

Correct Answer

C:

Acceleration initialization and cache activity can be monitored explicitly rather than inferred from general query duration. Inspect cache state over time.

Incorrect Answers

A:

File count and metadata overhead still affect external scan and caching efficiency despite acceleration.

B:

External schema metadata must reflect source changes; incompatible schema changes can invalidate or restart acceleration.

D:

Acceleration uses cache capacity and may consume CUs for indexing; it is not a zero-cost equivalent of leaving the data uncached.

Question 251

A team asks whether query acceleration converts shortcut data into a fully native KQL table. What should the architect clarify?

  1. Treat it as accelerated external Delta access, not full native ingestion.
  2. Set a cache duration aligned with the intended recent-data query window.
  3. Optimize source Delta file layout and count where the owning system permits it.
  4. Include applicable OneLake premium cache and indexing consumption in the cost model.

Explanation

Correct Answer

A:

Caching improves shortcut query performance but keeps external-table feature limitations and source representation. Test the required native-only operation before design signoff.

Incorrect Answers

B:

Acceleration cost and cached volume depend on policy duration; retaining unused history is unnecessary.

C:

File count and metadata overhead still affect external scan and caching efficiency despite acceleration.

D:

Acceleration uses cache capacity and may consume CUs for indexing; it is not a zero-cost equivalent of leaving the data uncached.

Question 252

An accelerated Delta shortcut has too many tiny files and performance remains poor. What upstream property should be reviewed?

  1. Treat it as accelerated external Delta access, not full native ingestion.
  2. Include applicable OneLake premium cache and indexing consumption in the cost model.
  3. Optimize source Delta file layout and count where the owning system permits it.
  4. Use the supported external-table query-acceleration statistics command for that table.

Explanation

Correct Answer

C:

File count and metadata overhead still affect external scan and caching efficiency despite acceleration. Compare file statistics before and after source compaction.

Incorrect Answers

A:

Caching improves shortcut query performance but keeps external-table feature limitations and source representation.

B:

Acceleration uses cache capacity and may consume CUs for indexing; it is not a zero-cost equivalent of leaving the data uncached.

D:

Acceleration initialization and cache activity can be monitored explicitly rather than inferred from general query duration.

Question 253

An analyst expects accelerating a shortcut to eliminate all storage-related charges. What must be accounted for?

  1. Optimize source Delta file layout and count where the owning system permits it.
  2. Treat it as accelerated external Delta access, not full native ingestion.
  3. Include applicable OneLake premium cache and indexing consumption in the cost model.
  4. Configure query acceleration caching for the eligible external Delta table.

Explanation

Correct Answer

C:

Acceleration uses cache capacity and may consume CUs for indexing; it is not a zero-cost equivalent of leaving the data uncached. Review Eventhouse-related cache meter usage.

Incorrect Answers

A:

File count and metadata overhead still affect external scan and caching efficiency despite acceleration.

B:

Caching improves shortcut query performance but keeps external-table feature limitations and source representation.

D:

Query acceleration caches selected shortcut data for faster queries while leaving the source as an external reference.

Question 254

An Eventstream receives all device events but only critical alarms should reach the alert destination. Which operation should be inserted?

  1. Attach both supported Lakehouse and Eventhouse destinations to the appropriate streams.
  2. Create a derived stream from the transformations and attach both destinations.
  3. Apply a Filter transformation before the critical-alarm destination.
  4. Use a supported Manage Fields transformation to select and rename output fields.

Explanation

Correct Answer

C:

A filter restricts events using explicit conditions while preserving the upstream raw stream for other outputs. Publish normal and critical events to check routing.

Incorrect Answers

A:

An Eventstream can route event flows to multiple destinations for different consumption patterns.

B:

Derived streams expose a transformed event flow for reuse by multiple consumers.

D:

Field management shapes streaming events before delivery without changing the source producer.

Question 255

An event contains a nested field with an opaque name, and downstream consumers need a normalized output schema. Which operation can help?

  1. Create a derived stream from the transformations and attach both destinations.
  2. Use a supported Manage Fields transformation to select and rename output fields.
  3. Use a supported derived-field calculation before routing the transformed stream.
  4. Publish the modified Eventstream so destination changes take effect.

Explanation

Correct Answer

B:

Field management shapes streaming events before delivery without changing the source producer. Inspect the derived event schema.

Incorrect Answers

A:

Derived streams expose a transformed event flow for reuse by multiple consumers.

C:

Field derivation standardizes a value at stream-processing time while the raw default stream may remain available.

D:

Editing the stream canvas alone does not activate changes in the running eventstream.

Question 256

Two operations teams need the same cleaned stream for separate destinations. Which routing model reduces duplicate transformations?

  1. Create a derived stream from the transformations and attach both destinations.
  2. Use a supported derived-field calculation before routing the transformed stream.
  3. Apply a Filter transformation before the critical-alarm destination.
  4. Use a supported Manage Fields transformation to select and rename output fields.

Explanation

Correct Answer

A:

Derived streams expose a transformed event flow for reuse by multiple consumers. Verify both destinations receive the same transformed payload.

Incorrect Answers

B:

Field derivation standardizes a value at stream-processing time while the raw default stream may remain available.

C:

A filter restricts events using explicit conditions while preserving the upstream raw stream for other outputs.

D:

Field management shapes streaming events before delivery without changing the source producer.

Question 257

A published Eventstream keeps sending events to the old target after a destination change was made in edit mode. What is missing?

  1. Use a supported Manage Fields transformation to select and rename output fields.
  2. Use a supported derived-field calculation before routing the transformed stream.
  3. Publish the modified Eventstream so destination changes take effect.
  4. Attach both supported Lakehouse and Eventhouse destinations to the appropriate streams.

Explanation

Correct Answer

C:

Editing the stream canvas alone does not activate changes in the running eventstream. Check destination flow after publication.

Incorrect Answers

A:

Field management shapes streaming events before delivery without changing the source producer.

B:

Field derivation standardizes a value at stream-processing time while the raw default stream may remain available.

D:

An Eventstream can route event flows to multiple destinations for different consumption patterns.

Question 258

An Eventstream should archive raw events in a lakehouse while also sending live metrics to Eventhouse. How should it be configured?

  1. Publish the modified Eventstream so destination changes take effect.
  2. Use a supported Manage Fields transformation to select and rename output fields.
  3. Attach both supported Lakehouse and Eventhouse destinations to the appropriate streams.
  4. Apply a Filter transformation before the critical-alarm destination.

Explanation

Correct Answer

C:

An Eventstream can route event flows to multiple destinations for different consumption patterns. Reconcile test events at both targets.

Incorrect Answers

A:

Editing the stream canvas alone does not activate changes in the running eventstream.

B:

Field management shapes streaming events before delivery without changing the source producer.

D:

A filter restricts events using explicit conditions while preserving the upstream raw stream for other outputs.

Question 259

An event arrives with a Celsius reading but downstream dashboards require Fahrenheit. Which transformation fits?

  1. Create a derived stream from the transformations and attach both destinations.
  2. Publish the modified Eventstream so destination changes take effect.
  3. Use a supported derived-field calculation before routing the transformed stream.
  4. Attach both supported Lakehouse and Eventhouse destinations to the appropriate streams.

Explanation

Correct Answer

C:

Field derivation standardizes a value at stream-processing time while the raw default stream may remain available. Test a known temperature conversion.

Incorrect Answers

A:

Derived streams expose a transformed event flow for reuse by multiple consumers.

B:

Editing the stream canvas alone does not activate changes in the running eventstream.

D:

An Eventstream can route event flows to multiple destinations for different consumption patterns.

Question 260

A source is connected and a default stream appears automatically. What should the operator understand?

  1. Use a supported Manage Fields transformation to select and rename output fields.
  2. Publish the modified Eventstream so destination changes take effect.
  3. Apply a Filter transformation before the critical-alarm destination.
  4. Use the generated default stream as the raw event flow before any derived transformations.

Explanation

Correct Answer

D:

Every Eventstream source flow produces the default stream; a derived stream appears after supported operations are defined. Compare raw and transformed stream records.

Incorrect Answers

A:

Field management shapes streaming events before delivery without changing the source producer.

B:

Editing the stream canvas alone does not activate changes in the running eventstream.

C:

A filter restricts events using explicit conditions while preserving the upstream raw stream for other outputs.

Implementing Data Engineering Solutions Using Microsoft Fabric (DP-700) Practice Tests