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