
Connecting and Shapping Data
Authored by Jessica Jessica
Information Technology (IT)
Professional Development
Used 1+ times

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
15 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
45 sec • 2 pts
Which of the following operations is used to add new rows to an existing table?
Merge
Left Join
Outer Join
Append
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which term best describes the process of transforming a table from a horizontal orientation to a vertical orientation by turning distinct column values into rows?
Unpivoting
Hinging
Transposing
Pivoting
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which query editing tool would you use to aggregate or roll up your data at a higher level? (i.e. Daily to Monthly)
Pivot
Group By
Merge
Append
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which type of column would you add to create a series of values to uniquely identify each row in a table?
Index
Count
Conditional
Sequential
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following date tools is only available in the "Transform" tab of the Query Editor?
Latest
Month
Age
Day
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following information is preserved when you import an entire data model from Excel to Power BI Desktop?
Query editing procedures
DAX measures
Table relationships
All of this information is preserved
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which three tabs in the Query Editor contain data shaping and transformation tools?
Transform, Design, Analyze
Load, Transform, Analyze
Home, Transform, Add Column
Transform, Load, Add Column
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 Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
Already have an account?