SSRS 2008 Test

1. What's the full meaning of RDL?

Range Deviation Limit

Report Definition Language

Report Default Language

None of the above

RDL stands for Report Definition Language. This is the full meaning of RDL.

Explanation

RDL stands for Report Definition Language. This is the full meaning of RDL.

2. Which programming language can be used to code embedded functions in SSRS?

Visual Basic .NET Code

C++ Code

Java Code

C code

Visual Basic .NET Code can be used to code embedded functions in SSRS. SSRS (SQL Server Reporting Services) is a reporting tool by Microsoft that allows users to create, deploy, and manage reports. Visual Basic .NET is a programming language that is commonly used for developing applications on the .NET framework. In SSRS, users can write custom code using Visual Basic .NET to create embedded functions that can be used in their reports for various purposes such as data manipulation, calculations, or formatting.

Explanation

Visual Basic .NET Code can be used to code embedded functions in SSRS. SSRS (SQL Server Reporting Services) is a reporting tool by Microsoft that allows users to create, deploy, and manage reports. Visual Basic .NET is a programming language that is commonly used for developing applications on the .NET framework. In SSRS, users can write custom code using Visual Basic .NET to create embedded functions that can be used in their reports for various purposes such as data manipulation, calculations, or formatting.

3. RDL files are written in what language?

HTML

XML

PHP

C++

RDL files are written in XML. XML (Extensible Markup Language) is a markup language that is used to store and transport data. RDL (Report Definition Language) is a file format used by Microsoft SQL Server Reporting Services to define the structure and layout of a report. XML is a suitable language for RDL files as it allows for the organization and representation of data in a hierarchical and structured manner.

Explanation

RDL files are written in XML. XML (Extensible Markup Language) is a markup language that is used to store and transport data. RDL (Report Definition Language) is a file format used by Microsoft SQL Server Reporting Services to define the structure and layout of a report. XML is a suitable language for RDL files as it allows for the organization and representation of data in a hierarchical and structured manner.

4. A published report that accepts input values through parameters is called a/an

Rendered Report

Report Model

Linked Report

Parameterized Report

A published report that accepts input values through parameters is called a parameterized report. This type of report allows users to customize the report by providing specific values for the parameters, such as date range or product category. The report then uses these input values to generate the desired output, providing a more flexible and personalized experience for the users.

Explanation

A published report that accepts input values through parameters is called a parameterized report. This type of report allows users to customize the report by providing specific values for the parameters, such as date range or product category. The report then uses these input values to generate the desired output, providing a more flexible and personalized experience for the users.

5. The following are different types of data sources in SSRS except

ODBC

Microsoft SQL Server

Oracle

IBM

The given options list different types of data sources that can be used in SSRS. ODBC, Microsoft SQL Server, and Oracle are all valid data sources that can be used in SSRS. However, IBM is not a valid data source in SSRS. Therefore, the correct answer is IBM.

Explanation

The given options list different types of data sources that can be used in SSRS. ODBC, Microsoft SQL Server, and Oracle are all valid data sources that can be used in SSRS. However, IBM is not a valid data source in SSRS. Therefore, the correct answer is IBM.

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

Report Designer

Report Builder

Report Initiator

Report Framer

Report Builder provides a simpler user interface for creating ad hoc reports, directed primarily at business users rather than developers. It is designed to be user-friendly and intuitive, allowing business users to easily create and customize their own reports without the need for extensive technical knowledge or programming skills. Report Builder offers a wide range of pre-built templates, drag-and-drop functionality, and a user-friendly interface, making it the ideal choice for business users who need to quickly generate ad hoc reports.

Explanation

Report Builder provides a simpler user interface for creating ad hoc reports, directed primarily at business users rather than developers. It is designed to be user-friendly and intuitive, allowing business users to easily create and customize their own reports without the need for extensive technical knowledge or programming skills. Report Builder offers a wide range of pre-built templates, drag-and-drop functionality, and a user-friendly interface, making it the ideal choice for business users who need to quickly generate ad hoc reports.

7. There are how many stages of Enterprise Reporting Life Cycle?

1

2

3

4

The correct answer is 3 because the question asks about the number of stages in the Enterprise Reporting Life Cycle. The options provided are 1, 2, 3, and 4. Since the question specifically mentions the stages, we can conclude that there are three stages in the Enterprise Reporting Life Cycle.

Explanation

The correct answer is 3 because the question asks about the number of stages in the Enterprise Reporting Life Cycle. The options provided are 1, 2, 3, and 4. Since the question specifically mentions the stages, we can conclude that there are three stages in the Enterprise Reporting Life Cycle.

8. The following are the Command Line Utilities available in Reporting Services except

·RX Utility

.Rsconfig Utility

·RsKeymgmt Utility

·RS Utility

The RX Utility is not a command line utility available in Reporting Services.

Explanation

The RX Utility is not a command line utility available in Reporting Services.

9. The following are the requirements for creating a Basic Table Report except

A Text Editor

Microsoft SQL Server 2008 R2 with the AdventureWorks2008R2 database installed

SQL Server 2008 Reporting Services

SQL Server Business Intelligence Development Studio

The given requirements for creating a Basic Table Report include Microsoft SQL Server 2008 R2 with the AdventureWorks2008R2 database installed, SQL Server 2008 Reporting Services, and SQL Server Business Intelligence Development Studio. However, a text editor is not required for creating a Basic Table Report.

Explanation

The given requirements for creating a Basic Table Report include Microsoft SQL Server 2008 R2 with the AdventureWorks2008R2 database installed, SQL Server 2008 Reporting Services, and SQL Server Business Intelligence Development Studio. However, a text editor is not required for creating a Basic Table Report.

10. There are how many different part(s) of RDL file

1

2

3

4

The correct answer is 3 because an RDL file consists of three main parts: the report definition, the data source, and the report layout. The report definition defines the structure and elements of the report, the data source specifies where the data for the report comes from, and the report layout determines how the report will be displayed and formatted.

Explanation

The correct answer is 3 because an RDL file consists of three main parts: the report definition, the data source, and the report layout. The report definition defines the structure and elements of the report, the data source specifies where the data for the report comes from, and the report layout determines how the report will be displayed and formatted.