You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions, monitoring the database server, and design deployment.
In the company, you major job is the deployment, maintenance and support of Microsoft SQL Server 2005. You work as the database administrator for your company. There is a SQL Server 2005 computer in the company. A single user database named DB01 is contained in this computer. All company employees connect to DB1. According to the requirement of the company policy, the database should be fault-tolerant and that failovers require no administrative effort. Therefore, you are asked to provide fault tolerance for the database.
Your solution must guarantee that even if a complete hardware failure occurs on the SQL Server 2005 computer, client computers are able to connect to the database, including a failure of all disks. What action should you perform to achieve your goal?

• A. Log shipping needs to be implemented to another SQL Server 2005 computer.
• B. A two-node server cluster that contains the database needs to be implemented.
• C. Transactional replication needs to be implemented to another SQL Server 2005 computer.
• D. Database mirroring to another SQL Server 2005 computer needs to be implemented.

You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions, monitoring the database server, and design deployment. In the company, you major job is the deployment, maintenance and support of Microsoft SQL Server 2005.
You work as the administrator of a SQL Server 2005 computer, and the computer is named SQL1. Microsoft Windows Server 2003 is run by all servers. All the servers belong to a Microsoft Active Directory domain. According to the company written security policy, strong passwords are mandated for all domain, local, and application accounts. The company utilizes a Group Policy object (GPO) to deploy the proper domain password policy. MSDOS-based or UNIX-based operating systems are run by many of the company's computers. Varying levels of access to a database named Services on SQL1 is requested by the computers. Since you are the database administrator, you are required to confirm that the Services database can be accessed by these computers.
And the company's written security policy should not be violated. Which action should be performed by you?

• A. A virtual directory should be configured through Internet Information Services (IIS) for access to SQL1. And then, users should be directed to the virtual directory for data access.
• B. A local logon account should be created on SQL1 for each of the company's users. And then, each logon account should be offered with access to SQL1 and the Services database.
• C. One SQL Server logon account should be created for all of the company's computers running MS-DOS or UNIX-based operating systems. And then, the Enforce password policy option should be enabled for users' accounts. At last, the logon accounts should be provided with access to the Services database.
• D. A SQL Server logon account should be created for each of the company's users. And then, the Enforce password policy option should be enabled for each logon account. At last, each logon account should be offered with access to the Services database.
• E. A domain account should be created for each of the company's users. And then, each domain account should be offered with access to SQL1 and the Services database.

You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions, monitoring the database server, and design deployment. In the company, you major job is the deployment, maintenance and support of Microsoft SQL Server 2005. You administer a SQL Server 2005 computer named SQL01. Backups of all user databases are performed on Sunday nights. Backups of all system databases are performed on Saturday nights. All backups are stored in an off-site facility. SQL01 shuts down unexpectedly because of a power failure. The SQL Server service fails to start when SQL01 is brought back online. The SQL Server error log is shown in the exhibit below. Since you are the technical support, you have to return SQL01 to working order in a minimum possible time. What action should you perform first?

• A. All of the user databases should be restored from backup.
• B. After the SQL Server 2005 installation CD is inserted, you should reinstall the default instance by running the setup utility.
• C. All of the system databases should be restored.
• D. Setup.exe should be run from a command line and a rebuild of the master database
  should be specified.

After check, you find that because of a careless deletion at 11:45, all inserts and updates in the internet_rentals database from the last two days were lost. Now it is 11:58.
In order to recover the data that are lost, you have to perform a point-in-point restore. After you complete the restore, you intend to limit the amount of data loss. Your database, transaction log, and all backups can be accessed. After you take the database offline, what action should you perform?
(Choose the appropriate actions and put them in the correct order.)
1.Perform the back up of the active portion of the transaction log.
2.Restore the latest full backup, and the WITH NORECOVER option should be used.
3.Restore the latest differential backup, and the WITH NORECOVER option should be used.
4.Restore the final transaction log backup, and the WITH RECOVERY and STOPAT options should be used.
5.Restore all but the final transaction log backups that have occurred since the latest full backup, and the WITH NORECOVER option should be used.
6.Restore all but the final transaction log backups that have occurred since the latest different backup, and the WITH NORECOVER option should be used.

• A. 5, 1, 6, 4
• B. 6, 3, 5, 4
• C. 2, 5, 1. 6
• D. 5, 4, 3, 1
• E. 4, 2, 6, 3

You are a professional level SQL Server 2005 database administrator in an international
corporation named Wiikigo. You are experienced in implementing high-availability solutions, monitoring the database server, and design deployment. In the company, you major job is the deployment, maintenance and support of Microsoft SQL Server 2005.You work as the administrator of a SQL Server 2005 computer, and the SQL Server 2005 computer is called SQL01. SQL01 is in a Microsoft Active Directory domain. No rights or privileges are assigned to you to have domain administration performed. However, the company has granted you membership in the local Administrators group on SQL01. Most of the management of SQL01 is performed from your administrative workstation. However, according to the company security requirements, you intend to have all attempts for interactive logons and network connections to SQL1 tracked. Which action should be performed?

• A. The local security policy of SQL1 should be edited. Then, success and failure auditing should be set on the Audit logon events setting.
• B. A Group Policy object (GPO) should be created, and the GPO is set to audit success and failure of the Audit account logon events setting. And then, the domain administrator should be requested to link the GPO to the object including SQL01.
• C. The SQL Server Profiler should be run and a standard default template should be utilized.
• D. The SQL Server service should be set on SQL01 to audit all successful and failed logon attempts.