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 B01. Certkiller -DB01 hosts a database named CK_Sales that stores sales data for the company. CK_Sales is also used for online transaction processing (OLTP).
Several tables in the CK_Sales database have more than one million rows. You have created a clustered index on each table in the CK_Sales database as well as a nonclustered index on each table that is used frequently. You want to optimize performance for the clustered and nonclustered indexes. You want to generate index recommendations.
What should you do?
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 B01. Certkiller -DB01 hosts a database named CK_Manufacturing that stores data from the Manufacturing department. Several tables in the CK_Manufacturing database have more than one million rows. You have created a clustered index on each table in the CK_Manufacturing database as well as a nonclustered index on each table that is used frequently. You want to optimize performance for the CK_Manufacturing database. You create a trace file for a workload in SQL Server Profiler. You now want to tune the workload file.
What should you do?
Which performance object should she add to the counter log?
You are employed as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. Domain.com has a server named Certkiller -DB01 that is configured to run SQL Server 2005 Enterprise Edition.
Certkiller -DB01 has 2 GB of RAM. However, 1.6 GB is used by the default SQL Server database engine instance. 100 MB is the average data growth of all databases combined per month. You have received several reports from clients sating that the execution times are increasing.
A Domain.com employee named Kara Lang works in the Research and Development department. You instruct her to assess whether more RAM is required. Kara Lang needs to make use of the System Monitor to create a counter log. This counter log will aid her in deciding whether to add more RAM. Which performance object should she add to the counter log?
What should you 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. Your duties include administrating a SQL Server 2005 database named CK_Timesheet. You have received instruction from the CIO to move CK_Timesheet to a new database server. At present the CK_Timesheet database is used by the CK_TimeEntry application. You need to minimize the amount of time that the CK_TimeEntry application is unavailable while she moves the database.
What should you do?
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. Several data capturers enter data into the CK_Sales database everyday. The Full Recovery Model is implemented for the CK_Sales database. A Full backup of the CK_Sales database is performed every Saturday at
12:00 P.M., a differential backup is performed every week night at 12:00 P.M., and a backup of the transaction log is performed every two hours during the working day.
On Thursday morning you discover that Certkiller -DB01 suffered a hard disk failure sometime before the previous day’s differential backup was performed. You replace the failed hard disk and restore the operating system and application on Certkiller -DB01. You now need to restore the CK_Sales database as quickly as possible.
What should you do?
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 CK_Sales database has three file groups named Primary, Secondary and Extra. Primary is the primary file group and contains the critical data from the database.
A Full backup of the CK_Sales database is performed every Saturday at 12:00 P.M., and a backup of the transaction log is performed every two hours during the working day. Certkiller -DB01 suffers a catastrophic failure. You replace Certkiller -DB01 with a new SQL Server 2005 database server named Certkiller -DB02. You now need to restore the Primary filegroup from a backup named bak_20060722 as quickly as possible. The Secondary and Extra file groups will be restored later.
What should you do?
What should she do?
You work as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. You have received a report from the CIO stating that as soon as new sales transactions is inserted in a SQL Server 2005 database it results in an error A Domain.com user named Ally Wagner is a junior technician in the Sales department. You instruct her to investigate the error. Ally Wagner determines that a developer has accidentally deleted some data in a table that is critical for transaction processing in one of the databases.
The database makes use of the full recovery model. Ally Wagner needs to restore the table. You inform Ally Wagner to accomplish this goal without affecting the accessibility of other information in the database.
What should she do?
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