Coursera Microsoft Power BI Data Analyst • STUDY MODE
Practice Quiz
QUESTION 1 OF 33
Which of the following visualizations would be the most appropriate for a categorical analysis of a field with more than 10 separate values?
A
Scatter plot.
B
Pie chart
C
Column chartCorrect Answer
QUESTION 2 OF 33
Within which formatting category would a user adjust the title of a visualization?
A
Conditional formatting
B
GeneralCorrect Answer
C
Visual
QUESTION 3 OF 33
Which of the following conditional formatting settings was used to apply the color hex codes to the visualization?
A
Rules
B
Field valueCorrect Answer
C
Gradient
QUESTION 4 OF 33
Which of the following filtering options offers the capability to apply a filter to all pages of the report?
A
Visualization settings
B
Filters paneCorrect Answer
C
Slicer
QUESTION 5 OF 33
What is the function of the Lock button in the Filters pane filters?
A
Hides the filter from users
B
Locks the filter pane adjustments to users
C
Disables the modification of the filterCorrect Answer
QUESTION 6 OF 33
True or False:The default option of a 16:9 ratio in the report page allows users to specifically adjust the number of pixels of the page’s width and height.
A
True
B
FalseCorrect Answer
QUESTION 7 OF 33
Which of the following settings can be found in the Report page settings? Select all that apply.
A
Visual border
B
Tooltips
C
Wallpaper Correct Answer
D
Filters paneCorrect Answer
QUESTION 8 OF 33
True or False: Custom apps in Power BI do not share the default visualization settings as native Power BI Visualizations.
A
TrueCorrect Answer
B
False
QUESTION 9 OF 33
When dealing with a small number of categories and aiming to show the proportion of each category, which visual is advisable to use in Power BI?
A
Line chart
B
Pie chartCorrect Answer
C
Scatter plot
QUESTION 10 OF 33
True or false: Formatting options in Power BI are split into General and Visual formatting options that are the same across all visualizations.
A
True
B
FalseCorrect Answer
QUESTION 11 OF 33
Which of the following are available options for filtering in the Filters pane? Select all that apply.
A
Filter on this visualCorrect Answer
B
Filter on this pageCorrect Answer
C
Filter on all pagesCorrect Answer
D
Filter on this slicer
QUESTION 12 OF 33
In the activity, how did bookmarks assist you in creating a Power BI presentation of the sales benchmarks for Europe in 2019?
A
Bookmarks increased the report loading speed.
B
Bookmarks saved the relevant filtered state of the report.Correct Answer
C
Bookmarks filtered the dataset to contain only relevant data.
QUESTION 13 OF 33
What information is contained in a bookmark? Select all that apply.
A
Graph position
B
Color Theme
C
Visualization visibilityCorrect Answer
D
Slicer filtersCorrect Answer
QUESTION 14 OF 33
How was Adventure Works able to incorporate a Visualization within another Visualization’s Tooltip?
A
Assigned a report page Tooltip.Correct Answer
B
Changed the Tooltip settings to “Visualization”.
C
Modified the Tooltip to custom by adding additional fields.
QUESTION 15 OF 33
What is the effect on the default Tooltip fields when new fields are added to a tooltip?
A
They are still visible together with the added fields.Correct Answer
B
They are aggregated in a single field.
C
They are replaced by the added fields.
QUESTION 16 OF 33
True or False: When you re-launch a published Power BI Report, the sorting previously applied in a published Power BI Report gets reapplied.
A
TrueCorrect Answer
B
False
QUESTION 17 OF 33
How can a text field, such as a Month name field, be sorted chronologically instead of alphabetically?
A
Applied two-column sorting on the visualization.
B
Adjusting the sorting method from the visualization’s settings.
C
Sorting the field by another column.Correct Answer
QUESTION 18 OF 33
Which of the following design methods are effective when optimizing a Power BI report for mobile use?
A
Utilize simple and focused visualizations.Correct Answer
B
Using text annotations to explain data points.
C
Designing the report on horizontal layout.
D
Creation of a separate layout in Mobile Layout view.Correct Answer
QUESTION 19 OF 33
In Microsoft Power BI, what are bookmarks used for?
A
To quickly navigate to specific states of a report.Correct Answer
B
To link to external data sources.
C
To sort data based on user preference.
QUESTION 20 OF 33
Which of the following interaction options shows the percentage of the applied filter against the whole value on the visualization?
A
HighlightCorrect Answer
B
Filter
C
None
QUESTION 21 OF 33
What is the primary function of the Sync Slicers feature in Power BI?
A
To create new slicers automatically.
B
To synchronize filter selections across multiple report pages.Correct Answer
C
To automatically link slicers with similar data fields.
D
To merge data from different sources.
QUESTION 22 OF 33
In Power BI, what is the primary function of the Selection Pane?
A
To manage the visibility and layering of visuals in a report.Correct Answer
B
To filter data based on specific criteria.
C
To change the data source of the report.
D
To create new visualizations.
QUESTION 23 OF 33
True or False: When you modify visualizations in the Power BI Mobile layout view, they do not change in the desktop layout view.
A
TrueCorrect Answer
B
False
QUESTION 24 OF 33
What is the primary function of the Analyze feature in Microsoft Power BI when examining data trends?
A
To highlight trends and patterns in your dataCorrect Answer
B
To create complex DAX formulas
C
To import new datasets into Power BI
D
To modify data source settings
QUESTION 25 OF 33
The data analysis team at Adventure Works receives a dataset detailing sales figures across various countries. However, the stakeholders are interested in a broader view of the sales performance. They want to see the sales figures aggregated by continents rather than individual countries. How can the data analysis team solve this problem?
A
Requesting the team to recreate the dataset with continents
B
Using treemaps
C
By data groupingCorrect Answer
D
By data binning
QUESTION 26 OF 33
The data analysis team at Adventure Works is analyzing recent data relating to bicycle sales data. They are focusing on varying sale prices. The marketing team has requested that this price data be organized into value categories so that they target different customer segments effectively. Which method should the data analysis team use to categorize continuous sale price data for this targeted campaign planning?
A
Time series analysis
B
Data binningCorrect Answer
C
Data grouping
D
Cluster analysis
QUESTION 27 OF 33
True or False: You can create a new group on any field in the data pane or in a field well.
A
TrueCorrect Answer
B
False
QUESTION 28 OF 33
Which of the following statements is true about data grouping?
A
Data grouping is primarily used for creating visualizations.
B
Data grouping allows you to combine data rows based on specific column values.Correct Answer
C
Data grouping is only useful for text columns.
D
Data grouping creates new fields for each group.
QUESTION 29 OF 33
Which of the following statements is true about anomalies and outliers in a dataset?
A
Anomalies and outliers are data points that conform to the expected pattern.
B
Anomalies and outliers are both explained by the base distribution
C
Identifying and handling anomalies and outliers is generally unnecessary in data analysis.
D
Anomalies and outliers are not always errors or mistakes in the data.Correct Answer
QUESTION 30 OF 33
In Power BI, what is the primary purpose of data grouping?
A
To combine data rows based on specific column values and create a new column for aggregated data.Correct Answer
B
To create histograms for numeric columns.
C
To analyze data in continuous intervals.
D
To arrange multiple visuals for creating dashboards.
QUESTION 31 OF 33
Which of the following is the most suitable option for breaking down a complex metric into its underlying components in Power BI?
A
Forecasting
B
Scatter chart
C
Decomposition trees visual Correct Answer
D
Key influencers visual
QUESTION 32 OF 33
Which of the following are reference line types in Power BI? Select all that apply.
A
Standard Deviation
B
MedianCorrect Answer
C
MaxCorrect Answer
D
PercentileCorrect Answer
QUESTION 33 OF 33
In the context of Power BI, what is a scorecard?
A
A collection of related goals to track progress.Correct Answer
B
A measure that serves as a key indicator of business performance.
C
A visualization in Power BI that assigns scoring on fields based on criteria.
D
Google Advanced Data Analytics
E
Google Cybersecurity Professional Certificate
F
Meta Marketing Analytics Professional Certificate
G
Google Digital Marketing & E-commerce Professional Certificate
H
Google UX Design Professional Certificate
I
Meta Social Media Marketing Professional Certificate
J
Google Project Management Professional Certificate
K
Meta Front-End Developer Professional Certificate
Ready to test your recall?
Which of the following visualizations would be the most appropriate for a categorical analysis of a field with more than 10 separate values?