Examkin

Soru

Zorluk: OrtaData Integration and Analytical Storage

A digital marketing agency is designing an analytical data platform to query ad campaign click logs. The logs are uploaded daily as Parquet files to Azure Data Lake Storage (ADLS) Gen2, totaling 1.5 TB1.5\text{ TB} of new data per day. Analysts will run infrequent, ad-hoc exploratory T-SQL queries that must run directly against the storage account. The platform must survive a primary regional datacenter outage, minimize operational costs, and secure data access without utilizing long-lived access keys.

Which architecture should you recommend to meet these requirements?

  1. Azure Data Lake Storage Gen2 configured with Geo-Redundant Storage (GRS), queried using Azure Synapse serverless SQL pools with a system-assigned managed identity.Cevap
  2. B
    Azure Data Lake Storage Gen2 configured with Locally Redundant Storage (LRS), queried using Azure Synapse serverless SQL pools with a system-assigned managed identity.
  3. C
    Azure Data Lake Storage Gen2 configured with Geo-Redundant Storage (GRS), queried using Azure Synapse dedicated SQL pools with a Shared Access Signature (SAS) token.
  4. D
    Azure Data Lake Storage Gen2 configured with Locally Redundant Storage (LRS), queried using Azure Synapse dedicated SQL pools with a system-assigned managed identity.

Cevap

Azure Data Lake Storage Gen2 configured with Geo-Redundant Storage (GRS), queried using Azure Synapse serverless SQL pools with a system-assigned managed identity.
The correct architecture uses Geo-Redundant Storage (GRS) to ensure data survival during a primary datacenter outage, Azure Synapse serverless SQL pools to query the Parquet files on demand without paying for idle compute clusters, and a system-assigned managed identity to establish secure, passwordless authentication.

Adım Adım Çözüm

1
Determine the storage redundancy level required for regional disaster resilience.
Geo-Redundant Storage (GRS) is selected.
The scenario requires that the data must survive a primary regional datacenter outage. Locally Redundant Storage (LRS) is vulnerable to localized regional outages.
2
Select the appropriate analytical query tool based on the query patterns and cost constraints.
Azure Synapse serverless SQL pools are selected.
Since the T-SQL queries are ad-hoc and infrequent, using a dedicated SQL pool would lead to unnecessary compute costs for idle clusters. Serverless SQL pools charge per query based on data processed, aligning with the cost minimization goal.
3
Select the secure authorization mechanism for accessing the storage account.
System-assigned managed identity is selected.
The requirements dictate avoiding long-lived access keys or SAS tokens. Managed identities provide automated credentials rotation and eliminate stored secrets.

Anahtar Kavram

Selecting Azure analytical storage and query components based on redundancy, cost profiles, and access security requirements.
Tahmini Süre:1m 30s
Bu soruyu puanla

Konular

Data Integration and Analytical Storage

Bu konudan daha fazla soru