Examkin

Soru

Zorluk: OrtaData Integration and Analytical Storage

A logistics company is designing an analytical data solution to review daily shipping routes and delivery anomalies. Approximately 50 GB50\text{ GB} of delivery log files in JSON format are uploaded hourly to an Azure Data Lake Storage Gen2 account. Data analysts need to run ad-hoc exploratory SQL queries on the raw JSON data to inspect specific routes. The solution must minimize provisioning and administrative overhead, and ensure compute resources are charged only when queries are executed. Which Azure service should you recommend in the design?

  1. A serverless SQL pool in Azure Synapse AnalyticsCevap
  2. B
    A dedicated SQL pool in Azure Synapse Analytics
  3. C
    An Azure SQL Database serverless database
  4. D
    An Azure Storage account using the Archive access tier queried via an Azure Databricks cluster

Cevap

A serverless SQL pool in Azure Synapse Analytics
A serverless SQL pool in Azure Synapse Analytics is the optimal choice because it is a query service over the data lake. It allows analysts to execute T-SQL queries directly against JSON data stored in Azure Data Lake Storage Gen2. There are no resources to provision, and billing is based purely on the amount of data processed by the queries, satisfying the requirement to minimize overhead and cost.

Adım Adım Çözüm

1
Analyze the ingestion and storage requirements.
JSON delivery logs totaling 50 GB50\text{ GB} daily are stored in Azure Data Lake Storage (ADLS) Gen2.
Understanding the source storage helps filter out services that cannot query raw data files directly.
2
Evaluate compute models based on cost and overhead.
Ad-hoc query patterns require a pay-per-query model with zero provisioning to minimize overhead.
Dedicated clusters or databases would incur idle costs and require schema setup.
3
Identify the optimal SQL query engine for ADLS Gen2 files.
Synapse serverless SQL pool supports direct T-SQL queries over JSON in ADLS Gen2 on-demand.
This matches the requirement to only pay for executed queries and minimize setup work.

Anahtar Kavram

Selecting serverless T-SQL execution over raw data lakes for ad-hoc exploratory queries
Tahmini Süre:1m 30s
Bu soruyu puanla

Konular

Data Integration and Analytical Storage

Bu konudan daha fazla soru