Summer Sale Limited Time 75% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = simple75

Pass the Microsoft Certified: Fabric Data Engineer Associate DP-700 Questions and answers with Dumpstech

Home
Microsoft
Microsoft Certified: Fabric Data Engineer Associate
DP-700
DP-700 Questions and Answers

Exam DP-700 Premium Access

View all detail and faqs for the DP-700 exam

Go to Exam

Practice at least 50% of the questions to maximize your chances of passing.

Viewing page 4 out of 4 pages

Viewing questions 31-40 out of questions

Questions # 31:

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.

Options:

Assign WorkspaceA to Capl.

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

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

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

Answer

A, B

Questions # 32:

You need to ensure that usage of the data in the Amazon S3 bucket meets the technical requirements.

What should you do?

Options:

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.

Answer

Explanation

To ensure that the usage of the data in the Amazon S3 bucket meets the technical requirements, we must address two key points:

Minimize egress costs associated with cross-cloud data access: Using a shortcut ensures that Fabric does not replicate the data from the S3 bucket into the lakehouse but rather provides direct access to the data in its original location. This minimizes cross-cloud data transfer and avoids additional egress costs.

Prevent saving a copy of the raw data in the lakehouses: Disabling caching ensures that the raw data is not copied or persisted in the Fabric workspace. The data is accessed on-demand directly from the Amazon S3 bucket.

Questions # 33:

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

Options:

Modify the number of executors.

Disable high concurrency.

Create a custom pool.

Set the default environment.

Answer

Questions # 34:

What should you do to optimize the query experience for the business users?

Options:

Enable V-Order.

Create and update statistics.

Run the VACUUM command.

Introduce primary keys.

Answer

Questions # 35:

HOTSPOT

You need to troubleshoot the ad-hoc query issue.

How should you complete the statement? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Question # 35

Options:

Answer

Answer:

Explanation

A screenshot of a computer Description automatically generated

SELECT last_run_start_time, last_run_command: These fields will help identify the execution details of the long-running queries.

FROM queryinsights.long_running_queries: The correct solution is to check the long-running queries using the queryinsights.long_running_queries view, which provides insights into queries that take longer than expected to execute.

WHERE last_run_total_elapsed_time_ms > 7200000: This condition filters queries that took more than 2 hours to complete (7200000 milliseconds), which is relevant to the issue described.

AND number_of_failed_runs > 1: This condition is key for identifying queries that have failed more than once, helping to isolate the problematic queries that cause failures and need attention.

Questions # 36:

You have a Fabric workspace that contains a lakehouse named Lakehouse1. Lakehouse1 contains a table named Table 1. You need to ensure that a user named User 1 can view only specific rows in Table1. What should you do first?

Options:

Create a security predicate.

Create a function.

Create a security policy.

Grant User1 the SELECT permission for Table1.

Answer

Questions # 37:

You have a Fabric workspace named Workspace1 that contains the items shown in the following table.

Question # 37

For Model1, the Keep your Direct Lake data up to date option is disabled.

You need to configure the execution of the items to meet the following requirements:

Notebook1 must execute every weekday at 8:00 AM.

Notebook2 must execute when a file is saved to an Azure Blob Storage container.

Model1 must refresh when Notebook1 has executed successfully.

How should you orchestrate each item? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Question # 37

Options:

Answer

Answer:

Questions # 38:

HOTSPOT

You have a Fabric workspace that contains a warehouse named Warehouse1. Warehouse1 contains the following tables and columns.

Question # 38

You need to denormalize the tables and include the ContractType and StartDate columns in the Employee table. The solution must meet the following requirements:

Ensure that the StartDate column is of the date data type.

Ensure that all the rows from the Employee table are preserved and include any matching rows from the Contract table.

Ensure that the result set displays the total number of employees per contract type for all the contract types that have more than two employees.

How should you complete the statement? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Question # 38

Options:

Answer

Answer:

Explanation

C:\Users\Waqas Shahid\Desktop\Mudassir\Untitled.jpg

Questions # 39:

You have a Fabric workspace named Workspace1.

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

Options:

the project, Git repository, branch, and Git folder

the organization, project. Git repository, and branch

the Git repository URL and the Git folder

the personal access token (PAT) for Git authentication and the Git repository URL

Answer

Questions # 40:

You have a Fabric .

In Warehouse1, you create a table named DimCustomer by running the following statement.

Question # 40

You need to set the Customerkey column as a primary key of the DimCustomer table.

Which three code segments should you run in sequence? To answer, move the appropriate code segments from the list of code segments to the answer area and arrange them in the correct order.

Question # 40

Options:

Answer

Answer:

Viewing page 4 out of 4 pages

Viewing questions 31-40 out of questions

Modal title

Registered Required

In order to participate in the comments you need to be logged-in.
You can sign-up or login (it's free).