A banking company recently launched an Amazon RDS for MySQL DB instance as part of a proof-of-concept project. A database specialist has configured automated database snapshots. As a part of routine testing, the database specialist noticed one day that the automated database snapshot was not created.
Which of the following are possible reasons why the snapshot was not created? (Choose two.)

• A.A copy of the RDS automated snapshot for this DB instance is in progress within the same AWS Region.
• B.A copy of the RDS automated snapshot for this DB instance is in progress in a different AWS Region.
• C.The RDS maintenance window is not configured.
• D.The RDS DB instance is in the STORAGE_FULL state.
• E.RDS event notifications have not been enabled.

Comment: *

Name: *

Email: *

Verification: *

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?

• A.Deploy Active Directory Federation Services (AD FS) on premises and configure it with an on-premises Active Directory. 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.
• B.Establish a forest trust between the on-premises Active Directory and AWS Directory Service for Microsoft Active Directory. Use AWS SSO to configure an Active Directory user delegated to access the databases in RDS for SQL Server.
• C.Use Active Directory Connector to redirect directory requests to the company's on-premises Active Directory without caching any information in the cloud. 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.
• D.Establish a forest trust between the on-premises Active Directory and AWS Directory Service for Microsoft Active Directory. Ensure RDS for SQL Server is using mixed mode authentication. 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.

Comment: *

Name: *

Email: *

Verification: *

A large retail company recently migrated its three-tier ecommerce applications to AWS. The company's backend database is hosted on Amazon Aurora PostgreSQL. During peak times, users complain about longer page load times. A database specialist reviewed Amazon RDS Performance Insights and found a spike in IO:XactSync wait events. The SQL attached to the wait events are all single INSERT statements.
How should this issue be resolved?

• A.Add a new Aurora Replica to the Aurora DB cluster.
• B.Add an Amazon ElastiCache for Redis cluster and change the application to write through.
• C.Modify the application to commit transactions in batches
• D.Change the Aurora DB cluster storage to Provisioned IOPS (PIOPS).

Comment: *

Name: *

Email: *

Verification: *

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.Ensure the table is always provisioned to meet peak needs
• C.Set an AWS Application Auto Scaling policy for the table to handle the increase in traffic
• D.Preprovision additional capacity for the known peaks and then reduce the capacity after the event

Comment: *

Name: *

Email: *

Verification: *

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.Create and review a change set before applying it
• C.Export the database resources as stack outputs
• D.Define the database resources in a nested stack
• E.Set a stack policy for the database resources

Comment: *

Name: *

Email: *

Verification: *