Question 1

________, or "The Extended ASP Model," is a creative way of deploying information system applications where the provider licenses its applications to customers for use as a service on demand (usually over the Internet)

Accepted Answer

The answer of ________, or "The Extended ASP Model," is...

Question 2

Most data warehouses are built using ________ database management systems to control and manage the data.

Accepted Answer

The answer of Most data warehouses are built using ________...

Question 3

________ is a mechanism for pulling data from source systems to satisfy a request for information. It is an evolving tool space that promises real-time data integration from a variety of sources, such as relational databases, Web services, and multidimensional databases.

Accepted Answer

The answer of ________ is a mechanism for pulling data...

Question 4

Data ________ comprises data access, data federation, and change capture.

Accepted Answer

The answer of Data ________ comprises data access, data federation,...

Question 5

________ (also called in-database analytics) refers to the integration of the algorithmic extent of data analytics into data warehouse.

Accepted Answer

The answer of ________ (also called in-database analytics) refers to...

Question 6

In the Michigan State Agencies case, the approach used was a(n) ________ one, instead of developing separate BI/DW platforms for each business area or state agency.

Accepted Answer

The answer of In the Michigan State Agencies case, the...

Question 7

With ________ data flows, managers can view the current state of their businesses and quickly identify problems.

Accepted Answer

The answer of With ________ data flows, managers can view...

Question 8

Performing extensive ________ to move data to the data warehouse may be a sign of poorly managed data and a fundamental lack of a coherent data management strategy.

Accepted Answer

The answer of Performing extensive ________ to move data to...

Question 9

Online ________ is arguably the most commonly used data analysis technique in data warehouses.

Accepted Answer

The answer of Online ________ is arguably the most commonly...

Question 10

________ describe the structure and meaning of the data, contributing to their effective use.

Accepted Answer

The answer of ________ describe the structure and meaning of...

Question 11

The role responsible for successful administration and management of a data warehouse is the ________, who should be familiar with high-performance software, hardware, and networking technologies, and also possesses solid business insight.

Accepted Answer

The answer of The role responsible for successful administration and...

Question 12

________ modeling is a retrieval-based system that supports high-volume query access.

Accepted Answer

The answer of ________ modeling is a retrieval-based system that...

Question 13

The ________ Model, also known as the data mart approach, is a "plan big, build small" approach. A data mart is a subject-oriented or department-oriented data warehouse. It is a scaled-down version of a data warehouse that focuses on the requests of a specific department, such as marketing or sales.

Accepted Answer

The answer of The ________ Model, also known as the...

Question 14

The ________ Model, also known as the EDW approach, emphasizes top-down development, employing established database development methodologies and tools, such as entity-relationship diagrams (ERD), and an adjustment of the spiral development approach.

Accepted Answer

The answer of The ________ Model, also known as the...

Question 15

________ is a mechanism that integrates application functionality and shares functionality (rather than data) across systems, thereby enabling flexibility and reuse.

Accepted Answer

The answer of ________ is a mechanism that integrates application...

Question 16

In ________ oriented data warehousing, operational databases are tuned to handle transactions that update the database.

Accepted Answer

The answer of In ________ oriented data warehousing, operational databases...

Question 17

The ________ data warehouse architecture involves integrating disparate systems and analytical resources from multiple sources to meet changing needs or business conditions.

Accepted Answer

The answer of The ________ data warehouse architecture involves integrating...

Question 18

The three main types of data warehouses are data marts, operational ________, and enterprise data warehouses.

Accepted Answer

The answer of The three main types of data warehouses...

Question 19

A(n) ________ architecture is used to build a scalable and maintainable infrastructure that includes a centralized data warehouse and several dependent data marts.

Accepted Answer

The answer of A(n) ________ architecture is used to build...

Question 20

Online ________ is a term used for a transaction system that is primarily responsible for capturing and storing data related to day-to-day business functions such as ERP, CRM, SCM, and point of sale.

Accepted Answer

The answer of Online ________ is a term used for...

Quiz 3: Data Warehousing