Questions with Single correct answer
1) What is the name of main 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?
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?
a) LOOKUP
b) INSCOPE
c) FIX
d) mMaP
Ans: a- LOOKUP
4) Which of the following is 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?
Ans: a- http://Servername/Reportserver
6) Which of the following is 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”?
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?
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?
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?
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?
a) Windows Integrated security
b) Credential stored securely in the report server
c) Credentials supplied by 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?
a) SQL Azure
b) SQL Server Analysis services
c) XML
d) None of them
Ans: a,b,c
13) Which of the following 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?
a) Deployment from BIDS
b) Upload rdl files to 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?
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?
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?
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?
a) Service account password for SQL Server Reporting service
b) Service account password in Reporting Configuration Manager
c) Service account password 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?
a) SQL Server Browse service
b) SQL Server integration services
c) SQL Server Agent
d) SQL Server Reporting services
Ans: c & d
Questions with True/False Answer
20) Page break is possible in SSRS 2005.
a) True
b) False
Ans : a
21) Gauge is the new feature in SSRS 2008 R2.
a) False
b) True
Ans: a
22) Importing assemblies of .Net is possible in SSRS 2005.
a) True
b) False
Ans: a
23) We can use spatial data for creating reports in SSRS 2008.
a) True
b) False
Ans: b
24) We can call Report Builder from Report Manager.
a) True
b) False
Ans: a
No comments:
Post a Comment