Microsoft Implementing Analytics Solutions Using Microsoft Fabric (DP-600) Free Practice Test
Question 1
Shortcuts in OneLake are objects that link to other storage locations, which may be internal or external to OneLake. What are two places you can create shortcuts in fabric? (Select 2)
Correct Answer: B,C
Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).
Question 2
Hotspot Question
You have a Fabric tenant that contains a warehouse named WH1.
You have source data in a CSV file that has the following fields:
- SalesTransactionID
- SaleDate
- CustomerCode
- CustomerName
- CustomerAddress
- ProductCode
- ProductName
- Quantity
- UnitPrice
You plan to implement a star schema for the tables in WH1. The dimension 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 that contains a warehouse named WH1.
You have source data in a CSV file that has the following fields:
- SalesTransactionID
- SaleDate
- CustomerCode
- CustomerName
- CustomerAddress
- ProductCode
- ProductName
- Quantity
- UnitPrice
You plan to implement a star schema for the tables in WH1. The dimension 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.
Correct Answer:
Question 3
Hotspot Question
You have a Fabric tenant that contains a warehouse named WH1.
You run the following T-SQL query against WH1.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
You have a Fabric tenant that contains a warehouse named WH1.
You run the following T-SQL query against WH1.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Correct Answer:
Question 4
You have a Microsoft Power BI 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?
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?
Correct Answer: A
Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).
Question 5
You have a Fabric workspace that contains a lakehouse named Lakehouse1. Lakehouse1 contains a Delta Parquet table named FactSales. You use a Describe command to review the history of FactSales and notice that you have over 1000 versions of the table, and the retention policy is six months.
You need to reduce the size of the FactSales table and the number of files in the table. What should you configure on the table?
You need to reduce the size of the FactSales table and the number of files in the table. What should you configure on the table?
Correct Answer: D
Question 6
Drag and Drop Question
You have a Fabric tenant that contains a Microsoft Power BI report named Report1.
Report1 is slow to render. You suspect that an inefficient DAX query is being executed.
You need to identify the slowest DAX query, and then review how long the query spends in the formula engine as compared to the storage engine.
Which five 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.
You have a Fabric tenant that contains a Microsoft Power BI report named Report1.
Report1 is slow to render. You suspect that an inefficient DAX query is being executed.
You need to identify the slowest DAX query, and then review how long the query spends in the formula engine as compared to the storage engine.
Which five 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.
Correct Answer:
Question 7
You are creating a semantic model in Microsoft Power BI Desktop.
You plan to make bulk changes to the model by using the Tabular Model Definition Language (TMDL) extension for Microsoft Visual Studio Code.
You need to save the semantic model to a file.
Which file format should you use?
You plan to make bulk changes to the model by using the Tabular Model Definition Language (TMDL) extension for Microsoft Visual Studio Code.
You need to save the semantic model to a file.
Which file format should you use?
Correct Answer: A
Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).
Question 8
You have a Fabric tenant that contains a workspace named Workspace1.
You plan to deploy a semantic model named Model1 by using the XMLA endpoint.
You need to optimize the deployment of Model1. The solution must minimize how long it takes to deploy Model1.
What should you do in Workspace1?
You plan to deploy a semantic model named Model1 by using the XMLA endpoint.
You need to optimize the deployment of Model1. The solution must minimize how long it takes to deploy Model1.
What should you do in Workspace1?
Correct Answer: B
Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).
Question 9
You are developing a complex semantic model that contains more than 20 date columns. You need to conform the date format for all the columns as quickly as possible. What should you use?
Correct Answer: A
Question 10
Hotspot Question
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.
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.
Correct Answer:
Question 11
Drag and Drop Question
You have Fabric tenant that contains a semantic model named Model1. Model1 contains the following tables.
You are designing a Microsoft Power BI report named Report1 that will deliver near-real-time (NRT) shipping data. Report1 will contain data about many shipped packages.
You need to ensure that each table is in the appropriate storage mode to support Report1. The solution must support near-real-time data delivery while maintaining high query performance.
Which storage mode should you select for each table? To answer, drag the appropriate storage modes to the correct tables. Each mode may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
You have Fabric tenant that contains a semantic model named Model1. Model1 contains the following tables.
You are designing a Microsoft Power BI report named Report1 that will deliver near-real-time (NRT) shipping data. Report1 will contain data about many shipped packages.
You need to ensure that each table is in the appropriate storage mode to support Report1. The solution must support near-real-time data delivery while maintaining high query performance.
Which storage mode should you select for each table? To answer, drag the appropriate storage modes to the correct tables. Each mode may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Correct Answer:
Question 12
You have a Fabric tenant that contains a workspace named Workspace1 and a user named User1. User1 is assigned the Contributor role for Workspace1.
You plan to configure Workspace1 to use an Azure DevOps repository for version control.
You need to ensure that User1 can commit items to the repository.
Which two settings should you enable for User1? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
You plan to configure Workspace1 to use an Azure DevOps repository for version control.
You need to ensure that User1 can commit items to the repository.
Which two settings should you enable for User1? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
Correct Answer: B,C
Question 13
Hotspot Question
You have a Fabric lakehouse named Lakehouse1 that contains the following data.
You need build a T-SQL statement that will return the total sales amount by OrderDate only for the days that are holidays in Australia. The total sales amount must sum the quantity multiplied by the price on each row in the dbo.sales table.
How should you complete the statement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
You have a Fabric lakehouse named Lakehouse1 that contains the following data.
You need build a T-SQL statement that will return the total sales amount by OrderDate only for the days that are holidays in Australia. The total sales amount must sum the quantity multiplied by the price on each row in the dbo.sales table.
How should you complete the statement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Correct Answer:
Question 14
You have a Microsoft Power BI semantic model that contains a measure named TotalSalesAmount. TotalSalesAmount returns a sales revenue amount that is translated into a selected currency.
You need to ensure that the value returned by TotalSalesAmount is formatted to use the correct currency symbol.
What should you include in the solution?
You need to ensure that the value returned by TotalSalesAmount is formatted to use the correct currency symbol.
What should you include in the solution?
Correct Answer: B
Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).
Question 15
You have a Fabric tenant that contains a Microsoft Power BI report.
You are exploring a new semantic model.
You need to display the following column statistics:
- Count
- Average
- Null count
- Distinct count
- Standard deviation
Which Power Query function should you run?
You are exploring a new semantic model.
You need to display the following column statistics:
- Count
- Average
- Null count
- Distinct count
- Standard deviation
Which Power Query function should you run?
Correct Answer: B
Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).