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

Show Answer

 
 
2) Which of the following command prompt tool is used for deploying the reports ?

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

Show Answer

 
 
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

Show Answer

 
 
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

Show Answer

 
 
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

Show Answer

 
 
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

Show Answer

 
 
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

Show Answer

 
 
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

Show Answer

 
 
9) What is the extension for report file?

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

Show Answer

 
 
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

Show Answer

 
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

Show Answer

 
 
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

Show Answer

 
 
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

Show Answer

 
 
14) The Control that is used for displaying Data in a Free-form Layout is

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

Show Answer

 
 
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

Show Answer

 
 
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”)

Show Answer

 
 
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

Show Answer

 
 
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

Show Answer

 
 
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

Show Answer

 
 
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

Show Answer

 
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.

Show Answer

 
 
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

Show Answer

 
 
23) How can you identify the current user in SSRS report?

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

Show Answer

 
 
24) Cumulative Sum in SSRS could be achieved using the function

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

Show Answer

 
 
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

Show Answer

 
 
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

Show Answer

 
 
27) In Reporting Services, Interactive Sorting enables sorting of _________________

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

Show Answer

 
 
28) In Reporting Services, an Expressions begin with ________________________Sign

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

Show Answer

 
 
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

Show Answer

 
 
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

Show Answer

 
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

Show Answer

 
 
32) A Matrix report in Reporting Services provide functionality similar to ____________________

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

Show Answer

 
 
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()

Show Answer

 
 
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

Show Answer

 
 
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

Show Answer

 
 
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

Show Answer

 
 
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

Show Answer

 
 
38) A dataset that is private to a report is called

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

Show Answer

 
 
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)

Show Answer

 
 
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”

Show Answer

 
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

Show Answer

 
 
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

Show Answer

 
 
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

Show Answer

 
 
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

Show Answer

 
 
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

Show Answer

 
 
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

Show Answer

 
 
47) From which version, SSRS  supports Ad-hoc reporting functionality?

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

Show Answer

 
 
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

Show Answer

 
 
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

Show Answer

 
 
50) What is Power View for SSRS?

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

Show Answer

 
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

Show Answer

 
 
52) Report snapshots can be created from ?

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

Show Answer

 
 
53) How many default rendering options are available in Reporting Services 2014?

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

Show Answer

 
 
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

Show Answer

 
 
55) Which of the following rendering extension is useful for placing reports in cache?

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

Show Answer

 
 
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

Show Answer

 
 
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

Show Answer

 
 
58) Report snapshots are stored in ___________________

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

Show Answer

 
 
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

Show Answer

 
 
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

Show Answer