Chapter 4 Flashcards
Which of the following statements about managing data is true?
Reconciling inconsistent data can require a significant amount of time and money.
Data that unambiguously describes other data for enterprise use are called:
metadata.
A top-down data modeling approach to describe the data structure and other requirements of an organization, independent of any particular reports or screens, is called:
enterprise modeling
All of the following are true about using a pre-existing (packaged) data model
the modeling projects require less time and money.
it may be easier to share data with other organizations in the industry.
it is likely to work well with other applications from the same vendor.
The data modeling guideline that specifies the functional, business division, and/or corporate coverage is called the:
scope
An example of a query language used for posing queries to a database is:
SQL.
An example of a data exchange language to pass data between computers for e-business is:
XML.
Which of the following is not true about managing data in today’s large organizations?
Data is captured more than once to ensure accuracy.
The following statements about information processing with application independence
Data are captured and stored in an operational database.
processing is automatically deleted from the database.
Subsets and aggregated operational data may be periodically transferred to a long-term data warehouse.
An application that moves data from one database to another and permits one source of data to serve many localized systems within an organization is called a:
data transfer application
An application that distributes data to authorized users and manipulates data to create useful information from established data sources is called a:
data analysis and presentation application
The following statements is true about the retention of data?
Some national laws require that certain types of data must be retained for certain periods of time.
An unambiguous description of each type of data that applies to all business circumstances and users is called a(n):
definition.
A characteristic of a business entity that uniquely distinguishes it from other instances of the entity for the long term is called a(n):
identifier
A data dictionary/directory, or DD/D, contains each of the following?
entity definitions.
data element definitions.
data standards.
What organizational role or unit is responsible for functions such as physical database design, database interfaces with other technologies, and database recovery methods?
database administrator
Determining the physical arrangement of data based on the data currently required by the business and expected to be required in the future is part of which of the following data resource management functions?
organize and make accessible
What organizational role or unit is responsible for functions such as maintaining metadata, reducing redundant data, and improving data quality across an organization?
data administration
What organizational role or unit is responsible for the quality of the data in a particular subject database or departmental area?
data steward
Which of the following is a rationale for data ownership?
A) the need to protect the privacy of personal data
B) the need to protect trade secrets
C) the need to share data with those who “need to know”
Which of the following is a justification given for laws that control data flows across national borders?
protect a domestic industry
protect individual privacy
Data warehouses provide a method for making historical and current data accessible for queries by many people throughout an organization.
TRUE
For legal reasons, all data should be stored indefinitely.
FALSE
Explanation: Some data should be retained, while other data should be disposed of at regular intervals, based on legal requirements and organizational policies.
The permissible range or set of values for each data element is defined by integrity rules.
TRUE
Databases for managerial control and other decision-making are often subsets, summaries, or aggregations of ________________ databases with external data supplements.
operational
