Chapter 12, chapter 11, asdf10

________ duplicates data across databases.

Data propagation

All of the following are popular architectures for Master Data Management EXCEPT:

Normalization

A(n) ________ stores metadata about an organization's data and data processing resources.

information repository

A centralized strategy has ________ expandability.

poor

An organization should have one data warehouse administrator for every

100 gigabytes of data in the enterprise data warehouse.

Which of the following is not a component of a repository system architecture?

A data transformation process

A data warehouse administrator has which of the following responsibilities?

A data warehouse administrator has which of the following responsibilities?

Which of the following are key steps in a data quality program?

Apply TQM principles and practices.

Which of the following is true of distributed databases?

Better local control

hich type of index is commonly used in data warehousing environments?

Bit-mapped index

________ insures that a transaction is successfully completed or else it is aborted.

Commit protocol

Which of the following is true about horizontal partitioning?

Data can be stored to optimize local access.

________ is a technical function responsible for database design, security, and disaster recovery.

Database administration

Which of the following functions model business rules?

Database analysis

Which of the following functions develop integrity controls?

Database design

Which of the following functions do cost/benefit models?

Database planning

Which of the following supports a simple path to other databases, without the benefits of one logical database?

Gateways

A(n) ________ is submitted by a DBA to test the current performance of a database or predict the response time for queries.

Heartbeat query

Which of the following environments uses a different DBMS at each node, and supports local databases for unique data requests?

Heterogeneous; federated

Which of the following environments uses the same DBMS at each node with a central or master DBMS coordinating database access across nodes?

Homogeneous; nonautonomous

________ is a design goal for a distributed database, which says a user does not need to know the location of data to use the data.

Location transparency

Which of the following threats involves outside parties using information to embarrass a company?

Loss of confidentiality

The methods to ensure the quality of data across various subject areas are called:

Master Data Management.

The W3C standard for Web privacy is called:

Platform for Privacy Preferences.

________ is used to undo unwanted database changes.

Rollback

Which of the following characterizes homogeneous environments?

Same DBMS used at all locations

Which of the following is a principal type of authorization table?

Subject

Which of the following is a basic method for single field transformation?

Table lookup

TQM stands for:

Total Quality Management.

Which of the following is NOT an area of concern when trying to maintain a well-tuned database?

User interface design

Snapshot replication is most appropriate for

a data warehouse application.

An open-source DBMS is:

a free source-code RBMS that provides the functionality of an SQL-compliant DBMS.

The process of transforming data from a detailed to a summary level is called:

aggregating

While views promote security by restricting user access to data, they are not adequate security measures because:

an unauthorized person may gain access to a view through experimentation.

Which of the following is a type of network security:

authentication of the client workstation.

Controls designed to restrict access and activities are called:

authorization rules.

The preferred method of fixing an aborted transaction is:

backing out the transaction.

A device to measure or detect fingerprints or signatures is called a(n) ________ device.

biometric

One way to improve the data capture process is to:

check entered data immediately for quality against data in the database

A DBMS periodically suspends all processing and synchronizes its files and journals through the use of a:

checkpoint facility.

A characteristic of reconciled data that means the data reflect an enterprise-wide view is:

comprehensive

The actions that must be taken to ensure data integrity is maintained during multiple simultaneous transactions are called ________ actions.

concurrency control

A design goal for distributed databases that states that although a distributed database runs many transactions, it appears that a given transaction is the only one in the system is called: A) linear run.

concurrency transparency.

All of the following are tasks of data cleansing EXCEPT:

creating foreign keys.

Data quality problems can cascade when:

data are copied from legacy systems.

Conformance means that:

data are stored, exchanged or presented in a format that is specified by its metadata.

A repository of information about a database that documents data elements of a database is called a:

data dictionary

Including data capture controls (i.e., dropdown lists) helps reduce ________ deteriorated data problems.

data entry

All of the following are ways to consolidate data EXCEPT:__

data rollup and integration.

A technique using artificial intelligence to upgrade the quality of raw data is called:

data scrubbing

A technique using pattern recognition to upgrade the quality of raw data is called:

data scrubbing.

