You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance with failover clustering. You have received instructions from management to encrypt the
connections in the failover cluster.
How can this be accomplished? Select all that apply.

You work as a database administrator at ABC.com. ABC.com has 12 separate branch offices and
a main office, each office is equipped with their own SQL Server 2008 computer.
A database table named ABC-Sales is used to store point-of-sale transactions. Furthermore, ABCSales also hosts sales information from all 12 of the ABC.com branch offices to accommodate
customer returns of products. Consequently the data should be refreshed from the main office to
all 12 branch offices every hour, on the hour. To this end you make use of a trigger called
Stats_Trigger to produce sales statistics based on customer sales and buying patterns. Currently
replication between the server in each of the 12 branch offices and a middle server in the main
office occurs in real time. You need to decide which type of replication would be best in this
scenario. You should also eliminate the replication of the data that is produced by the trigger.
What steps should you take? (Each correct answer presents part of the solution. Choose TWO.)

You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance that contains a database named ABC_Travel that has a table named ABC_Travel that
keeps data about the entire catalogue of travels. The users at ABC.com search ABC_Tbl on the
Travel_Type column. The Travel_Type column is planned to contain data such as walk, bike, car,
train, bus, ferry, boat, spaceshuttle. However, at the moment the column either contains bus or
NULL.
After some investigation, to your horror, you find out that you have forgotten to build an index on
this table. After examining the hard drive on the server you realize that you cannot afford to use
indexes that require a lot of hard drive space.
What action should you take to avoid to lose your job?

You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance to administrate and maintain their database. The SQL Server 2008 instance contains a
database named ABC_DB that contains a table named ABC_Tbl.
You have to put the output of the entire information from ABC_Tbl to a file. You have received
instructions from management to ensure that your solution will provide the desired output in a
Microsoft Office Open XML document format whilst making sure that the data export process is
protected for reuse.
What utility and what step should you use to accomplish this task? (Each correct option is part of
the answer. Choose TWO)

You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance that contains a database named ABC_Prod. You have received instructions to ensure
that the entire SQL Server samples are set to comply with specific corporate standards. In
particular index creation should be forced, naming conventions should be implemented and data
fragmentation should be prevented.
Which tool and which action should you take? (Each correct option is part of the answer. Choose
TWO)

You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance. The SQL Server 2008 instance contains a database named ABC_Prod which make use
of the Fulltext indexes.
One day ABC.com users complain that some searches in the database is not working any longer.
In particular, some searches result an empty resultsets, even though even though the
corresponding key words are indeed present in the database.
What action should you take to resolve this problem?

You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2000
instance that contains a database named ABC_DB1. One day you are required to install a SQL
Server 2008 instance. Management wants you to ensure that new third-party SQL Server 2008
applications can run on both database instances with the minimum amount of administrative effort

while the old SQL Server 2000 applications should be working as before.
Which steps should you take? Select two.

You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance that contains a database named ABC_Prod. ABC.com is using Microsoft SQL Server
2005 Analysis Services (SSAS) that is accessed by an Internet Information Services application.
You get complaints from users that say they can’t access the information SQL Server 2008. They
are prompted for authentication.
How should you reconfigure the server so that the users can access the application without being
prompted for a login and a password?

You work as the network administrator at ABC.com. ABC.com has acquired an enterprise
application that runs SQL Server 2008. The stored procedures that the application uses make use
of the EXECUTE AS clause that makes use of the Microsoft Windows accounts.
A new ABC.com security policy requires that all enterprise applications must run under the context
of a service account. It is imperative that this account complies with the company policy that states
all accounts must have the least amount of privileges whilst allowing duties to be carried out.
Consequently this service account must have as little privileges as possible. You have received
instructions to configure the SQL Server service to be used in a suitable context for the installation
of the new enterprise application.
What steps should you take?

You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance that contains a database named ABC_Prod. ABC.com’s SQL Server 2008 is configured
to make use of the 7806 trace flag while booting up. You have received instructions to make sure
that the use of this trace flag is included in backups.
What action should you take?