Examkin

Question

Difficulty: MediumData Integration and Analytical Storage

A utility provider is designing an analytical solution to monitor power grid telemetry. The solution must process daily load profile data stored as Apache Parquet files in Azure Data Lake Storage Gen2. Data analysts need to run ad-hoc, exploratory queries across these files to identify consumption anomalies. The solution must minimize administrative overhead, avoid persistent compute costs, and ensure that the analytical and underlying storage components survive a primary datacenter outage within the region. Which configuration should you recommend?

  1. Azure Synapse serverless SQL pool querying files in a Zone-Redundant Storage (ZRS) Azure Data Lake Storage Gen2 account using Microsoft Entra ID authenticationAnswer
  2. B
    Azure Synapse dedicated SQL pool querying files in a Zone-Redundant Storage (ZRS) Azure Data Lake Storage Gen2 account using PolyBase staging
  3. C
    Azure Synapse serverless SQL pool querying files in a Locally Redundant Storage (LRS) Azure Data Lake Storage Gen2 account
  4. D
    Azure Synapse serverless SQL pool accessing the storage account via a Shared Access Signature (SAS) token configured with a five-year validity period directly on the token URI

Answer

The configuration using an Azure Synapse serverless SQL pool to query files in a Zone-Redundant Storage (ZRS) Azure Data Lake Storage Gen2 account using Microsoft Entra ID authentication.
The correct configuration uses an Azure Synapse serverless SQL pool to query the Parquet files in a Zone-Redundant Storage (ZRS) Azure Data Lake Storage Gen2 account. Serverless SQL pools require zero setup and charge only for the data processed, which eliminates persistent compute costs and minimizes administrative overhead. Zone-Redundant Storage replicates data across three separate physical datacenters within the region, ensuring survival of a primary datacenter outage.

Step-by-Step Solution

1
Identify the analytical query model needed.
Since the query requirement is ad-hoc, exploratory, and must minimize persistent compute costs and overhead, a serverless SQL pool is preferred over a dedicated SQL pool.
Serverless SQL pools scale automatically and charge only per query, whereas dedicated SQL pools incur continuous hosting costs.
2
Determine the storage redundancy model.
To survive a primary datacenter outage within the region, Zone-Redundant Storage (ZRS) must be used instead of Locally Redundant Storage (LRS).
ZRS replicates data across three separate Availability Zones within the region, while LRS replicates only within a single datacenter.
3
Evaluate authentication and security.
Using Microsoft Entra ID authentication is secure, whereas using a long-lived SAS token without a stored access policy introduces security risks and management issues.
Entra ID integrates identity governance, while long-lived SAS tokens on the URI are difficult to rotate or revoke.

Key Concept

Selecting the appropriate analytical query engine and storage redundancy model based on cost, management overhead, and resilience requirements.
Estimated Time:1m 30s
Rate this question

Topics

Data Integration and Analytical Storage

More questions from this topic