Microsoft Exam 070-447: UPGRADE: MCDBA Skills to MCITP Database Administrator by Using Microsoft SQL Server 2005

MCDBA Skills to MCITP Database Administrator by Using Microsoft SQL Server 2005

Exam : 070-447
Title : UPGRADE: MCDBA Skills to MCITP Database Administrator by Using Microsoft SQL Server 2005
Ver : 02.26.07

QUESTION 1
You work as DBA at Certkiller .com. You administer two Windows Server 2003 computers named Certkiller A and Certkiller B. You install SQL Server 2005 on both Certkiller A and Certkiller B to host a new company database. Certkiller A hosts a read-write copy of the company database in which all changes are made. Certkiller B subscribes to a publication on Certkiller A and is only used for reporting. A Windows domain administrator provides you with a domain user account named SQLSRV to use as the security context for the SQL Server services. A password policy of 42 days exists in the Default Domain Group Policy object (GPO). You install the database on Certkiller A and Certkiller B and configure replication. Everything works fine for six weeks, but then all SQL Server services fail. You need to correct the problem.



What should you do?

A. Ask the Windows domain administrator to grant the Log on as service right to the SQLSRV domain user account.
B. Configure the SQLSRV domain user account with a new strong password. Configure the new password in the properties of each SQL Server service that failed.
C. Create a local user account on Certkiller A named Certkiller A and a local user account on Certkiller B named Certkiller B. Configure Certkiller A and Certkiller B to run under the context of the appropriate local user account.
D. Ask the Windows domain administrator to grant the SQLSRV domain user account membership in the Domain Admins group.

Answer: B
Explanation: The Default Domain Group Policy object requires that passwords are changed every 42 days. In order to correct this problem you have to change the password in the Active Directory AND configure the new password on both you SQL Servers to the newly changed password.

Download Microsoft Exam 070-447: UPGRADE: MCDBA Skills to MCITP Database Administrator by Using Microsoft SQL Server 2005:

Download “MCDBA Skills to MCITP DB Adm MsSQL Server 2005” Microsoft Exam MCDBA Skills to MCITP DB Adm MsSQLServer05.zip – Downloaded 127 times – 6 MB

PERHATIAN: Harap download file TANPA DOWNLOAD MANAGER karena kemungkinan besar akan gagal. Jika tidak bisa download via alternatif link, silakan dicoba kembali.

Tulisan Terkait

Tinggalkan Balasan

Alamat email Anda tidak akan dipublikasikan. Ruas yang wajib ditandai *

bebas bayar, pembayaran mudah dan cepat, transaksi online, pembayaran tagihan dan tiket, transfer dana online