Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
49 Cards in this Set
- Front
- Back
|
What are the two types of role definitions in SSRS?
|
Item-level roles which assign permissions on report objects and system level-roles which are used to assign usrs to site-wide functionality
|
|
|
What tool is used to modify, delete, or create roles?
|
SSMS
|
|
|
What tool is used to assign roles to users or groups?
|
Report Manager Web interface
|
|
|
What are the default five item-level roles in SSRS?
|
1. Browser
2. Content Manager 3. My Reports 4. Publisher 5. Report Builder |
|
|
What does the Consume Reports task involve?
|
Reads report definitions
|
|
|
What is the minimum task requirements for a new role?
|
A new item-level role requires that at least one task is assigned to the role definition
|
|
|
Which is the only role that has users assigned to it by default?
|
The Content Manager role with the BUILTIN\Administrators gropu in it
|
|
|
What do system-level role definitions reference and what is their scope?
|
System-level role definitions reference the se of permissions or tasks related to the server's administrative objects and are scoped outside the report object hierarchy
|
|
|
Where do you manage system-level roles?
|
SSMS, not Report Manager
|
|
|
What are the two default system-level roles in SSRS?
|
System Adminsitrator
System User |
|
|
What two permissions would you need to execute a report?
|
System-level report execution task and object-leel permission to the specifc report
|
|
|
What are the nine tasks for system-level roles in SSRS 2008?
|
Execute Report Defninitions
Generate Events Manage jobs Manage report server properties Manage report server security Manage roles Manage shared schedules View report server properties View shared schedules |
|
|
Where are Server permissions assigned to System-Level roles?
|
Report Manager
|
|
|
What is the internal filename for the My Reports folder?
|
Users Folders\domain username\
|
|
|
What are linked reports?
|
Entities that reference an existing report but with different configurations
|
|
|
Where is the rport definition stored for a linked report?
|
The .rdl is stored in the base report
|
|
|
When do the My Reports folder and Linked Reports work together for a particular kind of user?
|
If the user does not have permission to write to public folders, they can still store linked servers inside their My Reports
|
|
|
What are shared data sources?
|
Objects that represent the connection information to a data repository that a report will use. These data sources are stored in the Reporting Services ReportServer database
|
|
|
What two items must you define to connect to a data repository?
|
Name of the service to which you can connect and the credentials used to access that repository
|
|
|
What are the four mechanisms for specifying the credentials used to access the data repository?
|
Credentials supplied by the user running the report
Credentials stored securely in the report server Windows integrated security (Kerberos is required if the data repository is on another computer Credentials not required |
|
|
What are three requirements for executing reporting on a schedule?
|
SQL Server Agent must be running
The report server must be configured to support scheduling and delivery operations New credentials must be stored on the report server because SSRS cannot rely on current user credential to run scheduled reports |
|
|
What privileges would you give a database login for running the scheduled reports?
|
Read access to the ReportServer database
Read access to the msdb database Read access to all objects from all databases included in a report |
|
|
What level of permission do you need to create a shared schedule?
|
System-level permissions
|
|
|
Where do you go to define a report-specific schedule?
|
The execution properties of a report which are set in Report Manager
|
|
|
Do subscriptions represent a push delivery model or a pull delivery model?
|
Push delivery model
|
|
|
How can you use subscriptions to improve performance for end users?
|
Set the delivery channel to Null so that the report is not delivered anywhere but is loaded in the cache on a schedule
|
|
|
What four things must be specified for a subscription?
|
1. Delivery method
2. Rednering type 3. Conditions for processing the subscriptions (Either on a schedule or when a snapshot is updated on the report server) 4. Values for paramaters if the report is parameterized |
|
|
Where are report subscriptions set?
|
Report manager
|
|
|
If you use the file share delivery method, what must you specifiy?
|
A universal naming convention (UNC) name for the share
Windows user credentials that SSRS will use to access the share |
|
|
How many queries can you use for any one data-driven subscription?
|
Only one query
|
|
|
What sources could you use for data in a data-driven subscription?
|
SQL Server relational data
SSAS database SSIS package data Oracle ODBC data sources OLE DB data sources |
|
|
What happens if you do not specifiy a paramater value in a subscription and the parameter does not have a deafult value?
|
The execution will fail
|
|
|
When you try to create a subscription to a report, the New Subscription option is dimmed. Why?
|
The report probably does not use stored credentials for accessing the data. SSRS needs these credentials stored in its own ReportServer database to execute a report on a schedule
|
|
|
What can you do if your query with properties for a data-driven subscription does not provide values for all the subscription properties?
|
Use static text and default values instead.
|
|
|
What seven steps does a report with default execution settings go through?
|
1. Report server recieves a request (usually HTTP)
2. Report Server validates the properties associated with the object 3. Report server access the SQL DB (ReportServer) and gets the RDL 4.Resport Server gets the data sources from the definition 5. Reporting Services connects to data sources and exutes the command 6. The data is mixed with the RDL to generate intermediate format 7. Report is rendered in final format |
|
|
What two mechanisms does Reporting Services use to reduce overhead?
|
Report caching and report snapshots
|
|
|
What does Report Caching cache?
|
All the data but not rendering information
|
|
|
What three ways caches can expire?
|
1. Specified number of minutes pass
2. Report-specific schedule 3. Through a shared schedule |
|
|
When should you modify the Reporting Services catalg database?
|
Don't! It could make the reporting services installation invalid
|
|
|
What do report snapshots do for performance?
|
The first user already has copy of the report in the cache so he doesn't have to wait for it to be generated
|
|
|
Suppose you want to create consistent copies of a report for comparison purposes. What do you use?
|
snapshots
|
|
|
What are two differences between cach and snapshots?
|
Snapshots are stored in the ReportServer database rather than in the temporary database
Snapshots do not allow changes in the query paramaters used to render the report while cache does |
|
|
Can you compare data from different snapshots?
|
No
|
|
|
What three behaviors can be associated with report history?
|
1. enable the New Snapshot button by slecting "Allow Report History To Be Created Manually" check box
2. "Store All Report Snapshot In History" 3. "Use The Following Schedule to Add Snapshots To Report History" |
|
|
Why set a limit on the maximum execution time for a report?
|
To limit the impact of a runaway query
|
|
|
Where can you set a Report Time-out?
|
Either at the report level (execution page on the properties tab for the report) or at the server level on the Site Settings page
|
|
|
How do you remove the item-level task Create Linked Reports from a given role?
|
Use the Content Manager item-level role
|
|
|
Can you create cache versions and snapshots of linked reports?
|
Yes
|
|
|
Can you alays create a cache of a report?
|
No, you can create a cache of a report only when certain requirements, such as having credentials stored in the Report Server, are met
|
