Latest Amazon DBS-C01 Actual Free Exam Questions & Community Discussion, Page 3

Question #21

A company has an AWS CloudFormation stack that defines an Amazon RDS DB instance. The company accidentally deletes the stack and loses recent data from the DB instance. A database specialist must change the CloudFormation template for the RDS resource to reduce the chance of accidental data loss from the DB instance in the future.
Which combination of actions should the database specialist take to meet this requirement? (Choose three.)

A. Set the TerminationProtection property to True.

B. Set the DeleteAutomatedBackups property to False.

C. Set the DeletionPolicy attribute to Retain.

D. Set the DeletionPolicy attribute to No.

E. Set the DeletionProtection property to True.

F. Set the MultiAZ property to True.

Discussion 0

Correct Answer: B,C,E Vote an answer

Question #22

An Amazon RDS EBS-optimized instance with Provisioned IOPS (PIOPS) storage is using less than half of its allocated IOPS over the course of several hours under constant load. The RDS instance exhibits multi-second read and write latency, and uses all of its maximum bandwidth for read throughput, yet the instance uses less than half of its CPU and RAM resources.
What should a Database Specialist do in this situation to increase performance and return latency to sub- second levels?

A. Increase the size of the DB instance storage

B. Change the underlying EBS storage type to General Purpose SSD (gp2)

C. Disable EBS optimization on the DB instance

D. Change the DB instance to an instance class with a higher maximum bandwidth

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #23

A company is using Amazon RDS for PostgreSQL. The Security team wants all database connection requests to be logged and retained for 180 days. The RDS for PostgreSQL DB instance is currently using the default parameter group. A Database Specialist has identified that setting the log_connections parameter to 1 will enable connections logging.
Which combination of steps should the Database Specialist take to meet the logging and retention requirements? (Choose two.)

A. Update the log_connections parameter in the default parameter group

B. Create a custom parameter group, update the log_connections parameter, and associate the parameter with the DB instance

C. Enable publishing of database engine logs to Amazon CloudWatch Logs and set the event expiration to
180 days

D. Enable publishing of database engine logs to an Amazon S3 bucket and set the lifecycle policy to 180 days

E. Connect to the RDS PostgreSQL host and update the log_connections parameter in the postgresql.conf file

Discussion 0

Correct Answer: A,E Vote an answer

Question #24

A company has two separate AWS accounts: one for the business unit and another for corporate analytics. The company wants to replicate the business unit data stored in Amazon RDS for MySQL in us-east-1 to its corporate analytics Amazon Redshift environment in us-west-1. The company wants to use AWS DMS with Amazon RDS as the source endpoint and Amazon Redshift as the target endpoint.
Which action will allow AVS DMS to perform the replication?

A. Configure the AWS DMS replication instance in the same account and Region as Amazon Redshift.

B. Configure the AWS DMS replication instance in the same account as Amazon Redshift and in the same Region as Amazon RDS.

C. Configure the AWS DMS replication instance in its own account and in the same Region as Amazon Redshift.

D. Configure the AWS DMS replication instance in the same account and Region as Amazon RDS.

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #25

A significant automotive manufacturer is switching a mission-critical finance application's database to Amazon DynamoDB. According to the company's risk and compliance policy, any update to the database must be documented as a log entry for auditing purposes. Each minute, the system anticipates about 500,000 log entries. Log entries should be kept in Apache Parquet files in batches of at least 100,000 records per file.
How could a database professional approach these needs while using DynamoDB?

A. Create a backup plan in AWS Backup to back up the DynamoDB table once a day. Create an AWS Lambda function that restores the backup in another table and compares both tables for changes.
Generate the log entries and write them to an Amazon S3 object.

B. Enable Amazon DynamoDB Streams on the table. Create an AWS Lambda function triggered by the stream. Write the log entries to an Amazon Kinesis Data Firehose delivery stream with buffering and Amazon S3 as the destination.

C. Enable AWS CloudTrail logs on the table. Create an AWS Lambda function that reads the log files once an hour and filters DynamoDB API actions. Write the filtered log files to Amazon S3.

D. Enable Amazon DynamoDB Streams on the table. Create an AWS Lambda function triggered by the stream. Write the log entries to an Amazon S3 object.

Discussion 0

Correct Answer: B Vote an answer

Question #26

