10. You need to provide support for distributed queries to a remote SQL Server
instance, but you need to allow it only for selected users. Which one of the
following solutions meets the requirements?
A. Grant execute permissions on the OPENROWSET function to the
selected users
B. Create a linked server and assign the selected users credentials to use when
connecting to the remote instance
C. Enable the “disallow adhoc access” on the SQL Server OLE DB to prevent
ad hoc access
D. Use sp_configure to set the “Ad Hoc Distributed Queries” to 1
Bạn đang xem 10. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P82 PPSX