Question 1

You need to refresh the Orders table of the Online Sales department. The solution must meet the semantic model requirements. What should you include in the solution?

Options :

A :

an Azure Data Factory pipeline that executes a dataflow to retrieve the minimum value of the OrderlD column in the destination lakehouse

B :

an Azure Data Factory pipeline that executes a Stored procedure activity to retrieve the maximum value of the OrderlD column in the destination lakehouse

C :

an Azure Data Factory pipeline that executes a dataflow to retrieve the maximum value of the OrderlD column in the destination lakehouse

D :

an Azure Data Factory pipeline that executes a Stored procedure activity to retrieve the minimum value of the OrderiD column m the destination lakehouse

Answer: C

Question 2

You have a Fabric tenant that contains a warehouse. You use a dataflow to load a new dataset from OneLake to the warehouse. You need to add a Power Query step to identify the maximum values for the numeric columns. Which function should you include in the step?

Options :

A : Table. MaxN

B : Table.Max

C : Table.Range

D : Table.Profile

Answer: B

Question 3

You have a Fabric tenant that contains a lakehouse named lakehouse1. Lakehouse1 contains a table named Table1. You are creating a new data pipeline. You plan to copy external data to Table1. The schema of the external data changes regularly. You need the copy operation to meet the following requirements: Replace Table1 with the schema of the external data. Replace all the data in Table1 with the rows in the external data. You add a Copy data activity to the pipeline. What should you do for the Copy data activity?

Options :

A : From the Source tab, add additional columns.

B : From the Destination tab, set Table action to Overwrite.

C : From the Settings tab, select Enable staging

D : From the Source tab, select Enable partition discovery

E : From the Source tab, select Recursively

Answer: B

Question 4

You have a Fabric tenant that contains a warehouse. Several times a day. the performance of all warehouse queries degrades. You suspect that Fabric is throttling the compute used by the warehouse. What should you use to identify whether throttling is occurring?

Options :

A : the Capacity settings

B : the Monitoring hub

C : dynamic management views (DMVs)

D : the Microsoft Fabric Capacity Metrics app

Answer: D

Question 5

You have a Fabric tenant. You are creating a Fabric Data Factory pipeline. You have a stored procedure that returns the number of active customers and their average sales for the current month. You need to add an activity that will execute the stored procedure in a warehouse. The returned values must be available to the downstream activities of the pipeline. Which type of activity should you add?Script

Options :

A : Script

B : Copy data

C : Switch

D : Append variable

Answer: A

Smartly Prepare Exam with Free Online DP-600 Practice Test

Buying Options: