Analyzing Data with SQL Server 2016 Reporting Services (SSRS) Quiz Questions and Answers

Which of the following provides a simpler user interface for creating ad hoc reports, directed primarily at business users rather than developers?

Answer :
  • Report Builder

A published report that accepts input values through parameters is called a______.

Answer :
  • Parameterized Report

Who developed the SSRS?

Answer :
  • Microsoft

Which of the following is a tool for Report Content Management?

Answer :
  • Report Server Web Service URL

A ___________ is a report server item that contains a pointer to the report definition.

Answer :
  • Linked Report

A/An ______________ report is a fully paged report saved in a specific file format.

Answer :
  • exported

___________ are portable, multipurpose items that contain ready-to-use schedule information.

Answer :
  • Shared Schedule

The functionality that SQL Server Agent Provides to Reporting Services can be replaced with custom code that uses the ______________ method to add scheduled events to the queue.

Answer :
  • FireEvent

Which of the following statements is used to retrieve rows from the view ExecutionLog3?

Answer :
  • Select * from ExecutionLog3 order by TimeStart DESC

What's the full meaning of RDL?

Answer :
  • Report Definition Language