Online Access Free 1Z0-888 Practice Test

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.)

• A.max_heap_table_size = 2G
  tmp_table_size=2G
• B.Innodb_flush_log_at_trx_commit=1
• C.innodb_flush_method=O_DIRECT
• D.query_cache_size = 2G
  query_cache_enabled=1
• E.sync_binlog=10
• F.innodb_buffer_pool_size=200G
  log_bin=mysql -bin
• G.innodb_flush_log_at_trx_commit=0
• H.table_open_cache = 64
  innodb_buffer_pool_instances=64

You have a consistent InnoDB backup created with mysqldump, the largest table is 50 GB in size.
You start to restore your backup with this command;
shell> mysql -u root -p < backup.sql
After 30 minutes, you notice that the rate of restore seems to have slowed down. No other processes or external factors are affecting server performance.
Which is the most likely explanation for this slowdown?

• A.InnoDB has filled the redo log and now must flush the pages.
• B.The MySQL server is taking a periodical snapshot of data so it can resume the restore if it is interrupted mid-way.
• C.Secondary indexes no longer fit into the buffer pool.
• D.InnoDB is doing CRC32 checks over the tablespace data as it grows.
• E.The MySQL server has stopped inserting data to check index consistency.

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 .mylogin.cnf file is not readable.
• C.The DNS is not configured correctly for slave1 host.
• D.There is no password defined in the login path.
• E.The mysqld instance has not been restarted after creating the login path.

You have forgotten the root user account password. You decide to reset the password and execute:

Which additional argument makes this operation safer?

• A.-reset-grant-tables, to start the server with only the mysql database accessible.
• B.-read-only, to set all data to read-only except for super users
• C.-skip-networking, to prohibit access from remote locations
• D.-old-passwords, to start MySQL to use the old password format while running without the grant tables.

You are no longer able to log in to an existing MySQL Server because the root password credentials not working. You need to reset the root password to complete various administrative tasks. What are the two major methods that will achieve this?

• A.Start the MySQL Server with --init-file pointing to SQL that executes an ALTER USER statement to change the root user password.
• B.Start the MySQL Server with --initialize-insecure to force a password reset procedure on the command line.
• C.Start the MySQL Server with --skip-grant-tables and execute SQL, which will update the root password.
• D.Start the MySQL Server with reset-root-password in my.cnf, which will prompt you to enter a new root user password.
• E.Start the MySQL Server in --safe-mode, which only loads the privilege system for changes as data is inaccessible.