Fabric Data Engineer Pipeline Orchestration Quiz

1. What is the primary advantage of using parameterization in Fabric pipelines?

It increases pipeline execution speed

It allows reuse of pipelines with different input values without modification

It automatically encrypts sensitive data

It reduces storage costs

2. Which best practice should be followed when designing pipelines for production environments?

Use hard-coded values for all connection strings

Implement logging, error handling, and monitoring from the start

Avoid parameterization to simplify maintenance

Run all pipelines with maximum concurrency settings

Submit

4. What is data lineage in Fabric, and why is it important for pipeline management?

A chronological log of all user login attempts

A visual map showing data flow and transformations across pipelines

A backup strategy for disaster recovery

A security audit trail for compliance

5. Which Fabric workspace role is required to create and edit data pipelines?

Viewer

Member or Admin

Contributor

Guest

Submit

7. In Fabric pipelines, how do you handle errors and implement retry logic?

Pipelines automatically retry failed activities indefinitely

Configure error handling policies and retry counts on activities

Manually restart the pipeline after each failure

Errors cannot be handled in Fabric pipelines

8. What does the copy activity in Fabric Data Factory do?

Moves data from source to destination with optional transformations

Creates backup snapshots of databases

Generates statistical reports on data quality

Compresses files for archival

9. Which pattern should be used to handle late-arriving data in a time-sensitive pipeline?

Discard the data immediately

Implement a retry mechanism with configurable thresholds

Store data in a separate archive folder

Merge with historical data without validation

Submit

11. What is the primary purpose of data pipeline orchestration in Microsoft Fabric?

To schedule and automate data workflows across multiple sources and destinations

To encrypt data in transit between systems

To provide user interface design for dashboards

To manage database access permissions

12. Which data source type does Fabric Data Factory natively support for direct connections?

Only Azure SQL Database

Only on-premises SQL Server

Azure SQL, Lakehouse, SharePoint, and other cloud services

Only Excel files

13. In Fabric pipelines, what is the primary function of a filter activity?

To remove duplicate rows from data

To conditionally pass or block execution based on criteria

To compress data for storage

To merge multiple datasets

14. Which Fabric feature allows you to monitor pipeline execution and view run history?

Workspace settings

Monitoring hub

Data lineage

Capacity metrics

15. What does idempotency mean in the context of data pipeline design?

Running a pipeline multiple times produces identical results

The pipeline can only run once per day

Data must be encrypted before processing

The pipeline automatically scales resources

16. In Fabric, which activity type is used to execute Spark jobs or notebooks within a pipeline?

Copy activity

Notebook activity

SQL query activity

Wait activity

17. What is the purpose of a lookup activity in a Fabric data pipeline?

To retrieve metadata or reference data from a source

To delete records from a table

To encrypt sensitive information

To create backup copies of data

18. Which trigger type in Fabric Data Factory executes a pipeline on a predefined schedule?

Event trigger

Tumbling window trigger

Manual trigger

Storage event trigger

19. In Fabric pipelines, what does a control flow activity allow you to do?

Transform raw data into structured formats

Execute conditional logic and branching within a pipeline

Compress data files for storage

Create visual dashboards

20. Which Fabric component is used to define and execute data pipelines?

Data Activator

Data Factory

Real-Time Analytics

Notebooks

Fabric Data Engineer Data Pipeline Orchestration Quiz

1. What is the primary advantage of using parameterization in Fabric pipelines?

2.

What first name or nickname would you like us to use?

2. Which best practice should be followed when designing pipelines for production environments?

3. In Fabric, a ______ trigger fires a pipeline when a file is added or modified in a storage location.

4. What is data lineage in Fabric, and why is it important for pipeline management?

5. Which Fabric workspace role is required to create and edit data pipelines?

6. The ______ component in Fabric enables real-time monitoring and alerting on pipeline metrics.

7. In Fabric pipelines, how do you handle errors and implement retry logic?

8. What does the copy activity in Fabric Data Factory do?

9. Which pattern should be used to handle late-arriving data in a time-sensitive pipeline?

10. In Fabric, a ______ activity allows you to execute T-SQL or Spark SQL queries directly.

11. What is the primary purpose of data pipeline orchestration in Microsoft Fabric?

12. Which data source type does Fabric Data Factory natively support for direct connections?

13. In Fabric pipelines, what is the primary function of a filter activity?

14. Which Fabric feature allows you to monitor pipeline execution and view run history?

15. What does idempotency mean in the context of data pipeline design?

16. In Fabric, which activity type is used to execute Spark jobs or notebooks within a pipeline?

17. What is the purpose of a lookup activity in a Fabric data pipeline?

18. Which trigger type in Fabric Data Factory executes a pipeline on a predefined schedule?

19. In Fabric pipelines, what does a control flow activity allow you to do?

20. Which Fabric component is used to define and execute data pipelines?