Power BI 778 Security and Administration 1 — Questions and Answers
Question 1: What are the three workspace roles in Power BI Service?
- Owner, Editor, Reader
- Admin, Member, Contributor, Viewer (Correct answer)
- Admin, Contributor, Viewer
- Owner, Contributor, Consumer
Correct answer: Admin, Member, Contributor, Viewer
Power BI workspaces have four roles: Admin, Member, Contributor, and Viewer, each with different levels of access.
Question 2: What is static Row-Level Security (RLS) in Power BI?
- RLS rules that change based on the logged-in user
- RLS rules with hardcoded filter values that restrict data to fixed categories (Correct answer)
- RLS applied dynamically via DAX username functions
- RLS managed through Active Directory groups only
Correct answer: RLS rules with hardcoded filter values that restrict data to fixed categories
Static RLS uses fixed DAX filter expressions with hardcoded values in role definitions to restrict what data members of that role can see.
Question 3: What is dynamic Row-Level Security (RLS) in Power BI?
- RLS that refreshes hourly to update filter rules
- RLS that uses the logged-in user's identity (via USERNAME() or USERPRINCIPALNAME()) to filter data (Correct answer)
- RLS applied at the workspace level instead of the dataset
- RLS that changes based on slicer selections
Correct answer: RLS that uses the logged-in user's identity (via USERNAME() or USERPRINCIPALNAME()) to filter data
Dynamic RLS uses DAX functions like USERPRINCIPALNAME() to filter data based on the logged-in user's email address stored in the data model.
Question 4: What Power BI license is required to share content with external users outside your organization?
- Power BI Free
- Power BI Pro (Correct answer)
- Power BI Premium only
- Power BI Desktop
Correct answer: Power BI Pro
Power BI Pro is required for sharing reports and dashboards with other users, including external guests added via Azure AD B2B.
Question 5: What does the Power BI Admin Portal allow tenant administrators to manage?
- Individual report designs and DAX expressions
- Tenant-wide settings, user permissions, audit logs, and feature controls (Correct answer)
- Power BI Desktop installation on client machines
- Gateway configuration for each dataset individually
Correct answer: Tenant-wide settings, user permissions, audit logs, and feature controls
The Admin Portal gives Power BI tenant admins control over organization-wide settings, including export controls, sharing policies, and audit logs.
Question 6: What is Azure Active Directory (AAD) used for in Power BI?
- Storing Power BI datasets in Azure
- Authenticating users and managing access permissions to Power BI resources (Correct answer)
- Generating DAX expressions automatically
- Managing scheduled refresh for datasets
Correct answer: Authenticating users and managing access permissions to Power BI resources
Azure Active Directory handles authentication and authorization for Power BI, controlling who can access what content based on identity.
Power BI 778 Security and Administration 1
What are the three workspace roles in Power BI Service?