DP-600 V0

HOTSPOT You need to migrate the Research division data for Productline2. The solution must meet the data preparation requirements. How should you complete the code? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer:

You have a Fabric tenant that uses a Microsoft tower Bl Premium capacity. You need to enable scale-out for a semantic model. What should you do first?A . At the semantic model level, set Large dataset storage format to Off.B . At the tenant level, set Create and use Metrics...

You are the administrator of a Fabric workspace that contains a lakehouse named Lakehouse1. Lakehouse1 contains the following tables: • Table1: A Delta table created by using a shortcut • Table2: An external table created by using Spark • Table3: A managed table You plan to connect to Lakehouse1 by...

You have a Fabric workspace that contains a DirectQuery semantic model. The model queries a data source that has 500 million rows. You have a Microsoft Power Bl report named Report1 that uses the model. Report! contains visuals on multiple pages. You need to reduce the query execution time for...

You have a Fabric tenant named Tenant1 that contains a workspace named WS1. WS1 uses a capacity named C1 and contains a dawset named DS1. You need to ensure read-write access to DS1 is available by using the XMLA endpoint. What should be modified first?A . the DS1 settingsB ....

HOTSPOT Which workspace rote assignments should you recommend for ResearchReviewersGroupl and ResearchReviewersGroupZ? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer:

You have a Fabric tenant that contains a lakehouse named lakehouse1. Lakehouse1 contains a table named Table1. You are creating a new data pipeline. You plan to copy external data to Table1. The schema of the external data changes regularly. You need the copy operation to meet the following requirements:...

You need to refresh the Orders table of the Online Sales department. The solution must meet the semantic model requirements. What should you include in the solution?A . an Azure Data Factory pipeline that executes a dataflow to retrieve the minimum value of the OrderlD column in the destination lakehouseB...

You need to provide Power Bl developers with access to the pipeline. The solution must meet the following requirements: • Ensure that the developers can deploy items to the workspaces for Development and Test. • Prevent the developers from deploying items to the workspace for Production. • Follow the principle...

You have a Fabric tenant that contains a warehouse. You use a dataflow to load a new dataset from OneLake to the warehouse. You need to add a Power Query step to identify the maximum values for the numeric columns. Which function should you include in the step?A . Table....