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

When backing up a replication slave, which three should also be backed up in addition to data?

• A.The relay log files
• B.Mysql.slave_worker_info table
• C.Mysql.slave_master_info table
• D.The relay index file
• E.Mysql.slave_relay_log_info table
• F.The master.info and relay.info files

Which three tasks can be performed by using the performance Schema?

• A.Finding client connection attributes
• B.Finding the part of a code in which a single query is spending time
• C.Finding rows that are locked by InnoDB
• D.Finding the size of each table
• E.Finding queries that are not using indexes

Which hardware storage option, when set up with redundant disks, offers the least stability, availability, and reliability for Mysql data?

• A.RAID 5
• B.iSCSI
• C.NFS (Networked File System)
• D.SAN (Storage Area Network)

Full Atomicity, Consistency, Isolation, Durability (ACID) compliance is a necessity for a new application, which heavily reads and writes data.
This requires the following config file options:
Sync_binlog=1 Innodb_flush_log_at_trx_commit=1
Innodb_doublewrite=1
However, this configuration is expected to introduce disk I/O overhead.
What three changes will reduce disk I/O overheads?

• A.Use of delay_key_write=ON for batch index update
• B.Use of soft links for database directories on the same physical disk
• C.Allocation of RAM to the buffer pool such that more of the data can fit in RAM
• D.Placement of InnoDB log files and datadir on separate physical disks
• E.Use of separate directories on the same physical disk for log files and data files

A Mysql Server has been running an existing application successfully for six months.
The my.cnf is adjusted to contain the following additional configuration:
[mysqld]
Default-authentication-plugin=sha256_password
The Mysql Server is restarted without error.
What effect will the new configuration have in existing accounts?

• A.They all connect via the secure sha256_password algorithm without any configuration change.
• B.They will have to change their password the next time they login to the server.
• C.They will have their passwords updated on start-up to sha256_password format.
• D.They are not affected by this configuration change.