Microsoft DP-700 Exam Questions Instant Access

Question 1

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.

AAssign WorkspaceA to Capl.

BFrom Tenant setting, set Users can synchronize workspace items with their Git repositories to Enabled

CConfigure WorkspaceA to use a Premium Per User (PPU) license

DFrom Tenant setting, set Users can sync workspace items with GitHub repositories to Enabled

Answer : A, B

Question 2

You have a Fabric workspace that contains a warehouse named Warehouse1. Data is loaded daily into Warehouse1 by using data pipelines and stored procedures.

You discover that the daily data load takes longer than expected.

You need to monitor Warehouse1 to identify the names of users that are actively running queries.

Which view should you use?

Asys.dm_exec_connections

Bsys.dm_exec_requests

Cqueryinsights.long_running_queries

Dqueryinsights.frequently_run_queries

Esys.dm_exec_sessions

Answer : E

sys.dm_exec_sessions provides real-time information about all active sessions, including the user, session ID, and status of the session. You can filter on session status to see users actively running queries.

Question 3

You are developing a data engineering solution in Fabric by using Apache Spark.

You need to monitor the performance of Spark workloads the solution must meet the following requirements

* Provide comprehensive information about the performance of the data engineering workloads.

* Identify stages and tasks that run slowly.

* Minimize administrative effort

What should you use?

ASpark application logs

Bthe Spark Ul

Cworkspace metrics in Fabric

DSpark job event logs

Answer : B

Question 4

You have a Fabric workspace that contains 10 data pipelines named Pipeline1 through Pipeline10. The data pipelines load, transform, and publish data to a lakehouse named Lakehouse1.

Each data pipeline takes 30 minutes to run. The data pipelines must run in numerical sequence based on their names. The end-to-end process must start every eight hours.

You need to configure orchestration to ensure that all the data pipelines run in the correct order. The solution must minimize the number of schedules and administrative effort.

What should you do?

ASchedule Pipeline1 to run every eight hours and configure trigger dependencies so that each subsequent data pipeline starts when the previous data pipeline completes successfully.

BCreate a master data pipeline that runs every eight hours and uses an Invoke pipeline activity to call the other data pipelines sequentially.

CAdd an event-based trigger to each data pipeline so that the data pipeline starts when a new dataset is written to Lakehouse1.

DConfigure a time-based schedule to run each data pipeline independently every eight hours.

Answer : B

Question 5

You have a Fabric workspace that contains a semantic model named Modell. You need to monitor the refresh history of Model 1 and visualize the refresh history in a chart. What should you use?

Athe refresh history from the settings of Model1.

Ba notebook

Ca Dataflow Gen2 dataflow

Da data pipeline

Answer : B

Question 6

You have a Fabric workspace that contains a write intensive warehouse named DW1. DW1 stores staging tables that are used to load a dimensional model. The tables are often read once, dropped, and then recreated to process new data.

You need to minimize load time of data from sources to staging tables in DW1.

What should you do?

ADrop statistics.

BEnable V Order.

CCreate statistics.

DDisable V Order.

Answer : D

Question 7

You have a Fabric workspace named Workspace1 that contains three notebooks named notebook_01, notebook_02, and notebook_03.

You are building a new notebook in Workspace1 that will contain the following Directed Acyclic Graph (DAG) definition.

You need to modify the DAG definition to meet the following requirements:

* Ensure that notebook.01 and notebook_02 run in parallel.

* Ensure that notebook_02 only runs after the execution of notebook_03 is complete.

How should you modify the DAG definition?

ACreate a second DAG definition. Move notebook_03 and notebook_02 to the new DAG definition

BMove the notebook_03 declaration to the top of the DAG definition. Add a concurrency to notebook_02 and notebook_01.

CMove the declaration of notebook 03 to the top of the DAG definition. Add a new stage that contains notebook 01 and notebook 02.

DCreate two stages in the DAG definition. Add notebook_03 to the first stage. Add notebook_01 and notebook_02 to the second stage.

Answer : D

Microsoft Implementing Data Engineering Solutions Using Microsoft Fabric DP-700 Exam Questions