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

Best 30 AWS Cloud Database Interview Questions

AWS Cloud DBA/Database Interview Questions - part 2

Q21. How to perform point-in-time recovery (PITR) of the RDS database?

answer:

Q22. What is the advantage and disadvantage of the Aurora Global cluster?

answer:

Q23. How to create and maintain AWS resources?

answer:

Q24. What is Terraform/IaC (Infrastructure as Code)? How do you manage Cloud resources using Terraform?

answer:

Q25. What are the providers/modules in Terraform?

answer:

Q26. What are the different storage classes in S3 storage? 

answer:

Q27. What are latency and throughput in Cloud computing?

answer:

Q28. What are the Cloudwatch Metrics you are monitoring for your databases?

answer:

Q29. What is Aurora serverless option? what are the advantages of Aurora serverless?

answer:

Q30. How do you encrypt an unencrypted RDS database instance?

answer:

Q31. What is Host Based Access (HBA) control in Postgres databases? Do we need to enable/use HBA in AWS PostgreSQL RDS instances?

answer:

Q32. 

answer:

Q33. 

answer:

Related Database Articles:  Cloud DBA - AWS Database Interview Questions - Part 1