Information Analytics Chapter 2

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? snowflake schema dimensional schema relational schema star schema

star schema

Operational or transaction databases are product oriented, handling transactions that update the database. In contrast, data warehouses are subject-oriented and nonvolatile. product-oriented and nonvolatile. product-oriented and volatile. subject-oriented and volatile.

subject-oriented and nonvolatile.

Supply each of the words for letters in the acronym BI in the correct blank. Answer for blank # 1: Business Answer for blank # 2: intelligence

Business intelligence

Data warehouses are subsets of data marts. True False

False

Large companies, especially those with revenue upwards of $500 million consistently reap substantial cost savings through the use of hosted data warehouses. True False

False

Moving the data into a data warehouse is usually the easiest part of its creation. True False

False

Subject oriented databases for data warehousing are organized by detailed subjects such as disk drives, computers, and networks. True False

False

The ETL process in data warehousing usually takes up a small portion of the time in a data-centric project. True False

False

Match the following OLAP operations with their definition __1__ Subset of a multidimensional array (usually a 2D representation) corresponding to a single value set for one (or more) of the dimensions in the subset. __2__ A slice on more than two dimensions of a data cube. __4__ Computing all of the data relationships for one or more dimensions. __3__ Technique where user navigates among levels of data ranging from the most summarized to the most detailed. __5__ Changes the dimensional orientation of a report or ad-hoc query page display. 1.Slice 2.Dice 3.Drill Down/Up 4.Roll-up 5.Pivot

Subset of a multidimensional array (usually a 2D representation) corresponding to a single value set for one (or more) of the dimensions in the subset. == Slice A slice on more than two dimensions of a data cube. == Dice Computing all of the data relationships for one or more dimensions. == Roll-up Technique where user navigates among levels of data ranging from the most summarized to the most detailed. == Drill Down/UP Changes the dimensional orientation of a report or ad-hoc query page display == Pivot

What does the second S in DSS stand for? Support Sales Supply Science

Support

which of the following is NOT a data warehouse development approach? The Booch Model The Kimball Model The Inmon Model

The Booch Model

Real-time data warehousing, active data warehousing, and zero latency data warehousing are all terms used to describe the process of loading and providing data via the data warehouse as soon as they become available. for many businesses, making fast and consistent decisions across the enterprise requires faster access than a traditional data warehouse. Correct Answer True Incorrect Response False

True

Without middleware, different BI programs cannot easily connect to the data warehouse. True False

True

The "single version of the truth" embodied in a data warehouse such as Capri Casinos' means all of the following EXCEPT decision makers get to see the same results to queries. decision makers have unfettered access to all data in the warehouse. decision makers have the same data available to support their decisions. decision makers get to use more dependable data for their decisions.

decision makers have unfettered access to all data in the warehouse.