Coursera Microsoft Power BI Data Analyst • STUDY MODE
Practice Quiz
QUESTION 1 OF 31
What is the primary task assigned to you by Renee in the Assessing a data set case study?
A
To sort and list the prices of all products, displaying them in descending order
B
To list the products in ascending order by the Supplier and Date Entered columns, respectively.
C
To list the products purchased from suppliers in ascending order by the Date Entered column.
D
To track the price increase on a supplier basis from the past to the present for each product the company purchases from suppliers and detect any unusual price situations, if any.Correct Answer
QUESTION 2 OF 31
In the Assessing a data set case study, which of the following columns need to be considered to track the price increase on a supplier basis from the past to the present for each product and detect anomalies? Select all that apply.
A
Product nameCorrect Answer
B
SupplierCorrect Answer
C
Category
D
Date EnteredCorrect Answer
QUESTION 3 OF 31
Based on your analysis of the data in the Assessing a data set case study, is this dataset suitable for the business need as determined by the task assigned to you by Renee?
A
No
B
YesCorrect Answer
QUESTION 4 OF 31
What type of data is primarily collected, stored, and interpreted by Adventure Works’ Enterprise Resource Planning (ERP) system?
A
Photo and video data
B
Unstructured data
C
Structured dataCorrect Answer
D
Semi-structured data
QUESTION 5 OF 31
Which of the following is the SaaS (Software as a Service) based web application of Microsoft Power BI?
A
Power BI ServiceCorrect Answer
B
Power BI Apps
C
Power BI Desktop
QUESTION 6 OF 31
Which product has strong reporting features and is typically used to begin a workflow in Power BI?
A
Microsoft Power BI Service
B
Microsoft Power BI Apps
C
Microsoft Power BI DesktopCorrect Answer
QUESTION 7 OF 31
If you are given Microsoft Excel data and informed of a business need, what method would you use to determine if the data provided is compatible with the business need?
A
Check if the Microsoft Excel data fulfills the business requirements by examining the format of the data.
B
Check if the Microsoft Excel data fulfills the business requirements by examining its content and data types.Correct Answer
C
Check if the Microsoft Excel data fulfills the business requirements by examining the source of the data.
QUESTION 8 OF 31
You want to publish your report and share your data with others by creating dashboards. Which of the following products would you use to accomplish this?
A
Microsoft Power BI ServiceCorrect Answer
B
Microsoft Power BI Desktop
C
Microsoft Power BI Apps
QUESTION 9 OF 31
True or False: The typical workflow in Microsoft Power BI starts with the creation of a report in Power BI Desktop.
A
TrueCorrect Answer
B
False
QUESTION 10 OF 31
What term is used to classify data such as word-processing files, images, video, and audio files?
A
Structured data
B
Semi-Structured data
C
Unstructured dataCorrect Answer
QUESTION 11 OF 31
What is the main advantage of hybrid storage for Adventure Works?
A
It reduces the IT management overhead.
B
It is the most affordable storage solution.
C
It is suitable for storing only structured data.
D
It combines the benefits of on-premises and cloud-based storage solutions.Correct Answer
QUESTION 12 OF 31
Which statement best describes structured data?
A
Data that is not organized in a predefined format, consisting of data types that do not fit neatly into rows and columns.
B
Data that is easily searchable and analyzable, consisting of data types that can be neatly arranged in rows and columns.Correct Answer
C
Data that is stored on physical hardware located within the company’s premises.
D
Data that is stored on remote servers managed by a third-party provider.
QUESTION 13 OF 31
What data source mentioned in the case study is an example of unstructured data?
A
Financial data
B
Manufacturing data
C
Sales data
D
Social media and online reviews dataCorrect Answer
QUESTION 14 OF 31
In the ETL process, which step involves retrieving raw data from different sources, such as databases and files?
A
ExtractCorrect Answer
B
Load
C
Visualize
D
Transform
QUESTION 15 OF 31
Which method of data ingestion is most suitable for gathering data from many Excel spreadsheets?
A
Database connections
B
Manual data entry
C
Web scraping
D
File-based ingestionCorrect Answer
QUESTION 16 OF 31
You need to consolidate data from multiple sources into a unified view. Which aspect of data management involves this task?
A
Data integration.Correct Answer
B
Data governance.
C
Data quality.
D
Data retention and archiving.
QUESTION 17 OF 31
What is a benefit of on-premises storage?
A
Full control over data and infrastructure.Correct Answer
B
No need for physical hardware.
C
Easy scalability.
D
Reduced IT management overhead.
QUESTION 18 OF 31
What is the primary purpose of the Transform step in the ETL process?
A
To load the transformed data into the final storage system.
B
To clean, structure, and enrich the data to make it more suitable for analysis.Correct Answer
C
To extract data from multiple sources.
D
To analyze and visualize the data.
QUESTION 19 OF 31
Which method of data ingestion allows real-time access to data but may require knowledge of database languages and complex configurations?
A
Data streaming
B
File-based ingestion
C
Web scrapingCorrect Answer
D
Database connections
QUESTION 20 OF 31
What does source data refer to? Select all that apply.
A
Pre-processed data used for analysis and decision-making.
B
Data that has been analyzed and refined for specific purposes.
C
Raw, unprocessed information collected, stored, and managed by an organization.Correct Answer
D
The initial input used as the basis for further processing, transformation, and analysis.Correct Answer
QUESTION 21 OF 31
Which aspect of data management is primarily responsible for establishing clear policies and procedures for data handling throughout an organization?
A
Data archiving
B
Data quality
C
Data security
D
Data governanceCorrect Answer
QUESTION 22 OF 31
Based on the Adventure Works Inventory dataset, what is the RestockingFrequency for the product Kidz-K400?
A
30 days
B
45 daysCorrect Answer
C
60 days
D
90 days
QUESTION 23 OF 31
In the Customer Feedback dataset, which ProductID received a feedback score of 3,5 on May 2023 23rd?
A
51
B
49Correct Answer
C
52
D
50
QUESTION 24 OF 31
According to the Adventure Works Sales dataset, what is the total quantity of products sold on 2023-05-05?
A
2
B
4
C
3Correct Answer
D
1
QUESTION 25 OF 31
What is the primary goal of data cleaning in the context of data analysis?
A
Processing and aggregating data to extract meaningful information.
B
Identifying and correcting errors and inconsistencies in datasets.Correct Answer
C
Altering the structure, format, or values of the data.
D
Implementing data validation rules in the source system.
QUESTION 26 OF 31
How does Power Query promote a structured and repeatable approach to data preparation?
A
By recording data transformation steps in the Applied Steps pane. By automatically generating data visualizations.Correct Answer
B
By creating real-time dashboards.
C
By integrating with third-party applications.
QUESTION 27 OF 31
Which process involves altering the data’s structure, format, or values to make it more suitable for analysis?
A
Data validation
B
Data cleaning
C
Data aggregating
D
Data transformationCorrect Answer
QUESTION 28 OF 31
What is a primary advantage of cleaning data at the source?
A
Eliminating the need for data transformation.
B
Reducing the need for data documentation.
C
Ensuring future analyses have a clean and consistent foundation.Correct Answer
D
Making it easier to import data into Microsoft Power BI.
QUESTION 29 OF 31
Which Excel function can be used to convert text strings into date formats?
A
MATCH()
B
SUMIF()
C
PROPERCorrect Answer
D
UPPER()
QUESTION 30 OF 31
What is the primary function of Power Query in Microsoft’s Microsoft Power BI suite?
A
Data visualization.
B
Sharing and collaboration.
C
Creating advanced calculations.
D
Data connectivity and preparation.Correct Answer
QUESTION 31 OF 31
Which data transformation functions are commonly performed in Power Query? Select all that apply.
A
Changing data types.Correct Answer
B
Filling in missing values.Correct Answer
C
Encrypting data.
D
Removing duplicates.Correct Answer
Ready to test your recall?
What is the primary task assigned to you by Renee in the Assessing a data set case study?
A
To sort and list the prices of all products, displaying them in descending order
B
To list the products in ascending order by the Supplier and Date Entered columns, respectively.
C
To list the products purchased from suppliers in ascending order by the Date Entered column.
D
To track the price increase on a supplier basis from the past to the present for each product the company purchases from suppliers and detect any unusual price situations, if any.