Database Specialty (Page 3)

A city’s weather forecast team is using Amazon DynamoDB in the data tier for an application.The application has several components.The analysis component of the application requires repeated reads against a large dataset.The application has started to temporarily consume all the read capacity in the DynamoDB table and is negatively affecting other applications that need to access the same data.Which solution will resolve this issue with the LEAST development effort?Read More →

An ecommerce company is migrating its core application database to Amazon Aurora MySQL.The company is currently performing online transaction processing(OLTP) stress testing with concurrent database sessions.During the first round of tests, a database specialist noticed slow performance for some specific write operations.Reviewing Amazon CloudWatch metrics for the Aurora DB cluster showed 90% CPU utilization.Which steps should the database specialist take to MOST effectively identify the root cause of high CPU utilization and slow performance? (Choose two.)Read More →

A company is working on migrating a large Oracle database schema with 3,500 stored procedures to Amazon Aurora PostgreSQL.An application developer is using the AWS Schema Conversion Tool (AWS SCT) to convert code from Oracle to Aurora PostgreSQL.However, the code conversion is taking a longer time with performance issues.The application team has reached out to a database specialist to improve the performance of the AWS SCT conversion.What should the database specialist do to resolve the performance issues?Read More →

A company’s application development team wants to share an automated snapshot of its Amazon RDS database with another team.The database is encrypted with a custom AWS Key Management Service (AWS KMS) key under the “WeShare” AWS account.The application development team needs to share the DB snapshot under the “WeReceive” AWS account.Which combination of actions must the application development team take to meet these requirements? (Choose two.)Read More →

An online gaming company is using an Amazon DynamoDB table in on-demand mode to store game scores.After an intensive advertisement campaign in SouthAmerica, the average number of concurrent users rapidly increases from 100,000 to 500,000 in less than 10 minutes every day around 5 PM.The on-call software reliability engineer has observed that the application logs contain a high number of DynamoDB throttling exceptions caused by game score insertions around 5 PM.Customer service has also reported that several users are complaining about their scores not being registered.How should the database administrator remediate this issue at the lowest cost?Read More →

A company with 500,000 employees needs to supply its employee list to an application used by human resources.Every 30 minutes, the data is exported using the LDAP service to load into a new Amazon DynamoDB table.The data model has a base table with Employee ID for the partition key and a global secondary index with Organization ID as the partition key.While importing the data, a database specialist receives ProvisionedThroughputExceededException errors.After increasing the provisioned write capacity units(WCUs) to 50,000, the specialist receives the same errors.Amazon CloudWatch metrics show a consumption of 1,500 WCUs.What should the database specialist do to address the issue?Read More →

A financial services company runs an on-premises MySQL database for a critical application.The company is dissatisfied with its current database disaster recovery (DR) solution.The application experiences a significant amount of downtime whenever the database fails over to its DR facility.The application also experiences slower response times when reports are processed on the same database.To minimize the downtime in DR situations, the company has decided to migrate the database to AWS.The company requires a solution that is highly available and the most cost-effective.Which solution meets these requirements?Read More →

A database specialist is launching a test graph database using Amazon Neptune for the first time.The database specialist needs to insert millions of rows of test observations from a .csv file that is stored in Amazon S3.The database specialist has been using a series of API calls to upload the data to the Neptune DB instance.Which combination of steps would allow the database specialist to upload the data faster? (Choose three.)Read More →

A pharmaceutical company uses Amazon Quantum Ledger Database (Amazon QLDB) to store its clinical trial data records.The company has an application that runs as AWS Lambda functions.The application is hosted in the private subnet in a VPC.The application does not have internet access and needs to read some of the clinical data records.The company is concerned that traffic between the QLDB ledger and the VPC could leave the AWS network.The company needs to secure access to the QLDB ledger and allow the VPC traffic to have read-only access.Which security strategy should a database specialist implement to meet these requirements?Read More →

A company has deployed an application that uses an Amazon RDS for MySQL DB cluster.The DB cluster uses three read replicas.The primary DB instance is an8XL-sized instance, and the read replicas are each XL-sized instances.Users report that database queries are returning stale data.The replication lag indicates that the replicas are 5 minutes behind the primary DB instance.Status queries on the replicas show that the SQL_THREAD is 10 binlogs behind the IO_THREAD and that the IO_THREAD is 1 binlog behind the primary.Which changes will reduce the lag? (Choose two.)Read More →