Mcts 70-448 Chap 13 Configuring And Administering The Ssrs Server

Front 1

What are the three major components of a complete SSRS installation?

Back 1

1. SQL Server catalog (2 DB-ReportServer and ReportServerTempDB)
2. Report Server service
3. Web service and URL access

Front 2

What are the two virtual directories in Web Service and URL access and what are they used for?

Back 2

Reports (used by the Report Manager Web interface) and ReportServer(used for direct access to the SSRS Web Service)

Front 3

What are the three Reporting Services configuration options the SQL Server 2008 Setup Wizard provides?

Back 3

Install native mode default configurations
Install SharePoint integrated mode default configurations
Install, but do not confiugre the report server

Front 4

Is IIS required for Reporting Services in native mode?

Back 4

It was in previous version but not anymore
Reporting Services now uses HTTP.sys which is included with Windows Server 2003 and 2008

Front 5

What changes with the SharePoint integrated mode default configuration?

Back 5

Report Manager is not installed and SharePoint Services 3 or Office SharePoint Server 2007 is the report management interface

Front 6

Do you need to use the SharePoint integrated mode to use SSRS WebParts in SharePoint?

Back 6

No

Front 7

Can you use the default configuration when you install a second instance of Reporting Services?

Back 7

No, it needs a seperate named instance

Front 8

What are two common scenarios where a second instance of SSRS is useful?

Back 8

1. Strict security requirements require you to divide site-level security among multiple groups of administrators
2. Limited hardware for development, test, and production servers so you use multiple instances on a single server

Front 9

What user interface administrationt tool for configuring SSRS server settings is included in the installation of the SSRS server component?

Back 9

Reporting Services Configuration Manager tool

Front 10

What common setup and configuration tasks does Reporting Services Configuration Manager tool perform?

Back 10

Create the virtual directories
Configure the Service Startup account
Define the ASP.NET account
Set up the DB connection to the SSRS repository
Manage the symmetric encryption keys
Perform initalization steps to enable new instances
Define operational accounts for e-mail and other admin tasks

Front 11

What should you do in case you need to reinstall the report server on the same computer or a different computer and need access to the same report catalog database?

Back 11

Backup the report server's encryption key

Front 12

What four options does the Reporting Services Configuration Manager offer for encyption keys?

Back 12

1. Back up the key into a password-protected file
2. Restore a key to rebuild a stand-alone instance
3. Change the key, which will rencrypt the content
4. Dete the encrypted content

Front 13

What command line utility is manages keys?

Back 13

RSKeyMgmt.exe

Front 14

Which tool can change or create virutal directories for the report server and Report Manager after installation?

Back 14

Only Reporting Services Configuration Manager

Front 15

What is the file name extension of an encryption key backup?

Back 15

.snk

Front 16

What are the three administration command-line utilities to assist in configuring SSRS server settings?

Back 16

RSConfig.exe (assists in managing SSRS instance connection to the repository database)
RSKeyMgmt.exe (Assists in managing encryption keys)
RS.exe (Assists in Microsoft .NET scripting of report management operations

Front 17

What are the two RSConfig.exe connection parameters?

Back 17

/m remote server name (name of the server installed with SSRS if its not localhost)
/i instance name

Front 18

What are the seven RSConfig Database connection parameters?

Back 18

/c
/s datbase server name
/d database name
/a Authentication Method
/u username
/p password
/t

Front 19

What does the /c RSConfig.exe database connection paramater indicate?

Back 19

You are defining the connection information with other paramaters)

Front 20

What does the /s database server name RSConfig.exe database connection paramater indicate?

Back 20

Used to ID the SQL Server name and instance of the host Report Server DB)

Front 21

What does the /d database name RSConfig.exe database connection paramater indicate?

Back 21

Name of the Report Server database on the specified SQL Server instance

Front 22

What does the /a Authentication Method RSConfig.exe database connection paramater indicate?

Back 22

Sindows or SQL authentication for connecting to the Report Server database

Front 23

What does the /t RSConfig.exe database connection paramater indicate?

Back 23

Optionally writes out error messages to the SSRS trace log

Front 24

What does the following RSConfig.exe switch do:/e

Back 24

The account will be used for an unattended report execution. You must also use the /u and /p paramaters

Front 25

What does the following RSKeyMgmt.exe switch do: /e

Back 25

specifies that the SSRS encryption key should be extracted to a file for backup

Front 26

What does the following RSKeyMgmt.exe switch do: /a

Back 26

Specifies that the SSRS encryption key should be resoted from a file and overwritten

Front 27

What does the following RSKeyMgmt.exe switch do: /d

Back 27

Deletes the encryption key on the SSRS instance or instances and deletes all encrypted data

Front 28

What does the following RSKeyMgmt.exe switch do: /s

Back 28

Replaces the existing encryption key with a newly generated one and reencrypts all existing content with the new key

