You are working as reporting administrator for a product development company. The company uses SQL
Server 2008 Reporting Services (SSRS) deployed in a native mode.
You need to deploy multiple reports via InstallShield.
Which three components are you required to use? (Each correct answer presents part of the solution.
Choose three.)

• A. .RSS File
• B. Report Builder
• C. RS.exe
• D. ReportService2005.asmx
• E. Rsconfig utility

You are an ETL developer for a mortgage company. In your application you have to load data from a Microsoft Excel source and an OLE DB source.
The Excel source contains vender data and has approximately 1000 records.
The OLE source contains loan data and has approximately 1,000,000 records.
Sample vendor data (Excel source) is shown in the following table:
VendorID VendorName 1 VendorA 2 VendorB 3 VendorC 4 VendorD 5 VendorE
Sample loan data (OLE DB source) is shown in the following table:
VendorID VendorName
1 VendorA
2 VendorB
3 VendorC
4 VendorD
5 VendorE
Sample loan data (OLE DB source) is shown in the following table:
LoanNumber VendorID LoanAmount
I-100 1 120000
I-200 1 130000
I-300 2 150000
I-400 3 150000
I-500 4 160000
I-600 4 170000
I-700 5 180000
The CIO asks you to generate an Excel file with the loan list information for each vendor. You build a SQL Server 2008 Integration Services (SSIS) package that can generate the Excel files dynamically. The Excel files should have the vendor name as the prefix and the date as the suffix (e.g., VendorA_DDMMYYYY.xlsx).
You get the error message shown in the exhibit. (Click the Exhibit button.)
You need to sort both sources in order to merge join the data.
What should you do?

• A. Set the IsSorted property to True for both the OLE DB and Excel sources.
• B. Sort the data in the select statement of the OLE DB source and use sort transformation after the Excel source.
• C. Use the sort transformation after the OLE DB source and set the IsSorted property to True for the Excel destination.
• D. Set the ISSorted property to True for the OLE DB, sort the data in the selct statement of the OLE DB source, and use sort transformation after the Excel source.

You maintain a SQL Server Analysis Services (SSAS) database. The database is configured by using
multiple security roles.
The database is accessed by a Microsoft ASP.NET application that runs on a remote computer. The
application is configured to use Windows Authentication.
You need to ensure that the users of the application can successfully access the SSAS database. You also
need to ensure that security restrictions of the roles are applied.
What should you do?

• A. Configure Analysis Services for HTTP authentication.
• B. Set the Security\RequireClientAuthentication property to True.
• C. Set the AnonymousConnectionsEnabled policy to True.
• D. Configure Kerberos authentication.

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. Configure the Hidden Visibility property.
• 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. Create a distinct dataset that includes all possible values and attach it to the parameter.
• G. Create a dynamic dataset that utilizes the WHERE clause to filter by the parameter.
• H. Develop a report for each environment.

You design a report by using SQL Server 2008 Reporting Services (SSRS).
The report will be included in a Windows Forms application that is distributed to remote users. These users have access to the report server.
You need to ensure that the application renders the report correctly. What should you do?

• A. Use the ReportViewer control along with the RemoteReport property.
• B. Use the ReportViewer control along with the LocalReport property.
• C. Deploy the report to the report server after adding an assembly creating a connection to the Windows form application.
• D. Deploy the report to the report server with a shared dataset.