Question 1

The data warehouse is a location for all of business information.

Accepted Answer

A) True 
 B)False

Question 2

Gender can be referred to in many ways (Male, Female, M/F, 1/0) in a data warehouse.What is this an example of?

Accepted Answer

A) Information scaling 
B) Streamlining data points 
C) Standardizing information 
D) Standardizing protocols 
A) Information scaling 
B) Streamlining data points 
C) Standardizing information 
D) Standardizing protocols

Question 3

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

Accepted Answer

A) Are there any duplicate orders? 
B) Are there any duplicate customers? 
C) Is aggregate information in agreement with detailed information? 
D) Is each transaction and event represented only once in the information? 
A) Are there any duplicate orders? 
B) Are there any duplicate customers? 
C) Is aggregate information in agreement with detailed information? 
D) Is each transaction and event represented only once in the information?

Question 4

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 key 
A) Entity 
B) Extraction 
C) Attribute 
D) Foreign key

Question 5

Relational integrity constraints are rules that enforce basic and fundamental information-based constraints.

Accepted Answer

A) True 
 B)False

Question 6

The primary purpose of a data ___________ is to combine information, specifically, strategic information, throughout an organization into a single repository in such a way that the people who need that information can make decisions and undertake business analysis.

Accepted Answer

The answer of The primary purpose of a data ___________...

Question 7

What is the primary difference between an entity and an attribute?

Accepted Answer

A) An attribute is a table; an entity is a column from the attribute table. 
B) An entity is specific; as an attribute is not data at all but brainstorming ideas that take place before the entity is created. 
C) An attribute refers to applications; an entity refers to executives. 
D) An entity is a table that stores information about people, places, or events; an attribute is a column or specific field of the data elements associated with an entity. 
A) An attribute is a table; an entity is a column from the attribute table. 
B) An entity is specific; as an attribute is not data at all but brainstorming ideas that take place before the entity is created. 
C) An attribute refers to applications; an entity refers to executives. 
D) An entity is a table that stores information about people, places, or events; an attribute is a column or specific field of the data elements associated with an entity.

Question 8

What is one of the biggest pitfalls associated with real-time information?

Accepted Answer

A) It is only available to high-level executives due to the expense. 
B) It is only available in aggregate levels of granularity. 
C) It continually changes. 
D) It rarely changes. 
A) It is only available to high-level executives due to the expense. 
B) It is only available in aggregate levels of granularity. 
C) It continually changes. 
D) It rarely changes.

Question 9

Which of the following represents the different information formats?

Accepted Answer

A) Detail, summary, aggregate 
B) Document, presentation, spreadsheet, database 
C) Individual, department, enterprise 
D) None of these 
A) Detail, summary, aggregate 
B) Document, presentation, spreadsheet, database 
C) Individual, department, enterprise 
D) None of these

Question 10

What are the primary differences between a data warehouse and a data mart?

Accepted Answer

A) Data warehouses make quick decisions; data marts make slow decisions. 
B) Data warehouse tackle ethical issues; data marts tackle hypothetical issues. 
C) Data warehouses have a more organizationwide focus; data marts have functional focus. 
D) Data warehouses have a physical focus; data marts have logical focus. 
A) Data warehouses make quick decisions; data marts make slow decisions. 
B) Data warehouse tackle ethical issues; data marts tackle hypothetical issues. 
C) Data warehouses have a more organizationwide focus; data marts have functional focus. 
D) Data warehouses have a physical focus; data marts have logical focus.

Question 11

Organizations using business intelligence can find the cause to many issues and problems simply by asking the question ____________.

Accepted Answer

The answer of Organizations using business intelligence can find the...

Question 12

Which of the following asks users to write lines of code to answer questions against a database?

Accepted Answer

A) Structured query language 
B) Relational query language 
C) Structured elements 
D) Data mining tools 
A) Structured query language 
B) Relational query language 
C) Structured elements 
D) Data mining tools

Question 13

Today's chief information officers are finding that business intelligence software is unnecessary and a financial burden for most companies.

Accepted Answer

A) True 
 B)False

Question 14

Which of the following implies that aggregate or summary information is in agreement with detailed information?

Accepted Answer

A) Uniqueness 
B) Completeness 
C) Consistency 
D) Accuracy 
A) Uniqueness 
B) Completeness 
C) Consistency 
D) Accuracy

