You need to implement the appropriate solution to meet the requirements while ensuring that the amount of development and maintenance time is minimized

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

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

A.
Create a dimension named Marketing Category Name and then configure a many-tomany relationship.

B.
Create a dimension named Marketing Category Name and then configure a regular
relationship.

C.
Add an attribute hierarchy named Marketing Category Name to the customer dimension.

D.
Add an attribute hierarchy for each marketing category to the customer dimension.
Configure each hierarchy to have two members named Yes and No.



Leave a Reply 5

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


Niklas

Niklas

Answer:
A.- Create a dimension named Marketing Category Name and then configure a many-to- many relationship.

Fabio J.

Fabio J.

A is correct.

Ralph

Ralph

A – we have here many to many relation and SSAS supports this by adding new dimension and realting it with other dimensions with many-to-many

Marchello

Marchello

A.
Create a dimension named Marketing Category Name and then configure a many-tomany relationship.