Weekend Sale Special - 75% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: big75certs

Microsoft Certified: Fabric Analytics Engineer Associate DP-700 Passing Score

Page: 3 / 7
Total 142 questions

Implementing Data Engineering Solutions Using Microsoft Fabric Questions and Answers

Question 9

You have a Fabric workspace that contains a Real-Time Intelligence solution and an eventhouse.

Users report that from OneLake file explorer, they cannot see the data from the eventhouse.

You enable OneLake availability for the eventhouse.

What will be copied to OneLake?

Options:

A.

only data added to new databases that are added to the eventhouse

B.

only the existing data in the eventhouse

C.

no data

D.

both new data and existing data in the eventhouse

E.

only new data added to the eventhouse

Question 10

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?

Options:

A.

Actions (Read and write) and Contents (Read and write)

B.

Actions (Read and write) only

C.

Contents (Read and write) only

D.

Contents (Read) and Commit statuses (Read and write)

Question 11

HOTSPOT

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

You need to create an output that presents the summarized values of all the order quantities by year and product. The results must include a summary of the order quantities at the year level for all the products.

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

NOTE: Each correct selection is worth one point.

Options:

Question 12

You need to recommend a Fabric streaming solution that will use the sources shown in the following table.

The solution must minimize development effort.

What should you include in the recommendation for each source? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Options:

Page: 3 / 7
Total 142 questions