You create a report in SQL Server 2008 Reporting Services (SSRS) solution.
You write the following code segment in the report.
Private Shared Function GetCmFromInches(ByVal InchValue As Decimal) As Decimal
If IsNothing(InchValue) Then Return Nothing Else Return InchValue * 2.54 End If End Function The code segment generates errors when compiled. You need to ensure that the following requirements are met: The code segment compiles successfully. The GetCmFromInches function can be called from other reports. What should you do?

• A. Create a custom assembly by using Microsoft Visual Basic .NET. Declare the function as Public Shared.
• B. Declare the function as Public Shared instead of Private Shared.
• C. Remove the Shared keyword from the function definition.
• D. Remove the Private keyword from the function definition.

You design a package by using SQL Server 2008 Integration Services (SSIS). The package is designed by using your local development environment.
The package extracts data from a remote server and inserts it in the PROD database on the local SQL
Server 2008 instance. You deploy the package to the MSDB database on the production server.
You need to ensure that only users that belong to an appropriate database role can modify and execute the
deployed package. You also need to ensure that these users cannot access other packages that are
deployed to the server.
What should you do?

• A. Assign the users to the db_ssisltduser role.
• B. Assign the users to a custom database role in the PROD database.
• C. Assign the users to the db_ssisoperator role.
• D. Assign the users to a custom database role in the MSDB database.

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.

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 this series. Information and details provided in a question apply only to the 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 SSISpackages folder on the company network. You need to deploy this package to the ProdSSISpackages file system on the production server. You need to rename the package to Memberinformation_Prod.dtsx, and the event based scheduler will execute the renamed package.
Which command syntax should you use?

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

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