[Q58-Q80] Certification Training for 1Z0-888 Exam Dumps Test Engine [2021]

Certification Training for 1Z0-888 Exam Dumps Test Engine [2021]

Sep 12, 2021 Step by Step Guide to Prepare for 1Z0-888 Exam

NEW QUESTION 58
Which three allocate memory per thread in MySQL? (Choose three.)

• A. sort buffer
• B. internal temporary table
• C. thread cache
• D. read buffer
• E. InnoDB buffer pool instance
• F. query cache

Answer: A,D,E

 

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

• 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:
Reference: https://www.digitalocean.com/community/tutorials/how-to-set-up-master-slave- replication-in-mysql

 

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

Answer: B,E

 

NEW QUESTION 61
What are three methods to reduce MySQL server exposure to remote connections?
(Choose three.)

• A. using the sql_mode=STRlCT_SECURE after connections are established for encrypted communications
• B. using SSL when transporting data over remote networks
• C. setting specific grant privileges to limit remote authentication
• D. setting -mysql_secure_configuration to enable paranoid mode
• E. setting -skip-networking when remote connections are not required

Answer: B,C,E

 

NEW QUESTION 62
Which statement best describes the purpose of the InnoDB buffer pool?

• A. It is amount of buffers available during a transaction.
• B. It caches data and indexes for InnoDB tables.
• C. It is a pool of memory for SQL query sort operations from within the InnoDB engine.
• D. It caches only the indexes for InnoDB tables.
• E. It holds changes made during a transaction before they are written to the log.

Answer: B

Explanation:
Reference: https://dev.mysql.com/doc/refman/5.7/en/innodb-buffer-pool-optimization.html

 

NEW QUESTION 63
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 64
Consider the table people with this definition:

The application uses a query such as:
SELECT * FROM people WHERE YEAR(Birthday) = 1980;
The query is not using an index.
Which two methods can be used to allow the query to use an index? (Choose two.)

• A. Execute ANALYZE TABLE to update the index statistics.
• B. Add a functional index for YEAR(Birthday).
• C. Add FORCE INDEX (Birthday) to the query.
• D. Change the WHERE clause to Birthday BETWEEN 1980-01-01 AND 1980-12-31.
• E. Add a generated column calculating YEAR(Birthday) and index that column.

Answer: C,D

 

NEW QUESTION 65
Which storage option for MySQL data directory typically offers the worst performance in a highly concurrent, OLTP-heavy, IO-bound workload?

• A. iSCSI Lun
• B. NFS (Networked File System) mount
• C. battery-backed locally-attached RAID 5 array
• D. SAN (Fibre Channel) Lun

Answer: C

 

NEW QUESTION 66
Which two are considered good security practices when using passwords? (Choose two.)

• A. Do not use dictionary-based words.
• B. Use one-way encryption for storage of passwords.
• C. Store passwords external to the database.
• D. Choose short passwords to save on storage space.
• E. Use simple keyboard actions that give mixed letters.

Answer: A,B

Explanation:
Reference: https://stackoverflow.com/questions/14798275/best-way-to-store-passwords-in- mysql-database

 

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

Answer: A,B

 

NEW QUESTION 69
Which two statements are true regarding the creating of new MySQL physical and logical backups?

• 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 70
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 RELAY_LOG_FILE = 'hostname-relay-
  bin.00004',
  RELAY_LOG_POS = 1383;
• B. STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; START SLAVE;
• C. STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; RELAY_LOG_FILE
  'hostname-relay-bin.00004', RELAY_LOG_POS = 1383;
• D. STOP SLAVE; SET GLOBAL master_delay=0; START SLAVE;

Answer: B

 

NEW QUESTION 71
Suppose you are adding rows to a MyISAM table and the --datadirlocation runs out of disk space.
What will happen when this occurs?

