CIS 323 Exam 3

Sarbane Oxley

privacy again financial records

Extensible Markup Language (XML) is:

A scripting language that allows the creation of customized tags to enable easier sharing of data across organizations

Controls designed to restrict access and activities are called:

Authorization Rules

The level of detail in a fact table determined by the intersection of all the components of the primary key, including all foreign keys and any other primary key elements, is called the:

Grain

Data governance can be defined as:

High-level organizational groups and processes that oversee data stewardship

The Unified Modeling Language (UML):

Is a notation useful for graphically depicting an object-oriented analysis or design model.

The NoSQL model that includes a simple pair of a key and an associated collection of values is called a:

Key-value score

Big Data includes:

Large volumes of data with many different data types that are processed at very high speeds.

A class of database technology used to store textual and other unstructured data is called:

NoSQL

The use of a set of graphical tools that provides users with multidimensional views of their data is called

On-line analytical processing (OLAP)

In the ________ approach, one consolidated record is maintained and all applications draw on that one actual "golden" record.

Persistent

Descriptive, predictive, and ________ are the three main types of analytics.

Prescriptive

Data that are detailed, current, and intended to be the single, authoritative source of all decision support applications are called ________ data.

Reconciled

________ is used to undo unwanted database changes.

Rollback

Which of the following characterizes homogeneous environments?

Same DBMS used at all locations

SOAP stands for

Simple Object Access Protocol Method

Hadoop/Map reduce

?

Operational and informational systems are generally separated because of which of the following factors?

A data warehouse centralizes data that are scattered throughout disparate operational systems and makes them readily available for decision support applications.

An open-source DBMS is:

A free source-code RBMS that provides the functionality of an SQL-compliant DBMS

At a basic level, analytics refers to:

Analysis and interpretation of data

Web Services

Are a set of emerging standards for protocols for automatic communication between software

Which of the following factors drive the need for data warehousing?

Businesses need an integrated view of company information.

An emerging trend likely to have an effect on the development of three-tier applications is called:

Cloud Computing

The actions that must be taken to ensure data integrity is maintained during multiple simultaneous transactions are called ________ actions

Concurrency control

Which of the following is NOT a method for storing XML documents?

Convert to text

A repository of information about a database that documents data elements of a database is called a:

Data Dictionary

When a data repository (including internal and external data) does NOT follow a predefined schema, this is called a

Data Lake

Converting data from the format of its source to the format of its destination is called

Data Transformation

Conformance means that:

Data are stored, exchanged or presented in a format that is specified by its metadata.

The role of a ________ emphasizes integration and coordination of metadata across many datasources.

Data warehouse administrator

A data mart is a(n):

Data warehouse that is limited in scope.

A computer that provides database storage and access in a client/server environment is called a(n):

Database Server

________ is a technical function responsible for database design, security, and disaster recovery

Database administration

A(n) ________ is a database stored on multiple computers in multiple locations that are NOT connected by a data communications link.

Decentralized database

________ is the technique of hiding the internal implementation details of an object from its external view

Encapsulation

A researcher trying to explain why sales of garden supplies in Hawaii have decreased would be an example of ________ data mining

Explanatory

The goal of data mining related to analyzing data for unexpected relationships is:

Exploratory

A client PC that is responsible for processing presentation logic, extensive application and business rules logic as well as many DBMS functions is called a(n)

Fat Client

Event-drive propagation:

Pushes data to duplicate sites as an event occurs

A PC configured to handle user interface with little or no local storage is called a:

Thin Client

Data in the data warehouse contain a time dimension so that they may be used to study trends and changes.

Time-Varient

One characteristic of quality data which pertains to the expectation for the time between when data are expected and when they are available for use is:

Timeliness

TQM stands for

Total Quality Management.

A discrete unit of work that must be processed completely or not at all within a computer system is called a

Transaction

User interaction integration is achieved by creating fewer ________ that feed different systems

User Interfaces

fact tables > impact of grain and duration

Transactional grain-finest level Aggregated grain-more summarized Finer grains better market basket analysis capability Finer grain more dimension tables, more rows in fact table In Web-based commerce, finest granularity is a click

Two other V's

Veracity, Value

The three 'v's commonly associated with big data include

Volume, variety, and velocity