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

QUESTION 59
You created a backup of the world database with this command:
shell> mysqldump –opt world > dump.sql
Which two will import the data from dump.sql?

QUESTION 60
Which command-line utility creates encrypted files that can be used by client programs and contain obfuscated usernames and passwords?

QUESTION 61
Exhibit:

What does the possible_keys column in this output denote?

QUESTION 62
You have successfully provisioned the latest MySQL 5.7 database instance on a physical host, to be added to an existing farm for use in a modern, high volume, ACID-compliant, OLTP website, which serves hundreds of DML transactions per second.
The default values of which two key variables do you change to ensure seamless operation of the database?
(Choose two.)

QUESTION 63
Consider these global status variables:

Which two conclusions can be made from the output? (Choose two.)

QUESTION 64
Which three statements correctly describe MySQL InnoDB Cluster? (Choose three.)

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

QUESTION 66
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 67
Which three are key advantages of standard MySQL replication? (Choose three.)

QUESTION 68
When you examine a new MySQL installation with default configuration, you find a file called ibdata1in the database directory. Which two statements are true about this file?

QUESTION 69
Where does MySQL Linux RPM install the mysqld binary?

QUESTION 70
An admin attempts to enforce stronger security by using these commands:

The admin then leaves the system running with the specified changes. What are two remaining security concerns? (Choose two.)

QUESTION 71
What two statements are true regarding FLUSH TABLES FOR EXPORT? (Choose two.)

QUESTION 72
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 73
Which two statements are true about InnoDB auto-increment locking? (Choose two.)

QUESTION 74
old_alter_tableis disabled as shown.
mysql> SELECT @@old_alter_table;

Consider this statement on a RANGE-partitioned table:
mysql> ALTER TABLE orders DROP PARTITION p1, p3;
What is the outcome of executing this statement?

QUESTION 75
Consider the table people with the 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.)

QUESTION 76
An admin attempts to enforce stronger security by using these commands:

The admin then leaves the system running with the specified changes. What are two remaining security concerns?

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

QUESTION 78
You created a backup of the worlddatabase with this command:
shell> mysqldump –opt world > dump.sql
Which two will import the data from dump.sql? (Choose two.)

QUESTION 79
How does the InnoDB storage engine handle deadlocks when they are detected?

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

QUESTION 81
On a master server that is using statement-based replication, a table of log data has become very large.
You decide to delete 100,000 rows.
Which two methods can be independently invoked to ensure that the delete is properly propagated to the slave? (Choose two.)