SSIS Questions frequently asked in microsoft interviews:
1. What is checkpoint in SSIS and how do you configure a checkpoint?
2. What are transactions?
3. How do you define transactions in SSIS?
4. What is logging in SSIS and how do you log events?
5. What is CDC (Change Data Capture)?
6. Explain how do you automate CDC?
7. How you will test the SSIS packages?
8. After data loading, what will you test?
9. Given a scenario to define ER Model for the scenario like “A College is organizing a Band”.
10. Prepare the necessary Model with required attributes.
Tags: SSIS Interview Questions and Answers At Microsoft, Microsoft, Interview Questions and Answers At Microsoft, SSIS, SSIS Interview Questions, SSIS QA, SSIS Interview Questions and Answers, SSIS Tutorial, SSIS books, SSIS Interview Questions pdf, SSIS experienced QA, interview questions, SSIS interview questions for experienced, SSIS interview questions for developers,SSIS interview questions for freshers,SSIS interview questions senior level, SSIS Certification Questions, Basic SSIS interview questions, SSIS interview questions 2 3 4 5 6 years experienced, SSIS Real time interview questions, SSIS Interview Questions and Answers At Microsoft 2015, Latest SSIS Questions At Microsoft Interview.
1. What is checkpoint in SSIS and how do you configure a checkpoint?
2. What are transactions?
3. How do you define transactions in SSIS?
4. What is logging in SSIS and how do you log events?
5. What is CDC (Change Data Capture)?
6. Explain how do you automate CDC?
7. How you will test the SSIS packages?
8. After data loading, what will you test?
9. Given a scenario to define ER Model for the scenario like “A College is organizing a Band”.
10. Prepare the necessary Model with required attributes.