Cisco®
CompTIA
Checkpoint
ISC
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk®
Scrum
All Vendors
  2. Home
  3. Exams
  4. Amazon
  5. DBS-C01

Free DBS-C01 Exam Braindumps (page: 43)

Page 42 of 82
PDF with 359 Questions

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/



A company is migrating an IBM Informix database to a Multi-AZ deployment of Amazon RDS for SQL Server with Always On Availability Groups (AGs). SQL Server Agent jobs on the Always On AG listener run at 5- minute intervals to synchronize data between the Informix database and the SQL Server database. Users experience hours of stale data after a successful failover to the secondary node with minimal latency.
What should a database specialist do to ensure that users see recent data after a failover?

  1. Set TTL to less than 30 seconds for cached DNS values on the Always On AG listener.
  2. Break up large transactions into multiple smaller transactions that complete in less than 5 minutes.
  3. Set the databases on the secondary node to read-only mode.
  4. Create the SQL Server Agent jobs on the secondary node from a script when the secondary node takes over after a failure.

Answer(s): C

Explanation:

After a failover, client applications that need to access the primary databases must connect to the new primary replica. Also, if the new secondary replica is configured to allow read-only access, read-only client applications can connect to it.


Reference:

https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/failover-andfailover-modes-always-on-availability-groups?view=sql-server-ver15



A database specialist needs to configure an Amazon RDS for MySQL DB instance to close non-interactive connections that are inactive after 900 seconds.
What should the database specialist do to accomplish this task?

  1. Create a custom DB parameter group and set the wait_timeout parameter value to 900. Associate the DB instance with the custom parameter group.
  2. Connect to the MySQL database and run the SET SESSION wait_timeout=900 command.
  3. Edit the my.cnf file and set the wait_timeout parameter value to 900. Restart the DB instance.
  4. Modify the default DB parameter group and set the wait_timeout parameter value to 900.

Answer(s): A

Explanation:

If we set the wait_timeout variable for a session, it will valid only for a particular session. But when we set the wait_timeout variable globally it will valid for all the sessions.


Reference:

https://dilsichandrasena.medium.com/changing-mysql-wait-timeout-variable-f16ebed1efce



A company is running its production databases in a 3 TB Amazon Aurora MySQL DB cluster. The DB cluster is deployed to the us-east-1 Region. For disaster recovery (DR) purposes, the company€™s database specialist needs to make the DB cluster rapidly available in another AWS Region to cover the production load with an RTO of less than 2 hours.
What is the MOST operationally efficient solution to meet these requirements?

  1. Implement an AWS Lambda function to take a snapshot of the production DB cluster every 2 hours, and copy that snapshot to an Amazon S3 bucket in the DR Region. Restore the snapshot to an appropriately sized DB cluster in the DR Region.
  2. Add a cross-Region read replica in the DR Region with the same instance type as the current primary instance. If the read replica in the DR Region needs to be used for production, promote the read replica to become a standalone DB cluster.
  3. Create a smaller DB cluster in the DR Region. Configure an AWS Database Migration Service (AWS DMS) task with change data capture (CDC) enabled to replicate data from the current production DB cluster to the DB cluster in the DR Region.
  4. Create an Aurora global database that spans two Regions. Use AWS Database Migration Service (AWS DMS) to migrate the existing database to the new global database.

Answer(s): B


Reference:

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






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

Exam Discussions & Posts