Online Access Free 70-448 Exam Questions

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?

• A.Set the IsAggregatable property of the Price attribute to False.
• B.Set the GroupingBehavior property of the Price attribute to DiscourageGrouping.
• C.Set the AttributeHierarchyEnabled property of the Price attribute to False.
• D.Set the MembersWithData property of the Price attribute to NonLeafDataHidden.

You design a report by using SQL Server 2008 Reporting Services (SSRS).
Detail information is displayed each time the users render the report.
You need to ensure that the following requirements are met:
Summary information is displayed when the report is initially rendered.
Detail information is displayed only when the users click a column header.
What should you do?

• A.On the column that contains detail information, set the hidden property to FalsE. Set the Visibility can be toggled by another report item property to False.
• B.On the column that contains detail information, set the hidden property to TruE. Set the Visibility can be toggled by another report item property to False.
• C.On the column that contains detail information, set the hidden property to TruE. Set the Visibility can be toggled by another report item property to True.
• D.On the column that contains detail information, set the hidden property to FalsE. Set the Visibility can be toggled by another report item property to True.

You maintain a SQL Server 2008 Analysis Service (SSAS) database in a test environment. You plan to deploy changes from as SSAS project in a development environment to the test environment are replaced by the deployment.
What should you do?

• A.Update the database by using the Synchronize Database Wizard.
• B.Process the database by using the Business Intelligence Design Studio (BIDS).
• C.Back up the development database and restore it to the test environment.
• D.Update the database by using the Deployment Wizard.

You develop a SQL Server 2008 Reporting Services (SSRS) project.
The report will display data from a SQL Server 2005 Analysis Services databasE.You need to ensure that
the report displays member properties and extended properties.
What should you do?

• A.Use the SQL Server data source.
• B.Use the OLE DB for the Analysis Services 8.0 data source.
• C.Use the SQL Server Analysis Services data source.
• D.Use the OLE DB for SQL Server data source.

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?

• A.Use the Analysis Services Destination component in Microsoft SQL Server Integration Services (SSIS).
• B.Execute an UPDATE CUBE statement in Microsoft SQL Server Management Studio (SSMS).
• C.Use the Deployment Wizard along with the appropriate options.
• D.Use the Business Intelligence Development Studio (BIDS) and set the processing option to Do Not Process.