Amazon RDS for Oracle with Transparent Data Encryption is used by a financial services organization (TDE).
At all times, the organization is obligated to encrypt its data at rest. The decryption key must be widely distributed, and access to the key must be restricted. The organization must be able to rotate the encryption key on demand to comply with regulatory requirements. If any possible security vulnerabilities are discovered, the organization must be able to disable the key. Additionally, the company's overhead must be kept to a minimal.
What method should the database administrator use to configure the encryption to fulfill these specifications?

A. AWS Key Management Service (AWS KMS) with server-side encryption

B. AWS CloudHSM

C. AWS Key Management Service (AWS KMS) with an AWS managed key

D. AWS Key Management Service (AWS KMS) CMK with customer-provided material

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #27

A company has an on-premises system that tracks various database operations that occur over the lifetime of a database, including database shutdown, deletion, creation, and backup.
The company recently moved two databases to Amazon RDS and is looking at a solution that would satisfy these requirements. The data could be used by other systems within the company.
Which solution will meet these requirements with minimal effort?

A. Create an AWS Lambda function to trigger on AWS CloudTrail API calls. Filter on specific RDS API calls and write the output to the tracking systems.

B. Create an Amazon Cloudwatch Events rule with the operations that need to be tracked on Amazon RDS.
Create an AWS Lambda function to act on these rules and write the output to the tracking systems.

C. Write RDS logs to Amazon Kinesis Data Firehose. Create an AWS Lambda function to act on these rules and write the output to the tracking systems.

D. Create RDS event subscriptions. Have the tracking systems subscribe to specific RDS event system notifications.

Discussion 0

Correct Answer: D Vote an answer

Question #28

An online advertising website uses an Amazon DynamoDB table with on-demand capacity mode as its data store. The website also has a DynamoDB Accelerator (DAX) cluster in the same VPC as its web application server. The application needs to perform infrequent writes and many strongly consistent reads from the data store by querying the DAX cluster.
During a performance audit, a systems administrator notices that the application can look up items by using the DAX cluster. However, the QueryCacheHits metric for the DAX cluster consistently shows 0 while the QueryCacheMisses metric continuously keeps growing in Amazon CloudWatch.
What is the MOST likely reason for this occurrence?

A. A VPC endpoint was not added to access CloudWatch.

B. DynamoDB is scaling due to a burst in traffic, resulting in degraded performance.

C. A VPC endpoint was not added to access DynamoDB.

D. Strongly consistent reads are always passed through DAX to DynamoDB.

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #29

A database specialist needs to move an Amazon RDS DB instance from one AWS account to another AWS account.
Which solution will meet this requirement with the LEAST operational effort?

A. Create a DB snapshot of the DB instance. Share the snapshot with the destination AWS account. Create a new DB instance by restoring the snapshot in the destination AWS account.

B. Create a Multi-AZ deployment for the DB instance. Create a read replica for the DB instance in the source AWS account. Use the read replica to replicate the data into the DB instance in the destination AWS account.

C. Use AWS Database Migration Service (AWS DMS) to migrate the DB instance from the source AWS account to the destination AWS account.

D. Use AWS DataSync to back up the DB instance in the source AWS account. Use AWS Resource Access Manager (AWS RAM) to restore the backup in the destination AWS account.

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #30

An worldwide gaming company's development team is experimenting with using Amazon DynamoDB to store in-game events for three mobile titles. Maximum concurrent users for the most popular game is 500,000, while the least popular game is 10,000. The typical event is 20 KB in size, while the average user session generates one event each second. Each event is assigned a millisecond time stamp and a globally unique identification.
The lead developer generated a single DynamoDB database with the following structure for the events:
Partition key: game name
Sort key: event identifier
Local secondary index: player identifier
Event time
In a small-scale development setting, the tests were successful. When the application was deployed to production, however, new events were not being added to the database, and the logs indicated DynamoDB failures with the ItemCollectionSizeLimitExceededException issue code.
Which design modification should a database professional offer to the development team?

A. Replace the sort key with a compound value consisting of the player identifier collated with the event time, separated by a dash. Add a local secondary index with the player identifier as the sort key.

B. Use the player identifier as the partition key. Use the event time as the sort key. Add a global secondary index with the game name as the partition key and the event time as the sort key.

C. Create one table for each game. Use the player identifier as the partition key. Use the event time as the sort key.

D. Create two tables. Use the game name as the partition key in both tables. Use the event time as the sort key for the first table. Use the player identifier as the sort key for the second table.

Discussion 0

Correct Answer: C Vote an answer

Amazon DBS-C01 Actual Free Exam Questions & Community Discussion

Download Free Amazon DBS-C01 Demo