MCQs on Pipelines and Activities | Azure Data Factory MCQs Question

Azure Data Factory (ADF) is a cloud-based data integration service that orchestrates and automates data movement and transformation. This collection of Azure Data Factory MCQs questions explores key concepts such as pipelines, activities, and triggers. Learn about pipeline design, data movement activities, control flow logic, and scheduling for efficient data integration and processing in ADF.

MCQs

1. Understanding Pipelines, Activities, and Triggers

1. What is the purpose of a pipeline in Azure Data Factory?
   a) Storing data
   b) Orchestrating data movement and transformation activities
   c) Running SQL queries
   d) Managing virtual machines
2. Which of the following is an activity in Azure Data Factory?
   a) Azure Monitor
   b) Data transformation
   c) Data replication
   d) Data modeling
3. In Azure Data Factory, what is a trigger used for?
   a) Automating virtual network configurations
   b) Initiating a pipeline based on a specific schedule or event
   c) Storing large datasets
   d) Monitoring real-time data
4. Pipelines in Azure Data Factory are made up of:
   a) Triggers and flows
   b) Activities and datasets
   c) Virtual machines
   d) Key vaults and secrets
5. Which type of trigger in ADF starts a pipeline based on an event?
   a) Tumbling window trigger
   b) Event-based trigger
   c) Schedule-based trigger
   d) Time-based trigger
6. An activity in Azure Data Factory represents:
   a) A logical unit of work performed within a pipeline
   b) A monitoring tool for Azure resources
   c) A replication task
   d) A data storage unit

2. Designing Pipelines Using the ADF Studio

7. The ADF Studio interface is used to:
   a) Create and manage pipelines, datasets, and triggers
   b) Run SQL queries on Azure databases
   c) Manage virtual networks
   d) Configure Azure AD policies
8. Which section in ADF Studio helps monitor pipeline runs?
   a) Author
   b) Monitor
   c) Manage
   d) Data flow
9. In the pipeline design interface, activities are added to:
   a) Linked services
   b) Datasets
   c) The canvas area
   d) Azure Storage
10. What is the first step when creating a pipeline in ADF Studio?
    a) Adding a dataset
    b) Configuring linked services
    c) Defining activities
    d) Testing the pipeline
11. ADF Studio allows debugging pipelines by:
    a) Running the pipeline with sample data
    b) Editing the source code
    c) Creating multiple triggers
    d) Exporting the pipeline
12. Which feature in ADF Studio enables reusing pipeline configurations?
    a) Linked templates
    b) Parameters
    c) Debugging tools
    d) Activity logs

3. Data Movement Activities

13. The Copy activity in Azure Data Factory is used to:
    a) Move and transform data from source to destination
    b) Monitor network traffic
    c) Replicate Azure VMs
    d) Perform SQL transformations
14. What is the purpose of the Lookup activity in ADF?
    a) Retrieve a single row or value from a dataset
    b) Monitor data pipeline progress
    c) Store secrets securely
    d) Create a virtual machine
15. Which activity would you use to remove unwanted files from a data lake?
    a) Copy activity
    b) Delete activity
    c) Lookup activity
    d) Move activity
16. Data movement activities require:
    a) Virtual machine resources
    b) Linked services for source and destination configuration
    c) Azure Active Directory integration
    d) Blob encryption
17. The Copy activity supports:
    a) Only SQL-based transformations
    b) Data movement across different storage formats
    c) Real-time data replication only
    d) Monitoring of virtual networks
18. Which is NOT a data movement activity in ADF?
    a) Copy
    b) Lookup
    c) ForEach
    d) Delete

4. Control Flow Activities

19. What is the purpose of the ForEach activity in ADF?
    a) Iterating through items in a collection
    b) Managing linked services
    c) Debugging pipeline issues
    d) Configuring Azure AD authentication
20. The Until activity in ADF is used for:
    a) Looping until a condition is met
    b) Scheduling pipelines
    c) Managing dataset dependencies
    d) Encrypting data pipelines
21. What does the If Condition activity do in ADF?
    a) Filters data from a source dataset
    b) Performs conditional logic within a pipeline
    c) Encrypts pipeline configurations
    d) Manages virtual machine backups
22. Control flow activities enable:
    a) Orchestrating complex workflows in pipelines
    b) Monitoring real-time data
    c) Configuring Azure networking
    d) Storing large datasets
23. Which is an example of a control flow activity in ADF?
    a) Lookup
    b) Copy
    c) ForEach
    d) SQL transformation
24. How do you specify the order of activities in a pipeline?
    a) By using activity dependencies
    b) By configuring linked services
    c) By adding triggers
    d) By monitoring logs

5. Scheduling and Triggering Pipelines

25. Which trigger type schedules pipelines to run at regular intervals?
    a) Event-based trigger
    b) Tumbling window trigger
    c) Schedule-based trigger
    d) Activity-based trigger
26. Pipelines can be triggered manually by:
    a) Clicking “Trigger Now” in ADF Studio
    b) Creating a service principal
    c) Deleting existing triggers
    d) Running PowerShell scripts
27. Tumbling window triggers are useful for:
    a) Real-time data processing
    b) Scheduling non-overlapping pipeline runs
    c) Debugging pipelines
    d) Running event-based pipelines
28. Event-based triggers respond to:
    a) Data ingestion events like file uploads
    b) Scheduled intervals
    c) Looping conditions
    d) Network traffic changes
29. What is required to use triggers effectively in ADF?
    a) A configured Azure Function
    b) A defined pipeline and linked services
    c) An encrypted blob storage account
    d) Azure Policy integration
30. Triggers can be monitored in which ADF Studio section?
    a) Author
    b) Monitor
    c) Manage
    d) Data flow

Answers