What should you do?
You work as the database administrator at Domain.com. All servers on the Domain.com network run Windows Server 2003 and all database servers run SQL Server 2005. The Domain.com network contains a database server named Certkiller -DB01. Certkiller -DB01 hosts a database named CK_Sales that stores sales and product data. The Simple Recovery Model is implemented for the CK_Sales database. A Full backup of the CK_Sales database is performed every Saturday at 8:00 P.M.
The sales data is updated frequently throughout the day. Over the last six months the CK_Sales database has grown considerably. At present the Full backup requires 6 hours to complete. You are concerned that data loss may occur should Certkiller -DB01 suffer a hard disk failure. You decide to implement additional backups of the CK_Sales database on a daily basis. However, the backup may only run between midnight and 4:00 A.M. on week nights.
What should you do? (Each correct answer presents part of the solution. Choose two.)
What should you do?
You work as the database administrator at Domain.com. The Domain.com network contains a SQL Server 2005 database server named Certkiller -DB01 that runs on a Windows Server 2003 computer. Certkiller -DB01 hosts a database named CK_Projects. The Simple Recovery Model is implemented for the CK_Projects database.
You need to implement a disaster recovery plan for the CK_Projects database. Your disaster recovery plan must ensure that data can be baked up as quickly as possible and that data can be recovered as quickly as possible following a disaster. You must also ensure that no more than three hours data is at risk at any one time. You plan to perform a full backup every Saturday at 12:00 P.M. You must now plan the backup schedule that will run during the week.
What should you do?
A Full backup of the CK_Orders database is performed every Saturday at 2:
You work as the database administrator at Domain.com. The Domain.com network contains a SQL Server 2005 database server named Certkiller -DB01 that runs on a Windows Server 2003 computer. Certkiller -DB01 hosts a database named CK_Orders. Several data capturers enter data into the CK_Orders database everyday. The Simple Recovery Model is implemented for the CK_Orders database. A Full backup of the CK_Orders database is performed every Saturday at 2:00
which encompass the system catalogs.What should he do?
You are employed as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. The Domain.com network contains a SQL Server 2005 database server named Certkiller -DB01.
You discover that a power failure occurred on the storage area network (SAN) where Certkiller -DB01 is located. A Domain.com employee named Clive Wilson is a junior technician in the Research and Development department. You inform Clive Wilson to check the allocation as well as the structural and logical integrity of all databases, which encompass the system catalogs.
What should he do?
What should you do?
You work as the database administrator at Domain.com. The Domain.com network contains a SQL Server 2005 database server named Certkiller -DB01 that runs on a Windows Server 2003 computer. Certkiller -DB01 hosts a database named CK_Staff. The Full Recovery Model is implemented for the CK_Staff database.
Domain.com acquires another company named TestLabs.com. You import staff data from the new company into the CK_Staff database. Soon after ward you notice that Certkiller -DB01 is performing quite poorly. You discover that the transaction logs for the CK_Staff database has increased by almost five times in size and has consumed most of the free disk space. You need to recover disk space as soon as possible.
What should you do?
What should you do to achieve this goal?
You are employed as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. Your duties at Domain.com are the administrating of the SQL Server 2005 computer named Certkiller -DBO1. Certkiller -DBO1 was installed with the default settings and on the server.
A database named CK_DATA is located on the Certkiller -DBO1. As administrator you noticed the recent failure of a hard disk controller and decide to check the integrity of CK_DATA. You need to create a maintenance task named Check CK_DATA that makes use of default settings.
You are then required to schedule the check to run over the weekend not to interfere with user transactions. You need to retrieve the outcome details of the Check CK_DATA maintenance plan the following Monday. What should you do to achieve this goal? (Choose all that apply)
What should you do?
You work as the database administrator at Domain.com. The Domain.com network contains two SQL Server 2005 database servers named Certkiller -DB01 and Certkiller -DB02. Certkiller -DB01 hosts a database named CK_Sales that is used to store sales information for the company, while Certkiller -DB02 is used for reporting purposes only.
You want to be notified by e-mail when ever a syntax error event occurs on the CK_Sales database but you want to keep the number of e-mails to a minimum. You configure SQL Server Agent Mail and you define a SQL operator object on Certkiller -DB01 for your administrative user account. What should you do? (Each correct answer represents part of the solution. Choose three.)
What should you do?
You work as the database administrator at Domain.com. The Domain.com network contains a SQL Server 2005 database server named Certkiller -DB01 that runs on a Windows Server 2003 computer. Certkiller -DB01 hosts a database named CK_Sales that is used to store sales information for the company. You create a maintenance job named DB_Job for Certkiller -DB01 and configure the job to run when the processor utilization on the server drops below 15%. A week later you notice that the scheduled maintenance job has not yet run. You open System Monitor on Certkiller -DB01 and notice that the processor utilization is currently at approximately 5%. You need to ensure that the maintenance job runs when the processor utilization drops below 15%.
What should you do? (Each correct answer represents part of the solution. Choose two.)
What should Amy Walsh do?
You work as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. Your duties include implementing maintenance on a SQL Server 2005 database server named Certkiller -DB01.
At present there are certain jobs that run every Sunday whilst other jobs run at the start of every month. A Domain.com user named Amy Walsh is a member of the Finance department. You instruct her to schedule the jobs in the way that uses the minimum administrative effort.
What should Amy Walsh do?
What should Rory Allen do?
You are employed as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. The Domain.com network contains two SQL Server 2005 computers named Certkiller -DB01 and Certkiller -DB02.
Certkiller -DB01 and Certkiller -DB02 both take part in replication. Certkiller -DB01 is the Publisher and Distributor of a publication named CK_Pub1. CK_Pub1 is the only publication on Certkiller -DB01 while Certkiller -DB02 is the only Subscriber. The CIO requests a status report regarding the replication latencies.
A Domain.com user named Rory Allen is a member of the Research and Development department. You instruct him to determine the current latencies between the Publisher and Distributor as well as between the Distributor and Subscriber using the Replication Monitor on Certkiller -DB01.
What should Rory Allen do?