STUFF

Cluster analysis

A technique used to divide an information set into mutually exclusive groups such that the members of each group are as close together as possible to one another and the different groups are as far apart as possible.

Data _______ is the collection of data from various sources for the purpose of data processing.

Aggregation

What represents the loss of a network signal strength measured in decibels (dB) and occurs because the transmissions gradually dissipate in strength over longer distances or because of radio interference or physical obstructions such as walls?

Attenuation

____________ represents the loss of a network signal strength measured in decibels (dB) and occurs because the transmissions gradually dissipate in strength over longer distances or because of radio interference or physical obstructions such as walls.

Attenuation

Select the three terms for the data elements associated with an entity.

Attributes Fields Columns

__________ critical integrity constraints enforce business rules vital to an organization's success and often require more insight and knowledge than relational integrity constraints.

Business

What defines how a company performs certain aspects of its business and typically results in either a yes/no or true/false answer?

Business Rule

What is the solution to the problem of being data rich and information poor?

Business intelligence

What enforces business rules vital to an organization's success and often require more insight and knowledge than relational integrity constraints?

Business-critical integrity constraints

__________ analysis is the process of organizing data into categories or groups for its most effective and efficient use.

Classification

_______ analysis is a technique used to divide information sets into mutually exclusive groups such that the members of each group are as close together as possible to one another and the different groups are as far apart as possible.

Cluster

What is a technique used to divide information sets into mutually exclusive groups such that the members of each group are as close together as possible to one another and the different groups are as far apart as possible?

Cluster Analysis

Integrity __________ are rules that help ensure the quality of information.

Constraints

Who is the person responsible for updating and maintaining website content?

Content editor

Select the four functions that a database management system can perform on data in a database?

Create data Read data Update data Delete data

What is the collection of data from various sources for the purpose of data processing?

Data Aggregation

What uses a variety of techniques to find patterns and relationships in large volumes of information that predict future behavior and guide decision making?

Data Mining tool

What refers to the overall management of the availability, usability, integrity, and security of company data?

Data governance

What contains a subset of data warehouse information?

Data mart

What is a logical collection of information, gathered from many different operational databases, that supports business analysis activities and decision-making tasks?

Data warehouse

What creates, reads, updates, and deletes data in a database while controlling access and security?

Database managment System

Estimation analysis

Determines values for an unknown continuous variable behavior or estimated future value.

Variety

Different forms of structured and unstructured data

__________ computing processes and manages algorithms across many machines in a computing environment.

Distributed

What is an area of a website that stores information about products in a database?

Dynamic catalog

What is stored in a dynamic catalog, or an area of a website that stores information about products in a database?

Dynamic website information

Select the three advantages of a data-driven website.

Easy to manage content Easy to eliminate human errors Easy to store large amounts of data

What stores information about a person, place, thing, transaction, or event?

Entity

Inconsistent Data Definitions

Every department had its own method for recording data so when trying to share information, data did not match and users did not get the data they really needed.

___________, transformation, and loading is a process that extracts information from internal and external databases, transforms it using a common set of enterprise definitions, and loads it into a data warehouse.

Extraction

What is a process that extracts information from internal and external databases, transforms it using a common set of enterprise definitions, and loads it into a data warehouse?

Extraction, transformation, and loading

What is a primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables?

Foreign key

What is a broad administrative area that deals with identifying individuals in a system (such as a country, a network, or an enterprise) and controlling their access to resources within that system by associating user rights and restrictions with the established identity?

INformation Management

___________ management is a broad administrative area that deals with identifying individuals in a system (such as a country, a network, or an enterprise) and controlling their access to resources within that system by associating user rights and restrictions with the established identity.

Identity

Select the three accurate statements reflecting the business advantages of a relational database.

Increased information integrity Reduced information redundancy Increased information security

Select two terms that describe the process for weeding out, fixing, or discarding inconsistent, incorrect, or incomplete information.

Information Cleansing Information Scrubbing

What is a measure of the quality of information?

Information integrity

What are rules that help ensure the quality of information?

Integrity constraints

What connects a group of computers in close proximity, such as in an office building, school, or home?

Local Arena Network

Select the three network categories.

MAN LAN WAN

Lack of Data Standards

Managers need to perform cross-functional analysis using data from all departments, which differed in granularities, formats, and levels.

_________ data management is the practice of gathering data and ensuring that it is uniform, accurate, consistent, and complete, including such entities as customers, suppliers, products, sales, employees, and other critical entities that are commonly integrated across organizational system.

Master

What is the practice of gathering data and ensuring that it is uniform, accurate, consistent, and complete, including such entities as customers, suppliers, products, sales, employees, and other critical entities that are commonly integrated across organizational system?

Master Data Managment

What is a large computer network usually spanning a city?

Metropolitan area network

