Recently, an ecommerce business transferred one of its SQL Server databases to an Amazon RDS for SQL Server Enterprise Edition database instance. The corporation anticipates an increase in read traffic as a result of an approaching sale. To accommodate the projected read load, a database professional must establish a read replica of the database instance.
Which procedures should the database professional do prior to establishing the read replica? (Select two.)

• A.Identify a potential downtime window and stop the application calls to the source DB instance.
• B.Ensure that automatic backups are enabled for the source DB instance.
• C.Ensure that the source DB instance is a Multi-AZ deployment with Always ON Availability Groups.
• D.Ensure that the source DB instance is a Multi-AZ deployment with SQL Server Database Mirroring (DBM).
• E.Modify the read replica parameter group setting and set the value to 1.

Comment: *

Name: *

Email: *

Verification: *

A financial services company is developing a shared data service that supports different applications from throughout the company. A Database Specialist designed a solution to leverage Amazon ElastiCache for Redis with cluster mode enabled to enhance performance and scalability. The cluster is configured to listen on port
6379.
Which combination of steps should the Database Specialist take to secure the cache data and protect it from unauthorized access? (Choose three.)

• A.Enable in-transit and at-rest encryption on the ElastiCache cluster.
• B.Ensure that Amazon CloudWatch metrics are configured in the ElastiCache cluster.
• C.Ensure the security group for the ElastiCache cluster allows all inbound traffic from itself and inbound traffic on TCP port 6379 from trusted clients only.
• D.Create an IAM policy to allow the application service roles to access all ElastiCache API actions.
• E.Ensure the security group for the ElastiCache clients authorize inbound TCP port 6379 and port 22 traffic from the trusted ElastiCache cluster's security group.
• F.Ensure the cluster is created with the auth-token parameter and that the parameter is used in all subsequent commands.

Comment: *

Name: *

Email: *

Verification: *

A company maintains several databases using Amazon RDS for MySQL and PostgreSQL. Each RDS database generates log files with retention periods set to their default values. The company has now mandated that database logs be maintained for up to 90 days in a centralized repository to facilitate real-time and after- the-fact analyses.
What should a Database Specialist do to meet these requirements with minimal effort?

• A.Create an AWS Lambda function to pull logs from the RDS databases and consolidate the log files in an Amazon S3 bucket. Set a lifecycle policy to expire the objects after 90 days.
• B.Modify the RDS databases to publish log to Amazon CloudWatch Logs. Change the log retention policy for each log group to expire the events after 90 days.
• C.Write a stored procedure in each RDS database to download the logs and consolidate the log files in an Amazon S3 bucket. Set a lifecycle policy to expire the objects after 90 days.
• D.Create an AWS Lambda function to download the logs from the RDS databases and publish the logs to Amazon CloudWatch Logs. Change the log retention policy for the log group to expire the events after
  90 days.

Comment: *

Name: *

Email: *

Verification: *

The website of a manufacturing firm makes use of an Amazon Aurora PostgreSQL database cluster.
Which settings will result in the LEAST amount of downtime for the application during failover? (Select three.)

• A.Use the provided read and write Aurora endpoints to establish a connection to the Aurora DB cluster.
• B.Create an Amazon CloudWatch alert triggering a restore in another Availability Zone when the primary Aurora DB cluster is unreachable.
• C.Edit and enable Aurora DB cluster cache management in parameter groups.
• D.Set TCP keepalive parameters to a high value.
• E.Set JDBC connection string timeout variables to a low value.
• F.Set Java DNS caching timeouts to a high value.

Comment: *

Name: *

Email: *

Verification: *

A manufacturing company's website uses an Amazon Aurora PostgreSQL DB cluster.
Which configurations will result in the LEAST application downtime during a failover? (Choose three.)

• A.Set TCP keepalive parameters to a high value.
• B.Edit and enable Aurora DB cluster cache management in parameter groups.
• C.Create an Amazon CloudWatch alert triggering a restore in another Availability Zone when the primary Aurora DB cluster is unreachable.
• D.Set JDBC connection string timeout variables to a low value.
• E.Use the provided read and write Aurora endpoints to establish a connection to the Aurora DB cluster.
• F.Set Java DNS caching timeouts to a high value.

Comment: *

Name: *

Email: *

Verification: *