You work as a database administrator at ABC.com. The ABC.com network contains a SQL Server
2008 database server named ABC-DB01, which hosts the SQL Server 2008 Reporting Services
(SSRS) instance.
During routine monitoring, you discover that this instance does not render any extensions for
Microsoft Office Word.
How would you modify the instance to render these extensions?

You work as a database administrator for ABC.com. The ABC.com network contains a SQL
Server 2008 database server named ABC-DB03.
You are in the process of designing a SQL Server 2008 Integration Services (SSIS) package for
the ABC.com network. ABC.com has informed you that ABC-DB03 will be hosting the package.
You receive an instruction from the CIO to devise a plan of action in the event that ABC-DB03
becomes inactive.
How can this be achieved?

You work as a database administrator at ABC.com. You are responsible for managing a SQL
Server 2008 database server named ABC-DB01.
You receive instruction that the SQL Server 2008 Reporting Services model needs to be deployed
on ABC-DB01 to support a data source that contains 800 tables for the Marketing division. You
have been tasked with developing a report model.
Which of the following options will make sure that the Marketing division is only able to access 10
tables? (Choose two)

You work as a database administrator at ABC.com. The ABC.com network contains a SQL Server
2008 database server named ABC-DB01. ABC-DB01 is configured to host the SQL Server
Analysis Services (SSAS) role.
There is a dimension named Housing in ABC-DB01 that contains three properties named Slabs,
Cement and Bricks. The relationship between the properties is nonflexible. Currently a data source
is used that indicates the changes between the affiliations of the properties. You receive an
instruction from the CIO to ensure that any modifications will be reflected.
Identify the command that will help you to accomplish your task?

You work as a database administrator at ABC.com. Your duties include administering a SQL
Server 2008 Analysis Services (SSAS) sample named ABC-DB01.
You receive an instruction from the CIO to log all queries. You then decide to make the necessary
changes to the QueryLogconnection String feature.
What should your next step be?

You work as a database administrator at ABC.com. Your duties include administrating a SQL
Server 2008 server database named ABC-DB05, which hosts the SQL Server Analysis Services
(SSAS) role.
While querying ABC-DB05, you are presented with a Duplicate Key error. You receive an
instruction from the CIO to make minor modifications to the ErrorConfiguration feature to resolve
this problem.
Which of the following actions should you take?

You work as a database administrator for ABC.com. Your duties include administrating a SQL
Server 2008 server database named ABC-DB01 that contains a single partition. ABC-DB01 is
hosting a SQL Server 2008 Analysis Services (SSAS) role.
You are tasked with the responsibility of ensuring that information is updated in the partition every
thirty minutes.
Identify the command that will assist you in updating the partition?

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?