Questions
with Single correct answer
with Single correct answer
1) What is the name of main
repository DB of Reporting service?
repository DB of Reporting service?
a) ReportingDB
b) ReportServerTempDB
c) ReportServer
d) MyReporting DB
Ans: c- Report Server
2) Which of the following is
the new feature of SQL Server 2008 R2?
the new feature of SQL Server 2008 R2?
a) Tablix
b) Page Break
c) Map
d) Report Variable
Ans: c- Map
3) By using which of the
following function, we can map multiple datasets in a single tablix?
following function, we can map multiple datasets in a single tablix?
a) LOOKUP
b) INSCOPE
c) FIX
d) mMaP
Ans: a- LOOKUP
4) Which of the following is
one of Ad-hoc Reporting tool?
one of Ad-hoc Reporting tool?
a) CRTool
b) Report generator
c) Report SX Tool
d) Report Builder
Ans: d- Report Builder
5) While deploying report
from BIDS, What will be the target URL for deployment?
from BIDS, What will be the target URL for deployment?
Ans:
a- http://Servername/Reportserver
a- http://Servername/Reportserver
6) Which of the following is
the minor version of Charts?
the minor version of Charts?
a) Map
b) Gauge
c) Mini-Chart
d) Sparkline
Ans: d-Spark line
7) Which of the following is
responsible for “SQL Server 2008 or
higher versions are no longer depended on IIS”?
responsible for “SQL Server 2008 or
higher versions are no longer depended on IIS”?
a) Hymen.sys
b) http.sys
c) iNet.sys
d) AppNet.sys
Ans: b- http.sys
8) Which of the following is
not a role in SSRS 2008 R2?
not a role in SSRS 2008 R2?
a) Browser
b) Content Manager
c) Report Builder
d) Report Subscriber
Ans: d – Report Subscriber
9) Which of the following is
not an available data type for creating a parameter in SSRS 2008 R2?
not an available data type for creating a parameter in SSRS 2008 R2?
a) Boolean
b) Varbinary
c) Date/Time
d) Float
Ans: b- Varbinary
Questions with multiple correct answers
10) Which of the following
are different ways of subscription in SSRS 2008?
are different ways of subscription in SSRS 2008?
a) Email
b) FileShare
c) Mapped drives
d) FTP
Ans: a,b
11) Which of the following
are the authentication modes for connecting a data source in Report manager
page?
are the authentication modes for connecting a data source in Report manager
page?
a) Windows Integrated
security
security
b) Credential stored
securely in the report server
securely in the report server
c) Credentials supplied by
the user running the report
the user running the report
d) Anonymous Authentication
Ans: a,b,c
12) Which of the following can be used as
datasource in SSRS 2008 R2?
datasource in SSRS 2008 R2?
a) SQL Azure
b) SQL Server Analysis
services
services
c) XML
d) None of them
Ans: a,b,c
13) Which of the following
are aggregate functions in SSRS ?
are aggregate functions in SSRS ?
a) COUNT
b) COUNTDISTINCT
c) COUNTROWS
d) COUNTCOULMNS
Ans: a,b,c
14) Which of the following
are the different ways of RDL deployment?
are the different ways of RDL deployment?
a) Deployment from BIDS
b) Upload rdl files to
Report Manager
Report Manager
c) Report Deployment Wizard
d) None of the above
Ans: a,b
15) Which of the following
can be used as data source for creating a Map?
can be used as data source for creating a Map?
a) SSRS Map Gallery
b) ESRI Shapefile
c) SQL Server spatial query
d) A & B only
Ans: a,b,c
16) Which of the Charts that
can design in SSRS 2008 R2?
can design in SSRS 2008 R2?
a) Pie
b) Funnel
c) Radar
d) Venn
Ans: a,b,c
17) Which of the following
are build-in fields functions in SSRS 2008 R2?
are build-in fields functions in SSRS 2008 R2?
a) Render format IsInteractive
b) Language
c) ReportAge
d) B & C
Ans: a,b
18) If SQL Reporting service
is running with service account and once we changed the password of service
account, what are the places where we need to update the service account
password for successful running of Reporting environment?
is running with service account and once we changed the password of service
account, what are the places where we need to update the service account
password for successful running of Reporting environment?
a) Service account password for SQL Server Reporting service
b) Service account password
in Reporting Configuration Manager
in Reporting Configuration Manager
c) Service account password
in data source if credential stored in report server.
in data source if credential stored in report server.
d) None of the above
Ans: a,b,c
19) Which of the following
services responsible for Report subscription?
services responsible for Report subscription?
a) SQL Server Browse service
b) SQL Server integration
services
services
c) SQL Server Agent
d) SQL Server Reporting
services
services
Ans: c & d
Questions with True/False Answer
20) Page
break is possible in SSRS 2005.
break is possible in SSRS 2005.
a) True
b) False
Ans
: a
: a
21) Gauge
is the new feature in SSRS 2008 R2.
is the new feature in SSRS 2008 R2.
a) False
b) True
Ans:
a
a
22) Importing
assemblies of .Net is possible in SSRS 2005.
assemblies of .Net is possible in SSRS 2005.
a) True
b) False
Ans:
a
a
23) We
can use spatial data for creating reports in SSRS 2008.
can use spatial data for creating reports in SSRS 2008.
a) True
b) False
Ans:
b
b
24) We
can call Report Builder from Report Manager.
can call Report Builder from Report Manager.
a) True
b) False
Ans:
a
a