Question 1

Complete information asks if there is a value missing from the information.

Accepted Answer

A) True 
 B)False

Question 2

Ben works at a top accounting firm in Salt Lake City and his responsibilities include developing reports for each salesperson, product, and part as well as departmental-wide sales reports by salesperson, product, and part.Ben's duties provide value-added to his company and would be categorized as occurring at the different information ________.

Accepted Answer

A)  levels
B)  formats
C)  granularities
D)  formulasE) None of the above
F) B) and C)

Question 3

The primary purpose of a data warehouse is to ________.

Accepted Answer

A)  combine strategic information
B)  organize departments
C)  interface between the computer and employees
D)  All of these are correct.E) C) and D)
F) A) and B)

Question 4

Within the data warehouse model, the internal databases could include marketing, sales, inventory, and billing.

Accepted Answer

A) True 
 B)False

Question 5

Which of the following lists include all of the five characteristics common to high-quality information?

Accepted Answer

A)  accuracy, completeness, strength, support, and positive feedback
B)  accuracy, association, referral, sales, and marketing
C)  accuracy, competition, support, customer service, and visibility
D)  accuracy, completeness, consistency, timeliness, and uniquenessE) B) and C)
F) C) and D)

Question 6

What can help uncover correlations and trends in data that would otherwise go unrecognized?

Accepted Answer

A)  informing
B)  infographics
C)  data visualization tools
D)  business intelligence dashboardsE) B) and C)
F) A) and B)

Question 7

A relational database management system allows users to create, read, update, and delete data in a relational database.

Accepted Answer

A) True 
 B)False

Question 8

Data elements can include a customer's name, address, email, discount rate, preferred shipping method, product name, quantity ordered, and so on.

Accepted Answer

A) True 
 B)False

Question 9

What is extraction, transformation, and loading?

Accepted Answer

A)  It is a process of entering data, tracking data, and loading it into a database.
B)  It is a process that extracts information from internal and external databases, transforms it using a common set of enterprise definitions, and loads it into a data warehouse.
C)  It is a process that is performed at the end of the data warehouse model prior to putting the information in a cube.
D)  It is a process that is performed at the beginning of the data mining model.E) A) and D)
F) A) and C)

Question 10

What are information integrity issues?

Accepted Answer

A)  occurs when the same data element has different values
B)  occurs when a system produces incorrect, inconsistent, or duplicate data
C)  refers to the overall management of the availability, usability, integrity, and security of company data
D)  the practice of gathering data and ensuring that it is uniform, accurate, consistent, and complete, including such entities as customers, suppliers, products, sales, employees, and other critical entities that are commonly integrated across organizational systemsE) A) and C)
F) None of the above

Question 11

Web mining analysis describes technologies that allow users to "see" or visualize data to transform information into a business perspective.

Accepted Answer

A) True 
 B)False

Question 12

What is a field that uniquely identifies a given record in a table?

Accepted Answer

A)  foreign key
B)  primary key
C)  data mining key
D)  DBMS keyE) B) and D)
F) A) and B)

Question 13

A data-driven website is an interactive website kept constantly updated and relevant to the needs of its customers using a database.

Accepted Answer

A) True 
 B)False

Question 14

Regression is a prediction based on time-series information.

Accepted Answer

A) True 
 B)False

Question 15

Regression is a statement about what will happen or might happen in the future, for example, predicting future sales or employee turnover.

Accepted Answer

A) True 
 B)False

Question 16

Which of the following stores information about a person, place, thing, transaction, or event, and is usually referred to as a table?

Accepted Answer

A)  entity
B)  extraction
C)  attribute
D)  foreign keyE) None of the above
F) B) and C)

Question 17

If a manager identifies numerous information integrity issues, he or she should consider the reports generated from that data as invalid and not use them when making decisions.

Accepted Answer

A) True 
 B)False

Question 18

Which of the following forms of data mining assigns records to one of a predefined set of classes?

Accepted Answer

A)  clustering
B)  classification
C)  estimation
D)  affinity groupingE) None of the above
F) B) and C)

Question 19

A foreign key is a field (or group of fields) that uniquely identifies a given entity in a table.

Accepted Answer

A) True 
 B)False

Question 20

Distributed computing focuses on forecasting future trends and producing insights using sophisticated quantitative methods, including statistics, descriptive and predictive data mining, simulation, and optimization.

