Coursera Microsoft Power BI Data Analyst • STUDY MODE

Practice Quiz

QUESTION 1 OF 36

Several columns in your worksheet contain missing or null values. Which of the following options must you type in the Value to Find field to locate these values?

NullCorrect Answer

Missing

QUESTION 2 OF 36

What steps did you take to address inconsistencies in date columns in your worksheet? Select all that apply.

You changed the data type of the column to Text by clicking on the DataType icon next to the column name.

You dropped duplicate rows by selecting Remove Duplicates inside the Remove Rows menu.

You changed the data type of the column to Date by clicking on the Data Type icon next to the column name.Correct Answer

You replaced any empty values with a default date using the Replace Values tool.Correct Answer

QUESTION 3 OF 36

True or false: Once you completed all the data cleaning steps, you clicked Apply or Close & Apply to apply all the transformations you made. 

False

TrueCorrect Answer

QUESTION 4 OF 36

Which of the following operations are steps in the data transformation process? Select all that apply.

Creating insights from data

Cleaning dataCorrect Answer

Shaping dataCorrect Answer

Removing dataCorrect Answer

QUESTION 5 OF 36

Which of the following data types are part of the number type group? Select all that apply.

Text

Whole numberCorrect Answer

Binary

Fixed decimal number  Correct Answer

QUESTION 6 OF 36

Which one of the following features are used to track, re-order or delete the steps completed in Power Query?

Applied StepsCorrect Answer

Properties

New Source

Queries

QUESTION 7 OF 36

Which of the following options can be used for Power Query Optimization? Select all that apply.

Filter rows in the queries.Correct Answer

Choose only the columns that you will use in the data model.Correct Answer

Choose the right data types for columns.Correct Answer

QUESTION 8 OF 36

You have added a new source that displays NaN (Not a Number) values in Power Query. Which of the following issues could occur if these are not resolved? Select all that apply.

Skewed statistical resultsCorrect Answer

Incorrect calculationsCorrect Answer

Misleading insightsCorrect Answer

Normal distribution in data

QUESTION 9 OF 36

Which of the following statements describes the pivot operation in Power BI? Select all that apply.

The pivot operation converts data from a narrow format to a wide format by reorganizing the data structure.Correct Answer

The pivot operation is used for data aggregation and summarization by converting rows into columns.Correct Answer

The pivot operation supports data normalization by converting column headers into row values.

The pivot operation involves transforming data from a wide format to a narrow format.

QUESTION 10 OF 36

Which table do you use as the first table in the AppendQueries window?

AdventureWorksSalesCorrect Answer

Consolidated Sales

OtherSales 

QUESTION 11 OF 36

How many columns are there in the new query ConsolidatedSales, after you combined the AdventureWorksSales and OtherSales queries?

8Correct Answer

QUESTION 12 OF 36

True or False:  To append all respective columns between two queries successfully, you first need to make sure that there is an equal number of columns, the same column names and the same or convertible data types respectively.   

False

TrueCorrect Answer

QUESTION 13 OF 36

How many rows are there in the new query Consolidated Sales, after you combined AdventureWorksSales and OtherSales queries?

124Correct Answer

100

QUESTION 14 OF 36

Data transformation is the process of preparing data for analysis.

TrueCorrect Answer

False

QUESTION 15 OF 36

What is the primary purpose of Power Query in Power BI?

To create insightful visualizations and reports.

To predict future trends and patterns in the data.

To facilitate seamless data preparation for analysis and visualization.Correct Answer

To automate the process of sharing reports and dashboards.

QUESTION 16 OF 36

What is the purpose of the Applied Steps section in the Power Query Editor?

To preview the data after the applied transformations.

To display a list of all the queries in your Power BI project.

To show the sequence of transformations applied to the selected query.Correct Answer

To provide a graphical user interface for designing and managing queries.

QUESTION 17 OF 36

How does removing unnecessary columns from a dataset benefit the data analysis process?

It reduces the dataset size, making it easier to manipulate and process.Correct Answer

It makes the dataset look more visually appealing.

It changes the structure of the dataset entirely.

It creates new columns with more relevant data.

QUESTION 18 OF 36

Which of these issues in Power Query within Power BI is related to the presence of empty cells in your dataset?

Inconsistent data types

Duplicate rows

Missing or null valuesCorrect Answer

Data entry errors

QUESTION 19 OF 36

Which one of the following describes the reason for Adio’s request to combine two different sales datasets together?

Enriching data

Creating relationships

Consolidating informationCorrect Answer

