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 87

Question 860

At Meadowview Commerce payment anomalies are monitored in rolling five-minute windows. Which shortcut most directly threatens the intended data outcome?

  1. Calculate a 'last five minutes' alert from a table refreshed once per day.
  2. Run only a nightly file import for a stated subminute safety alert requirement.
  3. Store a decade of evenly used time-series data in one undifferentiated daily-export file.
  4. Assume DirectQuery has no dependency on the source system's availability or latency.

Answer & Explanations

Correct answer: A

A.

Calculate a 'last five minutes' alert from a table refreshed once per day. The scenario is: At Meadowview Commerce payment anomalies are monitored in rolling five-minute windows. This undermines the mechanism: Windowed streaming computations aggregate events over bounded time intervals as new data arrives. Instead: Use a supported stream-processing engine to calculate rolling event metrics instead of querying only raw immutable logs.

B.

Run only a nightly file import for a stated subminute safety alert requirement. This concerns another issue: At Cedarpoint Manufacturing equipment overheating requires prompt detection. In the stated case—At Meadowview Commerce payment anomalies are monitored in rolling five-minute windows—reject: Calculate a 'last five minutes' alert from a table refreshed once per day. The safer response is: Use a supported stream-processing engine to calculate rolling event metrics instead of querying only raw immutable logs.

C.

Store a decade of evenly used time-series data in one undifferentiated daily-export file. This concerns another issue: At Oakfield Utilities analysts frequently report one month of meter usage. In the stated case—At Meadowview Commerce payment anomalies are monitored in rolling five-minute windows—reject: Calculate a 'last five minutes' alert from a table refreshed once per day. The safer response is: Use a supported stream-processing engine to calculate rolling event metrics instead of querying only raw immutable logs.

D.

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 Meadowview Commerce payment anomalies are monitored in rolling five-minute windows—reject: Calculate a 'last five minutes' alert from a table refreshed once per day. The safer response is: Use a supported stream-processing engine to calculate rolling event metrics instead of querying only raw immutable logs.

Question 861

At Cedarfield Utilities power-grid telemetry requires short-lived rolling averages. Which design or Azure data approach best fits this requirement?

  1. Use a supported stream-processing engine to calculate rolling event metrics instead of querying only raw immutable logs.
  2. Separate real-time alert processing from slower historical archival so urgent actions do not wait for nightly warehousing.
  3. Use a scatter plot when exploring whether two quantitative variables have an association.
  4. Use Azure Databricks for distributed Spark-based processing of large or complex transformation workloads.

Answer & Explanations

Correct answer: A

A.

Use a supported stream-processing engine to calculate rolling event metrics instead of querying only raw immutable logs. This works because: Windowed streaming computations aggregate events over bounded time intervals as new data arrives. The scenario is: At Cedarfield Utilities power-grid telemetry requires short-lived rolling averages. Verify the outcome by: Send synthetic purchases across a five-minute interval and verify the window aggregate resets as designed.

B.

Separate real-time alert processing from slower historical archival so urgent actions do not wait for nightly warehousing. This addresses a different situation: At Pineport Healthcare medical equipment signals abnormal temperatures. The present case is: At Cedarfield Utilities power-grid telemetry requires short-lived rolling averages. The relevant action here is: Use a supported stream-processing engine to calculate rolling event metrics instead of querying only raw immutable logs.

C.

Use a scatter plot when exploring whether two quantitative variables have an association. This addresses a different situation: At Pinewood Retail analysts compare campaign spend with customer acquisitions. The present case is: At Cedarfield Utilities power-grid telemetry requires short-lived rolling averages. The relevant action here is: Use a supported stream-processing engine to calculate rolling event metrics instead of querying only raw immutable logs.

D.

Use Azure Databricks for distributed Spark-based processing of large or complex transformation workloads. This addresses a different situation: At Harborland Energy billions of sensor readings require transformation. The present case is: At Cedarfield Utilities power-grid telemetry requires short-lived rolling averages. The relevant action here is: Use a supported stream-processing engine to calculate rolling event metrics instead of querying only raw immutable logs.

