Data Analysis Class Quiz 1

Which data role enables advanced analytics capabilities through reports and visualizations?

• Data Analyst

• 
  B. Data Engineer

• Data Miner

• Data scientist

You import two Microsoft Excel tables named Customer and Address into Power Query. Customer contains the following columns:
 ✑ Customer ID
✑ Customer Name
 ✑ Phone
 ✑ Email Address
 ✑ Address ID

Address contains the following columns:
✑ Address ID
✑ Address Line 1
✑ Address Line 2
✑ City
✑ State/Region
✑ Country
 ✑ Postal Code
The Customer ID and Address ID columns represent unique rows. You need to create a query that has one row per customer. Each row must contain City, State/Region, and Country for each customer. What should you do?

• Merge the Customer and Address tables.

• Transpose the Customer and Address tables.

• Group the Customer and Address tables by the Address ID column.

• Append the Customer and Address tables.
  

You open a query in Power Query Editor. You need to identify the percentage of empty values in each column as quickly as possible. Which Data Preview option should you select?

• Show whitespace

• Column profile

• Column distribution
  

• Column Quality

When working with data in Power Query, what does it mean to 'unpivot' a table?

• To transform columns into rows

• To combine multiple tables into one

• To filter out empty values

• To sort the data in ascending order

In Power Query Editor, what is the purpose of the 'Column profile' Data Preview option?

• To display statistical summaries of each column

• To show whitespace characters in the data

• To visualize the distribution of values in a column

• To identify and remove duplicate values

When importing data into Power Query, what does it mean to 'append' tables?

• To merge tables based on a common column

• To combine tables vertically

• To filter out rows with empty values

• To sort the data in descending order

What is the purpose of the 'Data Analyst' data role in Power Query?

• To perform advanced analytics through reports and visualizations

• To optimize data storage and retrieval

• To clean and transform data efficiently

• To manage data security and access permissions

What does it mean to 'transform columns into rows' when working with data in Power Query?

• To pivot the table based on a common column

• To combine multiple tables into one

• To filter out empty values

• To sort the data in ascending order

What is a key benefit of data analysis?

• Decisive analytics

• Informed business decisions

• Complex reports

• Visualize Data

You have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date and time each complaint occurred. The data Logged is in the following format: 2018-12-31 at 08:59. You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy. What should you do?

• Apply a transformation to extract the last 11 characters of the Logged column and
  set the data type of the new column to Date.

• Create a column by example that starts with 2018-12-31 and set the data type of the
  new column to Date.

• Change the data type of the Logged column to Date.

• Add a conditional column that outputs 2018 if the Logged column starts with 2018 and set the data type of the new column to whole number