Question 15

Which of the following is not an example of an advantage of using a relational database?

Accepted Answer

A) Increased information quality 
B) Increased flexibility 
C) Decreased information redundancy 
D) Decreased information security 
A) Increased information quality 
B) Increased flexibility 
C) Decreased information redundancy 
D) Decreased information security

Question 16

Why do relational databases use primary keys and foreign keys?

Accepted Answer

A) To create an entity 
B) To create physical relationships 
C) To create logical relationships 
D) To create an attribute 
A) To create an entity 
B) To create physical relationships 
C) To create logical relationships 
D) To create an attribute

Question 17

Relational _____________ constraints are rules that enforce basic and fundamental information-based constraints.

Accepted Answer

The answer of Relational _____________ constraints are rules that enforce...

Question 18

What is a real-time system?

Accepted Answer

A) It provides immediate, up-to-date information. 
B) It provides real-time information in response to query requests. 
C) It encompasses all organization information, and its primary purpose is to support the performing of managerial analysis tasks. 
D) It encompasses all of the information contained within a single business process or unit of work, and its primary purpose is to support the performing of daily operational tasks. 
A) It provides immediate, up-to-date information. 
B) It provides real-time information in response to query requests. 
C) It encompasses all organization information, and its primary purpose is to support the performing of managerial analysis tasks. 
D) It encompasses all of the information contained within a single business process or unit of work, and its primary purpose is to support the performing of daily operational tasks.

Question 19

A database maintains information on ___________.

Accepted Answer

A) Inventory 
B) Transactions 
C) Employees 
D) All of these 
A) Inventory 
B) Transactions 
C) Employees 
D) All of these

Question 20

Data-mining tools use a variety of techniques to find patterns and relationships in large volumes of information that predict future behavior and guide decision making.

Accepted Answer

A) True 
 B)False

The data warehouse is a location for all of business information.

Gender can be referred to in many ways (Male, Female, M/F, 1/0) in a data warehouse.What is this an example of?

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

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

Relational integrity constraints are rules that enforce basic and fundamental information-based constraints.

The primary purpose of a data ___________ is to combine information, specifically, strategic information, throughout an organization into a single repository in such a way that the people who need that information can make decisions and undertake business analysis.

What is the primary difference between an entity and an attribute?

What is one of the biggest pitfalls associated with real-time information?

Which of the following represents the different information formats?

What are the primary differences between a data warehouse and a data mart?

Organizations using business intelligence can find the cause to many issues and problems simply by asking the question ____________.

Which of the following asks users to write lines of code to answer questions against a database?

Today's chief information officers are finding that business intelligence software is unnecessary and a financial burden for most companies.

Which of the following implies that aggregate or summary information is in agreement with detailed information?

Which of the following is not an example of an advantage of using a relational database?

Why do relational databases use primary keys and foreign keys?

Relational _____________ constraints are rules that enforce basic and fundamental information-based constraints.

What is a real-time system?

A database maintains information on ___________.

Data-mining tools use a variety of techniques to find patterns and relationships in large volumes of information that predict future behavior and guide decision making.

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

The data warehouse is a location for all of business information.

Gender can be referred to in many ways (Male, Female, M/F, 1/0) in a data warehouse.What is this an example of?

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

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

Relational integrity constraints are rules that enforce basic and fundamental information-based constraints.

The primary purpose of a data ___________ is to combine information, specifically, strategic information, throughout an organization into a single repository in such a way that the people who need that information can make decisions and undertake business analysis.

What is the primary difference between an entity and an attribute?

What is one of the biggest pitfalls associated with real-time information?

Which of the following represents the different information formats?

What are the primary differences between a data warehouse and a data mart?

Organizations using business intelligence can find the cause to many issues and problems simply by asking the question ____________.

Which of the following asks users to write lines of code to answer questions against a database?

Today's chief information officers are finding that business intelligence software is unnecessary and a financial burden for most companies.

Which of the following implies that aggregate or summary information is in agreement with detailed information?

Which of the following is not an example of an advantage of using a relational database?

Why do relational databases use primary keys and foreign keys?

Relational _____________ constraints are rules that enforce basic and fundamental information-based constraints.

What is a real-time system?

A database maintains information on ___________.

Data-mining tools use a variety of techniques to find patterns and relationships in large volumes of information that predict future behavior and guide decision making.

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