Practice Exams:

Microsoft DP-900 Dumps

EXAM: Microsoft Azure Data Fundamentals
Verified By Experts
Premium Bundle
$40.00
$59.97 $99.97

DP-900 Premium Bundle


  • Premium File 332 Questions & Answers
  • Training Course 32 Lectures
  • Study Guide 672 Pages

Microsoft DP-900 Practice Test 81

Question 800

At Oakbridge Services service tickets update frequently but old cases rarely change. Which shortcut most directly threatens the intended data outcome?

  1. Reappend the entire transaction history each hour with no deduplication.
  2. Connect unrelated tables by matching display names that are not stable unique keys.
  3. Route emergency alerts through a slow end-of-day ETL job.
  4. Schedule a single weekly batch while promising a dashboard accurate every ten minutes.

Answer & Explanations

Correct answer: A

A.

Reappend the entire transaction history each hour with no deduplication. The scenario is: At Oakbridge Services service tickets update frequently but old cases rarely change. This undermines the mechanism: Incremental loads process changed records instead of copying all historical data on each run. Instead: Build an incremental ingestion path based on reliable watermarks or source change tracking.

B.

Connect unrelated tables by matching display names that are not stable unique keys. This concerns another issue: At Harborfield Commerce sales facts reference a product dimension. In the stated case—At Oakbridge Services service tickets update frequently but old cases rarely change—reject: Reappend the entire transaction history each hour with no deduplication. The safer response is: Build an incremental ingestion path based on reliable watermarks or source change tracking.

C.

Route emergency alerts through a slow end-of-day ETL job. This concerns another issue: At Pineport Healthcare medical equipment signals abnormal temperatures. In the stated case—At Oakbridge Services service tickets update frequently but old cases rarely change—reject: Reappend the entire transaction history each hour with no deduplication. The safer response is: Build an incremental ingestion path based on reliable watermarks or source change tracking.

D.

Schedule a single weekly batch while promising a dashboard accurate every ten minutes. This concerns another issue: At Harborland Retail nightly inventory analytics satisfy finance but not emergency stock alerts. In the stated case—At Oakbridge Services service tickets update frequently but old cases rarely change—reject: Reappend the entire transaction history each hour with no deduplication. The safer response is: Build an incremental ingestion path based on reliable watermarks or source change tracking.

Question 801

At Meadowfield Retail some supplier feeds contain negative quantities. Which design or Azure data approach best fits this requirement?

  1. Add validation and a quarantine destination for records failing an agreed data quality rule.
  2. Distinguish continuous streaming ingestion from scheduled batch imports by how promptly records must be processed.
  3. Use a DAX measure for a filter-context-dependent aggregate rather than storing the same changing total in every fact row.
  4. Select appropriate batch processing windows and compute scale based on data freshness requirements and job cost.

Answer & Explanations

Correct answer: A

A.

Add validation and a quarantine destination for records failing an agreed data quality rule. This works because: Separating bad records protects curated datasets while retaining evidence for correction and replay. The scenario is: At Meadowfield Retail some supplier feeds contain negative quantities. Verify the outcome by: Send one valid and one invalid synthetic record and confirm only the valid record reaches the curated table.

B.

Distinguish continuous streaming ingestion from scheduled batch imports by how promptly records must be processed. This addresses a different situation: At Cedarpoint Manufacturing equipment overheating requires prompt detection. The present case is: At Meadowfield Retail some supplier feeds contain negative quantities. The relevant action here is: Add validation and a quarantine destination for records failing an agreed data quality rule.

C.

Use a DAX measure for a filter-context-dependent aggregate rather than storing the same changing total in every fact row. This addresses a different situation: At Silverlake Services managers compare revenue by selected region. The present case is: At Meadowfield Retail some supplier feeds contain negative quantities. The relevant action here is: Add validation and a quarantine destination for records failing an agreed data quality rule.

D.

Select appropriate batch processing windows and compute scale based on data freshness requirements and job cost. This addresses a different situation: At Harborland Retail nightly inventory analytics satisfy finance but not emergency stock alerts. The present case is: At Meadowfield Retail some supplier feeds contain negative quantities. The relevant action here is: Add validation and a quarantine destination for records failing an agreed data quality rule.

Question 802

At Meadowfield Retail some supplier feeds contain negative quantities. The team proposes this approach: Add validation and a quarantine destination for records failing an agreed data quality rule. Which technical principle explains the choice?

  1. Import caches data in the Power BI model and requires refresh to reflect changed source rows.
  2. Windowed streaming computations aggregate events over bounded time intervals as new data arrives.
  3. Separating bad records protects curated datasets while retaining evidence for correction and replay.
  4. Fact tables hold numeric events while dimensions describe dates, products and customers used to filter or group them.

Answer & Explanations

Correct answer: C

A.

Import caches data in the Power BI model and requires refresh to reflect changed source rows. That explains a separate situation: At Pinecrest Finance a morning report refresh is sufficient for yesterday's closing totals. The current case is: At Meadowfield Retail some supplier feeds contain negative quantities. The actual mechanism is: Separating bad records protects curated datasets while retaining evidence for correction and replay.

B.

Windowed streaming computations aggregate events over bounded time intervals as new data arrives. That explains a separate situation: At Meadowview Commerce payment anomalies are monitored in rolling five-minute windows. The current case is: At Meadowfield Retail some supplier feeds contain negative quantities. The actual mechanism is: Separating bad records protects curated datasets while retaining evidence for correction and replay.

C.

Separating bad records protects curated datasets while retaining evidence for correction and replay. This principle supports the intervention: Add validation and a quarantine destination for records failing an agreed data quality rule. The relevant scenario is: At Meadowfield Retail some supplier feeds contain negative quantities. Verify the result by: Send one valid and one invalid synthetic record and confirm only the valid record reaches the curated table.

D.

Fact tables hold numeric events while dimensions describe dates, products and customers used to filter or group them. That explains a separate situation: At Pinecrest Retail product-category reporting relies on many transactions. The current case is: At Meadowfield Retail some supplier feeds contain negative quantities. The actual mechanism is: Separating bad records protects curated datasets while retaining evidence for correction and replay.

Question 803

At Meadowfield Retail some supplier feeds contain negative quantities. After implementing this approach—Add validation and a quarantine destination for records failing an agreed data quality rule—which result would most directly confirm success?

  1. Load fictional sales and finance facts and verify both reports share a consistent date dimension.
  2. Send one valid and one invalid synthetic record and confirm only the valid record reaches the curated table.
  3. Update a synthetic source record and verify the report reflects it after a configured refresh.
  4. Replay a fictional event with the same ID and confirm the sink counts it only once.

Answer & Explanations

Correct answer: B

A.

Load fictional sales and finance facts and verify both reports share a consistent date dimension. This tests a separate situation: At Silvercrest Commerce executives compare sales performance across regions. The observed case is: At Meadowfield Retail some supplier feeds contain negative quantities. Use this acceptance check instead: Send one valid and one invalid synthetic record and confirm only the valid record reaches the curated table.

B.

Send one valid and one invalid synthetic record and confirm only the valid record reaches the curated table. This tests the targeted action: Add validation and a quarantine destination for records failing an agreed data quality rule. The reason is: Separating bad records protects curated datasets while retaining evidence for correction and replay. The reported case is: At Meadowfield Retail some supplier feeds contain negative quantities.

C.

Update a synthetic source record and verify the report reflects it after a configured refresh. This tests a separate situation: At Pinecrest Finance a morning report refresh is sufficient for yesterday's closing totals. The observed case is: At Meadowfield Retail some supplier feeds contain negative quantities. Use this acceptance check instead: Send one valid and one invalid synthetic record and confirm only the valid record reaches the curated table.

D.

Replay a fictional event with the same ID and confirm the sink counts it only once. This tests a separate situation: At Silverpoint Banking an event publisher retries after a brief timeout. The observed case is: At Meadowfield Retail some supplier feeds contain negative quantities. Use this acceptance check instead: Send one valid and one invalid synthetic record and confirm only the valid record reaches the curated table.

Question 804

At Meadowfield Retail some supplier feeds contain negative quantities. Which shortcut most directly threatens the intended data outcome?

  1. Silently drop errors while still reporting the source batch as complete.
  2. Have every department calculate quarterly revenue from unrelated raw CSV files with different definitions.
  3. Use a pie chart to prove one numeric factor causes another.
  4. Route emergency alerts through a slow end-of-day ETL job.

Answer & Explanations

Correct answer: A

A.

