A marketing company is using Amazon DocumentDB and requires that database audit logs be enabled. A Database Specialist needs to configure monitoring so that all data definition language (DDL) statements performed are visible to the Administrator. The Database Specialist has set the audit_logs parameter to enabled in the cluster parameter group.
What should the Database Specialist do to automatically collect the database logs for the Administrator?

• A.Enable DocumentDB to export the logs to Amazon CloudWatch Logs
• B.Configure an AWS Lambda function to download the logs using the download-db-log-file-portion operationand store the logs in Amazon S3
• C.Enable DocumentDB to export the logs to AWS CloudTrail
• D.Enable DocumentDB Events to export the logs to Amazon CloudWatch Logs

Comment: *

Name: *

Email: *

Verification: *

A gaming company has implemented a leaderboard in AWS using a Sorted Set data structure within Amazon ElastiCache for Redis. The ElastiCache cluster has been deployed with cluster mode disabled and has a replication group deployed with two additional replicas. The company is planning for a worldwide gaming event and is anticipating a higher write load than what the current cluster can handle.
Which method should a Database Specialist use to scale the ElastiCache cluster ahead of the upcoming event?

• A.Enable cluster mode on the existing ElastiCache cluster and configure separate shards for the Sorted Set across all nodes in the cluster.
• B.Create an additional ElastiCache cluster and load-balance traffic between the two clusters.
• C.Increase the size of the ElastiCache cluster nodes to a larger instance size.
• D.Use the EXPIRE command and set a higher time to live (TTL) after each call to increment a given key.

Comment: *

Name: *

Email: *

Verification: *

A company is using an Amazon RDS for MySQL DB instance for its internal applications. A security audit shows that the DB instance is not encrypted at rest. The company's application team needs to encrypt the DB instance.
What should the team do to meet this requirement?

• A.Stop the DB instance and modify it to enable encryption. Apply this setting immediately without waiting for the next scheduled RDS maintenance window.
• B.Stop the DB instance and create an encrypted snapshot. Restore the encrypted snapshot to a new encrypted DB instance. Delete the original DB instance, and update the applications to point to the new encrypted DB instance.
• C.Stop the DB instance and create a snapshot. Copy the snapshot into another encrypted snapshot. Restore the encrypted snapshot to a new encrypted DB instance. Delete the original DB instance, and update the applications to point to the new encrypted DB instance.
• D.Create an encrypted read replica of the DB instance. Promote the read replica to master. Delete the original DB instance, and update the applications to point to the new encrypted DB instance.

Comment: *

Name: *

Email: *

Verification: *

A company has an ecommerce web application with an Amazon RDS for MySQL DB instance. The marketing team has noticed some unexpected updates to the product and pricing information on the website, which is impacting sales targets. The marketing team wants a database specialist to audit future database activity to help identify how and when the changes are being made.
What should the database specialist do to meet these requirements? (Choose two.)

• A.SSH to the DB instance and review the database logs.
• B.Publish the database logs to Amazon CloudWatch Logs.
• C.Enable auditing of CONNECT and QUERY_DML events.
• D.Enable Enhanced Monitoring on the DB instance.
• E.Create an RDS event subscription to the audit event type.

Comment: *

Name: *

Email: *

Verification: *

A company has a database monitoring solution that uses Amazon CloudWatch for its Amazon RDS for SQL Server environment. The cause of a recent spike in CPU utilization was not determined using the standard metrics that were collected. The CPU spike caused the application to perform poorly, impacting users. A Database Specialist needs to determine what caused the CPU spike.
Which combination of steps should be taken to provide more visibility into the processes and queries running during an increase in CPU load? (Choose two.)

• A.Enable Amazon RDS Performance Insights to view the database load and filter the load by waits, SQL statements, hosts, or users.
• B.Use Amazon QuickSight to view the SQL statement being run.
• C.Enable Enhanced Monitoring metrics to view CPU utilization at the RDS SQL Server DB instance level.
• D.Implement a caching layer to help with repeated queries on the RDS SQL Server DB instance.
• E.Enable Amazon CloudWatch Events and view the incoming T-SQL statements causing the CPU to spike.

Comment: *

Name: *

Email: *

Verification: *