Question 862

At Cedarfield Utilities power-grid telemetry requires short-lived rolling averages. The team proposes this approach: Use a supported stream-processing engine to calculate rolling event metrics instead of querying only raw immutable logs. Which technical principle explains the choice?

  1. Fact tables hold numeric events while dimensions describe dates, products and customers used to filter or group them.
  2. Model relationships propagate filter context between related tables according to direction and cardinality.
  3. Windowed streaming computations aggregate events over bounded time intervals as new data arrives.
  4. Event time reflects when the source event happened; processing time reflects when the system saw it.

Answer & Explanations

Correct answer: C

A.

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 Cedarfield Utilities power-grid telemetry requires short-lived rolling averages. The actual mechanism is: Windowed streaming computations aggregate events over bounded time intervals as new data arrives.

B.

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 Cedarfield Utilities power-grid telemetry requires short-lived rolling averages. The actual mechanism is: Windowed streaming computations aggregate events over bounded time intervals as new data arrives.

C.

Windowed streaming computations aggregate events over bounded time intervals as new data arrives. This principle supports the intervention: Use a supported stream-processing engine to calculate rolling event metrics instead of querying only raw immutable logs. The relevant scenario is: At Cedarfield Utilities power-grid telemetry requires short-lived rolling averages. Verify the result by: Send synthetic purchases across a five-minute interval and verify the window aggregate resets as designed.

D.

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 Cedarfield Utilities power-grid telemetry requires short-lived rolling averages. The actual mechanism is: Windowed streaming computations aggregate events over bounded time intervals as new data arrives.

Question 863

At Cedarfield Utilities power-grid telemetry requires short-lived rolling averages. After implementing this approach—Use a supported stream-processing engine to calculate rolling event metrics instead of querying only raw immutable logs—which result would most directly confirm success?

  1. Land sample JSON files and create a queryable curated table without discarding the original files.
  2. Add a fictional revenue measure and confirm it changes when the product slicer is adjusted.
  3. Send synthetic purchases across a five-minute interval and verify the window aggregate resets as designed.
  4. Stream sample temperature events, filter values above a threshold and verify only matching output reaches the destination.

Answer & Explanations

Correct answer: C

A.

Land sample JSON files and create a queryable curated table without discarding the original files. This tests a separate situation: At Cedarbridge Media analysts combine raw events and curated advertising tables. The observed case is: At Cedarfield Utilities power-grid telemetry requires short-lived rolling averages. Use this acceptance check instead: Send synthetic purchases across a five-minute interval and verify the window aggregate resets as designed.

B.

Add a fictional revenue measure and confirm it changes when the product slicer is adjusted. This tests a separate situation: At Silverlake Services managers compare revenue by selected region. The observed case is: At Cedarfield Utilities power-grid telemetry requires short-lived rolling averages. Use this acceptance check instead: Send synthetic purchases across a five-minute interval and verify the window aggregate resets as designed.

C.

Send synthetic purchases across a five-minute interval and verify the window aggregate resets as designed. This tests the targeted action: Use a supported stream-processing engine to calculate rolling event metrics instead of querying only raw immutable logs. The reason is: Windowed streaming computations aggregate events over bounded time intervals as new data arrives. The reported case is: At Cedarfield Utilities power-grid telemetry requires short-lived rolling averages.

D.

Stream sample temperature events, filter values above a threshold and verify only matching output reaches the destination. This tests a separate situation: At Pinebrook Facilities sensors send readings to an event hub. The observed case is: At Cedarfield Utilities power-grid telemetry requires short-lived rolling averages. Use this acceptance check instead: Send synthetic purchases across a five-minute interval and verify the window aggregate resets as designed.

Question 864

At Cedarfield Utilities power-grid telemetry requires short-lived rolling averages. Which shortcut most directly threatens the intended data outcome?

  1. Calculate a 'last five minutes' alert from a table refreshed once per day.
  2. Append duplicate transactions on every network retry without comparing event IDs.
  3. Treat each retransmission as a brand-new purchase.
  4. Paste a fixed grand total into every transaction row and expect slicers to recalculate it.

