More DBA job interview questions and answers at
http://dba.fyicenter.com/Interview-Questions/
(Continued from previous question...)
What does the CREATE SERVICE statement do in SQL Server 2005?
Before a user can build reports using Report Builder in Reporting Services 2005, which one of the following steps must be done first?
Answer
Build and deploy a model
Explanation
Report Builder requires a model and that model cannot be defined using Report Builder. The advantage of using models is that users do not need to understand SQL statements to build a report (but they will still benefit from a basic understanding of the relationships between various bits of data)
(Continued on next question...)
