DATA 2100 || ERROR-FREE ANSWERS 100%.
Anything that keeps a person from understanding the facts of a circumstance with perfect
objectivity is called... (Choose the best answer.) correct answers 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... correct answers 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, ... correct answers variables
Which of the following best corresponds with the idea of a "time-appropriateness" data quality
problem? correct answers 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... correct answers 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. correct answers Record
A primary key is... correct answers Required for each record.
Databases... (Select the most applicable answer.) correct answers 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? correct answers Primary key
, When there is a relationship between records in two different tables... correct answers The
mandatory side donates its key to the many side.
A data dictionary... correct answers Describes every field in each table
What does the FROM clause do within a SQL SELECT query? correct answers Tells the
database what table(s) to pull data from.
Which of the following best corresponds with the components that compromise a data
ecosystem? correct answers 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? correct answers operational database
One reason the data must be transformed before being loaded from the operational database to
the data warehouse is that... correct answers 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 correct answers
Data are denormalized into fewer tables.
Which of the following is true regarding data marts? correct answers 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...
correct answers Loose data
One big reason that ERP systems are widely used in large organizations is... correct answers To
make it easier for top executives to know what's going on in the company.
Anything that keeps a person from understanding the facts of a circumstance with perfect
objectivity is called... (Choose the best answer.) correct answers 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... correct answers 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, ... correct answers variables
Which of the following best corresponds with the idea of a "time-appropriateness" data quality
problem? correct answers 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... correct answers 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. correct answers Record
A primary key is... correct answers Required for each record.
Databases... (Select the most applicable answer.) correct answers 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? correct answers Primary key
, When there is a relationship between records in two different tables... correct answers The
mandatory side donates its key to the many side.
A data dictionary... correct answers Describes every field in each table
What does the FROM clause do within a SQL SELECT query? correct answers Tells the
database what table(s) to pull data from.
Which of the following best corresponds with the components that compromise a data
ecosystem? correct answers 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? correct answers operational database
One reason the data must be transformed before being loaded from the operational database to
the data warehouse is that... correct answers 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 correct answers
Data are denormalized into fewer tables.
Which of the following is true regarding data marts? correct answers 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...
correct answers Loose data
One big reason that ERP systems are widely used in large organizations is... correct answers To
make it easier for top executives to know what's going on in the company.
