Coursera Microsoft Power BI Data Analyst • STUDY MODE
Practice Quiz
QUESTION 1 OF 36
There are Revenue and Cost columns in an Adventure Works Sales dataset. The profit is defined as Revenue – Cost. Which DAX function should you use to calculate the average profit of the dataset?
What are the different ways a Top N analysis can be applied to a Power BI Report? Select all that apply.
A
By applying a Top N filter on the Filter pane. Correct Answer
B
By utilizing TOP N function in DAX. Correct Answer
C
By selecting Top N option in the Visualization’s options.
D
By typing it into a Q&A visualization. Correct Answer
QUESTION 3 OF 36
When grouping data in Power BI, what happens to the original dataset?
A
The data is aggregated into the new group values.
B
The data is automatically sorted based on grouping criteria.
C
The original dataset remains unchanged. Correct Answer
D
The original dataset is deleted.
QUESTION 4 OF 36
What is the primary goal of applying clustering techniques in Power BI?
A
To identify outliers in the dataset.
B
To group similar data points together. Correct Answer
C
To filter out noisy data points.
D
To create custom clustering visualizations.
QUESTION 5 OF 36
What are the main differences between a histogram bar chart and a standard bar chart in Power BI? Select all that apply.
A
Histogram bar charts display data distribution within bins, while standard bar charts show individual categories. Correct Answer
B
Standard bar charts contain separate fields in their x and y axis, while histograms contain the same field for both axes. Correct Answer
C
Histogram bar chart represents continuous numerical data, while a standard bar chart represents categorical data. Correct Answer
D
Histogram bar chart has separate bars for each category, while a standard bar chart has equal-width bins.
QUESTION 6 OF 36
Which of the following features available for analytics in Power BI groups data points together? Select all that apply.
A
Analyze feature
B
Quick Insights
C
Clustering technique Correct Answer
D
Groups and bins Correct Answer
QUESTION 7 OF 36
Which statistical function in Power BI calculates the middle value of a dataset when arranged in ascending order?
A
Average
B
Deviation
C
Median Correct Answer
D
Count
QUESTION 8 OF 36
Which of the following statements about groups and bins in Power BI are true? Select all that apply.
A
Both groups and bins use existing columns to create new ones with a lower number of distinct values. Correct Answer
B
Groups combine data fields in categories while bin into predefined intervals. Correct Answer
C
Both groups and bins can be used to automatically split data fields into equal.
D
Groups are used for text data, while bins are used for numeric data.
E
Bins automatically label data fields with the predefined. Correct Answer
QUESTION 9 OF 36
Which of the following graphs are the optimal visualizations to represent histograms? Select all that apply.
A
Bar chartCorrect Answer
B
Funnel chart
C
Scatter plot
D
Area chartCorrect Answer
QUESTION 10 OF 36
When it comes to using generated cluster columns in visualizations, which of the following statements are true? Select all that apply.
A
Cluster columns are created only in scatter plots Correct Answer
B
Clustering technique is enabled on both bar and scatter charts
C
A created cluster column can only be a scatter plot’s legend
D
Any visualization can have a created clustered column as axis Correct Answer
QUESTION 11 OF 36
Which of these attributes can support the continuous axis type in Power BI? Select all that apply.
A
Temperature Correct Answer
B
Product weight Correct Answer
C
Employee names
D
Product category
E
Employee hire date Correct Answer
QUESTION 12 OF 36
In this exercise you created a scatter plot to identify the product name distribution on Order Total vs Product Price. Which product name was the definite outlier in the dataset?
A
FreestyleMaster 1000
B
E-TrailBlazer 1000
C
E-TrailBlazer 2000
D
Aerospeed 1000Correct Answer
QUESTION 13 OF 36
For the line chart, what was the percentile increase in Sum of Order Total on the day with the highest sales amount?
A
42.59% increase
B
217.65% increaseCorrect Answer
C
162.50% increase
D
460.00% increase
QUESTION 14 OF 36
When the second highest day in terms of Order Total was identified as March 3rd , which of the two payment methods impacted positively to create the increase?
A
Neither Credit card nor PayPal payments
B
Credit card paymentsCorrect Answer
C
PayPal payments
D
Both Credit card and PayPal payments
QUESTION 15 OF 36
What is the default visual that the Analyze feature creates when the Explain the increase or Explain the decrease options are selected?
A
Pie chart
B
Waterfall chartCorrect Answer
C
Bar chart
D
Scatter plot
QUESTION 16 OF 36
Which of these features are supported by Analyze feature in Microsoft Power BI? Select all that apply.
A
Analyze errors in the dataset
B
Find where the distribution is different Correct Answer
C
Predict Future Trends
D
Explain the increase Correct Answer
E
Explain the decreaseCorrect Answer
QUESTION 17 OF 36
Which of these following visualizations is the most appropriate for time series analysis? Select all that apply.
A
Map visual
B
Card visual
C
Scatter plot Correct Answer
D
Line chartCorrect Answer
E
Bar chart
QUESTION 18 OF 36
Which of these following are types of Reference lines in Power BI? Select all that apply.
Which of the following sentences describes what the Analyze feature in Microsoft Power BI automatically generates?
A
It generates visualizations and adds them to the report.
B
It generates advanced visualizations with insights.
C
It generates DAX measures.
D
It generates charts with insights and patterns from your data Correct Answer
QUESTION 20 OF 36
What is the primary objective of time series analysis in Microsoft Power BI?
A
To add time zone information on time-based data
B
To perform real-time data synchronization across sources
C
To explore patterns and trends within time-based data Correct Answer
D
To create interactive and dynamic dashboards
QUESTION 21 OF 36
What is the primary function of Reference lines in Power BI visualizations?
A
To indicate potential outliers in the dataset
B
To replace the axes labels in a chart or graph with custom lines
C
To create subtotals and aggregate values in tables
D
To highlight specific data points or values Correct Answer
QUESTION 22 OF 36
How do Reference lines enhance the readability and interpretation of visualizations?
A
By changing the color scheme of the visualization
B
By providing additional insights into the underlying data Correct Answer
C
By automatically resizing visualizations for different devices
D
By generating predictive models based on historical data
QUESTION 23 OF 36
What purpose do Error bars serve in Power BI visualizations?
A
They replace the need for error data labels in charts.
B
They indicate the range of potential data variability. Correct Answer
C
They provide a Bar chart with errors in the dataset’s source.
D
They link related data points together.
QUESTION 24 OF 36
Which of the following best defines seasonality in time-series data?
A
Recurring patterns or cycles that occur at regular intervals. Correct Answer
B
The presence of random fluctuations in data points.
C
The overall trend of increasing or decreasing values.
D
Sudden and unpredictable changes in the data’s trajectory.
QUESTION 25 OF 36
According to the relevant chart created, what is the average CO2 emission of the vehicle with the largest volume of Engine Size?
A
157.15
B
360.33 Correct Answer
C
367.75
D
28/46
QUESTION 26 OF 36
Based on the results of the Key influencers visuals, which of the following fuel type attributes are scoring below the Average of CO2 emission line? Select all that apply.
A
Petrol Electric
B
Petrol
C
Electricity/Diesel Correct Answer
D
Petrol LPG Correct Answer
QUESTION 27 OF 36
Which of the following decomposition tree features are driven by AI algorithms? Select all that apply.
A
High value Correct Answer
B
Low value Correct Answer
C
Top segments
D
Quick Insights
QUESTION 28 OF 36
Which column of the VehicleDetails table does not add value when added to the Explain by field of an AI visual?
A
Transmission
B
Car_id Correct Answer
C
Engine Size (cm3)
D
Powertrain
QUESTION 29 OF 36
Between Manual transmission vehicles, what is the fuel type category with the lowest average CO2 emission? Use the decomposition tree to find the answer.
A
Internal Combustion Engine
B
Petrol/LPG
C
Diesel Electric
D
Petrol Electric Correct Answer
QUESTION 30 OF 36
Which tool of the Key influencer visualizations groups major contributing influencers together?
A
Key influencers
B
Explain by
C
Top segments Correct Answer
D
Top Influencer groups
QUESTION 31 OF 36
In which of the following scenarios is the decomposition tree the most suitable visualization?
A
Analysis of customer reviews in feeds
B
Identification of trends in sales patterns Correct Answer
C
Evaluation of employee performance
D
Influence of future pricing strategies
QUESTION 32 OF 36
Which of the following specialized tools of Power BI use AI algorithms to provide insights? Select all that apply.
A
Decomposition treeCorrect Answer
B
Q&ACorrect Answer
C
Line charts
D
Key influencersCorrect Answer
QUESTION 33 OF 36
What does the Top segments tool in the key influencers visualization do?
A
It displays segments of data sorted by the least influential factors.
B
It ranks segments based on the combined influence of multiple factors.Correct Answer
C
It highlights the least common categories within the dataset.
D
It identifies subsets of data that have a negligible impact on the measure.
QUESTION 34 OF 36
What are the primary purposes of the decomposition tree visualization in Power BI? Select all that apply.
A
Highlighting outlier data points
B
Predicting future data trends
C
Identifying root causes of fluctuationsCorrect Answer
D
Ad-hoc exploration of data patternsCorrect Answer
QUESTION 35 OF 36
What is the primary purpose of the Q&A visual in Microsoft Power BI?
A
Enables communication between report users through questions and answers
B
Automate complex data transformations
C
Allows users to ask questions in natural language and generate relevant visualizationsCorrect Answer
D
Provides stakeholders with a channel to ask the Power BI developers technical questions
QUESTION 36 OF 36
The Q&A visualization provides wording underlying to showcase whether the natural language words were interpreted correctly. Which of the following underlying feedback is featured in the visualization? Select all that apply.
A
Double red underlineCorrect Answer
B
Dashed pink underline
C
Solid green underlineCorrect Answer
D
Orange dotted underlineCorrect Answer
Ready to test your recall?
There are Revenue and Cost columns in an Adventure Works Sales dataset. The profit is defined as Revenue – Cost. Which DAX function should you use to calculate the average profit of the dataset?