Answer & Explanations

Correct answer: A

A.

Calculate a 'last five minutes' alert from a table refreshed once per day. The scenario is: At Cedarfield Utilities power-grid telemetry requires short-lived rolling averages. This undermines the mechanism: Windowed streaming computations aggregate events over bounded time intervals as new data arrives. Instead: Use a supported stream-processing engine to calculate rolling event metrics instead of querying only raw immutable logs.

B.

Append duplicate transactions on every network retry without comparing event IDs. This concerns another issue: At Silverbrook Logistics pipelines reattempt delayed shipment messages. In the stated case—At Cedarfield Utilities power-grid telemetry requires short-lived rolling averages—reject: Calculate a 'last five minutes' alert from a table refreshed once per day. The safer response is: Use a supported stream-processing engine to calculate rolling event metrics instead of querying only raw immutable logs.

C.

Treat each retransmission as a brand-new purchase. This concerns another issue: At Silverpoint Banking an event publisher retries after a brief timeout. In the stated case—At Cedarfield Utilities power-grid telemetry requires short-lived rolling averages—reject: Calculate a 'last five minutes' alert from a table refreshed once per day. The safer response is: Use a supported stream-processing engine to calculate rolling event metrics instead of querying only raw immutable logs.

D.

Paste a fixed grand total into every transaction row and expect slicers to recalculate it. This concerns another issue: At Silverlake Services managers compare revenue by selected region. In the stated case—At Cedarfield Utilities power-grid telemetry requires short-lived rolling averages—reject: Calculate a 'last five minutes' alert from a table refreshed once per day. The safer response is: Use a supported stream-processing engine to calculate rolling event metrics instead of querying only raw immutable logs.

Question 865

At Pinebrook Facilities sensors send readings to an event hub. Which design or Azure data approach best fits this requirement?

  1. Use a DAX measure for a filter-context-dependent aggregate rather than storing the same changing total in every fact row.
  2. Use Azure Stream Analytics for a supported continuous stream query that filters and aggregates incoming events.
  3. Use a supported stream-processing engine to calculate rolling event metrics instead of querying only raw immutable logs.
  4. Choose a lakehouse when a project needs both raw files and managed analytical tables for mixed data engineering workloads.

Answer & Explanations

Correct answer: B

A.

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 Pinebrook Facilities sensors send readings to an event hub. The relevant action here is: Use Azure Stream Analytics for a supported continuous stream query that filters and aggregates incoming events.

B.

Use Azure Stream Analytics for a supported continuous stream query that filters and aggregates incoming events. This works because: Stream Analytics applies SQL-like continuous queries to configured inputs and outputs. The scenario is: At Pinebrook Facilities sensors send readings to an event hub. Verify the outcome by: Stream sample temperature events, filter values above a threshold and verify only matching output reaches the destination.

C.

Use a supported stream-processing engine to calculate rolling event metrics instead of querying only raw immutable logs. This addresses a different situation: At Meadowview Commerce payment anomalies are monitored in rolling five-minute windows. The present case is: At Pinebrook Facilities sensors send readings to an event hub. The relevant action here is: Use Azure Stream Analytics for a supported continuous stream query that filters and aggregates incoming events.

D.

Choose a lakehouse when a project needs both raw files and managed analytical tables for mixed data engineering workloads. This addresses a different situation: At Cedarbridge Media analysts combine raw events and curated advertising tables. The present case is: At Pinebrook Facilities sensors send readings to an event hub. The relevant action here is: Use Azure Stream Analytics for a supported continuous stream query that filters and aggregates incoming events.

Question 866

At Pinebrook Facilities sensors send readings to an event hub. The team proposes this approach: Use Azure Stream Analytics for a supported continuous stream query that filters and aggregates incoming events. Which technical principle explains the choice?

  1. A hot streaming path reacts promptly while the cold path can consolidate history for deeper analysis.
  2. Separating bad records protects curated datasets while retaining evidence for correction and replay.
  3. Stream Analytics applies SQL-like continuous queries to configured inputs and outputs.
  4. Position along a time axis makes change and seasonality easier to compare across ordered periods.

