Question 1

What is a dimension?

Accepted Answer

A)  A particular attribute of information. 
B)  A particular entity of information. 
C)  A particular relational database. 
D)  A particular single repository. 
A)  A particular attribute of information. 
B)  A particular entity of information. 
C)  A particular relational database. 
D)  A particular single repository. A

Question 2

What is information that people use to support their decision-making efforts?

Accepted Answer

A)  Information cleansing and scrubbing 
B)  Data-mining tools 
C)  Data mining 
D)  Business intelligence 
A)  Information cleansing and scrubbing 
B)  Data-mining tools 
C)  Data mining 
D)  Business intelligence D

Question 3

The primary purpose of a data warehouse is to perform transactional processes.

Accepted Answer

A) True 
 B)False  False

Question 4

Explain the primary difference between a database and a data warehouse.

Accepted Answer

The primary difference between a databas

Question 5

Which of the following is not one of the principal BI enablers?

Accepted Answer

A)  Technology 
B)  Corporate processes 
C)  People 
D)  Corporate culture 
A)  Technology 
B)  Corporate processes 
C)  People 
D)  Corporate culture

Question 6

What do data warehouses support?

Accepted Answer

A)  OLAP 
B)  Analytical processing 
C)  OLTP 
D)  OLAP and analytical processing 
A)  OLAP 
B)  Analytical processing 
C)  OLTP 
D)  OLAP and analytical processing

Question 7

Data information in a data warehouse contains layers of columns and rows,and this is known as __________ databases.

Accepted Answer

The answer of Data information in a data warehouse contains...

Question 8

Lands' End created an organization-wide data warehouse so all its employees could access organizational information.Lands' End soon found out that there could be "too much of a good thing." Many of its employees would not use the data warehouse,because it was simply too big,too complicated,and had too much irrelevant information.Lands' End knew there was valuable information in its data warehouse,and it had to find a way for its employees to easily access the information.What was Lands' End's solution?

Accepted Answer

A)  Build a better, more efficient data warehouse. 
B)  Build a better, more efficient transactional database. 
C)  Build a data mart. 
D)  Build a data-driven website. 
A)  Build a better, more efficient data warehouse. 
B)  Build a better, more efficient transactional database. 
C)  Build a data mart. 
D)  Build a data-driven website.

Question 9

The Data Warehousing Institute estimates that low-quality information costs U.S.businesses $60 billion annually.

Accepted Answer

A) True 
 B)False

Question 10

A(n)__________ is a particular attribute of information.

Accepted Answer

The answer of A(n)__________ is a particular attribute of information....

Question 11

Which of the following does not draw a parallel between the challenges in business and the challenges of war?

Accepted Answer

A)  Collecting information. 
B)  Discerning patterns and meaning in the information. 
C)  Accurate and complete information. 
D)  Responding to the resultant information. 
A)  Collecting information. 
B)  Discerning patterns and meaning in the information. 
C)  Accurate and complete information. 
D)  Responding to the resultant information.

Question 12

Data _________ is the process of analyzing data to extract information not offered by the raw data alone.

Accepted Answer

The answer of Data _________ is the process of analyzing...

Question 13

A(n)___________ is the common term for the representation of multidimensional information.

Accepted Answer

The answer of A(n)___________ is the common term for the...

Question 14

Why would a business use a data warehouse that offers strategic level,external,integrated,and historical information?

Accepted Answer

A)  Identify trends. 
B)  Make projections. 
C)  Decide key business issues. 
D)  All of these. 
A)  Identify trends. 
B)  Make projections. 
C)  Decide key business issues. 
D)  All of these.

Question 15

Extraction,transformation,and loading is a process that extracts information from internal databases,transforms the information using a common set of enterprise definitions,and loads the information into an external database.

Accepted Answer

A) True 
 B)False

Question 16

A dimension is a particular attribute of information.Each layer in a data warehouse or data mart represents information according to an additional dimension.What is the common term for the representation of multidimensional information?

Accepted Answer

A)  Table 
B)  Block 
C)  Cube 
D)  All of these 
A)  Table 
B)  Block 
C)  Cube 
D)  All of these

Question 17

A relational database contains information in a series of two-dimensional tables.How is data contained in a data warehouse and data mart?

Accepted Answer

A)  Information is multidimensional, meaning it contains a single layer of data in a table format. 
B)  Information is two-dimensional, meaning it contains a single layer of data in a table format. 
C)  Information is two-dimensional, meaning it contains layers of columns and rows. 
D)  Information is multidimensional, meaning it contains layers of columns and rows. 
A)  Information is multidimensional, meaning it contains a single layer of data in a table format. 
B)  Information is two-dimensional, meaning it contains a single layer of data in a table format. 
C)  Information is two-dimensional, meaning it contains layers of columns and rows. 
D)  Information is multidimensional, meaning it contains layers of columns and rows.

