Microsoft
70-432 · Question #84
You are the administrator of a SQL Server 2008 instance. According to the requirement of the company CIO, users on the SQL Server instance must be able to use the OPENROWSET() function to query…
The correct answer is D. Ad Hoc Distributed Queries. See the full explanation below for the reasoning.
Question
You are the administrator of a SQL Server 2008 instance. According to the requirement of the company CIO, users on the SQL Server instance must be able to use the OPENROWSET() function to query remote data source. Which sp_configure configuration option should you configure?
Options
- AAgent XPs
- Bremote access
- Cremote proc trans
- DAd Hoc Distributed Queries
How the community answered
(53 responses)- A6% (3)
- B11% (6)
- C2% (1)
- D81% (43)
Community Discussion
No community discussion yet for this question.