30 Top Cloud DBA Database Interview Questions

AWS Cloud DBA/Database Interview Questions - Part 1

Q1. What are the advantages of cloud computing?

answer:

Q2. What is the database storage in AWS cloud? where are the RDS instance datafiles stored?

answer:

Q3. What database metrics will you be monitoring?

answer:

Q4. How will you check database performance issues/bottlenecks in AWS console?

answer:

Q5. Which EC2 instance type/class is the best for databases?

answer:

Q6. How to enforce the security of RDS instances? 

answer:

Q7. How to encrypt data-at-rest in the cloud?

answer:

Q8. How to encrypt data-in-transit / data-in-motion in the cloud?

answer:

Q9. What is the difference/advantages between RDS instance and database running on EC2?

answer:

Q10. What is the difference between "General purpose" and "Provisioned IOPS" storage?

answer:

Q11. What is the advantage of Multi-AZ instance in AWS?

answer:

Q12. How do we export and import data/snapshots from production to non-production environments in different AWS accounts?

answer:

Q13. Please explain the main differences between RDS MySQL and AWS Aurora?

answer:

Q14. What are the main differences between RDS PostgreSQL and Amazon Aurora?

answer:

Q15. How to setup MySQL replication between two Amazon Aurora MySQL clusters?

answer:

Q16. How to setup logical replication between two AWS Aurora Postgres clusters?

answer:

Q17. How can you migrate data from MySQL RDS and Aurora MySQL?

answer:

Q18. How will you update the database parameter value of (Oracle) RDS instance?

answer:

Q19. 

answer:

Q20. 

answer:

Related DBA Articles: PostgreSQL/Aurora Postgres DBA Interview Questions   AWS DBA Database Interview Questions - Part 2