MS SSAS Set 1

You are managing a SQL Server 2008 Analysis Services (SSAS) database which includes a dimension called Product for Company.com. You should set the Dimension Data configurations as following: Deny access to the {[ Product].[Country].[USA],[ Product].[Country].[China]} configure of property workers. New workers increased to the property are seen by default. Which is the correct answer?

You create a SQL Server 2008 Analysis Services (SSAS) solution.
You create a dimension named DimProduct that contains an attribute named Price. You
use the DimProduct dimension in a cube.
You need to ensure that aggregations are not associated with the Price attribute.
What should you do?

You create a SQL Server 2008 Analysis Services (SSAS) solution. You have a dimension named Account and a time dimension named Time. You have a fact table that contains a column named CurrentBalance. CurrentBalance contains the current account balance. You need to create a measure named AccountBalance from the CurrentBalance column to display the closing account balance for a time period. What should you do?

You create a SQL Server 2008 Analysis Services (SSAS) solution. You enable proactive caching for a partition. You need to ensure that SSAS can query relational data when multidimensional storage is being updated. What should you do?

You are managing a SQL Server 2008 Analysis Services (SSAS) database for Company.com. In order to update data in a partition each hour you should run the incremental processing method. In order to solve the problem, which is the correct answer?

You are managing a SQL Server 2008 Analysis Services (SSAS) database for Company.com. A sales manager called Clerk is responsible for the sales of bikes in the Northeast region. You decide to give some rights to the rights to Clerk to visit the database. You won two roles below called Northeast Region and Bikes. Their schemas are listed below: You have make The Visual Totals properties attribute true for roles above. You should make sure that Clerk could browser the workers in the Product dimension which link to the Bikes category in the Northeast region. Which is the correct answer?

You are maintaining a SQL Server 2008 Analysis Services (SSAS) solution in the production environment. You modify the solution to include two new measure groups in the development environment. You need to ensure that only one measure group is deployed to the cube in the production environment. What should you do?

You are managing a SQL Server 2008 Analysis Services (SSAS) instance for Company.com. In order to execute the Usage-Based Optimization Wizard you should make query logging enable. Which is the correct answer?

You develop a SQL Server 2008 Analysis Services (SSAS) database. Your database includes several measure groups. A measure group named Sales Data requires frequent updates than other measure groups. You need to ensure that the Sales Data measure group will automatically process on a schedule managed by SSAS. What should you do?

You administer a SQL Server 2008 Analysis Services (SSAS) instance. You plan to troubleshoot query performance by using a Dynamic Management View (DMV). You need to identify query sessions that execute a query for more than 30,000 ms. Which DMV should you use?