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?

You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008 server.
Management wanted the backups to be done on a daily basis. Transaction log backups are
performed every afternoon and morning. This worked fine for six months. However, as the content
of the log file grew it resulted in a large transaction log file. The size of the transaction log file is
affecting the performance of the server. You have received instructions to take appropriate
measures when doing the backups of the transaction log files.
What is the preferred action in this scenario?

You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance that contains a database named ABC_DB. ABC_DB have 200 GB information where 3
GB of the information is changed daily. ABC_DB has its recovery model set for Simple. However,
ABC.com states that data loss of more than one hour for transactions during business hours is a
NO – NO.

How can you setup a backup service while also making sure that minimum disk space is used?
Select two.