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 90

Question 890

At Silverpoint Banking an event publisher retries after a brief timeout. The team proposes this approach: Define a controlled late-arrival and deduplication policy for at-least-once streaming delivery. Which technical principle explains the choice?

  1. Retries and event-time disorder can produce duplicate or tardy events that require stable IDs and window rules.
  2. Position along a time axis makes change and seasonality easier to compare across ordered periods.
  3. A bounded event retention period permits eligible consumers to resume from offsets without requiring the producer to resend immediately.
  4. Data Factory pipelines coordinate copy activities, triggers, transformations and operational monitoring across services.

Answer & Explanations

Correct answer: A

A.

Retries and event-time disorder can produce duplicate or tardy events that require stable IDs and window rules. This principle supports the intervention: Define a controlled late-arrival and deduplication policy for at-least-once streaming delivery. The relevant scenario is: At Silverpoint Banking an event publisher retries after a brief timeout. Verify the result by: Replay a fictional event with the same ID and confirm the sink counts it only once.

B.

Position along a time axis makes change and seasonality easier to compare across ordered periods. That explains a separate situation: At Meadowport Media analysts inspect daily subscription signups. The current case is: At Silverpoint Banking an event publisher retries after a brief timeout. The actual mechanism is: Retries and event-time disorder can produce duplicate or tardy events that require stable IDs and window rules.

C.

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 Silverpoint Banking an event publisher retries after a brief timeout. The actual mechanism is: Retries and event-time disorder can produce duplicate or tardy events that require stable IDs and window rules.

D.

Data Factory pipelines coordinate copy activities, triggers, transformations and operational monitoring across services. That explains a separate situation: At Harborpoint Education SQL and file extracts feed a shared Azure reporting lake. The current case is: At Silverpoint Banking an event publisher retries after a brief timeout. The actual mechanism is: Retries and event-time disorder can produce duplicate or tardy events that require stable IDs and window rules.

Question 891

At Silverpoint Banking an event publisher retries after a brief timeout. After implementing this approach—Define a controlled late-arrival and deduplication policy for at-least-once streaming delivery—which result would most directly confirm success?

  1. Load a fictional raw dataset into a restricted landing zone and run a documented transformation to a curated table.
  2. Replay a fictional event with the same ID and confirm the sink counts it only once.
  3. Emit a synthetic threshold event and verify an immediate alert and a later analytical archive record.
  4. Build a fictional multi-page sales report and pin a selected KPI to a dashboard without losing the source report.

Answer & Explanations

Correct answer: B

A.

Load a fictional raw dataset into a restricted landing zone and run a documented transformation to a curated table. This tests a separate situation: At Meadowview Retail a cloud warehouse performs its own SQL cleaning after ingestion. The observed case is: At Silverpoint Banking an event publisher retries after a brief timeout. Use this acceptance check instead: Replay a fictional event with the same ID and confirm the sink counts it only once.

B.

Replay a fictional event with the same ID and confirm the sink counts it only once. This tests the targeted action: Define a controlled late-arrival and deduplication policy for at-least-once streaming delivery. The reason is: Retries and event-time disorder can produce duplicate or tardy events that require stable IDs and window rules. The reported case is: At Silverpoint Banking an event publisher retries after a brief timeout.

C.

Emit a synthetic threshold event and verify an immediate alert and a later analytical archive record. This tests a separate situation: At Pineport Healthcare medical equipment signals abnormal temperatures. The observed case is: At Silverpoint Banking an event publisher retries after a brief timeout. Use this acceptance check instead: Replay a fictional event with the same ID and confirm the sink counts it only once.

D.

Build a fictional multi-page sales report and pin a selected KPI to a dashboard without losing the source report. This tests a separate situation: At Harborland Banking executives monitor headline risk indicators and analysts need detail pages. The observed case is: At Silverpoint Banking an event publisher retries after a brief timeout. Use this acceptance check instead: Replay a fictional event with the same ID and confirm the sink counts it only once.

Question 892

At Silverpoint Banking an event publisher retries after a brief timeout. Which shortcut most directly threatens the intended data outcome?

  1. Treat each retransmission as a brand-new purchase.
  2. Assume a consumer can recover messages that have already aged out of the event stream.
  3. Hide a confidential table on the report canvas while leaving its underlying dataset unrestricted.
  4. Have every department calculate quarterly revenue from unrelated raw CSV files with different definitions.

