QuizzesBackup & Recovery — Concept Check
intermediate
mysql

Backup & Recovery — Concept Check

Questions on Backup & Recovery. mysqldump for logical backups; Percona XtraBackup for hot physical backups; binary log point-in-time recovery complements full backups to minimise data loss on failure.

8 minutes 8 questions Pass at 70%
Time Limit
8 minutes - timer starts when you begin
Change Answers Freely
Revisit and change any answer before submitting
Full Review After Submit
Correct answers and explanations shown for every question
Auto-submit on timeout
Quiz submits automatically when time runs out

Questions in this quiz

8 questions on Backup & Recovery — Concept Check. Work through them here, then start the quiz to answer them and see your score.

  1. 1.Your MySQL database is 200 GB and you need to perform a backup without downtime. Which tool should you use?

    • Amysqldump with --single-transaction
    • BManual file copy
    • CPercona XtraBackup
    • Dmysqldump without any options
  2. 2.A MySQL database backup is taken using mysqldump with --master-data=2. What does this option do?

    • AEnables compression of the backup
    • BLocks tables during the backup
    • CExports data in CSV format
    • DRecords the binary log position for PITR
  3. 3.You have a full backup and need to reduce the backup window for your 150 GB database. What should you do?

    • ASwitch to mysqldump for faster backups
    • BPerform manual backups more frequently
    • CUse incremental backups with Percona XtraBackup
    • DUse mysqldump with --quick option
  4. 4.After restoring a backup, you need to recover data up to a specific point in time. What should you use?

    • ASlow query logs for point-in-time recovery
    • BRedo logs for point-in-time recovery
    • CError logs for point-in-time recovery
    • DBinary logs for point-in-time recovery
  5. 5.You want to ensure minimal data loss in case of a failure. Which strategy should you adopt?

    • ADaily logical backups with mysqldump only
    • BMonthly physical backups with Percona XtraBackup only
    • CNightly full backups with continuous binlog archiving
    • DWeekly full backups with no binlog archiving
  6. 6.A colleague suggests using mysqldump for a 300 GB production database backup. Why might this be a poor choice?

    • Amysqldump requires downtime
    • Bmysqldump doesn't support InnoDB tables
    • Cmysqldump is too slow for large databases
    • Dmysqldump cannot export triggers
  7. 7.You notice that your binary logs are filling up disk space quickly. What configuration change can help manage this?

    • ADisable binary logging
    • BSet sync_binlog to 0
    • CIncrease the binlog_format to STATEMENT
    • DSet expire_logs_days in my.cnf
  8. 8.What is a potential risk of not enabling binary logging in a MySQL production environment?

    • AIncreased risk of data corruption
    • BSlower query performance
    • CIncreased storage requirements
    • DInability to perform point-in-time recovery