Which DMV should you use?
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?
You need to allow the Managers role to access aggregate data based on only three or less employees
You update a role named Managers for the Human Resources cube in your SQL Server
2008 Analysis Services (SSAS) database. The database contains a dimension named
Employee.
You plan to configure the security for the Managers role.
You need to allow the Managers role to access aggregate data based on only three or less
employees.
What should you do?
Which XML for Analysis (XMLA) command should you use?
You maintain a SQL Server 2008 Analysis Services (SSAS) database.
You plan to refresh data in a partition every two hours.
You need to implement the incremental processing strategy.
Which XML for Analysis (XMLA) command should you use?
You need to update the cube definition on the production server without overwriting any existing partitions
You maintain a SQL Server 2008 Analysis Services (SSAS) database. You create a new
measure group in one of the cubes.
You have a program that maintains partitions on the production copy of the cube.
You need to update the cube definition on the production server without overwriting any
existing partitions.
What should you do?
You need to ensure that the roles and partitions previously deployed to the test environment are unaffected by
You maintain a SQL Server 2008 Analysis Services (SSAS) database in a test environment.
You plan to deploy changes from an SSAS project in a development environment to the test
environment.
You need to ensure that the roles and partitions previously deployed to the test environment
are unaffected by the deployment.
What should you do?
You need to ensure that the instance uses the new folder in the minimum amount of downtime
You maintain a SQL Server 2008 Analysis Services (SSAS) instance. The instance contains
a database.
You change the DataDir property of the instance to a new folder.
You need to ensure that the instance uses the new folder in the minimum amount of
downtime.
What should you do?
You need to ensure that the sales manager can view only the members in the Product dimension that relate to th
You administer a SQL Server 2008 Analysis Services (SSAS) database. A sales manager is
responsible for the sales of bikes in the Northeast region. You plan to grant the necessary
permissions to the sales manager to access the database. You have two roles named
Northeast Region and Bikes. The schemas of the two roles are as shown in the following
table.
The Visual Totals property is set to True for both roles.
You need to ensure that the sales manager can view only the members in the Product
dimension that relate to the Bikes category in the Northeast region.
What should you do?
Which object should you modify?
You maintain a SQL Server 2008 Analysis Services (SSAS) database.
When you process the Analysis Services database, you discover that a Duplicate Key error
occurs.
You need to modify the ErrorConfiguration property so that the error condition is reported
and processing continues.
Which object should you modify?
Which trace event should you use?
You maintain a SQL Server 2008 Analysis Services (SSAS) database.
You plan to troubleshoot query performance by using SQL Profiler.
You need to identify the queries that take a long time to run.
Which trace event should you use?
You need to limit data that is displayed in the table while ensuring that the matrix is unaffected
You create a SQL Server 2008 Reporting Services (SSRS) report that contains a dataset.
The dataset retrieves data by executing a stored procedure. The report contains a table and
a matrix that use the dataset.
You need to limit data that is displayed in the table while ensuring that the matrix is
unaffected.
What should you do?