5. Manage workspaces and datasets in Power BI

Question 1

The following statemnent does explain what data classification tags is

Showing up to the report name, letting anyone viewing it, know the level of security that should be applied to the report

Yes or not

Answer 1

Not it is in the dashboard

Question 2

You have several reports and dashboard in a workspace. You need to grant all users to read access to a dashboard and several reports

Do you assign the users the viewer role to the workspace?

Yes or not

Answer 2

Not

it is inefficient
overly permissive

Question 3

What is the list hierarchie of roles in the Workspace

1. Admin / contributor / member / Viewer
2. Member/ Admin/Viewer/Contributor
   3 Admin/Member / Contributor / Viewer

Answer 3

3 Admin/Member / Contributor / Viewer

Question 4

Which of the following actions can be performed by workspace contributors? (Choose all that apply)

1.Publish an app within the workspace but only after given the ability by the admin or members

2.Update the content and reports within the workspace

3.Schedule the data refreshes

4.Create and Publish the reports within the workspace

5. All of them

😊

Answer 4

5 Alll of them

Question 5

You need to grant a user the ability to add new members to the workspace while adhering to the principle of least privilege, Which role is the most suitable

1. Viewer
   2.Admin
   3.Contributor
   4.Member

Answer 5

3 Contributor

Contributor By assigning the Contributor role to the user, they will have the ability to add new members to the Power BI workspace while adhering to the principle of least privilege. The Contributor role allows users to perform actions such as adding and editing content within the workspace, but it does not grant them full administrative control over the workspace.

Question 6

Row level security is set in workspaces for which type or role

1. Admin
2. Member
3. Contributor
4. Viewer

Answer 6

4. Viewer

Question 7

Which of the following can’t be seen from the data lineage view in Power BI?

A. Where the dataflows are being utilized as a data source for datasets
B. The data sources that are being utilized by the dashboards/reports/datasets in a workspace
C. The credentials utilized to connect to datasets
D. Where gateways are being utilized as a data source for datasets

Answer 7

C

Question 8

You have more than 100 published datasets.Ten of the datasets were verified to meet your corporate quality standards.You need to ensure that the 10 verified datasets appear at the top of the list of published datasets whenever users search for existing datasets.What should you do?

A. Promote the datasets.
B. Certify the datasets
C. Feature the dataset on the home page.
D. Publish the datasets in an app.

Answer 8

A

Question 9

What is the best way to manage workspaces in Power BI?

A. Create a new workspace for each department
B. Use a single workspace for all departments
C. Use a single workspace for each report
D. Use a single workspace for each user

Answer 9

A.

Creating a new workspace for each department allows for better organization and control over the data and reports specific to that department

Question 10

What is the difference between a dataset and a dataflow in Power BI?

A dataset is a single table of data, while a dataflow can contain multiple tables

B dataflow is a single table of data, while a dataset can contain multiple tables

C dataset is used for real-time data, while a dataflow is used for historical data

D dataflow is used for real-time data, while a dataset is used for historical data

Answer 10

A

Question 11

How can you add a dataset to a workspace in Power BI?

1.Import a dataset from a file
2.Connect to a data source
3.Create a new dataset
4. Delete a dataset

Answer 11

2

Question 12

How can you share a workspace with external users in Power BI?

A. Add external users to the workspace
B. Share a dashboard with external users
C. Share a report with external users
D. Use a guest account to share the workspace

Answer 12

A

This allows external users to access all the content within the workspace, including reports, dashboards, and datasets.

Question 13

You have five reports and two dashboards in a workspace.You need to grant all organizational users read access to one dashboard and three reports.Solution: You publish an app to the entire organization.Does this meet the goal?

Yes or not

Answer 13

no

Granularity: Publishing an app grants access to all the content within the app, including all reports and dashboards. In this case, you need to grant access to only one dashboard and three reports, not all five reports and two dashboards.

Security: Publishing an app might not be the most granular or secure approach for granting access. You might want to consider assigning specific roles to users or groups, allowing for more controlled access to specific reports and dashboards.

Question 14

What is the difference between a shared dataset and a published dataset in Power BI?

A. Shared datasets can be edited by multiple users, published datasets cannot
B. Published datasets can be refreshed, shared datasets cannot
C. Shared datasets can be used in multiple reports, published datasets cannot
D. Published datasets can be shared with external users, shared datasets cannot

Answer 14

C. Shared datasets can be used in multiple reports, published datasets cannot

Question 15

What is the best way to organize datasets in Power BI?

A. Use folders to group related datasets
B. Use tags to categorize datasets
C. Use a naming convention to identify datasets
D. Use a separate workspace for each dataset

Answer 15

A

Question 16

How do you create workspaces ( steps)

A Navigate to Power BI admin portal and select Tenant settings
B. Click on Workspace settings and then click on create workspaces
C. Choose specific security groups to apply to and add DA100Workspace

1. A B C
2. B C A
3. C A B

Answer 16

