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 a...

Question 2

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 3

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 a...

Question 4

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 5

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 approach...

Question 6

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...

Question 7

________ 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 8

________ 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 9

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

Accepted Answer

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

Question 10

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 data...

Question 11

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 12

________ 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 13

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 are...

Question 14

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 15

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 16

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 EDW...

Question 17

________ 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 18

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 the...

Question 19

________ (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 the...

Question 20

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...

Quiz 2: Data Warehousing