DBA > Job Interview Questions > Microsoft SQL Server FAQs

Which optional SQL Server component must you ins

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

Which optional SQL Server component must you install to ensure that you can create and execute maintenance plans?

Answer
SQL Server Integration Services

Explanation
You must install Integration Services in order to properly create and execute maintance plans since these plans are a subset of SSIS packages.

(Continued on next question...)

Other Job Interview Questions