In SQL Server 2005 Analysis Services, what does

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

(Continued from previous question...)

In SQL Server 2005 Analysis Services, what does the Synchronize Database Wizard allow you to do?

Answer: Synchronize all of the above.

Explanation: The Synchronize Database Wizard synchronizes data and metadata by default. You can also specify that security be synched.

(Continued on next question...)

Other Job Interview Questions

• Which framework would you use to manage this database programatically?
• What result would you expect from this statement? Select * from dbo .MyTable
• What level of permissions does a user need to create an assembly with UNSAFE permissions?
• In the SQL Server 2005 thesaurus XML configuration file, what is the expansion set?
• In SQL Server 2005 Integration Services, if you want to import a flat file very quickly that contains only integer data, what type of parsing should you use?
• In the Windows world, if you hit the "Enter" key on your keyboard between two single quotes and inserted this value, what data would be stored in the column?
• You created a SQL Server 2005 Service Broker queue ....
• After you've completed a backup for your Sales server to disk...
• Credentials in SQL Server 2005 are used to access what?
• What is the timestamp datatype used for?
• More...