Free Amazon DBS-C01 Exam Dumps Questions & Answers

A company is load testing its three-tier production web application deployed with an AWS CloudFormation template on AWS. The Application team is making changes to deploy additional Amazon EC2 and AWS Lambda resources to expand the load testing capacity. A Database Specialist wants to ensure that the changes made by the Application team will not change the Amazon RDS database resources already deployed.
Which combination of steps would allow the Database Specialist to accomplish this? (Choose two.)

• A.  Review the stack drift before modifying the template
• B.  Define the database resources in a nested stack
• C.  Create and review a change set before applying it
• D.  Export the database resources as stack outputs
• E.  Set a stack policy for the database resources

A corporation is transitioning from an IBM Informix database to an Amazon RDS for SQL Server Multi-AZ implementation with Always On Availability Groups (AGs). SQL Server Agent tasks are scheduled to execute at 5-minute intervals on the Always On AG listener to synchronize data between the Informix and SQL Server databases. After a successful failover to the backup node with minimum delay, users endure hours of stale data.
How can a database professional guarantee that consumers view the most current data after a failover?

• A.  Break up large transactions into multiple smaller transactions that complete in less than 5 minutes.
• B.  Set TTL to less than 30 seconds for cached DNS values on the Always On AG listener.
• C.  Set the databases on the secondary node to read-only mode.
• D.  Create the SQL Server Agent jobs on the secondary node from a script when the secondary node takes over after a failure.

A company needs to deploy an Amazon Aurora PostgreSQL DB instance into multiple accounts. The company will initiate each DB instance from an existing Aurora PostgreSQL DB instance that runs in a shared account. The company wants the process to be repeatable in case the company adds additional accounts in the future. The company also wants to be able to verify if manual changes have been made to the DB instance configurations after the company deploys the DB instances.
A database specialist has determined that the company needs to create an AWS CloudFormation template with the necessary configuration to create a DB instance in an account by using a snapshot of the existing DB instance to initialize the DB instance. The company will also use the CloudFormation template's parameters to provide key values for the DB instance creation (account ID, etc.).
Which final step will meet these requirements in the MOST operationally efficient way?

• A.  Set up CloudFormation to use drift detection to send notifications if the DB instance configurations have been changed.
• B.  Create an AWS Lambda function to compare the configuration to the current DB instance configuration and to report any changes.
• C.  Use the CloudFormation drift detection feature to check if the DB instance configurations have changed.
• D.  Create a bash script to compare the configuration to the current DB instance configuration and to report any changes.

A large ecommerce company uses Amazon DynamoDB to handle the transactions on its web portal. Traffic patterns throughout the year are usually stable; however, a large event is planned. The company knows that traffic will increase by up to 10 times the normal load over the 3-day event. When sale prices are published during the event, traffic will spike rapidly.
How should a Database Specialist ensure DynamoDB can handle the increased traffic?

• A.  Allow burst capacity to handle the additional load
• B.  Set an AWS Application Auto Scaling policy for the table to handle the increase in traffic
• C.  Ensure the table is always provisioned to meet peak needs
• D.  Preprovision additional capacity for the known peaks and then reduce the capacity after the event

A company requires near-real-time notifications when changes are made to Amazon RDS DB security groups.
Which solution will meet this requirement with the LEAST operational overhead?

• A.  Create an AWS Lambda function that monitors DB security group changes. Create an Amazon Simple Notification Service (Amazon SNS) topic for notification.
• B.  Turn on AWS CloudTrail. Configure notifications for the detection of changes to DB security groups.
• C.  Configure an Amazon CloudWatch alarm for RDS metrics about changes to DB security groups.
• D.  Configure an RDS event notification subscription for DB security group events.