Your network contains a System center 2012 Configuration Manager environment. The
environment contains a reporting services point.
A group of users is responsible for creating custom reports. The custom reports will be
published.
You need to identify which tools can be used to create and publish custom reports to
Microsoft SQL Server Reporting Services (SSRS).
Which tools should you identify? (Choose all that apply.)
A.
Report Builder
B.
Microsoft SQL Server Business Intelligence Development Studio
C.
Microsoft Access 2010
D.
Reporting Services Configuration Manager
E.
Microsoft SQL Server Management Studio
Explanation:
A:
* Report BuilderConfigMgr uses Report Builder 2.0 for authoring reports.
* Report Builder 1.0 first shipped with SQL Server 2005.
Since then there have been two major upgrades, with Report Builder 3.0 emerging as the
latest and the required version for SQL Server 2008 R2.
B: Create a Report SQL Statement in SQL Server Business Intelligence Development Studio
and Create a New Configuration Manager Report