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

ANSWER: C) Fact Constellation Schema




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

ANSWER: C) Both A & B




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

ANSWER: B) Dimension definition




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

ANSWER: D) All mentioned above




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

ANSWER: A) One




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

ANSWER: A) True




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

ANSWER: A) Yes




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

ANSWER: A) Schema Definition




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

ANSWER: B) False




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

ANSWER: D) All mentioned above




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

ANSWER: A) True




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

ANSWER: B) False




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

ANSWER: A) DMQL




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

ANSWER: A) True




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

ANSWER: A) Yes




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

ANSWER: D) All mentioned above




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

ANSWER: C) Both A & B




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

ANSWER: A) Master Data Services




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

ANSWER: A) True




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

ANSWER: A) Yes


Post your comment