Examkin

Soru

Zorluk: OrtaData Integration and Analytical Storage

An insurance company is designing an analytical data platform to query historical claims data. The platform must ingest transaction data at a rate of 200 GB200\text{ GB} per day, resulting in a volume of 6 TB6\text{ TB} of Parquet files monthly. Data analysts will run ad-hoc, exploratory SQL queries against these files with unpredictable frequency and require a query latency of under one minute. The solution must minimize operational and compute costs when no queries are running. Additionally, the data storage must survive a complete regional datacenter outage. Which two configurations should you recommend in the design? (Select two.)

  1. An Azure Synapse Analytics serverless SQL pool to execute the ad-hoc queries.Cevap
  2. An Azure Data Lake Storage Gen2 account configured with Geo-Redundant Storage (GRS) to store the Parquet files.Cevap
  3. C
    An Azure Synapse Analytics dedicated SQL pool to host and query the data.
  4. D
    An Azure Data Lake Storage Gen2 account configured with Locally Redundant Storage (LRS) to store the Parquet files.

Cevap

The correct configurations are using an Azure Synapse Analytics serverless SQL pool and an Azure Data Lake Storage Gen2 account configured with Geo-Redundant Storage (GRS).
To support ad-hoc SQL queries on Parquet files in a data lake without ongoing operational compute costs when inactive, a serverless SQL pool in Azure Synapse Analytics is the most cost-effective and low-overhead solution. To survive a complete regional datacenter outage, the Azure Data Lake Storage Gen2 account must be configured with Geo-Redundant Storage (GRS), which replicates the data asynchronously to a secondary region.

Adım Adım Çözüm

1
Analyze the query and operational overhead requirements.
Identify that queries are ad-hoc and unpredictable, and compute costs must be minimized when inactive.
This determines whether to use a serverless query model (no continuous compute charges) or a dedicated persistent cluster.
2
Evaluate the storage redundancy needs for disaster recovery.
Determine that the storage account must withstand a complete regional datacenter outage.
This requires selecting a geo-redundant storage replication tier (GRS) rather than local replication (LRS).
3
Combine the selected services into a unified architecture.
Combine an Azure Synapse Analytics serverless SQL pool with a Geo-Redundant (GRS) Azure Data Lake Storage Gen2 account.
This fulfills all target architecture requirements with minimal cost and maximum durability.

Anahtar Kavram

Designing low-cost ad-hoc analytical query layers coupled with geo-resilient storage replication.
Tahmini Süre:2m 0s
Bu soruyu puanla

Konular

Data Integration and Analytical Storage

Bu konudan daha fazla soru