You maintain a SQL Server 2008 instance that runs on a computer that hosts several
applications. You configure the SQL Server Agent service to run by using the
SERVER1\AGENT account. You create a job named MailingList that requires a file to be
written to a file server. The job fails to run because it does not have appropriate access to
the file server. You plan to configure the SQL Server Agent service.
You need to perform the configuration such that only the SQL Server Agent service has read
and write access to the file server.
Which account type should you use?

You maintain a SQL Server 2008 instance that contains a database named Finance.
Minimally logged operations are performed on the Finance database.
You need to verify that the database can be restored to a specific point in time.
What should you do?

You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008.
You are the administrator of the company database. Now you are in charge of a SQL Server
2008 instance. According to the company requirement, the names of all user-defined stored
procedures must contain the prefix usp_on all instances. Besides this, you must make sure
that stored procedures that do not contain this prefix cannot be created by you. What should
you do?

You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008.
You are the administrator of the company database. Now you are in charge of a SQL Server
2008 instance. There is an Internet Information Services application. This application will use
anonymous access to access the SSAS instance.
You must make sure that the application can access the SSAS instance.
What should you do?

You maintain a SQL Server 2008 instance that contains a database named Finance. A small
percentage of data in the database is modified daily.
You need to create a read-only copy of the database for reporting purposes at the beginning
of each day by ensuring that minimal disk space is used.
Which strategy should you use?

You upgrade an instance of Microsoft SQL Server 2000 to SQL Server 2008.
The SQL Server Agent service is configured to use the LocalSystem account. A job uses a
CMDExec step to access a file located on a remote network share.
After the upgrade, the job step fails to complete execution.
You need to configure the job step so that it can successfully complete execution.
What should you do?

You maintain a SQL Server 2008 instance.
You have an existing database maintenance plan that performs the following tasks:
-Rebuilds indexes. -Checks database integrity. -Writes a report to a text file.
You need to ensure that an e-mail message is sent to the operators when the maintenance
plan fails to execute successfully.
What should you modify?

You administer two SQL Server 2008 instances named Instance1 and Instance2.
A database named Customers resides on Instance1. You move the Customers database
from Instance1 to Instance2.
A SQL Server login named User1 that has the password “111999” is used by a user to
access the database on Instance1. You create the same SQL Server login on Instance2.
The user attempts to access the Customers database on Instance2 by using the SQL Server
login User1. However, the user receives an error message which indicates that the access to
the Customers database is denied.
You need to ensure that User1 can access the Customers database.
Which Transact-SQL statements should you execute on Instance2?

You administer three SQL Server 2008 instances named Instance1, Instance2, and
Instance3. Each of the three instances runs on a separate server. A mission-critical
database is mirrored between Instance1 and Instance2. Instance3 is configured as the
witness. Instance1 is configured as the Principal. You plan to apply an update to the servers
that run Instance1 and Instance2. The update requires a restart.
You need to ensure that the servers meet the following requirements during the update
process:
-Complete the update process in the least amount of time possible. -The database must be
available on one server during the update of another server. -The update process must not
cause an automatic failover of the database.
What should you do?

You administer a SQL Server 2008 instance.
You configure a single Database Mail profile that is used to send reports to all the
employees of your organization. The sp_send_dbmail stored procedure is used to send a
large volume of reports during business hours.
The reports to the manager take a long time to be delivered.
You need to ensure that the reports to the manager are sent as quickly as possible.
What should you do?