Manage Batches and Pipelines DP-203 Practice Questions (Page 4)

Questions 16–20

1. 16foundation · easy

   You need to run a pipeline every day at 6:00 AM. Which type of trigger should you create in Azure Data Factory?

   • ATumbling window trigger
   • BSchedule trigger
   • CEvent-based trigger
   • DManual trigger
   Reveal Solution Discussion Select an answer first
2. 17foundation · easy

   In Azure Synapse Analytics, which component is used to submit and manage Spark jobs?

   • ASpark job definition
   • BSpark pool
   • CLinked service
   • DIntegration runtime
   Reveal Solution Discussion Select an answer first
4. 18application · medium

   A data engineering team uses Azure Data Factory to develop pipelines. They want to implement version control for their pipeline artifacts so that they can track changes and collaborate effectively. The team uses Git for source control. What should they do?

   • AConfigure Git integration in Azure Data Factory and use branches for development, testing, and production.
   • BExport the pipeline JSON files manually and store them in a separate Git repository.
   • CUse Azure DevOps pipelines to copy the pipeline JSON files to a storage account and version them manually.
   • DUse the Data Factory UI to download the pipeline code and store it in a shared drive.
   Reveal Solution Discussion Select an answer first
5. 19application · medium

   A media company runs a batch pipeline that processes video files uploaded to Azure Blob Storage. The pipeline should run every hour to process any new files. However, the processing time varies, and sometimes it takes longer than an hour. The company wants to avoid overlapping runs and ensure that each file is processed exactly once. What should you configure?

   • AUse a storage event trigger that fires on blob creation and set the pipeline to use a 'Delete' activity after processing.
   • BUse a schedule trigger with an interval of 1 hour and set the pipeline concurrency to 1.
   • CUse a tumbling window trigger with a 1-hour interval and set the 'Max concurrency' to 1 and 'Rerun on failure' to true.
   • DUse a manual trigger and run the pipeline every hour using Azure Automation.
   Reveal Solution Discussion Select an answer first
6. 20foundation · easy

   What is the purpose of the 'Validate' activity in Azure Data Factory?

   • ATo copy data from one location to another
   • BTo transform data using a visual designer
   • CTo execute a stored procedure in a database
   • DTo check that a dataset exists and meets specified criteria before proceeding
   Reveal Solution Discussion Select an answer first