DP-600 Exam Question 51
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.
DP-600 Exam Question 52
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?
DP-600 Exam Question 53
You have a Fabric tenant that contains a semantic model. The model contains 15 tables.
You need to programmatically change each column that ends in the word Key to meet the following requirements:
* Hide the column.
* Set Nullable to False.
* Set Summarize By to None
* Set Available in MDX to False.
* Mark the column as a key column.
What should you use?
You need to programmatically change each column that ends in the word Key to meet the following requirements:
* Hide the column.
* Set Nullable to False.
* Set Summarize By to None
* Set Available in MDX to False.
* Mark the column as a key column.
What should you use?
DP-600 Exam Question 54
You have a Fabric workspace named Workspace1.
You have three groups named Group1, Group2, and Group3.
You need to assign a workspace role to each group. The solution must follow the principle of least privilege and meet the following requirements:
* Group1 must be able to write data to Workspace1, but be unable to add members to Workspace1.
* Group2 must be able to configure and maintain the settings of Workspace1.
* Group3 must be able to write data and add members to Workspace1, but be unable to delete Workspace1.
Which workspace role should you assign to each group? To answer, drag the appropriate roles to the correct groups. Each role may
You have three groups named Group1, Group2, and Group3.
You need to assign a workspace role to each group. The solution must follow the principle of least privilege and meet the following requirements:
* Group1 must be able to write data to Workspace1, but be unable to add members to Workspace1.
* Group2 must be able to configure and maintain the settings of Workspace1.
* Group3 must be able to write data and add members to Workspace1, but be unable to delete Workspace1.
Which workspace role should you assign to each group? To answer, drag the appropriate roles to the correct groups. Each role may
DP-600 Exam Question 55
You have a Fabric tenant that contains a Microsoft Power Bl 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?