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?

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

Correct Answer: C
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_WorkingWithParamGroups.html#USER_W

A Database Specialist is planning to create a read replica of an existing Amazon RDS for MySQL Multi-AZ DB instance. When using the AWS Management Console to conduct this task, the Database Specialist discovers that the source RDS DB instance does not appear in the read replica source selection box, so the read replica cannot be created.
What is the most likely reason for this?

1. A. The source DB instance has to be converted to Single-AZ first to create a read replica from it.
2. B. Enhanced Monitoring is not enabled on the source DB instance.
3. C. The minor MySQL version in the source DB instance does not support read replicas.
4. D. Automated backups are not enabled on the source DB instance.

Correct Answer: D
>Your source DB instance must have backup retention enabled. https://docs.aws.amazon.com/AmazonRDS/latest/APIReference/API_CreateDBInstanceReadReplica.html

A ride-hailing application uses an Amazon RDS for MySQL DB instance as persistent storage for bookings. This application is very popular and the company expects a tenfold increase in the user base in next few months. The application experiences more traffic during the morning and evening hours.
This application has two parts:
An in-house booking component that accepts online bookings that directly correspond to simultaneous requests from users.
A third-party customer relationship management (CRM) component used by customer care representatives. The CRM uses queries to access booking data.
A database specialist needs to design a cost-effective database solution to handle this workload. Which solution meets these requirements?

1. A. Use Amazon ElastiCache for Redis to accept the booking
2. B. Associate an AWS Lambda function to capture changes and push the booking data to the RDS for MySQL DB instance used by the CRM.
3. C. Use Amazon DynamoDB to accept the booking
4. D. Enable DynamoDB Streams and associate an AWS Lambda function to capture changes and push the booking data to an Amazon SQS queu
5. E. This triggers another Lambda function that pulls data from Amazon SQS and writes it to the RDS for MySQL DB instance used by the CRM.
6. F. Use Amazon ElastiCache for Redis to accept the booking
7. G. Associate an AWS Lambda function to capture changes and push the booking data to an Amazon Redshift database used by the CRM.
8. H. Use Amazon DynamoDB to accept the booking
9. I. Enable DynamoDB Streams and associate an AWS Lambda function to capture changes and push the booking data to Amazon Athena, which is used by the CRM.

Correct Answer: D

A business maintains a SQL Server database on-premises. Active Directory authentication is used to provide users access to the database. The organization transferred their database successfully to Amazon RDS for SQL Server. The organization, however, has reservations regarding user authentication in the AWS Cloud environment.
Which authentication solution should a database professional provide?

1. A. Deploy Active Directory Federation Services (AD FS) on premises and configure it with an on-premises Active Director
2. B. Set up delegation between the on- premises AD FS and AWS Security Token Service (AWS STS) to map user identities to a role using theAmazonRDSDirectoryServiceAccess managed IAM policy.
3. C. Establish a forest trust between the on-premises Active Directory and AWS Directory Service for Microsoft Active Director
4. D. Use AWS SSO to configure an Active Directory user delegated to access the databases in RDS for SQL Server.
5. E. Use Active Directory Connector to redirect directory requests to the company€™s on-premises Active Directory without caching any information in the clou
6. F. Use the RDS master user credentials to connect to the DB instance and configure SQL Server logins and users from the Active Directory users and groups.
7. G. Establish a forest trust between the on-premises Active Directory and AWS Directory Service for Microsoft Active Director
8. H. Ensure RDS for SQL Server is using mixed mode authenticatio
9. I. Use the RDS master user credentials to connect to the DB instance and configure SQL Server logins and users from the Active Directory users and groups.

Correct Answer: D
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_SQLServerWinAuth.html

A company has applications running on Amazon EC2 instances in a private subnet with no internet connectivity. The company deployed a new application that uses Amazon DynamoDB, but the application cannot connect to the DynamoDB tables. A developer already checked that all permissions are set correctly.
What should a database specialist do to resolve this issue while minimizing access to external resources?

1. A. Add a route to an internet gateway in the subnet’s route table.
2. B. Add a route to a NAT gateway in the subnet’s route table.
3. C. Assign a new security group to the EC2 instances with an outbound rule to ports 80 and 443.
4. D. Create a VPC endpoint for DynamoDB and add a route to the endpoint in the subnet’s route table.

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