You work as a database administrator for ABC.com. The ABC.com network has a SQL Server
2008 Analysis Services (SSAS) instance on a database server named ABC-DB05.
ABC-DB05 contains a DataDir feature. You receive notification from management to change the
feature to a folder named Features. It is imperative that Features is used in as little time as
possible.
How can you achieve this?

You work as a database administrator at ABC.com. You are responsible for managing a SQL
Server 2008 database server named ABC-DB01.

You are in the process of creating a complex report on ABC-DB01 using SQL Server 2008
Reporting Services (SSRS). You receive an instruction to have the report cached for the first
twenty minutes upon commencing the request. You then decide to configure ABC-DB01 to comply
with the stipulation.
Which of the following actions should you take?

You work as a database administrator for ABC.com. You are responsible for a SQL Server 2008
computer named ABC-DB01, which hosts a SQL Server 2008 Reporting Services (SSRS) sample.
A new ABC.com policy permits users to move reports via e-mail. ABC-DB01 should therefore be
configured for the delivery of e-mail.
How can you configure ABC-DB01 to send or receive e-mail messages?

You work as a database administrator for ABC.com. Your duties include administrating a SQL
Server 2008 server database named ABC-DB01. ABC-DB01 is hosting the SQL Server Analysis
Services (SSAS).
ABC-DB01 hosts numerous measure groups including a group named ABCSales that makes more
use of the refresh option that the other groups. You receive an instruction from the CIO to

supervise ABCSales via ABC-DB01. You thus decide to monitor it in a table.
How can you achieve this?

You work as a database administrator for ABC.com. The ABC.com network contains a database
server named ABC-DB02 that is configured to host the SQL Server 2008 Analysis Services
(SSAS) role.
ABC-DB02 contains a single partition. You receive an instruction from the CIO to implement
caching on the partition. Several times during the day the storage data is updated on ABC-DB02.
You therefore need to configure the partition to ensure that the role is able to query the connected
data whilst being updated. You then decide to make the necessary modifications to the
ProcessingMode feature.
What should your next step encompass?

You work as a database administrator at ABC.com. Your duties include administrating a SQL
Server 2008 server database named ABC-DB05. You are in the process of deploying a SQL
Server Analysis Services (SSAS) instance.

The SSAS instance contains a dimension, named Exams, which has a property named Screen
Shots. You are tasked with seeing that the aggregations and the Screen Shots property are not
connected to each other. You decide to have the AttributeHierarchyEnabled feature configured to
complete this task.
Which of the following actions should you take?

You work as a database administrator for ABC.com. Your duties include managing a FTP server
named ABC-SR01.
ABC-SR01 is configured to host the SQL Server 2008 Integration Services (SSIS) package.
Information is retrieved from ABC-SR01 through FTP tasks and is managed using Execute SQL
tasks.
How can you ensure that the packages will restart as soon as the files are downloaded?

You work as a database administrator for ABC.com. Your duties include administrating a SQL
Server 2008 server database named ABC-DB01. ABC-DB01 contains the SQL Server 2008
Integration Services (SSIS) package.
ABC.com has decided that all divisions should construct their information using Fuzzy Grouping

transformation. You are tasked with ensuring that the package includes a Data Flow task.
You received instructions from the CIO to sort out any problems that may occur on the SSIS
package. To accomplish this task you check through the retrieved information for any constraints
on the Fuzzy Grouping transformation.
Which of the following should you add to the Data Flow task?

You work as a database administrator for ABC.com. You are responsible for managing a SQL
Server 2008 database server named ABC-DB05, which hosts the SQL Server 2008 Integration
Services (SSIS) package.
The SSIS package references packages in ABC-DB05. You receive instructions from the CIO that
all packages be located in a common directory. You are tasked with the duty to publish the SSIS
package to another database server that hosts the SSIS package.
Which command should you run for the package?

You work as a database administrator at ABC.com. You are responsible for managing a SQL
Server 2008 server database named ABC-DB01 as well as a production server named ABC-DB02. ABC-DB01 is configured to host the SQL Server 2008 Integration Services (SSIS) package.

You are in the process of examining the package prior to publishing it to a file system on ABC-DB02. Afterwards, ABC.com employees inform you that they are unable to access the package.
How can you ensure that the employees are able to access and run the package?