Cisco®
Oracle
CompTIA
Checkpoint
ISC
EC-Council
EXIN
Fortinet
ITIL®
Juniper
Microsoft
VMware
Avaya
SAP
Google
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk®
All Vendors
  2. Home
  3. Exams
  4. Microsoft
  5. DP-600

Free Microsoft DP-600 Exam Braindumps (page: 3)

Page 3 of 41
PDF with 198 Questions

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?

  1. Table.schema
  2. Table.view
  3. Table.FuzzyGroup
  4. Table.Profile

Answer(s): D

Explanation:

Power Query M, Table.Profile Syntax
Table.Profile(table as table, optional additionalAggregates as nullable list) as table
About
Returns a profile for the columns in table.

The following information is returned for each column (when applicable): minimum
maximum average
standard deviation count
null count distinct count


Reference:

https://learn.microsoft.com/en-us/powerquery-m/table-profile



View Related Case Study

You need to recommend which type of Fabric capacity SKU meets the data analytics requirements for the Research division.

What should you recommend?

  1. A
  2. EM
  3. P
  4. F

Answer(s): D

Explanation:

Use F SKU for Fabric.

NOTE: Power BI embedded analytics requires a capacity (A, EM, P, or F SKU) in order to publish embedded Power BI content.

Microsoft Fabric
Microsoft Fabric is an Azure offering that brings together new and existing components from Power BI, Azure Synapse, and Azure Data Explorer into a single integrated environment. Fabric uses F SKUs and supports embedding Power BI items.

Scenario:

Data Analytics Requirements
Contoso identifies the following data analytics requirements:
*-> All the workspaces for the Sales division and the Research division must support all Fabric experiences. The Research division workspaces must use a dedicated, on-demand capacity that has per-minute billing. The Research division workspaces must be grouped together logically to support OneLake data hub filtering based on the department name.

For the Research division workspaces, the members of ResearchReviewersGroup1 must be able to read lakehouse and warehouse data and shortcuts by using SQL endpoints.

For the Research division workspaces, the members of ResearchReviewersGroup2 must be able to read lakehouse data by using Lakehouse explorer.

All the semantic models and reports for the Research division must use version control that supports branching.


Reference:

https://learn.microsoft.com/en-us/power-bi/developer/embedded/embedded-capacity



View Related Case Study

HOTSPOT (Drag and Drop is not supported)
Which workspace role assignments should you recommend for ResearchReviewersGroup1 and ResearchReviewersGroup2? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Hot Area:

  1. See Explanation section for answer.

Answer(s): A

Explanation:




Box 1: Viewer ResearchReviewersGroup1
For the Research division workspaces, the members of ResearchReviewersGroup1 must be able to read lakehouse and warehouse data and shortcuts by using SQL endpoints.

Workspace roles in Lakehouse
Workspace roles define what user can do with Microsoft Fabric items. Roles can be assigned to individuals or security groups from workspace view. See, Give users access to workspaces.

The user can be assigned to the following roles:
Admin Member Contributor Viewer
In a lakehouse the users with Admin, Member, and Contributor roles can perform all CRUD (CREATE, READ, UPDATE and DELETE) operations on all data. A user with Viewer role can only read data stored in Tables using the SQL analytics endpoint.

Box 2: Contributor ResearchReviewersGroup2
For the Research division workspaces, the members of ResearchReviewersGroup2 must be able to read lakehouse data by using Lakehouse explorer.

Microsoft Fabric workspace roles


Etc.

Incorrect:
* Member
More permissions compared to Contributor
Scenario:
Identity Environment
Contoso has a Microsoft Entra tenant named contoso.com. The tenant contains two groups named ResearchReviewersGroup1 and ResearchReviewersGroup2.


Reference:

https://learn.microsoft.com/en-us/fabric/data-engineering/workspace-roles-lakehouse https://learn.microsoft.com/en-us/fabric/get-started/roles-workspaces



View Related Case Study

You need to ensure that Contoso can use version control to meet the data analytics requirements and the general requirements.

What should you do?

  1. Store all the semantic models and reports in Data Lake Gen2 storage.
  2. Modify the settings of the Research workspaces to use a GitHub repository.
  3. Modify the settings of the Research division workspaces to use an Azure Repos repository.
  4. Store all the semantic models and reports in Microsoft OneDrive.

Answer(s): C



View Related Case Study

HOTSPOT (Drag and Drop is not supported)
You need to recommend a solution to group the Research division workspaces.

What should you include in the recommendation? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Hot Area:

  1. See Explanation section for answer.

Answer(s): A

Explanation:




Box 1: Domain Grouping method
With the OneLake data hub users can see data across their business domains and filter to see a specific domain that they are interested in, see all authoritative endorsed data in one place and see all the data owned by users to make data management easy as possible in one central location.

Box 2: OneLake data hub
Tool
The OneLake data hub is integrated into multiple experiences within both Fabric service and Power BI Desktop. This integration ensures that users can quickly and easily find necessary data in any context and in a consistent manner. For instance, in Power BI Desktop, users may access the OneLake data hub experience to browse available items and connect with them, thus avoiding the need to create new data sources. This approach fosters a culture of data reusability and helps organizations meet their goals more effectively.



Scenario:

Data Analytics Requirements
Contoso identifies the following data analytics requirements:
*-> The Research division workspaces must be grouped together logically to support OneLake data hub filtering based on the department name.

Identity Environment
Contoso has a Microsoft Entra tenant named contoso.com. The tenant contains two groups named ResearchReviewersGroup1 and ResearchReviewersGroup2.


Reference:

https://blog.fabric.microsoft.com/en-us/blog/microsoft-onelake-in-fabric-the-onedrive-for-data/ https://learn.microsoft.com/en-us/fabric/get-started/onelake-data-hub



Viewing page 3 of 41
Viewing questions 9 - 12 out of 198 questions



Post your Comments and Discuss Microsoft DP-600 exam prep with other Community members:

DP-600 Exam Discussions & Posts