Database Specialty (Page 5)

A company wants to automate the creation of secure test databases with random credentials to be stored safely for later use.The credentials should have sufficient information about each test database to initiate a connection and perform automated credential rotations.The credentials should not be logged or stored anywhere in an unencrypted form.Which steps should a Database Specialist take to meet these requirements using an AWS CloudFormation template?Read More →

A company’s Security department established new requirements that state internal users must connect to an existing Amazon RDS for SQL Server DB instance using their corporate Active Directory (AD) credentials.A Database Specialist must make the modifications needed to fulfill this requirement.Which combination of actions should the Database Specialist take? (Choose three.)Read More →

A Database Specialist migrated an existing production MySQL database from on-premises to an Amazon RDS for MySQL DB instance.However, after the migration, the database needed to be encrypted at rest using AWS KMS.Due to the size of the database, reloading, the data into an encrypted database would be too time-consuming, so it is not an option.How should the Database Specialist satisfy this new requirement?Read More →

A company is about to launch a new product, and test databases must be re-created from production data.The company runs its production databases on anAmazon Aurora MySQL DB cluster.A Database Specialist needs to deploy a solution to create these test databases as quickly as possible with the least amount of administrative effort.What should the Database Specialist do to meet these requirements?Read More →

A media company is using Amazon RDS for PostgreSQL to store user data.The RDS DB instance currently has a publicly accessible setting enabled and is hosted in a public subnet.Following a recent AWS Well-Architected Framework review, a Database Specialist was given new security requirements.✑ Only certain on-premises corporate network IPs should connect to the DB instance.✑ Connectivity is allowed from the corporate network only.Which combination of steps does the Database Specialist need to take to meet these new requirements? (Choose three.)Read More →

An ecommerce company recently migrated one of its SQL Server databases to an Amazon RDS for SQL Server Enterprise Edition DB instance.The company expects a spike in read traffic due to an upcoming sale.A database specialist must create a read replica of the DB instance to serve the anticipated read traffic.Which actions should the database specialist take before creating the read replica? (Choose two.)Read More →

Accompany is using Amazon Redshift for its data warehouse.During review of the last few AWS monthly bills, a database specialist notices charges for Amazon Redshift backup storage.The database specialist needs to decrease the cost of these charges in the future and must create a solution that provides notification if the charges exceed a threshold.Which combination of actions will moot those requirements with the LEAST operational overhead? (Choose two.)Read More →

A global company needs to migrate from an on-premises Microsoft SQL Server database to a highly available database solution on AWS.The company wants to modernize its application and keep operational costs low.The current database includes secondary indexes and stored procedures that need to be included in the migration.The company has limited availability of database specialists to support the migration and wants to automate the process.Which solution will meet these requirements?Read More →

A bike rental company operates an application to track its bikes.The application receives location and condition data from bike sensors.The application also receives rental transaction data from the associated mobile app.The application uses Amazon DynamoDB as its database layer.The company has configured DynamoDB with provisioned capacity set to 20% above the expected peak load of the application.On an average day, DynamoDB used 22 billion read capacity units (RCUs) and 60 billion write capacity units (WCUs).The application is running well.Usage changes smoothly over the course of the day and is generally shaped like a bell curve.The timing and magnitude of peaks vary based on the weather and season, but the general shape is consistent.Which solution will provide the MOST cost optimization of the DynamoDB database layer?Read More →

A company uses Amazon DynamoDB as a data store for multi-tenant data.Approximately 70% of the reads by the company’s application are strongly consistent.The current key schema for the DynamoDB table is as follows:Partition key: OrgID -Sort key: TenantID#Version -Due to a change in design and access patterns, the company needs to support strongly consistent lookups based on the new schema below:Partition key: OrgID#TenantID -Sort key: Version -How can the database specialist implement this change?Read More →