Free Microsoft DP-600 Practice Test & Real Exam Questions
You have a Fabric tenant that contains a semantic model named Model1. Model1 contains a fact table named FactSales. FactSales has a relationship to a dimension table named DimDate on a column named OrderDate.
To FactSales, you add a second relationship between FactSales and DimDate based on a column named ShippedDate.
You need to filter by using ShippedDate in a new report. The solution must NOT affect the function of existing reports.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct answer is worth one point.
To FactSales, you add a second relationship between FactSales and DimDate based on a column named ShippedDate.
You need to filter by using ShippedDate in a new report. The solution must NOT affect the function of existing reports.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct answer is worth one point.
Correct Answer: C,D
Vote an answer
You have a Fabric tenant that contains a workspace named Workspace1. Workspace1 contains a data pipeline named Pipeline1 and a lakehouse named Lakehouse1.
You perform the following actions:
Create a workspace named Workspace2.
Create a deployment pipeline named DeployPipeline1 that will deploy items from Workspace1 to Workspace2.
Add a folder named Folder1 to Workspace1.
Move Lakehouse1 to Folder1.
Run DeployPipeline1.
Which structure will Workspace2 have when DeployPipeline1 is complete?
You perform the following actions:
Create a workspace named Workspace2.
Create a deployment pipeline named DeployPipeline1 that will deploy items from Workspace1 to Workspace2.
Add a folder named Folder1 to Workspace1.
Move Lakehouse1 to Folder1.
Run DeployPipeline1.
Which structure will Workspace2 have when DeployPipeline1 is complete?
Correct Answer: A
Vote an answer
Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).
You have a Fabric warehouse that contains a table named SalesOrderDetail.
SalesOrderDetail contains the following columns:
SalesOrderID
ProductID
OrderQty
Each row represents one product in a sales order.
You have the following T-SQL statement:
You need to calculate the percentage of the total order quantity represented by each product in the same sales order.
Which clause should you use for < answer Choice > ?
SalesOrderDetail contains the following columns:
SalesOrderID
ProductID
OrderQty
Each row represents one product in a sales order.
You have the following T-SQL statement:
You need to calculate the percentage of the total order quantity represented by each product in the same sales order.
Which clause should you use for < answer Choice > ?
Correct Answer: D
Vote an answer
You have a Microsoft Power BI project that contains a file named definition.pbir. definition.pbir contains the following JSON.
Correct Answer:
Explanation:
PBIR-Legacy format # No
Located in Power BI service # No
Opens in full edit mode # Yes
Comprehensive Detailed Explanation
We are analyzing a Power BI Report (PBIR) definition file in JSON format:
{
" version " : " 1.0 " ,
" byPath " : {
" path " : " ../Sales.Dataset "
}
}
}
Step 1: Is this PBIR-Legacy?
PBIR-Legacy format is used when referencing a dataset hosted in the Power BI service (cloud).
In this case, the JSON uses byPath, which references a local dataset file (Sales.Dataset) in the project folder, not a service dataset.
Therefore: No, it is not PBIR-Legacy.
Step 2: Where is the semantic model located?
The datasetReference points to ../Sales.Dataset.
That means the semantic model is stored locally in the project structure, not in the Power BI service.
Therefore: No, it is not located in the Power BI service.
Step 3: What happens when opening in Power BI Desktop?
Since the dataset reference is local (byPath), Power BI Desktop opens the semantic model in full edit mode (allowing schema, relationships, measures, etc. to be modified).
If it were PBIR-Legacy with a service model, only Live Connection mode would be available.
Therefore: Yes, Power BI Desktop opens it in full edit mode.
References
PBIR file structure in Power BI projects
Semantic model references: byPath vs byConnection
Final Answer:
PBIR-Legacy format # No
Located in Power BI service # No
Opens in full edit mode # Yes
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.
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.
Correct Answer: A,B,D
Vote an answer
Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).
You have a Fabric tenant that contains two lakehouses.
You are building a dataflow that will combine data from the lakehouses. The applied steps from one of the queries in the dataflow is shown in the following exhibit.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point.
You are building a dataflow that will combine data from the lakehouses. The applied steps from one of the queries in the dataflow is shown in the following exhibit.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point.
Correct Answer:
Explanation:
Folding in Power Query refers to operations that can be translated into source queries. In this case, " some " of the steps can be folded, which means that some transformations will be executed at the data source level. The steps that cannot be folded will be executed within the Power Query engine. Custom steps, especially those that are not standard query operations, are usually executed within Power Query engine rather than being pushed down to the source system.
References =
Query folding in Power Query
Power Query M formula language
You have a Fabric tenant that contains a semantic model. The model uses Direct Lake mode.
You suspect that some DAX queries load unnecessary columns into memory.
You need to identify the frequently used columns that are loaded into memory.
What are two ways to achieve the goal? Each correct answer presents a complete solution.
NOTE: Each correct answer is worth one point.
You suspect that some DAX queries load unnecessary columns into memory.
You need to identify the frequently used columns that are loaded into memory.
What are two ways to achieve the goal? Each correct answer presents a complete solution.
NOTE: Each correct answer is worth one point.
Correct Answer: C,D
Vote an answer
Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).
You have a Fabric tenant that contains a lakehouse. You plan to use a visual query to merge two tables.
You need to ensure that the query returns all the rows that are present in both tables. Which type of join should you use?
You need to ensure that the query returns all the rows that are present in both tables. Which type of join should you use?
Correct Answer: F
Vote an answer
Note: This section contains one or more sets of questions with the same scenario and problem. Each question presents a unique solution to the problem. You must determine whether the solution meets the stated goals.
More than one solution in the set might solve the problem. It is also possible that none of the solutions in the set solve the problem.
After you answer a question in this section, you will NOT be able to return. As a result, these questions do not appear on the Review Screen.
Your network contains an on-premises Active Directory Domain Services (AD DS) domain named contoso.
com that syncs with a Microsoft Entra tenant by using Microsoft Entra Connect.
You have a Fabric tenant that contains a semantic model.
You enable dynamic row-level security (RLS) for the model and deploy the model to the Fabric service.
You query a measure that includes the username () function, and the query returns a blank result.
You need to ensure that the measure returns the user principal name (UPN) of a user.
Solution: You update the measure to use the USEROBJECT () function.
Does this meet the goal?
More than one solution in the set might solve the problem. It is also possible that none of the solutions in the set solve the problem.
After you answer a question in this section, you will NOT be able to return. As a result, these questions do not appear on the Review Screen.
Your network contains an on-premises Active Directory Domain Services (AD DS) domain named contoso.
com that syncs with a Microsoft Entra tenant by using Microsoft Entra Connect.
You have a Fabric tenant that contains a semantic model.
You enable dynamic row-level security (RLS) for the model and deploy the model to the Fabric service.
You query a measure that includes the username () function, and the query returns a blank result.
You need to ensure that the measure returns the user principal name (UPN) of a user.
Solution: You update the measure to use the USEROBJECT () function.
Does this meet the goal?
Correct Answer: A
Vote an answer
Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).
You have a Microsoft Power B1 report and a semantic model that uses Direct Lake mode. From Power Si Desktop, you open Performance analyzer as shown in the following exhibit.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point.
Correct Answer:
Explanation:
The Direct Lake fallback behavior is set to: DirectQueryOnly
The query for the table visual is executed by using: DirectQuery
In the context of Microsoft Power BI, when using DirectQuery in Direct Lake mode, there is no caching of data and all queries are sent directly to the underlying data source. The Performance Analyzer tool shows the time taken for different operations, and from the options provided, it indicates that DirectQuery mode is being used for the visuals, which is consistent with the Direct Lake setting. DirectQueryOnly as the fallback behavior ensures that only DirectQuery will be used without reverting to import mode.
You have a Fabric tenant that contains a workspace named Workspace1. Workspace1 uses Pro license mode and contains a semantic model named Model1. You need to ensure that Modell supports XMLA connections.
Which setting should you modify?
Which setting should you modify?
Correct Answer: B
Vote an answer
Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).
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.
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.
Correct Answer: B,C,D
Vote an answer
Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).
You have a Fabric tenant that contains a semantic model named Modell. Model! contains a fact table with millions of rows of shipment data.
You need to enable partitioning to improve the query performance and manageability of Modell. Which two tools can you use to achieve the goal? Each correct answer presents a complete solution. NOTE: Each correct answer is worth one point.
You need to enable partitioning to improve the query performance and manageability of Modell. Which two tools can you use to achieve the goal? Each correct answer presents a complete solution. NOTE: Each correct answer is worth one point.
Correct Answer: B,E
Vote an answer
You have a Fabric warehouse that contains a table named Sales.Products. Sales.Products contains the following columns.
You need to write a T-SQL query that will return the following columns.
How should you complete the code? To answer, select the appropriate options in the answer area.
You need to write a T-SQL query that will return the following columns.
How should you complete the code? To answer, select the appropriate options in the answer area.
Correct Answer:
Explanation:
For the HighestSellingPrice, you should use the GREATEST function to find the highest value from the given price columns. However, T-SQL does not have a GREATEST function as found in some other SQL dialects, so you would typically use a CASE statement or an IIF statement with nested MAX functions. Since neither of those are provided in the options, you should select MAX as a placeholder to indicate the function that would be used to find the highest value if combining multiple MAX functions or a similar logic was available.
For the TradePrice, you should use the COALESCE function, which returns the first non-null value in a list.
The COALESCE function is the correct choice as it will return AgentPrice if it ' s not null; if AgentPrice is null, it will check WholesalePrice, and if that is also null, it will return ListPrice.
The complete code with the correct SQL functions would look like this:
SELECT ProductID,
MAX(ListPrice, WholesalePrice, AgentPrice) AS HighestSellingPrice, -- MAX is used as a placeholder COALESCE(AgentPrice, WholesalePrice, ListPrice) AS TradePrice FROM Sales.Products Select MAX for HighestSellingPrice and COALESCE for TradePrice in the answer area.
