DP-600 Free Practice Questions — Page 3

Question 21

You have a Fabric workspace named Workspace1 that contains an eventstream named Eventstream1. Eventstream1 reads data from an Azure event hub named Eventhub1. Eventhub1 contains the following columns. You need to add a continuous percentile calculation to the Payload column. The solution must minimize development effort. What should you do?

Question 22

You have a semantic model named Model1 that contains data that relates to customers and their bank account balances. Model1 has the following tables and columns. A customer can have one or more accounts. Each account can be associated to multiple customers. You need to ensure that users can query Model1 to identify the total transaction amounts by customer. What should you add to Model1?

Question 23

HOTSPOT - You have a Fabric eventhouse that contains a KQL database. The database contains a table named TaxiData that stores the following data. You need to create a column named FirstPickupDateTime that will contain the first value of each hour from tpep_pickup_datetime partitioned by payment_type. How should you complete the query? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Question 24

You have a Fabric warehouse that contains a table named Table1. Table1 contains three columns named SalesAmount, ProductCategory, and TransactionDate. You need to create a Microsoft Power BI query that will calculate the total sales amount of each product category for transactions that occurred during the last quarter. Which two actions should you perform in the visual query editor? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

Question 25

HOTSPOT - You have a Fabric warehouse named Warehouse1 that contains a table named TaxiTrips. TaxiTrips contains the following columns. You need to create a query that shows the top three taxi companies based on the total miles traveled. 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.

Question 26

DRAG DROP - You are implementing two dimension tables named Customers and Products in a Fabric warehouse. You need to create two slowly changing dimensions that meet the requirements shown in the following table. Which type of SCD should you use for each table? To answer, drag the appropriate SCD types to the correct tables. Each SCD type 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.

Question 27

You have a Fabric tenant that contains 30 CSV files in OneLake. The files are updated daily. You create a Microsoft Power BI semantic model named Model1 that uses the CSV files as a data source. You configure incremental refresh for Model1 and publish the model to an F64 capacity in the Fabric tenant. When you initiate a refresh of Model1, the refresh fails after running out of resources. What is a possible cause of the failure?

Question 28

You have a Fabric tenant that contains the workspaces shown in the following table. You have a deployment pipeline named Pipeline1 that deploys items from Workspace_DEV to Workspace_TEST. In Pipeline1, all items that have matching names are paired. You deploy the contents of Workspace_DEV to Workspace_TEST by using Pipeline1. What will the contents of Workspace_TEST be once the deployment is complete?

Question 29

DRAG DROP - You have a Fabric warehouse named Warehouse1 that contains a table named dbo.Product. dbo.Product contains the following columns. You need to use a T-SQL query to add a column named PriceRange to dbo.Product. The column must categorize each product based on UnitPrice. The solution must meet the following requirements: • If UnitPrice is 0, PriceRange is "Not for resale". • If UnitPrice is less than 50, PriceRange is "Under $50". • If UnitPrice is between 50 and 250, PriceRange is "Under $250“. • In all other instances, PriceRange is "$250+". How should you complete the query? To answer, drag the appropriate values to the correct targets. Each value 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.

Question 30

You have a Fabric workspace named Workspace1. You need to create a semantic model named Model1 and publish Model1 to Workspace1. The solution must meet the following requirements: • Can revert to previous versions of Model1 as required. • Identifies differences between saved versions of Model1. • Uses Microsoft Power Bl=I Desktop to publish to Workspace1. • Can edit item definition files by using Microsoft Visual Studio Code. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.