CIS 3380 Exam Three - Chapters 6, 7, & 8

**End of Chapter Eight**

**End of Chapter Eight**

**End of Chapter Seven**

**End of Chapter Seven**

**End of Chapter Six**

**End of Chapter Six**

**Start of Chapter Eight**

**Start of Chapter Eight**

**Start of Chapter Seven**

**Start of Chapter Seven**

**Start of Chapter Six**

**Start of Chapter Six**

A(n) _____________________ reveals the relationship between variables along with the nature and frequency of the relationships.

Affinity grouping analysis

What reveals the relationship between variables along with the nature and frequency of the relationships?

Affinity grouping analysis.

What are mathematical formulas placed in software that performs an analysis on a data set?

Algorithms.

What is a data value that is numerically distant from most of the other data points in a set of data?

An outlier.

_____________________ information encompasses all organizational information, and its primary purpose is to support the performance of managerial analysis or semi-structured decisions.

Analytical

_____________________ encompasses all organizational information, and its primary purpose is to support the performing of managerial analysis task.

Analytical information

What are the elements associated with an entity?

Attributes

_____________________ 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 occurs when a company keeps tabs of its competitor's activities on the web using software that automatically tracks all competitor website activities such as discounts and new products?

Competitive monitoring.

Who is the person responsible for creating the original website content?

Content creator.

What compiles all of the metadata about the data elements in the data model?

Data dictionary

Select a term that is a synonym for data element, the smallest or basic unit of information in a database.

Data field

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 warehouse?

Data map.

What contains a subset of data warehouse information?

Data mart.

What is the process of collecting statistics and information about data in an existing source?

Data profiling.

Select the statement that accurately describes a situation in which there is too much data to properly understand or make use of it.

Data rich and information poor.

Who extracts knowledge from data by performing statistical analysis, data mining, and advanced analytics on big data to identify trends, market changes, and other relevant information?

Data scientist.

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

Data stewardship

What moves beyond Excel graphs and charts into sophisticated analysis techniques such as pie charts, controls, instruments, maps, time-series graphs, and more?

Data visualization tools.

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

Data-driven decision management.

Information granularities include...

Detail, summary, aggregate.

_____________________ data is erroneous or flawed data.

Dirty

Information formats include...

Documents, presentations, spreadsheets, databases.

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

Dynamic catalog

What includes data that change based on user actions?

Dynamic information

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

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

Select the three advantages of a data-driven website.

Easy to manage content: Website owners can make changes without relying on MIS professionals; users can update a data-driven website with little or no training. Easy to store large amounts of data: Data-driven websites can keep large volumes of information organized. Website owners can use templates to implement changes for layouts, navigation, or website structure. This improves website reliability, scalability, and performance. Easy to eliminate human errors: Data-driven websites trap data-entry errors, eliminating inconsistencies while ensuring all information is entered correctly.

Select the term that refers to storing information about a person, place, thing, transaction, or event.

Entity

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

Entity

_____________________, 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

Information in an organization exists only in a few departments, such as sales and marketing.

False.

_____________________ data is the application of big data analytics to smaller data sets in near-real or real-time in order to solve a problem or create business value.

Fast

Select three examples of analytical information.

Future growth projections Market projections Sales trends

_____________________ 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 Increased information security Reduced information reduncancy

Information levels include...

Individual, department, enterprise.

What presents the results of data analysis, displaying the patterns, relationships, and trends in a graphical format?

Infographics.

What occurs when the same data element has different values?

Information Inconsistency

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

Information cleansing or scrubbing.

Select the four primary traits of the value of information.

Information governance Information quality Information timeliness Information type

What refers to the extent of detail within information?

Information granularity.

What occurs when a system produces incorrect, inconsistent, or duplicate data?

Information integrity issues.

_____________________ allow separate systems to communicate directly with each other, eliminating the need for manual entry into multiple systems.

Integrations

What focuses on how individual users logically access information to meet their own particular business needs?

Logical view of information.

_____________________ 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

_____________________ provides details about data.

Metadata

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

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

Chooses reasons that make business analysis difficult from operational databases.

Operational information that is available is incomplete. Operational information lacks data standards. Operational information is typically current.

Select all the activities for which transactional information is create.

Purchasing stocks Withdrawing cash from an ATM Making airline reservations

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

Read data Delete data Create data Update data

What means immediate, up-to-date information?

Real-time information.

_____________________ 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 stores information in the form of logically related two-dimensional tables?

Relational database model.

_____________________ data identifies the primary location where data is collected.

Source

_____________________ information includes fixed data incapable of change in the event of a user action.

Static

Real-time _____________________ provide Real-time information in response to requests.

Systems

_____________________ data encompasses all raw facts contained within a single process and its purpose is to support daily operational tasks.

Transactional

_____________________ encompasses all of the information contained within a single business process or unit of work, and its primary purpose is to support the performing of daily operational tasks.

Transactional information

True or false: Business-critical integrity constraints tend to mirror the very rules by which an organization achieves success.

True.

True or false: Databases today scale to exceptional levels, allowing all types of users and programs to perform information processing and information-searching tasks.

True.

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.

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.

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

aggregation

A data _____________________ is a business analytics specialist who uses visual tools to help people understand complex data.

artist

A(n) _____________________ integration takes information entered into a given system and sends it automatically to all upstream systems and processes.

backward

A data _____________________ is a business that collects personal information about consumers and sells that information to other organizations.

broker

The problem of being data rich and information poor results from an inability to turn business data into _____________________.

business intelligence

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

classification analysis

A(n) _____________________ is 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.

cluster analysis

A(n) _____________________ analysis can compare two or more data sets to identify patterns and trends.

comparative

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

constraints

A(n) _____________________ is the common term for the representation of multidimensional information.

cube

Business intelligence _____________________ track corporate metrics such as critical success factors and key performance indicators and include advanced capabilities such as interactive controls allowing users to manipulate data for analysis.

dashboards

A _____________________-driven website is an interactive website kept constantly updated and relevant to the needs of its customers using a database.

data

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 includes the tests and evaluations used to determine compliance with data governance polices to ensure correctness of data?

data validation

A(n) _____________________ maintains information about various types of objects (inventory), events (transactions), people (employees), and places (warehouses).

database

Anomaly _____________________ 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.

detection

A content _____________________ is the person responsible for updating and maintaining website content.

editor

A(n)_____________________ determines values for an unknown continuous variable behavior or estimated future value.

estimation analysis

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(n) _____________________ integration takes information entered into a given system and sends it automatically to all downstream systems and processes.

forward

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

Data _____________________ refers to the overall management of the availability, usability, integrity, and security of company data.

governance

Information _____________________ is a measure of the quality of information.

integrity

Data _____________________ is the time it takes for data to be stored or retrieved.

latency

Data _____________________

mining

Data _____________________ are logical data structures that detail the relationships among data elements using graphics or pictures.

models

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

A data _____________________ is an individual item on a graph or a chart.

point

A(n) _____________________ is a statement about what will happen or might happen in the future.

prediction

A(n) _____________________ key is a field (or group of fields) that uniquely identifies a given record in a table.

primary

A(n) _____________________-by-example tool helps users graphically desing the answer to a question against a database.

query

A(n) _____________________ is a collection of related data elements.

record

Information _____________________ is the duplication of data, or the storage of the same data in multiple places.

redundancy

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

repository

A data _____________________ is an organized collection of data.

set

A(n) _____________________ query language asks users to write lines of code to answer questions against a database.

structured

Data _____________________ describes technologies that allow users to "see" or visualize data to transform information into a business perspective.

visualization

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

warehouse