Free Microsoft 70-448 Exam Dumps Questions & Answers

You manage the security in SQL Server 2008 Reporting Services (SSRS). The report server contains a
folder named Human Resources Report.
All groups can view and modify reports in any folder.
You need to ensure that only the Human Resources group can view and modify reports in the Human
Resources Reports folder.
What should you do? (Each correct answer presents part of the solution. Choose two.)

• A.  Remove all groups from the Human Resources Reports folder.
• B.  Add the Human Resources group to the Human Resources Reports folder and assign the Content Manager role.
• C.  Assign the Human Resources group to the root folder.
• D.  Create a Human Resources role.
• E.  Assign the Human Resources role to the Human Resources Reports folder.

You create a SQL Server 2008 Integration Services (SSIS) package by using SQL Server 2008.
You use a development server named SQL_DEV1. There is no network connectivity between the
development server and the production server.
You deploy the package to the SQL_PROD1 server.
The package fails to execute. The error message states that the package cannot connect to the
SQL_DEV1
server.
You need to modify the package to refer to the SQL_PROD1 server when being executed.
What should you do?

• A.  On the Connection Managers tab of the Execute Package utility, select the Connection Manager check box, and then modify the connection string.
• B.  Modify the deployment manifest file in Microsoft Notepad, and then modify the connection string manually.
• C.  Modify the properties of the package to use the ServerStorage package protection level.
• D.  Modify the properties of the package to use the DontSaveSensitive package protection level.

You create a SQL Server 2008 Analysis Services (SSAS) solution. Your solution contains a time
dimension named DimTime that contains a hierarchy named Yr-Qtr-Mth.
You have a measure named Amount from a measure group named Measures.
You need to create a calculated member to display the Amount measure in the previous time period for the
current level of the Yr-Qtr-Mth hierarchy.
Which expression should you use?

• A.  ([Measures].[Amount],[DimTime].[Yr-Qtr-Mth].FirstSibling)
• B.  ([Measures].[Amount],OPENINGPERIOD( [DimTime].[Yr-Qtr-Mth].FirstSibling.Level))
• C.  ([Measures].[Amount],[DimTime].[Yr-Qtr-Mth].PrevMember)
• D.  ([Measures].[Amount],LASTPERIODS( 0,[DimTime].[Yr-Qtr-Mth].PrevMember))

You develop a SQL Server 2008 Reporting Services (SSRS) report.
The report contains a parameter named @SalesTaxRateID.
You set the value of the @SalesTaxRateID parameter in the report by selecting a specific region.
You need to configure the report to prevent users from modifying the value of the @SalesTaxRateID
parameter. What should you do?

• A.  Clear the Prompt value.
• B.  Remove the default values.
• C.  Set the Hidden property.
• D.  Set the Internal property.

You are developing a SQL Server 2008 Integration Services (SSIS) package.
The package uses an OLE DB connection manager to connect to a third-party database server. The
database does not support Integrated Windows authentication.
You create an XML configuration file that provides configuration for the connection manager. You add the
configuration file to the package.
When the package executes, you receive an error message which indicates that login failure occurred.
You need to execute the package successfully.
What should you do?

• A.  Edit the XML configuration file.
• B.  Run the package on the same server as the third-party database server.
• C.  Use an indirect XML configuration.
• D.  Use a Microsoft ADO.NET connection manager instead of an OLE DB connection manager.