For IndividualsFor Educators
ExpertMinds LogoExpertMinds
ExpertMinds

Ace your certifications with Practice Exams and AI assistance.

  • Browse Exams
  • For Educators
  • Blog
  • Privacy Policy
  • Terms of Service
  • Cookie Policy
  • Support
  • AWS SAA Exam Prep
  • PMI PMP Exam Prep
  • CPA Exam Prep
  • GCP PCA Exam Prep

© 2026 TinyHive Labs. Company number 16262776.

    PracticeAzure Solutions Architect Expert (AZ-305)Azure Solutions Architect Expert AZ-305 Practice Exam 4Question 31
    Medium1 markMultiple Choice
    Domain 2.4: Design a Data Storage Solution for Non-Relational DataAnalyticsData ExplorerTime Series

    AZ-305 · Question 31 · Domain 2.4: Design a Data Storage Solution for Non-Relational Data

    A manufacturing company generates 10 TB of telemetry data daily from sensors on their assembly lines.

    The data is time-series in nature. Engineers need to run ad-hoc, complex analytical queries over billions of rows of this data to identify anomalies and optimize machine performance. The queries must return results in seconds.

    Which Azure data service is best optimized for this scenario?

    Answer options:

    A.

    Azure Cosmos DB

    B.

    Azure Data Explorer

    C.

    Azure SQL Database

    D.

    Azure Table Storage

    How to approach this question

    Keywords: 'time-series', 'telemetry', 'ad-hoc complex queries', 'billions of rows in seconds'. This is the exact use case for Azure Data Explorer (Kusto).

    Full Answer

    B.Azure Data Explorer✓ Correct
    Azure Data Explorer
    Azure Data Explorer (ADX) is a fast, fully managed data analytics service for real-time analysis on large volumes of data streaming from applications, websites, and IoT devices. It is specifically optimized for time-series and log data, allowing engineers to use KQL to query billions of records in seconds.

    Common mistakes

    Choosing Cosmos DB because it handles IoT data well. Cosmos DB is great for *ingesting* and serving individual IoT records (OLTP), but ADX is better for *analyzing* massive volumes of them (OLAP).
    Question 30All questionsQuestion 32

    Practice the full Azure Solutions Architect Expert AZ-305 Practice Exam 4

    55 questions · hints · full answers · grading

    Sign up freeTake the exam

    More questions from this exam

    Q01CASE STUDY: Tailspin Toys Tailspin Toys is a global manufacturing company with 50,000 employees ...MediumQ02CASE STUDY: Tailspin Toys Tailspin Toys is a global manufacturing company with 50,000 employees ...MediumQ03CASE STUDY: Tailspin Toys Tailspin Toys is a global manufacturing company with 50,000 employees ...HardQ04CASE STUDY: Tailspin Toys Tailspin Toys is a global manufacturing company with 50,000 employees ...MediumQ05CASE STUDY: Tailspin Toys Tailspin Toys is a global manufacturing company with 50,000 employees ...Hard
    View all 55 questions →