cis ch 5 Flashcards

question

The most common source system for a company’s data warehouse is its corporate operational databases.
answer

True
question

Companies often have to clean up the data before it can be imported into the data warehouse.
answer

True
question

The ETL process is now typically called data integration.
answer

True
question

The most common method for storing data in a data warehouse is:
answer

One central data warehouse
question

The IT department is solely responsible for the quality of the data in the data warehouse.
answer

False
question

Governance of a data warehouse must be a collaboration between business users and IT personnel.
answer

True
question

Big Data is the same thing as huge amounts of structured data in organizational databases.
answer

False
question

Which of the following is not a type of Big Data? Traditional enterprise data Sensor data Social data Images
answer

All of the above
question

Data in a data warehouse are organized by business process, where data in corporate databases are organized by subject.
answer

False
question

Data updates in a data warehouse are performed by the MIS department, not the users.
answer

True
question

A data warehouse is a repository of historical data that are organized by subject to support decision makers in the organization.
answer

True
question

Organizational databases access one record at a time, where data warehouses access groups of related records.
answer

True
question

Each ___ in a relational database is a record.
answer

Row
question

One of the attributes in a record must be a primary key.
answer

True
question

One field that uniquely identifies an entity or a record is:
answer

File
question

ER diagrams consist of entities, attributes, and relationships.
answer

True
question

The relationship between Student and Parking Permit is mandatory 1:1 because each student may have only one parking permit.
answer

True
question

In an ER diagram, relationships are expressed as diamonds and entities are expressed as boxes.
answer

True
question

The MIS department is solely responsible for the organization’s ER diagrams.
answer

False
question

After you have taken a particular course, your insights on how to do well in that course would be considered to be tacit knowledge.
answer

True
question

The IT infrastructure needed for you to register online for next semester would be considered to be explicit knowledge.
answer

True
question

Managing data is difficult because data is stored in one place in an organization, its database.
answer

False
question

In the preceding example, “Robert Jones” is an example of:
answer

Transaction data
question

NoSQL databases can manage more different types of data than a traditional relational database.
answer

True
question

A/B experiments are so-named because there are only two possible outcomes for each experiment.
answer

True
question

Normalization typically improves processing performance.
answer

True
question

When data are normalized, attributes in the table depend on the primary key and the secondary key.
answer

False
question

Data subject to constraints is an example of:
answer

Data integrity
question

A group of logically related fields is a(n):
answer

Record
question

A collection of logically related records (see table).
answer

data File
question

The identifier field or attribute that uniquely identifies a record.
answer

Primary Key
question

A grouping of logically related records (see data file).
answer

Table
question

Attributes that are unique to an entity instance.
answer

Identifiers
question

A binary digit—that is, a 0 or a 1.
answer

Bit
question

The most effective and efficient ways to do things.
answer

Best practices
question

Data collected about user behavior and browsing patterns by monitoring users’ activities when they visit a Web site.
answer

Clickstream data
question

Popular relational database language that enables users to perform complicated searches with relatively simple instructions.
answer

structured query language (SQL)
question

A group of eight bits that represents a single character.
answer

byte
question

An identifier field or attribute that has some identifying information but typically does not identify the file with complete accuracy.
answer

Secondary key
question

Each characteristic or quality describing a particular entity.
answer

attribute
question

A group of logically related files that stores data and the associations among them.
answer

database
question

A method for analyzing and reducing a relational database to its most streamlined form for minimum redundancy, maximum data integrity, and best processing performance
answer

Normalization
question

Information technologies used to systematize, enhance, and expedite intra- and interfirm knowledge management.
answer

Knowledge management systems (KMSs)
question

Collection of definitions of data elements; data characteristics that use the data elements; and the individuals, business functions, applications, and reports that use this data element.
answer

Data dictionary
question

The software program (or group of programs) that provides access to a database.
answer

database management system (DBMS)
question

An approach to managing information across an entire organization.
answer

Data governance
question

Database language that enables the user to fill out a grid (form) to construct a sample or description of the data wanted.
answer

query by example (QBM)
question

The process of designing a database by organizing data entities to be used and identifying the relationships among them.
answer

entity-relationship (ER) modeling
question

A grouping of logically related records.
answer

File
question

A process that helps organizations identify, select, organize, disseminate, transfer, and apply information and expertise that are part of the organization’s memory and that typically reside within the organization in an unstructured manner.
answer

Knowledge Management
question

A process that provides companies with the ability to store, maintain, exchange, and synchronize a consistent, accurate, and timely “single version of the truth” for the company’s core master data.
answer

Master data management
question

A particular entity within an entity class.
answer

instance
question

A low-cost, scaled-down version of a data warehouse that is designed for the end-user needs in a strategic business unit (SBU) or a department.
answer

data mart
question

Definition of the way data in a DBMS are conceptually structured.
answer

data model
question

Groupings of entities of a given type.
answer

entity classes
question

A person, place, thing, or event about which information is maintained in a record.
answer

entity
question

The cumulative store of subjective or experiential learning, which is highly personal and hard to formalize.
answer

tatic knowledge
question

Diverse, high-volume, high-velocity information assets that require new forms of processing to enable enhanced decision making, insight discovery, and process optimization.
answer

Big data
question

A grouping of logically related characters into a word, a small group of words, or a complete number.
answer

field
question

Databases that can manipulate structured as well as unstructured data and inconsistent or missing data; are useful when working with Big Data.
answer

NoSQL databases
question

