1. What is Star schema ? Junior A. the relationship classification describing how many matching rows exist on each side, such as one-to-many or many-to-many B. the relationship setting controlling whether filters flow one way or both ways across a join C. a modeling layout with a central numeric table surrounded by descriptive lookup tables joined by keys D. a lookup table of descriptive attributes such as product, customer, or date used to slice and group values
2. Which term means: "a modeling layout with a central numeric table surrounded by descriptive lookup tables joined by keys"? Junior A. Cross-filter direction B. Fact table C. Snowflake schema D. Star schema
3. Which statement is correct? Junior A. Star schema — the relationship setting controlling whether filters flow one way or both ways across a join B. Star schema — a layout where dimension tables are split into further related sub-tables, normalizing them across multiple linked levels C. Star schema — a modeling layout with a central numeric table surrounded by descriptive lookup tables joined by keys D. Star schema — the relationship classification describing how many matching rows exist on each side, such as one-to-many or many-to-many
4. What is Fact table ? Junior A. a modeling layout with a central numeric table surrounded by descriptive lookup tables joined by keys B. the relationship classification describing how many matching rows exist on each side, such as one-to-many or many-to-many C. the central table holding measurable numeric events and the foreign keys linking to descriptive context D. a lookup table of descriptive attributes such as product, customer, or date used to slice and group values
5. Which term means: "the central table holding measurable numeric events and the foreign keys linking to descriptive context"? Junior A. Fact table B. Cardinality C. Cross-filter direction D. Star schema
6. Which statement is correct? Junior A. Fact table — a modeling layout with a central numeric table surrounded by descriptive lookup tables joined by keys B. Fact table — a layout where dimension tables are split into further related sub-tables, normalizing them across multiple linked levels C. Fact table — the central table holding measurable numeric events and the foreign keys linking to descriptive context D. Fact table — a lookup table of descriptive attributes such as product, customer, or date used to slice and group values
7. What is Dimension table ? Junior A. a lookup table of descriptive attributes such as product, customer, or date used to slice and group values B. the relationship setting controlling whether filters flow one way or both ways across a join C. a modeling layout with a central numeric table surrounded by descriptive lookup tables joined by keys D. the relationship classification describing how many matching rows exist on each side, such as one-to-many or many-to-many
8. Which term means: "a lookup table of descriptive attributes such as product, customer, or date used to slice and group values"? Junior A. Star schema B. Fact table C. Dimension table D. Cardinality
9. Which statement is correct? Junior A. Dimension table — the central table holding measurable numeric events and the foreign keys linking to descriptive context B. Dimension table — the relationship classification describing how many matching rows exist on each side, such as one-to-many or many-to-many C. Dimension table — a lookup table of descriptive attributes such as product, customer, or date used to slice and group values D. Dimension table — a modeling layout with a central numeric table surrounded by descriptive lookup tables joined by keys
10. What is Cardinality ? Mid A. the relationship classification describing how many matching rows exist on each side, such as one-to-many or many-to-many B. the relationship setting controlling whether filters flow one way or both ways across a join C. a modeling layout with a central numeric table surrounded by descriptive lookup tables joined by keys D. a layout where dimension tables are split into further related sub-tables, normalizing them across multiple linked levels
11. Which term means: "the relationship classification describing how many matching rows exist on each side, such as one-to-many or many-to-many"? Mid A. Fact table B. Star schema C. Snowflake schema D. Cardinality
12. Which statement is correct? Mid A. Cardinality — the relationship classification describing how many matching rows exist on each side, such as one-to-many or many-to-many B. Cardinality — a layout where dimension tables are split into further related sub-tables, normalizing them across multiple linked levels C. Cardinality — the relationship setting controlling whether filters flow one way or both ways across a join D. Cardinality — a lookup table of descriptive attributes such as product, customer, or date used to slice and group values
13. What is Cross-filter direction ? Mid A. a lookup table of descriptive attributes such as product, customer, or date used to slice and group values B. the central table holding measurable numeric events and the foreign keys linking to descriptive context C. a layout where dimension tables are split into further related sub-tables, normalizing them across multiple linked levels D. the relationship setting controlling whether filters flow one way or both ways across a join
14. Which term means: "the relationship setting controlling whether filters flow one way or both ways across a join"? Mid A. Dimension table B. Snowflake schema C. Cardinality D. Cross-filter direction
15. Which statement is correct? Mid A. Cross-filter direction — a layout where dimension tables are split into further related sub-tables, normalizing them across multiple linked levels B. Cross-filter direction — a lookup table of descriptive attributes such as product, customer, or date used to slice and group values C. Cross-filter direction — the relationship setting controlling whether filters flow one way or both ways across a join D. Cross-filter direction — the relationship classification describing how many matching rows exist on each side, such as one-to-many or many-to-many
16. What is Snowflake schema ? Senior A. the relationship classification describing how many matching rows exist on each side, such as one-to-many or many-to-many B. a modeling layout with a central numeric table surrounded by descriptive lookup tables joined by keys C. the central table holding measurable numeric events and the foreign keys linking to descriptive context D. a layout where dimension tables are split into further related sub-tables, normalizing them across multiple linked levels
17. Which term means: "a layout where dimension tables are split into further related sub-tables, normalizing them across multiple linked levels"? Senior A. Snowflake schema B. Dimension table C. Cross-filter direction D. Star schema
18. Which statement is correct? Senior A. Snowflake schema — the central table holding measurable numeric events and the foreign keys linking to descriptive context B. Snowflake schema — a layout where dimension tables are split into further related sub-tables, normalizing them across multiple linked levels C. Snowflake schema — the relationship setting controlling whether filters flow one way or both ways across a join D. Snowflake schema — the relationship classification describing how many matching rows exist on each side, such as one-to-many or many-to-many