Question 1

What is time series information?

Accepted Answer

A)  Analyzes checkout scanner information 
B)  Time-stamped information collected at a particular frequency 
C)  Reveals the degree to which variables are related 
D)  All of these choices are correct. 
A)  Analyzes checkout scanner information 
B)  Time-stamped information collected at a particular frequency 
C)  Reveals the degree to which variables are related 
D)  All of these choices are correct.

Question 2

Which of the following can a database maintain information on?

Accepted Answer

A)  Inventory 
B)  Transactions 
C)  Employees 
D)  All of these choices are correct. 
A)  Inventory 
B)  Transactions 
C)  Employees 
D)  All of these choices are correct.

Question 3

Assess the impact of low-quality information on an organization and the benefits of high-quality information on an organization.

Accepted Answer

Using the wrong information can lead to

Question 4

What type of integrity constraint does not allow someone to create an order for a non-existent customer?

Accepted Answer

A)  Relational integrity constraint 
B)  Business-critical integrity constraint 
C)  Information-critical integrity constraint 
D)  None of these choices are correct. 
A)  Relational integrity constraint 
B)  Business-critical integrity constraint 
C)  Information-critical integrity constraint 
D)  None of these choices are correct.

Question 5

The acronym ETL stands for _______.

Accepted Answer

Extraction

Question 6

What is a backward integration?

Accepted Answer

A)  Takes information entered into a given system and sends it to the application generation component 
B)  Takes information entered into a given system and sends it automatically to all downstream systems and processes 
C)  Takes information entered into a given system and sends it automatically to all upstream systems and processes 
D)  Takes information entered into a given system and sends it to the DBMS 
A)  Takes information entered into a given system and sends it to the application generation component 
B)  Takes information entered into a given system and sends it automatically to all downstream systems and processes 
C)  Takes information entered into a given system and sends it automatically to all upstream systems and processes 
D)  Takes information entered into a given system and sends it to the DBMS

Question 7

An address containing Charlottetown, PEI, without a postal code is an example of incomplete information that is accurate.

Accepted Answer

A) True 
 B)False

Question 8

________ means that all information in a data warehouse is time-stamped with a particular time period, such as weekly, monthly, quarterly, or yearly.

Accepted Answer

The answer of ________ means that all information in a...

Question 9

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 a data warehouse.

Accepted Answer

A) True 
 B)False

Question 10

Explain the multi-dimensional nature of data warehouses (and data marts) and the business value gained from multidimensional analysis.

Accepted Answer

Databases contain information in a serie

Question 11

Evaluate the advantages of the relational database model.

Accepted Answer

Database advantages from a business pers

Question 12

In the relational database model, what is a person, place, thing, transaction, or event about which information is stored?

Accepted Answer

A)  Entity 
B)  Entity class 
C)  Attribute 
D)  Attribute class 
A)  Entity 
B)  Entity class 
C)  Attribute 
D)  Attribute class

Question 13

A ______ is a collection of similar entities.

Accepted Answer

table (or

Question 14

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

Accepted Answer

The answer of A data warehouse is a(n) ___________ collection...

Question 15

Which of the following statements is true?

Accepted Answer

A)  The more complete an organization wants to get its information, the less it costs 
B)  The more accurate an organization wants to get its information, the less it costs 
C)  The less accurate an organization wants to get its information, the more it costs 
D)  The more complete and accurate an organization wants to get its information, the more it costs 
A)  The more complete an organization wants to get its information, the less it costs 
B)  The more accurate an organization wants to get its information, the less it costs 
C)  The less accurate an organization wants to get its information, the more it costs 
D)  The more complete and accurate an organization wants to get its information, the more it costs

Question 16

In a table, each row contains a _____.

Accepted Answer

The answer of In a table, each row contains a...

Question 17

______________ is the duplication of information, or storing the same information in multiple places.

Accepted Answer

The answer of ______________ is the duplication of information, or...

Question 18

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

Question 19

In which one of the following data models, the data are organized into a treelike structure that allows repeating data using parent/child relationships?

Accepted Answer

A)  Hierarchical 
B)  Network 
C)  Relational 
D)  DBMS 
A)  Hierarchical 
B)  Network 
C)  Relational 
D)  DBMS

Question 20

The objects that are represented in the database and the relationships among them are well described by:

Accepted Answer

A)  Database 
B)  Business Intelligence 
C)  Schema 
D)  DBMS 
A)  Database 
B)  Business Intelligence 
C)  Schema 
D)  DBMS

What is time series information?

Which of the following can a database maintain information on?

Assess the impact of low-quality information on an organization and the benefits of high-quality information on an organization.

What type of integrity constraint does not allow someone to create an order for a non-existent customer?

The acronym ETL stands for _______.

What is a backward integration?

An address containing Charlottetown, PEI, without a postal code is an example of incomplete information that is accurate.

________ means that all information in a data warehouse is time-stamped with a particular time period, such as weekly, monthly, quarterly, or yearly.

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 a data warehouse.

Explain the multi-dimensional nature of data warehouses (and data marts) and the business value gained from multidimensional analysis.

Evaluate the advantages of the relational database model.

In the relational database model, what is a person, place, thing, transaction, or event about which information is stored?

A ______ is a collection of similar entities.

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

Which of the following statements is true?

In a table, each row contains a _____.

______________ is the duplication of information, or storing the same information in multiple places.

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

In which one of the following data models, the data are organized into a treelike structure that allows repeating data using parent/child relationships?

The objects that are represented in the database and the relationships among them are well described by:

Information Systems in Business

Strategic Decision Making

E-Business

It Architectures

Databases and Data Warehouses

Networks, Telecommunications, and Wireless Computing

Supply Chain Management

Customer Relationship Management

Enterprise Resource Planning and Collaboration Systems

Business Basics

Business Process

Filters

Exam 4: Ethics and Information Security

What is time series information?

Which of the following can a database maintain information on?

Assess the impact of low-quality information on an organization and the benefits of high-quality information on an organization.

What type of integrity constraint does not allow someone to create an order for a non-existent customer?

The acronym ETL stands for _______.

What is a backward integration?

An address containing Charlottetown, PEI, without a postal code is an example of incomplete information that is accurate.

________ means that all information in a data warehouse is time-stamped with a particular time period, such as weekly, monthly, quarterly, or yearly.

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 a data warehouse.

Explain the multi-dimensional nature of data warehouses (and data marts) and the business value gained from multidimensional analysis.

Evaluate the advantages of the relational database model.

In the relational database model, what is a person, place, thing, transaction, or event about which information is stored?

A ______ is a collection of similar entities.

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

Which of the following statements is true?

In a table, each row contains a _____.

______________ is the duplication of information, or storing the same information in multiple places.

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

In which one of the following data models, the data are organized into a treelike structure that allows repeating data using parent/child relationships?

The objects that are represented in the database and the relationships among them are well described by:

Information Systems in Business

Strategic Decision Making

E-Business

It Architectures

Databases and Data Warehouses

Networks, Telecommunications, and Wireless Computing

Supply Chain Management

Customer Relationship Management

Enterprise Resource Planning and Collaboration Systems

Business Basics

Business Process

Filters

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