Summer Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: exc65

Which three are key advantages of standard MySQL replication? (Choose three.)

A.

supports native automatic failover

B.

enables automatic resync of databases when discrepancies are detected

C.

provides arbitrary geographic redundancy with minimal overhead to master

D.

synchronously guarantees identical slave copy

E.

is easy to configure and has low performance overhead

F.

can easily add slaves for read scaling

Consider:

Which statement best describes the meaning of the values in the ref columns?

A.

world.City.CountryCode is used as the primary key for the Country table.

B.

No indexed columns are used to select rows from the City table. The world.City.CountryCode column is used to select rows in the Country table.

C.

world.City.CountryCode is used to sort the rows in the City table.

D.

No indexed columns are used to select rows from the Country table. The world.City.CountryCode column is used to select rows in the City table.

Which two statements are true about InnoDB auto-increment locking? (Choose two.)

A.

InnoDB never uses table-level locks.

B.

InnoDB always protects auto-increment updates with a table-level lock

C.

InnoDB does not use locks to enforce auto-increment uniqueness.

D.

The auto-increment lock can be a table-level lock.

E.

Some settings for innodb_autoinc_lock_mode can help reduce locking.

Consider the index information for the dept_emp table in the employee’s schema:

Which two conclusions can be made based on the output of the query? (Choose two.)

A.

There are three indexes on the table.

B.

There is a redundant index on the dept_no column.

C.

The secondary indexes are optimized for unique key look-ups.

D.

The values on the emp_no column must be unique.

E.

The selectivity of the dept_no column is the best of the indexed columns.

F.

There is a redundant index on the emp_no column.

Suppose you are adding rows to a MyISAM table and the --datadir location runs out of disk space. What will happen when this occurs?

A.

The server will crash.

B.

The server suspends that INSERT operation until space becomes available.

C.

An error message will be returned to the client .Server Error: ER_IO

D.

The server suspends operations for all storage engines until space becomes available.

SQL injection is a common security threat.

Which two methods would help protect against this risk?

A.

using stored procedures to validate values that are input

B.

using SQL variables to secure input values

C.

using prepared statements to handle unsecured values

D.

installing the SQL Protection plugin to catch such attempts

E.

starting the server with the –-injection-protection command-line option.

You attempt to connect to a MySQL Server by using the mysql client program. However, you receive this notice:

What would you run to fix the issue?

A.

the mysql_upgrade script

B.

the mysql client with the --ignore-password-hashing option

C.

the mysql_secure_installation script to update server security settings

D.

the mysql client with the --enable-cleartext-plugin option

E.

the install plugin command for the mysql_cleartext_password plugin

Which two capabilities are granted with the SUPER privilege?

A.

allowing change of the server runtime configuration

B.

allowing a client to shut down the server

C.

allowing client accounts to take over the account of another user

D.

allowing a client to kill other client connections

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? (Choose three.)

A.

Set isolation level to be SERIALIZABLE.

B.

Use the binary log row format.

C.

Set isolation level to be READ COMMITTED.

D.

Configure IPv6 network for hosts.

E.

Guarantee a secondary index on every table.

F.

Guarantee a primary key on every table.

G.

Set multiple slave parallel worker threads.

A MySQL server was initialized with separate UNDO tablespaces. Users complain that when they roll back large transactions, the time to process the request takes too long. The DBA would like to move the MySQL InnoDB UNDO tablespace to a solid-state drive (SSD) for better performance. Is this possible and how?

A.

Yes. Shut down the mysqld process, enable the transportable_tablespace option, and move the UNDO directory to the SSD.

B.

Yes. Shut down, copy the UNDO tablespaces to the new location, and change the innodb_undo_directory value in your my.cnf.

C.

No. The UNDO tablespaces must remain on the same file system as the system tablespaces.

D.

No. The sequential write pattern of the UNDO tablespaces is not supported on modern SSD block devices.