[Mysql] A MySQL database uses all InnoDB tables and is configured as follows: (MySQL5.7 OCP)

Question: 1

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

shell>cat/ etc/ my.cnf

[mysqld]

log-bin

server-id=1

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?

A. --skip-opt

B. --lock-all-tables

C. --create-apply-log

D. --single-transaction

E. --master-data

Correct Answer: DE