Answer & Explanations

Correct answer: C

A.

A hot streaming path reacts promptly while the cold path can consolidate history for deeper analysis. That explains a separate situation: At Pineport Healthcare medical equipment signals abnormal temperatures. The current case is: At Pinebrook Facilities sensors send readings to an event hub. The actual mechanism is: Stream Analytics applies SQL-like continuous queries to configured inputs and outputs.

B.

Separating bad records protects curated datasets while retaining evidence for correction and replay. That explains a separate situation: At Meadowfield Retail some supplier feeds contain negative quantities. The current case is: At Pinebrook Facilities sensors send readings to an event hub. The actual mechanism is: Stream Analytics applies SQL-like continuous queries to configured inputs and outputs.

C.

Stream Analytics applies SQL-like continuous queries to configured inputs and outputs. This principle supports the intervention: Use Azure Stream Analytics for a supported continuous stream query that filters and aggregates incoming events. The relevant scenario is: At Pinebrook Facilities sensors send readings to an event hub. Verify the result by: Stream sample temperature events, filter values above a threshold and verify only matching output reaches the destination.

D.

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 Pinebrook Facilities sensors send readings to an event hub. The actual mechanism is: Stream Analytics applies SQL-like continuous queries to configured inputs and outputs.

Question 867

At Pinebrook Facilities sensors send readings to an event hub. After implementing this approach—Use Azure Stream Analytics for a supported continuous stream query that filters and aggregates incoming events—which result would most directly confirm success?

  1. Publish synthetic events, consume them through a test consumer group and verify offsets advance.
  2. Build a fictional multi-page sales report and pin a selected KPI to a dashboard without losing the source report.
  3. Stream sample temperature events, filter values above a threshold and verify only matching output reaches the destination.
  4. Update two fictional source records and confirm the second pipeline run imports only eligible changes.

Answer & Explanations

Correct answer: C

A.

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 Pinebrook Facilities sensors send readings to an event hub. Use this acceptance check instead: Stream sample temperature events, filter values above a threshold and verify only matching output reaches the destination.

B.

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 Pinebrook Facilities sensors send readings to an event hub. Use this acceptance check instead: Stream sample temperature events, filter values above a threshold and verify only matching output reaches the destination.

C.

Stream sample temperature events, filter values above a threshold and verify only matching output reaches the destination. This tests the targeted action: Use Azure Stream Analytics for a supported continuous stream query that filters and aggregates incoming events. The reason is: Stream Analytics applies SQL-like continuous queries to configured inputs and outputs. The reported case is: At Pinebrook Facilities sensors send readings to an event hub.

D.

Update two fictional source records and confirm the second pipeline run imports only eligible changes. This tests a separate situation: At Cedarbank Payments the warehouse must refresh recent settlements without reloading years of history. The observed case is: At Pinebrook Facilities sensors send readings to an event hub. Use this acceptance check instead: Stream sample temperature events, filter values above a threshold and verify only matching output reaches the destination.

Question 868

At Pinebrook Facilities sensors send readings to an event hub. Which shortcut most directly threatens the intended data outcome?

  1. Use a pie chart to prove one numeric factor causes another.
  2. Deploy a static SQL query in a disconnected relational database and assume it automatically subscribes to the sensor stream.
  3. Have every department calculate quarterly revenue from unrelated raw CSV files with different definitions.
  4. Calculate a 'last five minutes' alert from a table refreshed once per day.

Answer & Explanations

Correct answer: B

A.

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 Pinebrook Facilities sensors send readings to an event hub—reject: Deploy a static SQL query in a disconnected relational database and assume it automatically subscribes to the sensor stream. The safer response is: Use Azure Stream Analytics for a supported continuous stream query that filters and aggregates incoming events.

B.

Deploy a static SQL query in a disconnected relational database and assume it automatically subscribes to the sensor stream. The scenario is: At Pinebrook Facilities sensors send readings to an event hub. This undermines the mechanism: Stream Analytics applies SQL-like continuous queries to configured inputs and outputs. Instead: Use Azure Stream Analytics for a supported continuous stream query that filters and aggregates incoming events.

