Online Access Free 070-448 Practice Test

You develop a report by using SQL Server 2008 Reporting Services (SSRS). The report has a dataset that
contains 25 columns of data. You plan to render the dataset to a Microsoft Excel worksheet.
You need to implement drilldown technology when rendering to Excel.
Which type of data region should you use?

• A.Textbox
• B.List
• C.Rectangle
• D.Matrix

Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in the question apply only to that question.
You maintain the SQL Server 2008 integration Services (SSIS) instance for a healthcare supply chain data management company. Your company uses third-party event based scheduler.
You develop a package named Memberinformation.dtsx and save it in the SSIS packages folder on the company network.
You need to deploy this package by connecting with the DBPROD production server SSIS engine. The event based scheduler will execute the deployed SSIS package.
Which command syntax should you use

• A.dtexec /f " Z:\ Memberinformation.dtsx " /conf "
  Z: \Memberinformationconfig,cfg "
• B.dtutil /FILE c:\SSISpackages\Memberinformation.dtsx /COPY FILE;W: \ProdSSISpackages\ Memberinformation_Prod.dtsx
• C.dtutil /FILE c:\ SSISpackages|Memberinformation.dstx /COPY SQL; Memberinformation.dtsx
• D.dtexec /sq Memberinformation / verify (a400e860-38d5-11c5-11ce-ae62-08002b2b79ef)
• E.dtexec /f "c: \ Memberinformation .dtsx" /1 " DTS.LogProviderTextFile;Y:\Loginformation.txt"
• F.dtutil /SQL Memberinformation /COPY DTS;c:\SSISpackages\Memberinformation
• G.dtexec /sq Memberinformation /ser productionServer / va
• H.dtutil /FILE c:\ SSISpackages|Memberinformation.dstx /DestServer DBPROD /COPY SQL; Memberinformation.dtsx

Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You create a SQL Server 2008 Reporting Services (SSRS) report. The report is hosted in a SharePoint environment. The UserID is passed into the report automatically when the user views the report. The UserID will be used to link to other pages on the SharePoint site via url.
You need to prevent the user from seeing their UserID.
What should you do?

• A.Develop a report for each environment.
• B.Create a dynamic data source from a dataset by using the IN operator.
• C.Create a dynamic data source from a dataset that includes a list of distinct servers.
• D.Create a dynamic dataset that includes a list of the different users.
• E.Configure the Internal Visibility option for the parameter.
• F.Configure the Hidden Visibility property.
• G.Create a distinct dataset that includes all possible values and attach it to the parameter.
• H.Create a dynamic dataset that utilizes the WHERE clause to filter by the parameter.

You implement a SQL Server 2008 Integration Services (SSIS) package.
The package contains the following components:
A Foreach Loop container for the Collection property as shown in the following exhibit. (Click the Exhibit
button.)
A Foreach Loop container for the Variable Mappings property as shown in the following exhibit. (Click the
Exhibit button.)
A String variable named FileName.
A String variable named DirectoryPath.
You need to update the package so that the DirectoryPath variable returns the directory path for the file
path stored in the FileName variable.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

• A.Add a Script task to the OnPostExecute event handler of the Foreach Loop container.
• B.Set the RaiseChangedEvent property of the User::FileName variable to True.
• C.Set the Expression property of the User::DirectoryPath variable to the following expression. SUBSTRING( @[User::FileName], 1, LEN( @[User::FileName] ) - FINDSTRING( REVERSE( @ [User::FileName] ), "\\", 1 ))
• D.Set the Expression property of the User::FileName variable to the following expression. SUBSTRING( @[User::FileName], 1, LEN( @[User::FileName] ) - FINDSTRING( REVERSE( @ [User::FileName] ), "\\", 1 ))
• E.Set the EvaluateAsExpression property of the User::DirectoryPath variable to True.

You are developing a SQL Server 2008 Reporting Service (SSRS) report for a DotNetNuke (DNN) application. The DNN application and SSRS are located on the same server. A custom module has been built in DNN to display the reports.
You need to enable the DNN application to connect to the report.
What should you do?

• A.Deploy the report to the Report Server.
• B.Modify the properties of ServerURL.
• C.Use the SSRS Web service.
• D.Modify the RSReportServer.config file.