Enhancing analysis

QUESTION 20 OF 36

Which of the following is the operation of putting two or more tables or queries in one master table together?

AppendingCorrect Answer

Merging

Combining

QUESTION 21 OF 36

Which feature allows you to add rows of different data sources together in Power Query?

AppendingCorrect Answer

Grouping

Removing Data

Merging

QUESTION 22 OF 36

Which of the following can be considered as a reason for combining data? Select all that apply.

Simplifying data managementCorrect Answer

Visualizing data

Consolidating informationCorrect Answer

Creating relationshipsCorrect Answer

QUESTION 23 OF 36

True or False: You can combine the tables in two different ways: merging and appending.

TrueCorrect Answer

False

QUESTION 24 OF 36

You import two Microsoft Excel tables named ContactInfo and Address into Power Query. 

CustomerID

CustomerName

Phone

Address

ContactID

ContactName

ZipCode

Remove ZipCode from ContactInfo

Add a calculated column to the Address table

Check the column types and make sure they have the same types respectively.Correct Answer

Change the column naming in ContactInfo from ContactID to CustomerID and ContactName to CustomerNameCorrect Answer

QUESTION 25 OF 36

You import 2 Microsoft Excel tables named ContactInfo and Address into Power Query. ContactInfo has 5 columns and 18 rows, whereas Address has 4 columns and 12 rows. Only 2 of the column names are common. You append the tables without changing the table columns. How many columns and rows are you going to have at the end of the append?

9 Columns, 30 Rows

5 Columns, 18 Rows

7 Columns, 30 RowsCorrect Answer

5 Columns, 30 Rows

QUESTION 26 OF 36

How many columns are there in the final Consolidated Sales dataset, after you merged the (Sales) and (Product) queries, add (Product.Product) and remove (Reseller), (Employee) and (Sales Territory Key) columns?

7Correct Answer

QUESTION 27 OF 36

True or false: After you import two data sources to combine, you observed that there is no NULL value ProductKey column for the Sales table. You applied Left outer join to merge the tables. If you had used Inner join, there would not have been a change in the number of rows because there are no null values in the product column.

TrueCorrect Answer

False

QUESTION 28 OF 36

Exactly how many rows are there in the Sales query, after you merged the Sales and Product queries?  

999

57851Correct Answer

47655 

QUESTION 29 OF 36

Which of the following options can be considered as the purposes of join operation? Select all that apply.

Integrating dataCorrect Answer

Ensuring consistencyCorrect Answer

Exploring relationshipsCorrect Answer

Creating insights from data

QUESTION 30 OF 36

Which type of JOIN operation includes only the matching records from both joined tables?

INNER JOINCorrect Answer

LEFT OUTER JOIN

FULL OUTER JOIN

QUESTION 31 OF 36

Which of the following pairs can be considered as a master table – pre defined table foreign key relationship? 

Employee – DepartmentCorrect Answer

Customer – CityCorrect Answer

Order – StatusCorrect Answer

Customer – Surname

QUESTION 32 OF 36

Which feature allows you to combine related data between differently structured data sources in Power Query?

Grouping

MergingCorrect Answer

Appending

QUESTION 33 OF 36

Which of the following can be considered as a purpose of merging data with joins? Select all that apply:

Integrating DataCorrect Answer

Expanding Data

Exploring RelationshipsCorrect Answer

Matching Related DataCorrect Answer

QUESTION 34 OF 36

True or False. The full outer join is useful when you want to retrieve all the records from both tables, regardless of whether they have matching values in the join condition.

TrueCorrect Answer

False

QUESTION 35 OF 36

You import 4 Microsoft Excel tables named Sales, Product, Reseller and Employee into Power Query. 

SalesOrderNumber

OrderDate

ProductKey

ResellerKey

EmployeeKey

SalesTerritoryKey

Quantity

Unit Price

Sales

Cost

Join Sales and Reseller  tables based on the EmployeeKey column.

Check the column types of (ProductKey), (ResellerKey) and (EmployeeKey) in the Sales, Product, Reseller and Employee tables.Correct Answer

Merge the Sales table with the Product, Reseller and Employee tables respectively.Correct Answer

Join Sales and Product tables based on the ProductKey column.Correct Answer

QUESTION 36 OF 36

You import two Microsoft Excel tables named Product and Categories into Power Query. There are 319 rows in the Product table. Nine of the total rows in the Product table do not have Categories data, so the CategoryKey of these rows has NULL values. 

