Font size
WorksheetsCS0005 - Types of Data Warehouse Schema
Total questions: 10
Worksheet time: 6mins
In a data warehouse schema, the aggregates of the associated data is included in its database. True or False.
True
False
The ____ is the simplest type of data warehouse schema.
star
snowflake
galaxy
sun
f
In which data warehouse schema is the tables normalized?
metro
star
snowflake
A (a) table in a data warehouse system is the table that contains all the facts of business information.
What is a table that collects the reference information about the measurable in the fact table?
Dimension
Corners
Fact Table
Schema
Which among the statements best describes a star schema?
The dimension tables are nomalized
It has multiple levels with multiple hierarchies
The dimension tables are not normalized
This schema is helpful for aggregating fact tables for better understanding
He is a data warehouse guru that proposes to use snowflake in financial product dimensions.
Ralph Lauren
Ralph Kimball
Bob Kimball
Kimball Tommy
Which among the following is the first step in designing the star schema?
List of attributes or column in each dimension table
Identify the Dimension table related to fact table.
Find the lowest level of aggregation or summary analysis in the fact table.
Identify business process
The _______ ______ ______ is also called Galaxy Schema.
Star Bright Schema
Fact Constellation Schema
Milky Way Schema
Dimension driven Schema
Which among the following is NOT a data warehouse schema?
Star
Snow white
Snowflake
Galaxy
