DBS-C01 (Page 20)

A retail company with its main office in New York and another office in Tokyo plans to build a database solution on AWS.The company’s main workload consists of a mission-critical application that updates its application data in a data store.The team at the Tokyo office is building dashboards with complex analytical queries using the application data.The dashboards will be used to make buying decisions, so they need to have access to the application data in less than 1 second.Which solution meets these requirements?Read More →

A database specialist at a large multi-national financial company is in charge of designing the disaster recovery strategy for a highly available application that is in development.The application uses an Amazon DynamoDB table as its data store.The application requires a recovery time objective (RTO) of 1 minute and a recovery point objective (RPO) of 2 minutes.Which operationally efficient disaster recovery strategy should the database specialist recommend for the DynamoDB table?Read More →

A small startup company is looking to migrate a 4 TB on-premises MySQL database to AWS using an Amazon RDS for MySQL DB instance.Which strategy would allow for a successful migration with the LEAST amount of downtime?Read More →

A database specialist deployed an Amazon RDS DB instance in Dev-VPC1 used by their development team.Dev-VPC1 has a peering connection with Dev-VPC2 that belongs to a different development team in the same department.The networking team confirmed that the routing between VPCs is correct; however, the database engineers in Dev-VPC2 are getting a timeout connections error when trying to connect to the database in Dev-VPC1.What is likely causing the timeouts?Read More →

A company wants to migrate its Microsoft SQL Server Enterprise Edition database instance from on-premises to AWS.A deep review is performed and the AWSSchema Conversion Tool (AWS SCT) provides options for running this workload on Amazon RDS for SQL Server Enterprise Edition, Amazon RDS for SQL ServerStandard Edition, Amazon Aurora MySQL, and Amazon Aurora PostgreSQL.The company does not want to use its own SQL server license and does not want to change from Microsoft SQL Server.What is the MOST cost-effective and operationally efficient solution?Read More →

A company is going to use an Amazon Aurora PostgreSQL DB cluster for an application backend.The DB cluster contains some tables with sensitive data.ADatabase Specialist needs to control the access privileges at the table level.How can the Database Specialist meet these requirements?Read More →

A company has a web-based survey application that uses Amazon DynamoDB.During peak usage, when survey responses are being collected, a DatabaseSpecialist sees the ProvisionedThroughputExceededException error.What can the Database Specialist do to resolve this error? (Choose two.)Read More →

A company is building a new web platform where user requests trigger an AWS Lambda function that performs an insert into an Amazon Aurora MySQL DB cluster.Initial tests with less than 10 users on the new platform yielded successful execution and fast response times.However, upon more extensive tests with the actual target of 3,000 concurrent users, Lambda functions are unable to connect to the DB cluster and receive too many connections errors.Which of the following will resolve this issue?Read More →

A company is writing a new survey application to be used with a weekly televised game show.The application will be available for 2 hours each week.The company expects to receive over 500,000 entries every week, with each survey asking 2-3 multiple choice questions of each user.A Database Specialist needs to select a platform that is highly scalable for a large number of concurrent writes to handle the anticipated volume.Which AWS services should the Database Specialist consider? (Choose two.)Read More →

A company developed a new application that is deployed on Amazon EC2 instances behind an Application Load Balancer.The EC2 instances use the security group named sg-application-servers.The company needs a database to store the data from the application and decides to use an Amazon RDS for MySQL DB instance.The DB instance is deployed in a private DB subnet.What is the MOST restrictive configuration for the DB instance security group?Read More →