SSRS Interview Question

1. What programming language would you use to create embedded functions in SSRS?
   visual Basic .Net used to create  embedded code in SSRS
2. What is the purpose of query parameter in ssrs?

Query parameter is used to filter the data in data source

3. What is the main difference between a Matrix report item and a Table report item? 

              both report items are just templates for the Tablix data region.            tabular report is the most basic type of report. Each column corresponds to a column selected from the database. A matrix (cross-product) report is a cross-tabulation of four groups of data: a. One group of data is displayed across the page

4.      What is the benefit of embedded code in the ssrs  reports?

Once we write the code in reports we can use the code in any expression in that report.

5.      How to display the amount in currency format and for that which property do you use?

For currency format in ssrs reports select the report item and then set the format property to  C.

6.      Can you use stored procedures in ssrs reports to get the data?

Yes, we can use stored procedures in ssrs reports and it should return only a single result.

7.      By which  we can use to generate reports in ssrs?

Reports can be developed by using tables,cubes,textfiles etc.,

8.      What is .rdl file?

Every report saved with .rdl extension in reporting services. RDL means Report Definition  Language.

9.      How many types os parameters in ssrs reports?

Single value parameters, multi value parameters, cascading parameters

10  what are the different stages in ssrs report processing

     Compile, process,render and export

SQL Server real time question

I have one doubt of SQL SERVER DBA

I am settings in backup every Sunday 12 am fullback up.

And  for every 6 hours differential backup.

And for every 15 mints  log back up.

 If my server crashes at Thursday 4.30 pm...How to recovery and restore the backup.

SQL SEVER INTERVIEW QUESTION

1. What is  the default "SORT" order for SQL SEVER?


2. select adresses which are between  " 1/1/2015" and "1/04/2015" ?

3.why should you use CTE rather than using simple views?

sql server to day question

CREATE TABLE mytable ( id INT, name VARCHAR(10) );

 GO

 INSERT mytable ( id, name )

 VALUES 

 ( 1, 'S' ), 

 ( 2 , 'P'),

 ( NULL, 'Q' ), 

 ( 4, 'T' ), 

 ( NULL, 'M' ), 

 ( 6, 'N' ); 

 SELECT COUNT(*) FROM mytable;

ANSWER: 
1) 2

2) 4

3) 6

4) NULL


post the right answer

SSIS Real Time Question

How do I access Microsoft Excel 2007 from SSIS 2005 version. I am unable to access the files from SSIS

ANS:
Use ACE connector for Excel.
ACE OLEDB 12.0:

TYPE OLE DB ProviderUSAGE Provider=Microsoft.ACE.OLEDB.12.0MANUFACTURER Microsoft 

Xlsx files

This one is for connecting to Excel 2007 files with the Xlsx file extension. That is the Office Open XML format with macros disabled.

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myExcel2007file.xlsx;
Extended Properties="Excel 12.0 Xml;HDR=YES";

"HDR=Yes;" indicates that the first row contains columnnames, not data. "HDR=No;" indicates the opposite.

SSRS Real time scenarios

SSRS (SQL Server Reporting Services)Real Time Scenarios:

Scenario 1:

 Show the report like Drill Down. Here I have 3 groups as shown in below.

Main Category Name 

     +  Sub Category Name1

               + Sub Details1

                             Details1Name     rate      qty    amount

                +Sub Details2

                               Details1Name     rate      qty    amount

                +SubDetails3

                               Details1Name     rate      qty    amount

       +SubCategory Name2

       +Sub Catagory Name3   

             .....


Scenario 2:

I have an SSRS Report that needs to be filtered via multi-value parameter selection. normally we can done for single column. But here we want to allow multi-select based on multiple columns. The column layout is as follows:

AFLAG    BFLAG    CFLAG     DFLAG
X                X               X           X
NULL          X             NULL      NULL
X               NULL           X         NULL
X                X                X         X
X              NULL            X         NULL
NULL         X                X          NULL
X               X               NULL     NULL
X               X               NULL    NULL

In my report parameter, when multiple AFLAG, BFLAG, CFLAG or DFLAG values are selected, I want to be able to display every Reports that contains an 'X' in each column once, where there are multiple values marked with 'X' in a single report.


Scenario 3:

Testing Procedure In SSIS

Test cases For SSIS Project :

Testing For a SSIS project Is very important question in interviews.


 @ Verify all the tables have been imported

@ Verify all the rows in each table have been imported

@ Verify all columns specified in source query for each table have been imported

@ Verify all the data have been recived without any truncation for each column

@ Verify the schema at source and destination

@ Verify the time taken /speed for data transfer

@ Fields truncated due to diffence in length of the field.