Question 18

Which of the following statements is true regarding customer information?

Accepted Answer

A)  Customer information can exist in several operational systems. 
B)  Customer information in each operational system could change. 
C)  Customer information in each operational system can be different. 
D)  All of these. 
A)  Customer information can exist in several operational systems. 
B)  Customer information in each operational system could change. 
C)  Customer information in each operational system can be different. 
D)  All of these.

Question 19

Identify the importance of ensuring the cleanliness of information throughout an organization.

Accepted Answer

An organization must maintain high-quali

Question 20

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

Accepted Answer

A)  Physical, transactional 
B)  Physical, operational 
C)  Logical, transactional 
D)  Logical, operational 
A)  Physical, transactional 
B)  Physical, operational 
C)  Logical, transactional 
D)  Logical, operational

What is a dimension?

What is information that people use to support their decision-making efforts?

The primary purpose of a data warehouse is to perform transactional processes.

Explain the primary difference between a database and a data warehouse.

Which of the following is not one of the principal BI enablers?

What do data warehouses support?

Data information in a data warehouse contains layers of columns and rows,and this is known as __________ databases.

The Data Warehousing Institute estimates that low-quality information costs U.S.businesses $60 billion annually.

A(n)__________ is a particular attribute of information.

Which of the following does not draw a parallel between the challenges in business and the challenges of war?

Data _________ is the process of analyzing data to extract information not offered by the raw data alone.

A(n)___________ is the common term for the representation of multidimensional information.

Why would a business use a data warehouse that offers strategic level,external,integrated,and historical information?

Extraction,transformation,and loading is a process that extracts information from internal databases,transforms the information using a common set of enterprise definitions,and loads the information into an external database.

A dimension is a particular attribute of information.Each layer in a data warehouse or data mart represents information according to an additional dimension.What is the common term for the representation of multidimensional information?

A relational database contains information in a series of two-dimensional tables.How is data contained in a data warehouse and data mart?

Which of the following statements is true regarding customer information?

Identify the importance of ensuring the cleanliness of information throughout an organization.

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

Business Driven Technology

Identifying Competitive Advantages

Strategic Initiatives for Implementing Competitive Advantages

Measuring the Success of Strategic Initiatives

Organizational Structures That Support Strategic Initiatives

Valuing Organizational Information

Storing Organizational Information Databases

Enabling the Organization Decision Making

Extending the Organization Supply Chain Management

Building a Customer-Centric Organization Customer Relationship Management

Integrating the Organization From End-To-End Enterprise Resource Planning

Creating Innovative Organizations

E-Business

Creating Collaborative Partnerships

Integrating Wireless Technology in Business

Building Software to Support an Agile Organization

Managing Organizational Projects

Outsourcing in the 21st Century

Developing a 21st-Century Organization

Filters

Exam 8: Accessing Organizational Information Data Warehouse

What is a dimension?

What is information that people use to support their decision-making efforts?

The primary purpose of a data warehouse is to perform transactional processes.

Explain the primary difference between a database and a data warehouse.

Which of the following is not one of the principal BI enablers?

What do data warehouses support?

Data information in a data warehouse contains layers of columns and rows,and this is known as __________ databases.

The Data Warehousing Institute estimates that low-quality information costs U.S.businesses $60 billion annually.

A(n)__________ is a particular attribute of information.

Which of the following does not draw a parallel between the challenges in business and the challenges of war?

Data _________ is the process of analyzing data to extract information not offered by the raw data alone.

A(n)___________ is the common term for the representation of multidimensional information.

Why would a business use a data warehouse that offers strategic level,external,integrated,and historical information?

Extraction,transformation,and loading is a process that extracts information from internal databases,transforms the information using a common set of enterprise definitions,and loads the information into an external database.

A dimension is a particular attribute of information.Each layer in a data warehouse or data mart represents information according to an additional dimension.What is the common term for the representation of multidimensional information?

A relational database contains information in a series of two-dimensional tables.How is data contained in a data warehouse and data mart?

Which of the following statements is true regarding customer information?

Identify the importance of ensuring the cleanliness of information throughout an organization.

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

Business Driven Technology

Identifying Competitive Advantages

Strategic Initiatives for Implementing Competitive Advantages

Measuring the Success of Strategic Initiatives

Organizational Structures That Support Strategic Initiatives

Valuing Organizational Information

Storing Organizational Information Databases

Enabling the Organization Decision Making

Extending the Organization Supply Chain Management

Building a Customer-Centric Organization Customer Relationship Management

Integrating the Organization From End-To-End Enterprise Resource Planning

Creating Innovative Organizations

E-Business

Creating Collaborative Partnerships

Integrating Wireless Technology in Business

Building Software to Support an Agile Organization

Managing Organizational Projects

Outsourcing in the 21st Century

Developing a 21st-Century Organization

Filters

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