Pre-Training Assessment Power Query & Power Pivots(Genpact)

What language does Power Query use?

• DAX

• M-Code

• Python

• JAVA

To combine two queries one on top of the other, _____ queries is used.

• Merging

• Combining

• Joining

• Appending

Horizontal combining of queries in Power Query is known as___

• Appending

• Combining

• Merging

• Union

What kind of relationship is appropriate while creating models in Power Query?

• One to one

• One to Many

• Many to many

• All

Number fields on which aggregation is not required should be kept as numeric datatype.

• True

• False

It is possible to connect more than one table in Power Query.

• True

• False

Splitting of column can be done on the basis of ____

• Space

• Hyphen

• Commas

• All Delimiters

The steps used in transformation of a query are known as:

• Applied Steps

• Macros

• Additional Steps

• Record of Steps

Which function is used to create a calculated column or field in Power Query?

• DAX

• Conditional Functions

• Database Functions

• None of the options

Power Query is an ETL Tool.

• False

• True