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 20

Question 190

A warehouse query returns doubled sales totals after joining a one-to-many product tags table. What should be corrected?

  1. Aggregate or constrain the tag side to the intended grain before joining facts.
  2. Use a deterministic CTE or window ranking by transaction ID and keep the selected source version.
  3. Cast the operands to a suitable decimal type before division.
  4. Use a supported warehouse MERGE or equivalent transactional upsert keyed to the business identifier.

Explanation

Correct Answer

A:

One-to-many joins multiply fact rows and can inflate additive measures; the join grain must be fixed first. Compare prejoin and postjoin fact row counts.

Incorrect Answers

B:

Explicit ranking chooses the correct record; DISTINCT over all columns may not resolve conflicting versions of one key.

C:

Numeric type semantics affect precision; explicit decimal conversion preserves fractions where integer arithmetic would not.

D:

An upsert maintains one current logical row per key and handles both changed and new records.

Question 191

A query needs to distinguish null amounts from actual zero-value transactions. Which SQL practice is essential?

  1. Use GROUP BY over customer and fiscal-quarter keys with SUM of the revenue measure.
  2. Use a LEFT JOIN from facts to dimensions and inspect unmatched dimension keys.
  3. Keep NULL handling explicit and apply COALESCE only when the business rule treats missing as zero.
  4. Aggregate or constrain the tag side to the intended grain before joining facts.

Explanation

Correct Answer

C:

Replacing null with zero changes meaning and can mask incomplete source records. Check separate counts of null and zero amounts.

Incorrect Answers

A:

Grouped aggregate SQL reduces fact rows to the requested reporting grain.

B:

Left joins retain rows from the fact side while exposing missing matches, unlike an INNER JOIN that drops them.

D:

One-to-many joins multiply fact rows and can inflate additive measures; the join grain must be fixed first.

Question 192

A warehouse staging query must remove exact duplicate source transaction IDs before inserting. Which SQL approach helps?

  1. Use GROUP BY over customer and fiscal-quarter keys with SUM of the revenue measure.
  2. Use a deterministic CTE or window ranking by transaction ID and keep the selected source version.
  3. Use a supported warehouse MERGE or equivalent transactional upsert keyed to the business identifier.
  4. Use a LEFT JOIN from facts to dimensions and inspect unmatched dimension keys.

Explanation

Correct Answer

B:

Explicit ranking chooses the correct record; DISTINCT over all columns may not resolve conflicting versions of one key. Test duplicate IDs with different modification times.

Incorrect Answers

A:

Grouped aggregate SQL reduces fact rows to the requested reporting grain.

C:

An upsert maintains one current logical row per key and handles both changed and new records.

D:

Left joins retain rows from the fact side while exposing missing matches, unlike an INNER JOIN that drops them.

Question 193

A customer lakehouse needs to query Delta data already stored in another Fabric workspace without copying it. Which feature fits?

  1. Create an internal OneLake shortcut to the existing source table or folder.
  2. Update or recreate the shortcut so its target path points to the renamed source location.
  3. Copy or ingest the data into compliant storage rather than relying on a pointer to the remote location.
  4. Use the ADLS Gen2 DFS endpoint and valid container or folder path.

Explanation

Correct Answer

A:

Shortcuts reference existing data, avoiding duplicate storage and separate ingestion pipelines. Confirm the shortcut resolves to the intended source path.

Incorrect Answers

B:

A shortcut doesn't rewrite itself when the target moves; the referenced path must remain valid.

C:

A shortcut leaves bytes in the original source region; catalog visibility is not physical residency.

D:

ADLS Gen2 shortcuts require the DFS endpoint; an otherwise valid storage account name is not sufficient.

Question 194

A lakehouse must read files in an Amazon S3 bucket in place. What should be configured?

  1. Use the ADLS Gen2 DFS endpoint and valid container or folder path.
  2. Create a suitable Delta table shortcut under the lakehouse Tables area where table discovery is supported.
  3. Update or recreate the shortcut so its target path points to the renamed source location.
  4. Create an S3 shortcut with a permitted cloud connection and the intended bucket or prefix.

Explanation

Correct Answer

D:

An external S3 shortcut exposes source files without requiring a replicated copy into OneLake. Read a sample file and check source-side and OneLake permissions.

Incorrect Answers

A:

ADLS Gen2 shortcuts require the DFS endpoint; an otherwise valid storage account name is not sufficient.

B:

Files paths do not automatically register as SQL analytics tables, even when they contain Delta-format files.

C:

A shortcut doesn't rewrite itself when the target moves; the referenced path must remain valid.

Question 195

A shortcut was deleted, and the data owner fears the underlying external folder disappeared. What should they verify?

  1. Update or recreate the shortcut so its target path points to the renamed source location.
  2. Grant the calling identity read access to the internal shortcut target as needed.
  3. Use the ADLS Gen2 DFS endpoint and valid container or folder path.
  4. Check the original target independently; deleting a shortcut does not delete its target data.

Explanation

Correct Answer

