Implementing a SQL Data Warehouse — Question 57

Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You are implementing a Microsoft SQL Server data warehouse with a multi-dimensional data model.
Business users observe that the value displayed for the profit margin is the average profit margin across all products. The profit margin must be calculated per product.
You need to modify the existing model without changing the overall structure of the data model.
What should you use?

Answer options

• A. star schema
• B. snowflake schema
• C. conformed dimension
• D. slowly changing dimension (SCD)
• E. fact table
• F. semi-additive measure
• G. non-additive measure
• H. dimension table reference relationship

Correct answer: G

Explanation

The correct answer is G, non-additive measure, because it allows for profit margin calculations that are not applicable to all dimensions, which fits the requirement of calculating profit margin per product. The other options either refer to schemas or dimensions that do not specifically address the need for product-specific calculations.