ExpertMedium1 markMultiple Choice
AZ-305 · Question 29 · Domain 2.4: Non-Relational Data Storage
Your company generates 10 TB of application log data daily.
You need to design a solution to ingest, store, and analyze this data. The analytics team requires the ability to run highly complex, ad-hoc queries over billions of rows of time-series data with sub-second response times. They are proficient in Kusto Query Language (KQL).
Which TWO Azure services are best suited for this architecture? (Select TWO)
Your company generates 10 TB of application log data daily.
You need to design a solution to ingest, store, and analyze this data. The analytics team requires the ability to run highly complex, ad-hoc queries over billions of rows of time-series data with sub-second response times. They are proficient in Kusto Query Language (KQL).
Which TWO Azure services are best suited for this architecture? (Select TWO)
Answer options:
A.
Azure SQL Database
B.
Azure Data Explorer
C.
Azure Cosmos DB
D.
Azure Event Hubs
E.
Azure Cache for Redis
How to approach this question
Identify the ingestion service for massive data streams and the analytical engine that natively uses KQL.
Full Answer
Azure Data Explorer (ADX) is a highly scalable data exploration service specifically designed for log and telemetry data. It provides sub-second query performance over billions of records and natively uses Kusto Query Language (KQL). To handle the massive ingestion rate (10 TB daily), Azure Event Hubs should be used as the streaming ingestion buffer, which natively integrates with ADX.
Common mistakes
Selecting Synapse Analytics. While Synapse is for analytics, ADX is specifically optimized for time-series/log data and KQL.
Practice the full Azure Solutions Architect Expert AZ-305 Practice Exam 2
55 questions · hints · full answers · grading
More questions from this exam
Q01Fabrikam Inc. is a global financial services company with 200 Azure subscriptions managed via a c...HardQ02A healthcare organization has 500 on-premises Windows Server VMs and 300 Azure VMs. They are impl...HardQ03You are designing a security monitoring solution using Microsoft Sentinel.
The compliance depar...EasyQ04Your company has a microservices application deployed across multiple Azure App Service instances...MediumQ05A defense contractor is migrating to Microsoft 365 and Azure. They have a strict security policy ...Hard