Free DBS-C01 Exam Braindumps

A database specialist is managing an application in the us-west-1 Region and wants to set up disaster recovery in the us-east-1 Region. The Amazon Aurora MySQL DB cluster needs an RPO of 1 minute and an RTO of 2 minutes.
Which approach meets these requirements with no negative performance impact?

1. A. Enable synchronous replication.
2. B. Enable asynchronous binlog replication.
3. C. Create an Aurora Global Database.
4. D. Copy Aurora incremental snapshots to the us-east-1 Region.

Correct Answer: C
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-global-database-disaster-recovery.ht

A company has a web-based survey application that uses Amazon DynamoDB. During peak usage, when survey responses are being collected, a Database Specialist sees the ProvisionedThroughputExceededException error.
What can the Database Specialist do to resolve this error? (Choose two.)

1. A. Change the table to use Amazon DynamoDB Streams
2. B. Purchase DynamoDB reserved capacity in the affected Region
3. C. Increase the write capacity units for the specific table
4. D. Change the table capacity mode to on-demand
5. E. Change the table type to throughput optimized

Correct Answer: CD
https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/switching.capacitymode.html

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?

1. A. AWS CloudHSM
2. B. AWS Key Management Service (AWS KMS) with an AWS managed key
3. C. AWS Key Management Service (AWS KMS) with server-side encryption
4. D. AWS Key Management Service (AWS KMS) CMK with customer-provided material

Correct Answer: D
https://docs.aws.amazon.com/whitepapers/latest/kms-best-practices/aws-managed-and-customer-managed-cmks

A company has deployed an e-commerce web application in a new AWS account. An Amazon RDS for MySQL Multi-AZ DB instance is part of this deployment with a database-1.xxxxxxxxxxxx.us-east- 1.rds.amazonaws.com endpoint listening on port 3306. The company’s Database Specialist is able to log in to MySQL and run queries from the bastion host using these details.
When users try to utilize the application hosted in the AWS account, they are presented with a generic error message. The application servers are logging a “could not connect to server: Connection times out” error message to Amazon CloudWatch Logs.
What is the cause of this error?

1. A. The user name and password the application is using are incorrect.
2. B. The security group assigned to the application servers does not have the necessary rules to allow inbound connections from the DB instance.
3. C. The security group assigned to the DB instance does not have the necessary rules to allow inbound connections from the application servers.
4. D. The user name and password are correct, but the user is not authorized to use the DB instance.

Correct Answer: C

A database specialist manages a critical Amazon RDS for MySQL DB instance for a company. The data stored daily could vary from .01% to 10% of the current database size. The database specialist needs to ensure that the DB instance storage grows as needed.
What is the MOST operationally efficient and cost-effective solution?

1. A. Configure RDS Storage Auto Scaling.
2. B. Configure RDS instance Auto Scaling.
3. C. Modify the DB instance allocated storage to meet the forecasted requirements.
4. D. Monitor the Amazon CloudWatch FreeStorageSpace metric daily and add storage as required.

Correct Answer: A
If your workload is unpredictable, you can enable storage autoscaling for an Amazon RDS DB instance. With storage autoscaling enabled, when Amazon RDS detects that you are running out of free database space it automatically scales up your storage.
https://aws.amazon.com/about-aws/whats-new/2019/06/rds-storage-auto-scaling/
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PIOPS.StorageTypes.html#USER_PIOPS.