Free DBS-C01 Exam Braindumps

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?

1. A. Aurora will promote an Aurora Replica that is of the same size as the primary instance
2. B. Aurora will promote an arbitrary Aurora Replica
3. C. Aurora will promote the largest-sized Aurora Replica
4. D. Aurora will not promote an Aurora Replica

Correct Answer: C
Priority: If you don't select a value, the default is tier-1. This priority determines the order in which Aurora https://docs.amazonaws.cn/en_us/AmazonRDS/latest/AuroraUserGuide/aurora-replicas-adding.html
More than one Aurora Replica can share the same priority, resulting in promotion tiers. If two or more Aurora Replicas share the same priority, then Amazon RDS promotes the replica that is largest in size. If two or more Aurora Replicas share the same priority and size, then Amazon RDS promotes an arbitrary replica in the same promotion tier.
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.Managing.Backups.html#Aurora.M If two or more Aurora Replicas share the same priority, then Amazon RDS promotes the replica that is largest in size. If two or more Aurora Replicas share the same priority and size, then Amazon RDS promotes an
arbitrary replica in the same promotion tier. https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Concepts.AuroraHighAvailability.html

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

1. A. Set the DeletionProtection property to True.
2. B. Set the MultiAZ property to True.
3. C. Set the TerminationProtection property to True.
4. D. Set the DeleteAutomatedBackups property to False.
5. E. Set the DeletionPolicy attribute to No.
6. F. Set the DeletionPolicy attribute to Retain.

Correct Answer: ADF

A business is transferring its on-premises database workloads to the Amazon Web Services (AWS) Cloud. A database professional migrating an Oracle database with a huge table to Amazon RDS has picked AWS DMS. The database professional observes that AWS DMS is consuming considerable time migrating the data.
Which activities would increase the pace of data migration? (Select three.)

1. A. Create multiple AWS DMS tasks to migrate the large table.
2. B. Configure the AWS DMS replication instance with Multi-AZ.
3. C. Increase the capacity of the AWS DMS replication server.
4. D. Establish an AWS Direct Connect connection between the on-premises data center and AWS.
5. E. Enable an Amazon RDS Multi-AZ configuration.
6. F. Enable full large binary object (LOB) mode to migrate all LOB data for all large tables.

Correct Answer: ACD
https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Tasks.LOBSupport.html

A security team is conducting an audit for a financial company. The security team discovers that the database credentials of an Amazon RDS for MySQL DB instance are hardcoded in the source code. The source code is stored in a shared location for automatic deployment and is exposed to all users who can access the location.
A database specialist must use encryption to ensure that the credentials are not visible in the source code. Which solution will meet these requirements?

1. A. Use an AWS Key Management Service (AWS KMS) key to encrypt the most recent database backup.Restore the backup as a new database to activate encryption.
2. B. Store the source code to access the credentials in an AWS Systems Manager Parameter Store secure string parameter that is encrypted by AWS Key Management Service (AWS KMS). Access the code with calls to Systems Manager.
3. C. Store the credentials in an AWS Systems Manager Parameter Store secure string parameter that is encrypted by AWS Key Management Service (AWS KMS). Access the credentials with calls to Systems Manager.
4. D. Use an AWS Key Management Service (AWS KMS) key to encrypt the DB instance at res
5. E. Activate RDS encryption in transit by using SSL certificates.

Correct Answer: C
only creds in system manager secure parameter.

A business is launching a new Amazon RDS for SQL Server database instance. The organization wishes to allow auditing of the SQL Server database.
Which measures should a database professional perform in combination to achieve this requirement? (Select two.)

1. A. Create a service-linked role for Amazon RDS that grants permissions for Amazon RDS to store audit logs on Amazon S3.
2. B. Set up a parameter group to configure an IAM role and an Amazon S3 bucket for audit log storage.Associate the parameter group with the DB instance.
3. C. Disable Multi-AZ on the DB instance, and then enable auditin
4. D. Enable Multi-AZ after auditing is enabled.
5. E. Disable automated backup on the DB instance, and then enable auditin
6. F. Enable automated backup after auditing is enabled.
7. G. Set up an options group to configure an IAM role and an Amazon S3 bucket for audit log storage.Associate the options group with the DB instance.

Correct Answer: AE
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.SQLServer.Options.Audit.html https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/security_iam_service-with-iam.html