Crucial Exams

Microsoft Azure Solutions Architect Expert AZ-305 Practice Question

A factory ingests 5 million JSON telemetry events per hour (~15 GB), each with 50-100 varying properties. Engineers need ad-hoc queries on the latest seven days, returning results in under two seconds when filtering by deviceId and any property. Data older than 30 days moves to Azure Data Lake Storage. For hot data, select a storage service that 1) auto-indexes all JSON properties, 2) offers single-digit-millisecond read/write latency globally with SLA, and 3) provides elastic throughput with minimal admin. Which service meets these needs?

  • Azure Table storage with partition and row key based on deviceId and timestamp

  • Azure Data Lake Storage Gen2 with hierarchical namespace enabled

  • Azure Cosmos DB using the Core (SQL) API with provisioned or autoscale throughput

  • Azure SQL Database Hyperscale tier with JSON columns and secondary indexes

Microsoft Azure Solutions Architect Expert AZ-305
Design data storage solutions
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot