Question 1

What is the primary problem with redundant data?

Accepted Answer

A) It is difficult to determine which values are the most current. 
B) It is often inconsistent. 
C) It is difficult to determine which values are the most accurate. 
D) All of these. 
A) It is difficult to determine which values are the most current. 
B) It is often inconsistent. 
C) It is difficult to determine which values are the most accurate. 
D) All of these.

Question 2

What is the primary tool that retrieves information and helps users graphically design the answer to a question?

Accepted Answer

A) Data mining tools 
B) Structured example language 
C) Query-by-example tool 
D) Relational query tool 
A) Data mining tools 
B) Structured example language 
C) Query-by-example tool 
D) Relational query tool

Question 3

Which of the following would not be considered part of the accurate characteristic of high-quality information?

Accepted Answer

A) Is the name spelled correctly? 
B) Is the email address invalid? 
C) Do the name and the phone values have the exact same information? 
D) Is aggregate information in agreement with detailed information? 
A) Is the name spelled correctly? 
B) Is the email address invalid? 
C) Do the name and the phone values have the exact same information? 
D) Is aggregate information in agreement with detailed information?

Question 4

What type of website is an interactive website kept constantly updated and relevant to the needs of its customers using a database?

Accepted Answer

A) Data-driven website 
B) Interactive website 
C) Database performing website 
D) Data processing website 
A) Data-driven website 
B) Interactive website 
C) Database performing website 
D) Data processing website

Question 5

What determines the accuracy and completeness of organizational data?

Accepted Answer

A) Data quantity audit 
B) Data quality audit 
C) Data intelligence audit 
D) All of these 
A) Data quantity audit 
B) Data quality audit 
C) Data intelligence audit 
D) All of these

Question 6

What is immediate, up-to-date information?

Accepted Answer

A) Real-time information 
B) Real-time systems 
C) Information granularity 
D) All of these 
A) Real-time information 
B) Real-time systems 
C) Information granularity 
D) All of these

Question 7

What compiles all of the metadata about the data elements in the data model?

Accepted Answer

A) Data entity 
B) Data element 
C) Data attribute 
D) Data dictionary 
A) Data entity 
B) Data element 
C) Data attribute 
D) Data dictionary

Question 8

Which of the following is not a primary trait of information?

Accepted Answer

A) Transactional 
B) Analytical 
C) Timeliness 
D) Quantity 
A) Transactional 
B) Analytical 
C) Timeliness 
D) Quantity

Question 9

What is another term for data that are already contained in a database or a spreadsheet?

Accepted Answer

A) Structured data 
B) Unstructured data 
C) Text mining 
D) Web mining 
A) Structured data 
B) Unstructured data 
C) Text mining 
D) Web mining

Question 10

Which of the following is correct in reference to a database?

Accepted Answer

A) A database can support only one logical view. 
B) A database can support many physical views. 
C) A database can support many logical views. 
D) A database can support up to three logical views. 
A) A database can support only one logical view. 
B) A database can support many physical views. 
C) A database can support many logical views. 
D) A database can support up to three logical views.

Question 11

What are the two different categories for information type?

Accepted Answer

A) Analytical and productive 
B) Analytical and analysis 
C) Transactional and analytical 
D) Transactional and analysis 
A) Analytical and productive 
B) Analytical and analysis 
C) Transactional and analytical 
D) Transactional and analysis

Question 12

Which of the following is a disadvantage of database-stored information?

Accepted Answer

A) Increased flexibility 
B) Increased performance 
C) Increased data redundancy 
D) Increased data integrity 
A) Increased flexibility 
B) Increased performance 
C) Increased data redundancy 
D) Increased data integrity

Question 13

All of the following are business-critical integrity constraints, except

Accepted Answer

A) System will not allow an entry for an order for a nonexistent customer. 
B) System will not allow returns of fresh produce after 15 days past delivery. 
C) System will not allow shipping a product to a customer who does not have a valid address. 
D) Systems will not allow shipping of a nonexistent product to a customer. 
A) System will not allow an entry for an order for a nonexistent customer. 
B) System will not allow returns of fresh produce after 15 days past delivery. 
C) System will not allow shipping a product to a customer who does not have a valid address. 
D) Systems will not allow shipping of a nonexistent product to a customer.

Question 14

Which of the following is the common term for the representation of multidimensional information?

Accepted Answer

A) Block 
B) Square 
C) Column 
D) Cube 
A) Block 
B) Square 
C) Column 
D) Cube

Question 15

Describe a database, a database management system, and the relational database model.

Accepted Answer

A database maintains information about v

Question 16

What provides real-time information in response to query requests?

Accepted Answer

A) Real-time information 
B) Real-time systems 
C) Information level 
D) All of these 
A) Real-time information 
B) Real-time systems 
C) Information level 
D) All of these

Question 17

A data warehouse is a logical collection of information, gathered from many different operational databases, that supports business analysis activities and decision-making tasks.

Accepted Answer

A) True 
 B)False

Question 18

Which of the following does not describe Zappos' database?

Accepted Answer

A) Zappos' database was high scalable. 
B) Zappos' database was highly flexible. 
C) Zappos' database was highly secure. 
D) Zappos' database was highly redundant. 
A) Zappos' database was high scalable. 
B) Zappos' database was highly flexible. 
C) Zappos' database was highly secure. 
D) Zappos' database was highly redundant.

Question 19

Ben works at a top accounting firm in Salt Lake City, and his responsibilities include writing letters, memos, and emails along with generating reports for financial analysis and marketing materials for products.Ben's duties provide value-added to his company and would be categorized as occurring at the different _____________.

Accepted Answer

A) Information levels 
B) Information formats 
C) Information granularities 
D) Information focus 
A) Information levels 
B) Information formats 
C) Information granularities 
D) Information focus

Question 20

Databases today scale to exceptional levels, allowing all types of users and programs to perform _____________ processing and information searching tasks.

Accepted Answer

The answer of Databases today scale to exceptional levels, allowing...

What is the primary problem with redundant data?

What is the primary tool that retrieves information and helps users graphically design the answer to a question?

Which of the following would not be considered part of the accurate characteristic of high-quality information?

What type of website is an interactive website kept constantly updated and relevant to the needs of its customers using a database?

What determines the accuracy and completeness of organizational data?

What is immediate, up-to-date information?

What compiles all of the metadata about the data elements in the data model?

Which of the following is not a primary trait of information?

What is another term for data that are already contained in a database or a spreadsheet?

Which of the following is correct in reference to a database?

What are the two different categories for information type?

Which of the following is a disadvantage of database-stored information?

All of the following are business-critical integrity constraints, except

Which of the following is the common term for the representation of multidimensional information?

Describe a database, a database management system, and the relational database model.

What provides real-time information in response to query requests?

A data warehouse is a logical collection of information, gathered from many different operational databases, that supports business analysis activities and decision-making tasks.

Which of the following does not describe Zappos' database?

Databases today scale to exceptional levels, allowing all types of users and programs to perform _____________ processing and information searching tasks.

Management Information Systems: Business Driven MIS

Decision and Processes: Value Driven Business

Ebusiness: Electronic Business Value

Ethics and Information Security: MIS Business Concerns

Infrastructure: Sustainable Technologies

Networks: Mobile Business

Enterprise Applications: Business Communications

Systems Development and Project Management: Corporate Responsibility

Hardware and Software

Networks and Telecommunications

Designing Databases

Filters

Exam 6: Data: Business Intelligence

What is the primary problem with redundant data?

What is the primary tool that retrieves information and helps users graphically design the answer to a question?

Which of the following would not be considered part of the accurate characteristic of high-quality information?

What type of website is an interactive website kept constantly updated and relevant to the needs of its customers using a database?

What determines the accuracy and completeness of organizational data?

What is immediate, up-to-date information?

What compiles all of the metadata about the data elements in the data model?

Which of the following is not a primary trait of information?

What is another term for data that are already contained in a database or a spreadsheet?

Which of the following is correct in reference to a database?

What are the two different categories for information type?

Which of the following is a disadvantage of database-stored information?

All of the following are business-critical integrity constraints, except

Which of the following is the common term for the representation of multidimensional information?

Describe a database, a database management system, and the relational database model.

What provides real-time information in response to query requests?

A data warehouse is a logical collection of information, gathered from many different operational databases, that supports business analysis activities and decision-making tasks.

Which of the following does not describe Zappos' database?

Databases today scale to exceptional levels, allowing all types of users and programs to perform _____________ processing and information searching tasks.

Management Information Systems: Business Driven MIS

Decision and Processes: Value Driven Business

Ebusiness: Electronic Business Value

Ethics and Information Security: MIS Business Concerns

Infrastructure: Sustainable Technologies

Networks: Mobile Business

Enterprise Applications: Business Communications

Systems Development and Project Management: Corporate Responsibility

Hardware and Software

Networks and Telecommunications

Designing Databases

Filters