Answer-first summary for fast verification
Answer: Data read throughput in Azure SQL Data Warehouse and data write throughput in Azure Blob Storage.
To ensure the efficiency and reliability of data movement in a data pipeline, you should monitor the data read throughput in the source (Azure SQL Data Warehouse) and the data write throughput in the destination (Azure Blob Storage). This will help you identify any bottlenecks or performance issues that may affect the data movement. Option B is related to the execution of data factory pipelines and activities, but it does not directly measure the performance of data movement. Option C is related to the performance of the Azure Data Factory service itself, not the data movement. Option D is related to the triggers and their execution status, which is not directly related to the performance of data movement.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
You are tasked with monitoring the performance of a data pipeline that uses Azure Data Factory to move data from Azure SQL Data Warehouse to Azure Blob Storage. Which of the following metrics should you monitor to ensure the efficiency and reliability of the data movement?
A
Data read throughput in Azure SQL Data Warehouse and data write throughput in Azure Blob Storage.
B
Number of data factory pipelines and activities executed.
C
CPU and memory usage of the Azure Data Factory service.
D
Number of data factory triggers and their execution status.
No comments yet.