SQL Server Reporting Services (SSRS) Interview Questions

 
1.
What can SQL Server Reporting Services do?
2.
Explain the architecture of reporting services?
3.
Describe Reporting Lifecycle?
4.
What are the ways to tune Reporting Services?
5.
How to schedule SSAS Database backup.
6.
How to Generate an Auto Incremental Number in a SSIS Package?
7.
Lookups are a key component in SQL Server Integration Services (SSIS). Explain its purpose?
8.
How to unzip a File in SSIS?
9.
Define Truncate and Delete commands?
10.
What are the ways to controlling Cursor Behavior?
11.
Define Identity and uniqueidentifier property of Column?
12.
What happens when my integer IDENTITY runs out of scope?
13.
What are the advantages of using Stored Procedures?
14.
Describe the purposes and advantages stored procedure?
15.
What is RAID (Redundant Array of Inexpensive disks)? Explain its level?
16.
What is RAID controller technology?
17.
What is RAID and what are different types of RAID configurations?