MIS 245 — Data, Data Warehousing & Business Intelligence Exam Questions with Correct
Answers Already Passed
Data - Answers Raw facts (numbers, text, symbols)
Information - Answers Data given meaning and context
Repository - Answers Central location where data is stored and managed
Dirty data - Answers Erroneous, flawed, inaccurate, misleading, duplicate, nonformatted, or rule-
violating data
Dirty data can be completely eliminated - Answers False
Dirty data is a ___ problem - Answers Business problem (not just MIS)
Data set - Answers Organized collection of data
Data point - Answers Individual item on a graph or chart
Source data - Answers Primary location where data is collected
Data aggregation - Answers Collecting data from multiple sources for processing
Data map - Answers Matches source data to target data warehouse
Information cleansing (scrubbing) - Answers Fixing or removing inaccurate, incomplete,
redundant, or missing data
Data warehouse - Answers Logical collection of information from many operational databases
that supports analytical processing and decision making
Primary purpose of a data warehouse - Answers Analytical processing (not transactional)
Data warehouse supports - Answers OLAP and analytical processing
Internal databases - Answers Marketing, sales, inventory, billing
External databases - Answers Competitor info, industry data, mailing lists, stock market data
Ultimate outcome of a data warehouse - Answers Data marts
Data mart - Answers Subset of data warehouse data with functional focus
Data warehouse scope - Answers Organization-wide
Data mart scope - Answers Department or functional area
ETL - Answers Extraction, Transformation, Loading
Answers Already Passed
Data - Answers Raw facts (numbers, text, symbols)
Information - Answers Data given meaning and context
Repository - Answers Central location where data is stored and managed
Dirty data - Answers Erroneous, flawed, inaccurate, misleading, duplicate, nonformatted, or rule-
violating data
Dirty data can be completely eliminated - Answers False
Dirty data is a ___ problem - Answers Business problem (not just MIS)
Data set - Answers Organized collection of data
Data point - Answers Individual item on a graph or chart
Source data - Answers Primary location where data is collected
Data aggregation - Answers Collecting data from multiple sources for processing
Data map - Answers Matches source data to target data warehouse
Information cleansing (scrubbing) - Answers Fixing or removing inaccurate, incomplete,
redundant, or missing data
Data warehouse - Answers Logical collection of information from many operational databases
that supports analytical processing and decision making
Primary purpose of a data warehouse - Answers Analytical processing (not transactional)
Data warehouse supports - Answers OLAP and analytical processing
Internal databases - Answers Marketing, sales, inventory, billing
External databases - Answers Competitor info, industry data, mailing lists, stock market data
Ultimate outcome of a data warehouse - Answers Data marts
Data mart - Answers Subset of data warehouse data with functional focus
Data warehouse scope - Answers Organization-wide
Data mart scope - Answers Department or functional area
ETL - Answers Extraction, Transformation, Loading
