Analytics Ch. 2

At which step of the ETL process should you try to answer the question "What business problem will the data address?" A) Step 1: Determine the purpose and scope of the data request. B) Step 2: Obtain the data. C) Step 3 or 4: Transformation. D) Step 5: Loading the data for data analysis.

A

At which step of the ETL process should you try to answer the question "What other information will impact the nature, timing and extent of the data analysis?" A) Step 1: Determine the purpose and scope of the data request. B) Step 2: Obtain the data. C) Step 3 or 4: Transformation. D) Step 5: Loading the data for data analysis.

A

Comparing descriptive statistics for numeric fields within the data is an example of which of the following? A) Validating the data for completeness B) Validating the data for integrity C) Cleaning the data D) Obtaining the data

A

The purpose of transforming data is: A) To validate the data for completeness and integrity B) To load the data into the appropriate tool for analysis C) To identify and obtain the data from the appropriate source D) To identify which approach to data analytics should be used

A

Which of the following best describes the purpose of a primary key? A) To ensure that each row in the table is unique B) To create the relationship between two tables C) To provide business information, but are not required to build a database D) To support business processes across the organization

A

Which of the following best exemplifies a way that data will need to be cleaned after extraction and validation? A) Remove headings and subtotals B) Validate date/time fields C) Remove trailing zeroes D) Compare string limits for text fields

A

Which of the following is most likely to be the primary key in an Employee table? A) Employee ID B) Employee Social Security Number C) Employee Name D) Employee Type

A

At which step of the ETL process should you try to answer the question "What tools will be used to perform data analytic tests or procedures and why?" A) Step 1: Determine the purpose and scope of the data request. B) Step 2: Obtain the data. C) Step 3 or 4: Transformation. D) Step 5: Loading the data for data analysis.

B

At which step of the ETL process should you try to answer the question "Where are the data located in the financial or other related systems?" A) Step 1: Determine the purpose and scope of the data request. B) Step 2: Obtain the data. C) Step 3 or 4: Transformation. D) Step 5: Loading the data for data analysis.

B

Mastering the data can also be described via the ETL process. The ETL process stands for: A) Extract, total, and load data. B) Extract, transform, and load data. C) Enter, transform, and load data. D) Enter, total, and load data.

B

The purpose of loading data is: A) To validate the data for completeness and integrity B) To load the data into the appropriate tool for analysis C) To identify and obtain the data from the appropriate source D) To identify which approach to data analytics should be used

B

Validating date/time fields within the data is an example of which of the following? A) Validating the data for completeness B) Validating the data for integrity C) Cleaning the data D) Obtaining the data

B

Which of the following best describes the purpose of a foreign key? A) To ensure that each row in the table is unique B) To create the relationship between two tables C) To provide business information D) To support business processes across the organization

B

Correcting inconsistencies across data is an example of which of the following? A) Validating the data for completeness B) Validating the data for integrity C) Cleaning the data D) Obtaining the data

C

Formatting negative numbers in the data is an example of which of the following? A) Validating the Data for Completeness B) Validating the Data for Integrity C) Cleaning the Data D) Obtaining the Data

C

Removing headings or subtotals from data is an example of which of the following? A) Validating the data for completeness B) Validating the data for integrity C) Cleaning the data D) Obtaining the data

C

Removing leading zeroes and non-printable characters from the data is an example of which of the following? A) Validating the data for completeness B) Validating the data for integrity C) Cleaning the data D) Obtaining the data

C

The purpose of extracting data is: A) To validate the data for completeness and integrity B) To load the data into the appropriate tool for analysis C) To identify and obtain the data from the appropriate source D) To identify which approach to data analytics should be used

C

When using [EmployeeID] as the unique identifier of the Employee table, [EmployeeID] is an example of which of the following: A) Foreign key B) Composite key C) Primary key D) Key attribute

C

All of the following are benefits of using a normalized relational database except: A) Completeness. B) No redundancy. C) Business rules are enforced. D) Data is stored in one place.

D

All of the following are included in the five steps of the ETL process except: A) Determine the purpose and scope of the data request B) Obtain the data C) Validate the data for completeness and integrity D) Scrub the data

D

There are a variety of methods that you could take to retrieve the data, including SQL. What does SQL stand for? A) Systems Query Language. B) Systems Question Language. C) Structured Question Language. D) Structured Query Language.

D

When obtaining the data yourself, you should do all of the following before you begin except: A) Identify the tables that contain the information you need. B) Identify which attributes specifically hold the information you need in each table. C) Identify how those tables are related to each other. D) Identify any errors or issues from the extraction

D

Which of the following best describes the purpose of relational databases? A) To ensure that business rules are enforced B) To increase information redundancy in the organization C) To provide business information to data analysts D) To support business processes across the organization

D

A foreign key is an attribute that exists in relational databases in order to carry out the relationship between two tables. TRUE FALSE

TRUE

In order to obtain the right data, it is important to have a firm grasp of what data is available and how it is stored. TRUE FALSE

TRUE