Ace Your DP-600 Microsoft Certified - Fabric Analytics Engineer Associate Exam

Page: 5 / 5

Question 20

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:

From the Source tab, add additional columns.

From the Destination tab, set Table action to Overwrite.

From the Settings tab, select Enable staging

From the Source tab, select Enable partition discovery

From the Source tab, select Recursively

Question 21

You have an Amazon Web Services (AWS) subscription that contains an Amazon Simple Storage Service (Amazon S3) bucket named bucketl.

You have a Fabric tenant that contains a lakehouse named LH1.

In LH1, you plan to create a OneLake shortcut to bucketl.

You need to configure authentication for the connection.

Which two values should you provide? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

Options:

the shared access signature (SAS) token

the secret access key

the access ID

the access key ID

the certificate thumbprint

Question 22

You have a Fabric tenant that contains two workspaces named Woritspace1 and Workspace2. Workspace1 contains a lakehouse named Lakehouse1. Workspace2 contains a lakehouse named Lakehouse2. Lakehouse! contains a table named dbo.Sales. Lakehouse2 contains a table named dbo.Customers.

You need to ensure that you can write queries that reference both dbo.Sales and dbo.Customers in the same SQL query without making additional copies of the tables.

What should you use?