Silently drop errors while still reporting the source batch as complete. The scenario is: At Meadowfield Retail some supplier feeds contain negative quantities. This undermines the mechanism: Separating bad records protects curated datasets while retaining evidence for correction and replay. Instead: Add validation and a quarantine destination for records failing an agreed data quality rule.

B.

Have every department calculate quarterly revenue from unrelated raw CSV files with different definitions. This concerns another issue: At Silvercrest Commerce executives compare sales performance across regions. In the stated case—At Meadowfield Retail some supplier feeds contain negative quantities—reject: Silently drop errors while still reporting the source batch as complete. The safer response is: Add validation and a quarantine destination for records failing an agreed data quality rule.

C.

Use a pie chart to prove one numeric factor causes another. This concerns another issue: At Pinewood Retail analysts compare campaign spend with customer acquisitions. In the stated case—At Meadowfield Retail some supplier feeds contain negative quantities—reject: Silently drop errors while still reporting the source batch as complete. The safer response is: Add validation and a quarantine destination for records failing an agreed data quality rule.

D.

Route emergency alerts through a slow end-of-day ETL job. This concerns another issue: At Pineport Healthcare medical equipment signals abnormal temperatures. In the stated case—At Meadowfield Retail some supplier feeds contain negative quantities—reject: Silently drop errors while still reporting the source batch as complete. The safer response is: Add validation and a quarantine destination for records failing an agreed data quality rule.

Question 805

At Harborcrest Research instrument exports occasionally omit required identifiers. Which design or Azure data approach best fits this requirement?

  1. Use ELT when raw records can first land in a scalable analytical store and transformations run there.
  2. Use a DAX measure for a filter-context-dependent aggregate rather than storing the same changing total in every fact row.
  3. Distinguish continuous streaming ingestion from scheduled batch imports by how promptly records must be processed.
  4. Add validation and a quarantine destination for records failing an agreed data quality rule.

Answer & Explanations

Correct answer: D

A.

Use ELT when raw records can first land in a scalable analytical store and transformations run there. This addresses a different situation: At Meadowview Retail a cloud warehouse performs its own SQL cleaning after ingestion. The present case is: At Harborcrest Research instrument exports occasionally omit required identifiers. The relevant action here is: Add validation and a quarantine destination for records failing an agreed data quality rule.

B.

Use a DAX measure for a filter-context-dependent aggregate rather than storing the same changing total in every fact row. This addresses a different situation: At Silverlake Services managers compare revenue by selected region. The present case is: At Harborcrest Research instrument exports occasionally omit required identifiers. The relevant action here is: Add validation and a quarantine destination for records failing an agreed data quality rule.

C.

Distinguish continuous streaming ingestion from scheduled batch imports by how promptly records must be processed. This addresses a different situation: At Cedarpoint Manufacturing equipment overheating requires prompt detection. The present case is: At Harborcrest Research instrument exports occasionally omit required identifiers. The relevant action here is: Add validation and a quarantine destination for records failing an agreed data quality rule.

D.

Add validation and a quarantine destination for records failing an agreed data quality rule. This works because: Separating bad records protects curated datasets while retaining evidence for correction and replay. The scenario is: At Harborcrest Research instrument exports occasionally omit required identifiers. Verify the outcome by: Send one valid and one invalid synthetic record and confirm only the valid record reaches the curated table.

Question 806

At Harborcrest Research instrument exports occasionally omit required identifiers. The team proposes this approach: Add validation and a quarantine destination for records failing an agreed data quality rule. Which technical principle explains the choice?

  1. Model relationships propagate filter context between related tables according to direction and cardinality.
  2. OneLake provides shared storage for Fabric experiences, while workspace and item permissions still govern access.
  3. Separating bad records protects curated datasets while retaining evidence for correction and replay.
  4. A bounded event retention period permits eligible consumers to resume from offsets without requiring the producer to resend immediately.

Answer & Explanations

Correct answer: C

A.

Model relationships propagate filter context between related tables according to direction and cardinality. That explains a separate situation: At Harborfield Commerce sales facts reference a product dimension. The current case is: At Harborcrest Research instrument exports occasionally omit required identifiers. The actual mechanism is: Separating bad records protects curated datasets while retaining evidence for correction and replay.

B.

OneLake provides shared storage for Fabric experiences, while workspace and item permissions still govern access. That explains a separate situation: At Meadowbank Insurance several Fabric teams need a centrally governed analytical foundation. The current case is: At Harborcrest Research instrument exports occasionally omit required identifiers. The actual mechanism is: Separating bad records protects curated datasets while retaining evidence for correction and replay.

