Enterprise Issues Business Rules  «Prev  Next»

Remote Data Sources - Quiz

Each question is worth one point. Select the best answer or answers for each question.
 
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

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.

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.
Score =
Correct answers: