Examice

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

Go to Exam

Question 108

Examine this command, which executes successfully:

Which statement is true?

Only files for MySQL or Its built-in storage engines are backed

Only non-encrypted files are backed up.

The backup includes only data files and their metadata.

Only InnoDB data and log files are backed up.

Only tables stored in their own tablespaces are backed up.

Correct Answer: A

The command includes the option --only-known-file-types, which specifies that mysqlbackup should only back up files known to the MySQL or its built-in storage engines. This implies that only files related to MySQL and its storage engines, such as ARCHIVE, CSV, InnoDB, Merge, and MyISAM, are backed up. Therefore, the statement that only files for MySQL or its built-in storage engines are backed up is correct.

Discussion

DhanushkaOption: A

f the --only-known-file-types option is specified, mysqlbackup only backs up those types of files that are data files for MySQL or its built-in storage engines, which, besides the ibdata* files, have the following extensions: .ARM: ARCHIVE table metadata .ARZ: ARCHIVE table data .CSM: CSV table metadata .CSV: CSV table data .ibd: InnoDB tablespace created using the file-per-table mode .MRG: Merge storage engine references to other tables .MYD: MyISAM data .MYI: MyISAM indexes

FelipeKOption: A

https://dev.mysql.com/doc/mysql-enterprise-backup/8.0/en/backup-partial-options.html