Q121.Examine these statements and output:

mysql> GRANT PROXY ON accounting@localhost TO ' '@ '%';

mysql> SELECT USER(), CURRENT_ USER(), @@proxy_ user;

+------------------------+-------------------+-----------------+

|USER()                    I CURRENT_ USER()   I @@proxy_ user    I

| r smith@localhost 1        |accounting@localhost I ' '@'%'            |

+------------------------+-------------------+-----------------+

Which statement is true?

A)The user failed to define a username and the connecting username defaulted to ''G'8'.

B)The user is authorized as the rsmith@localhost user.

C)The user is authenticated as the anonymous proxy user ' '@ '%'.

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

E)The user is authorized as the accounting@localhost user.

Answer:E

Q122.Which two actions can obtain information about deadlocks?

A)Run the SHOW ENGINE INNODB MUTEX command from the mysql client.

B)Enable the innodb_ status_ output_ locks global parameter.

C)Enable the innodb_ print_ all_ deadlocks global parameter.

D)Run the SHOW ENGINE INNODB STATUS command from the mysql client.

E)Use the sys. innodb_ lock_ waits view.

Answer:CD

Q123.Examine this statement, which executes successfully:

CREATE TABLE world.city(

ID int NOT NULL AUTO_ INCREMENT ,

Name char(35) NOT NULL DEFAULT '' ,

CountryCode char(35) NOT NULL DEFAULT ' ',

District char (20) NOT NULL DEFAULT '',

Population int NOT NULL DEFAULT '0',

PRIMARY KEY (ID) ,

KEY CountryCode (CountryCode)

)ENGINE=InnoDB;

You want to improve the performance of this query:

SELECT Name

FROM world. city

WHERE Population BETWEEN 1000000 AND 2000000;

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

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

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

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

D)ALTER TABLE world.city ADD FULITEXT INDEX (Population);

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

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

Answer:F

Q124.User ‘ fwuser’@ ‘1ocalhost’ is registered with the MySQL Enterprise Firewall and has been granted privileges for the SAKILA database.

Examine these commands that you executed and the results:

mysql> SELECT MODE FROM INFORMATION SCHENA.MYSOL FIREKALL _USERS

WHERE USERHOST . fwuser@localhost';

+-----------+

I HODE       |

|PROTECT ING |

+----------- +

mysql> SELECT RULE FROM INFORMATION SCHENA. MYSOL_FIREKALL _WHITELIST

WHERE USRHOST * 'fwuser@localhost' ;

+-----------------------------------------------------------------------------------+

|RULE                                                                                |

+-----------------------------------------------------------------------------------+

|SELECT ‘first_ Name’ n,’last._name' FROM .’ customer’ WHERE ‘customer_ id' *?                 |

|SELECT ‘get. customer_balance*' (? . NOW ( ) )                                             |

|UPDATE ’rental' SET ‘return date’. = NOwl ( ) WHERE ‘rental_ id’ = ?                          |

|SELECT @@'version comment’ LIMIT ?                                                   |

+-----------------------------------------------------------------------------------+

You then execute this command:

mysql> CALL mysql.sp_ set_firewall, _model('fwuserlocalhost', 'RESET');

Which two are true?

A)The fwuser@localhost account is removed from the mysql .user table.

B)The information_ schema.MYSQL_FIREWALL_WHITELIST table is truncated,

C)The whitelist of the fwuser@localhost account is truncated.

D)The mysql. Firewall_users table is truncated.

E)The firewall resets all options to default values.

F)The fwusere@localhost account mode is set to DETECTING.

G)The fwuserd@localhost account mode is set to OFF.

Answer:CG

Q125.A newly deployed replication master database has a 10/90 read to write ratio.

The complete dataset is currently 28G but will never fluctuate beyond +- 10%.

The database storage system consists of two locally attached PCI-E Enterprise grade disks (mounted as /data1 and /data2)

The server is dedicated to this MySQL Instance.

System memory capacity is 64G.

The my. cnf file contents are displayed here:

[Imysqld]

datadir=/data1/

innodb_ buffer_ pool_ size=28G

innodb_ log_ file_ size=150M

Which four changes provide the most performance improvement, without sacrificing data integrity?

A)innodb-doublewrite=off

B)innodb_ 1og_group_home_ dir=/data2/

C)innodb_ 1og_ file_ size=1G

D)innodb_ undo_ directory=/dev/ shm

E)log-bin=/data2/

F)innodb_ flush_ log_ at_ trx_ commit=0

G)sync_ binlog=0

H)innodb_buffer _pool_ size=32G

I)disable-log-bin

Answer:BCGH

Q126.You are having performance issues with MySQL instances. Those servers are monitored with MySQL Enterprise Monitor.

Using Query Analyzer,where do you begin to look for problem queries?

A)Sort the "Exec" column and check for SQL queries with low Query Response Time index (QRTi) values.

B)Look for queries with low total latency times in the Latency section in the times series graph.

C)Sort the "Exec" column and check for SQL queries with high Query Response Time index (QRTi) values.

D)Look for queries with big prolonged spikes in row activity/access graph in the times series graph.

Answer:A

Q127.You want to log only the changes made to the database objects and data on the MySQL system.Which log will do this by default?

A)slow query log

B)binary log

C)error log

D)general query log

E)audit log

Answer:B

Q128.Identify two ways to significantly improve data security.

A)Configure mysqld to run as the system admin account, such as root.

B)Use a private network behind a firewall.

C)Configure mysqld to use only networked disks.

D)Configure MySQL to have only one administrative account.

E)Configure mysqld to use only local disks or attached disks and to have its own account in the host system.

Answer:BD

Q129.Which two statements are true about MySQL Enterprise Backup?

A)It creates logical backups.

B)It supports backing up only table structures.

C)It can perform hot or warm backups.

D)It supports backup of a remote MySQL system.

E)It supports restoring to a remote MySQL system.

F)It supports the creation of incremental backups.

Answer:CF

Q130.Examine these commands, which execute successfully on the ic1 host:

mysqlsh> dba. createCluster('cluster1', {}memberWeight:35})

mysqlsh> var mycluster = dba.getCluster ()

mysqlsh> mycluster . addInstance(' ic@ic2', {memberWeight:25}）

mysqlsh> mycluster .addInstance(' ic@ic3', {memberWeight:50})

Now examine this configuration setting, which is the same on all nodes:

group_ replication_ consistency=BEFORE_ ON_ PRIMARY_ FAILOVER

Which statement is true if primary node ic1 fails?

A)Node ic2 becomes the new primary and existing transactions are considered stale and rolled back.

B)Node ic3 becomes the new primary and existing transactions are considered stale and rolled back.

C)Node ic3 becomes the new primary and is ignored until any backlog of transactions is completed

D)Only two nodes remain so the election process is uncertain and must be done manually.

E)Node ic2 becomes the new primary and is ignored until any backlog of transactions is completed.

Answer:C