Question

Difficulty: EasyData Integration and Analytical Storage

A retail business requires a daily ingestion pipeline to transfer 50 GB50\text{ GB} of operational log files from on-premises servers to Azure. The pipeline runs once every 24 hours. The storage solution must persist the logs in a hierarchical structure and guarantee data durability even during a regional datacenter disaster. Additionally, the data science team needs to perform infrequent, exploratory analysis directly on these files. Which two architectural choices should you make to meet these requirements? (Select two.)

  1. Azure Data Factory to manage and run the daily transfer pipelineAnswer
  2. Azure Data Lake Storage Gen2 using Geo-Redundant Storage (GRS)Answer
  3. C
    Azure Data Lake Storage Gen2 using Locally Redundant Storage (LRS)
  4. D
    An Azure Synapse Dedicated SQL Pool to run ad-hoc queries on the raw files

Answer

Azure Data Factory and Azure Data Lake Storage Gen2 using Geo-Redundant Storage (GRS)
To orchestrate the daily transfer pipeline, Azure Data Factory is the correct choice. To survive a regional outage, the storage must be configured with Geo-Redundant Storage (GRS) since it replicates the data to a secondary region.

Step-by-Step Solution

1
Identify the orchestration service required for daily batch data movement from an on-premises database to Azure.
Azure Data Factory is selected because it is designed to orchestrate and execute batch data ingestion pipelines.
This meets the daily pipeline orchestration requirement.
2
Determine the required replication strategy for Azure Data Lake Storage Gen2 to survive a regional outage.
Geo-Redundant Storage (GRS) is selected.
GRS replicates data to a secondary region, ensuring durability during a regional disaster, whereas LRS only replicates within a single datacenter.

Key Concept

Designing batch data integration pipelines and choosing disaster-resilient analytical storage replication.
Rate this question