DP-600試験無料問題集「Microsoft Implementing Analytics Solutions Using Microsoft Fabric 認定」
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?
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?
正解：D
解答を投票する
解説: (GoShiken メンバーにのみ表示されます)
You have a Fabric workspace that contains a Dataflow Gen2 query. The query returns the following data.
You need to filter the results to ensure that only the latest version of each customer ' s record is retained. The solution must ensure that no new columns are loaded to the semantic model.
Which four actions should you perform in sequence in Power Query Editor? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
You need to filter the results to ensure that only the latest version of each customer ' s record is retained. The solution must ensure that no new columns are loaded to the semantic model.
Which four actions should you perform in sequence in Power Query Editor? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
正解：
Explanation:
Comprehensive Detailed Explanation
We have a table with:
CustomerID # unique ID
CustomerName # customer's name
VersionDate # timestamp representing version history
The requirement:
Keep only the latest record per customer.
Ensure no new technical columns (like max version date) remain in the semantic model.
Step 1: Identify latest version per customer
We need to determine the latest VersionDate for each CustomerID.
Use Group By CustomerID and calculate Max of VersionDate.
This creates a mapping of CustomerID # latest VersionDate.
Step 2: Filter to keep only latest records
Join or filter original data so that only rows with VersionDate = Max(VersionDate) are retained.
This ensures that only the most recent record is kept per customer.
Step 3: Remove the helper column
The column holding Max VersionDate is only needed for filtering.
It must be removed because the requirement is that no new columns are loaded to the semantic model.
Step 4: Remove duplicates
As a final safeguard, remove duplicates by CustomerID, ensuring that each customer appears only once.
Final Ordered Actions
Group by CustomerID and calculate the max version date per customer ID.
Filter the query where the version date value equals the max version date value.
Remove the max version date column.
Remove duplicates based on CustomerID.
You have a Fabric tenant that contains two workspaces named Workspace1 and Workspace2 and a user named User1.
You need to ensure that User1 can perform the following tasks:
Create a new domain.
Create two subdomains named subdomain1 and subdomain2.
Assign Workspace1 to subdomain1.
Assign Workspace2 to subdomain2.
The solution must follow the principle of least privilege.
Which role should you assign to User1?
You need to ensure that User1 can perform the following tasks:
Create a new domain.
Create two subdomains named subdomain1 and subdomain2.
Assign Workspace1 to subdomain1.
Assign Workspace2 to subdomain2.
The solution must follow the principle of least privilege.
Which role should you assign to User1?
正解：A
解答を投票する
解説: (GoShiken メンバーにのみ表示されます)
You have a Fabric workspace that contains a warehouse named DW1. DW1 contains the following tables and columns.
You need to summarize order quantities by year and product. The solution must include the yearly sum of order quantities for all the products in each row.
How should you complete the T-SQL statement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
You need to summarize order quantities by year and product. The solution must include the yearly sum of order quantities for all the products in each row.
How should you complete the T-SQL statement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
正解：
Explanation:
Comprehensive Detailed Explanation
We need to write a query that summarizes order quantities by year and product, and also include the yearly total for all products in each row.
Step 1: What the query needs
Extract the year from SalesOrderDetail.ModifiedDate.
Join with the Product table to get the product name.
Aggregate with SUM(OrderQty).
Return grouped data by year and product, with an additional subtotal row per year (all products combined).
Step 2: Evaluate the SELECT Clause
We must extract the year using:
YEAR(so.ModifiedDate) AS OrderDate
This converts the ModifiedDate column into a year value for grouping.
Step 3: Evaluate the GROUP BY options
CUBE(YEAR, P.Name) # Produces all combinations of year totals, product totals, and grand totals. Too many combinations, not required.
GROUPING SETS # Could achieve the result but requires explicitly listing the sets. Less direct.
ROLLUP(YEAR, P.Name) # Produces grouping by (Year, Product) and then a subtotal per Year. Exactly what is required.
YEAR only # Would group only by year, losing per-product breakdown.
Correct: ROLLUP(YEAR(so.ModifiedDate), P.Name)
Step 4: Completed Query
SELECT
YEAR(so.ModifiedDate) AS OrderDate,
p.Name,
SUM(so.OrderQty) AS OrderQty
FROM dbo.SalesOrderDetail so
INNER JOIN dbo.Product p
ON p.ProductID = so.ProductID
GROUP BY ROLLUP(YEAR(so.ModifiedDate), p.Name);
Why This Works
YEAR(so.ModifiedDate) extracts year for grouping.
ROLLUP(YEAR, P.Name) provides both product-level totals and yearly subtotals.
Ensures the requirement: "include the yearly sum of order quantities for all the products in each row." References GROUP BY ROLLUP in T-SQL Aggregate functions in Microsoft Fabric warehouses
You have source data in a folder on a local computer.
You need to create a solution that will use Fabric to populate a data store. The solution must meet the following requirements:
* Support the use of dataflows to load and append data to the data store.
* Ensure that Delta tables are V-Order optimized and compacted automatically.
Which type of data store should you use?
You need to create a solution that will use Fabric to populate a data store. The solution must meet the following requirements:
* Support the use of dataflows to load and append data to the data store.
* Ensure that Delta tables are V-Order optimized and compacted automatically.
Which type of data store should you use?
正解：B,C
解答を投票する
解説: (GoShiken メンバーにのみ表示されます)
You have a Fabric tenant that contains customer churn data stored as Parquet files in OneLake. The data contains details about customer demographics and product usage.
You create a Fabric notebook to read the data into a Spark DataFrame. You then create column charts in the notebook that show the distribution of retained customers as compared to lost customers based on geography, the number of products purchased, age. and customer tenure.
Which type of analytics are you performing?
You create a Fabric notebook to read the data into a Spark DataFrame. You then create column charts in the notebook that show the distribution of retained customers as compared to lost customers based on geography, the number of products purchased, age. and customer tenure.
Which type of analytics are you performing?
正解：C
解答を投票する
解説: (GoShiken メンバーにのみ表示されます)
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.
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 Microsoft Power Bl project that contains a file named definition.pbir. definition.pbir contains the following JSON.
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.
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:
We are analyzing the JSON for definition.pbir in a Power BI Project:
{
" version " : " 1.0 " ,
" datasetReference " : {
" byPath " : {
" path " : " ../Sales.Dataset "
},
" byConnection " : null
}
}
Statement 1:
" definition.pbir is in the PBIR-Legacy format. "
No # The legacy PBIR format references datasets by byConnection (pointing to the Power BI service).
Here, it uses byPath, which is the new project format, not legacy.
Statement 2:
" The semantic model referenced by definition.pbir is located in the Power BI service. " No # The JSON shows byPath: " ../Sales.Dataset " , meaning the semantic model is referenced locally within the project folder (Sales.Dataset), not in the Power BI service.
Statement 3:
" When the related report is opened, Power BI Desktop will open the semantic model in full edit mode. " Yes # Since the semantic model is referenced by path (local PBIP project files), Power BI Desktop will open the model in full edit mode. If it had been byConnection, it would open in live connect mode to the service instead.
Final Answer:
PBIR-Legacy format # No
Semantic model in Power BI service # No
Opens in full edit mode # Yes
References:
Power BI Project (PBIP) structure
PBIR formats: byPath vs byConnection
You have a Fabric workspace named Workspacel that contains a lakehouse named Lakehousel. Lakehousel contains a table named Tablel. Table 1 contains the following data.
You need to perform the following actions:
* Load the data from Table! into a star schema.
* Create a product dimension table named DimProduct and a fact table named FactSales.
Which three columns should you include in DimProduct?
You need to perform the following actions:
* Load the data from Table! into a star schema.
* Create a product dimension table named DimProduct and a fact table named FactSales.
Which three columns should you include in DimProduct?
正解：B
解答を投票する
解説: (GoShiken メンバーにのみ表示されます)