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.

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.

Question 3

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

Accepted Answer

The answer of Assess the impact of low-quality information on...

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.

Question 5

The acronym ETL stands for _______.

Accepted Answer

The answer of The acronym ETL stands for _______....

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

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

The answer of Explain the multi-dimensional nature of data warehouses...

Question 11

Evaluate the advantages of the relational database model.

Accepted Answer

The answer of Evaluate the advantages of the relational database...

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

Question 13

A ______ is a collection of similar entities.

Accepted Answer

The answer of A ______ is a collection of similar...

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

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

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

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

Exam 4: Ethics and Information Security