You work as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. Your duties include administrating two SQL Server 2005 database named Certkiller -DB01 and Certkiller -DB02.
A Domain.com employee named Clive writes various ad hoc queries against the company databases. Clive has access to the Client database on Certkiller -DB01. Clive does not have any access to the Marketing database on Certkiller -DB02. You need to make sure that Clive is able to write queries that join data from both Certkiller -DB01 and Certkiller -DB02.
What should you do?
A.
You need to instruct Clive to write the queries on Certkiller -DB02 by using the OPENQUERY statement.
Thereafter you can specify Certkiller -DB01 as the server name.
B.
You need to create a linked server on Certkiller -DB01 to Certkiller -DB02.
Then you can configure the linked server to use impersonation.
C.
You need to create a linked server on Certkiller -DB01 to Certkiller -DB02.
Thereafter you can configure the linked server to use mapped logins.
D.
You need to instruct Clive to indicate the SQL Server object names by using four-part notation.
Explanation:
You need to define a linked server for every external data source you want to access. Thereafter you can configure the security context under which your distributed queries will run. You can configure the linked server to use one of the following security modes:
Self-mapping
– When a linked server is created, this mode is added for all local logins, so SQL Server tries to connect to the external data source using the current user’s login credentials. The same login and password must exist on the remote server. This is the default behavior. Delegation – This mode impersonates the Windows local credentials; the connection forwards the credentials of an authenticated Windows user to the linked server. The Windows user account and password must exist on the linked server. Remote Credentials – This mode lets you map local logins to remote logins on the external data source.