SQL Server Reporting Services (SSRS) Quiz

Posted on: | By: – Comments Off

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
3) 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]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
5) What function is used to get the current date.

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
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

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

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
9) What is not a valid visibility type for a parameter

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

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



 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
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”)

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
14) In which language are expression-based connection strings written

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
16) Which type of logging provides information about error conditions and diagnostic messages

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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]

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
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

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



 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
23) Which configuration file needs to be modified to specify rendering format of a report

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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)

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
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.

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
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.

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
30) Report Subscriptions 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]



 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
33) The SSRS configuration file that maintains the details for the delivery extension  for subscription is

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
34) The SSRS configuration file that maintains the details for the rendering extension for subscription is

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
35) Which of the following is not a Command line utility for SSRS?

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
37) What is the file name extension for an encryption key backup?

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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

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

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

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



 
 
 

Related Articles

Advanced Manufacturing Process Quiz

Web analytics, Adobe Analytics, Google Analytics Quiz

SailPoint Quiz