Question 1

You have a Fabric workspace named Workspace 1 that contains a dataflow named Dataflow1. Dataflow! has a query that returns 2.000 rows. You view the query in Power Query as shown in the following exhibit.

What can you identify about the pickupLongitude column?

Options :

A : The column has duplicate values.

B : All the table rows are profiled.

C : The column has missing values.

D : There are 935 values that occur only once.

Answer: A

Question 2

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 3

You have a Fabric tenant that contains a workspace named Workspace^ Workspacel is assigned to a Fabric capacity. You need to recommend a solution to provide users with the ability to create and publish custom Direct Lake semantic models by using external tools. The solution must follow the principle of least privilege. Which three actions in the Fabric Admin portal should you include in the recommendation? Each correct answer presents part of the solution. NOTE: Each correct answer is worth one point.

Options :

A : From the Tenant settings, set Allow XMLA Endpoints and Analyze in Excel with on-premises datasets to Enabled

B : From the Tenant settings, set Allow Azure Active Directory guest users to access Microsoft Fabric to Enabled

C : From the Tenant settings, select Users can edit data models in the Power Bl service.

D : From the Capacity settings, set XMLA Endpoint to Read Write

E : From the Tenant settings, set Users can create Fabric items to Enabled

F : From the Tenant settings, enable Publish to Web

Answer: A,C,D

Question 4

You need to create a data loading pattern for a Type 1 slowly changing dimension (SCD). Which two actions should you include in the process? Each correct answer presents part of the solution. NOTE: Each correct answer is worth one point.

Options :

A : Update rows when the non-key attributes have changed.

B : Insert new rows when the natural key exists in the dimension table, and the non-key attribute values have changed.

C : Update the effective end date of rows when the non-key attribute values have changed.

D : Insert new records when the natural key is a new value in the table.

Answer: A,D

Question 5

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?

Options :

A : a view

B : a dataflow

C : a managed table

D : a shortcut

Answer: A

Confidently Practice Online with Free DP-600 Exam Cram

Buying Options: