Refresh 1z0-888 Pdf 2021

NEW QUESTION 1
To satisfy a security requirement, you have created or altered some user accounts to include REQUIRE X509.
Which additional task needs to be performed for those user accounts to fulfill the requirement to use X509?

• A. Install the X509 plug-in on the server.
• B. Set the X509 option in the [client] section of the MySQL server’s configuration file.
• C. Restart the server with the --require-x509 option.
• D. Distribute client digital certificates to the client computers being used to log in by the user accounts.
• E. Provide users access to the server’s private ke

Answer: B

NEW QUESTION 2
You will configure a MySQL Server to act as a replication master. Which two options must be configured correctly to allow this?

• A. log-master-updates
• B. rpl-recovery-rank
• C. server-id
• D. enable-master-start
• E. log_bin
• F. master-logging

Answer: CE

NEW QUESTION 3
Examine the mysqldumpslow output:

Which two options could explain the slow query?

• A. There is network congestion between client and server.
• B. No index has been defined on the filtered column.
• C. There are 108 queries still being executed.
• D. A table lock is causing delays.
• E. A full table scan is being use

Answer: AE

NEW QUESTION 4
How does the InnoDB storage engine handle deadlocks when they are detected?

• A. Both the affected transactions will be rolled back.
• B. The affected transactions wait for innodb_lock_wait_timeout seconds, and then roll back.
• C. One of the affected transactions will be rolled back, the other is allowed to proceed.
• D. The transaction isolation level determines which transaction is rolled back.
• E. The innodb_locks_unsafe_for_binlog setting determines which transaction is rolled bac

Answer: C

NEW QUESTION 5
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. whether there are any indexes on the tables that you are querying
• C. if there are any indexes that may be used to solve this query
• D. whether there are any indexes in your query

Answer: A

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

• A. a backup created with mysqldump --all-databases
• B. a backup created using FLUSH TABLES … FOR EXPORT
• C. an up-to-date replication slave
• D. a file system-level snapshot
• E. a file system copy created while MySQL was shut dow

Answer: AD

NEW QUESTION 7
You are contacted by a user who does not have permission to access a database table. You determine after investigation that this user should be permitted to have access and so you execute a GRANT statement to enable the user to access the table.
Which statement describes the activation of that access for the user?

• A. The access does not take effect until the user logs out and back in.
• B. The access does not take effect until the next time the server is started.
• C. The access is available immediately.
• D. The access does not take effect until you issue the FLUSH PRIVILEGES statemen

Answer: C

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

• A. it contains the binary log.
• B. it contains a general tablespace.
• C. it is the default location for all new tables that you create.
• D. it contains the system tablespace.
• E. it contains the redo log.
• F. it contains the undo lo

Answer: CD

NEW QUESTION 9
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 10
Which two statements are true regarding the creating of new MySQL physical and logical backups?

• A. Physical backups can be used to recover from data corruption.
• 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 are usually faster than text backup

Answer: AE

NEW QUESTION 11
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 12
You are using the Performance Schema to investigate replication on a slave which has a single master. The option slave- parallel-type is set to DATABASE.

Assume that all instruments and consumers are enabled and all threads are instrumented. Which two facts can be concluded from the given output?

• A. The salve has two intermediate relay slaves connected to it.
• B. The slave is configured with slave_parallel_workers = 4
• C. At most, two schemas are being updates concurrently.
• D. THREAD_ID 21 has stopped running.
• E. The slave cannot process the relay log fast enough to use all threads.
• F. The server needs more cores to use all slave thread

Answer: BE

NEW QUESTION 13
Examine the mydata table and SELECT statements:

You issue: mysql> begin;
mysql> update mydata set a=0 where b=3;
How many rows are now protected by locks with the default InnoDB configuration?

• A. one
• B. one row and a next-key lock for supremum
• C. one row and a gap-lock
• D. five

Answer: D

NEW QUESTION 14
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 15
What is the order of tables shown in an EXPLAIN output?

• A. It lists tables from the smallest to the largest.
• B. It lists tables in the order in which their data will be read.
• C. It lists tables from the most optimized to the least optimized.
• D. It lists tables in the order in which they are specified in the statement that is being explaine

Answer: D

NEW QUESTION 16
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 17
You want to create a temporary table named OLD_INVENTORY in the OLD_INVENTORY database on the master server. This table is not to be replicated to the slave server.
Which two changes would ensure that the temporary table does not propagate to the slave?

• A. Set binlog_format=MIXED with the --replicate-ignore-temp-table option.
• B. Use the --replicate-do-db, --replicate-do-table, or --replicate-wild-do-table option with the value equal to OLD_INVENTORY.
• C. Change the binlog_format option to ROW and restart mysqld before you create the OLD_INVENTORY table.
• D. Stop SQL_THREAD on the slave until you have finished using the OLD_INVENTORY temporary table.
• E. Use the --replicate-ignore-table option with the value equal to OLD_INVENTORY.OLD_INVENTORY and restart mysqld before creating the temporary table.

Answer: BE

NEW QUESTION 18
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 19
Which two statements are true about InnoDB auto-increment locking?

• A. InnoDB never uses table_level locks.
• B. InnoDB always protects auto-increment updates with a table-level lock
• C. InnoDB does not use locks to enforce auto-increment uniqueness.
• D. The auto-increment lock can be a table-level lock.
• E. Some settings for innodb_autoinc_lock_mode can help reduce lockin

Answer: DE

NEW QUESTION 20
A particular government’s security policy is to have very strict data encryption and safety settings. This is done by restricting access based on their own CA authority and limiting access to particular users within a department. Which method could be used to restrict access as required?

• A. using GRANT … REQUIRE X509 AND REQUIRE ISSUER ‘/C=…..’ AND REQUIRE SUBJECT ‘/C=…..’
• B. using GRANT USAGE, X509, …….ON *.* TO user@remotehost IDENTIFIED BY ‘secret_password’
• C. using GRANT … REQUIRE SSL for a secure connection
• D. using GRANT USAGE, SSL, …..ON *.* TO user@remotehost IDENTIFIED BY ‘secret_password’

Answer: A

NEW QUESTION 21
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. The mysql service has already been started on the same port.
• B. The network service process in the server is frozen, so all TCP/IP connections are paused and cannot be reused.
• C. 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.
• D. 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.
• 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 22
Which are three facts about backups with mysqldump?

• A. will lock all storage engines for duration of backup
• B. can back up a remote database server
• C. allow a consistent backup to be taken
• D. are able to back up specific items within a database
• E. create automatically compressed backups
• F. are always faster to restore than binary backups

Answer: BCD

NEW QUESTION 23
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 24
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 25
......