Examkin

Soru

Zorluk: OrtaData Integration and Analytical Storage

A research institute is designing an analytical data platform to explore genomic metadata stored in Azure Data Lake Storage (ADLS) Gen2. The solution must meet the following requirements:

* Volume: 15 TB15 \text{ TB} of genomics metadata files stored in CSV and Parquet formats.
* Velocity/Ingestion: New research datasets totaling 200 GB200 \text{ GB} are uploaded in a batch once per week.
* Query latency: Analytical queries are sporadic, executed by researchers on an ad-hoc basis, and can tolerate a latency of up to 10 seconds10 \text{ seconds}.
* Resilience: The storage must remain available and suffer no data loss in the event of a physical datacenter outage within the primary region.
* Security: The query engine must authenticate to the storage account using dynamic, short-lived permissions without utilizing account keys or static credentials.

Which solution should you recommend to meet the requirements?

  1. A
    Query the files using Azure Synapse dedicated SQL pools, configure the ADLS Gen2 account to use zone-redundant storage (ZRS), and authenticate using Microsoft Entra ID pass-through.
  2. B
    Query the files using Azure Synapse serverless SQL pools, configure the ADLS Gen2 account to use locally redundant storage (LRS), and authenticate using Microsoft Entra ID pass-through.
  3. Query the files using Azure Synapse serverless SQL pools, configure the ADLS Gen2 account to use zone-redundant storage (ZRS), and authenticate using Microsoft Entra ID pass-through.Cevap
  4. D
    Query the files using Azure Synapse serverless SQL pools, configure the ADLS Gen2 account to use zone-redundant storage (ZRS), and access the storage using a Shared Access Signature (SAS) token configured with a three-year expiration.

Cevap

Query the files using Azure Synapse serverless SQL pools, configure the ADLS Gen2 account to use zone-redundant storage (ZRS), and authenticate using Microsoft Entra ID pass-through.
Querying ad-hoc CSV and Parquet files in a data lake is best served by Azure Synapse serverless SQL pools because compute costs are incurred only for data processed by queries. Zone-redundant storage (ZRS) replicates data across three Availability Zones in the primary region, safeguarding against physical datacenter failures. Microsoft Entra ID pass-through provides secure, keyless authentication utilizing the user's security identity.

Adım Adım Çözüm

1
Analyze the access pattern and cost requirements.
Since queries are sporadic and ad-hoc on files stored in ADLS Gen2, Azure Synapse serverless SQL pools should be chosen over dedicated SQL pools to avoid paying for idle compute resources.
Serverless SQL pools charge only per TB of data processed, minimizing costs for irregular query patterns.
2
Evaluate the resiliency requirement.
Select Zone-Redundant Storage (ZRS) for the ADLS Gen2 storage account.
ZRS replicates data synchronously across three availability zones in the primary region, ensuring availability during a physical datacenter failure, unlike LRS which is localized to a single datacenter.
3
Determine the authentication mechanism.
Choose Microsoft Entra ID pass-through authentication.
Microsoft Entra ID pass-through provides dynamic, role-based access control without hardcoded credentials or long-lived SAS tokens, satisfying the security requirements.

Anahtar Kavram

Selecting cost-effective query engines, secure authentication mechanisms, and resilient storage configurations for Azure analytical solutions.
Tahmini Süre:1m 30s
Bu soruyu puanla

Konular

Data Integration and Analytical Storage

Bu konudan daha fazla soru