Database Specialty (Page 18)

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 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 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 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 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 migrating a 2 TB Amazon RDS for Oracle DB instance to an RDS for PostgreSQL DB instance using AWS DMS.The source RDS OracleDB instance is in a VPC in the us-east-1 Region.The target RDS for PostgreSQL DB instance is in a VPC in the use-west-2 Region.Where should the AWS DMS replication instance be placed for the MOST optimal performance?Read More →

An ecommerce company is running AWS Database Migration Service (AWS DMS) to replicate an on-premises Microsoft SQL Server database to Amazon RDS for SQL Server.The company has set up an AWS Direct Connect connection from its on-premises data center to AWS.During the migration, the company’s security team receives an alarm that is related to the migration.The security team mandates that the DMS replication instance must not be accessible from publicIP addresses.What should a database specialist do to meet this requirement?Read More →

A database specialist needs to reduce the cost of an application’s database.The database is running on a Multi-AZ deployment of an Amazon RDS for Microsoft SQL Server DB instance.The application requires the database to support stored procedures, SQL Server Wire Protocol (TDS), and T-SQL.The database must also be highly available.The database specialist is using AWS Database Migration Service (AWS DMS) to migrate the database to a new data store.Which solution will reduce the cost of the database with the LEAST effort?Read More →

A company has more than 100 AWS accounts that need Amazon RDS instances.The company wants to build an automated solution to deploy the RDS instances with specific compliance parameters.The data does not need to be replicated.The company needs to create the databases within 1 day.Which solution will meet these requirements in the MOST operationally efficient way?Read More →

A social media company recently launched a new feature that gives users the ability to share live feeds of their daily activities with their followers.The company has an Amazon RDS for MySQL DB instance that stores data about follower engagement.After the new feature launched, the company noticed high CPU utilization and high database latency during reads and writes.The company wants to implement a solution that will identify the source of the high CPU utilization.Which solution will meet these requirements with the LEAST administrative oversight?Read More →