Answer & Explanations

Correct answer: A

A.

Treat each retransmission as a brand-new purchase. The scenario is: At Silverpoint Banking an event publisher retries after a brief timeout. This undermines the mechanism: Retries and event-time disorder can produce duplicate or tardy events that require stable IDs and window rules. Instead: Define a controlled late-arrival and deduplication policy for at-least-once streaming delivery.

B.

Assume a consumer can recover messages that have already aged out of the event stream. This concerns another issue: At Harborcrest Logistics a tracking processor is offline during a deployment. In the stated case—At Silverpoint Banking an event publisher retries after a brief timeout—reject: Treat each retransmission as a brand-new purchase. The safer response is: Define a controlled late-arrival and deduplication policy for at-least-once streaming delivery.

C.

Hide a confidential table on the report canvas while leaving its underlying dataset unrestricted. This concerns another issue: At Cedarcrest Finance regional managers should see only their branch transactions. In the stated case—At Silverpoint Banking an event publisher retries after a brief timeout—reject: Treat each retransmission as a brand-new purchase. The safer response is: Define a controlled late-arrival and deduplication policy for at-least-once streaming delivery.

D.

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 Silverpoint Banking an event publisher retries after a brief timeout—reject: Treat each retransmission as a brand-new purchase. The safer response is: Define a controlled late-arrival and deduplication policy for at-least-once streaming delivery.

Question 893

At Cedarbank IoT wireless sensors reconnect and resend buffered messages. Which design or Azure data approach best fits this requirement?

  1. Retain streaming events for a documented replay interval when consumers may fail temporarily.
  2. Define a controlled late-arrival and deduplication policy for at-least-once streaming delivery.
  3. Distinguish a Power BI report with interactive multiple-page exploration from a dashboard that presents pinned monitoring tiles.
  4. Use Microsoft Fabric OneLake as a governed shared logical lake for permitted analytics workloads.

Answer & Explanations

Correct answer: B

A.

Retain streaming events for a documented replay interval when consumers may fail temporarily. This addresses a different situation: At Harborcrest Logistics a tracking processor is offline during a deployment. The present case is: At Cedarbank IoT wireless sensors reconnect and resend buffered messages. The relevant action here is: Define a controlled late-arrival and deduplication policy for at-least-once streaming delivery.

B.

Define a controlled late-arrival and deduplication policy for at-least-once streaming delivery. This works because: Retries and event-time disorder can produce duplicate or tardy events that require stable IDs and window rules. The scenario is: At Cedarbank IoT wireless sensors reconnect and resend buffered messages. Verify the outcome by: Replay a fictional event with the same ID and confirm the sink counts it only once.

C.

Distinguish a Power BI report with interactive multiple-page exploration from a dashboard that presents pinned monitoring tiles. This addresses a different situation: At Harborland Banking executives monitor headline risk indicators and analysts need detail pages. The present case is: At Cedarbank IoT wireless sensors reconnect and resend buffered messages. The relevant action here is: Define a controlled late-arrival and deduplication policy for at-least-once streaming delivery.

D.

Use Microsoft Fabric OneLake as a governed shared logical lake for permitted analytics workloads. This addresses a different situation: At Meadowbank Insurance several Fabric teams need a centrally governed analytical foundation. The present case is: At Cedarbank IoT wireless sensors reconnect and resend buffered messages. The relevant action here is: Define a controlled late-arrival and deduplication policy for at-least-once streaming delivery.

Question 894

At Cedarbank IoT wireless sensors reconnect and resend buffered messages. The team proposes this approach: Define a controlled late-arrival and deduplication policy for at-least-once streaming delivery. Which technical principle explains the choice?

  1. RLS filters model rows according to configured role rules and identity mapping rather than merely hiding visuals.
  2. A lakehouse combines lake-style file storage with table organization and analytical query access.
  3. Streaming handles events as they arrive while batch processing groups bounded input sets at intervals.
  4. Retries and event-time disorder can produce duplicate or tardy events that require stable IDs and window rules.

Answer & Explanations

Correct answer: D

A.

