DBS-C01 (Page 18)

A company uses Amazon DynamoDB as the data store for its ecommerce website.The website receives little to no traffic at night, and the majority of the traffic occurs during the day.The traffic growth during peak hours is gradual and predictable on a daily basis, but it can be orders of magnitude higher than during off- peak hours.The company initially provisioned capacity based on its average volume during the day without accounting for the variability in traffic patterns.However, the website is experiencing a significant amount of throttling during peak hours.The company wants to reduce the amount of throttling while minimizing costs.What should a database specialist do to meet these requirements?Read More →

A pharmaceutical company’s drug search API is using an Amazon Neptune DB cluster.A bulk uploader process automatically updates the information in the database a few times each week.A few weeks ago during a bulk upload, a database specialist noticed that the database started to respond frequently with aThrottlingException error.The problem also occurred with subsequent uploads.The database specialist must create a solution to prevent ThrottlingException errors for the database.The solution must minimize the downtime of the cluster.Which solution meets these requirements?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 →

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 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 →

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 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 →

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 →