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

Examine this parameter setting:

audit_log=FORCE_LOG_PERMANENT

What effect does this have on auditing?

A.

It will force the load of the audit plugin even in case of errors at server start.

B.

It causes the audit log to be created if it does not exist.

C.

It prevents the audit plugin from being removed from the running server.

D.

It prevents the audit log from being removed or rotated.

You made some table definition changes to a schema in your MySQL Server.

Which two statements reflect how MySQL Server handles the table definition changes? (Choose two.)

A.

MySQL writes SDI to the binary log for distributed backups.

B.

MySQL keeps InnoDB metadata changes in .sdi files in datadir.

C.

The metadata is serialized in JSON format in Serialized Dictionary Information (SDI).

D.

MySQL Server stores a copy of the serialized data in the InnoDB user tablespace.

E.

MySQL implicitly executes FLUSH TABLES and stores a snapshot backup of the metadata.

A colleague complains about slow response time on your website.

Examine this query and output:

What is the most likely cause for the high number of lock waits?

A.

You use the MyISAM storage engine for most common tables.

B.

You use the InnoDB storage engine and statements wait while data is inserted.

C.

The Innodb Buffer pool is full.

D.

Your table accesses wait for the operating system level flush.

You are using mysqlcheck for server maintenance.

Which two statements are true? (Choose two.)

A.

The mysqlcheck --check --all-databases command takes table write locks while performing a series of checks.

B.

The mysqlcheck --optimize --all-databases command reclaims free space from table files.

C.

The mysqlcheck --repair --all-databases command can repair an InnoDB corrupted table.

D.

The mysqlcheck command can be renamed mysqlrepair so that it repairs tables by default.

E.

The mysqlcheck --analyze --all-databases command performs a series of checks to spot eventual table corruptions.

Examine this command, which executes successfully:

shell> mysqldump --master-data=2 --single-transaction --result-file=dump.sql mydb

Which two statements are true? (Choose two.)

A.

It executes flush tables with read lock.

B.

It enforces consistent backups for all storage engines.

C.

The backup created is a consistent data dump.

D.

This option uses the READ COMMITTED transaction isolation mode.

E.

It is a cold backup.

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->mydb2’ | mysql

B.

mysqlbinlog --datebase=mydb1 --database=mydb2 | mysql

C.

mysqlbinlog --rewrite-db=’mydb1’ --rewrite-db=’mydb2’ | mysql

D.

mysqlbinlog --read-from-remote-server --raw | sed ‘s/mydb1/mydb2/g’ | mysql

Which statement is true about MySQL Enterprise Transparent Data Encryption (TDE)?

A.

MySQL TDE uses an appropriate keyring plugin to store the keys in a centralized location.

B.

Both MyISAM and InnoDB tables can be encrypted by setting the keyring_engine = ALL variable in the MySQL configuration file.

C.

Lost tablespace encryption keys can be regenerated only if the master database key is known or present in the Key Vault specification.

D.

TDE can encrypt InnoDB and MyISAM tables only when the tables are stored in the SYSTEM tablespace.

Examine this statement, which executes successfully:

You want to improve the performance of this query:

Which change enables the query to succeed while accessing fewer rows?

A.

ALTER TABLE world.city ADD SPATIAL INDEX (Name);

B.

ALTER TABLE world.city ADD SPATIAL INDEX (Population);

C.

ALTER TABLE world.city ADD INDEX (Population);

D.

ALTER TABLE world.city ADD INDEX (Name);

E.

ALTER TABLE world.city ADD FULLTEXT INDEX (Name);

F.

ALTER TABLE world.city ADD FULLTEXT INDEX (Population);

Examine these statements and output:

Which statement is true?

A.

The user is logged in with --user=accounting as an option.

B.

The user is authenticated as the anonymous proxy user ‘’@’%’.

C.

The user is authorized as the accounting@localhost user.

D.

The user is authorized as the rsmith@localhost user.

E.

The user failed to define a username and the connecting username defaulted to ‘’@’%’.

Which three statements are true about MySQL replication? (Choose three.)

A.

Replication can use only TCP/IP connections.

B.

Any instance can have multiple slaves, but it can have only one master.

C.

Each instance in a replication topology must have a unique server ID.

D.

Binary logs contain only transactions originating from a single MySQL instance.

E.

Each slave must have its own MySQL user for replication.

F.

Binary logging must be enabled on the master in order to replicate to other instances.

G.

A replication user must have the SELECT privilege for all tables that need to be replicated.