Coursera Microsoft Power BI Data Analyst • STUDY MODE
Practice Quiz
QUESTION 1 OF 34
In the context of Adventure Works, what does pinning live reports to the executive dashboard accomplish?
A
It ensures that data is deleted after a certain period of time for security purposes.
B
It sends the dashboard to all employees of Adventure Works.
C
It updates the visual design of the dashboard, making it more appealing for the CEO.
D
It ensures that dynamic and interactive data is readily available to the CEO.Correct Answer
QUESTION 2 OF 34
When building the Power BI executive dashboard for Adventure Works, what step followed uploading the pre-made reports to the Power BI service?
A
Share the dashboard
B
Add Quick Insights
C
Delete the original reports to avoid duplication
D
Create a new dashboard Correct Answer
QUESTION 3 OF 34
Based on the Product Stock by Customer Feedback visual generated using Quick Insights, what is the product stock count for the Positive feedback category?
A
486
B
571Correct Answer
C
306
D
189
QUESTION 4 OF 34
How does a report in Power BI differ from a dashboard?
A
There is no difference between a report and a dashboard in Power BI.
B
A dashboard in Power BI allows for interactive analysis, while a report does not.
C
A report is an in-depth, interactive view of a specific dataset, while a dashboard provides a summary of the most important metrics. Correct Answer
D
A report provides a summary of the most important metrics, while a dashboard is an in-depth, interactive view of a specific dataset.
QUESTION 5 OF 34
In configuring the mobile layout for a Microsoft Power BI dashboard, how do you select which visuals to show on the mobile layout?
A
The visuals are automatically chosen by Power BI based on their related data.
B
By selecting the pin icons next to the desired visualizations.Correct Answer
C
The visuals are chosen based on their alignment with the dashboard’s theme.
D
The visuals that fit best within the mobile screen size are automatically selected.
QUESTION 6 OF 34
What is the primary role of the Quick Insights feature in Power BI?
A
To store additional data for future analysis.
B
To ask questions about the dataset in plain English.
C
To automatically search datasets and visualize potential insights.Correct Answer
D
To immediately implement changes in the dataset.
QUESTION 7 OF 34
What is the primary limitation of pinned visuals in Power B
A
They are not visually appealing.
B
They are challenging to create.
C
They lack interactivity.Correct Answer
D
They can only show limited data.
QUESTION 8 OF 34
How does a dashboard differ from a report in Microsoft Power BI?
A
A report is a one-page view of the most important metrics or key performance indicators (KPIs) selected from one or more dashboards.
B
A report is less interactive than a dashboard.
C
Unlike a report, a dashboard provides an in-depth, interactive, multi-perspective view of a specific dataset.
D
A dashboard is a one-page view of the most important metrics or key performance indicators (KPIs) selected from various pages of one or more reports.Correct Answer
QUESTION 9 OF 34
What is the initial step for creating a new report after importing your data in Microsoft Power BI?
A
Select the Workspace and then create a new reportCorrect Answer
B
Configure the mobile layout of your report
C
Change the theme of your dashboard
D
Drag and drop the data fields into the axis sections of your choice
QUESTION 10 OF 34
In Microsoft Power BI, what is the primary role of the Quick Insights feature?
A
It scans and cleans your data for analysis.
B
It automatically searches datasets to discover and visualize potential insights.Correct Answer
C
It allows you to ask questions about your data in plain English.
D
It displays data in the form of charts and graphs.
QUESTION 11 OF 34
What does the Q&A feature in Microsoft Power BI allow you to do?
A
Import and clean your data for analysis
B
Automatically search datasets to discover and visualize potential insights
C
Ask questions about your data in plain EnglishCorrect Answer
D
Manually create charts and graphs
QUESTION 12 OF 34
What is the advantage of pinning live reports to your Microsoft Power BI dashboard over pinning static visuals?
A
Live reports automatically update every minute.
B
Live reports maintain the interactivity of the original report.Correct Answer
C
You can pin live reports to multiple dashboards.
D
Live reports display only a single type of visualization.
QUESTION 13 OF 34
Based on your observation of the first 10 records in the Adventure Works Product Sales Report, which specific Product ID has the highest product price?
A
Product ID 1003 – Road Bike ‘SpeedMaster 1000’
B
Product ID 1008 – Mountain Bike ‘GravityMaster 2000’Correct Answer
C
Product ID 1005 – Touring Bike ‘Explorer 1000’
D
Product ID 1001 – Mountain Bike ‘TrailBlazer 1000’
QUESTION 14 OF 34
What prerequisite step did you perform before you could publish your Adventure Works report to Power BI Service?
A
Export the report
B
Add new pages for pagination
C
Save the reportCorrect Answer
D
Rename the pages
QUESTION 15 OF 34
After creating the new pages in the Adventure Works report, where did you go to rename these pages?
A
In the File menu
B
In the Page Information menu within the Format page in the Visualizations paneCorrect Answer
C
In the Publish dialog box
D
In the Pages section below the Visualizations and Field panes
QUESTION 16 OF 34
What is the primary function of publishing reports in Microsoft Power BI?
A
To analyze data in your report using Power BI tools.
B
To create a report using Power BI Desktop.
C
To move your report from Power BI Desktop to Power BI Service. Correct Answer
D
To connect your Power BI report with other data visualization tools.
QUESTION 17 OF 34
Which view in Power BI will you use to configure pagination?
A
Report viewCorrect Answer
B
Data view
C
Model view
D
Power Query Editor view
QUESTION 18 OF 34
What is a crucial prerequisite for publishing a report to Power BI Service from Power BI Desktop?
A
You need to delete the report from Power BI Desktop to avoid duplication when publishing.
B
You need to save the report on Power BI Desktop before publishing.Correct Answer
C
You need to open the report in Power BI Service before publishing.
D
The report needs to be a specific size before publishing.
QUESTION 19 OF 34
In the context of Microsoft Power BI, what is the primary purpose of pagination?
A
To combine all visuals on a single page
B
To enhance the speed of data loading
C
To reduce the size of the report file
D
To organize and present data across multiple pages within a reportCorrect Answer
QUESTION 20 OF 34
What is the purpose of report page properties in Microsoft Power BI?
A
To facilitate data storage and backup
B
To speed up the data processing and analysis
C
To enhance the user experience, versatility, and clarity of communication in reportsCorrect Answer
D
To create a bridge between different datasets
QUESTION 21 OF 34
What does the term performance refer to in the context of Microsoft Power BI reports?
A
The size of the data being used in the report
B
The number of visuals in the report
C
The complexity of the calculations in the report
D
The speed and responsiveness of the reportsCorrect Answer
QUESTION 22 OF 34
What is the primary function of the Canvas Settings in Microsoft Power BI’s report page properties?
A
To determine the style of the report page
B
To manage the report page’s naming and contextual information
C
To modify the appearance of the space surrounding the report canvas.
D
To control the dimensions or layout of the report pageCorrect Answer
QUESTION 23 OF 34
When refining the DAX formula of the Total Sales field for optimization, what was one of the key changes you made?
A
Increase the use of CALCULATE function
B
Increase the use of the CROSSJOIN function
C
Remove the SUMX function.
D
Eliminate the nested CROSSJOIN and GENERATESERIES functionsCorrect Answer
QUESTION 24 OF 34
Based on your observation of the first 10 records, which product had the highest Product Weight value?
A
Explorer 1000
B
Voyager 1000
C
TrailBlazer 1000
D
GravityMaster 1000Correct Answer
QUESTION 25 OF 34
Based on your observation of the first 10 records in the sales Data view, which Day of Week has the highest frequency of sales?
A
Tuesday
B
Saturday
C
Wednesday
D
Monday Correct Answer
QUESTION 26 OF 34
Why is it critical to measure the current performance before making changes to a Power BI report?
A
To keep a record of all changes made to the report
B
To understand the current performance situation and identify problem areas.Correct Answer
C
To ensure that all visuals are equally efficient
D
To minimize the use of data storage
QUESTION 27 OF 34
What is the key advantage of simplifying and optimizing a DAX formula in Power BI?
A
It reduces computational load and speeds up query executionCorrect Answer
B
It enhances the formula’s readability and maintainability.
C
It makes the report more adaptable to changes in the data structure
D
It helps ensure that the report performs consistently across different platforms and devices
QUESTION 28 OF 34
How do variables in DAX primarily improve formula readability?
A
By facilitating easier debugging when errors occur in the formula
B
By breaking down lengthy and complex formulas into smaller parts Correct Answer
C
By storing results for visual representation
D
By adding modularization, multiple computations and increasing formula redundancy
QUESTION 29 OF 34
What role does the Card visual play in Power BI when troubleshooting individual variables?
A
It displays a single, prominent value ideal for examining individual variables.Correct Answer
B
It emphasizes specific data points for focused analysis.
C
It provides a summarized view of selected data.
D
It offers a concise visualization for quick insights.
QUESTION 30 OF 34
What does the Performance Analyzer track and document during its recording process?
A
General responsiveness of the report interface
B
The time taken to load each individual visual item in the report Correct Answer
C
The number of data points represented in visuals
D
Loading times for database connections
QUESTION 31 OF 34
What type of file can you export with your report’s performance data from the Performance Analyzer?
A
.ppt file
B
.json file Correct Answer
C
.docx file
D
.xlsx file
QUESTION 32 OF 34
In the context of Microsoft Power BI reports, what is the main advantage of delivering optimized DAX calculations?
A
Reducing the computational load, allowing for more complex data modeling
B
Empowering businesses to make quick and informed decisions by delivering the right information promptly Correct Answer
C
Enhancing the variety and depth of data insights to guide decision-making
D
Achieving faster report generation and export times
QUESTION 33 OF 34
What is the primary advantage of using DAX variables when dealing with repeated calculations in a formula?
A
They save computational effort by storing the value and referencing it. Correct Answer
B
They visualize data in a more appealing way.
C
They ensure a unified data format for easier processing.
D
They alter the data source to simplify calculations.
QUESTION 34 OF 34
Why is breaking down a DAX formula beneficial for data analysts?
A
It simplifies the visual interpretation of data.
B
It ensures more consistent data representation.
C
It optimizes the formula’s performance.
D
It provides a systematic method for troubleshooting. Correct Answer
Ready to test your recall?
In the context of Adventure Works, what does pinning live reports to the executive dashboard accomplish?
A
It ensures that data is deleted after a certain period of time for security purposes.
B
It sends the dashboard to all employees of Adventure Works.
C
It updates the visual design of the dashboard, making it more appealing for the CEO.
D
It ensures that dynamic and interactive data is readily available to the CEO.