PrepAway - Latest Free Exam Questions & Answers

Which dimensional model should you use?

You design a Business Intelligence (BI) solution by using SQL Server 2008. You plan to design a dimensional modeling strategy for a new data warehouse application.
The application contains the following dimensions:
-Product
-Time
-Customer
-SalesPerson

The application contains the following cubes:
-Sales that contains all the dimensions
-Products that contain the Product and the Time dimensions Customers that contain the Customer and the Time dimensions

You need to design an appropriate dimensional modeling strategy for the Product and the Time dimensions.
Which dimensional model should you use?

PrepAway - Latest Free Exam Questions & Answers

A.
Conformed dimensions

B.
Degenerate dimensions

C.
Parent�Child dimensions

D.
Reference dimensions

Explanation:
Tip: "to design an appropriate dimensional modeling strategy" = "Conformed"

Conformed dimensions enable a dimension to be used in multiple data marts, such as a time dimension or a product dimension. Surrogate keys are artificial keys that link dimension and fact tables and that are used to ensure uniqueness and to improve performance.

http://blog.sqlauthority.com/2007/07/27/sql-server-data-warehousing-interview-questions-and-answers-part-2/ – Excellent site
Conformed dimensions mean the exact same thing with every possible fact table to which they are joined. They are common to the cubes.


Leave a Reply