Develop a Stream Processing Solution DP-203 Practice Questions (Page 4)

Questions 16–20

1. 16foundation · easy

   Which sink in Azure Stream Analytics supports upsert operations natively?

   • AAzure Data Lake Storage Gen2
   • BAzure SQL Database
   • CAzure Blob Storage
   • DAzure Event Hubs
   Reveal Solution Discussion Select an answer first
2. 17foundation · easy

   When processing data within a single partition in a stream, what is a common benefit?

   • AHigher throughput than multi-partition processing
   • BNo need for checkpointing
   • CAutomatic schema validation
   • DSimplified state management because events are processed in order
   Reveal Solution Discussion Select an answer first
4. 18application · medium

   A retail company ingests clickstream events into an Event Hub with 32 partitions. They use Azure Stream Analytics to count events per product category per minute. The job's output is a single Azure SQL Database table. The ingestion rate is expected to triple in the next month. What should they do to ensure the job can handle the increased load?

   • AUse a tumbling window of 5 minutes instead of 1 minute to reduce the number of output records.
   • BIncrease the number of Stream Analytics streaming units to provide more processing capacity.
   • CChange the output to use a blob storage and then load into SQL Database periodically.
   • DReduce the number of Event Hub partitions to 8 to decrease the processing overhead.
   Reveal Solution Discussion Select an answer first
5. 19foundation · easy

   In Spark Structured Streaming, what is the primary abstraction used to represent a stream of data?

   • ADataset
   • BRDD
   • CDataFrame
   • DDStream
   Reveal Solution Discussion Select an answer first
6. 20application · medium

   A gaming company uses Azure Stream Analytics to process player actions. Each player's actions are sent to a specific partition in Event Hubs based on the player ID. The query needs to calculate a per-player session duration. The job is currently running with 6 SUs and the Event Hubs has 6 partitions. The company wants to ensure that all events for a single player are processed by the same SU to maintain session state. What should they do?

   • AUse PARTITION BY playerId in the query to ensure all events for a player are processed in the same partition.
   • BIncrease the number of SUs to 12 to ensure each partition has enough compute.
   • CEnsure the Event Hubs partition key is set to the player ID and use a single SU.
   • DUse a tumbling window with a large duration to capture the entire session.
   Reveal Solution Discussion Select an answer first