A significant automotive manufacturer is switching a mission-critical finance application's database to Amazon DynamoDB. According to the company's risk and compliance policy, any update to the database must be documented as a log entry for auditing purposes. Each minute, the system anticipates about 500,000 log entries. Log entries should be kept in Apache Parquet files in batches of at least 100,000 records per file.
How could a database professional approach these needs while using DynamoDB?

• A.Enable AWS CloudTrail logs on the table. Create an AWS Lambda function that reads the log files once an hour and filters DynamoDB API actions. Write the filtered log files to Amazon S3.
• B.Enable Amazon DynamoDB Streams on the table. Create an AWS Lambda function triggered by the stream. Write the log entries to an Amazon Kinesis Data Firehose delivery stream with buffering and Amazon S3 as the destination.
• C.Enable Amazon DynamoDB Streams on the table. Create an AWS Lambda function triggered by the stream. Write the log entries to an Amazon S3 object.
• D.Create a backup plan in AWS Backup to back up the DynamoDB table once a day. Create an AWS Lambda function that restores the backup in another table and compares both tables for changes.
  Generate the log entries and write them to an Amazon S3 object.

Comment: *

Name: *

Email: *

Verification: *

An AWS CloudFormation stack that included an Amazon RDS DB instance was accidentally deleted and recent data was lost. A Database Specialist needs to add RDS settings to the CloudFormation template to reduce the chance of accidental instance data loss in the future.
Which settings will meet this requirement? (Choose three.)

• A.Set DeleteAutomatedBackups to False
• B.Set DeletionPolicy to Retain
• C.Set DeletionProtection to True
• D.Set DeletionPolicy to Delete
• E.Set MultiAZ to True
• F.Set TerminationProtection to True

Comment: *

Name: *

Email: *

Verification: *

A database professional maintains a fleet of Amazon RDS database instances that are configured to utilize the default database parameter group. A database expert must connect a custom parameter group with certain database instances.
When will the instances be allocated to this new parameter group once the database specialist performs this change?

• A.Instantaneously after the change is made to the parameter group
• B.In the next scheduled maintenance window of the DB instances
• C.After the DB instances are manually rebooted
• D.Within 24 hours after the change is made to the parameter group

Comment: *

Name: *

Email: *

Verification: *

A company is building a new web platform where user requests trigger an AWS Lambda function that performs an insert into an Amazon Aurora MySQL DB cluster. Initial tests with less than 10 users on the new platform yielded successful execution and fast response times. However, upon more extensive tests with the actual target of 3,000 concurrent users, Lambda functions are unable to connect to the DB cluster and receive too many connections errors.
Which of the following will resolve this issue?

• A.Edit the my.cnf file for the DB cluster to increase max_connections
• B.Increase the instance size of the DB cluster
• C.Change the DB cluster to Multi-AZ
• D.Increase the number of Aurora Replicas

Comment: *

Name: *

Email: *

Verification: *

A financial institution uses AWS to host its online application. Amazon RDS for MySQL is used to host the application's database, which includes automatic backups.
The program has corrupted the database logically, resulting in the application being unresponsive. The exact moment the corruption occurred has been determined, and it occurred within the backup retention period.
How should a database professional restore a database to its previous state prior to corruption?

• A.Use the point-in-time restore capability to restore the DB instance to the specified time. No changes to the application connection string are required.
• B.Use the point-in-time restore capability to restore the DB instance to the specified time. Change the application connection string to the new, restored DB instance.
• C.Restore using the latest automated backup. Change the application connection string to the new, restored DB instance.
• D.Restore using the appropriate automated backup. No changes to the application connection string are required.

Comment: *

Name: *

Email: *

Verification: *