NEW QUESTION 42
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.)

NEW QUESTION 43
Which two methods will provide the total number of partitions on a table? (Choose two.)

NEW QUESTION 44
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.)

NEW QUESTION 45
You inherited a busy InnoDB OLTP Instance with 100 schemas and 100 active users per schema.
Total dataset size is 200G with an average schema size of 2G.

The data is transient and is not backed up and can be repopulated easily.

Performance and responsiveness of the DB is paramount.

The query pattern for the DB instance is split 90/10 read/write.

DB host is dedicated server with 256G RAM and 64 cores.

One of your colleagues made some recent changes to the system and users are now complaining of performance impacts.
Which four configuration file edits might your colleague have performed to cause the negative DB performance? (Choose four.)

NEW QUESTION 46
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.)

NEW QUESTION 47
You inherited a busy InnoDB OLTP Instance with 100 schemas and 100 active users per schema.
* Total dataset size is 200G with an average schema size of 2G.
* The data is transient and is not backed up and can be repopulated easily.
* Performance and responsiveness of the DB is paramount.
* The query pattern for the DB instance is split 90/10 read/write.
* DB host is dedicated server with 256G RAM and 64 cores.
One of your colleagues made some recent changes to the system and users are now complaining of performance impacts.
Which four configuration file edits might your colleague have performed to cause the negative DB performance? (Choose four.)

NEW QUESTION 48
The MySQL error log shows:
InnoDB: Warning: a long semaphore wait:
The relevant parts of the InnoDB monitor output shows:

Which two options would help avoid the long wait in the future?

NEW QUESTION 49
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? (Choose two.)

NEW QUESTION 50
What are three typical causes of MySQL becoming suddenly slow and unavailable? (Choose three.)

NEW QUESTION 51
Consider the table people with this definition:

The application uses a query such as:
SELECT * FROM people WHERE YEAR(Birthday) = 1980;
The query is not using an index.
Which two methods can be used to allow the query to use an index? (Choose two.)

NEW QUESTION 52
Is it true that binary backups always take less space than text backups?

NEW QUESTION 53
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.)

NEW QUESTION 54
Examine the mysqldumpslow output:

Which two options could explain the slow query? (Choose two.)

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

NEW QUESTION 56
After rebooting the host, you attempt to start the mysqld service. You get the following error:
Can’t start the server: Bind on TCP/IP port: Address already in use
What is the most likely cause of this error?

NEW QUESTION 57
The ‘applicationdb’ is using InnoDB and consuming a large amount of file system space. You have a / backuppartition available on NFS where backups are stored.
You investigate and gather this information:

Three tables are stored in the InnoDB shared tablespace and the details are as follows:
* The table data_currenthas 1,000,000 rows.
* The table data_reports has 1,500,000 rows.
* The table data_archivehas 4,500,000 rows.

You attempt to free space from ibdata1by taking a mysqldump of the data_archivetable and storing it on your backup partition.

Unfortunately, this action does not free any actual disk space back to the file system and the server disk space is running out.
Which set of actions will allow you to free disk space back to the file system?

NEW QUESTION 58
Given these table definitions and the explain plan:

Which ALTER TABLE statement will improve the performance of the query?

NEW QUESTION 59
A simple master-to-slave replication is currently being used. This information is extracted from the SHOW SLAVE STATUS output:

You execute a ‘SHOW CREATE TABLE mytable” on the slave:

The table mytable on the slave contains:

You have issued a STOP SLAVE command. You have determined that it is safe to skip the transaction in this case. One or more statements are required before you can issue a START SLAVE command to resolve the duplicate key error. Which statement should be used?

NEW QUESTION 60
You attempt to connect to a MySQL Server by using the mysqlclient program. However, you receive this notice:

What would you run to fix the issue?

NEW QUESTION 61
Which statement best describes the purpose of the InnoDB buffer pool?

NEW QUESTION 62
You have forgotten the root user account password. You decide to reset the password and execute:

Which additional argument makes this operation safer?