Exam : 070-447
Title : UPGRADE: MCDBA Skills to MCITP Database Administrator by Using Microsoft
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.
QUESTION 2
You are a database
A. You do not want the user application to connect directly to Certkiller B. You need to enable the data retrieval from Certkiller B while maintaining the ability to assign different permissions to different users who use the .NET application. What should you do?
A. Change the .NET application to define a new server
B. Configure a linked server on Certkiller A to point to Certkiller B.
C. Change the stored procedures called by the .NET application to include the OPENXML command.
D. Configure a linked server on Certkiller B to point to Certkiller A.
Answer: B
Explanation: SQL Server lets you access external data sources from your local Transact-SQL code. You need to define a linked server for each external data source you want to access and then configure the security context under which your distributed queries will run. After you create a linked server, you can use the Transact-SQL OPENQUERY function to execute your distributed queries.
Download Microsoft Exam
ยป Download Link
