nerdexam
Oracle

1Z0-908 · Question #29

You plan to take daily full backups, which include the ndbinfo and sys (internal) databases. Which command will back up the databases in parallel?

The correct answer is D. mysqldump --all-databases > full_backup-$(date +%Y%m%d).sql. https://mysqlserverteam.com/introducing-mysqlpump/

Backup and Recovery

Question

You plan to take daily full backups, which include the ndbinfo and sys (internal) databases. Which command will back up the databases in parallel?

Options

  • Amysqldump --single-transaction > full-backup-$(date +%Y%m%d).sql
  • Bmysqlpump --include-databases=% > full-backup-$(date +%Y%m$d).sql
  • Cmysqlpump --all-databases > full-backup-$(date +%Y%m%d).sql
  • Dmysqldump --all-databases > full_backup-$(date +%Y%m%d).sql

How the community answered

(26 responses)
  • A
    8% (2)
  • B
    4% (1)
  • C
    19% (5)
  • D
    69% (18)

Explanation

https://mysqlserverteam.com/introducing-mysqlpump/

Topics

#mysqlpump#parallel backup#ndbinfo database#sys database

Community Discussion

No community discussion yet for this question.

Full 1Z0-908 Practice