Big Halloween Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: simple70

Oracle MySQL 5.7 Database Administrator 1z0-888 Question # 2 Topic 1 Discussion

Oracle MySQL 5.7 Database Administrator 1z0-888 Question # 2 Topic 1 Discussion

1z0-888 Exam Topic 1 Question 2 Discussion:
Question #: 2
Topic #: 1

A MySQL database uses all InnoDB tables and is configured as follows;

1z0-888 Question 2

You will be setting up a replication slave by using mysqldump. You will need a consistent backup taken from your running production server. The process should have minimal impact to active database connections.

Which two arguments will you pass to mysqldump to achieve this? (Choose two.)


A.

--skip-opt


B.

--lock-all-tables


C.

--create-apply-log


D.

--single-transaction


E.

--master-data


Get Premium 1z0-888 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.