YOU NEED TO PROVIDE SUPPORT FOR DISTRIBUTED QUERIES TO A REMOTE SQ...

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