An ecommerce company has tasked a Database Specialist with creating a reporting dashboard that visualizes critical business metrics that will be pulled from the core production database running on Amazon Aurora. Data that is read by the dashboard should be available within 100 milliseconds of an update.
The Database Specialist needs to review the current configuration of the Aurora DB cluster and develop a cost-effective solution. The solution needs to accommodate the unpredictable read workload from the
reporting dashboard without any impact on the write availability and performance of the DB cluster.
Which solution meets these requirements?

1. A. Turn on the serverless option in the DB cluster so it can automatically scale based on demand.
2. B. Provision a clone of the existing DB cluster for the new Application team.
3. C. Create a separate DB cluster for the new workload, refresh from the source DB cluster, and set up ongoing replication using AWS DMS change data capture (CDC).
4. D. Add an automatic scaling policy to the DB cluster to add Aurora Replicas to the cluster based on CPU consumption.

Correct Answer: A

A company has a production environment running on Amazon RDS for SQL Server with an in-house web application as the front end. During the last application maintenance window, new functionality was added to the web application to enhance the reporting capabilities for management. Since the update, the application is slow to respond to some reporting queries.
How should the company identify the source of the problem?

1. A. Install and configure Amazon CloudWatch Application Insights for Microsoft .NET and Microsoft SQL Serve
2. B. Use a CloudWatch dashboard to identify the root cause.
3. C. Enable RDS Performance Insights and determine which query is creating the proble
4. D. Request changes to the query to address the problem.
5. E. Use AWS X-Ray deployed with Amazon RDS to track query system traces.
6. F. Create a support request and work with AWS Support to identify the source of the issue.

Correct Answer: B
Amazon RDS Performance Insights is a database performance tuning and monitoring feature that helps you quickly assess the load on your database, and determine when and where to take action. Performance Insights allows non-experts to detect performance problems with an easy-to-understand dashboard that visualizes database load. https://aws.amazon.com/rds/performance-insights/

A company wants to automate the creation of secure test databases with random credentials to be stored safely for later use. The credentials should have sufficient information about each test database to initiate a connection and perform automated credential rotations. The credentials should not be logged or stored anywhere in an unencrypted form.
Which steps should a Database Specialist take to meet these requirements using an AWS CloudFormation template?

1. A. Create the database with the MasterUserName and MasterUserPassword properties set to the default value
2. B. Then, create the secret with the user name and password set to the same default value
3. C. Add aSecret Target Attachment resource with the SecretId and TargetId properties set to the Amazon Resource Names (ARNs) of the secret and the databas
4. D. Finally, update the secret’s password value with a randomly generated string set by the GenerateSecretString property.
5. E. Add a Mapping property from the database Amazon Resource Name (ARN) to the secret AR
6. F. Then, create the secret with a chosen user name and a randomly generated password set by the GenerateSecretString propert
7. G. Add the database with the MasterUserName and MasterUserPassword properties set to the user name of the secret.
8. H. Add a resource of type AWS::SecretsManager::Secret and specify the GenerateSecretString property.Then, define the database user name in the SecureStringTemplate templat
9. I. Create a resource for the database and reference the secret string for the MasterUserName and MasterUserPassword propertie
10. J. Then, add a resource of type AWS::SecretsManagerSecretTargetAttachment with the SecretId and TargetId properties set to the Amazon Resource Names (ARNs) of the secret and the database.
11. K. Create the secret with a chosen user name and a randomly generated password set by the GenerateSecretString propert
12. L. Add an SecretTargetAttachment resource with the SecretId property set to the Amazon Resource Name (ARN) of the secret and the TargetId property set to a parameter value matching the desired database AR
13. M. Then, create a database with the MasterUserName and MasterUserPassword properties set to the previously created values in the secret.

Correct Answer: C

A corporation intends to migrate a 500-GB Oracle database to Amazon Aurora PostgreSQL utilizing the AWS Schema Conversion Tool (AWS SCT) and AWS Data Management Service (AWS DMS). The database does not have any stored procedures, but does contain several huge or partitioned tables. Because the program is vital to the company, it is preferable to migrate with little downtime.
Which measures should a database professional perform in combination to expedite the transfer process? (Select three.)

1. A. Use the AWS SCT data extraction agent to migrate the schema from Oracle to Aurora PostgreSQL.
2. B. For the large tables, change the setting for the maximum number of tables to load in parallel and perform a full load using AWS DMS.
3. C. For the large tables, create a table settings rule with a parallel load option in AWS DMS, then perform a full load using DMS.
4. D. Use AWS DMS to set up change data capture (CDC) for continuous replication until the cutover date.
5. E. Use AWS SCT to convert the schema from Oracle to Aurora PostgreSQL.
6. F. Use AWS DMS to convert the schema from Oracle to Aurora PostgreSQL and for continuous replication.

Correct Answer: CDE

An IT consulting company wants to reduce costs when operating its development environment databases. The company’s workflow creates multiple Amazon Aurora MySQL DB clusters for each development group. The Aurora DB clusters are only used for 8 hours a day. The DB clusters can then be deleted at the end of the development cycle, which lasts 2 weeks.
Which of the following provides the MOST cost-effective solution?

1. A. Use AWS CloudFormation template
2. B. Deploy a stack with the DB cluster for each development group.Delete the stack at the end of the development cycle.
3. C. Use the Aurora DB cloning featur
4. D. Deploy a single development and test Aurora DB instance, and create clone instances for the development group
5. E. Delete the clones at the end of the development cycle.
6. F. Use Aurora Replica
7. G. From the master automatic pause compute capacity option, create replicas for each development group, and promote each replica to maste
8. H. Delete the replicas at the end of the development cycle.
9. I. Use Aurora Serverles
10. J. Restore current Aurora snapshot and deploy to a serverless cluster for each development grou
11. K. Enable the option to pause the compute capacity on the cluster and set an appropriate timeout.

Correct Answer: B
Aurora Serverless is not compatible to all Aurora provisioned engine version. However, you can do clone with most engine version. Meanwhile, I also consider the performance while restoring snapshot to Aurora Serverless.
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-serverless.how-it-works.html#aurora https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-serverless.html#aurora-serverless.us