Free Cram & Latest Exams Dumps

QUESTION 53
A MySQL replication slave is set up as follows:
Uses all InnoDB tables

Receives ROW-based binary logs

Has the read-only option

The replication slave has been found in an error state.
You check the MySQL error log file and find these entries:

What are two possible causes for this error to occur? (Choose two.)

QUESTION 54
You are using replication and the binary log files on your master server consume a lot of disk space.
Which two steps should you perform to safely remove some of the older binary log files? (Choose two.)

QUESTION 55
Host slave1 has ip address 192.0.2.10.
Host slave2 has ip address 203.0.113.50
Examine these commands:

Why did this error occur?

QUESTION 56
A MySQL database uses all InnoDB tables and is configured as follows;

You will be setting up a replication slave by using mysqldump. You will need a consistent backup taken from your running production server. The process should have minimal impact to active database connections.
Which two arguments will you pass to mysqldump to achieve this?

QUESTION 57
Consider the CHECK TABLE command.
In which two situations should this command be used? (Choose two.)

QUESTION 58
Which three options are most likely to be changed for production form their default values?

QUESTION 59
An administrator installs MySQL to run under a mysql OS account. The administrator decides to disable logins to the mysql account by using /nologin or /bin/false as the user’s shell setting.
Which statement is true?

QUESTION 60
Which two capabilities are granted with the SUPER privilege? (Choose two.)

QUESTION 61
A master-slave replication setup has the slave showing this error:

On the master server, the binary logs show:

What could explain this error? (Choose two.)

QUESTION 62
Consider the join_buffer_sizeparameter in MySQL Server.
Which two statements are true about the join buffer? (Choose two.)

QUESTION 63
Consider the index information for the dept_emp table in the employee’s schema:

Which two conclusions can be made based on the output of the query?

QUESTION 64
What is the order of tables shown in an EXPLAINoutput?

QUESTION 65
You will configure a MySQL Server to act as a replication master. Which two options must be configured correctly to allow this? (Choose two.)

QUESTION 66
You have a MySQL instance running in a single cpu (1vCPU) VM in a shared infrastructure environment.
Your users are complaining that MySQL is sporadically slow and you have a suspicion that the VM infrastructure host is at fault due to resource contention.
You review the output of your scripts that monitor the database VM operating system during an extended period of slowdown.
What are the two most common indicators of the VM infrastructure host being at fault due to resource contention? (Choose two.)

QUESTION 67
Multiversion Concurrency Control (MVCC) enables what type of backup?

QUESTION 68
You are contacted by a user who does not have permission to access a database table.
You determine after investigation that this user should be permitted to have access and so you execute a GRANT statement to enable the user to access the table.
Which statement describes the activation of that access for the user?

QUESTION 69
You have the following in your my.cnf configuration file:
[mysqld]
default_authentication_plugin=sha256_password
You want to create a new user who will be connecting from the IP address 192.0.2.10, and you want to use the authentication plug-in that implements SHA-256 hashing for user account passwords.
Which two statements would create a user named webdesign for this IP address with the password of imbatman using a SHA_256 password hash?