MIS 183 Exam 1

Which of the following advances in information systems contributed to the emergence of data warehousing?

Advances in middleware products that enabled enterprise database connectivity across heterogeneous platforms.

At a basic level, analytics refers to:

Analysis and interpretation of data

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

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

Quality data can be defined as being:

Unique

Factless fact tables may apply when:

We are deleting correlated data.

Because applications are often developed independently in file processing systems:

Unplanned duplicate data files are the rule rather than the exception

Includes NoSQL accommodation of various data types.

Variety

Generally processes the largest quantities of data.

Transaction processing

One way to improve the data capture process is to:

Check entered data immediately for quality against data in the database.

Is/are a new technology which trade(s) off storage space savings for computing time.

Column databases

The real-time data warehouse is characterized by which of the following?

Data are immediately transformed and loaded into the warehouse

All of the following are some beneficial applications for real-time data warehousing EXCEPT:

Data entry

A technique using artificial intelligence to upgrade the quality of raw data is called:

Data scrubbing

A data mart is a(n):

Data warehouse that is limited in scope

Which of the following organizational trends does not encourage the need for data warehousing?

Downsizing

Datatype conflicts is an example of a(n) reason for deteriorated data quality.

External data source

The analysis of summarized data to support decision making is called:

Informational processing

A database is an organized collection of related data:

Logically

Data that describe the properties of other data are:

Metadata

An organization that decides to adopt the most popular NoSQL database management system would select:

MongoDB

Data that are never physically altered once they are added to the store are called ______ data.

Periodic

Informational systems are designed for all of the following EXCEPT:

Running a business in real-time

Apache Cassandra is a leading producer of NoSQL database management systems.

Wide-column

The NoSQL model that incorporates 'column families' is called a:

Wide-column store

An expanded version of a star schema in which all of the tables are fully normalized is called a(n):

Snowflake schema

Is a tool even non-programmers can use to access information from a database

Structured Query Language