Remote Data Sources - Quiz Explanation

The answers you selected are indicated below, along with text that explains the correct answers.
 
1. Which of the following is the best way to access remote data?
Please select the best answer.
  A. Linked server
  B. Remote server
  C. Neither, they are both the same.
  D. OPENQUERY
  The correct answer is A. A linked server is the preferred method of accessing remote data. B is incorrect because remote servers are supported in SQL Server 7.0 for backward compatibility only. C is incorrect because they are not both the same. D is incorrect because OPENQUERY requires a linked server to function.

2. Fred wants to execute a remote stored procedure on the Denver server. He asked the database administrator to create a linked server from the Tampa server to the Denver server. However, when he tries to execute the remote stored procedure, he receives a security error. Which of the following is the most likely reason for the error?
Please select the best answer.
  A. He does not have administrator privileges.
  B. He does not have an account on the Denver server and has not been added as a remote login.
  C. He is not executing the stored procedure from the administrator’s workstation.
  D. The administrator added a remote server, not a linked server, to the Denver server..
  The correct answer is B. A linked server tries to pass a user’s credentials on to the remote server. A is incorrect because a Fred does not necessarily require administrator privileges. C is incorrect because it does not matter which client machine Fred executing the stored procedure from. D is incorrect because even if the server were added as a remote server, Fred could still execute stored procedures, as long as the appropriate permissions were granted.

3. What is the difference between OPENROWSET and OPENQUERY?
Please select the best answer.
  A. There is no difference, both use previously linked servers.
  B. OPENROWSET uses a previously linked server, whereas OPENQUERY does not.
  C. OPENQUERY uses a previously linked server, whereas OPENROWSET does not.
  D. Both OPENROWSET and OPENQUERY do not use a previously linked server.
  The correct answer is C. OPENQUERY uses a linked server, but OPENROWSET allows you to specify connection parameters at runtime without linking a server first. A is incorrect because there is a difference. B is incorrect because the OPENQUERY function uses the linked server, not OPENROWSET. D is incorrect because the OPENROWSET function does not use a linked server.