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?
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.