Question 1

The various types of online analytical processing OLAP)  does NOT include:

Accepted Answer

A)  MOLAP - Multidimensional online analytical processing.
B)  NOLAP - Notational online analytical processing.
C)  ROLAP - Relational online analytical processing.
D)  All of the above, A, B, and C are types of OLAP systems.E) B) and C)
F) All of the above

Question 2

Select the true statement from the following:

Accepted Answer

A)  Clients are usually workstations that contain data files.
B)  Servers are usually less capable computing power since their function is routing requirements to resources.
C)  Servers may contain shared files and resources.
D)  Servers usually do not control assets such as printers and Internet portals.E) A) and C)
F) A) and B)

Question 3

In today's IT environment:

Accepted Answer

A)  Processing speed is compromised for query capability with relational databases.
B)  Query capability is compromised for processing speed with relational databases.
C)  Neither querying nor processing speed need be compromised with relational databases.
D)  Both querying and processing speed are compromised with relational databases.E) B) and C)
F) A) and B)

Question 4

A character is a customer, client, or vendor.

Accepted Answer

A) True 
 B)False

Question 5

The requirements to frequently or infrequently access data are not relevant to the way that the data is stored due to computer access speed.

Accepted Answer

A) True 
 B)False

Question 6

The loss of transaction processing efficiency:

Accepted Answer

A)  Is substantial but a necessary trade-off with relational databases.
B)  Is minimized because of the increased computing power available.
C)  Is a primary reason why relational databases are not utilized.
D)  Both B and C are correct.E) All of the above
F) B) and C)

Question 7

If a company stores data in separate files in its different departmental locations and is able to update all files simultaneously, it would not have problems with

Accepted Answer

A)  Attributes.
B)  Data redundancy.
C)  Industrial espionage.
D)  Concurrency.E) B) and C)
F) None of the above

Question 8

Concurrency means that all of the multiple instances of the same data are exactly alike.

Accepted Answer

A) True 
 B)False

Question 9

Select the true statement from the following.

Accepted Answer

A)  High-impact processes HIPs)  are identified by single-functional teams.
B)  High-impact processes HIPs)  and user's needs determine the data in the data warehouse.
C)  High-impact processes HIPs)  address both short-term and long-term objectives.
D)  High-impact processes HIPs)  determine the long-term strategy of the organization.E) C) and D)
F) A) and B)

Question 10

The organization should institute procedures to insure that all customer data collected retains accuracy, is complete, is current, is relevant, and is reliable".

Accepted Answer

A) True 
 B)False

Question 11

Because of today's computing power and Internet accessibility, there has been a substantial increase in the use of centralized databases and centralized processing.

Accepted Answer

A) True 
 B)False

Question 12

A field is a set of characters that fill a space reserved for a particular kind of data.

Accepted Answer

A) True 
 B)False

Question 13

Magnetic tape is a storage medium that allows only a sequential access type of storage.

Accepted Answer

A) True 
 B)False

Question 14

Batch processing occurs when similar transactions are grouped together, and that group is processed as a batch.

Accepted Answer

A) True 
 B)False

Question 15

Tools commonly used in data mining are OLAP, ROLAP, and MOLAP.

Accepted Answer

A) True 
 B)False

Question 16

When a company buys data storage from a cloud provider, the arrangement is referred to as:

Accepted Answer

A)  Online analytical processing
B)  Cloud services assessment
C)  Distributed data storage
D)  Database as a serviceE) A) and B)
F) C) and D)

Question 17

The additive characteristic means:

Accepted Answer

A)  The linked tables are synergetic within themselves - linked they are more powerful than alone.
B)  The values in the preceding fields must total into a following field.
C)  That if the preceding rules are met, the rule can be met.
D)  That if the preceding rules are not met, the rule must be met.E) All of the above
F) A) and C)

Question 18

Batch processing:

Accepted Answer

A)  Occurs when dissimilar transactions are grouped and processed as a group.
B)  Occurs when similar transactions are grouped together and processed as a group.
C)  Occurs when the transaction is processed as soon as it is entered.
D)  Would not be used for payment to vendor type transactions since they are time sensitive.E) A) and D)
F) B) and C)

Question 19

When data and processing are distributed across several computers, as occurs in a system of distributed processing, the failure of one site will be harmful and bring down the entire system.

Accepted Answer

A) True 
 B)False

Question 20

Which of the following correctly orders the hierarchy of data from smallest to largest?

Accepted Answer

A)  Field, character, record, file, database
B)  Character, record, field, file, database
C)  File, character, database, field, record
D)  Character, field, record, file, databaseE) A) and B)
F) All of the above

Exam 13: Data and Databases

When data and processing are distributed across several computers, as occurs in a system of distributed processing, the failure of one site will be harmful and bring down the entire system.

Correct AnswerverifiedShow Answer

The loss of transaction processing efficiency:

Correct AnswerverifiedShow Answer

A character is a customer, client, or vendor.

Correct AnswerverifiedShow Answer

If a company stores data in separate files in its different departmental locations and is able to update all files simultaneously, it would not have problems with

Correct AnswerverifiedShow Answer

When a company buys data storage from a cloud provider, the arrangement is referred to as:

Correct AnswerverifiedShow Answer

Tools commonly used in data mining are OLAP, ROLAP, and MOLAP.

Correct AnswerverifiedShow Answer

Select the true statement from the following.

Correct AnswerverifiedShow Answer

Batch processing:

Correct AnswerverifiedShow Answer

Because of today's computing power and Internet accessibility, there has been a substantial increase in the use of centralized databases and centralized processing.

Correct AnswerverifiedShow Answer

Magnetic tape is a storage medium that allows only a sequential access type of storage.

Correct AnswerverifiedShow Answer

In today's IT environment:

Correct AnswerverifiedShow Answer

The various types of online analytical processing OLAP) does NOT include:

Correct AnswerverifiedShow Answer

Concurrency means that all of the multiple instances of the same data are exactly alike.

Correct AnswerverifiedShow Answer

Batch processing occurs when similar transactions are grouped together, and that group is processed as a batch.

Correct AnswerverifiedShow Answer

Which of the following correctly orders the hierarchy of data from smallest to largest?

Correct AnswerverifiedShow Answer

A field is a set of characters that fill a space reserved for a particular kind of data.

Correct AnswerverifiedShow Answer

The requirements to frequently or infrequently access data are not relevant to the way that the data is stored due to computer access speed.

Correct AnswerverifiedShow Answer

The organization should institute procedures to insure that all customer data collected retains accuracy, is complete, is current, is relevant, and is reliable".

Correct AnswerverifiedShow Answer

Select the true statement from the following:

Correct AnswerverifiedShow Answer

The additive characteristic means:

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified