Down To Date 1z0-888 Answers 2021

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

• A. mysql_config_editor is the only MySQL-provided utility that can print the values stored in.mylogin.cnf.
• B. A .mylogin.cnf file can store at most one login path.
• C. It provides a FIPS-compliant keyring for storing MySQL login details.
• D. A .mylogin.cnf file can be edited using a text editor, such as vim or Notepad++.
• E. It is an alternative to storing the MySQL login details in a my.cnf file.
• F. It provides means to help avoid accidentally exposing the MySQL login detail

Answer: EF

NEW QUESTION 2
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 3
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 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
You have a MySQL replication setup and you intentionally stop the SQL thread on the slave.

What are two reasons that you may stop the SQL thread on the slave while keeping the I/O thread running?

• A. to allow the remaining events to be processed on the slave while not receiving new events from the master
• B. to allow a backup to be created under reduced load
• C. to allow for point-in-time recovery on the slave
• D. to prevent schema changes from propagating to the slave before they are validated
• E. to prevent any transaction experiencing a deadlock

Answer: BC

NEW QUESTION 6
Which MySQL utility program should you use to process and sort the Slow Query Log based on query time or average query time?

• A. mysqldumpslow
• B. mysqldump
• C. mysqlaccess
• D. mysqlshow
• E. mysqlslow

Answer: A

NEW QUESTION 7
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. --tab
• B. --single-transaction
• C. --quick
• D. --skip-buffer

Answer: C

NEW QUESTION 8
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 9
Consider the key buffer in a MySQL server. Which two statements are true about this feature?

• A. It caches index blocks for MyISAM tables only.
• B. It caches index blocks for all storage engine tables.
• C. It is a global buffer.
• D. It is set on a per-connection basis.
• E. It caches index blocks for InnoDB tables onl

Answer: AD

NEW QUESTION 10
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. --lock-all-tables
• C. --create-apply-log
• D. --single-transaction
• E. --master-data

Answer: AB

NEW QUESTION 11
Host slave1 has ip address 192.0.2.10. Host slave2 has ip address 203.0.113.50 Examine these commands:

Why did this error occur?

• A. The host on the command line is not defined in the login path.
• B. The mysqld instance has not been restarted after creating the login path.
• C. There is no password defined in the login path.
• D. The DNS is not configured correctly for slave1 host.
• E. The .mylogin.cnf file is not readabl

Answer: E

NEW QUESTION 12
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 13
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 14
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. You would receive an error on the statement because you cannot update a different database that what is specified with the USE statement.
• B. The changes caused by the UPDATE statement are logged to the binary log because the instance is using --binlog-format = ROW
• C. The statement would fail because you cannot update more than one row at a time when using –binlogformat = ROW.
• D. 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.
• E. Nothing was written to the binary log because you cannot perform a calculation in a query without enclosing the statement in single quotation marks.

Answer: DE

NEW QUESTION 15
You have created a new user with this statement:
CREATE USER ‘erika’@’localhost’ IDENTIFIED BY ‘first#1Pass’ PASSWORDEXPIRE; What is the outcome?

• A. When ‘erika’@’localhost’ tries to log in with the MySQL command-line client, the user will have to change the password before seeing the mysql> prompt.
• B. When ‘erika’@’localhost’ tries to log in with the MySQL command-line client, the user will not be permitted to log in because the password is expired.
• C. When ‘erika’@’localhost’ tries to log in with the MySQL command-line client, the user will be permitted to log in but will not be able to issue ant statements until the user changes the password.
• D. You receive a syntax error that indicates that you cannot set a password and expire it at the same tim

Answer: A

NEW QUESTION 16
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 LOADFROM *.*
• B. setting the --local-service=0 option when starting mysqld
• C. executing REVOKEFILEFROM *_*
• D. executing REVOKEFILE ON *_* FROM ‘ ‘@’%’
• E. setting the --local-infile=0 option when starting mysqld
• F. setting the --open-files-limit=0 option when starting mysqld

Answer: F

NEW QUESTION 17
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 log_bin variable is set to OFF on the slave.
• B. server_id is not unique.
• C. The max_connections variable on the slave needs to be increased.
• D. The shared_memory_base_name variable must match the master.
• E. The version of the slave is newer that the version of the maste

Answer: A

NEW QUESTION 18
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 19
A crucial database, ‘db_prod’, just disappeared from your production MySQL instance.
In reviewing the available MySQL logs (General, Audit, or Slow) and your own application-level logs, you identified this command from a customer facing application:
SELECT id FROM users WHERE login=’payback!’;DROP DATABASE db_prod;’
Which three methods could have been used to prevent this SQL injection attack from happening?

• A. writing your client code to properly escape all user input
• B. giving limited privileges to accounts used by application servers to interact with their backing databases
• C. using SSL/TLS on your outward facing web servers (https://) to encrypt all user sessions
• D. using a hashing or encryption method to secure all user passwords in your MySQL tables
• E. removing any remaining anonymous accounts from your MySQL instance
• F. validating all user input before sending it to the database server
• G. changing all passwords for the MySQL account ‘root’@’%’ immediately after losing an employee who knew the current password

Answer: DEG

NEW QUESTION 20
Consider the join_buffer_size parameter in MySQL Server. Which two statements are true about the join buffer?

• A. The value should be increased if the client performs several SELECT operations.
• B. The join buffer is set per connection.
• C. The join buffer is used to process sorts when complex joins are being performed.
• D. The value should be increased from the default if the query joins large rows without using an index.
• E. The join buffer is global and can be changed only by restarting the serve

Answer: CD

NEW QUESTION 21
Which three statements correctly describe MySQL InnoDBCluster?

• A. The cluster can be operated in multimaster mode with conflict detection for DML statements.
• B. All MySQL client programs and connectors can be used for executing queries.
• C. It provides fully synchronous replication between the nodes.
• D. There is support for automatic failover when one node fails.
• E. The data is automatically shared between the nodes.
• F. Each query will be executed in parallel across the node

Answer: BDF

NEW QUESTION 22
......