D:

The shortcut is a pointer separate from source storage and can be removed without deleting external files. Open the target through its native storage interface.

Incorrect Answers

A:

A shortcut doesn't rewrite itself when the target moves; the referenced path must remain valid.

B:

Internal shortcuts generally evaluate the accessing user's source permissions instead of making source access universal.

C:

ADLS Gen2 shortcuts require the DFS endpoint; an otherwise valid storage account name is not sufficient.

Question 196

A shortcut in a lakehouse Files folder points to Delta files, but the analyst expects a discovered SQL table. What should be changed?

  1. Create a suitable Delta table shortcut under the lakehouse Tables area where table discovery is supported.
  2. Copy or ingest the data into compliant storage rather than relying on a pointer to the remote location.
  3. Update or recreate the shortcut so its target path points to the renamed source location.
  4. Grant the calling identity read access to the internal shortcut target as needed.

Explanation

Correct Answer

A:

Files paths do not automatically register as SQL analytics tables, even when they contain Delta-format files. Verify table discovery in the lakehouse SQL endpoint.

Incorrect Answers

B:

A shortcut leaves bytes in the original source region; catalog visibility is not physical residency.

C:

A shortcut doesn't rewrite itself when the target moves; the referenced path must remain valid.

D:

Internal shortcuts generally evaluate the accessing user's source permissions instead of making source access universal.

Question 197

A lakehouse shortcut to ADLS fails because its URL uses a blob endpoint for a hierarchical namespace source. Which endpoint should be configured?

  1. Copy or ingest the data into compliant storage rather than relying on a pointer to the remote location.
  2. Use the ADLS Gen2 DFS endpoint and valid container or folder path.
  3. Create an S3 shortcut with a permitted cloud connection and the intended bucket or prefix.
  4. Grant the calling identity read access to the internal shortcut target as needed.

Explanation

Correct Answer

B:

ADLS Gen2 shortcuts require the DFS endpoint; an otherwise valid storage account name is not sufficient. Test the target path and authorized connection.

Incorrect Answers

A:

A shortcut leaves bytes in the original source region; catalog visibility is not physical residency.

C:

An external S3 shortcut exposes source files without requiring a replicated copy into OneLake.

D:

Internal shortcuts generally evaluate the accessing user's source permissions instead of making source access universal.

Question 198

A shortcut stops working after an external folder is renamed. What should the engineer repair?

  1. Create a suitable Delta table shortcut under the lakehouse Tables area where table discovery is supported.
  2. Update or recreate the shortcut so its target path points to the renamed source location.
  3. Use the ADLS Gen2 DFS endpoint and valid container or folder path.
  4. Grant the calling identity read access to the internal shortcut target as needed.

Explanation

Correct Answer

B:

A shortcut doesn't rewrite itself when the target moves; the referenced path must remain valid. Resolve the shortcut and compare it with the new source path.

Incorrect Answers

A:

Files paths do not automatically register as SQL analytics tables, even when they contain Delta-format files.

C:

ADLS Gen2 shortcuts require the DFS endpoint; an otherwise valid storage account name is not sufficient.

D:

Internal shortcuts generally evaluate the accessing user's source permissions instead of making source access universal.

Question 199

A local Fabric lakehouse uses an internal shortcut but a user with access to the destination cannot read the source. What must be checked?

  1. Create a suitable Delta table shortcut under the lakehouse Tables area where table discovery is supported.
  2. Grant the calling identity read access to the internal shortcut target as needed.
  3. Create an S3 shortcut with a permitted cloud connection and the intended bucket or prefix.
  4. Copy or ingest the data into compliant storage rather than relying on a pointer to the remote location.

Explanation

Correct Answer

B:

Internal shortcuts generally evaluate the accessing user's source permissions instead of making source access universal. Test the target and shortcut with the same identity.

Incorrect Answers

A:

Files paths do not automatically register as SQL analytics tables, even when they contain Delta-format files.

C:

An external S3 shortcut exposes source files without requiring a replicated copy into OneLake.

D:

A shortcut leaves bytes in the original source region; catalog visibility is not physical residency.

Question 200

An architecture review requires physically relocating data to a particular compliance region. Why might a shortcut be unsuitable?

  1. Use the ADLS Gen2 DFS endpoint and valid container or folder path.
  2. Create an internal OneLake shortcut to the existing source table or folder.
  3. Copy or ingest the data into compliant storage rather than relying on a pointer to the remote location.
  4. Create a suitable Delta table shortcut under the lakehouse Tables area where table discovery is supported.

Explanation

Correct Answer

C:

A shortcut leaves bytes in the original source region; catalog visibility is not physical residency. Inspect the actual storage location after the migration.

Incorrect Answers

A:

ADLS Gen2 shortcuts require the DFS endpoint; an otherwise valid storage account name is not sufficient.

B:

Shortcuts reference existing data, avoiding duplicate storage and separate ingestion pipelines.

D:

Files paths do not automatically register as SQL analytics tables, even when they contain Delta-format files.

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