Interview with LTIMindtree

1. How do you migrate 16 TB Database from On prem to Cloud? 2. How do you optimize the backups and restores during the migrations to reduce the cutover window? Ans: There are 6 optimization methods for the same 1. Split Backups 2. Striped backups on multiple disks 3. Compressed backups 4. Stop SQL Services, Copy(snapshots) data and logs disks to new server and attach 5. Take Snapshots of the backup drives and attach to destination server and restore 6. ??? 3. what tools or methods you use to migrate from On Prem to Cloud Azure IaaS, PaaS and Managed Instnace? 4. Differnece Between General purpose and Business critical managed instnaces? 5. Limitations of Managed Instnace? 6. DMA (depricated), DMS with PowerShell, Azure Data Studio Migration extension, DBATOOLS.IO for migrations 7. What is the preliminary analysys that is required before migrating the databases from DBA perspective? 8. What are the events captured in SOX Audit? 9. What are the automation tools you are aware along with PowerShell? 10. How do you migrate TDE with Azure Keyvault databases? 11. How comfortable in handling alone and contributing for new age solutions for client? 12. What is your exposure in engineering work and team? 13. do you have experience in Terraform? 14. What is Contained Availability group? 15. Difference between On Prem Availability group and Azure AlwaysOn Availability groups? Load Balancer Multi Subnet configurations 16. What are the type of Availablity group you configured? 17. How many IPs you need to configure Listener with HADR (multi subnet vs Single Subnet)? 18. How do you migrate SQL objects? 19. Can we migrate SQL Maintenance plans and how? 20. Can we migrate Linked servers of Non MS SQL subscribers? if so, how? 21. How do you migrate linked servers? 22. How big the DB and SQL VM(SKU) that are being supported in your environment? 23. What is the Seris of the VMs that hosts the biggest databases? 24. As a solutions architect how comfortable you are in handling engineering work? 25. What is the difference between Basic Vs Standard Vs Contained Availability group? 26. How do you build foundation for migration plan including assessment and feasibility study? 27. How do you assess and ensure migration will be successful or identify road blocks and address before actual migration? 28. What are the tools or methods that can be used for migration assessment? 29.