DBS-C01 (Page 25)

A company conducted a security audit of its AWS infrastructure. The audit identified that data was not encrypted in transit between application servers and aMySQL database that is hosted in Amazon RDS.After the audit, the company updated the application to use an encrypted connection. To prevent this problem from occurring again, the company’s database team needs to configure the database to require in-transit encryption for all connections.Which solution will meet this requirement?Read More →

A company is due for renewing its database license.The company wants to migrate its 80 TB transactional database system from on-premises to the AWS Cloud.The migration should incur the least possible downtime on the downstream database applications.The company’s network infrastructure has limited network bandwidth that is shared with other applications.Which solution should a database specialist use for a timely migration?Read More →

A company just migrated to Amazon Aurora PostgreSQL from an on-premises Oracle database.After the migration, the company discovered there is a period of time every day around 3:00 PM where the response time of the application is noticeably slower.The company has narrowed down the cause of this issue to the database and not the application.Which set of steps should the Database Specialist take to most efficiently find the problematic PostgreSQL query?Read More →

A database specialist is responsible for an Amazon RDS for MySQL DB instance with one read replica.The DB instance and the read replica are assigned to the default parameter group.The database team currently runs test queries against a read replica.The database team wants to create additional tables in the read replica that will only be accessible from the read replica to benefit the tests.Which should the database specialist do to allow the database team to create the test tables?Read More →

A financial company wants to store sensitive user data in an Amazon Aurora PostgreSQL DB cluster.The database will be accessed by multiple applications across the company.The company has mandated that all communications to the database be encrypted and the server identity must be validated.Any non-SSL- based connections should be disallowed access to the database.Which solution addresses these requirements?Read More →

A company needs a data warehouse solution that keeps data in a consistent, highly structured format.The company requires fast responses for end-user queries when looking at data from the current year, and users must have access to the full 15-year dataset, when needed.This solution also needs to handle a fluctuating number incoming queries.Storage costs for the 100 TB of data must be kept low.Which solution meets these requirements?Read More →

A Database Specialist is migrating an on-premises Microsoft SQL Server application database to Amazon RDS for PostgreSQL using AWS DMS.The application requires minimal downtime when the RDS DB instance goes live.What change should the Database Specialist make to enable the migration?Read More →

A Database Specialist must create a read replica to isolate read-only queries for an Amazon RDS for MySQL DB instance.Immediately after creating the read replica, users that query it report slow response times.What could be causing these slow response times?Read More →

A Database Specialist is creating Amazon DynamoDB tables, Amazon CloudWatch alarms, and associated infrastructure for an Application team using a development AWS account.The team wants a deployment method that will standardize the core solution components while managing environment-specific settings separately, and wants to minimize rework due to configuration errors.Which process should the Database Specialist recommend to meet these requirements?Read More →

An online advertising company uses an Amazon DynamoDb table as its data store.The table has Amazon DynamoDB Streams enabled and has a global secondary index on one of the keys.The table is encrypted using an AWS Key Management Service (AWS KMS) customer managed key.The company has decided to expand its operations globally and wants to replicate the database in a different AWS Region by using DynamoDB global tables.Upon review, an administrator notices the following:✑ No role with the dynamodb: CreateGlobalTable permission exists in the account.✑ An empty table with the same name exists in the new Region where replication is desired.✑ A global secondary index with the same partition key but a different sort key exists in the new Region where replication is desired.Which configurations will block the creation of a global table or the creation of a replica in the new Region? (Choose two.)Read More →