Quiz 70-448

Quiz 70-448, Microsoft SQL Server 2008, Business Intelligence Development and Maintenance

Which DMV should you use?

You need to allow the Managers role to access aggregate data based on only three or less employees

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 need to ensure that the roles and partitions previously deployed to the test environment are unaffected by the deployment

You need to ensure that the instance uses the new folder in the minimum amount of downtime

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

Which object should you modify?

Which trace event should you use?

You need to limit data that is displayed in the table while ensuring that the matrix is unaffected