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.
