What does a report model provide in SQL Server 2

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

(Continued from previous question...)

What does a report model provide in SQL Server 2005 Reporting Services?

Answer
A report model provides familiar business names for database tables and fields
Explanation
A Report model provides business names and terms for database fields and tables. It allows for predefined relationships between tables as well as grouping items together logically.

(Continued on next question...)

Other Job Interview Questions

• You cannot remember what permissions that the db_accessadmin fixed database role has ...
• Clicking File, Save in Report Builder does which of the following?
• How can you determine which user is executing statements in Profiler?
• Can a particular event in SQL Server 2005, such as the CREATE USER command, have more than one DDL trigger assigned to it?
• You are using SQL Server 2005 and you wish to find a number of details about stored procedures created...
• How do you recover the snapshot?
• Can a deterministic computed column be full-text indexed in SQL Server 2005? Submitted by Matija Lah
• How are modified extents tracked in SQL Server 2005 (which internal structures)?
• What does a report model provide in SQL Server 2005 Reporting Services?
• What What does the term ACID refer to?
• More...