SQL Server Client Interviews - gsraocse/Interview-Questions GitHub Wiki

  1. Self Introduction

NAme, Experiance, ....

  1. Tell me the one challange which you faced in your project
    • Recently we observed that one of the table(which contains 2 million rows) from system is locking frequently
    • This table contains 4 different sources of data
    • We have used paritioning logic to avoid locking on that system

Questions related to above points:

  1. What are the source system types

    • SQL servers

  2. What is the SQL version it contains

    • SQL server 2008

  3. Why it was not observed during testing/analaysis phase - This was the issue we have seen in migration project - We have fixed this issue by using partitions

  4. Why it was locking - We do delta and Full loads to this table - Same table we have used in front end application - While deleting the rows from that table if any one access that front end application it is locking

  5. How will you reduce that lokcing?

    • By reducing the transactiion batch size

  6. What kind of steps will you do in Data quality testing

    • First we do row counts between source and target tables
    • Will compare Column wise data
    • Will check the NULLability ratio for every column

  7. What tool will you use for data quality testing

    • We have used SSIS package to test and inside we have used stored procedures to do data quality

  8. after completing unit testing,whom will you pass that solution for next steps -We will pass it to QA people for testing

  9. Who will deploy the solution and how will you give solution

    • Deployment team from client side will take care of deployment.
    • We will provide all the setup files for deployment and Deployment document with steps to follow in order to deploy the files
    • We will also provide pre-deployment and post deployment check list
    1. What will you provide in pre-deployment and post deployment checklist
      • Dependency tables related scripts
      • Base data which is need for deployment
      • Post deployment what are all the changes needs to be verified. Like all the objects are deployed properly

  10. What are the things you do to understand the system which you don't know any thing (New system)

  • First will try to understand the data in the system
  • Relate data flows
  • we Will get clarification from SME(business side)
  1. How much rating will you give for SQL server
  • I can give 8/10
  1. How will you understand the requirements
  • First we will receive User stories from Business user
  • We will go through the user story and will ask clarifications if we have
  • We will also suggest some of the gaps which we see in the User story
  • All the user stories will be maintained in TFS (Team foundation server)
  • all the details will be maintained in TFS