QUESTION: 21

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?

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.
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.
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.
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.

Answer(s): B

Reveal Solution Next Question

QUESTION: 22

A Database Specialist is setting up a new Amazon Aurora DB cluster with one primary instance and three Aurora Replicas for a highly intensive, business-critical application. The Aurora DB cluster has one medium- sized primary instance, one large-sized replica, and two medium sized replicas. The Database Specialist did not assign a promotion tier to the replicas.

In the event of a primary failure, what will occur?

Aurora will promote an Aurora Replica that is of the same size as the primary instance
Aurora will promote an arbitrary Aurora Replica
Aurora will promote the largest-sized Aurora Replica
Aurora will not promote an Aurora Replica

Answer(s): C

Reference:

https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-ug.pdf

Reveal Solution Next Question

QUESTION: 23

A company is running its line of business application on AWS, which uses Amazon RDS for MySQL at the persistent data store. The company wants to minimize downtime when it migrates the database to Amazon Aurora.

Which migration method should a Database Specialist use?

Take a snapshot of the RDS for MySQL DB instance and create a new Aurora DB cluster with the option to migrate snapshots.
Make a backup of the RDS for MySQL DB instance using the my sql dump utility, create a new Aurora DB cluster, and restore the backup.
Create an Aurora Replica from the RDS for MySQL DB instance and promote the Aurora DB cluster.
Create a clone of the RDS for MySQL DB instance and promote the Aurora DB cluster.

Answer(s): C

Reference:

https://d1.awsstatic.com/whitepapers/RDS/Migrating%20your%20databases%20to%20Amazon%20Aurora.pdf (10)

Reveal Solution Next Question

QUESTION: 24

The Security team for a finance company was notified of an internal security breach that happened 3 weeks ago. A Database Specialist must start producing audit logs out of the production Amazon Aurora PostgreSQL cluster for the Security team to use for monitoring and alerting. The Security team is required to perform real- time alerting and monitoring outside the Aurora DB cluster and wants to have the cluster push encrypted files to the chosen solution.
Which approach will meet these requirements?

Use pg_audit to generate audit logs and send the logs to the Security team.
Use AWS CloudTrail to audit the DB cluster and the Security team will get data from Amazon S3.
Set up database activity streams and connect the data stream from Amazon Kinesis to consumer applications.
Turn on verbose logging and set up a schedule for the logs to be dumped out for the Security team.

Answer(s): C

Reference:

https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-ug.pdf (525)

Reveal Solution Next Question

Free DBS-C01 Exam Braindumps (page: 6)

QUESTION: 21

QUESTION: 22

Reference:

QUESTION: 23

Reference:

QUESTION: 24

Reference: