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

examout.co

You want to create a temporary table named OLD_INVENTORY in the OLD_INVENTORY database on the master server. This table is not to be replicated to the slave server.

Which two changes would ensure that the temporary table does not propagate to the slave? (Choose two.)

A.

Set binlog_format=MIXED with the --replicate-ignore-temp-table option.

B.

Use the --replicate-do-db, --replicate-do-table, or --replicate-wild-do-table option with the value equal to OLD_INVENTORY.

C.

Change the binlog_format option to ROW and restart mysqld before you create the OLD_INVENTORY table.

D.

Stop SQL_THREAD on the slave until you have finished using the OLD_INVENTORY temporary table.

E.

Use the --replicate-ignore-table option with the value equal to OLD_INVENTORY.OLD_INVENTORY and restart mysqld before creating the temporary table.

Force Majeure is a catastrophic failure on a major level of the database operation. Regular backups are key to helping avoid data loss in such situations.

Which two other steps can help avoid data loss in a major catastrophe? (Choose two.)

A.

Implement a failover strategy to another geographic location.

B.

Create a master-master pair for each service.

C.

Have a second data centre in a different region or country.

D.

Keep software updated to the latest version.

E.

Use RAID 10 storage for data.

F.

Use on-site network-attached storage to separate service from data.

The MySQL installation includes the mysql_config_editor utility for managing login paths stored in a .mylogin.cnf file.

Which two are true about the login path feature? (Choose two.)

A.

mysql_config_editor is the only MySQL-provided utility that can print the values stored in .mylogin.cnf.

B.

A .mylogin.cnf file can store at most one login path.

C.

It provides a FIPS-compliant keyring for storing MySQL login details.

D.

A .mylogin.cnf file can be edited using a text editor, such as vim or Notepad++.

E.

It is an alternative to storing the MySQL login details in a my.cnf file.

F.

It provides means to help avoid accidentally exposing the MySQL login details.

Due to an authentication plug-in that is used on the server, passwords are required to be sent as clear text as opposed to the usual encrypted format.

Which two methods would allow the mysql client to connect to the server and send clear text passwords? (Choose two.)

A.

mysql --protocol=PLAIN –uroot –p –h dbhost.example.com

B.

INSTALL PLUGIN mysql_cleartext_password SONAME ‘mysql_cleartext_password.so’;

C.

export LIBMYSQL_ENABLE_CLEARTEXT_PLUGIN=’Y’

D.

SET GLOBAL mysql_cleartext_passwords=1;

E.

mysql --enable-cleartext-plugin –uroot –p –h dbhost.example.com

What does the possible_keys column in this output denote?

A.

if it is possible for you to include any indexes in your query

B.

whether there are any indexes on the tables that you are querying

C.

if there are any indexes that may be used to solve this query

D.

whether you are using any indexes in your query

You have successfully provisioned the latest MySQL 5.7 database instance on a physical host, to be added to an existing farm for use in a modern, high volume, ACID-compliant, OLTP website, which serves hundreds of DML transactions per second.

The default values of which two key variables do you change to ensure seamless operation of the database? (Choose two.)

A.

Key Buffer Size

B.

InnoDB Redo Log Size

C.

Binary Log Size

D.

Buffer Pool Size

E.

Sort Buffer size

F.

Query Cache Size

This output is from a SHOW SLAVE STATUS:

What would cause the SQL_Delay variable to have a value of 360?

A.

The master has performed a large transaction, which will take 360 seconds to complete on the slave.

B.

The network latency between the master and the slave is 360 milliseconds.

C.

The slave will need an estimated 360 seconds to update the remaining contents from the relay log.

D.

The slave was configured for delayed replication with a delay of six minutes.

Which MySQL utility copies the master instance to a slave instance on the same host?

A.

mysqlfailover

B.

mysqldbcopy

C.

mysqlrplsync

D.

mysqlserverclone

You are investigating the performance of a query which selects data from an InnoDB table.

Consider this Performance Schema diagnostics output for the query:

Which statement is true about the output?

A.

The time the query took is the sum of all timer_wait values.

B.

The query did not find its table in the table definition cache.

C.

The query read data from the data file rather than directly from the buffer pool.

D.

The event with event_id = 8945 is a child of the event with event_id=8944.

Consider the two partial outputs of the SHOW GLOBAL VARIABLES command from a master and slave server:

Master:

Slave:

There is a problem with the slave replicating from the master. Which statement describes the cause of the problem?

A.

The log_bin variable is set to OFF on the slave.

B.

server_id is not unique.

C.

The max_connections variable on the slave needs to be increased.

D.

The shared_memory_base_name variable must match the master.

E.

The version of the slave is newer that the version of the master.