More DBA job interview questions and answers at
http://dba.fyicenter.com/Interview-Questions/
(Continued from previous question...)
What is the best way to have your junior DBA do this?
You want to ensure that your junior DBA properly enables your SQL Server 2005 servers to allow OPENROWSET and OPENDATASOURCE commands so developers can write routines that access various files. What is the best way to have your junior DBA do this?
Answer: Tell your junior DBA to use the SQL Server Surface Area Configuration Tool to enable this feature.
Explanation: The best way to ensure it is properly done is to use the Surface Area Configuration for Features tool. This minimizes the chance a mistake will be made by a junior DBA.
(Continued on next question...)