Chapter 4 – The Data Resource – Flashcards
Unlock all answers in this set
Unlock answersquestion
Which of the statements about managing data is true?
answer
Reconciling inconsistent data can require a significant amount of time and money.
question
Data that unambiguously describes other data for enterprise use are called:
answer
metadata
question
In an ERD, a characteristic of a customer entity is diagrammed as a(n):
answer
attribute
question
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:
answer
enterprise modeling
question
A bottom-up approach to describe the data structure and other requirements of an organizations, in which reports, screens, and relevant documents are analyzed, is called:
answer
view integration
question
The process of creating simple data structures from more complex ones, which yields a data model that is very stable and useful across many different requirements, is called:
answer
normalization
question
All of the following are true about use a pre-existing (packaged) data model, except:
answer
it cannot be customized to fit the terms and business rules of a specific organization.
question
The data modeling guideline that specifies the functional, business division, and/or corporate coverage is called the:
answer
scope
question
The data modeling guideline that captures the need that justified the data modeling effort is specified in the:
answer
objective.
question
An example of a query language used for posing queries to a database is:
answer
SQL
question
An example of a data exchange language to pass data between computers for e-business is:
answer
XML
question
Which of the following is not true about managing data in today's large organizations?
answer
Data is captured more than once to ensure accuracy.
question
Databases for managerial control and other decision-making are often subsets, summaries, or aggregations of ____________ with external data supplements.
answer
operational databases
question
Which of the following statements about information processing with application independence is not true
answer
Data that is accessed from a database for application processing is automatically deleted from the database.
question
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:
answer
data transfer application
question
An application that distributes data to authorized users and manipulates data to create useful info from established data sources is called a:
answer
data analysis and presentation application
question
An application that gathers data and populates databases is called a:
answer
data capture application
question
Which of the following statements is true about the retention of data?
answer
Some national laws require that certain types of data must be retained for certain periods of time.
question
An unambiguous description of each type of data that applies to all business circumstances and users is called a(n):
answer
definition
question
A characteristic of a business entity that uniquely distinguishes it from other instances of the entity for the long term is called a(n):
answer
identifier
question
Which of the following prescribes who can do what and when to each kind of data?
answer
usage rights
question
A data dictionary/directory, or DD/D, contains each of the following, except:
answer
data standards
question
__________ refers to the disciplines, technologies, and methods to ensure the currency, meaning and quality of reference data within and across various subject areas.
answer
MDM
question
What organizational role or unit is responsible for functions such as physical database design, database interfaces with other technologies, and database recovery methods?
answer
database administrator
question
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?
answer
organize and make accessible
question
What organizational role or unit is responsible for functions such as maintaining metadata, reducing redundant data, and improving data quality across an organization?
answer
data administration
question
What organizational role or unit is responsible for the quality of the data in a particular subject database or departmental area?
answer
data steward
question
Each of the following is a critical step in a data quality initiative, except:
answer
Avoiding the usage of advanced data cleansing tools
question
Which of the following is a rationale for data ownership?
answer
All of the above - the need to protect the privacy of personal data, the need to protect trade secrets, and the need to share data with those who "need to know"
question
Which of the following is a justification given for laws that control data flows across national borders?
answer
both B and C - protect a domestic industry and protect individual privacy
question
If an organization maintains application independence, then application software can more easily be abandoned or replaced.
answer
True
question
Data warehouses provide a method for making historical and current data accessible for queries by many people throughout the organization.
answer
True
question
For legal reasons, all data should be stored indefinitely.
answer
False
question
The permissible range or set of values for each data element is defined by integrity rules.
answer
True