C.

Separating bad records protects curated datasets while retaining evidence for correction and replay. This principle supports the intervention: Add validation and a quarantine destination for records failing an agreed data quality rule. The relevant scenario is: At Harborcrest Research instrument exports occasionally omit required identifiers. Verify the result by: Send one valid and one invalid synthetic record and confirm only the valid record reaches the curated table.

D.

A bounded event retention period permits eligible consumers to resume from offsets without requiring the producer to resend immediately. That explains a separate situation: At Harborcrest Logistics a tracking processor is offline during a deployment. The current case is: At Harborcrest Research instrument exports occasionally omit required identifiers. The actual mechanism is: Separating bad records protects curated datasets while retaining evidence for correction and replay.

Question 807

At Harborcrest Research instrument exports occasionally omit required identifiers. After implementing this approach—Add validation and a quarantine destination for records failing an agreed data quality rule—which result would most directly confirm success?

  1. Send one valid and one invalid synthetic record and confirm only the valid record reaches the curated table.
  2. Test two fictional regional managers and confirm each can query only their permitted region.
  3. Build a small sales fact table and product dimension then verify a category-filtered revenue total.
  4. Publish synthetic events, consume them through a test consumer group and verify offsets advance.

Answer & Explanations

Correct answer: A

A.

Send one valid and one invalid synthetic record and confirm only the valid record reaches the curated table. This tests the targeted action: Add validation and a quarantine destination for records failing an agreed data quality rule. The reason is: Separating bad records protects curated datasets while retaining evidence for correction and replay. The reported case is: At Harborcrest Research instrument exports occasionally omit required identifiers.

B.

Test two fictional regional managers and confirm each can query only their permitted region. This tests a separate situation: At Cedarcrest Finance regional managers should see only their branch transactions. The observed case is: At Harborcrest Research instrument exports occasionally omit required identifiers. Use this acceptance check instead: Send one valid and one invalid synthetic record and confirm only the valid record reaches the curated table.

C.

Build a small sales fact table and product dimension then verify a category-filtered revenue total. This tests a separate situation: At Pinecrest Retail product-category reporting relies on many transactions. The observed case is: At Harborcrest Research instrument exports occasionally omit required identifiers. Use this acceptance check instead: Send one valid and one invalid synthetic record and confirm only the valid record reaches the curated table.

D.

Publish synthetic events, consume them through a test consumer group and verify offsets advance. This tests a separate situation: At Harborcrest Transport thousands of vehicles emit location updates. The observed case is: At Harborcrest Research instrument exports occasionally omit required identifiers. Use this acceptance check instead: Send one valid and one invalid synthetic record and confirm only the valid record reaches the curated table.

Question 808

At Harborcrest Research instrument exports occasionally omit required identifiers. Which shortcut most directly threatens the intended data outcome?

  1. Add an empty Fabric workspace and assume external live events start arriving without connectors.
  2. Assume DirectQuery has no dependency on the source system's availability or latency.
  3. Assume configuring a storage account alone creates a daily ingestion workflow.
  4. Silently drop errors while still reporting the source batch as complete.

Answer & Explanations

Correct answer: D

A.

Add an empty Fabric workspace and assume external live events start arriving without connectors. This concerns another issue: At Cedarcrest Media live audience actions feed a Fabric real-time dashboard. In the stated case—At Harborcrest Research instrument exports occasionally omit required identifiers—reject: Silently drop errors while still reporting the source batch as complete. The safer response is: Add validation and a quarantine destination for records failing an agreed data quality rule.

B.

Assume DirectQuery has no dependency on the source system's availability or latency. This concerns another issue: At Cedarfield Operations a governed warehouse remains the authority for interactive dashboard queries. In the stated case—At Harborcrest Research instrument exports occasionally omit required identifiers—reject: Silently drop errors while still reporting the source batch as complete. The safer response is: Add validation and a quarantine destination for records failing an agreed data quality rule.

C.

Assume configuring a storage account alone creates a daily ingestion workflow. This concerns another issue: At Harborpoint Education SQL and file extracts feed a shared Azure reporting lake. In the stated case—At Harborcrest Research instrument exports occasionally omit required identifiers—reject: Silently drop errors while still reporting the source batch as complete. The safer response is: Add validation and a quarantine destination for records failing an agreed data quality rule.