• A. The server suspends that INSERT operation until space becomes available.
• B. An error message will be returned to the client .Server Error: ER_IO
• C. The server suspends operations for all storage engines until space becomes available.
• D. The server will crash.

Answer: A

 

NEW QUESTION 72
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. Remove all of the binary log files that have a modification date earlier than today.
• B. Execute the PURGE BINARY LOGS NOT USEDcommand.
• C. Edit the .indexfile to remove the files you want to delete.
• D. Ensure that none of the attached slaves are using any of the binary logs you want to delete.
• E. Use the command PURGE BINARY LOGSand specify a binary log file name or a date and time to remove unused files.

Answer: D,E

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 73
What are three methods to reduce MySQL server exposure to remote connections? (Choose three.)

• A. using SSL when transporting data over remote networks
• B. setting --mysql_secure_configuration to enable paranoid mode
• C. setting specific GRANT privileges to limit remote authentication
• D. setting --skip-networking when remote connections are not required
• E. using the sql_mode=STRICT_SECURE after connections are established for encrypted communications

Answer: A,C,D

 

NEW QUESTION 74
You are receiving complaints from your application administrators that they are seeing periodic stalls in database response (no queries to any table are returning results for several seconds or longer). You monitor your system and notice that the durations of those stalls correspond to peaks in disk I/O.
Which 2 things should you investigate?

• A. Check the rate of change in the status value Aborted_connects and compare to the rate of change in Connections.
• B. Check the difference between the InooDB status values "Trx id counter" and "Purge done for" and compare to the state substatus of the main "Main thread"
• C. Check the rate of change in the statis value Qcache_hits and compare that to the rate of change of Qcache_not_cached.
• D. Check the difference between the InnoDB status values "Log Sequence number" and "Last Checkpoint" positions then compare that to the total size of the redo log.
• E. Check the rate of change in the status value Select_scan and compare to the rate of change in Com_select.

Answer: C,D

 

NEW QUESTION 75
Which three statements correctly describe MySQL InnoDB Cluster?

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

Answer: C,D,F

 

NEW QUESTION 76
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 USAGE, SSL, .....ON *.* TO user@remotehost IDENTIFIED BY
  'secret_password'
• B. using GRANT ... REQUIRE SSL for a secure connection
• C. using GRANT ... REQUIRE X509 AND REQUIRE ISSUER '/C=.....' AND REQUIRE SUBJECT '/C=...
  ..'
• D. using GRANT USAGE, X509, .......ON *.* TO user@remotehost IDENTIFIED BY
  'secret_password'

Answer: C

 

NEW QUESTION 77
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 78
You have a config file for a running DB with this excerpt:
[mysqld]
tmp_table_size=16M
sort_buffer_size=256k
To address a query performance problem of connecting to the DB from an application on another host, you log in and make these changes to the DB:
mysql> SET GLOBAL tmp_table_size=32000000;
mysql> SET sort_buffer_size=2000000;
This solves the problem with your queries. However, later the DB instance is restarted and the performance problem returns.
Which three best describe this scenario?

• A. sort_buffer_size should match tmp_table_size to be optimal.
• B. Global variables are not persistent across server restarts.
• C. Session variables are not persistent across server restarts.
• D. The query benefited from sort_buffer_size and tmp_table_size increases.
• E. The query benefited from sort_buffer_size increase.
• F. The query benefited from tmp_table_size increase.

Answer: C,E,F

 

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

• 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:
Reference: https://www.digitalocean.com/community/tutorials/how-to-set-up-master-slave-replication-in- mysql

 

NEW QUESTION 80
......

Ultimate Guide to Prepare 1Z0-888 Certification Exam for MySQL Database Administration: https://www.prep4king.com/1Z0-888-exam-prep-material.html

MySQL Database Administration 1Z0-888 Real Exam Questions and Answers FREE Updated: https://drive.google.com/open?id=19s0R_gN75EVG6BZeh2mFCTXd1T0yO-pD