You administer a SQL Server 2008 instance. The instance contains various SQL Server
Agent jobs that use seven shared schedules to run each job on each day of the week. You
need to ensure that a job named Job5 no longer runs on Thursdays. What should you do?

You administer a SQL Server 2008 instance. You have a stored procedure that implements
a database maintenance process.
You need to create a SQL Server Agent job that runs the stored procedure. You also need to
ensure that the job is removed after successful completion.
What should you do?

You maintain a SQL Server 2008 instance. You create a new SQL Agent job that includes a
Windows PowerShell job step.
The PowerShell job step uses the SQLCmd utility to transfer data between servers.
You need to ensue that an operator named ResponseTeam is notified by an e-mail message
if the job fails.
What should you do?

You maintain several SQL Server 2008 instances. You need to ensure that the names of all
user-defined stored procedures contain the prefix usp_ on all instances.
You also need to ensure that you cannot create stored procedures that do not contain this
prefix.
What should you do?

You maintain a SQL Server 2008 instance that contains a database named Finance. The
data file and the transaction log file are located on the E: drive. The E: drive has only 5
percent available space.
You need to move both files to the V: drive.
Which procedure should you use?

You are mastering the company database, with SQL Server 2008 computer named SQLDB.
The function of the SQLDB is to perform transaction log backups and so on.SQL1 should be
reset by another administrator using the tool of SQL Server Surface Area Configuration.
You should see that SQL1 no longer runs the maintenance tasks automatically. On SQLDB,
You should make sure the tasks of the maintenance are finished without menWhich is the
correct answer?

You maintain multiple SQL Server 2008 instances on the same physical computer.
Users can connect to the default instance but are unable to connect to the named instances.
You verify that currently all SQL Server instances run.
You need to start the service required to connect to the named instances.
Which Service should you start?

You manage a SQL Server 2008 instance.
You need to verify whether a database integrity check (DBCC CHECKDB) was run for a
particular database.

Which log file should you examine?

You administer a SQL Server 2008 instance.
A SQL Server Agent job executes every 2 minutes. The job logs information to a text file
named SQL1.log located on the E: drive.
Users report that the server is unresponsive. You discover the following problems:
-The SQL Server Agent job no longer functions. -The SQL Server Agent service does not
run.
You need to find out the cause of the SQL Server Agent service failure.
Which log should you examine?

You administer a SQL Server 200S instance. A user named Mary reports that she is waiting
for a query to complete. You need to ascertain whether the query is blocked. Which tool
should you use?