RLS filters model rows according to configured role rules and identity mapping rather than merely hiding visuals. That explains a separate situation: At Cedarcrest Finance regional managers should see only their branch transactions. The current case is: At Cedarbank IoT wireless sensors reconnect and resend buffered messages. The actual mechanism is: Retries and event-time disorder can produce duplicate or tardy events that require stable IDs and window rules.

B.

A lakehouse combines lake-style file storage with table organization and analytical query access. That explains a separate situation: At Cedarbridge Media analysts combine raw events and curated advertising tables. The current case is: At Cedarbank IoT wireless sensors reconnect and resend buffered messages. The actual mechanism is: Retries and event-time disorder can produce duplicate or tardy events that require stable IDs and window rules.

C.

Streaming handles events as they arrive while batch processing groups bounded input sets at intervals. That explains a separate situation: At Cedarpoint Manufacturing equipment overheating requires prompt detection. The current case is: At Cedarbank IoT wireless sensors reconnect and resend buffered messages. The actual mechanism is: Retries and event-time disorder can produce duplicate or tardy events that require stable IDs and window rules.

D.

Retries and event-time disorder can produce duplicate or tardy events that require stable IDs and window rules. This principle supports the intervention: Define a controlled late-arrival and deduplication policy for at-least-once streaming delivery. The relevant scenario is: At Cedarbank IoT wireless sensors reconnect and resend buffered messages. Verify the result by: Replay a fictional event with the same ID and confirm the sink counts it only once.

Question 895

At Cedarbank IoT wireless sensors reconnect and resend buffered messages. After implementing this approach—Define a controlled late-arrival and deduplication policy for at-least-once streaming delivery—which result would most directly confirm success?

  1. Send synthetic device readings and compare event-to-dashboard delay under both processing designs.
  2. Replay a fictional event with the same ID and confirm the sink counts it only once.
  3. Create a test lakehouse table and verify only approved workspace identities can read the source files.
  4. Build a fictional multi-page sales report and pin a selected KPI to a dashboard without losing the source report.

Answer & Explanations

Correct answer: B

A.

Send synthetic device readings and compare event-to-dashboard delay under both processing designs. This tests a separate situation: At Cedarpoint Manufacturing equipment overheating requires prompt detection. The observed case is: At Cedarbank IoT wireless sensors reconnect and resend buffered messages. Use this acceptance check instead: Replay a fictional event with the same ID and confirm the sink counts it only once.

B.

Replay a fictional event with the same ID and confirm the sink counts it only once. This tests the targeted action: Define a controlled late-arrival and deduplication policy for at-least-once streaming delivery. The reason is: Retries and event-time disorder can produce duplicate or tardy events that require stable IDs and window rules. The reported case is: At Cedarbank IoT wireless sensors reconnect and resend buffered messages.

C.

Create a test lakehouse table and verify only approved workspace identities can read the source files. This tests a separate situation: At Meadowbank Insurance several Fabric teams need a centrally governed analytical foundation. The observed case is: At Cedarbank IoT wireless sensors reconnect and resend buffered messages. Use this acceptance check instead: Replay a fictional event with the same ID and confirm the sink counts it only once.

D.

Build a fictional multi-page sales report and pin a selected KPI to a dashboard without losing the source report. This tests a separate situation: At Harborland Banking executives monitor headline risk indicators and analysts need detail pages. The observed case is: At Cedarbank IoT wireless sensors reconnect and resend buffered messages. Use this acceptance check instead: Replay a fictional event with the same ID and confirm the sink counts it only once.

Question 896

At Cedarbank IoT wireless sensors reconnect and resend buffered messages. Which shortcut most directly threatens the intended data outcome?

  1. Treat each retransmission as a brand-new purchase.
  2. Calculate a 'last five minutes' alert from a table refreshed once per day.
  3. Assume DirectQuery has no dependency on the source system's availability or latency.
  4. Silently drop errors while still reporting the source batch as complete.

Answer & Explanations

Correct answer: A

A.

Treat each retransmission as a brand-new purchase. The scenario is: At Cedarbank IoT wireless sensors reconnect and resend buffered messages. This undermines the mechanism: Retries and event-time disorder can produce duplicate or tardy events that require stable IDs and window rules. Instead: Define a controlled late-arrival and deduplication policy for at-least-once streaming delivery.

B.

