Categories: Microsoft Exam

Microsoft Exam 070-447: UPGRADE: 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:

Soal Ujian

Recent Posts

Naskah Soal Ujian Nasional SMA IPA IPS 2018

Berikut ini merupakan naskah asli dari paket soal Ujian Nasional (UN) SMA IPA dan IPS…

6 tahun ago

Naskah Soal Ujian Nasional SMA IPS 2017 Lengkap

Berikut ini kami sediakan naskah asli dari paket soal Ujian Nasional (UN) SMA IPS yang…

6 tahun ago

Naskah Soal Ujian Nasional UN UNBK SMA IPA 2017 Lengkap

Dokumen berikut ini adalah naskah asli dari paket soal Ujian Nasional (UN) SMA/MTs yang diujikan…

6 tahun ago

Soal Tes Penalaran Verbal & Numerik/Kuantitatif

Berikut ini merupakan contoh soal tes penalaran verbal dan numerik/kuantitatif. Ada beberapa file soal yang…

6 tahun ago

Induksi Matematika: Materi, Soal & Penyelesaian

Berikut ini kami sediakan beberapa file yang didalamnya ada materi singkat tentang Induksi Matematika, Soal…

7 tahun ago

Soal Tryout UAMBN MTs beserta Kunci Jawaban (2 Paket)

Berikut ini adalah soal tryout UAMBN MTs beserta kunci jawaban yang terdiri dari 2 paket…

8 tahun ago