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

Free DBS-C01 Exam Braindumps (page: 42)

Page 42 of 82
PDF with 327 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



Page 42 of 82



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

Pedro commented on April 27, 2024
Thanks for the dumps. It was an easy pass.
UNITED STATES
upvote

Keran commented on April 26, 2024
All of these questions are in the real exam. I just wrote my test yesterday. This is a valid exam dumps.
Anonymous
upvote

Mungara commented on March 14, 2023
thanks to this exam dumps, i felt confident and passed my exam with ease.
UNITED STATES
upvote

Mungara commented on March 14, 2023
Thanks to this exam dumps, I felt confident and passed my exam with ease.
UNITED STATES
upvote

otaku commented on August 11, 2022
just passed my dbs-c01 exam this site is really helped a lot.
Anonymous
upvote

Erik commented on March 02, 2022
These braindumps questions make passing very easy.
UNITED KINGDOM
upvote

Sanjev commented on January 12, 2022
This is the easiest way to get a 90%. Perfect exam dumps.
UNITED STATES
upvote

Abigail commented on September 20, 2021
I know using prep course are not ethical but I had to do this as this exam is way too hard to pass on your own. Thid prep course got me out of trouble.
UNITED STATES
upvote