1. A B C

Question 17

You store your dataflows in Azure Data Lake Gen2

Yes or not

Answer 17

Yes

Question 18

You want to share a dashboard with external guest users from another business.
How would you share content with external users?

Invite external guests through the Azure Active Directory B2B

Yes or not

Answer 18

Yes

Question 19

Promote datasets characteristics

1 Promote datasets when they are ready for broad usage.
2Only members in the workspace having Write permission can promote the datasets

A 1 true 2 true
B 1 True 2 False
C 1 False 2 False

Answer 19

B

Every member in the workspace

Question 20

Certification characteristics

1.Request certification for the promoted datasets from an admin user that is given in the Dataset Certification tenant admin setting.
2Certification enhances the security of the dataset.
3 it is a quite selective process that ensures that only truly reliable and authoritative datasets are utilized across the organization.

A 1 true 2 false 3 false
B 1 False 2 False 3 False
C all true

Answer 20

C

Question 21

Your Organization asks to ensure that all the Power BI users who create the region sales reports will be aware of the availability of a high-quality data source.
On behalf of Power BI Admin, how can you achieve this task?

1.From the Tenant Settings of Power BI, enable the certification section, then select users or groups who can certify datasets.
2.Create a new app workspace that contains only the high-quality dataset and add all the organization users as members of the workspace.
3.From the Tenant Settings of Power BI, enable the data protection, then add sensitivity labels to the dataset.
4. From the Tenant Settings of Power BI, remove the ‘build and share permissions’ to all organization users.

Answer 21

1

Question 22

Security Groups are used for granting access to resources like SharePoint sites.

Yes or not

Answer 22

Yes

Question 23

your customer owns a custom BI App based on PowerBI Embedded technology. He requests to scale up the capacity available for his custom BI App.
What do you need to change?

1The licensing plan from Office 365 admin 2center.
3 Tenant settings from the PowerBI admin portal.
4 The Workspace settings from PowerBI Service.
5 Pricing tier from Azure Portal.

Answer 23

5

Question 24

You have a Power BI Workspace named SalesTeamBI Workspace. Michael is a Power BI user who has access to SalesTeamBI Workspace. He is also a member of a Security Group named Sales_Team.
You must prevent Michael from exporting data from SalesTeamBI Workspace.
Solution: From the Microsoft Office 365 Admin center, you remove Michael from the All Users security group.
Does this solution resolve the issue?

YES.
NO.

Answer 24

NO

Question 25

You have a dashboard named Sales_01 hosted on your Company Workspace. You need to share the dashboard with external guest users giving them editing and manage content permissions.
How guest users can be integrated into the Organization users Tenant?(Select two)

1Enable Power BI Premium Capacity.
2It is a tricky question: External users can have only view access.
3Add guest users to Azure Active Directory.
4Enable the Share content with ‘external users’ feature from the Power BI admin portal.

Answer 25

3 and 4

Question 26

Power BI Premium is NOT the option that best fits full accessibility and shareability of app workspaces.

Yes
Not

Answer 26

NO

It is the best option

Question 27

Your company follows a security protocol about data management for which information can’t be provided over the Internet.
You need to plan a solution to ensure that the company will be compliant with the security policy also when using Power BI Service.
What should you include in your recommendation?

1 The on-premises gateway for Power BI.
2 Using Row Level Security (RLS).
3 Power BI report Server.
4 Microsoft Azure ExpressRoute.

Answer 27

4 Microsoft Azure ExpressRoute.

Question 28

You have a Power BI report in an app workspace. You plan to embed a report from the app workspace into a line-of-business application by using Power BI Embedded and APIs REST.
Which information should you provide to the application developers?

1The application token and the report URL.
2The access key and the report ID.
3The report URL and a user name.
4The app workspace name and the access key.

Answer 28

1

Question 29

You manage an app workspace named School Enrollments in the Power BI service. You need to manage the members that have access to the app workspace.

Select the right option:

1From the Office 365 Admin center, click Groups.
2From the Azure AD, click Users.
3From the Power BI Admin portal, click Users.
4From the Power BI Admin portal, click Tenant settings.

Answer 29

1

Question 30

You have several reports and dashboards in a workspace. You need to grant all organizational users to read access to a dashboard and several reports.
Solution: You publish an app to the entire organization.
Does this meet the goal?

Yes
No

Answer 30

yes

Question 31

You are your company’s Power BI expert. You know that data lineage shows you which data sources are used by which datasets. One of your colleagues says he cannot access data lineage.
What could be two possible explanations for data lineage not working?

A Only admins can see the lineage view
B You need a Power BI Pro license to see lineage view
C Lineage only works for DirectQuery datasets
D Lineage view is available only to users with higher than Viewer access to the workspace
E Each user needs to be granted lineage view permission in the tenant settings

Answer 31

B D

Question 32

What type of expression supported by Power BI while extracting data?

SQL, MDX, DAX
SQL, Python, R
SQL, DAX, M