DBS-C01 Exam Dumps - AWS Certified Database - Specialty

The combination of changes that the database administrator must make to the database deployment to automate the collection of performance data are:

• Update the CloudFormation template to enable Amazon CloudWatch monitoring on the Aurora PostgreSQL DB instances. This will allow the database administrator to monitor the CPU utilization, memory usage, disk I/O, network throughput, and other metrics of the DB instances. CloudWatch monitoring is enabled by default for Aurora DB instances, but it can also be specified in the CloudFormation template using the MonitoringInterval property of the AWS::RDS::DBInstance resource1.
• Update the CloudFormation template to turn on Performance Insights for Aurora PostgreSQL. This will allow the database administrator to analyze the database load and identify the most resource-intensive SQL queries, hosts, or users. Performance Insights is a feature of Amazon RDS that provides an easy-to-use dashboard to visualize and troubleshoot database performance. Performance Insights can be enabled in the CloudFormation template using the PerformanceInsightsEnabled property of the AWS::RDS::DBInstance resource2.

The other options are not relevant or sufficient for the requirement of automating the collection of performance data for the Aurora PostgreSQL databases. For example:

• Turning on Amazon DevOps Guru for the Aurora database resources in the CloudFormation template is not necessary, as DevOps Guru is a service that uses machine learning to identify operational issues and risks across applications and infrastructure. DevOps Guru does not provide detailed performance data or analysis for Aurora PostgreSQL databases3.
• Turning on AWS CloudTrail in each AWS account is not sufficient, as CloudTrail is a service that records API calls and events for AWS services. CloudTrail does not provide performance data or analysis for Aurora PostgreSQL databases, although it can help with auditing and compliance4.
• Turning on and configuring AWS Config for all Aurora PostgreSQL databases is not relevant, as AWS Config is a service that tracks and evaluates the configuration changes of AWS resources. AWS Config does not provide performance data or analysis for Aurora PostgreSQL databases, although it can help with governance and security5.

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PerfInsights.Enabling.html

https://aws.amazon.com/rds/performance-insights/

https://aws.amazon.com/blogs/database/tuning-amazon-rds-for-mysql-with-performance-insights/

Correct Answer: A

Explanation from Amazon documents:

Amazon RDS for Microsoft SQL Server supports two types of database snapshots: automated and manual. Automated snapshots are taken daily and are retained for a period of time that you specify, from 1 to 35 days. Manual snapshots are taken by you and are retained until you delete them.

To save a particular automated database snapshot for longer than the maximum number of days, the database administrator can create a manual copy of the snapshot. This can be done using the AWS Management Console, the AWS CLI, or the RDS API. The manual copy of the snapshot will be retained until it is deleted, regardless of the retention period of the automated snapshot. This solution is the most operationally efficient way to meet the requirements, because it does not require any additional steps or resources.

Therefore, option A is the correct solution to meet the requirements. Option B is not operationally efficient because it requires exporting the contents of the snapshot to an Amazon S3 bucket, which can be time-consuming and costly. Option C is not possible because the maximum retention period for automated snapshots is 35 days, not 45 days. Option D is not operationally efficient because it requires creating a native SQL Server backup and saving it to an Amazon S3 bucket, which can also be time-consuming and costly.

https://aws.amazon.com/blogs/database/new-aws-dms-and-aws-snowball-integration-enables-mass-database-migrations-and-migrations-of-large-databases/

When you perform a restore operation to a point in time or from a DB Snapshot, a new DB Instance is created with a new endpoint (the old DB Instance can be deleted if so desired). This is done to enable you to create multiple DB Instances from a specific DB Snapshot or point in time."

Correct Answer: A, C, E

Explanation from Amazon documents:

To enable CDC mode for RDS for PostgreSQL database, the database architect needs to configure the following parameters12:

• Set wal_level = logical. This parameter determines how much information is written to the write-ahead log (WAL). For CDC mode, the wal_level must be set to logical, which enables logical decoding of the WAL and allows AWS DMS to read changes from the source database1.
• Set max_replication_slots to 1 or more, depending on the number of DMS tasks. This parameter specifies the maximum number of replication slots that the source database can support. A replication slot is a data structure that records the state of a replication stream. AWS DMS uses replication slots to set up logical replication and track changes in the source database. The max_replication_slots parameter must be equal to or greater than the number of DMS tasks that use CDC mode for the source database1.
• Set wal_sender_timeout to 20,000 milliseconds. This parameter specifies the amount of time that a WAL sender process waits for feedback from a WAL receiver process before terminating the connection. A WAL sender process is a background process that streams WAL data from the source database to AWS DMS. A WAL receiver process is a background process that receives WAL data from a WAL sender process and writes it to a local file. The wal_sender_timeout parameter must be set to a value greater than 10,000 milliseconds (10 seconds) to prevent connection timeouts during CDC mode2.

Therefore, option A, C, and E are the correct parameters to support CDC mode for RDS for PostgreSQL database. Option B is incorrect because wal_level = replica is not sufficient for logical decoding and CDC mode. Option D is incorrect because max_replication_slots must be a positive integer, not zero. Option F is incorrect because wal_sender_timeout = 5,000 milliseconds is too low and may cause connection timeouts during CDC mode.

"AWS Lambda function to capture changes" capture changes to what? ElastiCache? The main use of ElastiCache is to cache frequently read data. Also "the company expects a tenfold increase in the user base" and "correspond to simultaneous requests from users"