Free DBS-C01 Exam Braindumps

A database specialist is responsible for an Amazon RDS for MySQL DB instance with one read replica. The DB instance and the read replica are assigned to the default parameter group. The database team currently runs test queries against a read replica. The database team wants to create additional tables in the read replica that will only be accessible from the read replica to benefit the tests.
Which should the database specialist do to allow the database team to create the test tables?

1. A. Contact AWS Support to disable read-only mode on the read replic
2. B. Reboot the read replic
3. C. Connect to the read replica and create the tables.
4. D. Change the read_only parameter to false (read_only=0) in the default parameter group of the read replic
5. E. Perform a reboot without failove
6. F. Connect to the read replica and create the tables using the local_only MySQL option.
7. G. Change the read_only parameter to false (read_only=0) in the default parameter grou
8. H. Reboot the read replic
9. I. Connect to the read replica and create the tables.
10. J. Create a new DB parameter grou
11. K. Change the read_only parameter to false (read_only=0). Associate the read replica with the new grou
12. L. Reboot the read replic
13. M. Connect to the read replica and create the tables.

Correct Answer: D
https://aws.amazon.com/premiumsupport/knowledge-center/rds-read-replica/

A company recently acquired a new business. A database specialist must migrate an unencrypted 12 TB Amazon RDS for MySQL DB instance to a new AWS account. The database specialist needs to minimize the amount of time required to migrate the database.
Which solution meets these requirements?

1. A. Create a snapshot of the source DB instance in the source accoun
2. B. Share the snapshot with the destination accoun
3. C. In the target account, create a DB instance from the snapshot.
4. D. Use AWS Resource Access Manager to share the source DB instance with the destination account.Create a DB instance in the destination account using the shared resource.
5. E. Create a read replica of the DB instanc
6. F. Give the destination account access to the read replic
7. G. In the destination account, create a snapshot of the shared read replica and provision a new RDS for MySQL DB instance.
8. H. Use mysqldump to back up the source databas
9. I. Create an RDS for MySQL DB instance in the destination accoun
10. J. Use the mysql command to restore the backup in the destination database.

Correct Answer: A
Sharing an unencrypted manual DB snapshot enables authorized AWS accounts to directly restore a DB instance from the snapshot instead of taking a copy of it and restoring from that. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ShareSnapshot.html However Resource Access Manager could not share non-Aurora cluster. https://docs.aws.amazon.com/ram/latest/userguide/shareable.html

An ecommerce company uses a backend application that stores data in an Amazon DynamoDB table. The backend application runs in a private subnet in a VPC and must connect to this table.
The company must minimize any network latency that results from network connectivity issues, even during periods of heavy application usage. A database administrator also needs the ability to use a private connection to connect to the DynamoDB table from the application.
Which solution will meet these requirements?

1. A. Use network ACLs to ensure that any outgoing or incoming connections to any port except DynamoDB are deactivate
2. B. Encrypt API calls by using TLS.
3. C. Create a VPC endpoint for DynamoDB in the application's VP
4. D. Use the VPC endpoint to access the table.
5. E. Create an AWS Lambda function that has access to DynamoD
6. F. Restrict outgoing access only to this Lambda function from the application.
7. G. Use a VPN to route all communication to DynamoDB through the company's own corporate network infrastructure.

Correct Answer: B
https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/vpc-endpoints-dynamodb.html

To meet new data compliance requirements, a company needs to keep critical data durably stored and readily accessible for 7 years. Data that is more than 1 year old is considered archival data and must automatically be moved out of the Amazon Aurora MySQL DB cluster every week. On average, around 10 GB of new data is added to the database every month. A database specialist must choose the most operationally efficient solution to migrate the archival data to Amazon S3.
Which solution meets these requirements?

1. A. Create a custom script that exports archival data from the DB cluster to Amazon S3 using a SQL view, then deletes the archival data from the DB cluste
2. B. Launch an Amazon EC2 instance with a weekly cron job to execute the custom script.
3. C. Configure an AWS Lambda function that exports archival data from the DB cluster to Amazon S3 using a SELECT INTO OUTFILE S3 statement, then deletes the archival data from the DB cluste
4. D. Schedule the Lambda function to run weekly using Amazon EventBridge (Amazon CloudWatch Events).
5. E. Configure two AWS Lambda functions: one that exports archival data from the DB cluster to Amazon S3 using the mysqldump utility, and another that deletes the archival data from the DB cluste
6. F. Schedule both Lambda functions to run weekly using Amazon EventBridge (Amazon CloudWatch Events).
7. G. Use AWS Database Migration Service (AWS DMS) to continually export the archival data from the DB cluster to Amazon S3. Configure an AWS Data Pipeline process to run weekly that executes a custom SQL script to delete the archival data from the DB cluster.

Correct Answer: B
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Integrating.SaveIntoS3.htm

A company is using an Amazon RDS for MySQL DB instance for its internal applications. A security audit shows that the DB instance is not encrypted at rest. The company’s application team needs to encrypt the DB instance.
What should the team do to meet this requirement?

1. A. Stop the DB instance and modify it to enable encryptio
2. B. Apply this setting immediately without waiting for the next scheduled RDS maintenance window.
3. C. Stop the DB instance and create an encrypted snapsho
4. D. Restore the encrypted snapshot to a new encrypted DB instanc
5. E. Delete the original DB instance, and update the applications to point to the new encrypted DB instance.
6. F. Stop the DB instance and create a snapsho
7. G. Copy the snapshot into another encrypted snapsho
8. H. Restore the encrypted snapshot to a new encrypted DB instanc
9. I. Delete the original DB instance, and update the applications to point to the new encrypted DB instance.
10. J. Create an encrypted read replica of the DB instanc
11. K. Promote the read replica to maste
12. L. Delete the original DB instance, and update the applications to point to the new encrypted DB instance.

Correct Answer: C