SQL Server interview questions part 24
SQL Server interview questions part 24
Take as many assements as you can to improve your validate your skill rating
Total Questions: 20
1. ______________ does not help you manage report server content, enable additional features, or grant access to the server.
Correct Answer is : None of the mentioned
2. __________ is a tool to configure and manage a report server connection to the report server database.
Correct Answer is : Rsconfig Utility
3. Point out the wrong statement :
Correct Answer is : Report Manager works in all modes
4. Which of the following is a tool for Report Content Management?
Correct Answer is : Report Server Web service URL
5. Which of the following mode lets you interact with the report server, reports, and report related items by using a browser with Report Manager or URL access commands?
Correct Answer is : Native
6. Reports use __________ to retrieve data for a report when a query runs or when the report is processed.
Correct Answer is : Data connections
7. A _________ is an item stored internally in an alerting database.
Correct Answer is : Data alert
8. A __________ is a report server item that contains a pointer to the report definition.
Correct Answer is : Linked report
9. A _________ report solution includes a main report that displays summary information with hyperlinks to one or more reports that display detailed information.
Correct Answer is : All of the mentioned
10. Point out the correct statement :
Correct Answer is : Report history is a collection of report snapshots
11. An ___________ report is a fully paged report saved in a specific file format.
Correct Answer is : exported
12. Which of the following is a list type in RDL with base 64 encoded value ?
Correct Answer is : Binary
13. Point out the wrong statement :
Correct Answer is : A detailed report is a saved copy of a compiled report and report data
14. You can use Report Manager in ________ mode and SharePoint site administration pages in ________ mode.
Correct Answer is : Native, Sharepoint
15. __________ are portable, multipurpose items that contain ready-to-use schedule information.
Correct Answer is : Shared schedules
16. The Schedule and Delivery Processing feature must be enabled through the ____________ property.
Correct Answer is : ScheduleEventsAndReportDeliveryEnabled
17. The functionality that SQL Server Agent provides to Reporting Services can be replaced with custom code that uses the _________ method to add schedule events to the queue.
Correct Answer is : FireEvent
18. Which of the following statement is used to retrieve rows from the view ExecutionLog3 ?
Correct Answer is : select * from ExecutionLog3 order by TimeStart DESC
19. Resource Governor is a feature that enables you to specify limits on the amount of :
Correct Answer is : None of the mentioned
20. Point out the correct statement :
Correct Answer is : Resource management is limited to the SQL Server Database Engine
