Database Specialty (Page 31)

A financial company is running an Amazon Redshift cluster for one of its data warehouse solutions.The company needs to generate connection logs, user logs, and user activity logs.The company also must make these logs available for future analysis.Which combination of steps should a database specialist take to meet these requirements? (Choose two.)Read More →

A company requires near-real-time notifications when changes are made to Amazon RDS DB security groups.Which solution will meet this requirement with the LEAST operational overhead?Read More →

A software-as-a-service (SaaS) company is using an Amazon Aurora Serverless DB cluster for its production MySQL database.The DB cluster has general logs and slow query logs enabled.A database engineer must use the most operationally efficient solution with minimal resource utilization to retain the logs and facilitate interactive search and analysis.Which solution meets these requirements?Read More →

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 →