SQL Server Reporting Services(SSRS) interview questions

Difference between query parameter and report parameter in SSRS?

Query parameter is used to filter data in the data source.

Report parameter is to add interactively, users can change report behavior based
 on selected options.

What type of roles available in SSRS 2008?

System Administrator role 

System user role-

•  Browser
•  Content Manager
•  My Reports
•  Publisher
•  Report Builder

What are the different ways to deploy a report?

Using Bids by giving target URL.

By uploading .rdl file from Report Manager.

What are the different types of Processing Modes in SSRS 2008?

Local Processing Mode

Remote Processing Mode

Are SSRS dataset queries running parallel?

By default running parallel y. We can use data source property Use Single Transaction when Processing the queries option to run sequentially.