DRAG DROP
You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008 Server.
You are requested to make it easier to export data from the database to Microsoft Excel 2007
format. In particular you want to be able run a command from the command line that exports the
data to Excel format.
What steps should you take?

You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance. ABC.com contains a SQL Server 2008 server named ABC-DB01. There are also SQL
Server Agent jobs on the server. Furthermore the database is backed up at a daily basis. One
morning, the master database on ABC-DB02 went down. You then restore and rebuild the master
database. The ABC.com managers want ABC-DB01 to work as it was in the past.
What steps 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 SQL Server 2008.
ABC.com contains a SQL Server 2008 server named ABC-DB04. ABC-DB04 will be used to run
the Reporting Services. However, the Reporting Services must be able to run the database
backups and other maintenance job automatically. Because ABC.com has no other SQL systems,
you need to make use of the SQL’s DNS name.
What steps should you take?

You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance. You have received instruction from management to migrate a web application from
Microsoft SQL Server 2005 to Microsoft SQL Server 2008. Be reminded that when a web
application is moved then some features could stop working. You need to detect such instances.
What 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. Your junior assistant is interested in the default trace log. What T-SQL command should
she use to open this log file if we assume it is stored in the default location?

You work as a database administrator at ABC.com. ABC.com is using SQL Server 2008
Enterprise Edition. ABC.com contains a database that unfortunately has torn page errors. You
need to solve the problem of the torn page errors.
What steps 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 multiple SQL Server Agent jobs. These SQL
Server Agent jobs use twelve shared schedules that are used at all times. There is one schedule
for each month. The schedules are named January, February, etc. each configured to run in a
specific month.
You have been asked to make sure that the ABC_job13 is never run in April. What action should
you take?

You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance. The SQL Server 2008 instance has a stored procedure named ABC_14. You have been
asked to make sure ABC_14 is run once on April 21 at 5.15 AM only. You create a new SQL
Server Agent Job that starts ABC_14 to run at April 21 at 5.15 AM.
You ask your CEO if you are allowed to use SQL Server Agent Job to implement this. She tells
you that it is ok, but in that case you must make sure the SQL Server Agent Job is removed after
ABC_14 has run.
What actions should you take?

You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance. ABC.com has a SQL Agent job that contains a Windows PowerShell job step that uses
the SQLCmd function to move data between servers. The SQL Agent job is working fine for a
couple of week. However, occasionally the job fails.

Your CEO tells you that all employees in ABC must be notified by e-mail if this job is not
successfully run.
What steps should you take? (Each correct option is part of the answer. Choose THREE.)

DRAG DROP
You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance. Your CEO tells you that all user-defined stored procedures must have the prefix ABC_.
You must prevent user-defined procedures from being created that do not meet her requirement.
What steps would meet this requirement?