SSRS Intermediate Quiz

 



1) ____________ are the dynamic reports and columns can be changed at run time according to the data
 

1. Tabular Report
2. Matrix Report
3. Chart Report
4. None

Show Answer

 
 
2) Which of the following is true for Gauge report item

1. Needle, marker, and bar pointers are available in both radial and linear gauges
2. Gauge can be used to display multi dimensional data
3. A gauge can not be configured to display a different format. Radial cannot be changed to linear, and linear cannot be changed to radial.
4. Can not be embedded with other report items like Chart and Tablix

Show Answer

 
 
3) Which is true with respect to paging

1. Globals!PageNumber can be used to display the page number in report body only.
2. Globals!PageNumber can be used to display the page number in report footer and header only.
3. Globals!PageNumber can be used to display the page number everywhere in report.
4. Fields!PageNumber can be used to display the page number everywhere in report.

Show Answer

 
 
4) You  notice  that  while printing your SSRS report, blank pages are printed after every page that contains the data. But the report appears correctly when you view it on screen. You need to ensure that the blank pages are not printed. Which report property should you use?

1. Page Size
2. Grid Spacing
3. Interactive Size
4. Data Transform.

Show Answer

 
 
5) You are developing an SSRS report which is difficult and cost a lot of time to produce. You should make sure that you could set the report server to cache the report for 40 minutes at the beginning of the request. Which of the following options helps you to achieve this?

1. Manage -> Processing Options -> Always run this report with the most recent data
2. Manage -> Processing Options -> Cache a temporary copy of the report. Expire copy of report after a number of minutes
3. Manage -> Processing Options -> Cache a temporary copy of the report. Expire copy of report on the following schedule
4. SSRS does not support caching

Show Answer

 
 
6) Which of the following could be used  to find slow running report in Reporting Services?

1. Using SSRS Report manager
2. Using ReportExecutionTable
3. Using ReportConfig files
4. Using Report Server TempDB

Show Answer

 
 
7) Which of he following functions returns the set of first-match values for a set of names from a dataset that contains name/value pairs.
 
 

1. Lookup Function
2. Multilookup Function
4. LookupSet Function
5. None of a , b ,c

Show Answer

 
 
8) Correlation analysis is a method of data analysis where the relation between two measures are determined in addition to identifying outliers in the data set. Which type of chart is best suited for this method?

1. Bar Charts
3. Scatter Chart
4. Gauges
5. Column Chart

Show Answer

 
 
9) What do ‘Atom-compliant’ data feeds in SQL Server 2008 R2 Reporting Services do?

1. The ATOM data feed allows you to extract the data from other RSS feeds.
2. The ATOM data feed allows you to extract the data from a SQL Server 2008 R2 Reporting Services report. It’s as if the report itself is a data source.
3. The ATOM data feed allows you to extract the data from other Web Services.
4. None of a , b ,c

Show Answer

 
 
10) Which of the  following built-in function tests the current context of a report item to see if it is a member of a specific scope.

1. InScope
2. CurrentScope
3. LookupSet
4. LookupScope

Show Answer

 
11) Which of the following is not a Command line utility for SSRS?

1. RS
2. RSCONFIG
3. RSMGMT
4. RSKEYMGMT

Show Answer

 
 
12) Which of the following is not a Reporting Services Type of report?

1. Linked report
2. History Report
3. Cached Report
4. Exported report

Show Answer

 
 
13) Built-in Role available in SSRS

1. Browser
2. Content Manager
3. My Reports
4. Publisher
5. a,b &c
6. a,b & d
7. a &d
8. a,b,c & d

Show Answer

 
 
14) Which of the following report item cannot be added to the page footer in SSRS 2008

1. Table’ ,Matrix and Chart report item
2. Image
3. Rectangles
4. Borders

Show Answer

 
 
15) Which of the following is true about page header in SSRS 2008

1. Each rendering extension processes page headers and footers same way
2. By default, reports have page footers, but not page headers
3. Expression can be used in page header
4. Both B & C

Show Answer

 
 
16) Which of the following is true about Report wizard

