Database Specialty (Page 30)

An ecommerce company is running Amazon RDS for Microsoft SQL Server.The company is planning to perform testing in a development environment with production data.The development environment and the production environment are in separate AWS accounts.Both environments use AWS Key Management Service (AWS KMS) encrypted databases with both manual and automated snapshots.A database specialist needs to share a KMS encrypted production RDS snapshot with the development account.Which combination of steps should the database specialist take to meet these requirements? (Choose three.)Read More →

A company has an ecommerce website that runs on AWS.The website uses an Amazon RDS for MySQL database.A database specialist wants to enforce the use of temporary credentials to access the database.Which solution will meet this requirement?Read More →

A company has an application that uses an Amazon DynamoDB table as its data store.During normal business days, the throughput requirements from the application are uniform and consist of 5 standard write calls per second to the DynamoDB table.Each write call has 2 KB of data.For 1 hour each day, the company runs an additional automated job on the DynamoDB table that makes 20 write requests per second.No other application writes to the DynamoDB table.The DynamoDB table does not have to meet any additional capacity requirements.How should a database specialist configure the DynamoDB table’s capacity to meet these requirements MOST cost-effectively?Read More →

A company is using a Single-AZ Amazon RDS for MySQL DB instance for development.The DB instance is experiencing slow performance when queries run.Amazon CloudWatch metrics indicate that the instance requires more I/O capacity.Which actions can a database specialist perform to resolve this issue? (Choose two.)Read More →

A database specialist needs to delete user data and sensor data 1 year after it was loaded in an Amazon DynamoDB table.TTL is enabled on one of the attributes.The database specialist monitors TTL rates on the Amazon CloudWatch metrics for the table and observes that items are not being deleted as expected.What is the MOST likely reason that the items are not being deleted?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 →

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