Free DBS-C01 Exam Braindumps
AWS Certified Database - Specialty Questions 161–165 (page: 34)

Updated On: 10-Feb-2026

A company that analyzes the stock market has two offices: one in the us-east-1 Region and another in the euwest-2 Region. The company wants to implement an AWS database solution that can provide fast and accurate updates.
The office in eu-west-2 has dashboards with complex analytical queries to display the data. The company will use these dashboards to make buying decisions, so the dashboards must have access to the application datain less than 1 second.
Which solution meets these requirements and provides the MOST up-to-date dashboard?

  1. Deploy an Amazon RDS DB instance in us-east-1 with a read replica instance in eu-west-2. Create an Amazon ElastiCache cluster in eu-west-2 to cache data from the read replica to generate the dashboards.
  2. Use an Amazon DynamoDB global table in us-east-1 with replication into eu-west-2. Use multi-active replication to ensure that updates are quickly propagated to eu-west-2.
  3. Use an Amazon Aurora global database. Deploy the primary DB cluster in us-east-1. Deploy the secondary DB cluster in eu-west-2. Configure the dashboard application to read from the secondary cluster.
  4. Deploy an Amazon RDS for MySQL DB instance in us-east-1 with a read replica instance in eu-west-2. Configure the dashboard application to read from the read replica.

Answer(s): C



A company is running its customer feedback application on Amazon Aurora MySQL. The company runs a report every day to extract customer feedback, and a team reads the feedback to determine if the customer comments are positive or negative. It sometimes takes days before the company can contact unhappy customers and take corrective measures. The company wants to use machine learning to automate this workflow.
Which solution meets this requirement with the LEAST amount of effort?

  1. Export the Aurora MySQL database to Amazon S3 by using AWS Database Migration Service (AWS DMS). Use Amazon Comprehend to run sentiment analysis on the exported files.
  2. Export the Aurora MySQL database to Amazon S3 by using AWS Database Migration Service (AWS DMS). Use Amazon SageMaker to run sentiment analysis on the exported files.
  3. Set up Aurora native integration with Amazon Comprehend. Use SQL functions to extract sentiment analysis.
  4. Set up Aurora native integration with Amazon SageMaker. Use SQL functions to extract sentiment analysis.

Answer(s): C

Explanation:

Amazon Comprehend is a natural-language processing (NLP) service that uses machine learning to uncover valuable insights and connections in text.


Reference:

https://aws.amazon.com/comprehend/



A bank plans to use an Amazon RDS for MySQL DB instance. The database should support read-intensive traffic with very few repeated queries.
Which solution meets these requirements?

  1. Create an Amazon ElastiCache cluster. Use a write-through strategy to populate the cache.
  2. Create an Amazon ElastiCache cluster. Use a lazy loading strategy to populate the cache.
  3. Change the DB instance to Multi-AZ with a standby instance in another AWS Region.
  4. Create a read replica of the DB instance. Use the read replica to distribute the read traffic.

Answer(s): D


Reference:

https://cloudbasic.net/aws/rds/sqlserver/managing-rds-read-replicas-on-aws/



A database specialist has a fleet of Amazon RDS DB instances that use the default DB parameter group. The database specialist needs to associate a custom parameter group with some of the DB instances.
After the database specialist makes this change, when will the instances be assigned to this new parameter group?

  1. Instantaneously after the change is made to the parameter group
  2. In the next scheduled maintenance window of the DB instances
  3. After the DB instances are manually rebooted
  4. Within 24 hours after the change is made to the parameter group

Answer(s): C

Explanation:

To apply the latest parameter changes to that DB instance, manually reboot the DB instance.


Reference:

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_WorkingWithParamGroups.html



A company is planning on migrating a 500-GB database from Oracle to Amazon Aurora PostgreSQL using the AWS Schema Conversion Tool (AWS SCT) and AWS DMS. The database does not have any stored procedures to migrate but has some tables that are large or partitioned. The application is critical for business so a migration with minimal downtime is preferred.
Which combination of steps should a database specialist take to accelerate the migration process? (Choose three.)

  1. Use the AWS SCT data extraction agent to migrate the schema from Oracle to Aurora PostgreSQL.
  2. For the large tables, change the setting for the maximum number of tables to load in parallel and perform a full load using AWS DMS.
  3. For the large tables, create a table settings rule with a parallel load option in AWS DMS, then perform a full load using DMS.
  4. Use AWS DMS to set up change data capture (CDC) for continuous replication until the cutover date.
  5. Use AWS SCT to convert the schema from Oracle to Aurora PostgreSQL.
  6. Use AWS DMS to convert the schema from Oracle to Aurora PostgreSQL and for continuous replication.

Answer(s): D,E


Reference:

https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Tasks.CustomizingTasks.TaskSettings.FullLoad.html https://aws.amazon.com/blogs/database/continuous-database-replication-using-aws-dms-to-migrate-fromoracle-to-amazon-aurora/



Viewing page 34 of 67
Viewing questions 166 - 170 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!