Amazon DBS-C01 Exam Questions Instant Access

Question 1

An ecommerce company is using Amazon DynamoDB as the backend for its order-processing application. The

steady increase in the number of orders is resulting in increased DynamoDB costs. Order verification and reporting perform many repeated GetItem functions that pull similar datasets, and this read activity is contributing to the increased costs. The company wants to control these costs without significant development efforts.

How should a Database Specialist address these requirements?

AUse AWS DMS to migrate data from DynamoDB to Amazon DocumentDB

BUse Amazon DynamoDB Streams and Amazon Kinesis Data Firehose to push the data into Amazon Redshift

CUse an Amazon ElastiCache for Redis in front of DynamoDB to boost read performance

DUse DynamoDB Accelerator to offload the reads

Answer : D

https://docs.amazonaws.cn/en_us/amazondynamodb/latest/developerguide/DAX.html

'Applications that are read-intensive, but are also cost-sensitive. With DynamoDB, you provision the number of reads per second that your application requires. If read activity increases, you can increase your tables' provisioned read throughput (at an additional cost). Or, you can offload the activity from your application to a DAX cluster, and reduce the number of read capacity units that you need to purchase otherwise.'

Question 2

A startup company is building a new application to allow users to visualize their on-premises and cloud networking components. The company expects billions of components to be stored and requires responses in milliseconds. The application should be able to identify:

The networks and routes affected if a particular component fails.

The networks that have redundant routes between them.

The networks that do not have redundant routes between them.

The fastest path between two networks.

Which database engine meets these requirements?

AAmazon Aurora MySQL

BAmazon Neptune

CAmazon ElastiCache for Redis

DAmazon DynamoDB

Answer : B

Question 3

A company is running an Amazon RDS for MySQL Multi-AZ DB instance for a business-critical workload. RDS encryption for the DB instance is disabled. A recent security audit concluded that all business-critical applications must encrypt data at rest. The company has asked its database specialist to formulate a plan to accomplish this for the DB instance.

Which process should the database specialist recommend?

ACreate an encrypted snapshot of the unencrypted DB instance. Copy the encrypted snapshot to Amazon S3. Restore the DB instance from the encrypted snapshot using Amazon S3.

BCreate a new RDS for MySQL DB instance with encryption enabled. Restore the unencrypted snapshot to this DB instance.

CCreate a snapshot of the unencrypted DB instance. Create an encrypted copy of the snapshot. Restore the DB instance from the encrypted snapshot.

DTemporarily shut down the unencrypted DB instance. Enable AWS KMS encryption in the AWS Management Console using an AWS managed CMK. Restart the DB instance in an encrypted state.

Answer : C

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Overview.Encryption.html#Overview.Encryption.Limitations

Question 4

A financial services company has an application deployed on AWS that uses an Amazon Aurora PostgreSQL DB cluster. A recent audit showed that no log files contained database administrator activity. A database specialist needs to recommend a solution to provide database access and activity logs. The solution should use the least amount of effort and have a minimal impact on performance.

Which solution should the database specialist recommend?

AEnable Aurora Database Activity Streams on the database in synchronous mode. Connect the Amazon Kinesis data stream to Kinesis Data Firehose. Set the Kinesis Data Firehose destination to an Amazon S3 bucket.

BCreate an AWS CloudTrail trail in the Region where the database runs. Associate the database activity logs with the trail.

CEnable Aurora Database Activity Streams on the database in asynchronous mode. Connect the Amazon Kinesis data stream to Kinesis Data Firehose. Set the Firehose destination to an Amazon S3 bucket.

DAllow connections to the DB cluster through a bastion host only. Restrict database access to the bastion host and application servers. Push the bastion host logs to Amazon CloudWatch Logs using the CloudWatch Logs agent.

Answer : C

https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/DBActivityStreams.Overview.html

Question 5

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?

ATake a snapshot of the RDS for MySQL DB instance and create a new Aurora DB cluster with the option to migrate snapshots.

BMake a backup of the RDS for MySQL DB instance using the mysqldump utility, create a new Aurora DB cluster, and restore the backup.

CCreate an Aurora Replica from the RDS for MySQL DB instance and promote the Aurora DB cluster.

DCreate a clone of the RDS for MySQL DB instance and promote the Aurora DB cluster.

Answer : C

https://aws.amazon.com/blogs/database/best-practices-for-migrating-rds-for-mysql-databases-to-amazon-aurora/

https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraPostgreSQL.Migrating.html#AuroraPostgreSQL.Migrating.RDSPostgreSQL.Replica

Question 6

A Database Specialist has migrated an on-premises Oracle database to Amazon Aurora PostgreSQL. The schema and the data have been migrated successfully. The on-premises database server was also being used to run database maintenance cron jobs written in Python to perform tasks including data purging and generating data exports. The logs for these jobs show that, most of the time, the jobs completed within 5 minutes, but a few jobs took up to 10 minutes to complete. These maintenance jobs need to be set up for Aurora PostgreSQL.

How can the Database Specialist schedule these jobs so the setup requires minimal maintenance and provides high availability?

ACreate cron jobs on an Amazon EC2 instance to run the maintenance jobs following the required schedule.

BConnect to the Aurora host and create cron jobs to run the maintenance jobs following the required schedule.

CCreate AWS Lambda functions to run the maintenance jobs and schedule them with Amazon CloudWatch Events.

DCreate the maintenance job using the Amazon CloudWatch job scheduling plugin.

Answer : C

https://docs.aws.amazon.com/AmazonCloudWatch/latest/events/Create-CloudWatch-Events-Scheduled-Rule.html

https://docs.aws.amazon.com/prescriptive-guidance/latest/patterns/schedule-jobs-for-amazon-rds-and-aurora-postgresql-using-lambda-and-secrets-manager.html

a job for data extraction or a job for data purging can easily be scheduled using cron. For these jobs, database credentials are typically either hard-coded or stored in a properties file. However, when you migrate to Amazon Relational Database Service (Amazon RDS) or Amazon Aurora PostgreSQL, you lose the ability to log in to the host instance to schedule cron jobs. This pattern describes how to use AWS Lambda and AWS Secrets Manager to schedule jobs for Amazon RDS and Aurora PostgreSQL databases after migration.

https://docs.aws.amazon.com/AmazonCloudWatch/latest/events/RunLambdaSchedule.html

Question 7

A company is going to use an Amazon Aurora PostgreSQL DB cluster for an application backend. The DB cluster contains some tables with sensitive dat

a. A Database Specialist needs to control the access privileges at the table level.

How can the Database Specialist meet these requirements?

AUse AWS IAM database authentication and restrict access to the tables using an IAM policy.

BConfigure the rules in a NACL to restrict outbound traffic from the Aurora DB cluster.

CExecute GRANT and REVOKE commands that restrict access to the tables containing sensitive data.

DDefine access privileges to the tables containing sensitive data in the pg_hba.conf file.

Answer : C

Amazon AWS Certified Database - Specialty DBS-C01 Exam Questions