Coursera Microsoft Power BI Data Analyst • STUDY MODE
Practice Quiz
QUESTION 1 OF 37
Based on your observation of the Order Total by Product Color visual, which product color has the highest order total?
A
Green
B
BlueCorrect Answer
C
Red
QUESTION 2 OF 37
Based on your observation of the Order Total by Product Category clustered bar chart, which product subcategory has the lowest order total?
A
Freestyle
B
BalanceCorrect Answer
C
Touring
QUESTION 3 OF 37
Which label did you apply to ensure the data in the report remains within its shared domain?
A
Personal
B
General
C
ConfidentialCorrect Answer
QUESTION 4 OF 37
Which safety measure ensures that users see only specific rows of data in Power BI based on their role or identity?
A
Row-level securityCorrect Answer
B
Data masking
C
Data encryption
QUESTION 5 OF 37
True or False: The People in your organization sharing option in Power BI means that anyone with an email address belonging to the company domain can access the report.
A
TrueCorrect Answer
B
False
QUESTION 6 OF 37
What is the primary purpose of Power BI’s data sensitivity labels?
A
To increase data storage efficiency.
B
To indicate the level of discretion and confidentiality of data.Correct Answer
C
To standardize the naming conventions across datasets.
QUESTION 7 OF 37
What is the purpose of Row-level security (RLS) in Power BI?
A
To ensure data consistency across various reports.
B
To encrypt data during transmission for optimal performance.
C
To display only the data rows that a user’s identity or role permits.Correct Answer
QUESTION 8 OF 37
Which security measure in Power BI allows users to work with obscured versions of sensitive data?
A
Data encryption
B
Data maskingCorrect Answer
C
Roles and permissions
QUESTION 9 OF 37
What is the primary purpose of the People with Existing Access sharing option in Power BI?
A
To nominate individuals by their email addresses.
B
To limit viewership to those previously granted permission.Correct Answer
C
To avoid sharing with new members of the organization.
QUESTION 10 OF 37
True or False: The primary reason for ensuring that recipients cannot reshare your report in Power BI is to maintain data integrity and ensure content is viewed only by its intended audience.
A
TrueCorrect Answer
B
False
QUESTION 11 OF 37
Which of the following statements are correct descriptions of data sensitivity labels?
A
The Highly Confidential label safeguards pivotal proprietary information.Correct Answer
B
The Personal label denotes data linked to specific individuals but not intended for the wider organization.Correct Answer
C
The General label classifies content suitable for a broad audience without specific restrictions.
D
The Restricted label denotes data requiring the utmost secrecy.Correct Answer
QUESTION 12 OF 37
Which Power BI dataset permission primarily allows visual representation without altering the source data?
A
BuildCorrect Answer
B
Write
C
Read
QUESTION 13 OF 37
What is the primary function of dataset permissions in Power BI?
A
To ensure selected individuals have specialized access to data.
B
To increase the complexity of data access.
C
To maintain data visibility.
D
To act as gatekeepers to organizational information.Correct Answer
QUESTION 14 OF 37
True or False: The primary purpose of the Direct Access tab in Power BI Service is to enable users to grant direct access to specific individuals or groups for a particular dataset.
A
TrueCorrect Answer
B
False
QUESTION 15 OF 37
True or False: The primary function of the Links section in Power BI Service is to provide shortcuts to the data source settings and configuration.
A
True
B
FalseCorrect Answer
QUESTION 16 OF 37
Which of the following are accurate descriptions of specific Power BI dataset permissions? Select all that apply.
A
The Read permission allows users to modify and delete datasets.
B
The Write permission is exclusively about viewing and understanding the data.
C
The Build permission lets users construct visuals and reports without altering the source data.Correct Answer
D
The Reshare permission lets users distribute data to other users or teams.Correct Answer
QUESTION 17 OF 37
What action can users who have been granted Build permission take with Power BI source data?
A
Create reports without modifying the data source.Correct Answer
B
Change the source datasets within Power BI.
C
Share datasets with other members of the team.
QUESTION 18 OF 37
What Power BI tab should you select to grant access to a specific individual or group?
A
Links
B
Manage permissions
C
Direct AccessCorrect Answer
QUESTION 19 OF 37
True or False: The primary purpose of defining sharing permissions in the context of sharing Power BI reports externally is to control the access level of external users effectively.
A
TrueCorrect Answer
B
False
QUESTION 20 OF 37
What does row-level security (RLS) primarily manage in Power BI?
A
It manages granular access to data based on predefined roles and rules.Correct Answer
B
It manages the interaction and relationship between different data tables.
C
It manages the validation of data outputs.
QUESTION 21 OF 37
How does static row-level security control users’ access in their respective data domains? Select all that apply.
A
By relying on DAX expressions to specify boundaries for users.Correct Answer
B
By confining users to predetermined and specific segments of data.Correct Answer
C
By providing comprehensive insights across different operational domains.
D
By modifying access levels in response to real-time user activity and role changes.
QUESTION 22 OF 37
Why is naming a role important when configuring static row-level security in Power BI?
A
To facilitate structured management of user access levels.
B
To ensure clarity and avoid potential ambiguities in role management.Correct Answer
C
To ensure precision in defining visibility boundaries.
QUESTION 23 OF 37
True or False: Validating configured roles before publishing a report ensures that the data viewed by the user is exactly what they should be seeing.
A
TrueCorrect Answer
B
False
QUESTION 24 OF 37
How does dynamic row-level security enhance data accessibility for users with multifaceted roles within a company? Select all that apply.
A
By allowing tailored access to data segments per user permissions.Correct Answer
B
By confining users to specific data segments for operational clarity and focus.
C
By utilizing dynamic filters like USERPRINCIPALNAME() to control data access based on the user’s identity.Correct Answer
D
By offering temporary access permissions that expire after a predetermined period.
QUESTION 25 OF 37
True or False: The primary function of Row-Level Security (RLS) in Power BI is to create relationships between different tables in data models.
A
True
B
FalseCorrect Answer
QUESTION 26 OF 37
What action does the View as Roles feature allow you to perform?
A
Validate the roles you’ve created within the Manage Roles window.
B
Test the configuration to ensure the role’s visibility boundaries are accurate.Correct Answer
C
Assign different roles to users of your workspace in Power BI service.
QUESTION 27 OF 37
True or False: A DAX function, or expression, in Power BI can filter data dynamically, ensuring that users only interact with the data assigned to them.
A
TrueCorrect Answer
B
False
QUESTION 28 OF 37
True or False: You configured the frequency of the Profit Margin alert to Every 24 hours to monitor the KPI, as this is the optimal regular interval at which you should monitor pivotal metrics related to Adventure Works’ financial health.
A
True
B
FalseCorrect Answer
QUESTION 29 OF 37
What threshold percentage did you configure for the profit margin for triggering the alert?
A
15% Correct Answer
B
20%
C
10%
QUESTION 30 OF 37
What was the primary purpose of pinning the ProfitMargin KPI to a dashboard in the exercise?
A
To ensure that the KPI is easily accessible for monitoring.Correct Answer
B
To emphasize the importance of the KPI in Adventure Works’ financial health.Correct Answer
C
To allow team members to share KPIs with external stakeholders.
D
To facilitate a streamlined workflow in Power BI.
QUESTION 31 OF 37
What are the primary benefits of subscribing to reports and dashboards within Power BI? Select all that apply.
A
Enhancing real-time collaboration with synchronized report updates.
B
Ensuring the delivery of a more accurate and consistent data stream.
C
Configuring timely and consistent access to critical data insights.Correct Answer
D
Directly automating the delivery of reports and dashboards to your email.Correct Answer
QUESTION 32 OF 37
What do data alerts in Power BI primarily inform users of?
A
When specific conditions are met or exceeded.Correct Answer
B
Analytical trends observed in datasets.
C
Key performance indicators of specific departments.
QUESTION 33 OF 37
What are the benefits of setting up subscriptions in Power BI? Select all that apply.
A
Subscriptions ensure real-time collaboration on reports, allowing teams to make changes simultaneously.
B
Subscriptions boost efficiency and productivity by reducing the time data analysts spend manually retrieving reports.Correct Answer
C
Subscriptions provide instant updates, ensuring subscribers always have the most current data.Correct Answer
D
Subscriptions establish a shared understanding within teams when making decisions if all members are subscribed to the same reports.Correct Answer
QUESTION 34 OF 37
True or False: When you set up a subscription in Power BI, the primary aim is to create new reports and dashboards based on live data feeds.
A
True
B
FalseCorrect Answer
QUESTION 35 OF 37
How do data alerts enhance collaboration within teams?
A
By sending notifications about weekly insights to team members.
B
By offering shared dashboards for team review.
C
By notifying relevant parties about critical data-driven insights.Correct Answer
D
By integrating with other collaboration tools in Power BI.
QUESTION 36 OF 37
True or False: Data alerts in Power BI send notifications when metrics go above or below a predefined threshold.
A
TrueCorrect Answer
B
False
QUESTION 37 OF 37
Which type of visuals in Power BI can you set alerts on?
A
Line graphs and scatter plots.
B
Pie charts and bar graphs.
C
Gauges, KPIs, and cards.Correct Answer
D
Histograms and tree maps.
Ready to test your recall?
Based on your observation of the Order Total by Product Color visual, which product color has the highest order total?