Calculate a 'last five minutes' alert from a table refreshed once per day. This concerns another issue: At Meadowview Commerce payment anomalies are monitored in rolling five-minute windows. In the stated case—At Cedarbank IoT wireless sensors reconnect and resend buffered messages—reject: Treat each retransmission as a brand-new purchase. The safer response is: Define a controlled late-arrival and deduplication policy for at-least-once streaming delivery.

C.

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 Cedarbank IoT wireless sensors reconnect and resend buffered messages—reject: Treat each retransmission as a brand-new purchase. The safer response is: Define a controlled late-arrival and deduplication policy for at-least-once streaming delivery.

D.

Silently drop errors while still reporting the source batch as complete. This concerns another issue: At Meadowfield Retail some supplier feeds contain negative quantities. In the stated case—At Cedarbank IoT wireless sensors reconnect and resend buffered messages—reject: Treat each retransmission as a brand-new purchase. The safer response is: Define a controlled late-arrival and deduplication policy for at-least-once streaming delivery.

Question 897

At Harborcrest Logistics a tracking processor is offline during a deployment. Which design or Azure data approach best fits this requirement?

  1. Retain streaming events for a documented replay interval when consumers may fail temporarily.
  2. Distinguish continuous streaming ingestion from scheduled batch imports by how promptly records must be processed.
  3. Configure an active relationship between compatible dimension keys and fact foreign keys for expected report filtering.
  4. Use versioned curated datasets and lineage metadata so analysts can trace transformations and reproduce reports.

Answer & Explanations

Correct answer: A

A.

Retain streaming events for a documented replay interval when consumers may fail temporarily. This works because: A bounded event retention period permits eligible consumers to resume from offsets without requiring the producer to resend immediately. The scenario is: At Harborcrest Logistics a tracking processor is offline during a deployment. Verify the outcome by: Pause a synthetic consumer, resume within retention and verify it catches up from a saved checkpoint.

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 Harborcrest Logistics a tracking processor is offline during a deployment. The relevant action here is: Retain streaming events for a documented replay interval when consumers may fail temporarily.

C.

Configure an active relationship between compatible dimension keys and fact foreign keys for expected report filtering. This addresses a different situation: At Harborfield Commerce sales facts reference a product dimension. The present case is: At Harborcrest Logistics a tracking processor is offline during a deployment. The relevant action here is: Retain streaming events for a documented replay interval when consumers may fail temporarily.

D.

Use versioned curated datasets and lineage metadata so analysts can trace transformations and reproduce reports. This addresses a different situation: At Cedarcrest Banking financial metrics require stable audit evidence. The present case is: At Harborcrest Logistics a tracking processor is offline during a deployment. The relevant action here is: Retain streaming events for a documented replay interval when consumers may fail temporarily.

Question 898

At Harborcrest Logistics a tracking processor is offline during a deployment. The team proposes this approach: Retain streaming events for a documented replay interval when consumers may fail temporarily. Which technical principle explains the choice?

  1. A bounded event retention period permits eligible consumers to resume from offsets without requiring the producer to resend immediately.
  2. Event time reflects when the source event happened; processing time reflects when the system saw it.
  3. Each point shows paired numeric values and can reveal patterns or outliers without implying causation.
  4. Fact tables hold numeric events while dimensions describe dates, products and customers used to filter or group them.

Answer & Explanations

Correct answer: A

A.

A bounded event retention period permits eligible consumers to resume from offsets without requiring the producer to resend immediately. This principle supports the intervention: Retain streaming events for a documented replay interval when consumers may fail temporarily. The relevant scenario is: At Harborcrest Logistics a tracking processor is offline during a deployment. Verify the result by: Pause a synthetic consumer, resume within retention and verify it catches up from a saved checkpoint.

B.

Event time reflects when the source event happened; processing time reflects when the system saw it. That explains a separate situation: At Meadowport Transit buses upload buffered GPS events after reconnecting. The current case is: At Harborcrest Logistics a tracking processor is offline during a deployment. The actual mechanism is: A bounded event retention period permits eligible consumers to resume from offsets without requiring the producer to resend immediately.

C.

