PrepAway - Latest Free Exam Questions & Answers

Which two actions should you perform?

You administer a SQL Server 2008 infrastructure.
You plan to design an infrastructure for a new application.
The application has the following requirements:
Users can connect to an instance named SQLSERVER1.
SQLSERVER1 is linked to a server named SQLSERVER2.
SQLSERVER1 and SQLSERVER2 run on different computers.
The SQL Server instances use only Windows authentication.
You need to configure the infrastructure to ensure that the distributed queries are executed in the Windows
security context of the login.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

PrepAway - Latest Free Exam Questions & Answers

A.
Configure all servers to use the Shared Memory network protocol.

B.
Register a server principal name (SPN) for SQLSERVER1 and SQLSERVER2.

C.
Use the local computer account as a service account for SQLSERVER1 and SQLSERVER2.

D.
Create a map for each SQL login from SQLSERVER1 to SQLSERVER2 and use the impersonate option.

E.
Ensure that the two instances use the same Windows account for the Microsoft SQL Service. Create the link so that each account uses the current security context.


Leave a Reply