DP-600 試験問題を無料オンラインアクセス

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?

• A.CREATE MATERIALIZED VIEW AS SELECT
• B.CREATE TABLE AS CLONE OF
• C.INSERT INTO
• D.CREATE TABLE AS SELECT (CTAS)

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.

正解：

Explanation:
A replica of dbo.Sales is created in the test schema by copying the metadata only. - Yes Additional schema changes to dbo.FactSales will also apply to test.FactSales. - No Additional data changes to dbo.FactSales will also apply to test.FactSales. - No The CREATE TABLE AS CLONE statement creates a copy of an existing table, including its data and any associated data structures, like indexes. Therefore, the statement does not merely copy metadata; it also copies the data. However, subsequent schema changes to the original table do not automatically propagate to the cloned table. Any data changes in the original table after the clone operation will not be reflected in the clone unless explicitly updated.
References =
CREATE TABLE AS SELECT (CTAS) in SQL Data Warehouse

You have a Fabric workspace named Workspace1.
Workspace1 contains multiple semantic models, including a model named Model1. Model1 is updated by using an XMLA endpoint.
You need to increase the speed of the write operations of the XMLA endpoint.
What should you do?

• A.Configure Model1 to use the Direct Lake storage format.
• B.Delete any unused semantic models from Workspace1.
• C.Select Large semantic model storage format for Workspace1.
• D.Delete any unused columns from Model1.

You have three Fabric workspaces named Workspace1, Workspace2, and Workspace3 Workspace1 contains a report named Report1 and a semantic model named Model1 in import mode.
You perform the following actions;
* Create a deployment pipeline named Pipeline1 that has three stages named development, test, and production.
* Assign Workspace1 to the development stage of Pipeline1.
* Assign Workspace2 to the test stage of Pipeline.
* Assign Wofkspace3 to the production stage of Pipeline1
* Modify Model1.
You need to ensure that changes to Model! are available in the production stage as quickly as possible. The solution must NOT affect the availability of Report1.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

正解：

Explanation:

You have an Azure Repos Git repository named Repo1 and a Fabric-enabled Microsoft Power Bl Premium capacity. The capacity contains two workspaces named Workspace! and Workspace2. Git integration is enabled at the workspace level.
You plan to use Microsoft Power Bl Desktop and Workspace! to make version-controlled changes to a semantic model stored in Repo1. The changes will be built and deployed lo Workspace2 by using Azure Pipelines.
You need to ensure that report and semantic model definitions are saved as individual text files in a folder hierarchy. The solution must minimize development and maintenance effort.
In which file format should you save the changes?

• A.PBIDS
• B.PBIX
• C.PBIP
• D.PBIT