C.

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 Pinebrook Facilities sensors send readings to an event hub—reject: Deploy a static SQL query in a disconnected relational database and assume it automatically subscribes to the sensor stream. The safer response is: Use Azure Stream Analytics for a supported continuous stream query that filters and aggregates incoming events.

D.

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 Pinebrook Facilities sensors send readings to an event hub—reject: Deploy a static SQL query in a disconnected relational database and assume it automatically subscribes to the sensor stream. The safer response is: Use Azure Stream Analytics for a supported continuous stream query that filters and aggregates incoming events.

Question 869

At Silverlake Operations a real-time anomaly feed needs an Azure stream query. Which design or Azure data approach best fits this requirement?

  1. Use Azure Stream Analytics for a supported continuous stream query that filters and aggregates incoming events.
  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. Use an ETL pipeline when data must be cleansed and reshaped before loading the governed analytical destination.

Answer & Explanations

Correct answer: A

A.

Use Azure Stream Analytics for a supported continuous stream query that filters and aggregates incoming events. This works because: Stream Analytics applies SQL-like continuous queries to configured inputs and outputs. The scenario is: At Silverlake Operations a real-time anomaly feed needs an Azure stream query. Verify the outcome by: Stream sample temperature events, filter values above a threshold and verify only matching output reaches the destination.

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 Silverlake Operations a real-time anomaly feed needs an Azure stream query. The relevant action here is: Use Azure Stream Analytics for a supported continuous stream query that filters and aggregates incoming events.

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 Silverlake Operations a real-time anomaly feed needs an Azure stream query. The relevant action here is: Use Azure Stream Analytics for a supported continuous stream query that filters and aggregates incoming events.

D.

Use an ETL pipeline when data must be cleansed and reshaped before loading the governed analytical destination. This addresses a different situation: At Cedarfield Finance external invoices need standard currency codes before reporting. The present case is: At Silverlake Operations a real-time anomaly feed needs an Azure stream query. The relevant action here is: Use Azure Stream Analytics for a supported continuous stream query that filters and aggregates incoming events.

Question 870

At Silverlake Operations a real-time anomaly feed needs an Azure stream query. The team proposes this approach: Use Azure Stream Analytics for a supported continuous stream query that filters and aggregates incoming events. Which technical principle explains the choice?

  1. Larger batch jobs can be efficient but delay availability, so cadence must match business SLAs.
  2. Stream Analytics applies SQL-like continuous queries to configured inputs and outputs.
  3. Import caches data in the Power BI model and requires refresh to reflect changed source rows.
  4. A bounded event retention period permits eligible consumers to resume from offsets without requiring the producer to resend immediately.

Answer & Explanations

Correct answer: B

A.

Larger batch jobs can be efficient but delay availability, so cadence must match business SLAs. That explains a separate situation: At Harborland Retail nightly inventory analytics satisfy finance but not emergency stock alerts. The current case is: At Silverlake Operations a real-time anomaly feed needs an Azure stream query. The actual mechanism is: Stream Analytics applies SQL-like continuous queries to configured inputs and outputs.

B.

Stream Analytics applies SQL-like continuous queries to configured inputs and outputs. This principle supports the intervention: Use Azure Stream Analytics for a supported continuous stream query that filters and aggregates incoming events. The relevant scenario is: At Silverlake Operations a real-time anomaly feed needs an Azure stream query. Verify the result by: Stream sample temperature events, filter values above a threshold and verify only matching output reaches the destination.

C.

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 Silverlake Operations a real-time anomaly feed needs an Azure stream query. The actual mechanism is: Stream Analytics applies SQL-like continuous queries to configured inputs and outputs.

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 Silverlake Operations a real-time anomaly feed needs an Azure stream query. The actual mechanism is: Stream Analytics applies SQL-like continuous queries to configured inputs and outputs.

Microsoft Azure Data Fundamentals (DP-900) Practice Tests