DATA 2100 EXAM - QUESTIONS WITH
CORRECT ANSWERS
Anything that keeps a person from understanding the facts of a circumstance
with perfect objectivity is called... (Choose the best answer.) - ANSWER Bias
Within a dataset, all the information related to one instance of interest (e.g., a
specific customer within a dataset of customer data) is referred to as a... -
ANSWER Record
A dataset includes information about a retail company's 100 different retail
products. For each product, the dataset shows the product name, the number
sold in the last month, the average price at which each was sold, as well as the
average cost of acquisition. Product name, number sold, average price, and
average cost are, therefore, ... - ANSWER variables
Which of the following best corresponds with the idea of a "time-
appropriateness" data quality problem? - ANSWER In trying to predict who
would win this year's dog show, Eunice used a dataset from 1993 exclusively
Enabling different data points to relate to one another... - ANSWER Is one of
the core functions of a database.
Within a table, a includes values for a given observation (e.g., a customer) for
each of the fields included in that table. - ANSWER Record
A primary key is... - ANSWER Required for each record.
Databases... (Select the most applicable answer.) - ANSWER Rely on primary
and foreign keys to relate records from different tables.
Which of the following does every table in a database need to have? -
ANSWER Primary key
When there is a relationship between records in two different tables... -
ANSWER The mandatory side donates its key to the many side.
, A data dictionary... - ANSWER Describes every field in each table
What does the FROM clause do within a SQL SELECT query? - ANSWER
Tells the database what table(s) to pull data from.
Which of the following best corresponds with the components that compromise
a data ecosystem? - ANSWER Data storage, hardware, processes, and
reporting tools
Which of the following is most likely to have to handle hundreds of queries
simultaneously, some reading data and others writing data? - ANSWER
operational database
One reason the data must be transformed before being loaded from the
operational database to the data warehouse is that... - ANSWER The data in
the operational database may use different fields than the data in the data
warehouse
Often, when data from the data warehouse is loaded into a specific data mart -
ANSWER Data are denormalized into fewer tables.
Which of the following is true regarding data marts? - ANSWER They usually
contain data specific to one function or group within the organization.
A professor who doesn't fully trust Canvas keeps students' actual grades in a
spreadsheet saved on his desktop computer. From the university's perspective,
this spreadsheet is an example of... - ANSWER Loose data
One big reason that ERP systems are widely used in large organizations is... -
ANSWER To make it easier for top executives to know what's going on in the
company.
Because ERP systems are modular - ANSWER Companies can add a new
process to their already-established ERP system *relatively* easily.
I just bought a brand new video game console as well as 30 new games that go
with it and that are exclusive to my console. As a result, I'm pretty hesitant to
CORRECT ANSWERS
Anything that keeps a person from understanding the facts of a circumstance
with perfect objectivity is called... (Choose the best answer.) - ANSWER Bias
Within a dataset, all the information related to one instance of interest (e.g., a
specific customer within a dataset of customer data) is referred to as a... -
ANSWER Record
A dataset includes information about a retail company's 100 different retail
products. For each product, the dataset shows the product name, the number
sold in the last month, the average price at which each was sold, as well as the
average cost of acquisition. Product name, number sold, average price, and
average cost are, therefore, ... - ANSWER variables
Which of the following best corresponds with the idea of a "time-
appropriateness" data quality problem? - ANSWER In trying to predict who
would win this year's dog show, Eunice used a dataset from 1993 exclusively
Enabling different data points to relate to one another... - ANSWER Is one of
the core functions of a database.
Within a table, a includes values for a given observation (e.g., a customer) for
each of the fields included in that table. - ANSWER Record
A primary key is... - ANSWER Required for each record.
Databases... (Select the most applicable answer.) - ANSWER Rely on primary
and foreign keys to relate records from different tables.
Which of the following does every table in a database need to have? -
ANSWER Primary key
When there is a relationship between records in two different tables... -
ANSWER The mandatory side donates its key to the many side.
, A data dictionary... - ANSWER Describes every field in each table
What does the FROM clause do within a SQL SELECT query? - ANSWER
Tells the database what table(s) to pull data from.
Which of the following best corresponds with the components that compromise
a data ecosystem? - ANSWER Data storage, hardware, processes, and
reporting tools
Which of the following is most likely to have to handle hundreds of queries
simultaneously, some reading data and others writing data? - ANSWER
operational database
One reason the data must be transformed before being loaded from the
operational database to the data warehouse is that... - ANSWER The data in
the operational database may use different fields than the data in the data
warehouse
Often, when data from the data warehouse is loaded into a specific data mart -
ANSWER Data are denormalized into fewer tables.
Which of the following is true regarding data marts? - ANSWER They usually
contain data specific to one function or group within the organization.
A professor who doesn't fully trust Canvas keeps students' actual grades in a
spreadsheet saved on his desktop computer. From the university's perspective,
this spreadsheet is an example of... - ANSWER Loose data
One big reason that ERP systems are widely used in large organizations is... -
ANSWER To make it easier for top executives to know what's going on in the
company.
Because ERP systems are modular - ANSWER Companies can add a new
process to their already-established ERP system *relatively* easily.
I just bought a brand new video game console as well as 30 new games that go
with it and that are exclusive to my console. As a result, I'm pretty hesitant to
