DBS-C01 (Page 23)

A company runs a MySQL database for its ecommerce application on a single Amazon RDS DB instance.Application purchases are automatically saved to the database, which causes intensive writes.Company employees frequently generate purchase reports.The company needs to improve database performance and reduce downtime due to patching for upgrades.Which approach will meet these requirements with the LEAST amount of operational overhead?Read More →

A company is using Amazon Neptune as the graph database for one of its products.The company’s data science team accidentally created large amounts of temporary information during an ETL process.The Neptune DB cluster automatically increased the storage space to accommodate the new data, but the data science team deleted the unused information.What should a database specialist do to avoid unnecessary charges for the unused cluster volume space?Read More →

A database specialist is responsible for designing a highly available solution for online transaction processing (OLTP) using Amazon RDS for MySQL production databases.Disaster recovery requirements include a cross-Region deployment along with an RPO of 5 minutes and RTO of 30 minutes.What should the database specialist do to align to the high availability and disaster recovery requirements?Read More →

A database specialist needs to configure an Amazon RDS for MySQL DB instance to close non-interactive connections that are inactive after 900 seconds.What should the database specialist do to accomplish this task?Read More →

The Amazon CloudWatch metric for FreeLocalStorage on an Amazon Aurora MySQL DB instance shows that the amount of local storage is below 10 MB.A database engineer must increase the local storage available in the Aurora DB instance.How should the database engineer meet this requirement?Read More →

A company is deploying a solution in Amazon Aurora by migrating from an on-premises system.The IT department has established an AWS Direct Connect link from the company’s data center.The company’s Database Specialist has selected the option to require SSL/TLS for connectivity to prevent plaintext data from being set over the network.The migration appears to be working successfully, and the data can be queried from a desktop machine.Two Data Analysts have been asked to query and validate the data in the new Aurora DB cluster.Both Analysts are unable to connect to Aurora.Their user names and passwords have been verified as valid and the Database Specialist can connect to the DB cluster using their accounts.The Database Specialist also verified that the security group configuration allows network from all corporate IP addresses.What should the Database Specialist do to correct the Data Analysts’ inability to connect?Read More →

A company is concerned about the cost of a large-scale, transactional application using Amazon DynamoDB that only needs to store data for 2 days before it is deleted.In looking at the tables, a Database Specialist notices that much of the data is months old, and goes back to when the application was first deployed.What can the Database Specialist do to reduce the overall cost?Read More →

A clothing company uses a custom ecommerce application and a PostgreSQL database to sell clothes to thousands of users from multiple countries.The company is migrating its application and database from its on-premises data center to the AWS Cloud.The company has selected Amazon EC2 for the application and Amazon RDS for PostgreSQL for the database.The company requires database passwords to be changed every 60 days.A Database Specialist needs to ensure that the credentials used by the web application to connect to the database are managed securely.Which approach should the Database Specialist take to securely manage the database credentials?Read More →

A company is running a finance application on an Amazon RDS for MySQL DB instance.The application is governed by multiple financial regulatory agencies.The RDS DB instance is set up with security groups to allow access to certain Amazon EC2 servers only.AWS KMS is used for encryption at rest.Which step will provide additional security?Read More →

A gaming company wants to deploy a game in multiple Regions.The company plans to save local high scores in Amazon DynamoDB tables in each Region.ADatabase Specialist needs to design a solution to automate the deployment of the database with identical configurations in additional Regions, as needed.The solution should also automate configuration changes across all Regions.Which solution would meet these requirements and deploy the DynamoDB tables?Read More →