Which of the following services is instance-awar

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

(Continued from previous question...)

Which of the following services is instance-aware?

Analysis Services
Explanation
Of these, only Analysis services is instance-aware.

(Continued on next question...)

Other Job Interview Questions

• When you create a new Message Type in the SQL Server 2005 Service Broker, what does the Authorization parameter signify?
• Which types of replication work with Oracle publishers?
• How can you quickly determine if any of these indexes are really being used?
• What should you have applied a patch for by now on your Windows 2003 and XP systems?
• How can you determine which user is executing statements in Profiler?
• If you received a "Performance Critical" status in the SQL Server 2005 replication monitor, what does this mean?
• Where is varchar(max) data stored?
• Which severity levels of errors can be corrected by a user (as opposed to those that an administrator or Microsoft must work to fix.)
• What does NULL mean?
• On which platforms can you use Instant File Initialization to improve database growth performance in SQL Server 2005?
• More...