You work as a database administrator for ABC.com. The ABC.com network contains a SQL
Server 2008 database server named ABC-DB05, which hosts the SQL Server 2008 Integration
Services (SSIS).
The SSIS runs a number of packages. You receive an instruction from the CIO that all services on
ABC-DB05 should run as normal as possible.
Which of the following actions should you take? (Choose all that apply.)

You work as a database administrator at ABC.com. You are assigned to manage a server named
ABC-DB01. Your duties include managing a SQL Server 2008 Integration Services (SSIS)
instance.
The SQL instance was tested in a local development environment. You receive an instruction from
the CIO to deploy the instance to ABC-DB01. The CIO informs you that the level of security must
be configured for users when they run the package.
Which of the following actions should you take?

You work as a Developer for ABC.com. The company has a SQL Server 2008 computer. You are
designing a Microsoft SQL Server 2008 Reporting Services (SSRS) accounting report. You want
every alternate row of the output in the report table to have a green background. You need to use
the appropriate expression for the BackgroundColor property of the table. Which of the following
expressions should you choose to accomplish the task?

You are using SQL Server 2008 Reporting Services to create reports for your company, an
automobile supply chain. You create a report called AutomotivePartsSales that displays the sales
for the last period. This report displays sales of over 500 different parts. The report is rendered in
PDF format.
Users complain that the page breaks are not set in the correct places when they print the report.
What report controls should you change to so that page breaks occur in the correct place when
users print? (Choose two.)

You are developing a SQL Server 2008 SQL Server Integration Services (SSIS) package. The
package consists of a Sequence container holding a For loop and a Foreach loop. There are two
Execute SQL tasks in the Foreach loop, and one Script task in the For loop.

You have created a variable for the Foreach loop. What will be the scope of the variable?

You are in the process of deploying an Analysis Services Database in the production environment.
You are using the Analysis Services Deployment Wizard to perform this deployment. The project
will be named Deploy_Prod1.
During the deployment process, you want to retain the existing roles and role members on the
destination server.
Which input file should you modify to accomplish the objective?

You are in the process of designing a cube named InvStock. The measure group in the cube will
have a measure named TotInventory that will be used to determine the total inventory stock for the
manufacturing department at the end of quarter.
What should you do to determine the inventory stock at the end of quarter?

You manage a Microsoft SQL Server Analysis Services (SSAS) database for your company.
Users are reporting that SSAS performance has recently degraded.
You run a SQL Profiler trace on MDX queries that are being executed on a SSAS instance. Trace
analysis shows that a MDX query executed by a new user is consuming more than the required
resources. You review the MDX query and identify that the MDX query contains a complex IIF
function to return a result set.
Which advice should you give to the new user to improve query performance?

You are the administrator for your company’s SQL Server 2008 server. You have created a
package using SQL Server Integration Services (SSIS) and have modified some of the package
properties. (Click the Exhibit(s) button to view the properties you configured.)
When you run the package for the first time, a file not found error occurs. When you rerun the
package, the package is successful. You want to ensure that you can restart the package at the
point of failure and skip any tasks in the package that have already completed. What should you
configure?

You want to deploy a custom assembly in SQL Server 2008 Report Services (SSRS) for use in the
reports you are generating for your organization. What must you do to deploy a custom assembly?