Instant Access Amazon.DBS-C01.v2023-12-26.q241 Actual Practice Test Engine for Free (Page 8)

Question 31

A company has more than 100 AWS accounts that need Amazon RDS instances. The company wants to build an automated solution to deploy the RDS instances with specific compliance parameters. The data does not need to be replicated. The company needs to create the databases within 1 day Which solution will meet these requirements in the MOST operationally efficient way?

A.Create RDS resources by using AWS CloudFormation. Share the CloudFormation template with each account.
B.Create an RDS snapshot. Share the snapshot With each account Deploy the snapshot into each account
C.use AWS CloudFormation to create RDS instances in each account. Run AWS Database Migration Service (AWS DMS) replication to each ot the created instances.
D.Create a script by using the AWS CLI to copy the ROS instance into the other accounts from a template account.

Question 32

A company has an on-premises production Microsoft SQL Server with 250 GB of data in one database. A database specialist needs to migrate this on-premises SQL Server to Amazon RDS for SQL Server. The nightly native SQL Server backup file is approximately 120 GB in size. The application can be down for an extended period of time to complete the migration. Connectivity between the on-premises environment and AWS can be initiated from on-premises only.
How can the database be migrated from on-premises to Amazon RDS with the LEAST amount of effort?

A.Back up the SQL Server database using a native SQL Server backup. Upload the backup files to Amazon S3. Download the backup files on an Amazon EC2 instance and restore them from the EC2 instance into the new production RDS instance.
B.Back up the SQL Server database using a native SQL Server backup. Upload the backup files to Amazon S3. Restore the backup files from the S3 bucket into the new production RDS instance.
C.Provision and configure AWS DMS. Set up replication between the on-premises SQL Server environment to replicate the database to the new production RDS instance.
D.Back up the SQL Server database using AWS Backup. Once the backup is complete, restore the completed backup to an Amazon EC2 instance and move it to the new production RDS instance.

Question 33

A company has a web application that uses Amazon API Gateway to route HTTPS requests to AWS Lambda functions. The application uses an Amazon Aurora MySQL database for its data storage. The application has experienced unpredictable surges in traffic that overwhelm the database with too many connection requests.
The company needs to implement a scalable solution that is more resilient to database failures as quickly as possible.
Which solution will meet these requirements MOST cost-effectively?

A.Migrate the Aurora MySQL database to Amazon Aurora Serverless by restoring a snapshot. Change the endpoint in the Lambda functions to use the new database.
B.Migrate the Aurora MySQL database to Amazon DynamoDB tables by using AWS Database Migration Service (AWS DMS). Change the endpoint in the Lambda functions to use the new database.
C.Create an Amazon EventBridge rule that invokes a Lambda function. Code the function to iterate over all existing connections and to call MySQL queries to end any connections in the sleep state.
D.Increase the instance class for the Aurora database with more memory. Set a larger value for the max_connections parameter.

Correct Answer: A

Explanation from Amazon documents:
Amazon Aurora Serverless is an on-demand, auto-scaling configuration for Amazon Aurora MySQL that automatically starts up, shuts down, and scales capacity up or down based on your application's needs. Aurora Serverless is ideal for applications with unpredictable or intermittent traffic patterns that experience sudden spikes or drops in demand. Aurora Serverless also provides high availability and durability by replicating your data across multiple Availability Zones and continuously backing up your data to Amazon S3.
Migrating the Aurora MySQL database to Amazon Aurora Serverless by restoring a snapshot will meet the requirements of implementing a scalable solution that is more resilient to database failures as quickly as possible. This solution will allow the company to benefit from the auto-scaling and high availability features of Aurora Serverless, which will handle the unpredictable surges in traffic and prevent connection issues. This solution will also be cost-effective, as the company will only pay for the database capacity that they use. The migration process will be simple and fast, as the company can use the AWS Management Console, the AWS CLI, or the RDS API to restore a snapshot of their existing Aurora MySQL database to an Aurora Serverless DB cluster, and then change the endpoint in the Lambda functions to use the new database.
Therefore, option A is the correct solution to meet the requirements. Option B is not cost-effective because migrating the Aurora MySQL database to Amazon DynamoDB tables by using AWS DMS will incur additional time and cost, and may require significant code changes to adapt to a different data model and query language. Option C is not scalable because creating an EventBridge rule that invokes a Lambda function to end any connections in the sleep state will not address the root cause of the connection issues, which is the lack of database capacity to handle the traffic spikes. Option D is not scalable because increasing the instance class for the Aurora database with more memory and setting a larger value for the max_connections parameter will not provide auto-scaling or high availability, and may still result in connection issues if the traffic exceeds the provisioned capacity.

Question 34

An ecommerce company uses Amazon DynamoDB as the backend for its payments system. A new regulation requires the company to log all data access requests for financial audits. For this purpose, the company plans to use AWS logging and save logs to Amazon S3 How can a database specialist activate logging on the database?

A.Use AWS CloudTrail to monitor DynamoDB control-plane operations. Create a DynamoDB stream to monitor data-plane operations. Pass the stream to Amazon Kinesis Data Streams. Use that stream as a source for Amazon Kinesis Data Firehose to store the data in an Amazon S3 bucket.
B.Use AWS CloudTrail to monitor DynamoDB data-plane operations. Create a DynamoDB stream to monitor control-plane operations. Pass the stream to Amazon Kinesis Data Streams. Use that stream as a source for Amazon Kinesis Data Firehose to store the data in an Amazon S3 bucket.
C.Create two trails in AWS CloudTrail. Use Trail1 to monitor DynamoDB control-plane operations. Use Trail2 to monitor DynamoDB data-plane operations.
D.Use AWS CloudTrail to monitor DynamoDB data-plane and control-plane operations.

Question 35

A Database Specialist modified an existing parameter group currently associated with a production Amazon RDS for SQL Server Multi-AZ DB instance. The change is associated with a static parameter type, which controls the number of user connections allowed on the most critical RDS SQL Server DB instance for the company. This change has been approved for a specific maintenance window to help minimize the impact on users.
How should the Database Specialist apply the parameter group change for the DB instance?

A.Select the option to apply the change immediately
B.Allow the preconfigured RDS maintenance window for the given DB instance to control when the change is applied
C.Apply the change manually by rebooting the DB instance during the approved maintenance window
D.Reboot the secondary Multi-AZ DB instance

Question 31

Question 32

Question 33

Question 34

Question 35

Download PDF File