An online multiplayer gaming platform is designing a telemetry analytics pipeline on Azure to ingest game session event logs. The platform needs to store raw events in JSON format and enable data analysts to run ad-hoc exploratory SQL queries on the files. The data volume fluctuates significantly, and the platform wants to avoid paying for compute resources when queries are not executing. Additionally, the storage solution must survive a regional datacenter outage, and the legacy ingestion service must authenticate to the storage account using a Shared Access Signature (SAS) token with a lifetime of no more than 4 hours.
Which of the following components should you include in the architecture to satisfy these requirements? (Select TWO.)
- Azure Synapse Analytics serverless SQL pools to query the JSON filesAnswer
- Azure Data Lake Storage Gen2 configured with Geo-Redundant Storage (GRS)Answer
- CAzure Synapse Analytics dedicated SQL pools with a provisioned DW100c cluster
- DAzure Data Lake Storage Gen2 configured with Locally Redundant Storage (LRS)
- EA Shared Access Signature (SAS) token configured with an unlimited lifetime duration
Answer
Azure Synapse Analytics serverless SQL pools and Azure Data Lake Storage Gen2 configured with Geo-Redundant Storage (GRS)
The design calls for ad-hoc exploratory queries on JSON data directly in the data lake without paying for idle resources, making serverless SQL pools the optimal selection as they scale dynamically and bill based on data processed. The requirement to survive a regional datacenter outage is met by selecting Geo-Redundant Storage (GRS), which replicates the files to a paired secondary region.
Step-by-Step Solution
Key Concept
Designing serverless analytical query mechanisms coupled with geo-replicated storage to satisfy cost, performance, and disaster recovery SLA constraints.
Estimated Time:2m 30s