DP-700: Implementing Data Engineering Solutions Using Microsoft Fabric

Question

You have an Azure subscription that contains a blob storage account named sa1. sa1 contains two files named File1.csv and File2.csv.

You have a Fabric tenant that contains the items shown in the following table.

Question Image

You need to configure Pipeline1 to perform the following actions:

• At 2 PM each day, process File1.csv and load the file into flh1.

• At 5 PM each day, process File2.csv and load the file into flh1.

The solution must minimize development effort.

What should you use?

Explanation

Fabric data pipeline schedules support passing different parameter values at each scheduled run, so a single parameterized pipeline can be scheduled to run at 2 PM with File1.csv and again at 5 PM with File2.csv without building separate pipelines. Event-based triggers exist to react to file-arrival or other events rather than fixed daily clock times, so a schedule is the lower-effort choice.

Learn more

Run, schedule, or use events to trigger a pipeline

DP-700: Implementing Data Engineering Solutions Using Microsoft Fabric

AstroTutor

Notes

Readiness

QuestionQ4

Community Discussion