1Z0-908 試験問題を無料オンラインアクセス

You are upgrading a MySQL instance to the latest 8.0 version.
Examine this output:

You plan to add this parameter to the configuration: innodb_directories='/innodb_extras' Which statement is true?

• A.It allows scanning of other locations to discover more innodb tablespaces.
• B.It is not necessary because innodb_data_home_dir is already defined.
• C.It moves all innodb tablespaces to the /innodb_extras directory to enable a new innodb_data_home_dir to be defined.
• D.It adds more temporary workspace in addition to the innodb_tmpdir location.
• E.It defines all innodb tablespace options relative to a starting parent directory.

Binary log events for the 'mydb1' schema must be copied to a different schema name 'mydb2'.
Which command will do this?

• A.mysqlbinlog --rewrite-db='mydb1' --rewrite-db='mydb2' | mysql
• B.mysqlbinlog --datebase=mydb1 --database=mydb2 | mysql
• C.mysqlbinlog --read-from-remote-server --raw | sed 's/mydb1/mydb2/g' | mysql
• D.mysqlbinlog --rewrite-db='mydb1->mydb2' | mysql

Which two statements are true about using backups of the binary log? (Choose two.)

• A.Multiple binary logs can be applied in parallel for faster data restoration.
• B.Multiple binary logs can be used to restore data.
• C.Binary logs can always be used to unapply unwanted schema changes.
• D.They allow for point-in-time recovery of the data.
• E.Binary logs are relatively small, and therefore, excellent for long-term storage and disaster recovery.

Examine this command, which executes successfully:

Which statement is true?

• A.Only tables stored in their own tablespaces are backed up.
• B.Only files for MySQL or Its built-in storage engines are backed
• C.Only InnoDB data and log files are backed up.
• D.The backup includes only data files and their metadata.
• E.Only non-encrypted files are backed up.

Examine this command, which executes successfully:
mysqlpump --user=root --password > full_backup.sql
Which two databases will be excluded from this dump? (Choose two.)

• A.mysql
• B.information_schema
• C.sys
• D.employee
• E.world