DBS-C01

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 →

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 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 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 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 is releasing a new mobile game featuring a team play mode.As a group of mobile device users play together, an item containing their statuses is updated in an Amazon DynamoDB table.Periodically, the other users’ devices read the latest statuses of their teammates from the table using the BatchGetltemn operation.Prior to launch, some testers submitted bug reports claiming that the status data they were seeing in the game was not up-to-date.The developers are unable to replicate this issue and have asked a database specialist for a recommendation.Which recommendation would resolve this issue?Read More →

An ecommerce company has tasked a Database Specialist with creating a reporting dashboard that visualizes critical business metrics that will be pulled from the core production database running on Amazon Aurora.Data that is read by the dashboard should be available within 100 milliseconds of an update.The Database Specialist needs to review the current configuration of the Aurora DB cluster and develop a cost-effective solution.The solution needs to accommodate the unpredictable read workload from the reporting dashboard without any impact on the write availability and performance of the DB cluster.Which solution meets these requirements?Read More →

A manufacturing company has an.inventory system that stores information in an Amazon Aurora MySQL DB cluster.The database tables are partitioned.The database size has grown to 3 TB.Users run one-time queries by using a SQL client.Queries that use an equijoin to join large tables are taking a long time to run.Which action will improve query performance with the LEAST operational effort?Read More →

A database specialist needs to move an Amazon RDS DB instance from one AWS account to another AWS account.Which solution will meet this requirement with the LEAST operational effort?Read More →

A global digital advertising company captures browsing metadata to contextually display relevant images, pages, and links to targeted users.A single page load can generate multiple events that need to be stored individually.The maximum size of an event is 200 KB and the average size is 10 KB.Each page load must query the user’s browsing history to provide targeting recommendations.The advertising company expects over 1 billion page visits per day from users in theUnited States, Europe, Hong Kong, and India.The structure of the metadata varies depending on the event.Additionally, the browsing metadata must be written and read with very low latency to ensure a good viewing experience for the users.Which database solution meets these requirements?Read More →