NEW QUESTION 1
Force Majeure is a catastrophic failure on a major level of the database operation. Regular backups are key to helping avoid data loss in such situations.
Which two other steps can help avoid data loss in a major catastrophe?

• A. Implement a failover strategy to another geographic location.
• B. Create a master-master pair for each service.
• C. Have a second data centre in a different region or country.
• D. Keep software updated to the latest version.
• E. Use RAID 10 storage for datA.
• F. Use on-site network-attached storage to separate service from dat

Answer: AC

NEW QUESTION 2
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?

• A. The applications have the SUPER privilege, which allows them to update rows.
• B. The root user on the slave has executed FLUSH LOGS, causing the relay-log to doublewrite.
• C. For tables with UNIQUE keys, statement-based replication must be used to maintain integrity.
• D. The slave was created with mysqldump –u root –p --skip-lock-tables –all-databases > /data/datA.sql
• E. The slave user does not have INSERT, UPDATE, or DELETE permission and cannot execute the Write_rows function.

Answer: CD

NEW QUESTION 3
Suppose you are adding rows to a MyISAM table and the --datadir location runs out of disk space. What will happen when this occurs?

• A. The server will crash.
• B. The server suspends that INSERT operation until space becomes available.
• C. An error message will be returned to the client .Server Error: ER_IO
• D. The server suspends operations for all storage engines until space becomes availabl

Answer: B

NEW QUESTION 4
Which three tasks are handled by the optimizer?

• A. Decide which indexes to use.
• B. Rewrite the WHERE clause.
• C. Parse the query.
• D. Change the order in which the tables are joined.
• E. Validate the query.
• F. Execute the query.
• G. Verify that the user is allowed to execute the quer

Answer: BCF

NEW QUESTION 5
The following grants were executed:
GRANT CREATE ROUTING ON sales.* TO ‘webadmin’@’%’; GRANT ALTER ON PROCEDURE sales.myproc TO ‘webadmin’@’%’;
A user successfully connects to the database as webadmin and created a stored procedure named get_reports. The next day, the user logs in again as webadmin and wants to delete the stored procedure named get_reports, and therefore, issues the following statement:
USE sales;
DROP PROCEDURE IF EXISTS get_reports; What is the result of executing the statement?

• A. The user will get an error because he or she did not use the ALTER statement to drop the stored procedure.
• B. The user will get an error because he or she did not put the database name in front of the stored procedure name.
• C. The stored procedure named get_reports will be dropped.
• D. The user will get an error because he or she does not have the permission to drop stored procedure

Answer: C

NEW QUESTION 6
You have just executed a manual backup by using this command:
mysqlbackup –u root –p –-socket=/tmp/my.sock –-backup-dir=/my/backup/ backup The operation completed without error.
What is the state of this backup and operation required before it is ready to be restored?

• A. Backup State = Compressed Backup Operation = copy-back
• B. Backup State = Raw Backup Operation = apply-log
• C. Backup State = Prepared Backup Operation = validate
• D. Backup State = Prepared Backup Operation = apply-log
• E. Backup State = Raw Backup Operation = backupdir-to-image

Answer: E

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

What would you run to fix the issue?

• A. the mysql_upgrade script
• B. the mysql client with the --ignore-password-hashing option
• C. the mysql_secure_installation script to update server security settings
• D. the mysql client with the --enable-cleartext-plugin option
• E. the install plugin command for the mysql_cleartext_password plugin

Answer: C

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

• A. Execute the PURGE BINARY LOGS NOT USED command.
• B. Edit the .index file to remove the files you want to delete.
• C. Ensure that none of the attached slaves are using any of the binary logs you want to delete.
• D. Remove all of the binary log files that have a modification date earlier than today.
• E. Use the command PURGE BINARY LOGS and specify a binary log file name or a date and time to remove unused files.

Answer: CE

Explanation:
A: To safely purge binary log files, follow this procedure:
1. On each slave server, use SHOW SLAVE STATUS to check which log file it is reading.
2. Obtain a listing of the binary log files on the master server with SHOW BINARY LOGS.
3. Determine the earliest log file among all the slaves. This is the target file. If all the slaves are up to date, this is the last log file on the list.
4. Make a backup of all the log files you are about to delete. (This step is optional, but always advisable.)
5. Purge all log files up to but not including the target file. Syntax:
PURGE { BINARY | MASTER } LOGS
{ TO ‘log_name’ | BEFORE datetime_expr }

NEW QUESTION 9
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?

• A. Increase the value of the innodb_lock_wait_timeout option.
• B. Increase the value of the innodb_read_io_threads option.
• C. Change the table to use HASH indexes instead of BTREE indexes.
• D. Set the value of innodb_adaptive_hash_index to zero.
• E. Deactivate the query cache.
• F. Increase the size of the InnoDB buffer poo

Answer: BF

NEW QUESTION 10
Which two methods accurately monitor the size of your total database size over time?

• A. monitoring the Innodb_rows_inserted status variable
• B. monitoring the innodb_redo_log_size variable
• C. monitoring the information_schemA.TABLES table
• D. monitoring datadir size in the operating system
• E. monitoring cumulative Innodb_page_size increase
• F. monitoring the performance_schema_hosts_size variable

Answer: CF

NEW QUESTION 11
Which three are key advantages of standard MySQL replication?

• A. supports native automatic failover
• B. enables automatic resync of databases when discrepancies are detected
• C. provides arbitrary geographic redundancy with minimal overhead to master
• D. synchronously guarantees identical slave copy
• E. is easy to configure and has low performance overhead
• F. can easily add slaves for read scaling

Answer: BEF

NEW QUESTION 12
Due to an authentication plug-in that is used on the server, passwords are required to be sent as clear text as opposed to the usual encrypted format.
Which two methods would allow the mysql client to connect to the server and send clear text passwords?

• A. mysql --protocol=PLAIN –uroot –p –h dbhost.example.com
• B. INSTALL PLUGIN mysql_cleartext_password SONAME ‘mysql_cleartext_password.so’;
• C. export LIBMYSQL_ENABLE_CLEARTEXT_PLUGIN=’Y’
• D. SET GLOBAL mysql_cleartext_passwords=1;
• E. mysql --enable-cleartext-plugin –uroot –p –h dbhost.example.com

Answer: DE

NEW QUESTION 13
Which two options describe how MySQL Server allocates memory?

• A. Each connection may have its own per-thread memory allocations.
• B. Thread memory is pre-allocated up to thread_cache_size for performance.
• C. Each thread allocates memory from a global pool.
• D. Global memory resources are allocated at server startu

Answer: AD

NEW QUESTION 14
What are three methods to reduce MySQL server exposure to remote connections? (Choose three.)

• A. using SSL when transporting data over remote networks
• B. using the sql_mode=STRlCT_SECURE after connections are established for encrypted communications
• C. setting —skip-networking when remote connections are not required
• D. setting specific grant privileges to limit remote authentication
• E. setting —mysql_secure_configuration to enable paranoid mode

Answer: ACD

NEW QUESTION 15
Which three allocate memory per thread in MySQL?

• A. query cache
• B. thread cache
• C. read buffer
• D. internal temporary table
• E. sort buffer
• F. InnoDB buffer pool instance

Answer: CEF

NEW QUESTION 16
Which two are considered good security practices when using passwords? (Choose two.)

• A. Use one-way encryption for storage of passwords.
• B. Store passwords external to the database.
• C. Choose short passwords to save on storage space.
• D. Use simple keyboard actions that give mixed letters.
• E. Do not use dictionary-based word

Answer: AE

NEW QUESTION 17
You back up by using mysqldump.
Which configuration is required on the MySQL Server to allow point-in-time recovery?

• A. binlog_format=STATEMENT
• B. log-bin
• C. apply-log
• D. bonlog_format=ROW
• E. gtid_enable

Answer: B

NEW QUESTION 18
Which two statements describe how InnoDB recovery works?

• A. InnoDB handles most crash recoveries automatically.
• B. InnoDB blocks some operations when innodb_force_recovery is set to greater than 0.
• C. There will in general be lost committed transactions after a crash using the default settings.
• D. It is required to enable binlog_gtid_simple_recovery to perform a crash recovery.
• E. It is recommended to set innodb_force_recovery = 1 as part of normal operations.
• F. It is always required to enable innodb_force_recovery to perform a crash recover

Answer: BF

NEW QUESTION 19
A MySQL Server has been running an existing application successfully for six months. The my.cnf is adjusted to contain this additional configuration:

The MySQL Server is restarted without error.
What effect will the new configuration have on existing account?

• A. They are not affected by this configuration change.
• B. They all connect via the secure sha256_password algorithm without any configuration change.
• C. They will have their passwords updated on start-up to sha256_password format.
• D. They will have to change their password the next time they login to the serve

Answer: A

NEW QUESTION 20
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?

• A. validate_password_policy cannot be set without restarting the MySQL instance.
• B. The name of the dictionary file is too obvious.
• C. The dictionary file word list is too short.
• D. validate_password_dictionary_file cannot be set without restarting the MySQL instance.
• E. The validate_password plug-in has not been loaded.
• F. The dictionary file is an insecure locatio

Answer: BF

NEW QUESTION 21
......