First Attempt Guaranteed Success in 1Z1-888 Exam 2022 [Q12-Q36]

Rate this post

First Attempt Guaranteed Success in 1Z1-888 Exam 2022

Real 1Z1-888 Exam Questions are the Best Preparation Material

NO.12 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?

The host on the command line is not defined in the login path.

The mysqld instance has not been restarted after creating the login path.

There is no password defined in the login path.

The DNS is not configured correctly for slave1 host.

The .mylogin.cnf file is not readable.

NO.13 Why should you be selective when granting the PROCESS privilege to an account?

It allows a client to process scripts.

It allows the use of stored routines.

It allows a client to see another user’s queries with the SHOW PROCESSLIST command.

It allows a client to control running processes on a server.

NO.14 Consider the key buffer in a MySQL server. Which two statements are true about this feature?

It caches index blocks for MyISAM tables only.

It caches index blocks for all storage engine tables.

It is a global buffer.

It is set on a per-connection basis.

It caches index blocks for InnoDB tables only.

NO.15 These details are shown when logged in to an account:

Which set of statements would match the accounts shown?

mysql> CREATE USER `employee’@’localhost’ IDENTIFIED BY `more_secrets’; mysql> CREATE USER ”@” IDENTIFIED BY `valid_password’ WITH PROXY `employee’@’localhost’;

mysql> CREATE USER `employee’@’localhost’ IDENTIFIED BY `more_secrets’; mysql> GRANT PROXY ON `employee’@’localhost’ TO `robert’@’localhost’;

mysql> CREATE USER `robert’@’localhost’ IDENTIFIED BY `secret_password’; mysql>CREATE USER `employee’@’localhost’ IDENTIFIED BY `more_secrets’;

