Get Latest [Oct-2021] Conduct effective penetration tests using PassLeaderVCE 1Z0-888
Penetration testers simulate 1Z0-888 exam PDF
NEW QUESTION 15
Which are three facts about backups with mysqldump? (Choose three.)
- 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 16
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 17
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 18
Consider the two partial outputs of the SHOW GLOBAL VARIABLES command from a master and slave server:
Master:
Slave:
There is a problem with the slave replicating from the master. Which statement describes the cause of the problem?
- A. The max_connections variable on the slave needs to be increased.
- B. The version of the slave is newer that the version of the master.
- C. The log_bin variable is set to OFF on the slave.
- D. server_id is not unique.
- E. The shared_memory_base_name variable must match the master.
Answer: C
NEW QUESTION 19
Which statement is true about tablespaces?
- A. All tablespace files must be in the directory specified by the --datadir option.
- B. General tablespaces can be configured to span multiple files.
- C. All tables must be in either the system tablespace or a general tablespace.
- D. The system tablespace can be configured to span multiple files.
Answer: C
NEW QUESTION 20
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 21
An administrator installs MySQL to run under a mysqlOS account. The administrator decides to disable logins to the mysqlaccount by using /nologinor /bin/falseas the user's shell setting.
Which statement is true?
- A. The mysqluser needs a login and its home directory must be the base directory of the installation.
- B. This prevents mysqldfrom starting when standard startup scripts are used.
- C. The OS needs to allow logging in as mysqlso that administrative tasks can be performed.
- D. This prevents creation of a command shell with the mysqlaccount, while allowing mysqldto run.
Answer: A
Explanation:
Explanation/Reference:
NEW QUESTION 22
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. The validate_passwordplug-in has not been loaded.
- B. validate_password_policycannot be set without restarting the MySQL instance.
- C. The dictionary file is an insecure location.
- D. The name of the dictionary file is too obvious.
- E. The dictionary file word list is too short.
- F. validate_password_dictionary_filecannot be set without restarting the MySQL instance.
Answer: C,D
NEW QUESTION 23
Which two statements are true regarding the creating of new MySQL physical and logical backups? (Choose two.)
- A. Physical backups are usually faster than text backups.
- B. Logical backups are human-readable whereas physical backups are not.
- C. Logical backups are always larger than physical backups.
- D. Physical backups are usually slower than text backups.
- E. Physical backups can be used to recover from data corruption.
Answer: A,E
NEW QUESTION 24
How does the InnoDB storage engine handle deadlocks when they are detected?
- A. One of the affected transactions will be rolled back, the other is allowed to proceed.
- B. The affected transactions wait for innodb_lock_wait_timeout seconds, and then roll back.
- C. The transaction isolation level determines which transaction is rolled back.
- D. Both the affected transactions will be rolled back.
- E. The innodb_locks_unsafe_for_binlog setting determines which transaction is rolled back.
Answer: A
Explanation:
Explanation/Reference:
Reference: https://dev.mysql.com/doc/refman/8.0/en/innodb-deadlocks.html
NEW QUESTION 25
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 all connect via the secure sha256_password algorithm without any configuration change.
- B. They are not affected by this configuration change.
- C. They will have to change their password the next time they login to the server.
- D. They will have their passwords updated on start-up to sha256_password format.
Answer: B
NEW QUESTION 26
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 STATUSindicates these values:
* RELAY_LOG_FILE=hostname-relay-bin.00004
* RELAY_LOG_POS=1383
Which command set would make the slave current?
STOP SLAVE; SET GLOBAL master_delay=0; START SLAVE;
- A. STOP SLAVE; CHANGE MASTER TO RELAY_LOG_FILE = 'hostname-relay-bin.00004',
- B. STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; RELAY_LOG_FILE = 'hostname-relay-
- C. RELAY_LOG_POS = 1383;
STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; START SLAVE; - D. bin.00004', RELAY_LOG_POS = 1383;
Answer: B
NEW QUESTION 27
When you examine a new MySQL installation with default configuration, you find a file called ibdata1 in the database directory. Which two statements are true about this file? (Choose two.)
- A. it is the default location for all new tables that you create.
- B. it contains the redo log.
- C. it contains the system tablespace.
- D. it contains the undo log.
- E. it contains a general tablespace.
- F. it contains the binary log.
Answer: A,C
NEW QUESTION 28
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 29
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_dictionary_file cannot be set without restarting the MySQL instance.
- B. The dictionary file is an insecure location.
- C. The name of the dictionary file is too obvious.
- D. The dictionary file word list is too short.
- E. validate_password_policy cannot be set without restarting the MySQL instance.
- F. The validate_password plug-in has not been loaded.
Answer: B,C
NEW QUESTION 30
Consider the key buffer in a MySQL server. Which two statements are true about this feature? (Choose two.)
- A. It caches index blocks for all storage engine tables.
- B. It caches index blocks for InnoDB tables only.
- C. It is a global buffer.
- D. It is set on a per-connection basis.
- E. It caches index blocks for MyISAM tables only.
Answer: D,E
Explanation:
Explanation/Reference: https://stackoverflow.com/questions/3663515/mysql-what-is-the-key-buffer
NEW QUESTION 31
After rebooting the host, you attempt to start the mysqld service. You get the following error:
Can't start the server: Bind on TCP/IP port: Address already in use
What is the most likely cause of this error?
- A. You failed to specify the port number 3306 to the command to start the server, so it is defaulting to port
80, which is in use by the built-in web server. - B. The /etc/hosts file does not have a valid IP entry for mysqld localhost, so it is binding to
127.0.0.1, which is already in use. - C. The mysql service has already been started on the same port.
- D. The network service process in the server is frozen, so all TCP/IP connections are paused and cannot be reused.
- E. The mysql.sock file in the MySQL /tmp directory was not removed after the reboot, so mysqld still thinks there is an active server running.
Answer: E
NEW QUESTION 32
Which two options describe how MySQL Server allocates memory? (Choose two.)
- 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 startup.
Answer: A,D
NEW QUESTION 33
What is the best method for monitoring Group Replication conflict resolution?
- A. the PERFORMANCE_SCHEMA tables
- B. the INNODB Lock Monitor details
- C. the INFORMATION_SCHEMA tables
- D. the SHOW PROCESSLIST command
- E. the SHOW STATUS command
Answer: A
Explanation:
Reference: https://dev.mysql.com/doc/refman/8.0/en/group-replication-monitoring.html
NEW QUESTION 34
You have installed MySQL Server for the first time on your system. However, the data directory along with the tables in the mysqlsystem database are missing. Which step do you perform to create the contents of the data directory?
- A. Run the mysql_unpack.sqlfile
- B. Run the create_system_tables.sqlfile
- C. Invoke mysqldwith the --initializeoption.
- D. Invoke mysqlwith the --initializeoption.
Answer: C
Explanation:
Explanation/Reference:
Reference: https://dev.mysql.com/doc/refman/5.7/en/data-directory-initialization-mysqld.html
NEW QUESTION 35
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.)
- A. Use the limit clause to limit the deletion to 100.000 rows.
- B. If the data modification is non-deterministic, the query optimizer will resolve any potential issues.
- C. Change the replication mode to mixed before issuing any delete statements when the limit clause is used.
- D. Use the limit clause in conjunction with the order 3Y clause.
Answer: C,D
NEW QUESTION 36
......
Tested Material Used To 1Z0-888 Test Engine: https://www.passleadervce.com/MySQL-Database-Administration/reliable-1Z0-888-exam-learning-guide.html
Steps Necessary To Pass The 1Z0-888 Exam: https://drive.google.com/open?id=1U-W6YG8vyaeQ0-dZolcnSqyM_MRS0VLP