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?

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

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

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

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

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

You have a Fabric workspace named Workspace1 and an Azure SQL database.You plan to create a dataflow that will read data from the database, and then transform the data by performing an inner join. You need to ignore spaces in the values when performing the inner join The solution must minimize development effort. What should you do?

Merge the queries by using fuzzy matching.

Append the queries by using fuzzy matching.

Merge the queries by using fuzzy matching.

Append the queries by using a lookup table.

Merge the queries by using a lookup table.

You have a Fabric tenant that contains a lakehouse named Lakehouse! Lakehouse1 contains a Delta table that has one million Parquet files.You need to remove files that were NOT referenced by the table during the past 30 days. The solution must ensure that the transaction log remains consistent, and the ACID properties of the table are maintainedWhat should you do?

Run the optimize command and specify the v-order parameter.

Run theOPTiMize command and specify the z-order parameter

From OneLake file explorer, delete the files.

You need to ensure that Contoso can use version control to meet the data analytics requirements and the general requirements. What should you do?

Modify the settings of the Research workspaces to use a GitHub repository.

Store all the semantic models and reports in Data Lake Gen2 storage.

Modify the settings of the Research workspaces to use a GitHub repository.

Store all the semantic models and reports in Microsoft OneDrive.

Modify the settings of the Research division workspaces to use an Azure Repos repository.

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?

Add a managed identity to App1.

Add a managed identity to the workspace.

Add a managed identity to App1.

Upgrade the workspace to Premium capacity.

Modify the XMLA Endpoint setting.

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?

CREATE TABLE schema2.city AS CLONE OF schemal.city;

INSERT INTO schema2.city SELECT * FROM schemal.city;

CREATE TABLE schema2.city AS CLONE OF schemal.city;

CREATE TABLE schema2.city AS SELECT * FROM schemal.city;

SELECT * INTO schema2.eity FROM schemal.city;

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.

the shared access signature (SAS) token

You have a Fabric workspace named Workspace1 that contains a dataflow named Dataflow1. Dataflow1 returns 500 rows of data.You need to identify the min and max values for each column in the query results.Which three Data view options should you select? Each correct answer presents part of the solution.NOTE: Each correct answer is worth one point.

Show column profile in details pane

You have a Fabric tenant that contains JSON files in OneLake. The files have one billion items.You plan to perform time series analysis of the items.You need to transform the data, visualize the data to find insights, perform anomaly detection, and share the insights with other business users. The solution must meet the following requirements:Use parallel processing.Minimize the duplication of data.Minimize how long it takes to load the data.What should you use to transform and visualize the data?

the PySpark library in a Fabric notebook

a Microsoft Power B1 report that uses core visuals

the PySpark library in a Fabric notebook

the pandas library in a Fabric notebook

You have a Fabric tenant that contains a warehouse named DW1 and a lakehouse named LH1. DW1 contains a table named Sales.Product. LH1 contains a table named Sales.Orders.You plan to schedule an automated process that will create a new point-in-time (PIT) table named Sales.ProductOrder in DW1. Sales.ProductOrder will be built by using the results of a query that will join Sales.Product and Sales.Orders.You need to ensure that the types of columns in Sales. ProductOrder match the column types in the source tables. The solution must minimize the number of operations required to create the new table.Which operation should you use?

CREATE MATERIALIZED VIEW AS SELECT

Microsoft DP-600 Practice Test 3 - Free Online Exam Prep & Questions

HOTSPOT

You have a Fabric tenant that contains a warehouse named Warehouse1. Warehouse1 contains a fact table named FactSales that has one billion rows. You run the following T-SQL statement.

CREATE TABLE test.FactSales AS CLONE OF Dbo.FactSales;

For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

Become a Premium Member for full access

Unlock Premium Member

Microsoft DP-600 Practice Test 3

Question

Microsoft DP-600 Practice Tests

Practice Tests