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 general-purpose way to configure repeated access to remote data in SQL Server? 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. A linked server exists from the Tampa server to the Denver server, but Fred receives a security error. Which of the following is the most likely reason? Please select the best answer.
A.		He does not have administrator privileges.
B.		His login is not mapped correctly to a valid login or security context on the Denver server.
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 require previously configured linked servers.
B.		OPENROWSET uses a previously linked server, whereas OPENQUERY does not.
C.		OPENQUERY uses a previously configured linked server, whereas OPENROWSET can be used for one-time ad hoc remote access.
D.		Neither OPENROWSET nor OPENQUERY can access remote data sources.