New 2022 1Z0-888 exam questions Welcome to download the newest ValidVCE 1Z0-888 PDF dumps (155 Q&As)
P.S. Free 2022 MySQL Database Administration 1Z0-888 dumps are available on Google Drive shared by ValidVCE
NEW QUESTION 16
After analysis on the slow query log on a high-end OLTP service, the table identified in the slow queries is:
What are the two most likely reasons for the slowness given this output?
- A. Date should be a TIMESTAMP field for better performance.
- B. The User field is too long for most names.
- C. Using default values for DATETIME causes table scans.
- D. No indexes are defined.
- E. The engine type is not appropriate to the application use.
Answer: D,E
NEW QUESTION 17
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.)
- A. The sync_relay_log=1000 setting on the slave is too small.
- B. sync_binlog=0 and the master server crashed.
- C. binlog_cache_size=1024 is too small and transactions are lost.
- D. binlog_format=STATEMENT and a non-deterministic query was executed.
- E. enforce_gtid_consistency=ON and consistency is broken between the master and the slave.
Answer: C,E
NEW QUESTION 18
You have a MySQL instance with the following variables in the /etc/my.cnf file:
You issue these statements:
USE prices;
UPDATE sales.january SET amount=amount+1000;
An hour after excluding the statements, you realize that you made a mistake and you want to go to the binary log and look at the statements again.
Which statement is true? (Choose two.)
- A. The statement would fail because you cannot update more than one row at a time when using
-binlogformat = ROW. - B. Nothing is logged because you are executing an UPDATE statement that will cause changes to more than one row, and you do not have the --binlog-format value set to STATEMENT.
- C. Nothing was written to the binary log because you cannot perform a calculation in a query without enclosing the statement in single quotation marks.
- D. The changes caused by the UPDATE statement are logged to the binary log because the instance is using --binlog-format = ROW
- E. You would receive an error on the statement because you cannot update a different database that what is specified with the USE statement.
Answer: B,C
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 will have to change their password the next time they login to the server.
- C. They all connect via the secure sha256_passwordalgorithm without any configuration change.
- D. They will have their passwords updated on start-up to sha256_passwordformat.
Answer: A
NEW QUESTION 20
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. export LIBMYSQL_ENABLE_CLEARTEXT_PLUGIN='Y'
- B. INSTALL PLUGIN mysql_cleartext_password SONAME `mysql_cleartext_password.so';
- C. mysql --enable-cleartext-plugin -uroot -p -h dbhost.example.com
- D. SET GLOBAL mysql_cleartext_passwords=1;
- E. mysql --protocol=PLAIN -uroot -p -h dbhost.example.com
Answer: C,D
Explanation:
Reference:
https://dev.mysql.com/doc/refman/5.7/en/cleartext-pluggable-authentication.html
NEW QUESTION 21
You are investigating the performance of the server and see this information:
* events_waits_summary_global_by_event_name in the Performance Schema shows that the wait/synch/mutex/sql/LOCK_table_cache event is dominating other wait events.
* The Table_open_cache_overflows status variable is 0.
Which action should be taken to remove the performance bottleneck described here?
- A. Decrease the value of table_definition_cache.
- B. Increase the value of table_open_cache.
- C. Decrease the value of table_open_cache.
- D. Increase the value of table_open_cache_instances.
- E. Decrease the value of table_open_cache instances.
- F. Increase the value of table_definition_cache.
Answer: D
NEW QUESTION 22
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 root user on the slave has executed FLUSH LOGS, causing the relay-log to doublewrite.
- B. The slave was created with mysqldump -u root -p --skip-lock-tables -all-databases
> /data/data.sql - C. The applications have the SUPERprivilege, which allows them to update rows.
- D. For tables with UNIQUE keys, statement-based replication must be used to maintain integrity.
- E. The slave user does not have INSERT, UPDATE, or DELETEpermission and cannot execute the Write_rowsfunction.
Answer: B,D
NEW QUESTION 23
The MySQL user 'adam' currently has USAGE permissions to the database.
The football database is transactional and has non-stop updates from application users. The 'adam' user needs to be able to take consistent backups of the football database by using the --single-transaction option.
Which extra GRANT permissions are required for adam to take mysqldump backups?
- A. The 'adam' user must also have SINGLE TRANSACTION global grant to take a consistent backup.
- B. The 'adam' user must have the SUPER privilege in order to take data backups.
- C. The 'adam' user must also have SELECT on the football database for backup to work.
- D. The 'adam' user needs the PROCESS privilege to be able to take a consistent backup while other users are connected.
Answer: B
NEW QUESTION 24
The MySQL installation includes the mysql_config_editor utility for managing login paths stored in a .mylogin.cnf file.
Which two are true about the login path feature? (Choose two.)
- A. It provides means to help avoid accidentally exposing the MySQL login details.
- B. mysql_config_editor is the only MySQL-provided utility that can print the values stored in .mylogin.cnf.
- C. A .mylogin.cnf file can be edited using a text editor, such as vim or Notepad++.
- D. A .mylogin.cnf file can store at most one login path.
- E. It is an alternative to storing the MySQL login details in a my.cnf file.
- F. It provides a FIPS-compliant keyring for storing MySQL login details.
Answer: A,E
NEW QUESTION 25
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? (Choose two.)
- A. Keep software updated to the latest version.
- B. Create a master-master pair for each service.
- C. Use RAID 10 storage for data.
- D. Implement a failover strategy to another geographic location.
- E. Use on-site network-attached storage to separate service from data.
- F. Have a second data centre in a different region or country.
Answer: D,F
NEW QUESTION 26
Which three options are most likely to be changed for production form their default values? (Choose three.)
- A. port
- B. max_connections
- C. character_set_system
- D. innodb_buffer_pool_size
- E. innodb_log_file_size
- F. max_user_connections
- G. join_buffer_size
Answer: A,E,F
NEW QUESTION 27
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?
- A. --skip-opt
- B. --single-transaction
- C. --lock-all-tables
- D. --master-data
- E. --create-apply-log
Answer: A,C
NEW QUESTION 28
A single InnoDB table has been dropped by accident. You are unable to use an additional intermediate MySQL instance to restore the table. Which two backup methods can be used to restore the single table without stopping the MySQL instance? (Choose two.)
- A. a backup created using FLUSH TABLES ... FOR EXPORT
- B. an up-to-date replication slave
- C. a backup created with mysqldump --all-databases
- D. a file system-level snapshot
- E. a file system copy created while MySQL was shut down.
Answer: C,D
NEW QUESTION 29
Why should you be selective when granting the PROCESS privilege to an account?
- A. It allows a client to control running processes on a server.
- B. It allows a client to see another user's queries with the SHOW PROCESSLIST command.
- C. It allows a client to process scripts.
- D. It allows the use of stored routines.
Answer: A
Explanation:
https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html
NEW QUESTION 30
You have installed MySQL Server for the first time on your system. However, the data directory along with the tables in the mysql system database are missing. Which step do you perform to create the contents of the data directory?
- A. Invoke mysql with the --initialize option.
- B. Run the create_system_tables.sql file
- C. Run the mysql_unpack.sql file
- D. Invoke mysqld with the --initialize option.
Answer: D
NEW QUESTION 31
Consider that local disk files are accessible via MySQL with commands such as:
mysql> LOAD DATA LOCAL INFILE '/etc/passwd' INTO TABLE mypasswords;
What change could be made to stop any breach via this insecurity?
- A. executing REVOKE FILE ON *_* FROM ' '@'%'
- B. setting the --open-files-limit=0option when starting mysqld
- C. executing REVOKE LOAD FROM *.*
- D. setting the --local-infile=0option when starting mysqld
- E. setting the --local-service=0option when starting mysqld
- F. executing REVOKE FILE FROM *_*
Answer: B
NEW QUESTION 32
......
1Z0-888 exam questions from ValidVCE dumps: https://www.validvce.com/1Z0-888-exam-collection.html (155 Q&As)
