Data Modeling Quiz

A gym man analyzes class attendance and member engagement. Which tables would be relevant for this analysis?

• Class Dimension Table

• Instructor Dimension Table

• Promotional Package Dimension Table

• Member Dimension Table

• Class Attendance Fact Table

You have a fact table containing sales data and a dimension table for products. What kind of relationship exists between these two tables?

• One-to-One

• Recursive

• Many-to-Many

• One-to-Many

A publishing company wants to analyze book sales, author royalties, and genre performance. What tables should be included?

• Genre Dimension Table

• Sales Fact Table

• Publisher Table

• Author Dimension Table

• Royalty Payment Fact Table

If you want to include multiple product categories in your analysis, which dimension should you consider?

• Product Dimension

• Time Dimension

• Customer Dimension

• Promotion Dimension

A university wants to analyze student enrollments. Which of the following should be considered a dimension in their data model?

• Enrollment Count

• Semester

• Tuition Fees

• Course Duration

In a dimensional model, which design typically facilitates faster query performance?

• Star Schema

• Network Schema

• Snowflake Schema

• Hierarchical Schema

A company’s financial data needs to be analyzed by year and quarter. Which type of hierarchy would be most useful in the Time Dimension?

• Week→Day→Month

• Year→Quarter→Month

• Day→Month→Year

• Year→Month→Day

You are tasked with designing a dimensional model for a telecommunications company. The company wants to analyze customer call data. What should be the primary fact table?

• Subscription Plans

• Call Detail Records

• Customer Dimension

• Billing Information

A shipping company tracks shipments, delivery times, and customer satisfaction. Identify the necessary tables.

• ShipmentFactTable

• DeliveryDimensionTable

• CustomerDimensionTable

• SatisfactionSurveyFactTable

• TotalPurchasesDimensionTable

Your data warehouse contains data from multiple sources. What is the first step you should take in dimensional modeling?

• Create the ETL processes

• Define the fact tables

• Design the reporting interface

• Identify the business processes