Each point shows paired numeric values and can reveal patterns or outliers without implying causation. That explains a separate situation: At Pinewood Retail analysts compare campaign spend with customer acquisitions. The current case is: At Harborcrest Logistics a tracking processor is offline during a deployment. The actual mechanism is: A bounded event retention period permits eligible consumers to resume from offsets without requiring the producer to resend immediately.

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 Harborcrest Logistics a tracking processor is offline during a deployment. The actual mechanism is: A bounded event retention period permits eligible consumers to resume from offsets without requiring the producer to resend immediately.

Question 899

At Harborcrest Logistics a tracking processor is offline during a deployment. After implementing this approach—Retain streaming events for a documented replay interval when consumers may fail temporarily—which result would most directly confirm success?

  1. Run two test consumer groups and confirm each sees the intended events without resetting the other's offset.
  2. Relate fictional sales facts to products and dates and verify filters affect the intended totals.
  3. Run a synthetic failed source connection and confirm a retry or failure alert is recorded without double loading.
  4. Pause a synthetic consumer, resume within retention and verify it catches up from a saved checkpoint.

Answer & Explanations

Correct answer: D

A.

Run two test consumer groups and confirm each sees the intended events without resetting the other's offset. This tests a separate situation: At Oakcrest Mobility live tracking and reporting consume the same event source. The observed case is: At Harborcrest Logistics a tracking processor is offline during a deployment. Use this acceptance check instead: Pause a synthetic consumer, resume within retention and verify it catches up from a saved checkpoint.

B.

Relate fictional sales facts to products and dates and verify filters affect the intended totals. This tests a separate situation: At Harborbank Retail executives need sales dashboards sharing one definition of revenue. The observed case is: At Harborcrest Logistics a tracking processor is offline during a deployment. Use this acceptance check instead: Pause a synthetic consumer, resume within retention and verify it catches up from a saved checkpoint.

C.

Run a synthetic failed source connection and confirm a retry or failure alert is recorded without double loading. This tests a separate situation: At Westport Manufacturing factory transactions feed an overnight analytics store. The observed case is: At Harborcrest Logistics a tracking processor is offline during a deployment. Use this acceptance check instead: Pause a synthetic consumer, resume within retention and verify it catches up from a saved checkpoint.

D.

Pause a synthetic consumer, resume within retention and verify it catches up from a saved checkpoint. This tests the targeted action: Retain streaming events for a documented replay interval when consumers may fail temporarily. The reason is: A bounded event retention period permits eligible consumers to resume from offsets without requiring the producer to resend immediately. The reported case is: At Harborcrest Logistics a tracking processor is offline during a deployment.

Question 900

At Harborcrest Logistics a tracking processor is offline during a deployment. Which shortcut most directly threatens the intended data outcome?

  1. Assume a consumer can recover messages that have already aged out of the event stream.
  2. Overwrite transformations without a change record while claiming prior KPI totals are reproducible.
  3. Share one destructive manual cursor between unrelated alerting and archival applications.
  4. Use a pie chart to prove one numeric factor causes another.

Answer & Explanations

Correct answer: A

A.

Assume a consumer can recover messages that have already aged out of the event stream. The scenario is: At Harborcrest Logistics a tracking processor is offline during a deployment. This undermines the mechanism: A bounded event retention period permits eligible consumers to resume from offsets without requiring the producer to resend immediately. Instead: Retain streaming events for a documented replay interval when consumers may fail temporarily.

B.

Overwrite transformations without a change record while claiming prior KPI totals are reproducible. This concerns another issue: At Cedarcrest Banking financial metrics require stable audit evidence. In the stated case—At Harborcrest Logistics a tracking processor is offline during a deployment—reject: Assume a consumer can recover messages that have already aged out of the event stream. The safer response is: Retain streaming events for a documented replay interval when consumers may fail temporarily.

C.

Share one destructive manual cursor between unrelated alerting and archival applications. This concerns another issue: At Oakcrest Mobility live tracking and reporting consume the same event source. In the stated case—At Harborcrest Logistics a tracking processor is offline during a deployment—reject: Assume a consumer can recover messages that have already aged out of the event stream. The safer response is: Retain streaming events for a documented replay interval when consumers may fail temporarily.

D.

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 Harborcrest Logistics a tracking processor is offline during a deployment—reject: Assume a consumer can recover messages that have already aged out of the event stream. The safer response is: Retain streaming events for a documented replay interval when consumers may fail temporarily.

Microsoft Azure Data Fundamentals (DP-900) Practice Tests