Microsoft
70-466 · Question #20
You are designing a dimension named Employee for a SQL Server Analysis Services multidimensional project. The Employee dimension contains a DateOfBirth attribute and a MaritalStatus attribute. You nee
To minimize processing time, attributes should be configured with appropriate relationship types. Given DateOfBirth and MaritalStatus attributes: Attribute | Relationship type ---|--- DateOfBirth | Fixed MaritalStatus | Fixed
Build an analysis services database
Question
You are designing a dimension named Employee for a SQL Server Analysis Services multidimensional project. The Employee dimension contains a DateOfBirth attribute and a MaritalStatus attribute. You need to minimize the amount of time required to process the cube. What should you do? To answer, select the appropriate action in the answer area.
| Attribute | Relationship type |
|---|---|
| DateOfBirth | |
| MaritalStatus |
Explanation
To minimize processing time, attributes should be configured with appropriate relationship types. Given DateOfBirth and MaritalStatus attributes:
| Attribute | Relationship type |
|---|---|
| DateOfBirth | Fixed |
| MaritalStatus | Fixed |
Topics
#attribute relationships#flexible vs rigid#dimension processing#cube performance
Community Discussion
No community discussion yet for this question.