MBA Chap 3.2

The function of a DBMS that standardizes and verifies the consistency of the data is (a)   .

• Data filtering and profiling

• Data integrity and maintenance

• Data synchronization

• Data security

The function of a DBMS that inspects the data for errors, inconsistencies, redundancies, and incomplete information is (a)   .

• Data filtering and profiling

• Data integrity and maintenance

• Data synchronization

• Data security

The function of a DBMS that controls data integrity over time is (a)   .

• Data filtering and profiling

• Data integrity and maintenance

• Data synchronization

• Data security

The function of a DBMS that matches, or links data from disparate sources is (a)   .

• Data filtering and profiling

• Data integrity and maintenance

• Data synchronization

• Data security

A DBMS that does not lose service as a result of a single failure is said to be _______________.

• fault tolerant

• scalable

• volatile

• redundant

NoSQL systems have increased in popularity because of the growing need for ________, which means the system can increase in size to handle data growth.

• scalability

• fault tolerance

• handling big data

• large Web apps

Which of the following is not a consequence of poor quality or dirty data?

• The company loses sales or customers

• Information workers are constrained in their jobs

• Decision makers face too much uncertainty to make intelligent decisions

• The company faces data ownership problems

The primary benefits of centralized database configuration are better __________ and __________.

• Reports / Statistical Tools

• Quality / Security

• Speed / Access

• Software / Hardware

The primary disadvantage of centralized database systems is ________.

• Data security

• Data quality

• Availability of statistical analysis tools

• Transmission delay when users are geo-dispersed

Distributed databases use (a)   architecture to process information requests.

• Client/server

• NoSQL

• Private clouds

• Public clouds