Amazon Aurora
| Overview |
|---|
| Amazon Aurora is a MySQL and PostgreSQL-compatible relational database built for the cloud, that combines the performance and availability of traditional enterprise databases with the simplicity and cost-effectiveness of open source databases. |
1. A company has a requirement for a managed database in AWS. It is also required that joins need to be performed on the underlying queries. Which of the following can be used as the underlying database?
A. AWS Aurora
B. AWS DynamoDB
C. AWS S3
D. AWS Redshift
2. A company is migrating an on-premises 10TB MySQL database to AWS. With a business requirement that the replica lag be under 100 milliseconds, the company expects this database to quadruple in size.
Which Amazon RDS engine meets the above requirements?
A. MySQL
B. Microsoft SQL Server
C. Oracle
D. Amazon Aurora
3. A company is migrating an on-premises 5TB MySQL database to AWS and expects its database size to increase steadily. Which Amazon RDS engine meets these requirements?
A. MySQL
B. Microsoft SQL Server
C. Oracle
D. Amazon Aurora
4. A company is migrating an on-premises MySQL database to AWS. Following are the key requirements:
a) Ability to support an initial size of 5TB
b) Ability to allow the database to double in size
c) Replication Lag to be kept under 100 milliseconds
Which Amazon RDS engine meets these requirements?
A. MySQL
B. Microsoft SQL Server
C. Oracle
D. Amazon Aurora
5. A company is planning on moving their PostgreSQL database to AWS. They want to have the ability to have Replicas for the database and automated backup. Which of the following databases would be ideal for this scenario?
A. AWS Aurora
B. AWS PostgreSQL
C. AWS DynamoDB
D. AWS Redshift
6. A company wants to have a fully managed data store in AWS. It should be a compatible MySQL database, which is an application requirement. Which of the following databases can be used for this purpose?
A. AWSR DS
B. AWS Aurora
C. AWS DynamoDB
D. AWS Redshift
7. A database is required for a Two-Tier application. The data would go through multiple schema changes. The database needs to be durable, ACID compliant and changes to the database should not result in database downtime. Which of the following is the best option for data storage?
A. AWS S3
B. AWS Redshift
C. AWS DynamoDB
D. AWS Aurora
8. An application needs to have a Data store hosted in AWS. The following requirements are in place for the Data store:
a) An initial storage capacity of 8 TB
b) The ability to accommodate a database growth of 8GB per day
c) The ability to have 4 Read Replicas
Which of the following Data stores would you choose for this requirement?
A. DynamoDB
B. Amazon S3
C. Amazon Aurora
D. SQL Server
9. An application requires a highly available relational database with an initial storage capacity of 8TB. This database will grow by 8GB everyday. To support the expected traffic, at least eight read replicas will be required to handle the database reads. Which of the below options meets these requirements?
A. DynamoDB
B. Amazon S3
C. Amazon Aurora
D. Amazon Redshift
10. In Below are the requirements for a data store in AWS:
a) Ability to perform SQL queries
b) Integration with existing business intelligence tools
c) High concurrency workload that generally involves reading and writing all columns of a small number of records at a time
Which of the following would be an ideal data store for the above requirements? Choose 2 answers from the options below.
A. AWS Redshift
B. AWS RDS
C. AWS Aurora
D. AWS S3
11. Your company currently has data hosted in an Amazon Aurora MySQL DB. Since this data is critical, there is a need to ensure that it can be made available in another region in case of a disaster. How can this be achieved?
A. Make a copy of the underlying EBS Volumes in the Amazon Cluster in another region.
B. Enable Multi-AZ for the Aurora database.
C. Creating a read replica of Amazon Aurora in another region.
D. Create an EBS Snapshot of the underlying EBS Volumes in the Amazon Cluster and thencopy them to another region.