MISY 5360 - BI Midterm Exam Questions
and Answers (Latest 2026)
Operational or transaction databases are product oriented,
handling transactions that update the database. In contrast,
data warehouses are:
A. subject-oriented and nonvolatile.
B. product-oriented and nonvolatile.
C. product-oriented and volatile.
D. subject-oriented and volatile. - Correct Answers ✅A.
subject-oriented and nonvolatile.
A Web client that connects to a Web server, which is in turn
connected to a BI application server, is reflective of a:
A. one-tier architecture.
B. two-tier architecture.
C. three-tier architecture.
D. four-tier architecture. - Correct Answers ✅C. three-tier
architecture.
Which of the following BEST enables a data warehouse to
handle complex queries and scale up to handle many more
requests?:
A. use of the Web by users as a front-end
B. parallel processing
,MISY 5360 - BI Midterm Exam Questions
and Answers (Latest 2026)
C. Microsoft Windows
D. a larger IT staff - Correct Answers ✅B. parallel
processing
In which stage of extraction, transformation, and load (ETL)
into a data warehouse are anomalies detected and corrected?
A. transformation
B. extraction
C. load
D. cleanse - Correct Answers ✅D. cleanse
All of the following are benefits of hosted data warehouses
EXCEPT
A. smaller upfront investment.
B. better quality hardware.
C. greater control of data.
D. frees up in-house systems. - Correct Answers ✅C.
greater control of data.
When representing data in a data warehouse, using several
dimension tables that are each connected only to a fact table
means you are using which warehouse structure?
, MISY 5360 - BI Midterm Exam Questions
and Answers (Latest 2026)
A. star schema
B. snowflake schema
C. relational schema
D. dimensional schema - Correct Answers ✅A. star schema
When querying a dimensional database, a user went from
summarized data to its underlying details. The function that
served this purpose is
A) slice.
B) dice.
C) drill down.
D) roll-up. - Correct Answers ✅C. drill down
A large storage location that can hold vast quantities of data
(mostly unstructured) in its native/raw format for
future/potential analytics consumption is referred to as a(n)
A. extended ASP
B. data cloud
C. data lake
D. relational database - Correct Answers ✅C. data lake
and Answers (Latest 2026)
Operational or transaction databases are product oriented,
handling transactions that update the database. In contrast,
data warehouses are:
A. subject-oriented and nonvolatile.
B. product-oriented and nonvolatile.
C. product-oriented and volatile.
D. subject-oriented and volatile. - Correct Answers ✅A.
subject-oriented and nonvolatile.
A Web client that connects to a Web server, which is in turn
connected to a BI application server, is reflective of a:
A. one-tier architecture.
B. two-tier architecture.
C. three-tier architecture.
D. four-tier architecture. - Correct Answers ✅C. three-tier
architecture.
Which of the following BEST enables a data warehouse to
handle complex queries and scale up to handle many more
requests?:
A. use of the Web by users as a front-end
B. parallel processing
,MISY 5360 - BI Midterm Exam Questions
and Answers (Latest 2026)
C. Microsoft Windows
D. a larger IT staff - Correct Answers ✅B. parallel
processing
In which stage of extraction, transformation, and load (ETL)
into a data warehouse are anomalies detected and corrected?
A. transformation
B. extraction
C. load
D. cleanse - Correct Answers ✅D. cleanse
All of the following are benefits of hosted data warehouses
EXCEPT
A. smaller upfront investment.
B. better quality hardware.
C. greater control of data.
D. frees up in-house systems. - Correct Answers ✅C.
greater control of data.
When representing data in a data warehouse, using several
dimension tables that are each connected only to a fact table
means you are using which warehouse structure?
, MISY 5360 - BI Midterm Exam Questions
and Answers (Latest 2026)
A. star schema
B. snowflake schema
C. relational schema
D. dimensional schema - Correct Answers ✅A. star schema
When querying a dimensional database, a user went from
summarized data to its underlying details. The function that
served this purpose is
A) slice.
B) dice.
C) drill down.
D) roll-up. - Correct Answers ✅C. drill down
A large storage location that can hold vast quantities of data
(mostly unstructured) in its native/raw format for
future/potential analytics consumption is referred to as a(n)
A. extended ASP
B. data cloud
C. data lake
D. relational database - Correct Answers ✅C. data lake
