Pre-Winter Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 65pass65

Free Implementing Data Engineering Solutions Using Microsoft Fabric Practice Questions

Question # 1

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

Options:

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.

Discussion 0
Question # 2

You need to schedule the population of the medallion layers to meet the technical requirements.

What should you do?

Options:

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.

Discussion 0
Question # 3

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.

Options:

A.  

ForEach

B.  

Copy data

C.  

WebHook

D.  

Stored procedure

Discussion 0
Question # 4

You need to ensure that the data engineer s are notified if any step in populating the lakehouses fails. The solution must meet the technical requirements and minimize development effort.

What should you use? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Question # 4

Options:

Discussion 0
Question # 5

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:

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

Discussion 0
Question # 6

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.

Question # 6

Options:

Discussion 0
Question # 7

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

What should you do?

Options:

A.  

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

B.  

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

C.  

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

D.  

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

Discussion 0
Question # 8

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

Options:

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

Discussion 0
Question # 9

You need to ensure that the data analysts can access the gold layer lakehouse.

What should you do?

Options:

A.  

Add the DataAnalyst group to the Viewer role for Workspace

A.  

B.  

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

C.  

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

D.  

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

Discussion 0
Question # 10

You have a Fabric data warehouse that contains the following tables.

Question # 10

You need to refresh the tables by using an automated pipeline. The solution must ensure that table updates occur in the correct order to maintain referential integrity.

Which two tables should you refresh first? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

Options:

A.  

FactSale

B.  

Dim Product

C.  

Factlnventory

D.  

DimCustomer

E.  

DimGeography

Discussion 0

DP-700 PDF

DP-700 PDF (Printable)
$54.25
$154.99

DP-700 Testing Engine

DP-700 PDF (Printable)
$59.5
$169.99

DP-700 PDF + Testing Engine

DP-700 PDF (Printable)
$74.55
$212.99
Exams4sure Dumps

Exam style questions across every DP-700 domain

Last Update 1 day ago
Total Questions : 142

Start with our free DP-700 practice questions, carefully crafted to mirror the domains, phrasing, and difficulty of the real Microsoft Certified: Fabric Data Engineer Associate exam. Each DP-700 exam question comes with a detailed rationale that explains not just which answer is correct but why the others fall short. That's how concepts stick. Use the free set to benchmark yourself: identify your Microsoft weak domains, see where you're losing marks, and build a focused study plan in minutes.

Free Exams Sample Questions