Coursera Microsoft Power BI Data Analyst • STUDY MODE
Practice Quiz
QUESTION 1 OF 32
Which issues can you address by implementing accessibility features and practices in Microsoft Power BI reports? Select all that apply.
A
Making the report easily understandable to people who use assistive technologies for navigation.Correct Answer
B
Ensuring visually impaired users can understand report visuals.Correct Answer
C
Making Power BI reports easily accessible from the Power BI Service.
D
Helping people with cognitive disabilities understand the report easily.Correct Answer
QUESTION 2 OF 32
A data analyst in your organization cannot use a mouse due to a recent injury. Which feature should you implement in your Microsoft Power BI reports to assist her in navigating and interacting with them?
A
Tab orderCorrect Answer
B
High-contrast colors
C
Focus mode
D
Alt text
QUESTION 3 OF 32
Some of the executives in a recent meeting have complained about feeling overwhelmed by the multitude of visuals on your Microsoft Power BI reports. Which feature should you utilize in Power BI to improve their user experience?
A
High-contrast colors
B
Focus modeCorrect Answer
C
Alt text
D
Tab order
QUESTION 4 OF 32
One of your team members has low vision and relies on a screen reader to understand the contents of a Microsoft Power BI report. He said it was difficult to distinguish between different elements in the report, and the screen reader did not provide enough context for visuals. Which features should you utilize to improve his experience with your Power BI reports? Select all that apply.
A
High-contrast colorsCorrect Answer
B
Alt textCorrect Answer
C
Focus mode
D
Show Data Table
QUESTION 5 OF 32
Your organization has committed to ensuring all Microsoft Power BI reports are accessible. You have implemented several measures, including adding alt text to all visuals and enabling keyboard navigation. However, feedback from a color-blind user indicates that they’re having difficulty interpreting some visuals due to their color usage. Which of the following steps would be most appropriate to improve accessibility for color-blind users further?
A
Enable Focus mode
B
Use high-contrast colors, shaded colors, or pattern fillsCorrect Answer
C
Increase the size of the visuals
D
Add more text descriptions to each report
QUESTION 6 OF 32
Which feature in Microsoft Power BI allows a user to view one visual at a time, potentially aiding users who might get overwhelmed with too many visuals?
A
High-contrast colors
B
Alt text
C
Focus modeCorrect Answer
D
Show as a table
QUESTION 7 OF 32
In the context of creating accessible Power BI reports, what does adding alt text to visuals accomplish?
A
It provides a description of a visual for screen readers.Correct Answer
B
It displays text on the screen when the visual is not properly loaded.
C
It changes the color of the visuals.
D
It allows users to interact with visuals using a keyboard.
QUESTION 8 OF 32
Which of the following are examples of conditional formatting in Power BI? Select all that apply.
A
Changing the background color of a cell in a table based on certain conditionsCorrect Answer
B
Changing the color of data bars based on their valuesCorrect Answer
C
Changing the font size and color of a text field
D
Customizing the color of bars in a bar chart based on predefined thresholdsCorrect Answer
QUESTION 9 OF 32
What is the function of themes in Microsoft Power BI? Select all that apply.
A
Enhancing the visual consistency across reportsCorrect Answer
B
Enabling alignment of reports with brand guidelinesCorrect Answer
C
Changing the colors of each report visual based on various conditions
D
Improving the accessibility and readability of reportsCorrect Answer
QUESTION 10 OF 32
What is the purpose of custom tooltips in Microsoft Power BI?
A
Custom tooltips enable connection to multiple data sources at once.
B
Custom tooltips enhance the aesthetic appeal of visuals.
C
Custom tooltips enhance user engagement by providing interactive insights.Correct Answer
D
Custom tooltips automatically update report data.
QUESTION 11 OF 32
In a business intelligence dashboard, you have two visuals: the first visual represents sales by region, and the second visual represents sales by product. When you select the North region in the first visual, the sales data in the second visual adjusts to show only sales of products in the North region. What is this interaction called?
A
Drill-down
B
Drillthrough
C
Cross-filteringCorrect Answer
D
Cross-highlighting
QUESTION 12 OF 32
You’re exploring an interactive business intelligence dashboard that displays two main visuals. The first chart shows monthly sales across regions. The second chart is a stacked column chart depicting the relationship between Month, Order Quantity, and Order Status. When you select the June bar corresponding to the West region in the first chart, you observe that the columns representing June in the second chart start to highlight particular sections within the stacks. These highlighted portions show the Order Quantity and their respective Order Status for products sold in the West region during June. The rest of the data in the stacked column remains visible but less prominent. What is this interaction called?
A
Cross-filtering
B
Cross-highlightingCorrect Answer
C
Drillthrough
D
Data visualization
QUESTION 13 OF 32
You are creating a multi-page business intelligence dashboard containing multiple levels of data from a retail chain. The main dashboard presents an overview of total sales across all stores. You want users who select the California section to be taken to another page of the report that provides detailed sales data specific to each store in that state, including top-selling products and customer feedback for each individual store. Which feature would be most useful for this deeper level of data exploration?
A
DrillthroughCorrect Answer
B
Drill-down
C
Cross-filtering
D
Cross-highlighting
QUESTION 14 OF 32
You are working with a business report that displays monthly sales data for an entire year. You want to view only the sales data for the months of July, August, and September. Which feature could you use to narrow down and present only the desired data?
A
FilteringCorrect Answer
B
Cross-highlighting
C
Sorting
D
Drillthrough
QUESTION 15 OF 32
Given the provided dataset on employee turnover, order the data points from the broadest (most general) level to the most specific level to establish a proper hierarchy.
What is the benefit of using hierarchy in a report? Select all that apply.
A
Helps organize data from broad to specific levelsCorrect Answer
B
Increases the amount of data you can display in a report
C
Creates a visual relationship among various data fieldsCorrect Answer
D
Helps to create data drill downCorrect Answer
QUESTION 17 OF 32
What is the primary purpose of using drillthrough in Microsoft Power BI?
A
To pivot data and change its orientation in a table
B
To create hierarchies for data fields in the same visualization
C
To drill down into data in the same visualization
D
To navigate from a data point or visual in a main report to a detailed report pageCorrect Answer
QUESTION 18 OF 32
Which of the following statements best describes the purpose of filtering in data analysis?
A
To highlight specific cells or rows in a dataset based on certain criteria or rules
B
To arrange data in a sequential manner
C
To screen out or focus on parts of the data based on specific conditionsCorrect Answer
D
To change the graphical representation of the data
QUESTION 19 OF 32
What best describes the function of cross-filtering in visual reports?
A
It displays the raw data of the selected visual.
B
It highlights specific cells or rows in a dataset based on certain criteria or rules.
C
It allows a selection in one visual to filter out unrelated data in another visual.Correct Answer
D
It highlights the selected data across multiple visuals without changing the displayed data.
QUESTION 20 OF 32
After creating the Sales Detail page in Step 1, what was the total sales revenue displayed in the visualization?
A
$107,300
B
$345,200Correct Answer
C
$411,900
D
$63,500
QUESTION 21 OF 32
True or False: By adding the drillthrough configuration, Microsoft Power BI automatically creates a back arrow button for ease of navigation.
A
TrueCorrect Answer
B
False
QUESTION 22 OF 32
After adding a bookmark for Mountain Bikes sold in March in the final step, what is the total sales revenue displayed when the bookmark is clicked?
A
$411,900
B
$63,500Correct Answer
C
$345,200
D
$107,300
QUESTION 23 OF 32
When synchronizing slicers, which of the following ensures that a slicer synchronizes when other slicers or visualizations are interacted with? Select all that apply.
A
Enable Sync filter changes to other slicersCorrect Answer
B
Navigate to the View menu and select Sync Slicers
C
Ensure that the group name is consistentCorrect Answer
D
Enable Sync field changes to other slicersCorrect Answer
QUESTION 24 OF 32
Which of the following are the benefits of using buttons in a report? Select all that apply.
A
Buttons allow viewers to ask natural-language questions about the report data.
B
Buttons can apply all slicers and clear slicers.Correct Answer
C
Buttons increase the interactivity of your report.Correct Answer
D
Buttons improve the user experience for page navigation.Correct Answer
QUESTION 25 OF 32
You added new visualizations to a report after previously creating a bookmark with the default options. When you select the bookmark, which of the following statements are true? Select all that apply.
A
The previous visualizations will have the bookmarked filters applied to it. Correct Answer
B
The current page of the report will change to the bookmarked page.Correct Answer
C
The new visualizations will have the bookmarked filters applied to it.
D
The new visualizations will appear in a default state.Correct Answer
QUESTION 26 OF 32
Three visualizations, X, Y, and Z, are present in a report. In the Layer Order tab, X is listed first, Y second, and Z third. When the visualizations overlap in the report, which one appears on top?
A
XCorrect Answer
B
Y
C
Z
QUESTION 27 OF 32
At Adventure Works, products are split into 5 main categories. The CEO wants a way to quickly filter by category in the sales report. It is important that any new categories added in the future can also be filtered. Which of the following is most suitable for this task?
A
Drillthrough
B
Button
C
SlicerCorrect Answer
D
Bookmark
QUESTION 28 OF 32
Which of the following are benefits of adding buttons to a report? Select all that apply.
A
They capture specific report states
B
They increase the interactivity of the report.Correct Answer
C
They improve the user experienceCorrect Answer
D
They limit filtering data in the report.
QUESTION 29 OF 32
What is a hyperlink?
A
A link to a Power BI report.
B
A link to a URL on the World Wide Web.Correct Answer
C
A link to a specific Power BI report page.
D
A link to a specific Power BI report state.
QUESTION 30 OF 32
When selecting a bookmark, which of the following are restored by default? Select all that apply.
A
Visualizations stateCorrect Answer
B
Current report pageCorrect Answer
C
Slicers stateCorrect Answer
D
Visualization filter interaction configuration
QUESTION 31 OF 32
True or False: When a value in a slicer is selected, the DAX context changes for connected visualizations.
A
TrueCorrect Answer
B
False
QUESTION 32 OF 32
True or False: Evaluation context influences how calculations are performed in DAX but does not affect the results of the calculations.
A
True
B
FalseCorrect Answer
Ready to test your recall?
Which issues can you address by implementing accessibility features and practices in Microsoft Power BI reports? Select all that apply.
💡Select all 3 correct answers before submitting (0 of 3 selected).
A
Making the report easily understandable to people who use assistive technologies for navigation.
B
Ensuring visually impaired users can understand report visuals.
C
Making Power BI reports easily accessible from the Power BI Service.
D
Helping people with cognitive disabilities understand the report easily.