Examkin

Soru

Zorluk: OrtaData Integration and Analytical Storage

An energy utility company is designing an analytical platform to process smart meter readings. The platform receives approximately 1010 million telemetry payloads per day, which are consolidated and written as Parquet files every hour to an Azure Data Lake Storage (ADLS) Gen2 account. Analysts need to perform occasional, ad-hoc exploratory SQL queries on the historical Parquet data to identify usage anomalies. The solution must survive a primary region datacenter outage, minimize operational costs, and avoid the use of credentials with a lifetime exceeding 3030 days. Which analytical and storage configuration should you recommend?

  1. Use Azure Synapse Analytics serverless SQL pools to query the Parquet files directly, store the data in an ADLS Gen2 account configured with Geo-Redundant Storage (GRS), and control access using Microsoft Entra ID authentication.Cevap
  2. B
    Use Azure Synapse Analytics dedicated SQL pools to query the Parquet files directly, store the data in an ADLS Gen2 account configured with Geo-Redundant Storage (GRS), and control access using Microsoft Entra ID authentication.
  3. C
    Use Azure Synapse Analytics serverless SQL pools to query the Parquet files directly, store the data in an ADLS Gen2 account configured with Locally Redundant Storage (LRS), and control access using Microsoft Entra ID authentication.
  4. D
    Use Azure Synapse Analytics serverless SQL pools to query the Parquet files directly, store the data in an ADLS Gen2 account configured with Geo-Redundant Storage (GRS), and control access using a Shared Access Signature (SAS) token configured with a 55-year lifetime.

Cevap

Use Azure Synapse Analytics serverless SQL pools to query the Parquet files directly, store the data in an ADLS Gen2 account configured with Geo-Redundant Storage (GRS), and control access using Microsoft Entra ID authentication.
The correct solution uses Azure Synapse Analytics serverless SQL pools, which are ideal for ad-hoc, cost-effective exploratory queries since charges are based on the volume of data processed by each query. Using Geo-Redundant Storage (GRS) ensures the data is replicated to a secondary region to survive a primary region outage. Utilizing Microsoft Entra ID authentication provides secure access control without the risk of long-lived Shared Access Signatures.

Adım Adım Çözüm

1
Analyze the query pattern and compute model.
Identify that occasional, ad-hoc queries are best served by a serverless SQL pool rather than a dedicated SQL pool to avoid continuous running costs.
Serverless SQL pools charge only per query based on data processed, whereas dedicated SQL pools charge for provisioned compute running continuously.
2
Evaluate the storage redundancy requirement for disaster recovery.
Select Geo-Redundant Storage (GRS) over Locally Redundant Storage (LRS).
The system must survive a primary region datacenter outage, which requires replicating data to a paired secondary region.
3
Evaluate the security and access control mechanism.
Choose Microsoft Entra ID authentication instead of a long-lived SAS token.
Microsoft Entra ID provides identity-based, token-controlled access that aligns with credential lifetime and rotation best practices, whereas a long-lived SAS token presents high security risks.

Anahtar Kavram

Selecting cost-effective analytics services (serverless vs dedicated pools), appropriate storage redundancy (GRS vs LRS), and secure access mechanisms (Entra ID vs SAS) for data lake integration.
Bu soruyu puanla

Konular

Data Integration and Analytical Storage

Bu konudan daha fazla soru