[Q59-Q75] Updated 1Z0-908 Dumps PDF – 1Z0-908 Real Valid Brain Dumps With 142 Questions!

Rate this post

Updated 1Z0-908 Dumps PDF – 1Z0-908 Real Valid Brain Dumps With 142 Questions!

100% Free 1Z0-908 Exam Dumps Use Real MySQL Database Administration Dumps

QUESTION 59
Examine this query and its output:

Which two statements are true? (Choose two.)

The root user had the largest number of modified rows for a SELECT statement.

User bob had the largest total time waiting for locks.

The root user had the largest single wait time.

The app user had the highest total number of rows read from storage engines.

User bob had a significantly higher ratio of SELECT + INSERT statements to QUIT than both app and root users.

QUESTION 60
MySQL is installed on a Linux server with this configuration:

Which method sets the default authentication to SHA-256 hashing for authenticating user account passwords?

Set validate-user-plugins=caching_sha2_password in the configuration file.

Define CREATE USER ”@’%’ IDENTIFIED WITH sha256_password in the MySQL instance.

Add default_authentication_plugin=mysql_native_password in the configuration file.

Add default_authentication_plugin=sha256_password in the configuration file.

QUESTION 61
Which two commands will display indexes on the partstable in the manufacturing schema? (Choose two.)

DESCRIBE manufacturing.parts;

SELECT * FROM information_schema.statistics WHERE table_schema=’manufacturing’
AND TABLE_NAME=’parts’;

SHOW INDEXES FROM manufacturing.parts;

SELECT * FROM information_schema.COLUMN_STATISTICS;

EXPLAIN SELECT INDEXES FROM manufacturing.parts;

QUESTION 62
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?

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

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

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

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

QUESTION 63
Examine this statement and output:

You must try to reduce query execution time.
Which two queries should you focus on? (Choose two.)

QN = 3

QN = 5

QN = 1

QN = 4

QN = 2

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

Replication can use only TCP/IP connections.

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

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

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

Each slave must have its own MySQL user for replication.

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

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

QUESTION 65
You are considering using file-system snapshots to back up MySQL.
Which three statements are true? (Choose three.)

They take roughly twice as long as logical backups.

They allow direct copying of table rows with operating system copy commands.

They work best for transaction storage engines that can perform their own recovery when restored.

The backup window is almost zero from the perspective of the application.

They do not back up views, stored procedures, or configuration files.

There is a slight performance cost while the snapshot is active.

They do not use additional disk space.

QUESTION 66
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.

QUESTION 67
Examine this SQL statement:

Which set of privileges will allow Tom to execute this SQL statement?

GRANT ALL PRIVILEGES ON ‘world’.’city’ TO ‘tom’@’%’;
GRANT SELECT (‘code’) ON ‘world’.’country’ TO ‘tom’@’%’;

GRANT UPDATE ON ‘world’.* TO ‘tom’@’%’;
GRANT ALL PRIVILEGES ON ‘world’.’country’ TO ‘tom’@’%’;

GRANT UPDATE ON ‘world’.’city’ TO ‘tom’@’%’; GRANT SELECT ON ‘world’.* TO ‘tom’@’%’;

GRANT UPDATE ON ‘world’.’city’ TO ‘tom’@’%’; GRANT SELECT ON ‘world’.’country’ TO
‘tom’@’%’;

QUESTION 68
You have semi-synchronous replication configured and working with one slave.
rpl_semi_sync_master_timeout has never been reached.
You find that the disk system on the master has failed and as a result, the data on the master is completely unrecoverable.
Which two statements are true? (Choose two.)

No committed transactions are lost.

The slave automatically identifies that the master is unreachable and performs any required actions so that applications can start using the slave as the new master.

As soon as the incident happens, application can read data from the slave and rely on it to return a full and current set of data.

Reads from the slave can return outdated data until the value of the rpi_semi_sync_master_timeout variable is reached.

Reads from the slave can return outdated data for some time, until it applies all transactions from its relay log.

A small amount of committed transactions may be lost in case they were committed just before the disk failure.

QUESTION 69
Your MySQL server is running on the Microsoft Windows platform.
Which three local connection protocols are available to you? (Choose three.)

named pipes

shared memory

SOCKET

X Protocol

UDP

TCP/IP

QUESTION 70
Examine the modified output:

Seconds_Behind_ Master value 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.

QUESTION 71
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?

You use the MyISAM storage engine for most common tables.

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

The Innodb Buffer pool is full.

Your table accesses wait for the operating system level flush.

QUESTION 72
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

QUESTION 73
What is the correct syntax for using transparent data encryption with an existing InnoDB table?

ALTER TABLE t1 ADD ENCRYPTED_TABLESPACE = ‘Y’;

ALTER TABLE t1 ENCRYPTION=’Y’;

ALTER TABLE t1 WITH ENCRYPTION USING MASTER KEY;

ALTER TABLE t1 SET TDE = ‘ON’;

QUESTION 74
Examine this command, which executes successfully:
$ mysqlrouter –bootstrap user@hostname:port –directory=directory_path Which activity is performed?

MySQL Router is configured based on the information in files in directory_path.

MySQL Router configures itself based on the information retrieved from the InnoDB cluster metadata server.

MySQL Router is restarted.

MySQL Router configures all the cluster nodes based on the information retrieved from the InnoDB cluster metadata server.

QUESTION 75
You want to check the values of the sort_buffer_sizesession variables of all existing connections.
Which performance_schematable can you query?

user_variables_by_thread

global_variables

variables_by_thread

session_variables