Answer-first summary for fast verification
Answer: Data read and write throughput in Azure SQL Database and Azure Data Lake Storage Gen2.
To ensure the efficiency and reliability of data movement in a data pipeline, you should monitor the data read and write throughput in both the source (Azure SQL Database) and the destination (Azure Data Lake Storage Gen2). This will help you identify any bottlenecks or performance issues that may affect the data movement. Option B is related to the failure 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 responsible for monitoring the performance of a data pipeline that uses Azure Data Factory to move data from Azure SQL Database to Azure Data Lake Storage Gen2. Which of the following metrics should you monitor to ensure the efficiency and reliability of the data movement?
A
Data read and write throughput in Azure SQL Database and Azure Data Lake Storage Gen2.
B
Number of failed data factory pipelines and activities.
C
CPU and memory usage of the Azure Data Factory service.
D
Number of data factory triggers and their execution status.
No comments yet.