You are asked to examine user accounts and find:

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

• A.ALTER USER bob@'%' IDENTIFIED BY 'secret_password';
• B.DROP USER ''@'localhost';
• C.ALTER USER 'root'@'localhost' ACCOUNT LOCK;
• D.ALTER USER bob PASSWORD = 'secret_password';
• E.REVOKE ALL PRIVILEGES FROM ''@'localhost';
• F.ALTER USER ''@'localhost' PASSWORD = 'secret_password';

Comment: *

Name: *

Email: *

Verification: *

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.log_bin=mysql -binInnodb_flush_log_at_trx_commit=1
• B.max_heap_table_size = 2Gtmp_table_size=2G
• C.sync_binlog=10
• D.innodb_buffer_pool_instances=64innodb_buffer_pool_size=200G
• E.query_cache_size = 2Gquery_cache_enabled=1
• F.table_open_cache = 64
• G.innodb_flush_log_at_trx_commit=0
• H.innodb_flush_method=O_DIRECT

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *

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

Comment: *

Name: *

Email: *

Verification: *

You are investigating the performance of a query which selects data from an InnoDB table.
Consider this Performance Schema diagnostics output for the query:

Which statement is true about the output?

• A.The query did not find its table in the table definition cache.
• B.The query read data from the data file rather than directly from the buffer pool.
• C.The event with event_id = 8945is a child of the event with event_id=8944.
• D.The time the query took is the sum of all timer_waitvalues.

Comment: *

Name: *

Email: *

Verification: *