Online Access Free 1Z1-888 Practice Test

Which three are key advantages of standard MySQL replication?

• A.can easily add slaves for read scaling
• B.enables automatic resync of databases when discrepancies are detected
• C.provides arbitrary geographic redundancy with minimal overhead to master
• D.supports native automatic failover
• E.is easy to configure and has low performance overhead
• F.synchronously guarantees identical slave copy

Group Replication uses global transaction identifiers to track executed transactions and are fundamental in avoiding transaction conflict. Which additional three steps help in avoiding conflicts in group replication?

• A.Guarantee a primary key on every table.
• B.Set isolation level to be READ COMMITTED.
• C.Set multiple slave parallel worker threads.
• D.Configure IPv6 network for hosts.
• E.Guarantee a secondary index on every table.
• F.Set isolation level to be SERIALIZABLE.
• G.Use the binary log row format.

You want to create the first configuration file for a new installation of MySQL.
- You will start mysqldmanually (not automate it to start when the host machine starts or execute as a service).
- You will stop mysqldusing mysqladmin.
- You will interact with mysqldby using only the command-line client mysql.
Which option identifies a maximal set of sections where you can put the "max_allowed_packet=16M" parameter without creating a problem?

• A.[mysql]
• B.[mysqladmin]
• C.[mysqld]
• D.[mysql] and [mysqld]
• E.[mysql] and [mysqld] and [mysqladmin]
• F.[mysql] and [mysqladmin]
• G.[mysqld] and [mysqladmin]

Which two are considered good security practices when using passwords? (Choose two.)

• A.Choose short passwords to save on storage space.
• B.Use one-way encryption for storage of passwords.
• C.Use simple keyboard actions that give mixed letters.
• D.Do not use dictionary-based words.
• E.Store passwords external to the database.

Which two statements describe how InnoDB recovery works?

• A.There will in general be lost committed transactions after a crash using the default settings.
• B.It is recommended to set innodb_force_recovery = 1 as part of normal operations.
• C.InnoDB handles most crash recoveries automatically.
• D.InnoDB blocks some operations when innodb_force_recovery is set to greater than 0.
• E.It is required to enable binlog_gtid_simple_recovery to perform a crash recovery.
• F.It is always required to enable innodb_force_recovery to perform a crash recovery.