Question 1 of 30
A data engineer is tasked with designing a data pipeline in Azure Data Factory (ADF) to move data from an on-premises SQL Server database to an Azure SQL Database. The data engineer needs to ensure that the pipeline can handle incremental data loads efficiently. To achieve this, they decide to implement a watermarking strategy. Which of the following approaches best describes how to implement this strategy effectively in ADF?
Use a stored procedure in the on-premises SQL Server to track the last processed timestamp and pass this value as a parameter to the ADF pipeline during each run.
Create a separate Azure Blob Storage file to store the last processed record ID and read from this file at the beginning of each pipeline execution.
Utilize the built-in ADF activity to automatically track the last processed row and manage the incremental load without any additional configuration.
Schedule the ADF pipeline to run at fixed intervals and load all records each time, ignoring previously processed data.

Preparing for Microsoft AI-102 Designing and Implementing a Microsoft Azure AI Solution? Now land the interview.

73% of qualified candidates get rejected because of weak resumes. Build an ATS-optimized, recruiter-ready resume in under 5 minutes - free to start.

Build My Resume Free