Real Time Interview Questions

Question

Hi Guys,

I want to know where can I get real time questions for SSRS and SSIS for experienced candidates?

Please share links and some interview questions which you came across?

I am not asking theoretical questions but some questions like after transferring data from various source to SQL Db  what you will do ?

---

SQL BI Developer (Starting to learn more about SQL&BI)

Answer 1

Google should be your friend here ....

But i would refer Aamir Shahzad webiste (TechBrothersIT.Com) ; also apart from this i would advice you to follow the blogs of all the Master's in this forum Like Visakh Sir ,Naomi N ,Shanky,ArthurZ etc ... regularly that would diffenetly help you.

Answer 2

Hi Guys,

I want to know where can I get real time questions for SSRS and SSIS for experienced candidates?

Please share links and some interview questions which you came across?

I am not asking theoretical questions but some questions like after transferring data from various source to SQL Db  what you will do ?

---

SQL BI Developer (Starting to learn more about SQL&BI)

You can get it here but real time experience comes from real time working. Apart from reading various blogs you should get hands on on SQL Server and start transferring data by yourself using import export wizard. Self help is best help

Below link should get you started

https://www.mssqltips.com/sqlservertip/2485/ssis-interview-questions--part-1/

Forum will always help you but make sure you ask logical question, try to answer it yourself if you cannot come and post the question on forum you will get help

Best of Luck

---

Cheers,

Shashank

Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

My TechNet Wiki Articles
MVP

Answer 3

Hi Shanky-621,

If you are an interviewer what are all the real time interview questions you will ask for 6 years experienced candidate?

I too agree experience comes only by real time working. Expecting some real time interview questions from you.

---

SQL BI Developer (Starting to learn more about SQL&BI)

Answer 4

Hi Nandhini Madan,

Every interviewer can be different and might ask you questions related to their environment. Let's say if they are dealing with Excel files and they need to load tons of excel files, the interviewer can ask you questions on Excel source, script Task, Expressions etc. 

If the company is  extract data from Oracle, they might ask you ,How to get data from oracle and which source works best?

If you are challenging yourself to prepare as Sr. BI developer, Then don't try to find the answers of questions, try to perform the tasks and learn the skills as Shanky_621 said above.

I have written tons of questions,detailed answers and  real time demos on SSIS/ SSRS but still I can say there are so many questions an interviewer can ask which you will only learn with experience.

These resources might help you

SSIS INTERVIEW QUESTIONS

SSIS Tutorial Scenario Based

SSRS Detailed Tutorial

SSRS Interview Questions/Answers

 

---

Good Luck!


TechBrothersIT.com

Answer 5

Thank you so much. I was searching for this type interview questions only :)

---

SQL BI Developer (Starting to learn more about SQL&BI)

Answer 6

Here you can find some more Interview questions regarding SSRS.