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?

DBA Interview with RevitUP

1. What is Physical DB Architecture and explain? What are the pagefile information? 2. What is Checkpoint and sequence of operations when Checkpoint is run? 3. Types of Checkpoints? 4. How do you connect to IBM DB2 for data retriveral or update/Insert? 5. WHat is Transactional replication and how it works? 6. WHat are the types of ISOLATIONS and use of them? 7. WHen do you use each of them? 8. How do you plan SQL Server migration and ensure perfect migrations? Logins Objects Credentials Configurations Drives Capacity OnPrem to Azure (IaaS) On Prem to Azure PaaS DMA DMS BACKPAC EXPORT 9. Have you worked on DB Partitioning and how does it work? 10. How do you check IO Statistics of the Servers and how do you ensure it's healthy? 11. what are L1, L2 and L3 Administrator Roles? 12. How do you rate yourself on PowerShell? 13. Have you involed in Automation activties? 14. What kind of activities are automated through PowerShell? 15. What is tail log backup? 16. TEMPDB Best practices? 17. How do you migrate databases to Azure Databases? 18. How do you migrate Large Databases? 19. How do you tune SQL Query? 20. How do you check Dead Locks? 21. How do you fix dead locks as a DBA? 22. WHat are the monitoring tools used? 23. How do you fix BD corruption issues? 24. If you don't have any details in logs, how do you check and fix the DB Corruption issues? 25. How does Query Optimizer works and work flow of Query Optimizer? 26. Explore on entier SQL Architectrure DB Architecture Log File Architecture Data File Architecture 27.