Database Specialty (Page 15)

A company is developing an application that performs intensive in-memory operations on advanced data structures such as sorted sets.The application requires sub-millisecond latency for reads and writes.The application occasionally must run a group of commands as an ACID-compliant operation.A database specialist is setting up the database for this application.The database specialist needs the ability to create a new database cluster from the latest backup of the production cluster.Which type of cluster should the database specialist create to meet these requirements?Read More →

A database specialist is working on an Amazon RDS for PostgreSQL DB instance that is experiencing application performance issues due to the addition of new workloads.The database has 5 ׀¢׀’ of storage space with Provisioned IOPS.Amazon CloudWatch metrics show that the average disk queue depth is greater than200 and that the disk I/O response time is significantly higher than usual.What should the database specialist do to improve the performance of the application immediately?Read More →

A company has an on-premises production Microsoft SQL Server with 250 GB of data in one database.A database specialist needs to migrate this on-premisesSQL Server to Amazon RDS for SQL Server.The nightly native SQL Server backup file is approximately 120 GB in size.The application can be down for an extended period of time to complete the migration.Connectivity between the on-premises environment and AWS can be initiated from on-premises only.How can the database be migrated from on-premises to Amazon RDS with the LEAST amount of effort?Read More →

A database specialist was alerted that a production Amazon RDS MariaDB instance with 100 GB of storage was out of space.In response, the database specialist modified the DB instance and added 50 GB of storage capacity.Three hours later, a new alert is generated due to a lack of free space on the same DB instance.The database specialist decides to modify the instance immediately to increase its storage capacity by 20 GB.What will happen when the modification is submitted?Read More →

A company is going through a security audit.The audit team has identified cleartext master user password in the AWS CloudFormation templates for AmazonRDS for MySQL DB instances.The audit team has flagged this as a security risk to the database team.What should a database specialist do to mitigate this risk?Read More →

A company hosts an on-premises Microsoft SQL Server Enterprise edition database with Transparent Data Encryption (TDE) enabled.The database is 20 TB in size and includes sparse tables.The company needs to migrate the database to Amazon RDS for SQL Server during a maintenance window that is scheduled for an upcoming weekend.Data-at-rest encryption must be enabled for the target DB instance.Which combination of steps should the company take to migrate the database to AWS in the MOST operationally efficient manner? (Choose two.)Read More →

A company uses Amazon DynamoDB to store its customer data.The DynamoDB table is designed with the user ID as the partition key value and multiple other non-key attributes.An external application needs to access data for specific user IDs.The external application must have access only to items with specific partition key values.What should the database specialist do to meet these requirements?Read More →

A company has an AWS CloudFormation template written in JSON that is used to launch new Amazon RDS for MySQL DB instances.The security team has asked a database specialist to ensure that the master password is automatically rotated every 30 days for all new DB instances that are launched using the template.What is the MOST operationally efficient solution to meet these requirements?Read More →

A software company uses an Amazon RDS for MySQL Multi-AZ DB instance as a data store for its critical applications.During an application upgrade process, a database specialist runs a custom SQL script that accidentally removes some of the default permissions of the master user.What is the MOST operationally efficient way to restore the default permissions of the master user?Read More →

An IT company wants to reduce its database operation costs in its development environment.The company’s workflow creates an Amazon Aurora MySQL DB cluster for each development group.The DB clusters are used for only 8 hours a day.The DB clusters can be deleted at the end of a development cycle, which lasts 2 weeks.Which solution will meet these requirements MOST cost-effectively?Read More →