True or false, Report Builder offers direct expo

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

(Continued from previous question...)

True or false, Report Builder offers direct export to a Microsoft Access database as one of its supported export options?

Answer
False

Explanation
False. Supported formats include Excel, CSV, XML, TIFF, MHTML, and PDF. XML or CSV could be easily imported into Access, but there is way to add the data directly from Report Builder

(Continued on next question...)

Other Job Interview Questions

• What does this return?
• How can SQL Server Agent Mail send messages in SQL Server 2005?
• 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?
• Using Report Builder, which of the following statements is correct about formatting numbers?
• Which protocols support Kerberos authentication on SQL Server 2005?
• What does this return? select (1324 & 1024)
• Can you use a CASE statement in a WHERE clause?
• Which permission in SQL Server 2005 allows you to switch your security context to that of another user with the EXECUTE AS statement?
• How many of these servers can you consolidate?
• Which type of XML variable requires a\one and only one root element?
• More...