You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance. You have received instructions from management to allow the users at ABC.com on the
SQL Server sample to use the OPENROWSET() function to search remote information sources.
You study incomplete code in the exhibit carefully. (Line numbers are used for reference purposes
only)
Exhibit:
01. sp_configure ‘show advanced options’, 1
02. RECONFIGURE
03.
04. RECONFIGURE
05. GO
06.

07. SELECT a.*
08. FROM OPENROWSET(‘SQLNCLI’, ‘Server=Madrid;Trusted_Connection=yes;’,
09. ‘SELECT GroupName, Name, DepartmentID
10. FROM AdventureWorks.HumanResources.Department
11. ORDER BY GroupName, Name’) AS a;
12. GO
Which T-SQL statement should you insert at line 03 to make the batch meet the requirement in
this scenario?

You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance. The a SQL Server 2008 instance is used on a Windows Server 2000 server and uses
the mixed authentication mode. Management wants you to ensure the following:
•SQL Server 2008 logins must have the same password complexity rules which are enforced by
Windows Server 2000 for authentication.

•Full compliance of all users with regarding to adhering to the password complexity rules.
What actions 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. 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)

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 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?