Orchestrate Processes DP-700 Practice Questions (Page 3)

Questions 11–15

1. 11foundation · easy

   How are parameters used in a Microsoft Fabric pipeline?

   • ATo set the pipeline's schedule
   • BTo define the pipeline's storage location
   • CTo pass values to activities within the pipeline at runtime
   • DTo control the pipeline's logging level
   Reveal Solution Discussion Select an answer first
2. 12application · medium

   A data engineering team needs to ingest data from a SharePoint list and an on-premises SQL Server database, then combine the data into a single table in a Fabric lakehouse. The transformation logic is simple and the team wants to minimize the number of artifacts to manage. What should they use?

   • AA pipeline with a single Copy activity that uses a query to join the two sources
   • BA pipeline with a Copy activity for each source, followed by a Notebook that joins the data
   • CA Dataflow Gen 2 that connects to both sources and loads the combined output to the lakehouse
   • DA Notebook that uses Spark to read from both sources and write the combined result
   Reveal Solution Discussion Select an answer first
4. 13foundation · easy

   Which Microsoft Fabric tool is best described as a low-code data transformation solution that uses Power Query?

   • AKQL database
   • BPipeline
   • CDataflow Gen 2
   • DNotebook
   Reveal Solution Discussion Select an answer first
5. 14foundation · easy

   What is the primary purpose of a pipeline in Microsoft Fabric?

   • ATo store and manage data in a columnar format
   • BTo orchestrate and manage the execution of data activities
   • CTo perform interactive data exploration using SQL
   • DTo provide a low-code interface for data transformation
   Reveal Solution Discussion Select an answer first
6. 15foundation · easy

   What is an event-based trigger in Microsoft Fabric?

   • AA trigger that runs a process at a fixed time every day
   • BA trigger that runs a process when a pipeline completes successfully
   • CA trigger that runs a process manually
   • DA trigger that starts a process when a specific event occurs, such as a new file being created
   Reveal Solution Discussion Select an answer first