Question No 1

You need to ensure that the data analysts can access the gold layer lakehouse. What should you do?

Choose the Choices:

Add the DataAnalyst group to the Viewer role for WorkspaceA.

Share the lakehouse with the DataAnalysts group and grant the Build reports on the default semantic model permission.

Share the lakehouse with the DataAnalysts group and grant the Read all SQL Endpoint data permission.

Share the lakehouse with the DataAnalysts group and grant the Read all Apache Spark permission.

Question No 2

HOTSPOT
You need to recommend a method to populate the POS1 data to the lakehouse medallion layers.
What should you recommend for each layer? To answer, select the appropriate options in the answer
area.
NOTE Each correct selection is worth one point.

Choose the Choices:

Question No 3

You need to ensure that usage of the data in the Amazon S3 bucket meets the technical requirements. What should you do?

Choose the Choices:

Create a workspace identity and enable high concurrency for the notebooks.

Create a shortcut and ensure that caching is disabled for the workspace.

Create a workspace identity and use the identity in a data pipeline.

Create a shortcut and ensure that caching is enabled for the workspace.

Question No 4

HOTSPOT
You need to create the product dimension.
How should you complete the Apache Spark SQL code? To answer, select the appropriate options in
the answer area.
NOTE Each correct selection is worth one point.

Choose the Choices:

Question No 5

You need to populate the MAR1 data in the bronze layer. Which two types of activities should you include in the pipeline? Each correct answer presents part of the solution. NOTE Each correct selection is worth one point.

Choose the Choices:

Practice Microsoft DP-700 Exam Questions

Question No 1

Question No 2

Question No 3

Question No 4

Question No 5

DP-700 Exam Features

DP-700 PDF Dumps