Data warehousing Schemas

Data warehousing Schemas

1) Which is also known as galaxy schema?
A) Star Schema
B) Snow Flake Schema
C) Fact Constellation Schema
D) None of the above
View Answer / Hide Answer


2) The two primitives, cube definition and dimension definition, can be used for defining the.
A) Data warehouses
B) Data marts
C) Both A & B
D) None of the above
View Answer / Hide Answer


3) The following is syntax to define dimension __________

< dimension_name > as ( < attribute_or_dimension_list > )

A) Cube definition
B) Dimension definition
C) Both A & B
D) None of the above
View Answer / Hide Answer


4) List the Schema that a data warehouse system can implement.
A) Star schema
B) Snowflake schema
C) Fact constellation schema
D) All mentioned above
View Answer / Hide Answer


5) How many fact tables are there in a star schema?
A) One
B) Two
C) Three
D) Four
View Answer / Hide Answer


6) Snowflake schema uses the concept of normalization.
A) True
B) False
View Answer / Hide Answer


7) Normalization splits up the data into additional tables.
A) Yes
B) No
View Answer / Hide Answer


8) Data Mining Query Language (DMQL) is used for
A) Schema Definition
B) Star Schema Definition
C) Snowflake Schema Definition
D) Fact Constellation Schema Definition
View Answer / Hide Answer


9) DMQL is not based on Structured Query Language (SQL).
A) True
B) False
View Answer / Hide Answer


10) Data Warehouse OLAP is based on
A) Star Schema
B) Snowflake Schema
C) Fact Constellation Schema
D) All mentioned above
View Answer / Hide Answer


11) Data Warehouse OLAP provides summarized and multidimensional view of data.
A) True
B) False
View Answer / Hide Answer


12) Some dimension tables in the Snowflake schema are not normalized.
A) True
B) False
View Answer / Hide Answer


13) Multidimensional schema is defined using.
A) DMQL
B) SQL
C) Both A & B
D) None of the above
View Answer / Hide Answer


14) Due to normalization in the Snowflake schema, the redundancy is reduced and therefore, it becomes easy to maintain and save the storage space.
A) True
B) False
View Answer / Hide Answer


15) Is it possible to share dimension tables between fact tables.
A) Yes
B) No
View Answer / Hide Answer


16) A database uses relational model, while a data warehouse uses
A) Star
B) Snowflake
C) Fact Constellation schema
D) All mentioned above
View Answer / Hide Answer


17) Dimensional modelling is used for de-normalizing the
A) ROLAP design
B) MOLAP design
C) Both A & B
D) None of the above
View Answer / Hide Answer


18) Abbreviate the term MDS.
A) Master Data Services
B) Minor Data Services
C) Major Data Services
D) Master Data Solutions
View Answer / Hide Answer


19) Cubes are logical representation of multidimensional data.
A) True
B) False
View Answer / Hide Answer


20) OLAP is the process of analyzing the data, managing aggregations, partitioning information into cubes for in depth visualization.
A) Yes
B) No
View Answer / Hide Answer