Describe Considerations for Real-Time Data Analytics DP-900 Practice Questions (Page 1)

Questions 1–5

1. 1foundation · easy

   Which Azure service is specifically designed for real-time data processing and analytics on streaming data?

   • AAzure Stream Analytics
   • BAzure Data Factory
   • CAzure Blob Storage
   • DAzure SQL Database
   Reveal Solution Discussion Select an answer first
2. 2expert · hard

   A retail chain has a data warehouse in Azure Synapse Analytics that is populated nightly. They now want to add real-time inventory tracking from their stores to prevent stockouts. They need to combine the real-time inventory data with historical sales data to forecast demand. The solution must minimize the number of services to manage. Which approach should they take?

   • AUse Azure Stream Analytics to process inventory updates and store results in Azure Data Lake Storage, then use Azure Data Factory to load into Synapse.
   • BReplace the nightly batch with a streaming solution that also loads historical sales data.
   • CIngest store inventory updates into Azure Synapse Analytics using streaming, and keep the nightly batch for historical sales.
   • DUse Azure Data Explorer for real-time inventory and keep Synapse for historical sales.
   Reveal Solution Discussion Select an answer first
4. 3foundation · easy

   What is a primary characteristic of streaming data processing?

   • AIt requires the data to be sorted before processing
   • BIt processes data continuously as it arrives, with low latency
   • CIt processes data in large, fixed-size batches at scheduled times
   • DIt only works with data that is stored in a data lake
   Reveal Solution Discussion Select an answer first
5. 4expert · hard

   A security operations center (SOC) needs to analyze firewall logs from multiple sources. The logs are streamed to Azure Event Hubs. Analysts need to run interactive queries on the last 24 hours of data with sub-second response times. They also need to retain the data for 90 days for compliance. Which solution should they use?

   • AUse Azure Stream Analytics to process logs and store results in Azure SQL Database.
   • BIngest the logs into Azure Data Explorer for interactive queries, and use Azure Blob Storage for long-term retention.
   • CStore all logs in Azure Blob Storage and use Azure Synapse Analytics for queries.
   • DKeep all logs in Azure Event Hubs for 90 days.
   Reveal Solution Discussion Select an answer first
6. 5expert · hard

   A manufacturing company has an existing Azure Synapse Analytics workspace used for batch reporting. They now want to add real-time monitoring of production line sensors. The monitoring data must be combined with historical production data for predictive maintenance. They want to avoid duplicating data storage. Which solution should they choose?

   • AUse Azure Event Hubs to store sensor data and query it directly.
   • BUse Azure Stream Analytics to process sensor data and store results in a separate database.
   • CIngest sensor data into Azure Synapse Analytics using a streaming pipeline, and query it alongside historical data.
   • DUse Azure Data Explorer for sensor data and keep Synapse for historical data.
   Reveal Solution Discussion Select an answer first