Pre-Training Assessment Power Query & Power Pivots(Genpact)
Authored by Ivy Professional School
Professional Development
Professional Development
Used 8+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
18 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 5 pts
What language does Power Query use?
DAX
M-Code
Python
JAVA
2.
MULTIPLE CHOICE QUESTION
30 sec • 5 pts
To combine two queries one on top of the other, _____ queries is used.
Merging
Combining
Joining
Appending
3.
MULTIPLE CHOICE QUESTION
30 sec • 5 pts
Horizontal combining of queries in Power Query is known as___
Appending
Combining
Merging
Union
4.
MULTIPLE CHOICE QUESTION
30 sec • 5 pts
What kind of relationship is appropriate while creating models in Power Query?
One to one
One to Many
Many to many
All
5.
MULTIPLE CHOICE QUESTION
30 sec • 5 pts
Number fields on which aggregation is not required should be kept as numeric datatype.
True
False
6.
MULTIPLE CHOICE QUESTION
30 sec • 5 pts
It is possible to connect more than one table in Power Query.
True
False
7.
MULTIPLE CHOICE QUESTION
30 sec • 5 pts
Splitting of column can be done on the basis of ____
Space
Hyphen
Commas
All Delimiters
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Microsoft
or continue with
%20(1).png)
Apple
Others
Already have an account?