mysql> CREATE_USER ”@” IDENTIFIED WITH authentication_pam ACCOUNT LOCK; mysql> CREATE USER `employee’@’localhost’ IDENTIFIED BY `more_secrets’; mysql> GRANT PROXY ON
`employee’@’localhost’ TO ”@”;

NO.16 A simple master-to-slave replication is currently being used. This information is extracted from the SHOW SLAVE STATUSoutput:

You execute a ‘SHOW CREATE TABLE mytable” on the slave:

The table mytable on the slave contains:

You have issued a STOP SLAVEcommand. 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 SLAVEcommand to resolve the duplicate key error. Which statement should be used?

SET GTID_NEXT=”CONSISTENCY”;
BEGIN; COMMIT;
SET GTID_NEXT=”AUTOMATIC”;

SET GTID_NEXT=”5da6b4f5-6f60-11e8-b2d6-0010e05f3e06:8″;
BEGIN; COMMIT;
SET GTID_NEXT=”AUTOMATIC”;

SET GLOBAL SQL_SKIP_SLAVE_COUNTER=1

SET GLOBAL enforce_gtid_consistency=ON

SET GTID_EXECUTED=”5da6b4f5-6f60-11e8-b2d6-0010e05f3e06:8″;

NO.17 There are multiple instances of MySQL Server running on a single OS that is backed up using the mysqlbackup command.
The /etc/my/cnf contains default values, for example, datadir=/var/lib/mysql/, with extra instances having their own separate my.cnf file (for example /etc/mysql/instanceN.cnf) overriding the defaults.
A restore of the second instance is attempted from the mysqlbackup archive using this command:
mysqlbackup –backup-dir=/opt/backup/mysql/instance2 copy-back
Upon starting the second MySQL instance, you notice that the data does not match the expected backup. Which command-line option is required to successfully update the second instance?

–restore=2

–copy-back-from-log

–backup-instance=/var/lib/mysql/instance2

–instance=/var/lib/mysql/instance2

–defaults-file=/etc/mysql/instance2.cnf

NO.18 Which two options describe how MySQL Server allocates memory? (Choose two.)

Each connection may have its own per-thread memory allocations.

Thread memory is pre-allocated up to thread_cache_size for performance.

Each thread allocates memory from a global pool.

Global memory resources are allocated at server startup.

NO.19 Which two statements can be used to adjust the sort_buffer_size variable on a running MySQL server?
(Choose two.)

mysql> SET GLOBAL sort_buffer_size=256000;

mysql> SET SESSION sort_buffer_size=256000;

mysql> CONF T; do global sort_buffer_size=256000;

mysql> system sort_buffer_size=256000;

mysql> SET VARIABLE sort_buffer_size=256000;

NO.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?

using GRANT … REQUIRE X509 AND REQUIRE ISSUER ‘/C=…..’ AND REQUIRE SUBJECT
‘/C=…
..’

using GRANT USAGE, X509, …….ON *.* TO user@remotehost IDENTIFIED BY
‘secret_password’

using GRANT … REQUIRE SSL for a secure connection

using GRANT USAGE, SSL, …..ON *.* TO user@remotehost IDENTIFIED BY
‘secret_password’

NO.21 After analysis on the slow query log on a high-end OLTP service, the table identified in the slow queries is:

What are the two most likely reasons for the slowness given this output? (Choose two.)

Dateshould be a TIMESTAMPfield for better performance.

The User field is too long for most names.

The engine type is not appropriate to the application use.

Using default values for DATETIMEcauses table scans.

No indexes are defined.

NO.22 You are asked to examine user accounts and find:

Which two statements will best secure this environment? (Choose two.)

DROP USER ”@’localhost’;

ALTER USER ”@’localhost’ PASSWORD = ‘secret_password’;

ALTER USER bob@’%’ IDENTIFIED BY ‘secret_password’;

LTER USER ‘root’@’localhost’ ACCOUNT LOCK;

ALTER USER bob PASSWORD = ‘secret_password’;

REVOKE ALL PRIVILEGES FROM ”@’localhost’;

NO.23 Consider the key buffer in a MySQL server. Which two statements are true about this feature?

It caches index blocks for MyISAM tables only.

It caches index blocks for all storage engine tables.

It is a global buffer.

It is set on a per-connection basis.

It caches index blocks for InnoDB tables only.

NO.24 You inherited a busy InnoDB OLTP Instance with 100 schemas and 100 active users per schema.
Total dataset size is 200G with an average schema size of 2G.
The data is transient and is not backed up and can be repopulated easily.
Performance and responsiveness of the DB is paramount.
The query pattern for the DB instance is split 90/10 read/write.
DB host is dedicated server with 256G RAM and 64 cores.
One of your colleagues made some recent changes to the system and users are now complaining of performance impacts.
Which four configuration file edits might your colleague have performed to cause the negative DB performance? (Choose four.)

table_open_cache = 64

innodb_buffer_pool_instances=64innodb_buffer_pool_size=200G

log_bin=mysql -binInnodb_flush_log_at_trx_commit=1

sync_binlog=10

innodb_flush_method=O_DIRECT

max_heap_table_size = 2Gtmp_table_size=2G

query_cache_size = 2Gquery_cache_enabled=1

innodb_flush_log_at_trx_commit=0

NO.25 You have successfully provisioned the latest MySQL 5.7 database instance on a physical host, to be added to an existing farm for use in a modern, high volume, ACID-compliant, OLTP website, which serves hundreds of DML transactions per second.
The default values of which two key variables do you change to ensure seamless operation of the database? (Choose two.)

Key Buffer Size

InnoDB Redo Log Size

Binary Log Size

Buffer Pool Size

Sort Buffer size

Query Cache Size

NO.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;

STOP SLAVE; CHANGE MASTER TO RELAY_LOG_FILE = ‘hostname-relay-bin.00004’, RELAY_LOG_POS = 1383;

STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; START SLAVE;

STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; RELAY_LOG_FILE = ‘hostname- relay-bin.00004’, RELAY_LOG_POS = 1383;

NO.27 You inherited a busy InnoDB OLTP Instance with 100 schemas and 100 active users per schema.
Total dataset size is 200G with an average schema size of 2G.

The data is transient and is not backed up and can be repopulated easily.

Performance and responsiveness of the DB is paramount.

The query pattern for the DB instance is split 90/10 read/write.

DB host is dedicated server with 256G RAM and 64 cores.

One of your colleagues made some recent changes to the system and users are now complaining of performance impacts.
Which four configuration file edits might your colleague have performed to cause the negative DB performance?

table_open_cache = 64

innodb_buffer_pool_instances=64
innodb_buffer_pool_size=200G

log_bin=mysql -bin
Innodb_flush_log_at_trx_commit=1

sync_binlog=10

innodb_flush_method=O_DIRECT

max_heap_table_size = 2G
tmp_table_size=2G

query_cache_size = 2G
query_cache_enabled=1

innodb_flush_log_at_trx_commit=0

NO.28 Which MySQL utility copies the master instance to a slave instance on the same host?

mysqlfailover

mysqldbcopy

mysqlrplsync

mysqlserverclone

NO.29 Which three allocate memory per thread in MySQL?

query cache

thread cache

read buffer

internal temporary table

sort buffer

InnoDB buffer pool instance

NO.30 Which MySQL utility program should you use to process and sort the Slow Query Log based on query time or average query time?

mysqldumpslow

mysqldump

mysqlaccess

mysqlshow

mysqlslow

NO.31 The /myfolder/my.cnffile has option set:
[mysqld]
skip-log-bin
myfolder2/my.cnfhas this option set:
/
[ mysqld]
log-bin = /valid/path/to/mysqlbinlog
All mentioned paths are accessible to the account that you are currently using. Assume that any other options mentioned in either file are valid and legal option definitions.
You start an instance by using this command line:
mysqld –defaults-file=/myfolder/my.cnf –defaults-extra-file=/myfolder2/my.cnf What is the outcome?

MySQL starts and Binary Logging is enabled.

MySQL fails to start due to the conflicting options in the configuration files.

MySQL fails to start due to conflicting options on the command line.

MySQL starts but Binary Logging is disabled.

NO.32 A master-slave replication setup has the slave showing this error:

On the master server, the binary logs show:

What could explain this error? (Choose two.)

binlog_cache_size=1024 is too small and transactions are lost.

binlog_format=STATEMENT and a non-deterministic query was executed.

enforce_gtid_consistency=ON and consistency is broken between the master and the slave.

The sync_relay_log=1000 setting on the slave is too small.

sync_binlog=0 and the master server crashed.

NO.33 You have installed MySQL Server for the first time on your system. However, the data directory along with the tables in the mysql system database are missing. Which step do you perform to create the contents of the data directory?

Run the create_system_tables.sql file

Run the mysql_unpack.sql file

Invoke mysqld with the –initialize option.

Invoke mysql with the –initialize option.

NO.34 Due to an authentication plug-in that is used on the server, passwords are required to be sent as clear text as opposed to the usual encrypted format.
Which two methods would allow the mysqlclient to connect to the server and send clear text passwords?

mysql –protocol=PLAIN -uroot -p -h dbhost.example.com

INSTALL PLUGIN mysql_cleartext_password SONAME
‘mysql_cleartext_password.so’;

export LIBMYSQL_ENABLE_CLEARTEXT_PLUGIN=’Y’

SET GLOBAL mysql_cleartext_passwords=1;

mysql –enable-cleartext-plugin -uroot -p -h dbhost.example.com

NO.35 There are multiple instances of MySQL Server running on a single OS that is backed up using the mysqlbackupcommand.
The /etc/my/cnf contains default values, for example, datadir=/var/lib/mysql/,with extra instances having their own separate my.cnffile (for example /etc/mysql/instanceN.cnf) overriding the defaults.
A restore of the second instance is attempted from the mysqlbackup archive using this command:
mysqlbackup –backup-dir=/opt/backup/mysql/instance2 copy-back
Upon starting the second MySQL instance, you notice that the data does not match the expected backup.
Which command-line option is required to successfully update the second instance?

–restore=2

–copy-back-from-log

–backup-instance=/var/lib/mysql/instance2

–instance=/var/lib/mysql/instance2

–defaults-file=/etc/mysql/instance2.cnf

NO.36 You have installed the validate_password plug-in and set the validate_password_policy variable.
Which validation is affected by the validate_password_policy setting?

whether a new password is rejected if it contains a word found in a dictionary file.

whether a new password is rejected if it contains the current user’s username.

the amount of delay after an incorrect password is entered

the length of time before a newly created password expires

Practice LATEST 1Z1-888 Exam Updated 155 Questions: https://www.dumpstorrent.com/1Z1-888-exam-dumps-torrent.html

First Attempt Guaranteed Success in 1Z1-888 Exam 2022 [Q12-Q36]

admin

Leave a Reply Cancel reply