Get real 070-448 exam questions for better preparation

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.Role Allowed set
Northeast Region
{[Sales Territory].[Sales Territory Region].&[Northeast]}
Bikes
{[Product].[Product Category].[Product Category].&[Bikes]}
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?

• A. Add the manager to a new role that has the following two components: {[Sales Territory].[Sales Territory Region].AllMembers} as the denied set {[Sales Territory].[Sales Territory Region].&[Northeast]} as the allowed set. {[Product].[Product Category].[Product Category].AllMembers} as the denied set. {[Product].[Product Category].[Product Category].&[Bikes]} as the allowed set.
• B. Add the manager to a new role that has the following two components: {[Sales Territory].[Sales Territory Region].&[Northeast]} as the allowed set. {[Product].[Product Category].[Product Category].&[Bikes]} as the allowed set.
• C. Add the manager to the Northeast Region role.
• D. Add the manager to the Bikes role.

You use SSIS to consolidate customer data from a relational database and several Microsoft Excel files into a single data warehouse.
The data warehouse is missing information that exists in the Excel files.
You need to discover why the data warehouse is missing data. What should you verify first to begin troubleshooting?

• A. That MSDTC has been started on the system.
• B. That SSRS has been installed and configured.
• C. That system event logs are not full.
• D. That SSAS has been installed and configured.

You create a SQL Server 2008 Analysis Services (SSAS) solution. Your solution has a date dimension
named Data along with a hierarchy named Calendar. The Calendar hierarchy has levels for the Year,
Quarter, Month, and Date attributes.
You need to create a named set that refers to July of the year 2007.
Which expression should you write for the named set?

• A. PeriodsToDate ([DinTime] . [Yr-Qtr-Mth]. [Year], [DimTime] . [Yr-Qtr-Mth] . [Month]. [July 2007])
• B. ParallelPeriod ([DimTime] . [Yr-Qtr-Mth] . [Year] , 7, [DimTime] . [Yr-Qtr-Mth] . [Month] . [July 2007])
• C. PeriodsToDate ([DinTime] . [Yr-Qtr-Mth]. [Month], [DimTime] . [Yr-Qtr-Mth] . [Month]. [July 2007])
• D. ParallelPeriod ([DimTime] . [Yr-Qtr-Mth] . [Month] , 7, [DimTime] . [Yr-Qtr-Mth] . [Month] . [July 2007])

You develop a package by using SQL Server 2008 Integration Services (SSIS). You test the package by
using your local development environment.
The package is deployed to a production server.
You need to configure the protection level of the package to ensure that only the user who deployed the
package can execute it.
Which protection level should you use?

• A. EncryptAllWithPassword
• B. EncryptSensitiveWithPassword
• C. EncryptAllWithUserKey
• D. DontSaveSensitive

You create a SQL Server 2008 Reporting Services (SSRS) report. This report includes a matrix containing three groups. The last group is Customer Name.
When a user clicks on a customer name, a new report should open with detailed customer information.
You need to enable this functionality. What option should you use?

• A. Enable Interactive Sorting
• B. Go to Report
• C. Go to Bookmark
• D. Go to URL