Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

PL-300 > Deploy & Maintain Assets > Flashcards

Deploy & Maintain Assets Flashcards

1
Q

What is Power BI Gateway?

A

Software that has to be installed to use to get to resources that Power BI generally can’t connect to (on-premises network)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What can Power BI Gateway be used with?

A 
Power BI
Azure Analysis Services
Power Apps
Power Automate
Azure Logic Apps
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What are the 2 types of Power BI Gateway?

A

Standard Mode - allows connections with multiple on-premises data sources for more than one user

Personal Mode - on-premises data gateway is used by only one user to connect to different data sources

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

How does Power BI Function as it relate to cloud services?

A

It functions as a mediator between cloud services and on-premises data sources

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

How do you configure a dataset scheduled refresh?

A

under Datasets, select More options (…) next to a dataset listed.

Select Schedule refresh.

set/define the frequency and time slot to refresh the dataset.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What is row-level security?

A

Row-level security (RLS) with Power BI can be used to restrict data access for given users. Filters restrict data access at the row level, and you can define filters within roles.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What data models can row-level security be configured for?

A

You can configure RLS for data models imported into Power BI with Power BI Desktop. You can also configure RLS on datasets that are using DirectQuery, such as SQL Server.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Where is row-level security configured for live connections and Analysis Azure Services?

A

For Analysis Services or Azure Analysis Services lives connections, you configure Row-level security in the model, not in Power BI Desktop. The security option will not show up for live connection datasets.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Where are roles defined?

A

You can define roles and rules within Power BI Desktop. When you publish to Power BI, it also publishes the role definitions

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What are the steps to defining roles?

A

Import data into your Power BI Desktop report, or configure a DirectQuery connection.

From the Modeling tab, select Manage Roles.

From the Manage roles window, select Create.

Under Roles, provide a name for the role. (You can’t define a role with a comma, for example London,ParisRole.)

Under Tables, select the table to which you want to apply a DAX rule.

In the Table filter DAX expression box, enter the DAX expressions. This expression returns a value of true or false. For example: [Entity ID] = “Value”.

After you’ve created the DAX expression, select the checkmark above the expression box to validate the expression

Select Save.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

How do you validate a role you’ve defined?

A

From the Modeling tab, select View as.
The View as roles window appears, where you see the roles you’ve created.

Select a role you created, and then select OK to apply that role.

The report renders the data relevant for that role.

You can also select Other user and supply a given user.

It’s best to supply the User Principal Name (UPN) as that’s what the Power BI service and Power BI Report Server use.

Within Power BI Desktop, Other user displays different results only if you’re using dynamic security based on your DAX expressions.

Select OK.

The report renders based on what that user can see.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What option in Power BI service will allow you to add users to roles you created in Power BI desktop?

A

Security will take you to the Role-Level Security page where you add members to a role you created in Power BI Desktop.

Only the owners of the dataset will see Security. If the dataset is in a Group, only administrators of the group will see the security option.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

How do you add members to the role in Power BI service?

A

In the Power BI service, select the More options menu for a dataset. This menu appears when you hover on a dataset name, whether you select it from the navigation menu or the workspace page.

Select Security.

you can add a member to the role by typing in the email address or name of the user or security group. You can’t add Groups created in Power BI. You can add members external to your organization.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What groups can you use set up row level security?

A

Distribution Group
Mail-enabled Group
Security Group

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What’s a Mail-enabled security group?

A

Mail-enabled security groups are used for granting access to resources such as SharePoint, and emailing notifications to those users.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What are Distribution groups?

A

Distribution groups are used for sending email notifications to a group of people.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

What are Security groups?

A

Security groups are used for granting access to resources such as SharePoint sites.

18
Q

How do you grant access to datasets?

A

To open the dataset manage permissions page:

From the datasets hub: Select Manage permissions on the More options (…) menu.

or

From the dataset info page: Select the Share icon on the action bar at the top of the page and choose Manage permissions

To modify a user’s permissions, select More options (…) and choose one of the available options.

To grant dataset access to another user, click + Add user. The Share dataset dialog will open.

