You design a Business Intelligence (BI) solution by using SQL Server 2008. At the end of every business day, an application records the inventory to the Products table. The business solution for the application must accommodate the following features:

The content of the Products table varies every day.

Historical product attributes are not stored.

You need to identify an appropriate dimensional model to meet the business solution. Which model should you use?

Question

You design a Business Intelligence (BI) solution by using SQL Server 2008. At the end of every business day, an application records the inventory to the Products table. The business solution for the application must accommodate the following features:

The content of the Products table varies every day.
Historical product attributes are not stored.

You need to identify an appropriate dimensional model to meet the business solution. Which model should you use?

Accepted Answer

C. Type I Slowly Changing Dimension

Answer

A. Degenerate Dimension

Answer

B. ParentCChild Dimension

Answer

D. Type II Slowly Changing Dimension

You design a Business Intelligence (BI) solution by using SQL Server 2008. At the end of every business day, an application records the inventory to the Products table. The business solution for the…

Question

Options

How the community answered

Community Discussion