If you absolutely need a report to look the same

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

(Continued from previous question...)

If you absolutely need a report to look the same regardless of what OS or viewing software is being used, which of the following file formats would be the best choice?

Answer
TIFF

Explanation
TIFF is the correct answer. By rendering as an image there are no concerns about different fonts, problems with page breaks, etc. PDF's are almost as good and more commonly used of course, with the advantage that document maps are translated to bookmarks that are usable - something not possible with a raw image.

(Continued on next question...)

Other Job Interview Questions

• You have a relatively new SQL Server 2005 and msdb is corrupt. How can you fix this database without a restore? (data loss is acceptable)
• Which of the following choices show the three report formats supported by Report Builder
• Which of the queries is the best one for Janice to use to return the information she has been requested to provide?
• If you want to apply a hot fix to SQL Server 2005, do you need to apply them all in order?
• You want to disable the receipt of messages in one of your databases by the Service Broken. How should you do this?
• You have just upgraded your server from a single processor by adding 3 additional processors....
• 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?
• You wish to prevent anyone from using the sa account on your SQL Server 2005 instance, but still keep it available if your polocy changes. What can you do?
• You have a Scalable Shared Database setup for reporting purposes on SQL2. You want to be able to keep a point in time view of the reporting database each month. What can you do?
• How can you determine which user is executing statements in Profiler?
• More...