SSRS Expert Quiz

 



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

 
 
2) How to pass multi-valued parameter to 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

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

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

Show Answer

 
 
4) What function is used to convert the decimal value to nearest integer

1. Decimal(##.0)
2. Round(Decimal Value)
3. Convert (decimal, int)
4. None

Show Answer

 
 
5) What function is used to get the current date.

1. GetDate()
2. CurrentDate()
3. Now()
4. Today()

Show Answer

 
 
6) 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. None

Show Answer

 
 
7) How do we create Optional parameter

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

Show Answer

 
 
8) Cascading parameter is

1. Dependency of one parameter value on another parameter
2. Selecting multiple values in a parameter
3. Cancatenating multiple parameter values
4. None

Show Answer

 
 
9) What is not a valid visibility type for a parameter

1. External
2. Visible
3. Hidden
4. Internal

Show Answer

 
 
10) What property is used to display a message when there is no data returned from a dataset used in Matrix

1. BlankMessage
2. EmptyMessage
3. NoRowsMessage
4. None

Show Answer

 
11) What Types of Groups are Available per Data Region?

1. Details Group
2. Row groups and column groups
3. Recursive hierarchy groups
4. All

Show Answer

 
 
12) Which represents a drilldown action

1. A report is regenerated with a new filter criteria entered by the user
2. A user selects a portion of a report for export rather than the whole report
3. Report data is aggregated by a user manipulating a pivot table
4. A user click reveals data which is already present on a report, but hidden

Show Answer

 
 
13) You have a parameter named Tax on a report that you want to use to display the value of the database field TRate as a percentage, out to 3 decimal places, prefixed with the string “Tax Rate: “.
Based on the scenario above, which expression do you use t

1. =”Tax Rate: ” & Format(TRate.Value, “d”, “3”)
2. =”Tax Rate: ” & Format(Fields!TRate.Value, 3)
3. =”Tax Rate: ” & Format(Fields!TRate.Value, “p3”)
4. =”Tax Rate: ” & Number(TRate.Value, “p3”)

Show Answer

 
 
14) In which language are expression-based connection strings written

1. Visual Basic
2. Jscript
3. C#
4. RDL

Show Answer

 
 
15) You need to distribute a report using a subscription to a list of recipients via email that changes over time. The list of recipients is stored in a database
Based on the scenario above, which type of subscription do you create?

1. Data-driven
2. Parameterized
3. Standard
4. Email

Show Answer

 
 
16) Which type of logging provides information about error conditions and diagnostic messages

1. Service
2. Execution
3. Trace
4. HTTP

Show Answer

 
 
17) Which filter equation do you use to limit the dataset with a field LastName to only show people whose last name is in one list of values supplied by the user as parameter LN?

1. =[LN] IN [@LastName]
2. =[LastName] ONE OF [@LN]
3. =[LastName] == [@LN] A18
4. =[LastName] IN [@LN]

Show Answer

 
 
18) Which property allows you to specify that an element in a subreport can be hidden or shown when the user clicks it?

1. ToggleItem
2. InvertElement
3. FlipVisibilityItem
4. None

Show Answer

 
 
19) When is a drillthrough report processed and rendered?

1. Whenever the dataset the report is based on changes
2. When its link is clicked
3. Only when the report is exported
4. At the same time as the main report

Show Answer

 
 
20) In order to create a report subscription, the report must

1. have been created with SQL Server Data Tools (SSDT)
2. support the email delivery extension
3. use stored credentials
4. be run on a server configured in SharePoint-integrated mode

Show Answer

 
21) You are developing a SSRS report model. In the Report Builder tool, the users should need to create their SSRS reports. The data source they used will include 1000 tables? You should design the report model for users, and allow access to only the 20 table

1. You should develop DataSet using the Web Service to Schema(s) option
2. You should develop DataTable using the Web Service to Schema(s) option
3. You should develop a data source view and select only the required tables and views
4. You should set the data source view in the setting file

Show Answer

 
 
22) You are developing a 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 is the correct answer

1. Report snapshots should be run for report
2. You should run report execution caching for report.
3. You should set the data source to utilize a DBCC INDEXDEFRAG
4. You should set the data source to utilize a DBCC SHRINKFILE. INDEXDEFRAG

Show Answer

 
 
23) Which configuration file needs to be modified to specify rendering format of a report

1. config
2. asax
3. config
4. config

Show Answer

 
 
24) The dataset has a column named LastName. Which expression should be used to ensure that the report items are grouped by the first character in the LastName column

1. =First(Fields!LastName)
2. =Fields!LastName.Value
3. =First(Fields!LastName.Value)
4. =Fields!LastName.Value.Substring(0,1)

Show Answer

 
 
25) A reort has complex task and takes several minutes to generate. What needs to be used to configure the report server to cache the report for 30 minutes after the initial request

1. Implement report snapshots.
2. Implement report execution caching.
3. Configure the data source to use snapshot isolation.
4. Configure the data source to use a database snapshot.

Show Answer

 
 
26) 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 at 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

 
 
27) We need to design a subscription strategy for a SQL Server Reporting Services (SSRS) report.
There is an application that populates a table with user-specific subscription schedules and report formats.
We need to ensure that users can receive reports by

1. Create a standard subscription for each record in the table.
2. Create a data-driven subscription for each record in the schedule table.
3. Create one data-driven subscription. Schedule the subscription to frequently retrieve user preferences.
4. Create a standard subscription for each subscription schedule.

Show Answer

 
 
28) Which SSRS security role can meet the following requirement.

• Members of the role must be able to update shared data sources.
• Members of the role must not be able to consume reports or manage subscriptions.
• The role must provide only the minimum p

1. Content Manager role
2. Read and Process role
3. Publisher role
4. Browser role

Show Answer

 
 
29) A deployed SSRS report needs to be delivered to a dynamic list of subscribers on a perticular schedule. What needs to be done.

1. Select the report you created, and then click the New Subscription button
2. Select the My Subscriptions page, and then click the New Data-driven Subscription button
3. Select the report you created. Click the Subscriptions tab, and then click the New Data-driven Subscription button
4. Select the report you created. Click the Subscriptions tab, and then click the New Subscription button

Show Answer

 
 
30) Report Subscriptions can be created from ?

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

Show Answer

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

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

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

Show Answer

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

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

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

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

Show Answer

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

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

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

Show Answer

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

 
 
39) What is the extension for report file?

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

Show Answer