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

cis ch 5 Flashcards

Unlock all answers in this set

Haven't found what you were looking for?

Search for samples, answers to your questions and flashcards