DBS-C01 (Page 18)

A company is using Amazon Redshift.A database specialist needs to allow an existing Redshift cluster to access data from other Redshift clusters.Amazon RDS for PostgreSQL databases, and AWS Glue Data Catalog tables.Which combination of steps will meet these requirements with the MOST operational efficiency? (Choose three.)Read More →

A database specialist is working with a company to launch a new website.The website accesses a database on an Amazon Aurora MySQL DB cluster that is configured with several Aurora Replicas.The website will replace an on-premises website that is connected to a legacy relational database.Because of stability issues in the legacy database, the company wants to test the resiliency of the Aurora cluster.Which action can the database specialist take to test the resiliency of the Aurora cluster?Read More →

A gaming company is developing a new mobile game and decides to store the data for each user in Amazon DynamoDB.To make the registration process as easy as possible, users can log in with their existing Facebook or Amazon accounts.The company expects more than 10,000 users.How should a database specialist implement access control with the LEAST operational effort?Read More →

An online retail company is planning a multi-day flash sale that must support processing of up to 5,000 orders per second.The number of orders and exact schedule for the sale will vary each day.During the sale, approximately 10,000 concurrent users will look at the deals before buying items.Outside of the sale, the traffic volume is very low.The acceptable performance for read/write queries should be under 25 ms.Order items are about 2 KB in size and have a unique identifier.The company requires the most cost-effective solution that will automatically scale and is highly available.Which solution meets these requirements?Read More →

A gaming company uses Amazon Aurora Serverless for one of its internal applications.The company’s developers use Amazon RDS Data API to work with theAurora Serverless DB cluster.After a recent security review, the company is mandating security enhancements.A database specialist must ensure that access toRDS Data API is private and never passes through the public internet.What should the database specialist do to meet this requirement?Read More →

A company that is located in the United States wants to expand its operations in Asia.The company’s data in the us-west-2 Region is stored in an Amazon DynamoD8 table.The company’s development team in the ap-northeast-1 Region needs to perform user acceptance testing (UAT) and several other performance feasibility tests with a copy of production data from us-west-2.The feasibility tests do not need to be run on data that is updated in real time.Which solution will make data available from us-west-2 to ap-northeast-1 MOST cost-effectively?Read More →

A company has a 250 GB Amazon RDS Multi-AZ DB instance.The company’s disaster recovery policy requires an RPO of 6 hours in a second AWS Region.Which solution will meet these requirements MOST cost-effectively?Read More →

A database administrator is reviewing the deployment of an application that uses Amazon DynamoDB.A fleet of Amazon EC2 application instances accesses the database.The database administrator notices that EC2 instances are using public IP addresses to access the database and that the database is available to the internet.Company policy requires that all corporate data must be accessed privately and that external access from the internet is not allowed.Which combination of steps will ensure that the DynamoDB database meets these requirements? (Choose two.)Read More →

A database specialist must create nightly backups of an Amazon DynamoDB table in a mission-critical workload as part of a disaster recovery strategy.Which backup methodology should the database specialist use to MINIMIZE management overhead?Read More →

A company is running a two-tier ecommerce application in one AWS account.The application is backed by an Amazon RDS for MySQL Multi-AZ DB instance.A developer mistakenly deleted the DB instance in the production environment.The company restores the database, but this event results in hours of downtime and lost revenue.Which combination of changes would minimize the risk of this mistake occurring in the future? (Choose three.)Read More →