Accepted Answer

A) True 
 B)False

Exam 6: Data: Business Intelligence

A data-driven website is an interactive website kept constantly updated and relevant to the needs of its customers using a database.

Correct Answer
verified

A relational database management system allows users to create, read, update, and delete data in a relational database.

Correct Answer
verified

What is extraction, transformation, and loading?

Correct Answer
verified

Which of the following stores information about a person, place, thing, transaction, or event, and is usually referred to as a table?

Correct Answer
verified

Distributed computing focuses on forecasting future trends and producing insights using sophisticated quantitative methods, including statistics, descriptive and predictive data mining, simulation, and optimization.

Correct Answer
verified

A foreign key is a field (or group of fields) that uniquely identifies a given entity in a table.

Correct Answer
verified

Complete information asks if there is a value missing from the information.

Correct Answer
verified

Within the data warehouse model, the internal databases could include marketing, sales, inventory, and billing.

Correct Answer
verified

Regression is a prediction based on time-series information.

Correct Answer
verified

Which of the following forms of data mining assigns records to one of a predefined set of classes?

Correct Answer
verified

If a manager identifies numerous information integrity issues, he or she should consider the reports generated from that data as invalid and not use them when making decisions.

Correct Answer
verified

What can help uncover correlations and trends in data that would otherwise go unrecognized?

Correct Answer
verified

Data elements can include a customer's name, address, email, discount rate, preferred shipping method, product name, quantity ordered, and so on.

Correct Answer
verified

The primary purpose of a data warehouse is to ________.

Correct Answer
verified

Web mining analysis describes technologies that allow users to "see" or visualize data to transform information into a business perspective.

Correct Answer
verified

Regression is a statement about what will happen or might happen in the future, for example, predicting future sales or employee turnover.

Correct Answer
verified

What are information integrity issues?

Correct Answer
verified

Correct Answer
verified

Which of the following lists include all of the five characteristics common to high-quality information?

Correct Answer
verified

What is a field that uniquely identifies a given record in a table?

Correct Answer
verified

Exam 6: Data: Business Intelligence

A data-driven website is an interactive website kept constantly updated and relevant to the needs of its customers using a database.

Correct AnswerverifiedShow Answer

A relational database management system allows users to create, read, update, and delete data in a relational database.

Correct AnswerverifiedShow Answer

What is extraction, transformation, and loading?

Correct AnswerverifiedShow Answer

Which of the following stores information about a person, place, thing, transaction, or event, and is usually referred to as a table?

Correct AnswerverifiedShow Answer

Distributed computing focuses on forecasting future trends and producing insights using sophisticated quantitative methods, including statistics, descriptive and predictive data mining, simulation, and optimization.

Correct AnswerverifiedShow Answer

A foreign key is a field (or group of fields) that uniquely identifies a given entity in a table.

Correct AnswerverifiedShow Answer

Complete information asks if there is a value missing from the information.

Correct AnswerverifiedShow Answer

Within the data warehouse model, the internal databases could include marketing, sales, inventory, and billing.

Correct AnswerverifiedShow Answer

Regression is a prediction based on time-series information.

Correct AnswerverifiedShow Answer

Which of the following forms of data mining assigns records to one of a predefined set of classes?

Correct AnswerverifiedShow Answer

If a manager identifies numerous information integrity issues, he or she should consider the reports generated from that data as invalid and not use them when making decisions.

Correct AnswerverifiedShow Answer

What can help uncover correlations and trends in data that would otherwise go unrecognized?

Correct AnswerverifiedShow Answer

Data elements can include a customer's name, address, email, discount rate, preferred shipping method, product name, quantity ordered, and so on.

Correct AnswerverifiedShow Answer

The primary purpose of a data warehouse is to ________.

Correct AnswerverifiedShow Answer

Web mining analysis describes technologies that allow users to "see" or visualize data to transform information into a business perspective.

Correct AnswerverifiedShow Answer

Regression is a statement about what will happen or might happen in the future, for example, predicting future sales or employee turnover.

Correct AnswerverifiedShow Answer

What are information integrity issues?

Correct AnswerverifiedShow Answer

Correct AnswerverifiedShow Answer

Which of the following lists include all of the five characteristics common to high-quality information?

Correct AnswerverifiedShow Answer

What is a field that uniquely identifies a given record in a table?

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified