You are modifying a SQL Server Analysis Services (SSAS) cube that aggregates order data from a Microsoft Azure SQL Database database. The existing database contains a customer dimension. The marketing team has requested that customer marketing categories be added to the database. The marketing categories must meet the following requirements:
- A customer member must be able to belong to multiple category members.
- A category member must be able to group several customer members.
- The marketing team must be able to create new categories every month in the data source.
You need to implement the appropriate solution to meet the requirements while ensuring that the amount of development and maintenance time is minimized. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

Question

Accepted Answer

A. Create a dimension named Marketing Category Name and then configure a many-to-many relationship. A many-to-many relationship in SSAS uses an intermediate fact table to resolve the bidirectional membership requirement - one customer maps to multiple categories and one category maps to multiple customers. Creating a separate Marketing Category dimension keeps new monthly categories manageable in the data source without requiring schema or cube development changes, minimizing ongoing maintenance.

Answer

B. Create a dimension named Marketing Category Name and then configure a regular relationship. A regular dimension relationship is one-to-many (one category per customer), which violates the requirement that a customer can belong to multiple category members.

Answer

C. Add an attribute hierarchy named Marketing Category Name to the customer dimension. Adding a single attribute hierarchy to the customer dimension enforces a one-to-one or one-to-many relationship from customer to category, preventing a customer from belonging to multiple categories.

Answer

D. Add an attribute hierarchy for each marketing category to the customer dimension. Configure each hierarchy to have two members named Yes and No. Adding a separate Yes/No hierarchy for each category requires a developer to add a new hierarchy every month as new categories are created, which maximizes rather than minimizes maintenance effort.

You are modifying a SQL Server Analysis Services (SSAS) cube that aggregates order data from a Microsoft Azure SQL Database database. The existing database contains a customer dimension. The marketing

Question

Exhibit

Options

How the community answered

Why each option

Topics

Community Discussion