What should you do?
You work as a database administrator at Domain.com. Domain.com is using a SQL Server 2008 instance.
Domain.com contains a SQL Agent job that runs every 5 minutes.
Domain.com also has a text file called CK_Tst.log on F: drive that logs all the information of the job.
One morning during monitoring you notice the following:
* The SQL Server Agent job does not function
* The SQL Server Agent service does not execute.
You need to make sure why the SQL Server Agent service got lost.
What should you do?
which implementsthe stored procedure; however it should delete the job when it is finished.What should you do?
You work as a database administrator at Domain.com. Domain.com is using a SQL Server 2008 instance.
The SQL Server 2008 instance has a stored procedure which runs a database maintenance process.
You were instructed to develop a SQL Server Agent job which implements
the stored procedure; however it should delete the job when it is finished.
What should you do?
What should you do?
You work as a database administrator at Domain.com. Domain.com is using a SQL Server 2008 instance.
You want the tasks in the database to have the following characteristics:
* Examining database integrity.
* Reproducing indexes.
* Stores a report to a text file.
You have received instructions to ensure that you could change the SQL Server instance in such a
way that an e-mail notification is sent to the developers when the maintenance plan could not run
normally.
What should you do?
What should you do?
You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance. The SQL Server 2008 instance contains SQL Server Agent jobs.
These SQL Server Agent jobs uses ten shared schedules that is used 24/7.
You have received instructions to ensure that a job named CK_Tst does not execute on Sundays.
What should you do?
What should you do?
You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance. The SQL Server 2008 instance hosts quite a few applications. Furthermore, the
SerTestTest account is used by the SQL Server Agent service. Domain.com also uses a file that
can be stored to a log server, by using a job named CK_MTest. However, CK_MTest cannot
access the log server as it should. You then decide to set the service of SQL Server Agent.
You need to ensure that the settings of the SQL Server Agent service can access the entire log server.
What should you do?
What should you do?
You work as a database administrator at Domain.com. The Domain.com network contains a
SQL Server 2008 computer named CERTKILLER-DB01. CERTKILLER-DB01 needs the SQL
Server service and the SQL Server Agent service to start automatically. Besides that, it should
also audit all user names and application names that access the system. Auditing should be on
always and the result should be there for about a decade.
What should you do? (Choose TWO.)
What should you do?
You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance. You are busy with the setting of the Database Mail profile. You want the Database
Mail profile to send reports to all of the users at Domain.com. You then use the sp_send_dbmail
stored procedure to send reports during office hours. However, this method will take its time to
send delivery reports to management. Furthermore, management wants the reports as soon as
possible.
What should you do?
What should you do?
You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2000 instance that contains a database named CK_DB1. One day you installed a SQL Server
2008 instance for business. Management wants you to ensure that the third-party applications can
run on both database instances with the minimum amount of administrative effort.
What should you do?
What should you do?
You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance that contains a database named CK_Prod. Domain.com is using Microsoft SQL
Server 2005 Analysis Services (SSAS) that is accessed by an Internet Information Services
application by using anonymous access. However, management wants the SSAS sample to be
processed by the application.
What should you do?
What should you do?
You work as a database administrator at Domain.com. Domain.com is using a SQL Server 2008 instance.
You have received instructions to publish an instance of SQL Server Reporting Services (SSRS)
that will keep the old information to the same machine, and as default as possible.
What should you do?