Your manager asked you to list Product data by showing their category names including the rows which have NULL values in CategoryKey column. What should you do to accomplish this task?

Merge Product and Categories tables based on CategoryKey column by choosing Inner Join in the join kind dropdown.

Merge Product and Categories tables based on ResellerKey column.

Merge Product and Categories tables based on CategoryKey column by choosing Left Outer Join in the join kind dropdown.Correct Answer

Ready to test your recall?

Several columns in your worksheet contain missing or null values. Which of the following options must you type in the Value to Find field to locate these values?

Null

Missing

How confident are you in this answer?

Practice Quiz

Several columns in your worksheet contain missing or null values. Which of the following options must you type in the Value to Find field to locate these values?

What steps did you take to address inconsistencies in date columns in your worksheet? Select all that apply.

True or false: Once you completed all the data cleaning steps, you clicked Apply or Close &amp; Apply to apply all the transformations you made.&nbsp;

Which of the following operations are steps in the data transformation process? Select all that apply.

Which of the following data types are part of the number type group? Select all that apply.

Which one of the following features are used to track, re-order or delete the steps completed in Power Query?

Which of the following options can be used for Power Query Optimization? Select all that apply.

You have added a new source that displays NaN (Not a Number) values in Power Query. Which of the following issues could occur if these are not resolved? Select all that apply.

Which of the following statements describes the pivot operation in Power BI? Select all that apply.

Which table do you use as the first table in the AppendQueries window?

How many columns are there in the new query ConsolidatedSales, after you combined the AdventureWorksSales and OtherSales queries?

True or False:&nbsp; To append all respective columns between two queries successfully, you first need to make sure that there is an equal number of columns, the same column names and the same or convertible data types respectively.&nbsp;&nbsp;&nbsp;

How many rows are there in the new query Consolidated Sales, after you combined AdventureWorksSales and OtherSales queries?

Data transformation is the process of preparing data for analysis.

What is the primary purpose of Power Query in Power BI?

What is the purpose of the Applied Steps section in the Power Query Editor?

How does removing unnecessary columns from a dataset benefit the data analysis process?

Which of these issues in Power Query within Power BI is related to the presence of empty cells in your dataset?

Which one of the following describes the reason for Adio’s request to combine two different sales datasets together?

Which of the following is the operation of putting two or more tables or queries in one master table together?

Which feature allows you to add rows of different data sources together in Power Query?

Which of the following can be considered as a reason for combining data? Select all that apply.

True or False: You can combine the tables in two different ways: merging and appending.

You import two Microsoft Excel tables named ContactInfo and Address into Power Query.&nbsp;

How many columns are there in the final Consolidated Sales dataset, after you merged the (Sales) and (Product) queries, add (Product.Product) and remove (Reseller), (Employee) and (Sales Territory Key) columns?

Exactly how many rows are there in the Sales query, after you merged the Sales and Product queries?&nbsp;&nbsp;

Which of the following options can be considered as the purposes of join operation? Select all that apply.

Which type of JOIN operation includes only the matching records from both joined tables?

Which of the following pairs can be considered as a master table &#8211; pre defined table foreign key relationship?&nbsp;

Which feature allows you to combine related data between differently structured data sources in Power Query?

Which of the following can be considered as a purpose of merging data with joins? Select all that apply:

True or False. The full outer join is useful when you want to retrieve all the records from both tables, regardless of whether they have matching values in the join condition.

You import 4 Microsoft Excel tables named Sales, Product, Reseller and Employee into Power Query.&nbsp;

You import two Microsoft Excel tables named Product and Categories into Power Query. There are 319 rows in the Product table. Nine of the total rows in the Product table do not have Categories data, so the CategoryKey of these rows has NULL values.&nbsp;

Ready to test your recall?

True or false: Once you completed all the data cleaning steps, you clicked Apply or Close & Apply to apply all the transformations you made.

True or False: To append all respective columns between two queries successfully, you first need to make sure that there is an equal number of columns, the same column names and the same or convertible data types respectively.

You import two Microsoft Excel tables named ContactInfo and Address into Power Query.

Exactly how many rows are there in the Sales query, after you merged the Sales and Product queries?

Which of the following pairs can be considered as a master table – pre defined table foreign key relationship?

You import 4 Microsoft Excel tables named Sales, Product, Reseller and Employee into Power Query.

You import two Microsoft Excel tables named Product and Categories into Power Query. There are 319 rows in the Product table. Nine of the total rows in the Product table do not have Categories data, so the CategoryKey of these rows has NULL values.