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 solution will meet these requirements and is the MOST operationally efficient?

• A.Create an AWS Lambda function to run on the first day of every month to take a manual RDS snapshot.
  Move the snapshot to the company's Amazon S3 bucket.
• B.Create an AWS Lambda function to run on the first day of every month to take a manual RDS snapshot.
• C.Create an RDS snapshot schedule from the AWS Management Console to take a snapshot every 30 days.
• D.Create an AWS Lambda function to run on the first day of every month to create an automated RDS snapshot.

Comment: *

Name: *

Email: *

Verification: *

A database specialist wants to ensure that an Amazon Aurora DB cluster is always automatically upgraded to the most recent minor version available. Noticing that there is a new minor version available, the database specialist has issues an AWS CLI command to enable automatic minor version updates. The command runs successfully, but checking the Aurora DB cluster indicates that no update to the Aurora version has been made.
What might account for this? (Choose two.)

• A.The new minor version has not yet been designated as preferred and requires a manual upgrade.
• B.Configuring automatic upgrades using the AWS CLI is not supported. This must be enabled expressly using the AWS Management Console.
• C.Applying minor version upgrades requires sufficient free space.
• D.The AWS CLI command did not include an apply-immediately parameter.
• E.Aurora has detected a breaking change in the new minor version and has automatically rejected the upgrade.

Comment: *

Name: *

Email: *

Verification: *

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 binary objects (LOBs) across multiple tables. The Oracle database has a maximum LOB size of 500 MB with an average LOB size of 350 MB. The Database Specialist has chosen AWS DMS to migrate the data with the largest replication instances.
How should the Database Specialist optimize the database migration using AWS DMS?

• A.Create a single task using limited LOB mode with a maximum LOB size of 500 MB to migrate data andLOBs together
• B.Create two tasks: task1 with LOB tables using limited LOB mode with a maximum LOB size of 500 MB andtask 2 without LOBs
• C.Create a single task using full LOB mode with a LOB chunk size of 500 MB to migrate the data and LOBstogether
• D.Create two tasks: task1 with LOB tables using full LOB mode with a LOB chunk size of 500 MB and task2without LOBs

Comment: *

Name: *

Email: *

Verification: *

A gaming company wants to deploy a game in multiple Regions. The company plans to save local high scores in Amazon DynamoDB tables in each Region. A Database Specialist needs to design a solution to automate the deployment of the database with identical configurations in additional Regions, as needed. The solution should also automate configuration changes across all Regions.
Which solution would meet these requirements and deploy the DynamoDB tables?

• A.Create an AWS CLI command to deploy the DynamoDB table to all the Regions and save it for future deployments.
• B.Create an AWS CloudFormation template and deploy the template to all the Regions.
• C.Create an AWS CloudFormation template and use a stack set to deploy the template to all the Regions.
• D.Create DynamoDB tables using the AWS Management Console in all the Regions and create a step-by- step guide for future deployments.

Comment: *

Name: *

Email: *

Verification: *

A company has multiple applications serving data from a secure on-premises database. The company is migrating all applications and databases to the AWS Cloud. The IT Risk and Compliance department requires that auditing be enabled on all secure databases to capture all log ins, log outs, failed logins, permission changes, and database schema changes. A Database Specialist has recommended Amazon Aurora MySQL as the migration target, and leveraging the Advanced Auditing feature in Aurora.
Which events need to be specified in the Advanced Auditing configuration to satisfy the minimum auditing requirements? (Choose three.)

• A.QUERY_DDL
• B.TABLE
• C.QUERY
• D.QUERY_DCL
• E.CONNECT
• F.QUERY_DML

Comment: *

Name: *

Email: *

Verification: *