Use Real 1Z0-888 - 100% Cover Real Exam Questions [Oct-2021]
Dumps Brief Outline Of The 1Z0-888 Exam - VCEEngine
NEW QUESTION 74
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. Set the value of innodb_adaptive_hash_index to zero.
- B. Increase the value of the innodb_lock_wait_timeout option.
- C. Increase the value of the innodb_read_io_threads option.
- D. Increase the size of the InnoDB buffer pool.
- E. Change the table to use HASH indexes instead of BTREE indexes.
- F. Deactivate the query cache.
Answer: C,D
NEW QUESTION 75
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? (Choose two.)
- A. --lock-all-tables
- B. --single-transaction
- C. --master-data
- D. --skip-opt
- E. --create-apply-log
Answer: A,D
NEW QUESTION 76
old_alter_table is 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?
- A. All data in p1 and p3 partitions is removed, but the table definition remains unchanged.
- B. Only the first partition (p1) will be dropped because only one partition can be dropped at any time.
- C. All data in p1 and p3 partitions is removed and the table definition is changed.
- D. It results in a syntax error because you cannot specify more than one partition in the same statement.
Answer: A
NEW QUESTION 77
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. Set the value of innodb_adaptive_hash_index to zero.
- B. Increase the value of the innodb_lock_wait_timeout option.
- C. Increase the value of the innodb_read_io_threads option.
- D. Increase the size of the InnoDB buffer pool.
- E. Change the table to use HASH indexes instead of BTREE indexes.
- F. Deactivate the query cache.
Answer: C,D
NEW QUESTION 78
You have a server that has very limited memory but has a very large table.
You will use mysqldump to back up this table.
Which option will ensure mysqldump will process a row at a time instead of buffering a set of rows?
- A. --quick
- B. --tab
- C. --single-transaction
- D. --skip-buffer
Answer: A
NEW QUESTION 79
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? (Choose two.)
- A. --lock-all-tables
- B. --single-transaction
- C. --master-data
- D. --skip-opt
- E. --create-apply-log
Answer: A,D
NEW QUESTION 80
Which are three facts about backups with mysqldump?
- A. are able to back up specific items within a database
- B. allow a consistent backup to be taken
- C. can back up a remote database server
- D. are always faster to restore than binary backups
- E. create automatically compressed backups
- F. will lock all storage engines for duration of backup
Answer: A,B,C
NEW QUESTION 81
Exhibit:
What does the possible_keys column in this output denote?
- A. if it is possible for you to include any indexes in your query
- B. if there are any indexes that may be used to solve this query
- C. whether there are any indexes in your query
- D. whether there are any indexes on the tables that you are querying
Answer: A
NEW QUESTION 82
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?
- A. SET GTID_EXECUTED="5da6b4f5-6f60-11e8-b2d6-0010e05f3e06:8";
- B. SET GTID_NEXT="5da6b4f5-6f60-11e8-b2d6-0010e05f3e06:8";
BEGIN; COMMIT;
SET GTID_NEXT="AUTOMATIC"; - C. SET GTID_NEXT="CONSISTENCY";
BEGIN; COMMIT;
SET GTID_NEXT="AUTOMATIC"; - D. SET GLOBAL enforce_gtid_consistency=ON
- E. SET GLOBAL SQL_SKIP_SLAVE_COUNTER=1
Answer: E
Explanation:
Reference: https://dev.mysql.com/doc/refman/8.0/en/replication-problems.html
NEW QUESTION 83
Group Replication uses global transaction identifiers to track executed transactions and are fundamental in avoiding transaction conflict. Which additional three steps help in avoiding conflicts in group replication?
(Choose three.)
- A. Set multiple slave parallel worker threads.
- B. Guarantee a primary key on every table.
- C. Guarantee a secondary index on every table.
- D. Use the binary log row format.
- E. Set isolation level to be READ COMMITTED.
- F. Configure IPv6 network for hosts.
- G. Set isolation level to be SERIALIZABLE.
Answer: B,D,G
NEW QUESTION 84
Which statement describes how the relay log works?
- A. When a slave receives a change from the master, it is recorded in the relay log first and processed later.
- B. when a slave receives a change from the master, it is processed first, and then recorded in the relay log.
- C. It stores changes on the master, and relays them to the slave.
- D. It maintains a record of available master binary logs and the current executed log position.
Answer: D
NEW QUESTION 85
Which three are key advantages of standard MySQL replication?
- A. supports native automatic failover
- B. provides arbitrary geographic redundancy with minimal overhead to master
- C. can easily add slaves for read scaling
- D. enables automatic resync of databases when discrepancies are detected
- E. synchronously guarantees identical slave copy
- F. is easy to configure and has low performance overhead
Answer: C,D,F
NEW QUESTION 86
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. Set the value of innodb_adaptive_hash_index to zero.
- B. Increase the value of the innodb_lock_wait_timeout option.
- C. Increase the value of the innodb_read_io_threads option.
- D. Increase the size of the InnoDB buffer pool.
- E. Change the table to use HASH indexes instead of BTREE indexes.
- F. Deactivate the query cache.
Answer: C,D
NEW QUESTION 87
An existing master-slave setup is currently using a delayed replication of one hour. The master has crashed and the slave must be "rolled forward" to provide all the latest data.
The SHOW SLAVE STATUS indicates these values:
* RELAY_LOG_FILE=hostname-relay-bin.00004
* RELAY_LOG_POS=1383
Which command set would make the slave current?
- A. STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; START SLAVE;
- B. STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; RELAY_LOG_FILE =
'hostname-relay-bin.00004', RELAY_LOG_POS = 1383; - C. STOP SLAVE; CHANGE MASTER TO RELAY_LOG_FILE =
'hostname-relay-bin.00004',RELAY_LOG_POS = 1383; - D. STOP SLAVE; SET GLOBAL master_delay=0; START SLAVE;
Answer: A
NEW QUESTION 88
Consider:
Which statement best describes the meaning of the value for the key_len column?
- A. It shows how many bytes will be used from each index row.
- B. It shows the total size of the index row.
- C. It shows how many columns in the index are examined.
- D. It shows the number of characters indexed in the key.
Answer: A
NEW QUESTION 89
You will configure a MySQL Server to act as a replication master. Which two options must be configured correctly to allow this? (Choose two.)
- A. master-logging
- B. server-id
- C. log-master-updates
- D. log_bin
- E. enable-master-start
- F. rpl-recovery-rank
Answer: B,D
Explanation:
Explanation/Reference: https://www.digitalocean.com/community/tutorials/how-to-set-up-master-slave-replication-in-mysql
NEW QUESTION 90
......
Certification Training for 1Z0-888 Exam Dumps Test Engine: https://www.vceengine.com/1Z0-888-vce-test-engine.html
