Learn Power BI

Blog
Practice Questions

Learn Power BI

Accelerate your Career and Get Certified

Prepare the Data

Friday, June 25th, 2021

Welcome to your Prepare the Data for Analysis

True or False: when a table is created from a flat file in Power BI Desktop, the Power Query Editor assumes that the first row of data is the column headers

True

False

Which will make a data table longer (more rows)

Pivot

Unpivot

Two ways to change the data type in Power BI:

Select the column and use the metadata option in the Transform tab and select the correct data type

Select the data type icon next to the column header and then select the correct data type

Select the column and use the data type dropdown in the Transform tab and select the correct data type

Click the arrow next to the column header, select edit metadata, and select the correct data type

Which is more likely to have data type errors

databases

flat files

If a column has values that are misspelled, this option in the Transform tab can help

Recode

Replace Values

Find-Replace

Spell check

When you append queries, you will be

adding rows from one table (or query) into another.

adding columns from one table (or query) into another.

When you merge queries, you will be

adding rows from one table (or query) into another.

adding columns from one table (or query) into another.

Which is similar to a SQL JOIN?

merge

append

This transformation applies aggregation

Pivot

Unpivot

Remove top rows

If you think you might use a column at some point in the future, you should be sure to keep it in the data model so that it is there when you need it.

True

False

When doing a merge, which option will guarantee that all rows are included in the result?

Inner

Left Outer

Full Outer

Union

Shows % of data that is valid, in error, and empty

Column Distribution

Column Statistics

Column Quality

A column contains the following rows:

If we replace nulls with 0, how will the average of Shipping_Cost change?

average(Shipping_Cost) will decrease

average(Shipping_Cost) will increase

average(Shipping_Cost) will remain the same

To edit M code directly

Select the Transform ribbon of Power Query and then M Editor.

Select the View ribbon of Power Query and then select M Editor.

Select the Transform ribbon of Power Query and then select Advanced Editor.

Select the View ribbon of Power Query and then select Advanced Editor.

Power Query creates which type of code?

T-SQL code

M code

SQL code

DAX

Gives an in-depth look at a column's first 1000 values

Column profile

Column Quality

Value distribution

Column distribution

When renaming columns, a best practice is to replace underscores ("_") with

dashes ("-")

dots (".")

capitalizing the first letter of the words, so for example "birth_date" becomes "Birth Date"

spaces (" ")

Time is Up!

Time's up

Leave a Reply Cancel reply

Your email address will not be published.

Comment

Name

Email

Website

Δ

About the Author: Lukas Halim

I earned a Masters in Analytics from NC State in 2013 and now work as a data analyst in the health insurance industry. Using tools such as SAS, Tableau, and Teradata, I conduct analysis to help my company improve healthcare affordability and customer engagement.

Learn More

4.6 Instructor Rating
53,604 Students

14,612 Reviews
2 courses

© Power Bi Skills. All rights reserved.
Privacy Policy | Design by Liscio Apps, LLC