Pass with professional 070-448 actual quiz materials

You create a SQL Server 2008 Analysis Services (SSAS) solution. Your solution has a date dimension
named Date 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 the first seven months of the year 2007.
Which expression should you write for the named set?

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

You maintain a SQL Server 2008 Integration Services (SSIS) instancE.The instance stores packages in
a SQL Server 2008 instance.
You need to deploy the package of an instance of SSIS to another SSIS instance that stores its packages in
a shared directory.
What should you do?

• A. Execute the dtexecui command.
• B. Execute the dtexec command.
• C. Execute the dtutil command.
• D. Execute the dtswizard command.

You administer an instance of a SQL Server 2008 server.
The server is used to execute SQL Server 2008 Integration Services (SSIS) packages.
You need to ensure that the server executes only correctly signed packages.
What should you do?

• A. Set the BlockedSignatureStates registry entry to NoAdministrativeRestriction.
• B. Set the package protection level on all packages to DontSaveSensitive.
• C. Set the BlockedSignatureStates registry entry to Block invalid and untrusted signatures and unsigned
  packages.
• D. Set the package protection level on all packages to EncryptSensitiveWithPassword.

You create a report by using SQL Server 2008 Reporting Services (SSRS).
The report is complex and takes several minutes to generate.
You need to configure the report server to run in the morning and have the users access that copy of the
report for the remainder of the day.
What should you do?

• A. Configure the data source to use snapshot isolation
• B. Configure the data source to use a database snapshot
• C. Implement report snapshots
• D. Implement report execution caching

You maintain a SQL Server 2008 Analysis Services (SSAS) database that contains a dimension named
Customer.
You need to configure the Dimension Data settings to meet the following requirements:
Deny access to the {[Customer].[Country].&[Germany],[Customer].[Country].&[France]} set of attribute
members.
New members added to the attribute are visible by default.
What should you do?

• A. Add the following set to the Denied Set property. {[Customer].[Country].&[Germany] ,[Customer].[Country].&[France]}
• B. Add the following set to the Denied Set property. Except([Customer].[Country].[Country] ,{[Customer].[Country].&[Germany] ,[Customer].[Country].&[France]})
• C. Add the following set to the Allowed Set property. Extract({[Customer].[Country].&[Germany] ,[Customer].[Country].&[France]} ,[Customer].[Country])
• D. Add all the country members except those of France and Germany to the Allowed Set property.