1. Only Tabular and Matrix reports can be created in Report wizard
2. Shared datasource cannot be used in Report wizard
3. Grouping can be done using Report wizard
4. Both A& C

Show Answer

 
 
17) Which of the following property can use Expression to modify the report functionality at run time

1. Background color
2. Border style
3. Cell value
4. All of the above

Show Answer

 
 
18) Which of the following is not a valid option to specify credential for dataset?

1. Use a stored user name and password.
2. Prompt the user for credentials
3. No credentials are required
4. Shared Credentials

Show Answer

 
 
19) Which of the following is not a valid Report Parts?

1. Rectangle
2. Images
3. Square
4. Table

Show Answer

 
 
20) In which format, Hard page-break renderers are supported ?

1. CSV
2. HTML
3. PDF
4. XML

Show Answer

 
21) When you want to view summary level data and detail level data in a report, you implement _____

1. Drill-Through Report
2. Drill-down Report
3. Linked Report
4. Drill-across Report

Show Answer

 
 
22) Which of the following expression is correct for displaying date in format like ’14-Jan-2012′?

1. Format(Today(), “dd-MMM-yyyy”)
2. Format(Today(), “dd-Mon-yyyy”)
3. Format(Today(), “dd-mmm-yyyy”)
4. Format(Today(), “dd-MM-yyyy”)

Show Answer

 
 
23) Report Subscriptions can be created from ?

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

Show Answer

 
 
24) Which of below methods are valid to retrieve the data from a data source in an SSRS report?

1. Stored Procedure
2. Select Query
3. View
4. All the above

Show Answer

 
 
25) What is the main purpose of a query parameter?

1. To add interactivity to your reports
2. To filter data in the data source
3. Both A & B
4. To filter data on the rendered report

Show Answer

 
 
26) Which of the following is command-line utility used to define the connection properties from the SSRS instance to the Report Server database?

1. exe
2. exe
3. exe
4. None of these options are correct

Show Answer

 
 
27) What is the file name extension for an encryption key backup?

1. enc
2. enk
3. snk
4. ebk

Show Answer

 
 
28) A report has been created by enduser by using Report Builder.Later this report can be edited using which of the tools given below

1. Report Builder
2. SSDT
3. Both A & B
4. None of the above

Show Answer

 
 
29) RSKeyMgmt.exe is used to

1. Perform encryption key operations and scale-out deployment setup
2. Refine the connection properties from the SSRS instance to the Report Server database
3. Runs Report Server Script files
4. All the above

Show Answer

 
 
30) __________is a report that is embedded into another report.

1. Drill-Through Report
2. Drill-down Report
3. Sub-Report
4. Any of the above

Show Answer

 
 
31) Which of the following provides a set of navigational links to report items in a rendered report.

1. Document map
2. Bookmark
3. Jump to Report
4. Any of the above

Show Answer

 
 
32) What is a report called that contains layout information and query results that were retrieved at a specific point in time.

1. Linked report
2. Cached report
3. Snapshot Report
4. Ad hoc report

Show Answer

 
 
33) The reports that you build can be based on

1. relational data
2. multidimensional data
3. ODBC
4. All the above

Show Answer

 
 
34) What is the extension for report file?

1. .rpt
2. .rde
3. .rdl
4. .rep

Show Answer

 
 
35) What is Power View for SSRS?

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

Show Answer

 
 
36) What is the main difference between a Matrix report item and a Table report item?

1. Initial design
2. Initial template
3. Table report is only based on Tablix data region
4. Matrix report is only based on Tablix data region

Show Answer

 
 
37) Which of the following SSRS 2012 feature informs you about changes in report data that are of interest to you, and at a relevant time

1. Report Events
2. Report Alerts
3. Data Events
4. Data Alerts

Show Answer

 
 
38) 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 Paramters can filter data on the rendered report only

Show Answer

 
 
39) You are unable to create a cache of a report. Which of following would be a reason for this

1. Native mode deployment does not support this feature
2. SharePoint integrated mode deployment does not support this feature
3. Credentials are not stored in the Report Server.
4. Windows Authentication is not enabled

Show Answer

 
 
40) Which of the following mechanisms help you to reduce the overhead of Reporting Services data sources  and improve report response time.

1. Snapshots and cached reports
2. Linked and Sub Reports
3. Drill Down Reports
4. Drill-through reports

Show Answer

 
 
41)
Using which of the following can we preview reports that use local or published shared data sources and shared datasets

1. Report Manager
2. Report Builder
3. Report Server
4. Shared Dataset

Show Answer

 
 
42) Security in SSRS could be managed in Report Manger by which link?

1. SiteSettings
2. SecuritySettings
3. ManageSecurity
4. SetSecurity

Show Answer

 
 
43) Where does Power View get its data to create Power View reports?

1. Only from worksheets included in Excel
2. Only from the Data Model
3. Only from data imported from external sources
4. From the Data Model, and from any data that exists in the worksheets in Excel

Show Answer

 
 
44) What predefined database role is used by Reporting Services to grant report server permissions to the report server database?

1. RSConfigRole
2. SysAdminRole
3. ContributerRole
4. RSExecRole

Show Answer

 
 
45) Which default roles of SSRS  have full permissions to create, view, and manage Report Builder reports?

1. Content Manager and Report Builder
2. System Administrator and System User
3. System Administrator and Content Manager
4. Report Builder and System User

Show Answer

 
 
46) Which of the following logging categories are supported by Reporting Services?

1. Trace logging
2. Execution logging
3. Both A & B
4. None Of these

Show Answer

 
 
47) Which of the following is NOT a default delivery mechanism in SSRS

1. Share Point Library
2. Web Portal
3. Shared Folder
4. E-Mail

Show Answer

 
 
48) Which table in the reportserver  stores the mapping between the User , Role and policy of a catalog object.

1. PolicyRole
2. SecData
3. ModelItemPolicy
4. ReportServerSecurity

Show Answer

 
 
49) When we populate a dropdown parameter in SSRS ,the  field where we can specify the value to be shown in the dropdown is —————————

1. Value Field
2. Label Field
3. Name Field
4. Display Filed

Show Answer

 
 
50) Which of the following are the performance enhancing methods in SSRS

1. Caching
2. Snapshot
3. LinkedReports
4. Both A and B

Show Answer

 
 
51) Consider a scenario where the customer asks to deliver a sales reports without any manual intervention to the users e-mail.
The requirement is that
– the North region report should be delivered only to the resources in the north region & this should be in word format.
– the East region report should be delivered only to the resources in the east region & this should be in excel format.
– the West region report should be delivered only to the resources in the west region & this should be in csv format.
– the South region report should be delivered only to the resources in the south region & this should be in PDF format.
We can achieve this is SSRS using

1. Null Data Driven subscription
2. Standard Subscription
3. Data Driven Subscription
4. Default Subscription

Show Answer

 
 
52) The function that could be used to  separate a comma separated string for a Multi Valued Parameter is

1. SplitCommas()
2. Separate()
3. Split()
4. None Of these

Show Answer

 
 
53) From which version of SSRS  supports Ad-hoc reporting functionality?

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

Show Answer

 
 
54) The SSRS configuration file that maintains the details for the delivery extension  for subscription is

1. config
2. Config
3. config
4. Config

Show Answer

 
 
55) The SSRS configuration file that maintains the details for the rendering extension for subscription is

1. config
2. Config
3. config
4. Config

Show Answer

 
 
56) Which function is SSRS should be used to display a Multi-Valued parameter value in a textbox in a report.

1. Split()
2. Join()
3. SplitComma()
4. JoinComma()

Show Answer

 
 
57) Which Report Item could be used to automatically increase the  columns and rows based on the data  availability and also displays Column/Row totals?

1. Table
2. Tabular
3. Matrix
4. Bar Chart

Show Answer

 
 
58) The function that returns the current level of depth in a recursive hierarchy is —————–

1. RunningValue
2. CurrentLevel
3. InScope
4. Level

Show Answer

 
 
59) The function that returns the  number of rows in the specified scope, including rows with null values.

1. GetRows
2. RowCounts
3. CountRows
4. InScope

Show Answer

 
 
60) The best way to call a custom code written in a function name “Foo” is

1. Foo()
2. Foo()
3. Foo()
4. Foo()

Show Answer