DP-700 Practice Test

DP-700 Practice Test practice questions, page 6 of 7, with answer review and explanations.

Question 26

You have a Fabric workspace named Workspace1 that contains a data pipeline named Pipeline1 and a lakehouse named Lakehouse1. You have a deployment pipeline named deployPipeline1 that deploys Workspace1 to Workspace2. You restructure Workspace1 by adding a folder named Folder1 and moving Pipeline1 to Folder1. You use deployPipeline1 to deploy Workspace1 to Workspace2. What occurs to Workspace2?

  1. Folder1 is created, Pipeline1 moves to Folder1, and Lakehouse1 is deployed.
  2. Only Pipeline1 and Lakehouse1 are deployed.
  3. Folder1 is created, and Pipeline1 and Lakehouse1 move to Folder1.
  4. Only Folder1 is created and Pipeline1 moves to Folder1.

Question 27

Your company has a team of developers. The team creates Python libraries of reusable code that is used to transform data. You create a Fabric workspace name Workspace1 that will be used to develop extract, transform, and load (ETL) solutions by using notebooks. You need to ensure that the libraries are available by default to new notebooks in Workspace1. Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Question 28

You have a Fabric workspace that contains a lakehouse and a notebook named Notebook1. Notebook1 reads data into a DataFrame from a table named Table1 and applies transformation logic. The data from the DataFrame is then written to a new Delta table named Table2 by using a merge operation. You need to consolidate the underlying Parquet files in Table1. Which command should you run?

  1. VACUUM
  2. BROADCAST
  3. OPTIMIZE
  4. CACHE

Question 29

You have five Fabric workspaces. You are monitoring the execution of items by using Monitoring hub. You need to identify in which workspace a specific item runs. Which column should you view in Monitoring hub?

  1. Start time
  2. Capacity
  3. Activity name
  4. Submitter
  5. Item type
  6. Job type
  7. Location

Question 30

You have a Fabric workspace that contains a warehouse named DW1. DW1 is loaded by using a notebook named Notebook1. You need to identify which version of Delta was used when Notebook1 was executed. What should you use?

  1. Real-Time hub
  2. OneLake data hub
  3. the Admin monitoring workspace
  4. Fabric Monitor
  5. the Microsoft Fabric Capacity Metrics app