DBS-C01 (Page 2)

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 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 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 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 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 is creating a serverless application that uses multiple AWS services and stores data on an Amazon RDS DB instance.The database credentials must be stored securely.An AWS Lambda function must be able to access the credentials.The company also must rotate the database password monthly by using an automated solution.What should a database specialist do to meet those requirements in the MOST secure manner?Read More →

A company wants to build a new invoicing service for its cloud-native application on AWS.The company has a small development team and wants to focus on service feature development and minimize operations and maintenance as much as possible.The company expects the service to handle billions of requests and millions of new records every day.The service feature requirements, including data access patterns are well-defined.The service has an availability target of99.99% with a milliseconds latency requirement.The database for the service will be the system of record for invoicing data.Which database solution meets these requirements at the LOWEST cost?Read More →

A company runs hundreds of Microsoft SQL Server databases on Windows servers in its on-premises data center.A database specialist needs to migrate these databases to Linux on AWS.Which combination of steps should the database specialist take to meet this requirement? (Choose three.)Read More →

A company wants to migrate its on-premises Oracle database to a managed open-source database engine in Amazon RDS by using AWS Database Migration Service (AWS DMS).A database specialist needs to identify the target engine in Amazon RDS based on the conversion percentage of database code objects such as stored procedures, functions, views, and database storage objects.The company will select the engine that has the least manual conversion effort.What should the database specialist do to identify the target engine?Read More →

A company uses an Amazon Aurora MySQL DB cluster with the most recent version of the MySQL database engine.The company wants all data that is transferred between clients and the DB cluster to be encrypted.What should a database specialist do to meet this requirement?Read More →