Microsoft
70-450 · Question #17
70-450 Question #17: Real Exam Question with Answer & Explanation
Sign in or unlock 70-450 to reveal the answer and full explanation for question #17. The question stem and answer options stay visible for context.
Question
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.)
Options
- AConfigure all servers to use the Shared Memory network protocol.
- BRegister a server principal name (SPN) for SQLSERVER1 and SQLSERVER2.
- CUse the local computer account as a service account for SQLSERVER1 and SQLSERVER2.
- DCreate a map for each SQL login from SQLSERVER1 to SQLSERVER2 and use the
- EEnsure that the two instances use the same Windows account for the Microsoft SQL
Unlock 70-450 to see the answer
You've previewed enough free 70-450 questions. Unlock 70-450 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.