Question 1 of 30
A data engineer is tasked with orchestrating a data pipeline using Azure Data Factory (ADF) to move data from an on-premises SQL Server database to an Azure Blob Storage account. 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 Azure Data Factory?
Use a stored procedure in the SQL Server to track the last processed timestamp and pass this value as a parameter to the ADF pipeline to filter records for the incremental load.
Create a new dataset in ADF that includes all records from the SQL Server database and schedule the pipeline to run every hour.
Utilize Azure Functions to periodically check the SQL Server for new records and trigger the ADF pipeline when new data is available.
Set up a copy activity in ADF that copies all data from the SQL Server to Blob Storage without any filtering.

Preparing for Microsoft DP-900 Microsoft Azure Data Fundamentals? 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