Examkin

Question

Difficulty: MediumData Integration and Analytical Storage

An enterprise is designing a telemetry and analytical storage solution on Azure. The solution must support ad-hoc exploratory queries on 5 TB5 \text{ TB} of daily log files in CSV and Parquet formats stored in Azure Data Lake Storage Gen2 (ADLS Gen2). The queries will be run sporadically throughout the day.

The design must meet the following requirements:
- Minimize provisioning and compute cost when no queries are running.
- Ensure that the primary storage account survives a regional datacenter outage.
- Secure access to ADLS Gen2 using Shared Access Signatures (SAS) that can be easily revoked if compromised.

Which of the following configurations should you include in the solution design? (Select TWO.)

  1. Configure the ADLS Gen2 storage account to use Geo-redundant storage (GRS).Answer
  2. Use Azure Synapse Analytics serverless SQL pools to query the data.Answer
  3. C
    Use Azure Synapse Analytics dedicated SQL pools to query the data.
  4. D
    Configure the ADLS Gen2 storage account to use Locally redundant storage (LRS).
  5. E
    Generate Shared Access Signatures (SAS) with a lifetime of one year directly linked to the storage account key.

Answer

Configure the Azure Data Lake Storage Gen2 storage account to use Geo-redundant storage (GRS), and use Azure Synapse Analytics serverless SQL pools to query the data.
Using serverless SQL pools in Azure Synapse Analytics is the most cost-effective choice for sporadic, ad-hoc queries because it uses a pay-per-query model and has no idle resources to pay for. Configuring Geo-redundant storage (GRS) ensures that the data is replicated to a secondary region, providing protection against regional outages.

Step-by-Step Solution

1
Evaluate query requirement and cost profile.
Identify that the query patterns are ad-hoc and sporadic, meaning a serverless, pay-per-query model (serverless SQL pools) is much more cost-effective than a continuously running cluster (dedicated SQL pools).
This minimizes compute costs when no queries are running, addressing the first requirement.
2
Evaluate storage redundancy options for disaster recovery.
Determine that Locally redundant storage (LRS) is insufficient as it is bound to a single datacenter, whereas Geo-redundant storage (GRS) provides secondary-region replication.
This guarantees storage availability during a regional datacenter outage, addressing the second requirement.
3
Analyze secure token creation best practices.
Identify that generating a long-lived SAS directly linked to account keys lacks an easy revocation mechanism. Best practice demands stored access policies for easy revocation.
This ensures access can be easily revoked, addressing the security requirement.

Key Concept

Selecting cost-effective serverless analytics services and regional storage replication strategies on Azure.
Rate this question

Topics

Data Integration and Analytical Storage

More questions from this topic