Ineffective Direct Data Access

Most data stored in operational databases did not allow users direct access; users had to wait to have their queries or questions answered by MIS professionals who could code SQL.

What are private companies that own and maintain the worldwide backbone that supports the Internet?

National Service Provider

Select the five primary networking elements.

Network protocols Network providers Network convergence Network access technologies Network categories

What is a field that uniquely identifies a given record in a table?

Primary key

Which tool helps users graphically design the answer to a question against a database?

Query-by-example

What is a collection of related data elements?

Records

__________ integrity constraints are rules that enforce basic and fundamental information-based constraints.

Relational

Which system allows users to create, read, update, and delete data in a relational database?

Relational database management system

What are rules that enforce basic and fundamental information-based constraints?

Relational integrity constraints

What receives and repeats a signal to extend its attenuation or range?

Repeater

Data ______ is the process of sharing information to ensure consistency between multiple data sources.

Replication

A(n) __________ is a central location in which data is stored.

Repository

Affinity grouping analysis

Reveals the relationship between variables along with the nature and frequency of the relationships

Data _______ is responsible for ensuring the policies and procedures are implemented across the organization and acts as a liaison between the MIS department and the business.

Steward

Velocity

The analysis of streaming data as it travels around the Internet

Poor Data Quality

The data, if available, were often incorrect or incomplete. Therefore, users could not rely on the data to make decisions.

Classification analysis

The process of organizing data into categories or groups for its most effective and efficient use.

Volume

The scale of data

Veracity

The uncertainty of data, including biases, noise, and abnormalities

Select all that apply Select the four primary reasons low-quality information occurs in a system.

Third-party and external information contains inconsistencies and errors. Different systems have different information entry standards and formats. Data-entry personnel enter abbreviated information to save time. Online customers intentionally enter inaccurate information to protect their privacy.

Inadequate Data Usefulness

Users could not get the data they needed; what was collected was not always useful for intended purposes.

Data _______ includes the tests and evaluations used to determine compliance with data governance polices to ensure correctness of data.

Validation

Why does a database offer increased information security?

Various security features of databases ensure that individuals have only certain types of access to certain types of information.

incorrect What is the creation of a virtual (rather than actual) version of computing resources, such as an operating system, a server, a storage device, or network resources?

Virulaization

A data ________ is a logical collection of information, gathered from many different operational databases, that supports business analysis activities and decision-making tasks.

Warehouse

Select the statement below that accurately reflects a database.

While a database has only one physical view, it can easily support multiple logical views that provides for flexibility.

A(n) ____ area network spans a large geographic area such as a state, province, or country.

Wide

What spans a large geographic area such as a state, province, or country?

Wide area network

What is the process of identifying rare or unexpected items or events in a data set that do not conform to other items in the data set?

anomaly detection

A(n) _________ rule defines how a company performs certain aspects of its business and typically results in either a yes/no or true/false answer.

business

What is the process of organizing data into categories or groups for its most effective and efficient use?

classification analysis

What is the common term for the representation of multidimensional information?

cube

A(n) ___________ (one word) -driven website is an interactive website kept constantly updated and relevant to the needs of its customers using a database.

data

What is a storage repository that holds a vast amount of raw data in its original format until the business needs it?

data lake

What is a technique for establishing a match, or balance, between the source data and the target data warehouse?

data map

The analysis of streaming data as it travels around the Internet

data mining

Who is responsible for ensuring the policies and procedures are implemented across the organization and acts as a liaison between the MIS department and the business?

data steward

What is the management and oversight of an organization's data assets to help provide business users with high-quality data that is easily accessible in a consistent manner?

data stewardship

What is an approach to business governance that values decisions that can be backed up with verifiable data?

data-driven decision management

Data-driven _______ management is an approach to business governance that values decisions that can be backed up with verifiable data.

decision

What processes and manages algorithms across many machines in a computing environment?

distributed computing

Select the statement that accurately defines the relationship between entities and attributes in a relational database.

each attribute of an entity occupies a separate column of a table.

A(n) ____ key is a primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables.

foreign

A data ______ analysis occurs when a company examines its data to determine if it can meet business expectations, while identifying possible data gaps or where missing data might exist.

gap

A(n) ___ area network connects a group of computers in close proximity, such as in an office building, school, or home.

local

A(n) __ area network is a large computer network usually spanning a city.

metropolitan

One primary goal of a database is to eliminate information redundancy by recording each piece of information in _______ place(s) in the database.

only one

The ____________ view of information deals with the physical storage of information on a storage device.

physical

Data ________ is the process of collecting statistics and information about data in an existing source.

profiling

A(n) __________ receives and repeats a signal to extend its attenuation or range.

repeater

Data ______ is the process of sharing information to ensure consistency between multiple data sources.

replication

What identifies the primary location where data is collected?

source data