Exam 1z0-908 topic 1 question 67 discussion

Actual exam question from Oracle's 1z0-908

Question #: 67
Topic #: 1

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.)

A. All databases are backed up to the output file.
B. All non-active binary logs are removed from the master.
C. All binary logs are deleted from the master.
D. All binary logs are backed up and then deleted.
E. All databases, excluding master metadata, are backed up to the output file.
F. All details regarding deleted logs and master metadata are captured in the output file.

Show Suggested Answer

Suggested Answer: CE 🗳️

by FelipeK at April 19, 2023, 9:43 p.m.

Comments

Submit Cancel

dmees

1 year, 3 months ago

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.

upvoted 1 times

...

LrnsTgh

1 year, 4 months ago

Selected Answer: AC

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

upvoted 1 times

...

FelipeK

1 year, 7 months ago

Selected Answer: 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

upvoted 1 times

...

marklv

1 year, 9 months ago

incorrect not D, it doesn't backup them up

upvoted 1 times

marklv

1 year, 7 months ago

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

upvoted 1 times

marklv

10 months, 3 weeks ago

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.

upvoted 1 times

...

FelipeK

2 years, 1 month ago

Selected Answer: AD

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

upvoted 1 times

marklv

1 year, 5 months ago

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.

upvoted 1 times

...