Database Specialty (Page 32)

A company has multiple applications serving data from a secure on-premises database.The company is migrating all applications and databases to the AWSCloud.The IT Risk and Compliance department requires that auditing be enabled on all secure databases to capture all log ins, log outs, failed logins, permission changes, and database schema changes.A Database Specialist has recommended Amazon Aurora MySQL as the migration target, and leveraging the AdvancedAuditing feature in Aurora.Which events need to be specified in the Advanced Auditing configuration to satisfy the minimum auditing requirements? (Choose three.)Read More →

A company has an on-premises SQL Server database.The users access the database using Active Directory authentication.The company successfully migrated its database to Amazon RDS for SQL Server.However, the company is concerned about user authentication in the AWS Cloud environment.Which solution should a database specialist provide for the user to authenticate?Read More →

A Database Specialist has migrated an on-premises Oracle database to Amazon Aurora PostgreSQL.The schema and the data have been migrated successfully.The on-premises database server was also being used to run database maintenance cron jobs written in Python to perform tasks including data purging and generating data exports.The logs for these jobs show that, most of the time, the jobs completed within 5 minutes, but a few jobs took up to 10 minutes to complete.These maintenance jobs need to be set up for Aurora PostgreSQL.How can the Database Specialist schedule these jobs so the setup requires minimal maintenance and provides high availability?Read More →

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 ManagementConsole 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?Read More →

A gaming company is designing a mobile gaming app that will be accessed by many users across the globe.The company wants to have replication and full support for multi-master writes.The company also wants to ensure low latency and consistent performance for app users.Which solution meets these requirements?Read More →