Microsoft DP-900 Dumps
Microsoft DP-900 Practice Test 88
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?
Answer & Explanations
Correct answer: B
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.
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.
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.
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.
Question 871
At Silverlake Operations a real-time anomaly feed needs an Azure stream query. 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?
Answer & Explanations
Correct answer: 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 Silverlake Operations a real-time anomaly feed needs an Azure stream query. Use this acceptance check instead: Stream sample temperature events, filter values above a threshold and verify only matching output reaches the destination.
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 Silverlake Operations a real-time anomaly feed needs an Azure stream query. Use this acceptance check instead: Stream sample temperature events, filter values above a threshold and verify only matching output reaches the destination.
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 Silverlake Operations a real-time anomaly feed needs an Azure stream query.
Pause a synthetic consumer, resume within retention and verify it catches up from a saved checkpoint. This tests a separate situation: At Harborcrest Logistics a tracking processor is offline during a deployment. The observed case is: At Silverlake Operations a real-time anomaly feed needs an Azure stream query. Use this acceptance check instead: Stream sample temperature events, filter values above a threshold and verify only matching output reaches the destination.
Question 872
At Silverlake Operations a real-time anomaly feed needs an Azure stream query. Which shortcut most directly threatens the intended data outcome?
Answer & Explanations
Correct answer: C
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 Silverlake Operations a real-time anomaly feed needs an Azure stream query—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.
Discard raw source files before checking whether transformations are repeatable. This concerns another issue: At Meadowview Retail a cloud warehouse performs its own SQL cleaning after ingestion. In the stated case—At Silverlake Operations a real-time anomaly feed needs an Azure stream query—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.
Deploy a static SQL query in a disconnected relational database and assume it automatically subscribes to the sensor stream. The scenario is: At Silverlake Operations a real-time anomaly feed needs an Azure stream query. 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.
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 Silverlake Operations a real-time anomaly feed needs an Azure stream query—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 873
At Cedarcrest Media live audience actions feed a Fabric real-time dashboard. Which design or Azure data approach best fits this requirement?
Answer & Explanations
Correct answer: D
Build an incremental ingestion path based on reliable watermarks or source change tracking. This addresses a different situation: At Cedarbank Payments the warehouse must refresh recent settlements without reloading years of history. The present case is: At Cedarcrest Media live audience actions feed a Fabric real-time dashboard. The relevant action here is: Use Microsoft Fabric Real-Time Intelligence eventstream capabilities when live events must feed governed Fabric analytics destinations.
Use Azure Stream Analytics for a supported continuous stream query that filters and aggregates incoming events. This addresses a different situation: At Pinebrook Facilities sensors send readings to an event hub. The present case is: At Cedarcrest Media live audience actions feed a Fabric real-time dashboard. The relevant action here is: Use Microsoft Fabric Real-Time Intelligence eventstream capabilities when live events must feed governed Fabric analytics destinations.
Choose a bar chart for comparing distinct categories with a common quantitative scale. This addresses a different situation: At Cedarbank Logistics supervisors compare delivery counts among depots. The present case is: At Cedarcrest Media live audience actions feed a Fabric real-time dashboard. The relevant action here is: Use Microsoft Fabric Real-Time Intelligence eventstream capabilities when live events must feed governed Fabric analytics destinations.
Use Microsoft Fabric Real-Time Intelligence eventstream capabilities when live events must feed governed Fabric analytics destinations. This works because: Eventstreams can connect event sources to Fabric's real-time processing experiences and selected sinks. The scenario is: At Cedarcrest Media live audience actions feed a Fabric real-time dashboard. Verify the outcome by: Ingest a synthetic click event and confirm it appears in the designated Fabric analytics destination.
Question 874
At Cedarcrest Media live audience actions feed a Fabric real-time dashboard. The team proposes this approach: Use Microsoft Fabric Real-Time Intelligence eventstream capabilities when live events must feed governed Fabric analytics destinations. Which technical principle explains the choice?
Answer & Explanations
Correct answer: D
Extract-load-transform separates landing from later compute in a target platform capable of processing raw data. That explains a separate situation: At Meadowview Retail a cloud warehouse performs its own SQL cleaning after ingestion. The current case is: At Cedarcrest Media live audience actions feed a Fabric real-time dashboard. The actual mechanism is: Eventstreams can connect event sources to Fabric's real-time processing experiences and selected sinks.
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 Cedarcrest Media live audience actions feed a Fabric real-time dashboard. The actual mechanism is: Eventstreams can connect event sources to Fabric's real-time processing experiences and selected sinks.
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 Cedarcrest Media live audience actions feed a Fabric real-time dashboard. The actual mechanism is: Eventstreams can connect event sources to Fabric's real-time processing experiences and selected sinks.
Eventstreams can connect event sources to Fabric's real-time processing experiences and selected sinks. This principle supports the intervention: Use Microsoft Fabric Real-Time Intelligence eventstream capabilities when live events must feed governed Fabric analytics destinations. The relevant scenario is: At Cedarcrest Media live audience actions feed a Fabric real-time dashboard. Verify the result by: Ingest a synthetic click event and confirm it appears in the designated Fabric analytics destination.
Question 875
At Cedarcrest Media live audience actions feed a Fabric real-time dashboard. After implementing this approach—Use Microsoft Fabric Real-Time Intelligence eventstream capabilities when live events must feed governed Fabric analytics destinations—which result would most directly confirm success?
Answer & Explanations
Correct answer: B
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 Cedarcrest Media live audience actions feed a Fabric real-time dashboard. Use this acceptance check instead: Ingest a synthetic click event and confirm it appears in the designated Fabric analytics destination.
Ingest a synthetic click event and confirm it appears in the designated Fabric analytics destination. This tests the targeted action: Use Microsoft Fabric Real-Time Intelligence eventstream capabilities when live events must feed governed Fabric analytics destinations. The reason is: Eventstreams can connect event sources to Fabric's real-time processing experiences and selected sinks. The reported case is: At Cedarcrest Media live audience actions feed a Fabric real-time dashboard.
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 Cedarcrest Media live audience actions feed a Fabric real-time dashboard. Use this acceptance check instead: Ingest a synthetic click event and confirm it appears in the designated Fabric analytics destination.
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 Cedarcrest Media live audience actions feed a Fabric real-time dashboard. Use this acceptance check instead: Ingest a synthetic click event and confirm it appears in the designated Fabric analytics destination.
Question 876
At Cedarcrest Media live audience actions feed a Fabric real-time dashboard. Which shortcut most directly threatens the intended data outcome?
Answer & Explanations
Correct answer: 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 Cedarcrest Media live audience actions feed a Fabric real-time dashboard—reject: Add an empty Fabric workspace and assume external live events start arriving without connectors. The safer response is: Use Microsoft Fabric Real-Time Intelligence eventstream capabilities when live events must feed governed Fabric analytics destinations.
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 Cedarcrest Media live audience actions feed a Fabric real-time dashboard—reject: Add an empty Fabric workspace and assume external live events start arriving without connectors. The safer response is: Use Microsoft Fabric Real-Time Intelligence eventstream capabilities when live events must feed governed Fabric analytics destinations.
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 Cedarcrest Media live audience actions feed a Fabric real-time dashboard—reject: Add an empty Fabric workspace and assume external live events start arriving without connectors. The safer response is: Use Microsoft Fabric Real-Time Intelligence eventstream capabilities when live events must feed governed Fabric analytics destinations.
Add an empty Fabric workspace and assume external live events start arriving without connectors. The scenario is: At Cedarcrest Media live audience actions feed a Fabric real-time dashboard. The likely failure is: Real-time dashboards have no ingestion source. Instead: Use Microsoft Fabric Real-Time Intelligence eventstream capabilities when live events must feed governed Fabric analytics destinations.
Question 877
At Harborline Retail storefront activity requires near-live operational metrics. Which design or Azure data approach best fits this requirement?
Answer & Explanations
Correct answer: B
Use Azure Stream Analytics for a supported continuous stream query that filters and aggregates incoming events. This addresses a different situation: At Pinebrook Facilities sensors send readings to an event hub. The present case is: At Harborline Retail storefront activity requires near-live operational metrics. The relevant action here is: Use Microsoft Fabric Real-Time Intelligence eventstream capabilities when live events must feed governed Fabric analytics destinations.
Use Microsoft Fabric Real-Time Intelligence eventstream capabilities when live events must feed governed Fabric analytics destinations. This works because: Eventstreams can connect event sources to Fabric's real-time processing experiences and selected sinks. The scenario is: At Harborline Retail storefront activity requires near-live operational metrics. Verify the outcome by: Ingest a synthetic click event and confirm it appears in the designated Fabric analytics destination.
Use partitioned analytical files or tables for large date-filtered scans when data volume and query patterns justify it. This addresses a different situation: At Oakfield Utilities analysts frequently report one month of meter usage. The present case is: At Harborline Retail storefront activity requires near-live operational metrics. The relevant action here is: Use Microsoft Fabric Real-Time Intelligence eventstream capabilities when live events must feed governed Fabric analytics destinations.
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 Harborline Retail storefront activity requires near-live operational metrics. The relevant action here is: Use Microsoft Fabric Real-Time Intelligence eventstream capabilities when live events must feed governed Fabric analytics destinations.
Question 878
At Harborline Retail storefront activity requires near-live operational metrics. The team proposes this approach: Use Microsoft Fabric Real-Time Intelligence eventstream capabilities when live events must feed governed Fabric analytics destinations. Which technical principle explains the choice?
Answer & Explanations
Correct answer: B
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 Harborline Retail storefront activity requires near-live operational metrics. The actual mechanism is: Eventstreams can connect event sources to Fabric's real-time processing experiences and selected sinks.
Eventstreams can connect event sources to Fabric's real-time processing experiences and selected sinks. This principle supports the intervention: Use Microsoft Fabric Real-Time Intelligence eventstream capabilities when live events must feed governed Fabric analytics destinations. The relevant scenario is: At Harborline Retail storefront activity requires near-live operational metrics. Verify the result by: Ingest a synthetic click event and confirm it appears in the designated Fabric analytics destination.
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 Harborline Retail storefront activity requires near-live operational metrics. The actual mechanism is: Eventstreams can connect event sources to Fabric's real-time processing experiences and selected sinks.
A measure is evaluated under the report's current filter context while a calculated column is stored per row after refresh. That explains a separate situation: At Silverlake Services managers compare revenue by selected region. The current case is: At Harborline Retail storefront activity requires near-live operational metrics. The actual mechanism is: Eventstreams can connect event sources to Fabric's real-time processing experiences and selected sinks.
Question 879
At Harborline Retail storefront activity requires near-live operational metrics. After implementing this approach—Use Microsoft Fabric Real-Time Intelligence eventstream capabilities when live events must feed governed Fabric analytics destinations—which result would most directly confirm success?
Answer & Explanations
Correct answer: C
Import three synthetic source rows containing malformed dates and verify only validated clean records reach the reporting table. This tests a separate situation: At Cedarfield Finance external invoices need standard currency codes before reporting. The observed case is: At Harborline Retail storefront activity requires near-live operational metrics. Use this acceptance check instead: Ingest a synthetic click event and confirm it appears in the designated Fabric analytics destination.
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 Harborline Retail storefront activity requires near-live operational metrics. Use this acceptance check instead: Ingest a synthetic click event and confirm it appears in the designated Fabric analytics destination.
Ingest a synthetic click event and confirm it appears in the designated Fabric analytics destination. This tests the targeted action: Use Microsoft Fabric Real-Time Intelligence eventstream capabilities when live events must feed governed Fabric analytics destinations. The reason is: Eventstreams can connect event sources to Fabric's real-time processing experiences and selected sinks. The reported case is: At Harborline Retail storefront activity requires near-live operational metrics.
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 Harborline Retail storefront activity requires near-live operational metrics. Use this acceptance check instead: Ingest a synthetic click event and confirm it appears in the designated Fabric analytics destination.
Question 880
At Harborline Retail storefront activity requires near-live operational metrics. Which shortcut most directly threatens the intended data outcome?
Answer & Explanations
Correct answer: 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 Harborline Retail storefront activity requires near-live operational metrics—reject: Add an empty Fabric workspace and assume external live events start arriving without connectors. The safer response is: Use Microsoft Fabric Real-Time Intelligence eventstream capabilities when live events must feed governed Fabric analytics destinations.
Add an empty Fabric workspace and assume external live events start arriving without connectors. The scenario is: At Harborline Retail storefront activity requires near-live operational metrics. This undermines the mechanism: Eventstreams can connect event sources to Fabric's real-time processing experiences and selected sinks. Instead: Use Microsoft Fabric Real-Time Intelligence eventstream capabilities when live events must feed governed Fabric analytics destinations.
Deploy a static SQL query in a disconnected relational database and assume it automatically subscribes to the sensor stream. This concerns another issue: At Pinebrook Facilities sensors send readings to an event hub. In the stated case—At Harborline Retail storefront activity requires near-live operational metrics—reject: Add an empty Fabric workspace and assume external live events start arriving without connectors. The safer response is: Use Microsoft Fabric Real-Time Intelligence eventstream capabilities when live events must feed governed Fabric analytics destinations.
Expect a static imported dataset to show each operational write instantly without refresh. This concerns another issue: At Pinecrest Finance a morning report refresh is sufficient for yesterday's closing totals. In the stated case—At Harborline Retail storefront activity requires near-live operational metrics—reject: Add an empty Fabric workspace and assume external live events start arriving without connectors. The safer response is: Use Microsoft Fabric Real-Time Intelligence eventstream capabilities when live events must feed governed Fabric analytics destinations.
Microsoft Azure Data Fundamentals (DP-900) Practice Tests
- Microsoft DP-900 Practice Test 86 - 10 Questions (Last Reviewed 21-Oct-2026)
- Microsoft DP-900 Practice Test 87 - 10 Questions (Last Reviewed 20-Oct-2026)
- Microsoft DP-900 Practice Test 88 - 10 Questions (Last Reviewed 19-Oct-2026)
- Microsoft DP-900 Practice Test 89 - 10 Questions (Last Reviewed 18-Oct-2026)
- Microsoft DP-900 Practice Test 90 - 10 Questions (Last Reviewed 17-Oct-2026)