Soru

Zorluk: OrtaData Integration and Analytical Storage

A healthcare provider is designing an analytical data platform to analyze telemetry from patient monitoring devices. The platform must meet the following requirements:
- Ingest telemetry data at a rate of 1500015{}000 events per second.
- Store raw events in Azure Data Lake Storage (ADLS) Gen2 in JSON format, with an expected annual volume of 100 TB100\text{ TB}.
- Enable analysts to perform ad-hoc, exploratory queries on the raw JSON data with a latency of less than 10 seconds10\text{ seconds}.
- Provide regional disaster resilience for the stored data.
- Minimize administrative overhead and run-time costs.
Which two configurations should you include in the design? (Select two.)

  1. Configure the ADLS Gen2 storage account to use Geo-redundant storage (GRS).Cevap
  2. Use Azure Synapse Analytics serverless SQL pools to query the raw JSON files in the data lake.Cevap
  3. C
    Provision an Azure Synapse dedicated SQL pool to load and query the raw JSON files.
  4. D
    Configure the ADLS Gen2 storage account to use Locally redundant storage (LRS).
  5. E
    Generate a Shared Access Signature (SAS) token with a 5-year lifetime to authorize analysts' ad-hoc query tools.

Cevap

To satisfy the requirements, the storage account must be configured to use Geo-redundant storage (GRS) for regional disaster resilience, and Azure Synapse Analytics serverless SQL pools must be used to perform ad-hoc queries on the raw JSON files stored in ADLS Gen2.
Geo-redundant storage (GRS) provides the required regional disaster resilience by asynchronously replicating data to a secondary region. Azure Synapse Analytics serverless SQL pools provide an on-demand, serverless query engine to run ad-hoc queries directly on the JSON files stored in ADLS Gen2, minimizing administrative overhead and costs since you only pay for queries executed.

Adım Adım Çözüm

1
Determine the data redundancy level required for regional disaster resilience.
Identify that Locally redundant storage (LRS) is insufficient as it does not survive a regional outage, whereas Geo-redundant storage (GRS) provides regional replication.
The solution must withstand a regional disaster, requiring data replication to a secondary region.
2
Determine the query model that minimizes administrative overhead and costs for ad-hoc exploratory queries on raw JSON files.
Select serverless SQL pools instead of dedicated SQL pools.
Serverless SQL pools charge on a per-query basis and do not require provisioning or managing compute clusters, which aligns with the cost-optimization and minimal-overhead goals.

Anahtar Kavram

Designing an analytical architecture using Azure Synapse serverless SQL pools for ad-hoc data lake queries and ADLS Gen2 with Geo-redundant storage (GRS) for disaster recovery.
Bu soruyu puanla