D.

Silently drop errors while still reporting the source batch as complete. The scenario is: At Harborcrest Research instrument exports occasionally omit required identifiers. The likely failure is: Data loss remains undiscovered and totals no longer reconcile. Instead: Add validation and a quarantine destination for records failing an agreed data quality rule.

Question 809

At Silverbrook Logistics pipelines reattempt delayed shipment messages. Which design or Azure data approach best fits this requirement?

  1. Add validation and a quarantine destination for records failing an agreed data quality rule.
  2. Apply Power BI row-level security when different users should see only their permitted records.
  3. Choose event-time windows when late-arriving sensor measurements must be attributed to their occurrence time rather than receipt time.
  4. Make ingestion transformations idempotent by using stable business keys when retrying failed batches.

Answer & Explanations

Correct answer: D

A.

Add validation and a quarantine destination for records failing an agreed data quality rule. This addresses a different situation: At Meadowfield Retail some supplier feeds contain negative quantities. The present case is: At Silverbrook Logistics pipelines reattempt delayed shipment messages. The relevant action here is: Make ingestion transformations idempotent by using stable business keys when retrying failed batches.

B.

Apply Power BI row-level security when different users should see only their permitted records. This addresses a different situation: At Cedarcrest Finance regional managers should see only their branch transactions. The present case is: At Silverbrook Logistics pipelines reattempt delayed shipment messages. The relevant action here is: Make ingestion transformations idempotent by using stable business keys when retrying failed batches.

C.

Choose event-time windows when late-arriving sensor measurements must be attributed to their occurrence time rather than receipt time. This addresses a different situation: At Meadowport Transit buses upload buffered GPS events after reconnecting. The present case is: At Silverbrook Logistics pipelines reattempt delayed shipment messages. The relevant action here is: Make ingestion transformations idempotent by using stable business keys when retrying failed batches.

D.

Make ingestion transformations idempotent by using stable business keys when retrying failed batches. This works because: Idempotent processing produces the same final state after repeated delivery of an identical event. The scenario is: At Silverbrook Logistics pipelines reattempt delayed shipment messages. Verify the outcome by: Replay a fictional batch twice and verify its aggregate row count remains unchanged.

Question 810

At Silverbrook Logistics pipelines reattempt delayed shipment messages. The team proposes this approach: Make ingestion transformations idempotent by using stable business keys when retrying failed batches. Which technical principle explains the choice?

  1. Idempotent processing produces the same final state after repeated delivery of an identical event.
  2. Aligned bar lengths communicate relative magnitudes across discrete groups more clearly than unrelated symbols.
  3. Windowed streaming computations aggregate events over bounded time intervals as new data arrives.
  4. Extract-transform-load performs transformations before storing the final warehouse-ready form.

Answer & Explanations

Correct answer: A

A.

Idempotent processing produces the same final state after repeated delivery of an identical event. This principle supports the intervention: Make ingestion transformations idempotent by using stable business keys when retrying failed batches. The relevant scenario is: At Silverbrook Logistics pipelines reattempt delayed shipment messages. Verify the result by: Replay a fictional batch twice and verify its aggregate row count remains unchanged.

B.

Aligned bar lengths communicate relative magnitudes across discrete groups more clearly than unrelated symbols. That explains a separate situation: At Cedarbank Logistics supervisors compare delivery counts among depots. The current case is: At Silverbrook Logistics pipelines reattempt delayed shipment messages. The actual mechanism is: Idempotent processing produces the same final state after repeated delivery of an identical event.

C.

Windowed streaming computations aggregate events over bounded time intervals as new data arrives. That explains a separate situation: At Meadowview Commerce payment anomalies are monitored in rolling five-minute windows. The current case is: At Silverbrook Logistics pipelines reattempt delayed shipment messages. The actual mechanism is: Idempotent processing produces the same final state after repeated delivery of an identical event.

D.

Extract-transform-load performs transformations before storing the final warehouse-ready form. That explains a separate situation: At Cedarfield Finance external invoices need standard currency codes before reporting. The current case is: At Silverbrook Logistics pipelines reattempt delayed shipment messages. The actual mechanism is: Idempotent processing produces the same final state after repeated delivery of an identical event.

Microsoft Azure Data Fundamentals (DP-900) Practice Tests