Microsoft DP-700 Exam Questions Instant Access

Question 1

You have an Azure key vault named KeyVaultl that contains secrets.

You have a Fabric workspace named Workspace!. Workspace! contains a notebook named Notebookl that performs the following tasks:

* Loads stage data to the target tables in a lakehouse

* Triggers the refresh of a semantic model

You plan to add functionality to Notebookl that will use the Fabric API to monitor the semantic model refreshes. You need to retrieve the registered application ID and secret from KeyVaultl to generate the authentication token. Solution: You use the following code segment:

Use notebookutils. credentials.getSecret and specify key vault URL and the name of a linked service.

Does this meet the goal?

AYes

BNo

Answer : B

Question 2

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?

AActions (Read and write) and Contents (Read and write)

BActions (Read and write) only

CContents (Read and write) only

DContents (Read) and Commit statuses (Read and write)

Answer : C

Question 3

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 4

You have a Fabric capacity that contains a workspace named Workspace1. Workspace1 contains a lakehouse named Lakehouse1, a data pipeline, a notebook, and several Microsoft Power BI reports.

A user named User1 wants to use SQL to analyze the data in Lakehouse1.

You need to configure access for User1. The solution must meet the following requirements:

Provide User1 with read access to the table data in Lakehouse1.

Prevent User1 from using Apache Spark to query the underlying files in Lakehouse1.

Prevent User1 from accessing other items in Workspace1.

What should you do?

AShare Lakehouse1 with User1 directly and select Read all SQL endpoint data.

BAssign User1 the Viewer role for Workspace1. Share Lakehouse1 with User1 and select Read all SQL endpoint data.

CShare Lakehouse1 with User1 directly and select Build reports on the default semantic model.

DAssign User1 the Member role for Workspace1. Share Lakehouse1 with User1 and select Read all SQL endpoint data.

Answer : B

To meet the specified requirements for User1, the solution must ensure:

Read access to the table data in Lakehouse1: User1 needs permission to access the data within Lakehouse1. By sharing Lakehouse1 with User1 and selecting the Read all SQL endpoint data option, User1 will be able to query the data via SQL endpoints.

Prevent Apache Spark usage: By sharing the lakehouse directly and selecting the SQL endpoint data option, you specifically enable SQL-based access to the data, preventing User1 from using Apache Spark to query the data.

Prevent access to other items in Workspace1: Assigning User1 the Viewer role for Workspace1 ensures that User1 can only view the shared items (in this case, Lakehouse1), without accessing other resources such as notebooks, pipelines, or Power BI reports within Workspace1.

This approach provides the appropriate level of access while restricting User1 to only the required resources and preventing access to other workspace assets.

Question 5

You have a Fabric workspace named Workspace1 that uses version control. Workspace! and Azure DevOps are integrated.

In Azure DevOps. developers create a branch named Branch1 to test extract, transform, and load (ETL) updates.

You need to connect Workspace1 to Branch1. The solution must ensure that all the existing content in Branch1 is available in Workspace1.

What should you do?

AFrom Workspace1. select Source control, and then select Sync

BFrom Workspace1. select Source control, select Current branch, select Branch1, and then select Commit

CFrom Azure DevOps, merge the contents of the main branch into Branch1.

DFrom Workspace1, select Source control, and then select Branch out to new workspace

Answer : A

Question 6

You have a Fabric lakehouse that contains the resources shown in the following table.

You need to use a notebook to query for customers in the United States and load the filtered data into USCustomers. The solution must minimize the number of scripts used.

Which statement should you use?

Acustomers.write.format('parquet').mode('append').saveAsTable('USCustomers')

Bcustomers.write.format('delta').mode('overwrite').save('Tables/USCustomers')

Ccustomers.write.format('delta').mode('overwrite').saveAsTable('USCustomers')

Dcustomers.write.format('parquet').mode('append').save('Tables/USCustomers')

Answer : C

Question 7

You have an Azure key vault named KeyVaultl that contains secrets.

You have a Fabric workspace named Workspace-!. Workspace! contains a notebook named Notebookl that performs the following tasks:

* Loads stage data to the target tables in a lakehouse

* Triggers the refresh of a semantic model

Solution: You use the following code segment:

Use notebookutils.credentials.getSecret and specify the key vault URL and key vault secret. Does this meet the goal?

AYes

BNo

Answer : A

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