PrepAway - Latest Free Exam Questions & Answers

Author: seenagape

How can you hide a hierarchy from the users?

You work as a developer at ABC.com. The company uses a Microsoft SQL Server 2012
infrastructure.
An Analysis Services project you are developing contains multiple dimensions.
The attributes in one of the dimensions include a parent-child hierarchy, a key attribute and two
regular attributes.
Users are able to view all the hierarchies when they view the dimension.
How can you hide a hierarchy from the users?

How can you increase the processing performance of the dimension?

You have been hired as a Business Intelligence (BI) developer at ABC.com. The company uses a
Microsoft SQL Server 2012 infrastructure.
A junior developer has created a multidimensional Microsoft SQL Server Analysis Services
project. The processing performance of the dimensions in the project needs to be optimized to
improve performance.
All dimension attributes in one of the dimensions directly relate to the key attribute. Relationships
between the non-key attributes are supported by the data in the dimension.
How can you increase the processing performance of the dimension?