Which data model should you use?

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. Sales information is stored in a single table. The table includes the order date, expected shipping date, promotion ID, currency, and sales office columns. A dimension table exists for each attribute.
Business users must be able to examine the sales data based on dates, promotions, currency, and the office of the sale.
You need to design the data model.
Which data model should you use?
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

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.