Front 29

What does the following RSKeyMgmt.exe switch do: /f file path

Back 29

Specifies the location of the file for the encryption key if the /e or /a parameter is used

Front 30

What does the following RSKeyMgmt.exe switch do: /p file password

Back 30

Specifies the password used to secure the encryption key file so that if the file is found the encryption key is still secure

Front 31

What does the following RSKeyMgmt.exe switch do: /i local SSRS instance name

Back 31

Optional argument used to specify a named instance of SSRS

Front 32

What does the following RSKeyMgmt.exe switch do: /t

Back 32

Captures error to the SSRS trace log

Front 33

What does RS.exe do for you?

Back 33

Lets you script SSRS report operations such as deployment and management and run scripts through the command line

Front 34

What does the following RS.exe switch do: /i input .rss file

Back 34

Specifies the .rss file to execute

Front 35

What does the following RS.exe switch do: /s SSRS server URL

Back 35

Defines the URL path to the SSRS report server virtul directory

Front 36

What does the following RS.exe switch do: /u username

Back 36

Overrides the user running the command to define a different domain\user

Front 37

What does the following RS.exe switch do: /p password

Back 37

specifies password for override username

Front 38

What does the following RS.exe switch do: /l timeout seconds

Back 38

Used to override the default time-out of 60 sseconds
0 is unlimited

Front 39

What does the following RS.exe switch do: /b

Back 39

Runs the commands in a batch so that if a failure occurs anywhere in the script, the entire operatoin rolls back

Front 40

What does the following RS.exe switch do: /e

Back 40

SOAP endpoint

Front 41

What does the following RS.exe switch do: /v Global Variable maping

Back 41

Passes values into embedded variables

Front 42

What does the following RS.exe switch do: /t

Back 42

captures errors in the trace log

Front 43

What are scale-out SSRS deployments and why are they used?

Back 43

Scale-out SSRS deployments involve connecting more than one report server instance to a shared report server catalog, which allows execution load to be shared across multiple servers. This provides more availablilty and scale.

Front 44

What are four elements of a scale-out deployment?

Back 44

NLB Network Load Balancing
Mutliple report server instances on multiple servers
Shared report server catalog
Optionally a MSCS installatoin

Front 45

What does the following RSKeyMgmet.exe Scale-Out instance Management switch do: /j

Back 45

Adds a remote instance of SSRS to the Report Server database of a local instance.

Front 46

What does the following RSKeyMgmet.exe Scale-Out instance Management switch do: /r GUID Installation ID

Back 46

Reomves an instance of SSRS from a scale-out deployment implementation

Front 47

What does the following RSKeyMgmet.exe Scale-Out instance Management switch do: /u account name

Back 47

Specifies the account of a local administrator on the server where the remote SSRS instance runs

Front 48

What does the following RSKeyMgmet.exe Scale-Out instance Management switch do: /v password

Back 48

Defines the password of the local administrator account specified by the /v parameter

Front 49

What does the following RSKeyMgmet.exe Scale-Out instance Management switch do: /m remote SSRS Server Name

Back 49

Specifies the server when connecting to an SSRS instaqnce on a remote computer

Front 50

What does the following RSKeyMgmet.exe Scale-Out instance Management switch do: /n remote SSRS instance name

Back 50

Specifies the SSRS instance name on a remote computer

Front 51

What are the seven XML configuration files to handle advanced service settings, user defaults, and policy implementations?

Back 51

RSReportServer.config
RSSrvPolicy.config
RSMgrPolicy.config
Web.config
ReportingServicesServices.exe.config
RSReportDesigner.config
RSPreviewPolicy.config

Front 52

What does RSReportServer.config do?

Back 52

Primary config file for Report Server Web and Report Manager

Front 53

What does RSSrvPolicy.config do?

Back 53

Stores policy settings for the Report Server Web service

Front 54

What does RSMgrPolicy.config do?

Back 54

Contains plicy settings for the Report Manager application

Front 55

What does Web.config do?

Back 55

Contains ASP.NET settings for the Report Server and Report Manager

Front 56

What does ReportingServicesServices.exe.config do?

Back 56

Contains trace and logging settings for the Report Server service

Front 57

What does RSReportDesigner.config do?

Back 57

Contains configuration settings such as rendering devices for the Report Designer application

Front 58

What does RSPreviewPolicy.config do?

Back 58

Contains security policies for the server extensions

Front 59

Which RS config file does SSRS 2008 NOT use?

Back 59

RSWebApplication.config

Front 60

Which config file contains many more advanced settings and properties that are not available to set within Reproting Services Configuration Manager or through the report server properties in SSMS?

Back 60

RSReportServer.config

Front 61

Where would you go to prevent rendering reports in Microsoft Excel or other formats?

Back 61

RSReportServer.config
Add a Visible="false" entry to the line