Free 1Z0-908 Exam Braindumps certification guide Q&A [Q63-Q80]

Q63. Your my.cnf file contains these settings:

You want to log queries that looked at a minimum of 5000 records and either took longer than 5 seconds to run or did not use indexes.
Which contains all the settings that you need to add to or modify the slow log configuration?

Q64. Examine this parameter setting:
audit_log=FORCE_LOG_PERMANENT
What effect does this have on auditing?

Q65. You are upgrading a MySQL instance to the latest 8.0 version.
Examine this output:

You plan to add this parameter to the configuration: innodb_directories=’/innodb_extras’ Which statement is true?

Q66. Examine this command, which executes successfully:
mysqlpump –user=root –password > full_backup.sql
Which two databases will be excluded from this dump? (Choose two.)

Q67. You are backing up raw InnoDB files by using mysqlbackup.
Which two groups of files will be backed up during a full backup? (Choose two.)

Q68. Where is the default data directory located after installing MySQL using RPM on Oracle Linux 7?

Q69. Which two statements are true about the binary log encryption feature? (Choose two.)

Q70. You have just installed MySQL on Oracle Linux and adjusted your /etc/my.cnf parameters to suit your installation.
Examine the output:

What statement is true about the start attempt?

Q71. Binary log events for the ‘mydb1’ schema must be copied to a different schema name ‘mydb2’.
Which command will do this?

Q72. Which two statements are true about using MySQL Enterprise Monitor Query Analyzer? (Choose two.)

Q73. Which two storage engines provide a view of the data consistent with the storage system at any moment?
(Choose two.)

Q74. What does the binlog dump thread do?

Q75. Examine this command, which executes successfully on InnoDB Cluster: dba.dropMetadataSchema() Which two statements are true? (Choose two.)

Q76. 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.)

Q77. Which two statements are true about InnoDB data-at-rest encryption? (Choose two.)

Q78. On examination, your MySQL installation datadir has become recursively world read/write/executable.
What are two major concerns of running an installation with incorrect file privileges? (Choose two.)

Q79. Examine these commands and output:

Which connection ID is holding the metadata lock?

Q80. Examine this statement and output:

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