Microsoft
70-466 · Question #150
70-466 Question #150: Real Exam Question with Answer & Explanation
Sign in or unlock 70-466 to reveal the answer and full explanation for question #150. The question stem and answer options stay visible for context.
Build an analysis services database
Question
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.)
Options
- ACreate a dimension named Marketing Category Name and then configure a many-to-many relationship.
- BCreate a dimension named Marketing Category Name and then configure a regular relationship.
- CAdd an attribute hierarchy named Marketing Category Name to the customer dimension.
- DAdd an attribute hierarchy for each marketing category to the customer dimension. Configure each hierarchy to have two members named Yes and No.
Unlock 70-466 to see the answer
You've previewed enough free 70-466 questions. Unlock 70-466 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#many-to-many relationship#dimension design#SSAS#customer dimension