What should the company do to achieve this in the shortest amount of time?

Correct Answer for the Question – What should the company do to achieve this in the shortest amount of time? is given below A large company is using an Amazon RDS for Oracle Multi-AZ DB instance with a Java application. As a part of its disaster recovery annual testing, the company would like to simulate an … Read more

How should the Database Specialist apply the parameter group change for the DB instance?

Correct Answer for the Question – How should the Database Specialist apply the parameter group change for the DB instance? is given below A Database Specialist modified an existing parameter group currently associated with a production Amazon RDS for SQL Server Multi-AZ DB instance. The change is associated with a static parameter type, which controls the … Read more

What should a Database Specialist recommend for this user?

Correct Answer for the Question – What should a Database Specialist recommend for this user? is given below A user has a non-relational key-value database. The user is looking for a fully managed AWS service that will offload the administrative burdens of operating and scaling distributed databases. The solution must be cost-effective and able to handle … Read more

How can the Database Specialist ensure that failovers occur with the least amount of downtime for the application?

Correct Answer for the Question – How can the Database Specialist ensure that failovers occur with the least amount of downtime for the application? is given below A Database Specialist needs to speed up any failover that might occur on an Amazon Aurora PostgreSQL DB cluster. The Aurora DB cluster currently includes the primary instance and … Read more

Which solution will meet these requirements and is the MOST operationally efficient?

Correct Answer for the Question – Which solution will meet these requirements and is the MOST operationally efficient? is given below A company is using 5 TB Amazon RDS DB instances and needs to maintain 5 years of monthly database backups for compliance purposes. A Database Administrator must provide Auditors with data within 24 hours. Which … Read more

Which migration method should a Database Specialist use?

Correct Answer for the Question – Which migration method should a Database Specialist use? is given below A company is running its line of business application on AWS, which uses Amazon RDS for MySQL at the persistent data store. The company wants to minimize downtime when it migrates the database to Amazon Aurora.Which migration method should … Read more

Which steps should be taken in the AWS Management Console to meet the disaster recovery requirements?

Correct Answer for the Question – Which steps should be taken in the AWS Management Console to meet the disaster recovery requirements? is given below A company is hosting critical business data in an Amazon Redshift cluster. Due to the sensitive nature of the data, the cluster is encrypted at rest using AWS KMS. As a … Read more

How should the Database Specialist optimize the database migration using AWS DMS?

Correct Answer for the Question – How should the Database Specialist optimize the database migration using AWS DMS? is given below A company is looking to migrate a 1 TB Oracle database from on-premises to an Amazon Aurora PostgreSQL DB cluster. The company’s Database Specialist discovered that the Oracle database is storing 100 GB of large … Read more

How can the Database Specialist schedule these jobs so the setup requires minimal maintenance and provides high availability?

Correct Answer for the Question – How can the Database Specialist schedule these jobs so the setup requires minimal maintenance and provides high availability? is given below A Database Specialist has migrated an on-premises Oracle database to Amazon Aurora PostgreSQL. The schema and the data have been migrated successfully. The on-premises database server was also being … Read more

How should the Database Specialist satisfy this new requirement?

Correct Answer for the Question – How should the Database Specialist satisfy this new requirement? is given below A Database Specialist migrated an existing production MySQL database from on-premises to an Amazon RDS for MySQL DB instance. However, after the migration, the database needed to be encrypted at rest using AWS KMS. Due to the size … Read more