What should you do?

You are modifying a SQL Server Analysis Services (SSAS) cube that aggregates mobile phone usage data from a Microsoft Azure SQL Database database. The existing database contains a device dimension.
The Research and Development team has requested that capabilities be added to the database.
The capabilities must meet the following requirements:
A device member must be able to have multiple capability members.
A capability member must be able to belong to several device members.
The Research and Development team must be able to create new capabilities every quarter 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 Capability Name and then configure a many-to-many relationship.
B. Add an attribute hierarchy for each capability to the customer dimension. Configure each hierarchy to have two members named Yes and No.
C. Create a dimension named Capability Name and then configure a regular relationship.
D. Add an attribute hierarchy named Capability Name to the customer dimension.

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.