Connecting and Shapping Data

Which of the following operations is used to add new rows to an existing table?

• Merge

• Left Join

• Outer Join

• Append

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

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

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

Which of the following date tools is only available in the "Transform" tab of the Query Editor?

• Latest

• Month

• Age

• Day

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

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

When you apply a tool from the "Transform" menu of the Power Query editor, which of the following is true?

• Original column values are replaced

• Original values are preserved, and a new column is created with transformed values

• Power BI will give you the option to preserve or replace original values

• Original column values are preserved

In Power BI, the tool used to connect to and transform data before loading it into the model is called the

(a)  

To combine two tables with the same columns into one, you use the (a)   operation in Power Query.