Question 1

Chapter 2 describes,the various ways in which data can be stored for differing purposes.Describe the two ways data can be organized and the purpose for each organizational structure.

Accepted Answer

The answer of Chapter 2 describes,the various ways in which...

Question 2

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

Accepted Answer

The Employee ID is a unique identifier assigned to each employee and would therefore be the best choice for a primary key in an Employee table. The other options, such as Social Security Number, Name, and Type, may not be unique to each employee and could lead to data duplication or errors in the table.

Question 3

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.

Accepted Answer

SQL stands for Structured Query Language and is a standard language for managing relational databases. It allows you to retrieve, manipulate, and store data in relational databases.

Question 4

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.

Accepted Answer

Normalization primarily aims to reduce redundancy and ensure data integrity by organizing data into tables according to rules designed to safeguard the data. However, it does not inherently ensure that data is stored in one place. In fact, normalization often involves distributing data across multiple tables to eliminate redundancy, which can sometimes lead to data being stored in multiple places, albeit in a structured and controlled manner.

Question 5

Define and compare a primary key,a foreign key,and non-key attribute.

Accepted Answer

The answer of Define and compare a primary key,a foreign...

Question 6

A data dictionary is paramount in helping database administrators do which of the following?
A) Maintain databases.
B) Identify the data they need to use.
C) Communicating insights.
D) Track outcomes.

Accepted Answer

A data dictionary provides a detailed description of the data elements within a database, including their names, data types, and relationships with other data elements. This information is critical for database administrators to effectively maintain databases, ensuring data accuracy, consistency, and integrity.

Question 7

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.

Accepted Answer

The answer of At which step of the ETL process...

Question 8

Taylor is a new staff accountant for a fortune 100 company.After hearing that she just successfully completed an Accounting Data Analytics course,her boss said,"Get me a listing of all our deadbeat customer,so I can cut off their credit." After asking clarifying questions,Taylor was able to determine that root request was "Which customer,with a credit limit over $10,000,have more than $5,000 outstanding for more than 90 days at the prior quarter's end?" Use the ETL Techniques briefly describe the process Taylor with have to complete to answer her boss' question.(Assume that Taylor does not have direct access the data,data will export into an Excel file,and she will complete the analysis with an Excel Pivot Table.)

Accepted Answer

The answer of Taylor is a new staff accountant for...

Question 9

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.

Accepted Answer

At the very beginning of the ETL process, it's important to determine the purpose and scope of the data request. This includes asking questions such as "What business problem will the data address?" in order to ensure that the data being collected and analyzed is relevant and valuable to the organization.

Question 10

Assume that you have just completed the extraction process on a data set.As you begin validating the data for completeness and integrity,you notice an error.Describe the steps you might take to determine the source of an error.

Accepted Answer

The answer of Assume that you have just completed the...

Question 11

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.

Accepted Answer

The question "What other information will impact the nature, timing, and extent of the data analysis?" should be addressed in Step 1: Determine the purpose and scope of the data request. This is because understanding the purpose and scope of the data request sets the context for the data analysis and helps identify the relevant data sources, business rules, and data transformations needed. By answering this question in Step 1, it can also help prevent potential issues and mistakes in later steps of the ETL process.

Question 12

A data dictionary is paramount in helping data analysts do which of the following?
A) Maintain databases.
B) Identify the data they need to use.
C) Communicating insights.
D) Track outcomes.

Accepted Answer

A data dictionary provides a standard definition of data elements, which helps data analysts in identifying the data they need to use. This ensures that they are working with accurate and consistent data, and it saves time by reducing the need for them to search for information in multiple locations. While a data dictionary may help in maintaining databases, communicating insights, and tracking outcomes to some extent, its primary purpose is to provide clarity on the data elements being used.

Question 13

Assume that you will be up for a promotion next month and you'd like to analyze a recently acquired database to show off your data analytic skills.After identifying the goal of your data analysis,using the first step of the IMPACT cycle,what steps would you take if you have direct access to the database?

Accepted Answer

The answer of Assume that you will be up for...

Question 14

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.

Accepted Answer

Step 2: Obtain the data is the correct answer because this step involves identifying and accessing the data sources, which would include determining the location of the data in the financial or other related systems.

Question 15

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.

Accepted Answer

The question states "except", meaning that all options except one should be done before beginning data extraction. Therefore, the correct answer is D, as identifying errors or issues would typically be done during or after the data extraction process.

Quiz 2: Data Preparation and Cleaning

Chapter 2 describes,the various ways in which data can be stored for differing purposes.Describe the two ways data can be organized and the purpose for each organizational structure.

Which of the following is most likely to be the primary key in an Employee table?

There are a variety of methods that you could take to retrieve the data,including SQL.What does SQL stand for?

All of the following are benefits of using a normalized relational database except:

Define and compare a primary key,a foreign key,and non-key attribute.

A data dictionary is paramount in helping database administrators do which of the following?

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?"

At which step of the ETL process should you try to answer the question "What business problem will the data address?"

Assume that you have just completed the extraction process on a data set.As you begin validating the data for completeness and integrity,you notice an error.Describe the steps you might take to determine the source of an error.

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 data dictionary is paramount in helping data analysts do which of the following?

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?"

When obtaining the data yourself,you should do all of the following before you begin except: