Exam 1z0-908 All QuestionsBrowse all questions from this exam
Question 67

Examine this list of MySQL data directory binary logs:

binlog.000001

binlog.000002

.....

binlog.000289

binlog.000300

binlog.000301

binlog.index

Now examine this command, which executes successfully:

mysqldump --delete-master-logs --all-databases > /backup/db_backup.sql

Which two are true? (Choose two.)

    Correct Answer: A, B

    The mysqldump command with the `--all-databases` option backs up all databases to the output file. Additionally, the `--delete-master-logs` option deletes the non-active binary logs from the master after the dump is completed, while keeping the active log intact.

Discussion
dmeesOptions: AB

AC. D. All binary logs are backed up and then deleted (FALSE): The mysqldump command doesn't have the capability to back up binary logs. It only deals with backing up database schemas and data.

LrnsTghOptions: AC

AC. >8.0.26 use --delete-source-logs

FelipeKOptions: AC

A-All databases are backed up to the output file. This is true because the --all-databases option tells mysqldump to dump all databases. C-All binary logs are deleted from the master. This is true because the --delete-master-logs option tells mysqldump to delete all binary logs on the master server2. However, it’s important to note that deleting the MySQL binary logs with mysqldump --delete-master-logs can be dangerous if your server is a replication source server, because replicas might not yet fully have processed the contents of the binary log

marklvOptions: AB

incorrect not D, it doesn't backup them up

marklv

B, non active logs i think, there is always one active log, after mysqldump it rotates the log and will purge the old ones

marklv

sorry me again, A. All databases are backed up to the output file. No, sys, information_schema, performance_schema are not backed up. But I think they mean yes to this. B. All non-active binary logs are removed from the master. Yes, the last binlog is active and does not get deleted. C. All binary logs are deleted from the master. No, last one is not. Tested this. D. All binary logs are backed up and then deleted. No, they are not backed up. E. All databases, excluding master metadata, are backed up to the output file. Maybe, if sys, performance_schema, information_schema are all meta, then yes, otherwise no. My guess is no. Performance_schema is not meta. F. All details regarding deleted logs and master metadata are captured in the output file. No.

FelipeKOptions: AD

https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html#option_mysqldump_delete-master-logs

marklv

A. yes, all databases are backedup. Not D, it doesn't backup binary logs. B or C, probably B, because there might logs made after the dump is started. So you are not deleting all logs.