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?

You work as a database administrator at ABC.com. The ABC.com network contains SQL Server
2008 database server named ABC-DB05, which hosts the SQL Server 2008 Analysis Services
(SSAS) role that contains a cube.
During routine monitoring, you discover that queries are not performing optimally. You are tasked
with the responsibility of improving the query performance. You are in the process of identifying
the poorly performing queries in order to make the necessary changes to the cube to enhance the
performance.
What should you do? (Choose THREE.)
Each answer forms part of the solution.)

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 Reporting
Services (SSRS) role.

The SSRS package contains a parameter named @Equipment. You receive an instruction from
the CIO to set the @Equipment parameter value in the report by selecting a particular area. Your
solution to this problem should however stop employees from making any modifications to the
parameter.
How can you ensure that the value of the parameter remains unchanged?

You work as a database administrator at ABC.com. You are responsible for managing a SQL
Server 2008 database server named ABC-DB01. ABC-DB01 is configured to host the SQL Server
2008 Reporting Services (SSRS).
You are in the process of generating a SSRS report that will be accessed by employees when
they work from remote locations. However, these employees will not have access to ABC-DB01
when they work from remote locations. The report will be located in an application. You have been
instructed to make sure that the report is not generated abnormally.
Which of the following actions should you take?