Coursera Microsoft Power BI Data Analyst • STUDY MODE
Practice Quiz
QUESTION 1 OF 40
How many visual elements exist in the report design before the mobile layout?
A
5
B
4
C
3Correct Answer
QUESTION 2 OF 40
In the bubble chart of the report, what does the size of the bubble represent?
A
Total Sales variance %
B
District size
C
Total SalesCorrect Answer
QUESTION 3 OF 40
True or False: After you select a mobile layout for a report, you can change the title properties of any visual element. This setting does not affect the desktop layout.
A
False
B
TrueCorrect Answer
QUESTION 4 OF 40
What is the percentage difference of the Goal value to the Sales values in the KPI visual of the report?
A
6.67%
B
-91.44%
C
+91.44%Correct Answer
QUESTION 5 OF 40
What is the correct path to format the title of the chart?
A local retail company has sales operations in three major cities, the company wants to present the distribution of sales across the cities. Which of the following chart type best presents the percentage contribution by cities towards total sales ensuring visual clarity? Select all that apply.
A
Pie chartCorrect Answer
B
Donut chartCorrect Answer
C
Bar chart
D
Line chart
QUESTION 7 OF 40
Which feature of Power BI desktop allows you to see a single visual in the entire report screen?
A
Focus modeCorrect Answer
B
Drill-down mode
C
Table mode
QUESTION 8 OF 40
Adventure Works wants to analyze its sales data over time, including year level and daily sales values. The company also wants to analyze each salesperson’s performance over the same time period. Which report design best displays the required data?
A
A column chart for the dates and a pie chart for salesperson data.
B
A bar chart with a date hierarchy for drill-down and a line chart for the salesperson data.
C
A bar chart with a date hierarchy and a slicer for salespersons.Correct Answer
QUESTION 9 OF 40
To visualize an Adventure Works Key Performance Indicator (KPI), Microsoft Power BI has a built-in visual called KPI. Which other visual from the visualization pane you can use to display KPI values?
A
GaugeCorrect Answer
B
Funnel chart
C
Card visual
QUESTION 10 OF 40
Which statements are true about dot plot chart? Select all that apply.
A
Dot plot chart enables you to plot categorical data on the horizontal axis of the chart.Correct Answer
B
Dot plot chart is a variation of a scatter plot in Power BI.Correct Answer
C
Dot plot chart can be directly created from the visualization pane of Power BI desktop.
D
Dot plot chart allows you to display relationship between two numerical data values.
QUESTION 11 OF 40
In Microsoft Power BI, which visual can you use to display three numerical data values?
A
Scatter chart
B
Dot chart
C
Bubble chart Correct Answer
QUESTION 12 OF 40
Which statement best describes the drill down operation in Power BI?
A
It involves switching between different pages of the report.
B
It involves aggregating data to a higher level of summarization.
C
It involves filtering data by selecting a data point on a visual.Correct Answer
QUESTION 13 OF 40
True or False: When you format the visuals in the mobile layout canvas, all the formatting, such as font size, will automatically change in the original desktop version of the report?
A
True
B
FalseCorrect Answer
QUESTION 14 OF 40
Which Power BI visual is used for visualizing the density and distribution of data across geographical regions or grids?
A
3D maps
B
Treemaps
C
Heat MapsCorrect Answer
QUESTION 15 OF 40
In the Power BI mobile layout which pane lists all the visuals that are included on the original report page?
A
Selection pane
B
Visuals pane
C
Page Visuals paneCorrect Answer
QUESTION 16 OF 40
True or False: Changing settings in the mobile layout does not affect the desktop layout.
A
TrueCorrect Answer
B
False
QUESTION 17 OF 40
Which chart type is used for exploring relationships between two numerical variables?
A
Pie charts
B
Line Charts
C
Scatter plotsCorrect Answer
QUESTION 18 OF 40
Which chart type displays a single metric and its performance against a target or baseline?
A
KPI ChartCorrect Answer
B
Bubble Chart
C
Pie Chart
QUESTION 19 OF 40
How many state records exist in the data set?
A
51
B
50Correct Answer
C
52
QUESTION 20 OF 40
What is the total sales value for the state of California in the Shapemap?
A
$250,000.00
B
$147,000.00
C
$210,000.00Correct Answer
QUESTION 21 OF 40
What was the data category of the State field before you applied any transformation?
A
UncategorizedCorrect Answer
B
Address
C
Country
QUESTION 22 OF 40
What data type is most suitable for a shape map visual in Power BI?
A
Regionals sales data.Correct Answer
B
Individual data points for precise data representation.
C
Time series data for trend analysis.
QUESTION 23 OF 40
What are some common use cases for choropleth maps in data visualization?
A
Showcasing economic indicators like GDP and unemployment rates.Correct Answer
B
Representing individual data points across different regions.
C
Visualizing abstract data trends without any geographical boundaries.
QUESTION 24 OF 40
What is the correct procedure for utilizing choropleth maps in Power BI to visualize data effectively?
A
Adding a choropleth map visual from the “Visualizations” pane and customizing it to enhance the visualization’s clarity and aesthetics, such as adjusting the color scale and formatting.Correct Answer
B
Selecting a random set of data without considering the data model structure and geographical regions.
C
Using choropleth maps to represent qualitative data and ignoring color intensity for quantitative data representation.
QUESTION 25 OF 40
True or False: You can create a geo-hierarchy in Power BI using a shape map visual from the core visualizations pane?
A
True
B
FalseCorrect Answer
QUESTION 26 OF 40
Which of the following map styles are available to use in the filled map visual of Power BI? Select all that apply.
A
GrayscaleCorrect Answer
B
RoadCorrect Answer
C
Political
D
AerialCorrect Answer
QUESTION 27 OF 40
What is the key difference between Shape and Filled maps in Power BI visualizations?
A
Filled Maps offer predefined geographical boundaries from Bing Maps, while Shape Maps use custom vector files in the TopoJSON format for unique visualizations.
B
Both Shape Maps and Filled Maps use custom vector files in the TopoJSON format to visualize data.
C
Shape map visuals are based on maps that you can find on the Internet, create yourself, or convert to the TopoJSON format. Filled maps in Power BI can leverage the Bing Maps service for enhanced geographical visualization. Correct Answer
QUESTION 28 OF 40
Which Azure map visual feature allows you to display custom information when the user hovers over a data point?
A
Legend
B
Category labels
C
TooltipsCorrect Answer
QUESTION 29 OF 40
What visuals are a geographic representation of areas, such as countries, states, or regions, that are shaded or patterned to illustrate quantitative data values?
A
Choropleth MapsCorrect Answer
B
Shape maps
C
Treemaps
QUESTION 30 OF 40
Which of the following projection methods is used to display three-dimensional earth as a two-dimensional cylindrical projection that converts the globe into a grid, with each rectangular cell having the same size, shape, and area?
A
Orthographic
B
Mercator
C
EquirectangularCorrect Answer
QUESTION 31 OF 40
True or False: Shape maps are most effective when visualized data has clear geographic boundaries.
A
True
B
FalseCorrect Answer
QUESTION 32 OF 40
What is the format of the vector files generally used in Shape Maps?
A
TopoJSONCorrect Answer
B
Shapefiles
C
SVG
QUESTION 33 OF 40
What visual connects to a cloud service hosted to retrieve location data, such as map images and coordinates used to create the map visualization?
A
Choropleth Maps
B
Azure MapsCorrect Answer
C
Shape maps
QUESTION 34 OF 40
What is the potential security risk of using external Python libraries in Microsoft Power BI?
A
Reduced/LimitedCompromised data visualization options.
B
Limited performance and data processing capabilities.
C
Exposure to security vulnerabilities in third-party libraries.Correct Answer
QUESTION 35 OF 40
How can you use Python in Microsoft Power BI? Select all that apply.
A
To retrieve data from the data sources.Correct Answer
B
For data modeling
C
For report optimization
D
To create a custom visualizationCorrect Answer
QUESTION 36 OF 40
True or False: Custom visuals can be created in the Microsoft Power BI desktop and can then be published and shared through the Power BI service.
A
TrueCorrect Answer
B
False
QUESTION 37 OF 40
You are working with a multiple-table data model. If you enable Python scripting in Power BI and import the visualization library, what is the most important thing to do before creating Python visuals?
A
Ensure the data is clean.
B
Ensure the data tables are related in the data model.Correct Answer
C
Ensure the fields used to create the visual do not contain duplicate values.
QUESTION 38 OF 40
What is a potential limitation of a Python visualization in Power BI?
A
You cannot share a Python visual with other team members.
B
You cannot cross-filter a Python visual by making a selection in another core Microsoft Power BI visual.
C
You cannot cross-filter Microsoft Power BI core visuals by selecting a data point from the Python visuals.Correct Answer
QUESTION 39 OF 40
Which of the following statements describes how you can create custom visualizations in Power BI? Select all that apply.
A
RCorrect Answer
B
Power Query
C
PythonCorrect Answer
D
DAX
QUESTION 40 OF 40
True or False: Data fields from different tables must have defined relationships between them.
A
TrueCorrect Answer
B
False
Ready to test your recall?
How many visual elements exist in the report design before the mobile layout?