How many dimensions can you have in a SQL Server

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

(Continued from previous question...)

How many dimensions can you have in a SQL Server 2005 Analysis Services database?

Answer: 2,147,483,647

Explanation: The maximum number of dimensions in a SQL Server 2005 Analysis Services database is 231-1, or 2,147,483,647.

(Continued on next question...)

Other Job Interview Questions

• You are building an application for a Smartphone and want to use SQL Server Compact Edition. However you do not want this to run as a service all the time because of power concerns. What can you do?
• Which of the following is true about the Raw File Source in SQL Server 2005 Integration Services?
• Using Report Builder, which of the following is the best statement about the formatting options for boolean columns?
• You want to create a covering index for this query on your SQL Server 2005 database ...
• In Full-Text Search, what is word breaking?
• What is the timestamp datatype used for?
• Using Report Builder, which of the following is the best statement about the formatting options for boolean columns?
• Setting the TRUSTWORTHY database property to ON allows you to execute the following from within the context of the database: Submitted by Charles Hawkins
• Which index rebuild operation in SQL Server 2005 can be performed online?
• Which commands are allowed when the "Ad Hoc Distributed Queries" server option is set to 0 in SQL Server 2005?
• More...