SQL - 070-447 Braindumps Upgrade MCDBA Skills to MCITP Database Administrator by Using Microsoft SQL Server 2005 9 Case Studies 219q.pdf

文档介绍：Exam Name: UPGRADE: MCDBA Skills to MCITP Database Administrator by Using Microsoft
SQL Server 2005
Exam Type Microsoft Case Study 9
Exams Code 70-447 Total Questions: 219

Question: 1
You work as DBA pany .com. You administer two Windows Server puters
pany A pany B. You install SQL Server 2005 on pany A and
Company B to host a pany database. Company A hosts a read-write copy of the
company database in which all changes are made. Company B subscribes to a publication on
Company A and is only used for reporting. A Windows domain administrator provides you with a
domain user account named SQL SRV 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 pany A pany 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 SQL SRV
domain user account.
B. Configure the SQL SRV 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 pany A pany A and a local user account on
Company B pany B. pany A pany B to run under the
context of the appropriate local user account.
D. Ask the Windows domain administrator to grant the SQL SRV domain user account
membership in the Domain Admin group.

Answer: B

Question: 2
You are a database administrator of two SQL Server puters pany A and
Company B. You have a Microsoft .NET application that has been modified so that it now
accesses a database pany B in addition pany A. You do not want the user
application to connect directly pany B. You need to enable the data retrieval from
Company B while maintaining the ability to assign different permissions to different user