You develop a package in SQL Server 2008 Integration Services (SSIS).
You need to deploy the package so that it meets the following requirements:
Only authorized users can view and execute the package.
Users will NOT know the database credentials from within the package.
The package should NOT be stored in the MSDB database.
What should you do?

You maintain the SQL Server 2008 Integration Services (SSIS) instance for a healthcare
supply chain data management company. Your company uses a 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?

You maintain a SQL Server 2008 Analysis Services (SSAS) server. You add two new
measure groups to an existing cube.
You need to deploy only one of these measure groups to the production environment with
minimal impact to the cube.
What should you do?

You maintain a SQL Server 2008 Analysis Services (SSAS) server.
After several databases are deployed to the server, you notice that the drives are nearing
capacity.
You need to move the data to drives with more space.
Which two actions should you perform? (Each correct answer presents part of the solution.
Choose two.)

You develop a series of SQL Server 2008 Integration Services (SSIS) packages.
There are dependencies among the packages. You need to configure the packages.
Which configuration type should you use?

You build and deploy a SQL Server 2008 Integration Services (SSIS) package.
During package development, the XML configuration is not specified.
You need to apply the configuration file to the deployed package stored in file system.
Which parameter should you set in the dtexec command line utility?

HOTSPOT
You are an ETL developer for a mortgage company. In your application you have two tables
named Vendor and Loan.
Vendor sample data is shown in the following table:

Loan sample data is shown in the following table:

You need to build a SQL Server 2008 Integration Services (SSIS) package that meets the
following requirements:
The package should be able to generate the Excel files dynamically.

Each file should have the vendor name as the prefix and the date as the suffix (e.g.,
VendorA_DDMMYYYY.xlsx).
All the vendor names should be added to a variable and loop through the variable to
generate and load separate files for each vendor dynamically.
Which type of variable should you create? (To answer, select the appropriate option in the
dialog box in the answer area.)

You are implementing a disaster recovery strategy for SQL Server 2008 Reporting Services
(SSRS).
You want to be able to restore the report catalog database in the event of a failure.
You need to back up the encryption key.
Which command line utility should you use?

You maintain a SQL Server 2008 Reporting Services instance.
Some users need to view and run reports in the Eastern Region folder on the Report Server.
You need to assign these users the minimum permissions required.
Which role should you use?

You are working as reporting administrator for a product development company. The
company uses SQL Server 2008 Reporting Services (SSRS) deployed in 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.)