Coursera Microsoft Power BI Data Analyst • STUDY MODE
Practice Quiz
QUESTION 1 OF 33
True or False: When you go back to the desktop layout of your dashboard, the mobile optimized layout is deleted, and you need to create it again next time you log in to Microsoft Power BI service?
A
True
B
FalseCorrect Answer
QUESTION 2 OF 33
From the generated report, which of the following is the most profitable product category?
A
Bikes
B
Accessories
C
ComponentsCorrect Answer
QUESTION 3 OF 33
Based on the dashboard, how many units have been sold?
A
370
B
6,560Correct Answer
C
10,234
QUESTION 4 OF 33
True or False: Both Microsoft Power BI dashboards and Microsoft Power BI reports can have multiple pages or tabs.
A
True
B
FalseCorrect Answer
QUESTION 5 OF 33
Adventure Works Customer Service manager wants to visualize an overview of customer satisfaction every Monday morning. As a principal data analyst, you need to design a dashboard, which elements you should include in your dashboard? Select all that apply.
A
Customer support ticket volumeCorrect Answer
B
Total return volumeCorrect Answer
C
Top performing products volume
D
Customer satisfaction rateCorrect Answer
QUESTION 6 OF 33
What component of the Power BI ecosystem is needed to create and optimize dashboards for smartphones?
A
Power Query
B
Power BI Desktop
C
Power BI ServiceCorrect Answer
QUESTION 7 OF 33
What are the key characteristics of Microsoft Power BI report design? Select all that apply.
A
High level KPIs
B
Drill through functionalityCorrect Answer
C
Interactive filteringCorrect Answer
D
Single page layout
QUESTION 8 OF 33
What is the primary goal of creating a dashboard in Power BI?
A
Displaying detailed data exploration.
B
Providing high level insights about the data.Correct Answer
C
Providing a summary of the data with drill through to the details analysis.
QUESTION 9 OF 33
True or False: Once you publish your Power BI report to Power BI service, you can still edit and make changes to any chart of your report in the Power BI service.
A
TrueCorrect Answer
B
False
QUESTION 10 OF 33
When you publish a Power BI report to Power BI service, which of the following components are also published to the service? Select all that apply.
A
Underlying datasetCorrect Answer
B
The data model and relationshipsCorrect Answer
C
Only report page
D
All measures you created.Correct Answer
QUESTION 11 OF 33
True or False:You have created a dashboard in Power BI service and when you select mobile layout, all the visual elements automatically appear in edit mobile layout pane?
A
TrueCorrect Answer
B
False
QUESTION 12 OF 33
You have multiple graphs and charts in your Power BI report. One of the charts shows real-time data about the click trough rates (CTR) of the company’s website. Which of the following is the best dashboard to include this tile?
A
Sales dashboard
B
Marketing dashboardCorrect Answer
C
Customers dashboard
QUESTION 13 OF 33
You are designing a dashboard for the Adventure Works inventory management team. The team needs real-time access to the inventory levels while inspecting the warehouse. What is the most appropriate way to include this information in the dashboard?
A
Create a separate report for the inventory- levels of products and share it with team members.
B
Optimize the dashboard for mobile so each team member can access the information while inspecting the warehouse.
C
Create a QR code of the tile containing the inventory level of products and use the code as an email attachment, orattachment or display it in a common area of your office.Correct Answer
QUESTION 14 OF 33
What file types are supported in a Microsoft Power BI dashboard? Select all that apply.
A
PNGCorrect Answer
B
JPGCorrect Answer
C
BMPCorrect Answer
D
SVG
QUESTION 15 OF 33
True or False: In Microsoft Power BI service, you can pin a visual element from one dashboard to another dashboard.
A
TrueCorrect Answer
B
False
QUESTION 16 OF 33
In Microsoft Power BI, which media types can you add to a dashboard using Edit > Add a tile. Select all that apply.
A
Spreadsheet
B
VideoCorrect Answer
C
ImageCorrect Answer
D
Web contentCorrect Answer
QUESTION 17 OF 33
What live streaming data is stored in Microsoft Power BI memory?
A
PubNub streaming data
B
Streaming dataset
C
Push datasetCorrect Answer
QUESTION 18 OF 33
Your junior colleague designed a dashboard in Microsoft Power BI service, shared it with you, and requested that you duplicate and edit the dashboard. True or False: You cannot make a copy of the dashboard and apply any changes.
A
TrueCorrect Answer
B
False
QUESTION 19 OF 33
Which live streaming dataset is stored in Power BI service to support full report functionality?
A
PubNub streaming dataset
B
Push datasetCorrect Answer
C
Streaming dataset
QUESTION 20 OF 33
Which media types are supported by Microsoft Power BI service? Select all that apply.
A
An image published online.Correct Answer
B
A video hosted on Vimeo.Correct Answer
C
A YouTube playlist.Correct Answer
D
An image from your local computer.
QUESTION 21 OF 33
There is a shared dashboard in your Power BI workspace. You cannot edit it because you are not the creator. True or False: You can generate a QR code for any tile of the shared dashboard.
A
TrueCorrect Answer
B
False
QUESTION 22 OF 33
You have presented a story as a Power BI report for the sales team. Your manager needs to have a QR code for the entire report for easy distribution among the team members. What is the best option you can opt for to fulfil your manager’s needs?
A
Publish report to Power BI service and generate a QR code of the report.Correct Answer
B
Publish report to Power BI service, create a dashboard and pin report visuals to the dashboard and generate QR code.
C
Publish report to Power BI service, pin entire report to dashboard and generate QR code.
QUESTION 23 OF 33
Which alternative chart type can you use instead of a column chart to display current revenue and revenue from the previous year without losing clarity?
A
Line chart
B
Bar chartCorrect Answer
C
Pie chart
QUESTION 24 OF 33
How does your storytelling approach help to present the company’s growth more engagingly and understandably? Select all that apply.
A
By choosing the correct chart type for visualizationCorrect Answer
B
By crafting a clear narrativeCorrect Answer
C
By designing a logical canvas layoutCorrect Answer
D
By managing appropriate relationships between tables
QUESTION 25 OF 33
True or False: You have crafted a growth story for Adventure Works, based on the scenario presented. Both you and the CEO of the company are characters in this data story.
A
TrueCorrect Answer
B
False
QUESTION 26 OF 33
What term describes an important benefit that data provides to help the audience interpret your data story?
A
ContextCorrect Answer
B
Visualization
C
Modeling
QUESTION 27 OF 33
Who can be a character in the data story? Select the correct option.
A
A loyal customer
B
A CEOCorrect Answer
C
A data analystCorrect Answer
D
A marketing managerCorrect Answer
QUESTION 28 OF 33
What are benefits of effective visualization in data storytelling? Select all that apply.
A
Improve audience engagementCorrect Answer
B
Remove errors
C
Reveal patterns and trendsCorrect Answer
D
Provide contextCorrect Answer
QUESTION 29 OF 33
What is the role of a business analytic tool such as Microsoft Power BI in the data storytelling process?
A
It assists in the selection of an appropriate chart type for the data type.
B
It helps in data source optimization.It increases understanding of the narrative by providing context throughout your data story.Correct Answer
QUESTION 30 OF 33
In the context of data storytelling, what does the term conflict refer to?
A
A central issue or challenge that the data analyst aims to resolve.Correct Answer
B
A technical error in the data.
C
A distraction from the main narrative of the story.
QUESTION 31 OF 33
True or False: You have received a donut chart showing the total sales broken down by 13 individual countries. In terms of data storytelling best practices, a donut chart is not an appropriate chart type to display this data.
A
TrueCorrect Answer
B
False
QUESTION 32 OF 33
What purposes does data visualization have in data storytelling? Select all that apply.
A
To improve audience engagement.Correct Answer
B
To provide context and interpret results.Correct Answer
C
To display the data in visually appealing and colorful charts.
D
To explore and communicate data patterns effectively to the stakeholders.Correct Answer
QUESTION 33 OF 33
You are analyzing the Adventure Works sales data for Australia. What is the best way to color code a map visual in the context of data storytelling in Power BI?
A
Add a single color with different saturation levels based on the sales amount.Correct Answer
B
Add an individual color to each Australian state to create a divergent and colorful map.
C
Add product category to the legend well and allow Microsoft Power BI to auto-color each state.
Ready to test your recall?
True or False: When you go back to the desktop layout of your dashboard, the mobile optimized layout is deleted, and you need to create it again next time you log in to Microsoft Power BI service?