Coursera Microsoft Power BI Data Analyst • STUDY MODE
Practice Quiz
QUESTION 1 OF 28
Which step in the ETL process includes sending the transformed data into the target database?
A
Transform
B
Extract
C
LoadCorrect Answer
QUESTION 2 OF 28
Which of the following options can describe staging? Select all that apply.
A
Used primarily in Exploring Relationships.
B
Simplifies the process of data cleansing and consolidation for operational data.Correct Answer
C
Allows raw data to be stored and prepared for further processing in a data pipeline.Correct Answer
D
Acts a bridge between the data sources and the data warehouse.Correct Answer
QUESTION 3 OF 28
True or False: The existence of a data staging area is not obligatory for your ETL jobs.
A
TrueCorrect Answer
B
False
QUESTION 4 OF 28
You import two Microsoft Excel tables named SalesData2020 andSalesData2021 into Power Query.
A
SalesDate
B
ProductKey
C
ResellerKey
D
EmployeeKey
E
Quantity
F
Discount
G
Unit Price
H
Sales
I
Import SalesData2020 and SalesData2021 tables.Correct Answer
J
Right-click the tables and disable the load by clearing the checkbox Enable load.Correct Answer
K
Load data of SalesData2020 and SalesData2021 tables.
L
Right-click the Queries pane at the left menu of Power Query, select New Group and create a group. Then move the tables to the newly created group.Correct Answer
QUESTION 5 OF 28
When the Power Query window is opened and the transformations are completed, you are ready to load the tables into the reporting area. What should you do to complete this task?
A
Close
B
Apply
C
Close & ApplyCorrect Answer
QUESTION 6 OF 28
Which option must be selected to load data directly into the reporting area when the Get Data window is opened?
A
Select the correct option.
B
LoadCorrect Answer
C
Transform Data
D
Cancel
QUESTION 7 OF 28
Which of these issues can be considered as an advantage of using staging in Power BI?
A
Consolidate data easier.Correct Answer
B
Manage data effectively.Correct Answer
C
Identify errors in datasets.
D
Combine datasets.
QUESTION 8 OF 28
Which of the following operation gives you the percentage of valid, error, or empty values found in columns?
A
Column qualityCorrect Answer
B
Column profile
C
Column distribution
QUESTION 9 OF 28
What is the empty percentage of ProductKey column rows?
A
13
B
11Correct Answer
C
16
QUESTION 10 OF 28
How many unique and distinct values are there in the Price column?
A
18 distinct, 17 uniqueCorrect Answer
B
18 distinct, 18 unique
C
17 distinct, 17 unique
QUESTION 11 OF 28
Which column characteristic gives the most frequently repeated value in selected records? Select the correct option.
A
ModeCorrect Answer
B
Average
C
Min
QUESTION 12 OF 28
Which menu item gives the distinct and unique row values amounts for a selected column?
A
Column DistributionCorrect Answer
B
Column Profile
C
Column Quality
QUESTION 13 OF 28
Which of the following Power Query menu items provides the user with column information like the number of empty and distinct rows and rows with errors?
A
Column ProfileCorrect Answer
B
Column Distribution
C
Column Quality
QUESTION 14 OF 28
Which of the following is defined as a data point that significantly deviates from other observations?
A
Anomaly
B
OutlierCorrect Answer
C
Standard Deviation
QUESTION 15 OF 28
True or False: Distinct is known as “total number of different values”, regardless of how many of each we have. Unique is known as “total number of values that only appear once”. In this case, for fields with Primary Key or Unique Constraint defined, the values of Unique and Distinct will be equal.
A
TrueCorrect Answer
B
False
QUESTION 16 OF 28
You import an Excel table named EmployeeData2023 into Power Query. You removed all other columns except Country.
A
USA
B
France
C
Ireland
D
England
E
Spain
F
3 unique and 7 distinct
G
2 unique and 8 distinct
H
1 unique and 5 distinct
I
2 unique and 5 distinctCorrect Answer
QUESTION 17 OF 28
You need to identify if data in a column contains Empty values. Which of the following can be used to quickly identify this? Select all that apply.
A
Column Distribution
B
Column QualityCorrect Answer
C
Column ProfileCorrect Answer
QUESTION 18 OF 28
Which of the following statements is true about Power BI dataflows?
A
Dataflows allow advanced coding for complex transformations.
B
Dataflows can only connect to cloud-based data sources.
C
Dataflows are only available in Power BI Desktop.
D
Dataflows enable self-service data preparation and integration.Correct Answer
QUESTION 19 OF 28
Which of the following join types is selected when merging or joining multiple queries as the most efficient merge strategy?
A
Inner joinCorrect Answer
B
Full outer join
C
Left outer join
QUESTION 20 OF 28
True or False: You prioritize and schedule resource-intensive operations towards the end of the data transformation process. This approach ensures that complex calculations, merging large datasets, and applying multiple transformations on a significant number of rows are executed efficiently, leading to faster data loading and more responsive reports.
A
TrueCorrect Answer
B
False
QUESTION 21 OF 28
You are working on a data analysis project for Adventure Works. The company provides you with a large dataset containing information about sales, production, and inventory. Your task is to perform complex data transformations and calculations to derive meaningful insights from the data.
A
In this scenario, how can the Advanced Editor in Power BI be beneficial for your data analysis process?
B
It allows you to import and connect to various data sources to consolidate the dataset.
C
It provides advanced scripting capabilities for customizing data transformations.Correct Answer
D
It offers a wide range of visualizations to present the analysis results.
QUESTION 22 OF 28
Which of the following terms can be considered as the benefits of Reference Queries? Select all that apply:
A
ReusabilityCorrect Answer
B
EfficiencyCorrect Answer
C
Scalability Correct Answer
D
Connectivity
QUESTION 23 OF 28
Which one of the following options is considered a best practice when working with Power Query?
A
Performing expensive operations at the end of the process.Correct Answer
B
Choosing the most visually appealing color palette for your reports.
C
Keeping all data in a single table for simplicity.
QUESTION 24 OF 28
What is the primary purpose of dataflows in Power BI?
A
To centralize and manage data preparation processes.Correct Answer
B
To create interactive visualizations for business insights.
C
To visualize and analyze data in Power BI reports.
QUESTION 25 OF 28
Referencing queries eliminates the need to repeat time-consuming data transformation steps.
A
EfficiencyCorrect Answer
B
Reusability
C
Scalability
QUESTION 26 OF 28
Which of the following impacts must be considered when choosing to use a Reference Query?
A
Frequency and timing of refreshes.Correct Answer
B
Refreshing referenced queries.Correct Answer
C
Ease of maintenance.Correct Answer
D
Centralization of data.
QUESTION 27 OF 28
What is the primary purpose of using query parameters in Power BI?
A
To create adaptable, reusable queries for efficient data retrieval and transformation.Correct Answer
B
To change the visual design of the reports.
C
To connect Power BI with different databases.
D
To promote ease of query duplication for different variables.
QUESTION 28 OF 28
What are the functionalities of the Advanced Editor in Microsoft Power Query?
A
To write, modify, and debug M code.Correct Answer
B
To perform data transformations, calculations, and aggregations.Correct Answer
C
To design data models and create visualizations for analysis.
D
To connect to external data sources.
Ready to test your recall?
Which step in the ETL process includes sending the transformed data into the target database?