Microsoft DP-600 Practice Test - Questions Answers, Page 11

HOTSPOT

You need to recommend a solution to group the Research division workspaces.

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

NOTE: Each correct selection is worth one point.

You have a Microsoft Power B1 Premium Per User (PPU) workspace that contains a semantic model.

You have an Azure App Service app named App1 that modifies row-level security (RLS) for the model by using the XMLA endpoint. App1 requires users to sign in by using their Microsoft Entra credentials to access the XMLA endpoint. You need to configure App1 to use a service account to access the model. What should you do first?

HOTSPOT

You have source data in a CSV file that has the following fields:

* SalesTra nsactionl D

* SaleDate

* CustomerCode

* CustomerName

* CustomerAddress

* ProductCode

* ProductName

* Quantity

* UnitPrice

You plan to implement a star schema for the tables in WH1. Thedimension tables in WH1 will implement Type 2 slowly changing dimension (SCD) logic.

You need to design the tables that will be used for sales transaction analysis and load the source data.

Which type of target table should you specify for the CustomerName, CustomerCode, and SaleDate fields? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You have a Fabric tenant

You plan to create a data pipeline named Pipeline1. Pipeline1 will include two activities that will execute in sequence. You need to ensure that a failure of the first activity will NOT block the second activity. Which conditional path should you configure between the first activity and the second activity?

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?

You have a Fabric tenant that contains a warehouse named Warehouse!. Warehousel contains two schemas name schemal and schema2 and a table named schemal.city.

You need to make a copy of schemal.city in schema2. The solution must minimize the copying of data.

Which T-SQL statement should you run?

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.

You have a Fabric tenant that contains a data warehouse.

You need to load rows into a large Type 2 slowly changing dimension (SCD). The solution must minimize resource usage. Which T-SQL statement should you use?

HOTSPOT

You have a Fabric tenant that contains a semantic model named model1. The two largest columns in model1 are shown in the following table.

You need to optimize model 1. The solution must meet the following requirements:

* Reduce the model size.

* Increase refresh performance when using Import mode.

* Ensure that the datetime value for each sales transaction is available in the model.

What should you do on each column? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Answer: