SQL Server Reporting Services (SSRS) Quiz

Posted on: | By: – Comments Off

SSRS Beginner Quiz

 



1) What are the Databases that get installed when SSRS is installed?

  1. ReportServer and ReportServerTempDB
  2. ReportingServer and ReportingServerTempDB
  3. ReportServerConfig and ReportServerConfigTempDb
  4. ReportServerExe and ReportServerExeTempDb

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
2) Which of the following command prompt tool is used for deploying the reports ?

  1. EXE
  2. exe
  3. exe
  4. Exe

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
3) Which of the following is not true with respect to ‘Report Manager’

  1. Report Manager is used for administration purpose
  2. Report Manager is used only for a report server that runs in native mode.
  3. Cannot create/modify shared data source in Report Manager
  4. Report Builder can be launched from Report Manager

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
4) Select the right option:
Report Manager is used for i) Viewing Reports

  1. ii) Creating charts

iii)Configuring report & viewing security

  1. i only
  2. i and iii
  3. ii and iii
  4. iii only

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
5) Which of the following  is a Web-based administrative interface for Reporting Services?

  1. Report Manager
  2. Report Server
  3. Report Designer
  4. Web Manager

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
6) Which of the following is not a installed visual studio template in BIDS

  1. Report model project
  2. Report builder project
  3. Report server project
  4. Report server project wizard

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
7) What is the default URL configured for Report Manager?

  1. https://<ComputerName>/reportsMan
  2. http://<ComputerName>/reports.manager
  3. http://<ComputerName>/reports
  4. http://<ComputerName>/reportManager

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
8) Which of the following are  command prompt utilities provided SQL Server Reporting Services?

  1. a) RSS utility b)Rsconfig utility c)Rskeymgmt Utility d)Powershell cmdlets

 

  1. a & b
  2. c &d
  3. a, b, c, d
  4. b & c

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
9) What is the extension for report file?

  1. .rptx
  2. .rdex
  3. .rdlx
  4. .repx

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
10) What is the tool used for authoring and deploying reports?

  1. Report Manager
  2. Report Server
  3. SQL Server Management Studio
  4. SQL Server Data Tools

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]



 
11) What all should be backed as part of reporting Services  server level backup?

  1. Report server databases
  2. Encryption keys and
  3. Configuration Files (xml files)
  4. All developed reports
  5. All Data Sources
  6. All parameter Lists
  7. Only all developed reports & Data sources
  8. Only Report Server databases

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
12) Which of the following formats are affected by PageSize Property?

  1. PDF , Word & Image
  2. Excel & CSV
  3. MS Word Only
  4. A, B & C

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
13) Which of the following is NOT a Data region used in SSRS?

  1. Chart Data Region
  2. List Data Region
  3. Group Data Region
  4. Matrix Data Region

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
14) The Control that is used for displaying Data in a Free-form Layout is

  1. Matrix
  2. Tablix
  3. List
  4. Charts

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
15) How, adding page breaks can improve the performance of published reports

  1. As only the items on each page have to be processed as the report is viewed.
  2. As all items are processed before a report can be viewed.
  3. As it enables caching
  4. A,B,C & D

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
16) You are designing a SSRS  account report. Every other line of output in the report table must have a green background. What is the expression that you need to set for background property.

  1. iif((Rownumber(“Odd”)), “Green”,”White”)
  2. iif((Rownumber(Nothing)),”Green”, “White”)
  3. iif((Rownumber(nothing) mod 2), “Green”,”White”)
  4. Iif((Rownumber(Inscope(“old”))),”Green”,”White”)

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
17) Which is true with respect to ‘Report wizard in BIDS/SSDT’

  1. Can create all types of reports (Table, matrix, chart, etc.)
  2. Can do grouping and sub grouping in wizard level
  3. Possible to use shared data source in wizard
  4. Formatting can be done in wizard level

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
18) Reporting Lifecycle of SSRS include which of the following phases?

  1. Report authoring and Management
  2. Report authoring, Management and Delivery.
  3. Report authoring and Delivery.
  4. None of the A,B & C

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
19) Which of the following data sources are not supported by Reporting Services?

  1. XML
  2. Teradata
  3. HTML
  4. Microsoft SQL Server Analysis Services

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
20) Custom Code in SSRS could be written using which of the following Language?

  1. Any .Net Language
  2. C# .Net
  3. Net
  4. Net

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]



 
21) Why do you use shared data sources instead of embedded data sources?

  1. Shared data sources can be exposed as web services easier than embedded data sources.
  2. Credentials can be updated for all reports using a shared data source in one place.
  3. Shared data sources can connect to a wider range of underlying data source types than embedded data sources can.
  4. Performance is better for shared data sources than embedded data sources.

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
22) A dataset in SSRS specifies a __________________

  1. Query, query parameters, filters, and a field collection.
  2. Query and query parameters only
  3. Query only
  4. Query, query parameters, and filters only

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
23) How can you identify the current user in SSRS report?

  1. GetUserNameFromUserId()
  2. GetUserName()
  3. GetUser!UserId
  4. User!UserId

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
24) Cumulative Sum in SSRS could be achieved using the function

  1. RunningTotals
  2. PreviousValues & CurrentValue
  3. RunningValue
  4. GetCumilative

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
25) What does SSRS function WeekdayName(iday [,abbr])  return?
 

  1. Returns the integer day of week: 1=Sunday, 2=Monday, …, 7=Saturday given a date.
  2. Returns the integer month given a date.
  3. Returns the name of the day of week given the integer Weekday. The optional second argument will return the abbreviated day of week if ‘True’.
  4. Returns the integer minute given a date/time variable

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
26) What is the property that help you to display page number in the footer of a report in Reporting Services

  1. Pagenumber
  2. PageNumber
  3. PageNumber
  4. PageNumber

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
27) In Reporting Services, Interactive Sorting enables sorting of _________________

  1. Parameter Values
  2. Dataset values
  3. Report data
  4. Parameter Collection

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
28) In Reporting Services, an Expressions begin with ________________________Sign

  1. Equal (=)
  2. Plus (+)
  3. Ampersand (&)
  4. Exclamation(!)

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
29) Which feature of Reporting Service helps to jump to other areas within the report

  1. Drillthrough report links
  2. Hyperlinks
  3. Bookmark links
  4. Drilldown report links

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
30) A ____________provides a set of navigational links to report items , appears in a separate side pane  next to the rendered report.

  1. Hyperlinks
  2. Document map
  3. Bookmark links
  4. SSRS does not support this feature

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]



 
31) A data region that  can be used to create free-form reports or forms in Reporting Services is __________

  1. Matrices
  2. Table
  3. Rectangle
  4. List

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
32) A Matrix report in Reporting Services provide functionality similar to ____________________

  1. Linked Reports
  2. Sub Reports
  3. Crosstabs Reports
  4. Drilldown reports

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
33) You need  to display the current date in a textbox on the report, which SSRS function can help you to do this___________

  1. GetDate()
  2. SysDate()
  3. Date()
  4. ToDay()

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
34) When you have three or more conditions to test in an expression, which of the following functions helps without the need for using the same functions multiple times.

  1. Switch
  2. Iif
  3. Case
  4. A,B,C & D

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
35) Which of the below given types of queries are allowed  in SSRS to retrieve data from a data source?

  1. MDX – for OLAP
  2. DMX – for data mining
  4. T SQL
  5. All of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
36) In SSRS 2008 R2 and above , Which function could be used to get the value in another dataset based on current dataset field?

  1. GetDataSetValue Function
  2. GetValueUsingCode Function
  3. Lookup Function
  4. Not possible to get the value from another dataset from the current dataset

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
37) How to pass multi-valued parameter to a stored procedure in dataset?

  1. Use JOIN function in SSRS
  2. Use JOIN function in SSRS & split function in T-SQL
  3. Use a Linked reports to achieve this
  4. Use SPLIT function in SSRS & T-SQL

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
38) A dataset that is private to a report is called

  1. Shared Dataset
  2. Private Dataset
  3. Embedded Dataset
  4. My Dataset

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
39) Function used to concatenate multiple values from parameter list

  1. Join(Parameters!MySelection.Value)
  2. Concatenate(Parameters!MySelection.Value)
  3. Add(Parameters!MySelection.Value)
  4. Append(Parameters!MySelection.Value)

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
40) How do we create Optional parameter

  1. Marking parameter as “Optional”
  2. Marking parameter as “Nullable”
  3. By providing default value
  4. Marking parameter as “Not Nullable”

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]



 
41) A dataset which uses a stored procedure and dose not have any input parameter. In case if we cannot change the procedure, what approach needs to be used to limit the number of record to be displayed in the report.

  1. Consider running the Database Engine Tuning Advisor tool in the database
  2. Consider creating a dataset filter
  3. Consider creating a Report Parameter dialog box
  4. Consider adding an expression to the Visibility property that will result in report items to be toggled for different data views

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
42) What is a Cascading parameter in reporting Services?

  1. Parameter passed to a Sub Report
  2. Parameter passed to a Linked Reports
  3. Parameter having dependency on other parameter in the same report
  4. Parameter having dependency on other parameter in a different report

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
43) When Report Parameters are used, how data is filtered?

  1. Data is filtered at the source based on the Report Parameter
  2. Full set of data is retrieved and then filtered on the report server
  3. Report parameters can’t filter data
  4. Report Parameters can filter data in the rendered report only

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
44) When a report is re-executed  with different parameter choices, the Report Server uses cached data rather than returning to the database server, what kind of filter or paramter used in this scenario

  1. Data Filter
  2. Report Filter
  3. Query Parameter
  4. A,B,C & D

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
45) In SQL Server Reporting Services, Adhoc reports are created based on which of the following

  1. Report Model
  2. Source Model
  3. Published Report
  4. Rendered Report

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
46) What is the usage of Report Builder?

  1. Create Complex Reports by IT team
  2. Create Report Models by IT team
  3. Create ad-hoc reports by Business Users
  4. Create Snapshot Reports by Business Users

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
47) From which version, SSRS  supports Ad-hoc reporting functionality?

  1. 2005
  2. 2012
  3. 2008R2
  4. 2000

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
48) How do you launch ClickOnce Version of Report Builder

  1. From Report Manager
  2. Using Report Builder URL
  3. SharePoint -> Documents ->New Document -> Report Builder Report
  4. All of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
49) Which of the following Statements is true about Report Model

  1. a) A report model is a user-friendly description of an underlying database
  2. b) Report models can be used as data sources for reports created in Report Designer and Report Builder 3.0
  3. C)Report mod
  1. A & B
  2. A, B & C
  3. B & C
  4. B, C & D

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
50) What is Power View for SSRS?

  1. Self-Service BI tool
  2. Report Deployment tool
  3. Administrative tool
  4. Diagnostic Tool

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]



 
51) Which of the following are valid options for deploying a report? (Choose all that apply.)

  1. BIDS
  2. Report Manager
  3. Report Designer
  4. Both A, B

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
52) Report snapshots can be created from ?

  1. Report Server
  2. Report Manager
  3. Report Designer
  4. BIDS

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
53) How many default rendering options are available in Reporting Services 2014?

  1. Six
  2. Five
  3. Four
  4. Seven

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
54) Which component, by default, is responsible for executing scheduled reports?

  1. SSRS Report Manager
  2. SSRS Report Builder
  3. SQL Server Agent
  4. SSRS Scheduling Manager

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
55) Which of the following rendering extension is useful for placing reports in cache?

  1. MHTML
  2. HTML 4.0
  3. NULL
  4. XML

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
56) A cached report is invalidated in response to which of the following events?
A) When the report definition is modified
b) If report parameters are modified
c) If data source credentials change
d) If report execution options change
 

  1. A & B
  2. A, B , C & D
  3. C & D
  4. B & C only

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
57) The  evidence available to a user to indicate the report is a cached copy ____________________

  1. Date and time that the report ran is not current
  2. Date and time that the report ran is current
  3. The report Should be a snapshot report & Date and time that the report ran is not current
  4. The report Should not be a snapshot report & Date and time that the report ran is current

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
58) Report snapshots are stored in ___________________

  1. ReportServer Database
  2. MSBD database
  3. Buffer
  4. TempDB database

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
59) What is the difference between Report Caching and Snapshot?

  1. Caching is a persisted copy of the report
  2. Snapshot is a copy of the last executed report
  3. Caching is stored in Report Server Database. Snapshots are stored in TempDB
  4. Caching is a copy of the last executed report & Snapshot is a persisted copy of the report

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
60) How do view a report before publishing it to Reporting Server

  1. Use Report Builder to view Reports
  2. Use Preview Tab in Report Designer
  3. Not Possible
  4. You can view it from command Prompt

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]



 
 

Related Articles

Advanced Manufacturing Process Quiz

Web analytics, Adobe Analytics, Google Analytics Quiz

SailPoint Quiz