19
Q

What are Global options in Power BI?

A

Global options are applied to all Power BI Desktop files created or accessed by the user

20
Q

How do you create a workspace in Power BI

A

In Power Bi Service, Select Workspaces > Create workspace.

Give the workspace a unique name. If the name isn’t available, edit it to come up with a name that’s unique.

21
Q

What is the default name of an app created from a workspace?

A

When you create an app from the workspace, by default it will have the same name and icon as the workspace. You can change both when you create the app.

22
Q

What setting options are available in your created workspace?

A

Upload a Workspace image. Files can be .png or .jpg format. File size has to be less than 45 KB.

Specify a Workspace OneDrive to use a Microsoft 365 Group file storage location (provided by SharePoint).

Add a Contact list, the names of people to contact for information about the workspace. By default, the workspace admins are the contacts.

Allow contributors to update the app for the workspace

Assign the workspace to a Premium capacity.

Connect the workspace to an Azure Data Lake Gen2 storage account (in preview). Read about this functionality in the article Configuring dataflow storage to use Azure Data Lake Gen 2.

23
Q

How do you give access to your workspace?

A

Because you have the Admin role in the workspace, on the workspace content list page, you see Access.

Add security groups, distribution lists, Microsoft 365 groups, or individuals to these workspaces as admins, members, contributors, or viewers.

Select Add > Close.

24
Q

How do you assign appropriate workspace roles to users?

A

· UseContributorrole only fordevelopers
· UseMemberrole fordeployment groups
· UseAdminrole for theworkspace admins
· UseViewerrole forbusiness users/end users

25
Q

What are sensitivity labels?

A

Sensitivity labels are information icons that users can apply in Power BI desktop or the Power BI Service.

26
Q

Where can sensitivity labels be viewed?

A

Sensitivity labels can be viewed on reports or dashboards

27
Q

How to turn on Sensitivity labels?

A

Have to be an admin. In Admin Portal go to settings and go to tenant settings & turn on Information Protection (select enable)

28
Q

Where are classifications for sensitivity labels created and defined?

A

Classifications for sensitivity labels are created & defined in Microsoft 365 Compliance Centered

29
Q

How are filters defined for row-level security?

A

Filters are defined within roles for RLS.

30
Q

What does dynamic row-level security allow you to do with data?

A

Dynamic Row Level security allows you to display different data to users within the same role.

31
Q

What must the data model contain to utilize dynamic row-level security?

A

Your data model must contain the usernames of people who should have access to the relevant rows of data.

32
Q

What two functions does Power BI have that allow you to get the user name of the current user for Dynamic Row-Level security?

A

USERNAME

USERPRINCIPALNAME

33
Q

What will the DAX function USERNAME return?

A

DOMAIN\User

34
Q

What will the DAX function USERPRINCIPALNAME return?

A

UPN (like email) - when you have a column in your data that contains the email address you can filter using USERPRINCIPALNAME

35
Q

What is Object-level security?

A

Object Level Security hides tables, columns, and measures but also secures them

36
Q

What 3rd party application is used to implement object-level security?

A

Tabular Editor

37
Q

How do you view the impact analysis of a dataset?

A

In the dataset menu, select “view lineage”

38
Q

Where is incremental refresh set up?

A

For incremental refresh to work in Power BI service you must configure incremental refresh in Power BI desktop

39
Q

What are the steps to set up incremental refresh?

A

In Power BI desktop,

Create the RangeStart and RangeEnd parameters
Filter by using the RangeStart and RangeEnd parameters
Define incremental refresh policies

40
Q

What are the two ways you can endorse Power BI Content?

A

Promote & Certify

41
Q

What does it mean to promote Power BI content?

A

Content that is promoted means it is ready to be used by others. Any contributing member of the workspace where the content resides can promote it.

42
Q

What does it mean to certify Power BI content?

A

Content can be certified to show that it is recommended for use, meaning it is highly reliable. Only individuals who are selected by the Power BI tenant admins can certify Power BI Content

PL-300 (7 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions