Microsoft DP-700 Practice Exam Questions

Microsoft DP-700 Sample Question Answers

Question # 1

You have a Fabric workspace that contains a takehouse and a semantic model named Model1. You use a notebook named Notebook1 to ingest and transform data from an external data source. You need to execute Notebook1 as part of a data pipeline named Pipeline1. The process must meet the following requirements: • Run daily at 07:00 AM UTC. • Attempt to retry Notebook1 twice if the notebook fails. • After Notebook1 executes successfully, refresh Model1. Which three actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

A. Set the Retry setting of the Notebook activity to 2. 
B. Place the Semantic model refresh activity after the Notebook activity and link the activities by using an On completion condition.
C. Place the Semantic model refresh activity after the Notebook activity and link the activities by using the On success condition. 
D. From the Schedule settings of Notebook1, set the time zone to UTC. 
E. From the Schedule settings of Pipeline1, set the time zone to UTC. 
F. Set the Retry setting of the Semantic model refresh activity to 2. 

Show Answer

Question # 2

You need to ensure that processes for the bronze and silver layers run in isolation How should you configure the Apache Spark settings?

A. Modify the number of executors. 
B. Disable high concurrency. 
C. Create a custom pool. 
D. Set the default environment. 

Show Answer

Question # 3

You need to create a workflow for the new book cover images. Which two components should you include in the workflow? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

A. a notebook that uses Apache Spark Structured Streaming 
B. a time-based schedule 
C. an activator item 
D. a data pipeline 
E. a streaming dataflow 
F. a blob storage action 

Show Answer

Question # 4

You need to recommend a solution to resolve the MAR1 connectivity issues. The solution must minimize development effort. What should you recommend?

A. Add a ForEach activity to the data pipeline. 
B. Configure retries for the Copy data activity. 
C. Configure Fault tolerance for the Copy data activity. 
D. Call a notebook from the data pipeline.

Show Answer

Question # 5

You need to recommend a solution for handling old files. The solution must meet the technical requirements. What should you include in the recommendation?

A. a data pipeline that includes a Copy data activity 
B. a notebook that runs the VACUUM command 
C. a notebook that runs the OPTIMIZE command 
D. a data pipeline that includes a Delete data activity 

Show Answer

Question # 6

You need to schedule the population of the medallion layers to meet the technical requirements. What should you do?

A. Schedule a data pipeline that calls other data pipelines. 
B. Schedule a notebook. 
C. Schedule an Apache Spark job. 
D. Schedule multiple data pipelines. 

Show Answer

Question # 7

You need to ensure that WorkspaceA can be configured for source control. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point. 

A. Assign WorkspaceA to Capl. 
B. From Tenant setting, set Users can synchronize workspace items with their Git repositories to Enabled 
C. Configure WorkspaceA to use a Premium Per User (PPU) license 
D. From Tenant setting, set Users can sync workspace items with GitHub repositories to Enabled 

Show Answer

Question # 8

You have a Fabric workspace that contains a lakehouse named Lakehousel. You plan to create a data pipeline named Pipeline! to ingest data into Lakehousel. You will use a parameter named paraml to pass an external value into Pipeline1!. The paraml parameter has a data type of int You need to ensure that the pipeline expression returns param1 as an int value. How should you specify the parameter value?

 A. "@pipeline(). parameters. paraml" 
B. "@{pipeline().parameters.paraml}" 
C. "@{pipeline().parameters.[paraml]}" 
D. "@{pipeline().parameters.paraml}-

Show Answer

Question # 9

You have a Fabric workspace named Workspace1. You plan to configure Git integration for Workspacel by using an Azure DevOps Git repository. An Azure DevOps admin creates the required artifacts to support the integration of Workspacel Which details do you require to perform the integration?

A. the project, Git repository, branch, and Git folder 
B. the organization, project. Git repository, and branch 
C. the Git repository URL and the Git folder 
D. the personal access token (PAT) for Git authentication and the Git repository URL 

Show Answer

Question # 10

You have a Fabric workspace named Workspace1. Your company acquires GitHub licenses. You need to configure source control for Workpace1 to use GitHub. The solution must follow the principle of least privilege. Which permissions do you require to ensure that you can commit code to GitHub?

 A. Actions (Read and write) and Contents (Read and write) 
B. Actions (Read and write) only 
C. Contents (Read and write) only 
D. Contents (Read) and Commit statuses (Read and write)

Show Answer