Get 1z1-908 Products Practice Material for 1z1-908 Exam Question Preparation [Q47-Q66] : Top Exam Collection : http://blog.topexamcollection.com

NEW QUESTION 47
You must run multiple instances of MySQL Server on a single host.
Which three methods are supported? (Choose three.)

Run MySQL Server docker containers.

Use systemd with different settings for each instance.

Use system tools to lock each instance to its own CPU.

Start mysqld or mysqld_safe using different option files for each instance.

Run mysqld with –datadir defined for each instance.

Use resource groups to lock different instances on separate CPUs.

NEW QUESTION 48
Which three sets of item information are visible in the mysql system database? (Choose three.)

help topics

performance monitoring information

plugins

rollback segments

information about table structures

time zone information and definitions

audit log events

NEW QUESTION 49
You have configured MySQL Enterprise Monitor to monitor your MySQL server.
Which four features are available? (Choose four.)

starting and stopping the MySQL instance

tracing import and export with mysqidump

deploying the MySQL agent on supported target operating system

creating e-mail alerts and SNMP traps for MySQL warnings

monitoring the availability of the MySQL instance

analyzing executed MySQL queries

monitoring of NDB Cluster API nodes

NEW QUESTION 50
Examine this command and output:

Which two statements are true? (Choose two.)

The lock is at the metadata object level.

The lock is a shared lock.

The lock is an intentional lock.

The lock is at the table object level.

The lock is a row-level lock.

The lock is an exclusive lock.

NEW QUESTION 51
You have just installed MySQL on Oracle Linux and adjusted your /etc/my.cnf parameters to suit your installation.
Examine the output:

What statement is true about the start attempt?

MySQL server was not started due to a problem while executing process 2732.

MySQL server continued to start up even though another process existed.

systemd found the mysqld service disabled and failed to start it.

systemd waited for 30 seconds before timing out and start up failed.

systemd attempted to start mysqld, found another systemd mysqld process running, and shut it down.

NEW QUESTION 52
Which two statements are true about MySQL server multi-source replication? (Choose two.)

It is not compatible with auto-positioning.

It needs to be re-instanced after a crash to maintain consistency.

It uses only time-based replication conflict resolution.

It relies on relay_log_recovery for resilient operations.

It does not attempt to detect or resolve replication conflicts.

It must use GTID replication.

NEW QUESTION 53
You have configured GTID-based asynchronous replication with one master and one slave.
A user accidentally updated some data on the slave.
To fix this, you stopped replication and successfully reverted the accidental changes. Examine the current GTID information:

You must fix GTID sets on the slave to avoid replicating unwanted transactions in case of failover. Which set of actions would allow the slave to continue replicating without erroneous transactions?

RESET MASTER;
SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;

SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312,bbbbbbbb- bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-9; SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;

RESET SLAVE;
SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3820;
SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10300;

RESET MASTER;
SET GLOBAL gtid_purged-aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312;
SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;

RESET SLAVE;
SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;

NEW QUESTION 54
Examine this query and output:

Which two statements are true? (Choose two.)

The country table is accessed as the first table, and then joined to the city table.

It takes more than 8 milliseconds to sort the rows.

The optimizer estimates that 51 rows in the country table have Continent = ‘Asia’.

35 rows from the city table are included in the result.

The query returns exactly 125 rows.

NEW QUESTION 55
Which condition is true about the use of the hash join algorithm?

No index can be used for the join.

The query must access no more than two tables.

The smallest of the tables in the join must fit in memory as set by join_buffer_size.

At least one of the tables in the join must have a hash index.

NEW QUESTION 56
An attempt to recover an InnoDB Cluster fails.
Examine this set of messages and responses:
host3:3377 ssl JS > dba.rebootClusterFromCompleteOutage()
Reconfiguring the default cluster from complete outage…
The instance ‘host1:3377’’ was part of the cluster configuration.
Would you like to rejoin it to the cluster? [y/N]: y
The instance ‘host2:3377’ was part of the cluster configuration.
Would you like to rejoin it to the cluster? [y/N]: y
Dba.rebootClusterFromCompleteOutage: The active session instance isn’t the most updated in comparison with the ONLINE instances of the Cluster’s metadata. Please use the most up to date instance: ‘host1:3377’. (RuntimeError) Which statement is true?

The instance deployed on host3must be rebuilt with a backup from the primary instance.

The cluster is running and there is at least one ONLINEinstance.

The instance deployed on host3must be synchronized from a donor deployed on host1by using the command cluster.addInstance(‘host1:3377’).

It is possible to determine the most up-to-date instance by comparing different global transaction identifier (GTID) sets with GTID_SUBSET(set1,set2).

The active session instance is invalid and must be re-created by using the command shell.connect (‘host3:3377’).

NEW QUESTION 57
Examine the modified output:

Seconds_Behind_ Mastervalue is steadily growing.
What are two possible causes? (Choose two.)

The master is most probably too busy to transmit data and the slave needs to wait for more data.

One or more large tables do not have primary keys.

This value shows only I/O latency and is not indicative of the size of the transaction queue.

The master is producing a large volume of events in parallel but the slave is processing them serially.

The parallel slave threads are experiencing lock contention.

NEW QUESTION 58
Which two storage engines provide a view of the data consistent with the storage system at any moment? (Choose two.)

MyISAM

NDB

MEMORY