Free DBS-C01 Exam Braindumps (page: 21)

Page 20 of 82

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?

  1. Configure the on-premises application database to act as a source for an AWS DMS full load with ongoing change data capture (CDC)
  2. Configure the AWS DMS replication instance to allow both full load and ongoing change data capture (CDC)
  3. Configure the AWS DMS task to generate full logs to allow for ongoing change data capture (CDC)
  4. Configure the AWS DMS connections to allow two-way communication to allow for ongoing change data capture (CDC)

Answer(s): A


Reference:

https://aws.amazon.com/premiumsupport/knowledge-center/rds-import-data/



A financial company has allocated an Amazon RDS MariaDB DB instance with large storage capacity to accommodate migration efforts. Post-migration, the company purged unwanted data from the instance. The company now want to downsize storage to save money. The solution must have the least impact on production and near-zero downtime.
Which solution would meet these requirements?

  1. Create a snapshot of the old databases and restore the snapshot with the required storage
  2. Create a new RDS DB instance with the required storage and move the databases from the old instances to the new instance using AWS DMS
  3. Create a new database using native backup and restore
  4. Create a new read replica and make it the primary by terminating the existing primary

Answer(s): A



A large financial services company requires that all data be encrypted in transit. A Developer is attempting to connect to an Amazon RDS DB instance using the company VPC for the first time with credentials provided by a Database Specialist. Other members of the Development team can connect, but this user is consistently receiving an error indicating a communications link failure. The Developer asked the Database Specialist to reset the password a number of times, but the error persists.
Which step should be taken to troubleshoot this issue?

  1. Ensure that the database option group for the RDS DB instance allows ingress from the Developer machine’s IP address
  2. Ensure that the RDS DB instance’s subnet group includes a public subnet to allow the Developer to connect
  3. Ensure that the RDS DB instance has not reached its maximum connections limit
  4. Ensure that the connection is using SSL and is addressing the port where the RDS DB instance is listening for encrypted connections

Answer(s): D



A company is running Amazon RDS for MySQL for its workloads. There is downtime when AWS operating system patches are applied during the Amazon RDS-specified maintenance window.

What is the MOST cost-effective action that should be taken to avoid downtime?

  1. Migrate the workloads from Amazon RDS for MySQL to Amazon DynamoDB
  2. Enable cross-Region read replicas and direct read traffic to then when Amazon RDS is down
  3. Enable a read replicas and direct read traffic to it when Amazon RDS is down
  4. Enable an Amazon RDS for MySQL Multi-AZ configuration

Answer(s): C






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

DBS-C01 Exam Discussions & Posts