A valid raw backup of the shop.customers MyISAM table was taken.
You must restore the table. You begin with these steps:
1.Confirm that secure_file_priv='/var/tmp'
2.mysql> DROP TABLE shop.customers;
3.shell> cp /backup/customers.MY* /var/lib/mysql/shop/
Which two actions are required to complete the restore? (Choose two.)
A. shell> cp /backup/customers.sdi /var/tmp
B. shell> cp /backup/customers.sdi /var/lib/mysql/shop/
C. mysql> SOURCE `/var/tmp/customers.sdi'
D. mysql> IMPORT TABLE FROM /var/tmp/customers.sdi
E. shell> cp /backup/customers.frm /var/lib/mysql/shop/
F. mysql> IMPORT TABLE FROM /var/lib/mysql/shop/customers.sdi
G. mysql> ALTER TABLE shop.customers IMPORT TABLESPACE
H. mysql> ALTER TABLE shop.customers DISCARD TABLESPACE
Your my.cnf file contains these settings:
You want to log queries that looked at a minimum of 5000 records and either took longer than 5 seconds to run or did not use indexes.
Which contains all the settings that you need to add to or modify the slow log configuration?
A. min_examined_row_limit=5000
B. long_query_time=5 log_throttle_queries_not_using_indexes=5
C. log_throttle_queries_not_using_indexes=5 min_examined_ row_limit=5000
D. long_query_time=5
E. long_query_time=5 min_examined_row_limit=5000
F. log_throttle_queries_not_using_indexes=5
G. long_query_time=5 log_throttle_queries_not_using_indexes=5 min_examined_row_limit=5000
Examine these statements and output:
Which statement is true?
A. The user is logged in with --user=accounting as an option.
B. The user is authenticated as the anonymous proxy user `'@'%'.
C. The user is authorized as the accounting@localhost user.
D. The user is authorized as the rsmith@localhost user.
E. The user failed to define a username and the connecting username defaulted to `'@'%'.
Which statement is true about displaying and retrieving data with MySQL Enterprise Monitor Query Analyzer?
A. The Query Analyzer graph view range selector can extend to cover the same hour over multiple days.
B. It is possible to filter a Query Analyzer view graph by database and by table.
C. The Query Analyzer can plot a CPU utilization graph for remote hosts with a MySQL Enterprise Service Manager's built-in Agent installation.
D. It is possible to export statements included in a graph selection in CSV format.
Your MySQL instance is capturing a huge amount of financial transactions every day in the finance database.
Company policy is to create a backup every day.
The main tables being updated are prefixed with transactions-.
These tables are archived into tables that are prefixed with archives- each month. mysqlbackup --optimistic-busy-tables="^finance\.transactions-.*" backup
Which optimization process best describes what happens with the redo logs?
A. The redo logs are backed up first, then the transaction and archive tables.
B. The redo logs are backed up only if there are changes showing for the transactions tables.
C. The redo logs are not backed up at all.
D. The archive tables are backed up first, then the transaction tables and redo logs.
E. The transaction tables are backed up first, then the archive tables and redo logs.
You plan to install MySQL Server by using the RPM download. Which two statements are true? (Choose two.)
A. You can provide the root password interactively.
B. You must manually initialize the data directory.
C. The MySQL RPM package installation supports deploying multiple MySQL versions on the same host.
D. MySQL uses the RPM relocatable installation target feature.
E. The functionality is split among several RPM package files.
F. You can find the root password in the error log after the first start.
Which three are types of InnoDB tablespaces? (Choose three.)
A. redo tablespaces
B. encryption tablespaces
C. schema tablespaces
D. data tablespaces
E. undo tablespaces
F. temporary table tablespaces
Which statement is true about InnoDB persistent index statistics?
A. Updating index statistics is an I/O expensive operation.
B. Index statistics are calculated from pages buffered in the buffer pool for tables with InnoDB storage engine.
C. Setting innodb_stats_auto_recalc=ON causes statistics to be updated automatically when a new index is created.
D. Execution plans based on transient index statistics improve precision when innodb_stats_persistent_sample_pages is increased.
E. Increasing innodb_stats_persistent_sample_pages determines higher pages scanning speed, at the cost of increased memory usage.
You want to dump all databases with names that start with "db".
Which command will achieve this?
A. mysqlpump --include-tables=db.% --result-file=all_db_backup.sql
B. mysqlpump > all_db_backup.sql
C. mysqlpump --include-databases=db --result-file=all_db_backup.sql
D. mysqlpump --include-databases=db% --result-file=all_db_backup.sql
The data in this instance is transient; no backup or replication will be required. It is currently under performing.
The database size is static and including indexes is 19G.
Total system memory is 32G.
After profiling the system, you highlight these MySQL status and global variables:
The OS metrics indicate that disk is a bottleneck. Other variables retain their default values.
Which three changes will provide the most benefit to the instance? (Choose three.)
A. innodb_flush_log_at_trx_commit=1
B. buffer_pool_size=24G
C. innodb_log_file_size=1G
D. sync_binlog=0
E. innodb_doublewrite=0
F. max_connections=10000
G. innodb_undo_directory=/dev/shm