Database Specialty (Page 11)

A security team is conducting an audit for a financial company.The security team discovers that the database credentials of an Amazon RDS for MySQL DB instance are hardcoded in the source code.The source code is stored in a shared location for automatic deployment and is exposed to all users who can access the location.A database specialist must use encryption to ensure that the credentials are not visible in the source code.Which solution will meet these requirements?Read More →

A company hosts an internal file-sharing application running on Amazon EC2 instances in VPC_A.This application is backed by an Amazon ElastiCache cluster, which is in VPC_B and peered with VPC_A.The company migrates its application instances from VPC_A to VPC_B.Logs indicate that the file-sharing application no longer can connect to the ElastiCache cluster.What should a database specialist do to resolve this issue?Read More →

A company recently migrated its line-of-business (LOB) application to AWS.The application uses an Amazon RDS for SQL Server DB instance as its database engine.The company must set up cross-Region disaster recovery for the application.The company needs a solution with the lowest possible RPO and RTO.Which solution will meet these requirements?Read More →

A database specialist must load 25 GB of data files from a company’s on-premises storage to an Amazon Neptune database.Which approach to load the data is FASTEST?Read More →

A large retail company recently migrated its three-tier ecommerce applications to AWS.The company’s backend database is hosted on Amazon AuroraPostgreSQL.During peak times, users complain about longer page load times.A database specialist reviewed Amazon RDS Performance Insights and found a spike in IO:XactSync wait events.The SQL attached to the wait events are all single INSERT statements.How should this issue be resolved?Read More →

A company is running a two-tier ecommerce application in one AWS account.The web server is deployed using an Amazon RDS for MySQL Multi-AZ DB instance.A Developer mistakenly deleted the database in the production environment.The database has been restored, but this resulted in hours of downtime and lost revenue.Which combination of changes in existing IAM policies should a Database Specialist make to prevent an error like this from happening in the future? (Choose three.)Read More →

A company uses an Amazon RDS for PostgreSQL database in the us-east-2 Region.The company wants to have a copy of the database available in the us-west-2 Region as part of a new disaster recovery strategy.A database architect needs to create the new database.There can be little to no downtime to the source database.The database architect has decided to use AWS Database Migration Service (AWS DMS) to replicate the database across Regions.The database architect will use full load mode and then will switch to change data capture (CDC) mode.Which parameters must the database architect configure to support CDC mode for the RDS for PostgreSQL database? (Choose three.)Read More →

A company is closing one of its remote data centers.This site runs a 100 TB on-premises data warehouse solution.The company plans to use the AWS SchemaConversion Tool (AWS SCT) and AWS DMS for the migration to AWS.The site network bandwidth is 500 Mbps.A Database Specialist wants to migrate the on- premises data using Amazon S3 as the data lake and Amazon Redshift as the data warehouse.This move must take place during a 2-week period when source systems are shut down for maintenance.The data should stay encrypted at rest and in transit.Which approach has the least risk and the highest likelihood of a successful data transfer?Read More →

A company has deployed an e-commerce web application in a new AWS account.An Amazon RDS for MySQL Multi-AZ DB instance is part of this deployment with a database-1.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com endpoint listening on port 3306.The company’s Database Specialist is able to log in to MySQL and run queries from the bastion host using these details.When users try to utilize the application hosted in the AWS account, they are presented with a generic error message.The application servers are logging a `could not connect to server: Connection times out` error message to Amazon CloudWatch Logs.What is the cause of this error?Read More →

The Development team recently executed a database script containing several data definition language (DDL) and data manipulation language (DML) statements on an Amazon Aurora MySQL DB cluster.The release accidentally deleted thousands of rows from an important table and broke some application functionality.This was discovered 4 hours after the release.Upon investigation, a Database Specialist tracked the issue to a DELETE command in the script with an incorrectWHERE clause filtering the wrong set of rows.The Aurora DB cluster has Backtrack enabled with an 8-hour backtrack window.The Database Administrator also took a manual snapshot of the DB cluster before the release started.The database needs to be returned to the correct state as quickly as possible to resume full application functionality.Data loss must be minimal.How can the Database Specialist accomplish this?Read More →