Which of the following is the best use for a Sca

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

(Continued from previous question...)

Which of the following is the best use for a Scalable Shared Database in SQL Server 2005?

Answer
A reporting database server

Explanation
A scalable shared database is a feature that allows you to setup read-only database on a separate server for reporting purposes. This database provides an identicle view of your data from another server.

(Continued on next question...)

Other Job Interview Questions

• In SQL Server 2005, what is the maximum size of an index key?
• How do you recover the snapshot?
• What's the difference between a server login and a database user?
• You created a SQL Server 2005 Service Broker queue ....
• Which collation is used for Service Broker messages sent between the instances?
• You are loading 100 rows of data into a narrow table that is heavily used by your production inventory queries...
• You are loading 100 rows of data into a narrow table that is heavily used by your production inventory queries...
• You are loading 100 rows of data into a narrow table that is heavily used by your production inventory queries...
• In Reporting Services 2005, how is Report Builder typically deployed to end users?
• What method would you call to create this key?
• More...