Getting Started with Power Query in Power BI

 

Question:

Power BI allows you to perform an Append Query operation on two queries. Please select the set or join operation that Append Query is most similar to.

• A set UNION between two tables

Question

:

You have a Power BI table with a column named OrderDate and would like to perform a filter with three clauses on this column. How can you achieve this?

• Click through OrderDate >> Filter >> Date Filter >> Custom Filter >> Advanced

[Profit] / [Sales]

Question

:

You have a Power BI table with two columns called Profit and Sales, and you would like to compute a Profit Margin column, which is Profit / Sales. Which Power Query formulas can you use for this?

• Value.Divide([Profit], [Sales])

• [Profit] / [Sales]

Question

:

Please identify the Microsoft products which you can load data into using Power Query.

• MS Excel

• MS Power BI

Question

:

You have a Power BI table with the columns Salary, Age, Name, ID. You would like to reorder these columns to ID, Name, Salary, and Age. Which Power Query function can you use?

• Table.ReorderColumns

Question

:

Please identify the true statements about table reference queries and duplicate queries in Power BI.

• Changes made to the original do not modify duplicate queries

• Changes made to the original do modify reference queries

Question

:

You would like to extract the first 2 characters from a column in your Power BI table. How can you achieve this?

• Click through Transform --> Extract --> First Characters

Question

= if [Country] = CountryFilter then [Sales] - [Profit] then null

This custom column displays the value of the Sales column minus that of the Profit column if the Country is equal to a CountryFilter. What is the term used for this kind of operation?

• Parameterized query

Question:

Which tool can you use to perform data processing and transformation in Power BI?

Answer C.

• Power Query

Question

:

You have a table where you have performed some Power BI transformations, the latest of which is Changed Type. You would like to add a transformation where you take in the table output by Changed Type and rename the Country column to Nation. What will the Power Query formula of this transformation look like?

• Table.RenameColumns(#"Changed Type", {{"Country", "Nation"}})

Question

:

You are performing a left outer join using a Power BI merge query. Which rows, from the first and second tables, will this join keep in the output?

• All the rows from the first table, only the matching rows from the second table

Question

:

This chart visualizes the query dependencies of your Power BI queries. Based on this, which query depends on the Returns query?

• Orders_AddlColumns

Categories: Power BI