Processing of business transactions online as soon as they occur.
answer

Online transaction processing (OLTP)
question

A grouping of logically related fields; describes an entity.
answer

record
question

A set of core data, such as customer, product, employee, vendor, geographic location, and so on, that spans an enterprise’s information systems.
answer

Master Data
question

Data model based on the simple concept of tables in order to capitalize on characteristics of rows and columns of data.
answer

relational database model
question

The more objective, rational, and technical types of knowledge.
answer

explicit knowledge
question

Other terms for knowledge
answer

intellectual capital (or intellectual assets)
question

Document that shows data entities and attributes and relationships among them.
answer

entity-relationship (ER) model
question

A repository of historical data that are organized by subject to support decision makers in the organization.
answer

data warehouse
question

Storage of data in more than two dimensions; a common representation is the data cube.
answer

multidimensional structure
question

What is one of the problems with Big Data?
answer

collecting the data
question

Customer data degradation is the inability to manage data because of
answer

customers changing their addresses
question

Which statement becomes true as the amount of data increases?
answer

The data becomes harder to manage
question

The Sarbanes-Oxley Act was created to force companies to disclose what type of information?
answer

financial
question

Data __________ prevents data from being used by more than one application.
answer

isolation
question

Data integrity deals with
answer

meeting system constraints with the data
question

Storing data in a database minimizes the risk of what scenario for the data?
answer

isolation
question

Normalization of a relational database involves what process?
answer

streamlining
question

What type of data depends on the primary key as its only attribute in the data table?
answer

normalized data
question

Historical data is stored in a
answer

data warehouse
question

Which of the following statements is true about data warehouses?
answer

the use of a warehouse does not degrade the database’s performance
question

What does OLAP involve?
answer

the analysis of accumulated data by users
question

Relational databases are based on what type of structure?
answer

related tables
question

Explicit knowledge is
answer

procedural
question

Which type of knowledge depends on employees’ willingness to transfer it?
answer

tacit
question

The first step in a knowledge management system cycle is to
answer

create knowledge
question

Data governance manages
answer

information access
question

Which statement is characteristic of a data mart?
answer

they are primarily used by smaller companies
question

Companies transform data in order to
answer

make it more useful
question

Why is metadata important?
answer

it tells about the data stored in data warehouse
question

How is an attribute used in a relational database?
answer

it stores information about entities stored in the database
question

An online retailer can gain a competitive advantage by utilizing what characteristic of Big Data?
answer

velocity
question

An international financial research firm wishes to capture old financial market data from the past few decades in a database. Some of the data is missing and not well structured. This type of data is better handled by a(n)
answer

NoSQL
question

An employee observes his co-worker programming SQL statements to query the university’s database. His query will use many variables to retrieve a student’s records. The employee thinks that the database will run too slowly as more university employee need to use it. To improve the situation, he might suggest that his co-worker
answer

create a form template into which users can enter all search data.
question

One characteristic of Big Data is that it focuses on algorithms instead of ______ to make decisions.
answer

Humans
question

Using a KMS to capture the expertise of an organization’s human resources can make it easier to handle
answer

turnover
question

In a database, quick comparison across rows and columns is achieved by
answer

using tables
question

A database becomes unsearchable when
answer

neither a primary key nor a secondary key exist
question

Getting employees to share their work experience builds____ knowledge, which is needed to develop a KMS in an organization.
answer

tacit
question

Managing the security and access of a database is the job of a(n)
answer

DBMS
question

Transferring data to a new storage device could prevent which problem?
answer

Data cannot be retrieved from an old device
question

An entity is different from a record because it is a(n) ____ way of designing the information for the database.
answer

Intangible
question

Which of the following problems do organizations face when managing data?
answer

Processing and analyzing the data that are being stored Collecting the vast amounts of data that are being generated Storing the data that are being collected
question

The term “data rot” refers to
answer

The deterioration of the medium on which the data are stored.
question

Data redundancy refers to:
answer

Having copies of the same data in multiple locations.
question

The management of data across the entire organization is most accurately defined as:
answer

data governance
question

a data model is the diagrammatic representation of a database that clearly defines a database’s ___, ____, and ____.
answer

entities, attributes, relationships
question

a standardized language used to manipulate data is ____. MS-Access Oracle Query-by-example language
answer

None of these
question

___ is a method for analyzing and reducing a relational database to its most streamlined form.
answer

Normalization
question

Operational data that are constantly updated are stored in:
answer

databases
question

It is very difficult to manage data for which of the following reasons?
answer

Data are scattered throughout organizations
question

When customers access a Web site and make purchases, they generate ______.
answer

Clickstream data
question

In a relational database, the customer record contains information regarding the customer’s last name. The last name is a(n):
answer

Attribute
question

Place the following members of the data hierarchy in the correct order:
answer

bit – byte- field-record-database
question

In a database, the primary key field is used to _____.
answer

uniquely identify a record
question

data dictionaries perform all of the following functions except:
answer

Providing information on each record
question

A standardized language used to manipulate data is ____.
answer

structured query language
question

the data in a data warehouse have which of the following characteristics?
answer

the are organized by subject
question

Compared to data warehouses, data marts have which one of the following characteristics?
answer

cost less
question

which of the following is an example of explicit knowledge?
answer

procedural guides
question

explicit knowledge has which of the following characteristics?
answer

objective
question

the most important benefit of knowledge management systems is:
answer

they make best practices available to employees

Get instant access to
all materials

Become a Member