Converting data from the format of its source to the format of its destination is called:

data transformation.

A(n) ________ is a database stored on multiple computers in multiple locations that are NOT connected by a data communications link.

decentralized database

) An integrated partition strategy is ________ to manage.

difficult

A ________ allows a single SQL statement to refer to tables in more than one remote DBMS.

distributed request

All of the following are advantages of vertical partitioning EXCEPT

easier to set up than horizontal partitioning.

A synchronized replication strategy has a(n) ________ reliability.

excellent

A(n) ________ prevents another transaction from reading and therefore updating a record until it is unlocked.

exclusive lock

Datatype conflicts is an example of a(n) ________ reason for deteriorated data quality.

external data source.

Getting poor data from a supplier is a(n) ________ reason for deteriorated data quality.

external data source.

With ________ all of the actions of a transaction are either committed or not committed.

failure transparency

Loading data into a data warehouse does NOT involve:

formatting the hard drive.

) In a distributed database, a transaction that requires reference to data at one or more nonlocal sites is called a ________ transaction.

global

Data governance can be defined as:

high-level organizational groups and processes that oversee data stewardship.

Data that are accurate, consistent, and available in a timely fashion are considered:

high-quality.

The best place to improve data entry across all applications is:

in the database definitions.

A method of capturing only the changes that have occurred in the source data since the last capture is called ________ extract.

incremental

Data quality is important for all of the following reasons EXCEPT:

it provides a stream of profit.

The process of combining data from various sources into a single table or view is called:

joining

An audit trail of database changes is kept by a:

journalizing facility

An optimization strategy that allows sites that can update to proceed and other sites to catch up is called

lazy commit.

Informational and operational data differ in all of the following ways EXCEPT:

level of detail.

With ________, users can act as if all the data were located at a single node.

location transparency

The extent of the database resource that is included with each lock is called the level of:

lock granularity

In the ________ approach, one consolidated record is maintained from which all applications draw data.

persistent

In the ________ approach, one consolidated record is maintained, and all applications draw on that one actual "golden" record.

persistent

Data federation is a technique which:

provides a virtual view of integrated data without actually creating one centralized database.

Event-driven propagation:

pushes data to duplicate sites as an event occurs.

The major advantage of data propagation is

real-time cascading of data changes throughout the organization.

A ________ is a DBMS module that restores the database to a correct condition when a failure occurs.

recovery manager

All of the following are disadvantages of data replication EXCEPT:

reduced network traffic at prime time.

An approach to filling a data warehouse that employs bulk rewriting of the target data periodically is called:

refresh mode.

A design goal for distributed databases to allow programmers to treat a data item replicated at several sites as though it were at one site is called:

replication transparency

Data quality ROI stands for:

risk of incarceration.

Guidelines for server security should include all of the following EXCEPT:

securing the network between client and server.

A joining operation in which only the joining attribute from one site is transmitted to the other site is called a(n):

semijoin.

A credit-card sized plastic card with an embedded microprocessor chip with the ability to store, process and output electronic data in a secure manner is called a(n):

smart card.

One simple task of a data quality audit is to:

statistically profile all files.

With a pull strategy of replication, the ________ node determines when a database is updated.

target

Security measures for dynamic Web pages are different from static HTML pages because:

the connection requires full access to the database for dynamic pages.

External data sources present problems for data quality because:

there is a lack of control over data quality.

One characteristic of quality data which pertains to the expectation for the time between when data are expected and when they are available for use is:

timeliness

A discrete unit of work that must be processed completely or not at all within a computer system is called a

transaction.

Forward recovery is faster than restore/rerun because

transactions do not have to be repeated.

One way to generate store and forward messages for completed transactions to be broadcast across a network is through the use of:

triggers

A(n) ________ is a procedure for acquiring the necessary locks for a transaction where all necessary locks are acquired before any are released.

two-phase lock

Quality data can be defined as being:

unique

The sequence of instructions required to process a transaction is called the:

unit of work.

User interaction integration is achieved by creating fewer ________ that feed different systems.

user interfaces

An optimistic approach to concurrency control is called:

versioning.

Replication should be used when:

when there are no or few triggers.