DBA > Interview Resource

Microsoft SQL Server FAQs

Part:   1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  40  41 

(Continued from previous part...)

Using Report Builder, which of the following is the best statement about the formatting options for boolean columns?

Answer
Booleans are formatted as True/False and there are no other built in options, but you could build an expression using IIF that would let you do other formatting

Explanation
From the format dialog there are no extra formatting options for booleans, Report Builder renders them as True/False. Writing an expression that you add to the model view is the easiest way to work around this limitation.


What is the easiest way to capture the SQL statement for a Report Builder report you're troubleshooting?

Answer
Run Profiler

Explanation
Profiler will work as long as you have permissions to profile the server and is the the best solution because it requires no change to the Report Server itself. There is a way to log all report SQL to a log file, but that option was not listed here and is better used if you want to do analysis rather than troubleshooting.


Clicking File, Save in Report Builder does which of the following?

Answer
Saves the report to the report server

Explanation
File|Save writes the report to the Report Server. Users have the option to also save the report to disk by using File|Save to File. Report Builder users cannot modify the model.


Which of the following choices show the three report formats supported by Report Builder

Answer
Table, Matrix, Chart

Explanation
Report Builder can build a report formatted as a table, chart, or matrix (cross tab), but only ONE can be used in any given report.


Using Report Builder, which of the following statements is correct about formatting numbers?

Answer
Users can pick from a small number of predefined formats and they have the option to specify a custom format

Explanation
There are give built in formats; general, currency, percentage, two place decimal, and exponent. Users can also define a custom format using a .Net format string.


True or false, Report Builder supports using the LIKE function inside filters?

Answer
False

Explanation
There is no LIKE support, the next best thing is the CONTAINS function which works as if you specified both a leading and trailing wild card.

(Continued on next part...)

Part:   1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  40  41