Free DBS-C01 Exam Braindumps
AWS Certified Database - Specialty Questions 126–130 (page: 27)

Updated On: 10-Feb-2026

A large gaming company is creating a centralized solution to store player session state for multiple online games. The workload required key-value storage with low latency and will be an equal mix of reads and writes. Data should be written into the AWS Region closest to the user across the games’ geographically distributed user base. The architecture should minimize the amount of overhead required to manage the replication of data between Regions.

Which solution meets these requirements?

  1. Amazon RDS for MySQL with multi-Region read replicas
  2. Amazon Aurora global database
  3. Amazon RDS for Oracle with GoldenGate
  4. Amazon DynamoDB global tables

Answer(s): D



A company is running an on-premises application comprised of a web tier, an application tier, and a MySQL database tier. The database is used primarily during business hours with random activity peaks throughout the day. A database specialist needs to improve the availability and reduce the cost of the MySQL database tier as part of the company’s migration to AWS.

Which MySQL database option would meet these requirements?

  1. Amazon RDS for MySQL with Multi-AZ
  2. Amazon Aurora Serverless MySQL cluster
  3. Amazon Aurora MySQL cluster
  4. Amazon RDS for MySQL with read replica

Answer(s): B



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 AWS Schema Conversion Tool (AWS SCT) provides options for running this workload on Amazon RDS for SQL Server Enterprise Edition, Amazon RDS for SQL Server Standard 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?

  1. Run SQL Server Enterprise Edition on Amazon EC2.
  2. Run SQL Server Standard Edition on Amazon RDS.
  3. Run SQL Server Enterprise Edition on Amazon RDS.
  4. Run Amazon Aurora MySQL leveraging SQL Server on Linux compatibility libraries.

Answer(s): B


Reference:

https://docs.aws.amazon.com/SchemaConversionTool/latest/userguide/CHAP_Welcome.html



A company’s ecommerce website uses Amazon DynamoDB for purchase orders. Each order is made up of a Customer ID and an Order ID. The DynamoDB table uses the Customer ID as the partition key and the Order ID as the sort key.

To meet a new requirement, the company also wants the ability to query the table by using a third attribute named Invoice ID. Queries using the Invoice ID must be strongly consistent. A database specialist must provide this capability with optimal performance and minimal overhead.

What should the database administrator do to meet these requirements?

  1. Add a global secondary index on Invoice ID to the existing table.
  2. Add a local secondary index on Invoice ID to the existing table.
  3. Recreate the table by using the latest snapshot while adding a local secondary index on Invoice ID.
  4. Use the partition key and a FilterExpression parameter with a filter on Invoice ID for all queries.

Answer(s): C



A company wants to migrate its on-premises MySQL databases to Amazon RDS for MySQL. To comply with the company’s security policy, all databases must be encrypted at rest. RDS DB instance snapshots must also be shared across various accounts to provision testing and staging environments.

Which solution meets these requirements?

  1. Create an RDS for MySQL DB instance with an AWS Key Management Service (AWS KMS) customer managed CMK. Update the key policy to include the Amazon Resource Name (ARN) of the other AWS accounts as a principal, and then allow the kms:CreateGrant action.
  2. Create an RDS for MySQL DB instance with an AWS managed CMK. Create a new key policy to include the Amazon Resource Name (ARN) of the other AWS accounts as a principal, and then allow the kms:CreateGrant action.
  3. Create an RDS for MySQL DB instance with an AWS owned CMK. Create a new key policy to include the administrator user name of the other AWS accounts as a principal, and then allow the kms:CreateGrant action.
  4. Create an RDS for MySQL DB instance with an AWS CloudHSM key. Update the key policy to include the Amazon Resource Name (ARN) of the other AWS accounts as a principal, and then allow the kms:CreateGrant action.

Answer(s): A


Reference:

https://docs.aws.amazon.com/kms/latest/developerguide/grants.html



Viewing page 27 of 67
Viewing questions 131 - 135 out of 359 questions


Post your Comments and Discuss Amazon DBS-C01 exam prep with other Community members:

AI Tutor AI Tutor 👋 I’m here to help!