DBS-C01 (Page 28)

A media company is using Amazon RDS for PostgreSQL to store user data.The RDS DB instance currently has a publicly accessible setting enabled and is hosted in a public subnet.Following a recent AWS Well-Architected Framework review, a Database Specialist was given new security requirements.✑ Only certain on-premises corporate network IPs should connect to the DB instance.✑ Connectivity is allowed from the corporate network only.Which combination of steps does the Database Specialist need to take to meet these new requirements? (Choose three.)Read More →

A company is about to launch a new product, and test databases must be re-created from production data.The company runs its production databases on anAmazon Aurora MySQL DB cluster.A Database Specialist needs to deploy a solution to create these test databases as quickly as possible with the least amount of administrative effort.What should the Database Specialist do to meet these requirements?Read More →

A Database Specialist migrated an existing production MySQL database from on-premises to an Amazon RDS for MySQL DB instance.However, after the migration, the database needed to be encrypted at rest using AWS KMS.Due to the size of the database, reloading, the data into an encrypted database would be too time-consuming, so it is not an option.How should the Database Specialist satisfy this new requirement?Read More →

A company’s Security department established new requirements that state internal users must connect to an existing Amazon RDS for SQL Server DB instance using their corporate Active Directory (AD) credentials.A Database Specialist must make the modifications needed to fulfill this requirement.Which combination of actions should the Database Specialist take? (Choose three.)Read More →

A company wants to automate the creation of secure test databases with random credentials to be stored safely for later use.The credentials should have sufficient information about each test database to initiate a connection and perform automated credential rotations.The credentials should not be logged or stored anywhere in an unencrypted form.Which steps should a Database Specialist take to meet these requirements using an AWS CloudFormation template?Read More →

A healthcare company is running an application on Amazon EC2 in a public subnet and using Amazon DocumentDB (with MongoDB compatibility) as the storage layer.An audit reveals that the traffic between the application and Amazon DocumentDB is not encrypted and that the DocumentDB cluster is not encrypted at rest.A database specialist must correct these issues and ensure that the data in transit and the data at rest are encrypted.Which actions should the database specialist take to meet these requirements? (Choose two.)Read More →

A startup company is building a new application to allow users to visualize their on-premises and cloud networking components.The company expects billions of components to be stored and requires responses in milliseconds.The application should be able to identify:✑ The networks and routes affected if a particular component fails.✑ The networks that have redundant routes between them.✑ The networks that do not have redundant routes between them.✑ The fastest path between two networks.Which database engine meets these requirements?Read More →

A company has two separate AWS accounts: one for the business unit and another for corporate analytics.The company wants to replicate the business unit data stored in Amazon RDS for MySQL in us-east-1 to its corporate analytics Amazon Redshift environment in us-west-1.The company wants to use AWS DMS withAmazon RDS as the source endpoint and Amazon Redshift as the target endpoint.Which action will allow AVS DMS to perform the replication?Read More →

An ecommerce company uses an Amazon Aurora MySQL DB cluster to process payments.The company’s database specialist notices that Aurora performs database maintenance actions periodically.The database specialist is concerned because the upcoming maintenance window conflicts with a company sales event.What should the database specialist do to address this concern with the LEAST operational effort?Read More →

A company needs to troubleshoot its Amazon Aurora Serverless MySQL database.The company selected a db.t3, medium instance class for the database’s initial deployment.The database experienced light usage, and performance was normal.As the number of client connections increases, the application that is connected to the database is experiencing higher latency and occasional lost connections.A database specialist determines that the database needs to support a maximum of 2,000 simultaneous connections.Which solution will meet these requirements MOST cost-effectively?Read More →