Give Push to your Success with MySQL Database Administration 1z1-908 Exam Questions [Q14-Q33]

QUESTION 14
Examine this SQL statement:
mysql> GRANT r_read@localhost TO mark WITH ADMIN OPTION;
Which two are true? (Choose two.)

QUESTION 15
The data in this instance is transient; no backup or replication will be required. It is currently under performing.
* The database size is static and including indexes is 19G.
* Total system memory is 32G.
After profiling the system, you highlight these MySQL status and global variables:

The OS metrics indicate that disk is a bottleneck. Other variables retain their default values.
Which three changes will provide the most benefit to the instance? (Choose three.)

QUESTION 16
Which two MySQL Shell commands are excluded from the InnoDB Cluster creation procedure? (Choose two.)

QUESTION 17
There are five MySQL instances configured with a working group replication.
Examine the output of the group members:

Which two statements are true about network partitioning in the cluster? (Choose two.)

QUESTION 18
Which four are types of information stored in the MySQL data dictionary? (Choose four.)

QUESTION 19
Examine these InnoDB Cluster parameter settings:

Now examine the partial status:

A permanent network failure isolates host3.
Which two statements are true? (Choose two.)

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

QUESTION 21
Which four connection methods can MySQL clients specify with the –protocol option when connecting to a MySQL server? (Choose four.)

QUESTION 22
Your MySQL server was upgraded from an earlier major version.
The sales database contains three tables, one of which is the transactions table, which has 4 million rows.
You are running low on disk space on the datadir partition and begin to investigate.
Examine these commands and output:

Which two statements are true? (Choose two.)

QUESTION 23
Examine this list of MySQL data directory binary logs:
binlog.000001 binlog.000002
…..
binlog.000289
binlog.000300
binlog.000301
binlog.index
Now examine this command, which executes successfully:
mysqldump –delete-master-logs –all-databases > /backup/db_backup.sql
Which two are true? (Choose two.)

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

QUESTION 25
You have a MySQL system with 500 GB of data that needs frequent backups.
You use a mix of MyISAM and InnoDB storage engines for your data.
Examine your backup requirement:
* The MySQL system being backed up can never be unavailable or locked to the client applications.
* The recovery from the backup must work on any system.
* Only 1 hour of data can be lost on recovery of the backup.
Which option fulfills all backup requirements?

QUESTION 26
Examine this SQL statement:
mysql> GRANT r_read@localhost TO mark WITH ADMIN OPTION;
Which two are true? (Choose two.)

QUESTION 27
Examine this MySQL client command to connect to a remote database:
mysql -h remote.example.org -u root -p –protocol=TCP –ssl-mode=
Which two –ssl-mode values will ensure that an X.509-compliant certificate will be used to establish the SSL/TLS connection to MySQL?

QUESTION 28
Which step or set of steps can be used to rotate the error log?

QUESTION 29
Examine these statements, which execute successfully:
CREATE ROLE r_world_rd;
GRANT SELECT ON world.* TO r_world_rd;
CREATE USER john IDENTIFIED BY ‘P@ssw0rd’;
GRANT r_world_rd TO john;
Examine these statements issued by user John:

What is the reason for the error?

QUESTION 30
You have upgraded the MySQL binaries from 5.7.28 to 8.0.18 by using an in-place upgrade.
Examine the message sequence generated during the first start of MySQL 8.0.18:

Which step or set of steps will resolve the errors?

QUESTION 31
Which two are true about differences between logical and physical upgrades of MySQL databases? (Choose two.)

QUESTION 32
Which two MySQL Shell commands are excluded from the InnoDB Cluster creation procedure? (Choose two.)

QUESTION 33
A valid raw backup of the shop.customers MyISAM table was taken.
You must restore the table. You begin with these steps:
1. Confirm that secure_file_priv=’/var/tmp’
2. mysql> DROP TABLE shop.customers;
3. shell> cp /backup/customers.MY* /var/lib/mysql/shop/
Which two actions are required to complete the restore? (Choose two.)