Database Specialty (Page 29)

A company runs an ecommerce application on premises on Microsoft SQL Server.The company is planning to migrate the application to the AWS Cloud.The application code contains complex T-SQL queries and stored procedures.The company wants to minimize database server maintenance and operating costs after the migration is completed.The company also wants to minimize the need to rewrite code as part of the migration effort.Which solution will meet these requirements?Read More →

A company is using an Amazon RDS Multi-AZ DB instance in its development environment.The DB instance uses General Purpose SSD storage.The DB instance provides data to an application that has I/O constraints and high online transaction processing (OLTP) workloads.The users report that the application is slow.A database specialist finds a high degree of latency in the database writes.The database specialist must decrease the database latency by designing a solution that minimizes operational overhead.Which solution will meet these requirements?Read More →

A company performs an audit on various data stores and discovers that an Amazon S3 bucket is storing a credit card number.The S3 bucket is the target of an AWS Database Migration Service (AWS DMS) continuous replication task that uses change data capture (CDC).The company determines that this field is not needed by anyone who uses the target data.The company has manually removed the existing credit card data from the S3 bucket.What is the MOST operationally efficient way to prevent new credit card data from being written to the S3 bucket?Read More →

A company has a reporting application that runs on an Amazon EC2 instance in an isolated developer account on AWS.The application needs to retrieve data during non-peak company hours from an Amazon Aurora PostgreSQL database that runs in the company’s production account.The company’s security team requires that access to production resources complies with AWS best security practices.A database administrator needs to provide the reporting application with access to the production database.The company has already configured VPC peering between the production account and developer account.The company has also updated the route tables in both accounts with the necessary entries to correctly set up VPC peering.What must the database administrator do to finish providing connectivity to the reporting application?Read More →

A global company is creating an application.The application must be highly available.The company requires an RTO and an RPO of less than 5 minutes.The company needs a database that will provide the ability to set up an active-active configuration and near real-time synchronization of data across tables in multiple AWS Regions.Which solution will 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 →

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 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 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 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 →