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.Create an RDS event subscription to the audit event type.
• B.Enable auditing of CONNECT and QUERY_DML events.
• C.SSH to the DB instance and review the database logs.
• D.Publish the database logs to Amazon CloudWatch Logs.
• E.Enable Enhanced Monitoring on the DB instance.

Comment: *

Name: *

Email: *

Verification: *

A company is running a two-tier ecommerce application in one AWS account. The web server is deployed using an Amazon RDS for MySQL Multi-AZ DB instance. A Developer mistakenly deleted the database in the production environment. The database has been restored, but this resulted in hours of downtime and lost revenue.
Which combination of changes in existing IAM policies should a Database Specialist make to prevent an error like this from happening in the future? (Choose three.)

• A.Use AccessList Controls policy type to restrict users for database instance deletion
• B.Enable AWS CloudTrail logging and Enhanced Monitoring
• C.Enable multi-factor authentication for sensitive operations to access sensitive resources and APIoperations
• D.Grant least privilege to groups, users, and roles
• E.Allow all users to restore a database from a backup that will reduce the overall downtime to restore thedatabase
• F.Use policy conditions to restrict access to selective IP addresses

Comment: *

Name: *

Email: *

Verification: *

A Database Specialist is designing a disaster recovery strategy for a production Amazon DynamoDB table.
The table uses provisioned read/write capacity mode, global secondary indexes, and time to live (TTL). The Database Specialist has restored the latest backup to a new table.
To prepare the new table with identical settings, which steps should be performed? (Choose two.)

• A.Define IAM policies for access to the new table
• B.Set the provisioned read and write capacity
• C.Define the TTL settings
• D.Re-create global secondary indexes in the new table
• E.Encrypt the table from the AWS Management Console or use the update-table command

Comment: *

Name: *

Email: *

Verification: *

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 of the database, reloading, the data into an encrypted database would be too time- consuming, so it is not an option.
How should the Database Specialist satisfy this new requirement?

• A.Create a snapshot of the unencrypted RDS DB instance. Create an encrypted copy of the unencrypted snapshot. Restore the encrypted snapshot copy.
• B.Modify the RDS DB instance. Enable the AWS KMS encryption option that leverages the AWS CLI.
• C.Restore an unencrypted snapshot into a MySQL RDS DB instance that is encrypted.
• D.Create an encrypted read replica of the RDS DB instance. Promote it the master.

Comment: *

Name: *

Email: *

Verification: *

A worldwide digital advertising corporation collects browser information in order to provide targeted visitors with contextually relevant pictures, websites, and connections. A single page load may create many events, each of which must be kept separately. A single event may have a maximum size of 200 KB and an average size of 10 KB. Each page load requires a query of the user's browsing history in order to deliver suggestions for targeted advertising. The advertising corporation anticipates daily page views of more than 1 billion from people in the United States, Europe, Hong Kong, and India. The information structure differs according to the event. Additionally, browsing information must be written and read with a very low latency to guarantee that consumers have a positive viewing experience.
Which database solution satisfies these criteria?

• A.Amazon RDS Multi-AZ deployment
• B.Amazon DocumentDB
• C.Amazon DynamoDB global table
• D.Amazon Aurora Global Database

Comment: *

Name: *

Email: *

Verification: *