A business is transferring its on-premises database workloads to the Amazon Web Services (AWS) Cloud. A database professional migrating an Oracle database with a huge table to Amazon RDS has picked AWS DMS.
The database professional observes that AWS DMS is consuming considerable time migrating the data.
Which activities would increase the pace of data migration? (Select three.)

• A.Create multiple AWS DMS tasks to migrate the large table.
• B.Configure the AWS DMS replication instance with Multi-AZ.
• C.Increase the capacity of the AWS DMS replication server.
• D.Establish an AWS Direct Connect connection between the on-premises data center and AWS.
• E.Enable an Amazon RDS Multi-AZ configuration.
• F.Enable full large binary object (LOB) mode to migrate all LOB data for all large tables.

Comment: *

Name: *

Email: *

Verification: *

A company has deployed an application that uses an Amazon RDS for MySQL DB cluster. The DB cluster uses three read replicas. The primary DB instance is an
8XL-sized instance, and the read replicas are each XL-sized instances.
Users report that database queries are returning stale data. The replication lag indicates that the replicas are 5 minutes behind the primary DB instance. Status queries on the replicas show that the SQL_THREAD is 10 binlogs behind the IO_THREAD and that the IO_THREAD is 1 binlog behind the primary.
Which changes will reduce the lag? (Choose two.)

• A.Deploy two additional read replicas matching the existing replica DB instance size.
• B.Migrate the primary DB instance to an Amazon Aurora MySQL DB cluster and add three Aurora Replicas.
• C.Move the read replicas to the same Availability Zone as the primary DB instance.
• D.Increase the instance size of the primary DB instance within the same instance class.
• E.Increase the instance size of the read replicas to the same size and class as the primary DB instance.

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 loading sensitive data into an Amazon Aurora MySQL database. To meet compliance requirements, the company needs to enable audit logging on the Aurora MySQL DB cluster to audit database activity. This logging will include events such as connections, disconnections, queries, and tables queried. The company also needs to publish the DB logs to Amazon CloudWatch to perform real-time data analysis.
Which solution meets these requirements?

• A.Modify the default option group parameters to enable Advanced Auditing. Restart the database for the changes to take effect.
• B.Create a custom DB cluster parameter group. Modify the parameters for Advanced Auditing. Modify the cluster to associate the new custom DB parameter group with the Aurora MySQL DB cluster.
• C.Take a snapshot of the database. Create a new DB instance, and enable custom auditing and logging to CloudWatch. Deactivate the DB instance that has no logging.
• D.Enable AWS CloudTrail for the DB instance. Create a filter that provides only connections, disconnections, queries, and tables queried.

Comment: *

Name: *

Email: *

Verification: *

A software-as-a-service (SaaS) company is using an Amazon Aurora Serverless DB cluster for its production MySQL database. The DB cluster has general logs and slow query logs enabled. A database engineer must use the most operationally efficient solution with minimal resource utilization to retain the logs and facilitate interactive search and analysis.
Which solution meets these requirements?

• A.Use an AWS Lambda function to ship database logs to an Amazon S3 bucket. Use Amazon Athena and Amazon QuickSight to search and analyze the logs.
• B.Download the logs from the DB cluster and store them in Amazon S3 by using manual scripts. Use Amazon Athena and Amazon QuickSight to search and analyze the logs.
• C.Use an AWS Lambda function to ship database logs to an Amazon S3 bucket. Use Amazon Elasticsearch Service (Amazon ES) and Kibana to search and analyze the logs.
• D.Use Amazon CloudWatch Logs Insights to search and analyze the logs when the logs are automatically uploaded by the DB cluster.

Comment: *

Name: *

Email: *

Verification: *