Q1. Identify a performance impact when using the Performance Schema.
A. There is no impact on performance.
B. There is an overhead for querying the Performance Schema but not for having it enabled.
C. There is a constant overhead regardless of settings and workload.
D. The overhead depends on the settings of the Performance Schema.
Answer: B
Q2. What are three methods to reduce Mysql server exposure to remote connections?
A. Setting -- skip-networking when remote connections are not required
B. Using the sql_mode=STRICT_SECURE after connections are established for encrypted communications
C. Setting specific GRANT privilege to limit remote authentication
D. Setting – mysql_secure_configuration to enable paranoid mode
E. Using SSL when transporting data over remote networks
Answer: B,C,D
Q3. What are three facts about backups with mysqldump?
A. Can back up a remote database server
B. Allow a consistent backup to be taken
C. Are always faster to restore than binary backups
D. Are able to back up specific items within a database
E. Create automatically compressed backups
F. Will lock all storage engines for duration of backup
Answer: D,E,F
Q4. You have taken a Logical Volume Manager (LVM) snapshot backup of a volume that contains the MySQL data directory.
Why is it important to remove snapshots after completing a RAW backup in this way?
A. The system can only support one snapshot per volume, and you need to remove it to be able to take your next backup.
B. The snapshot size will continue to grow as changes to the volume are made.
C. The snapshots take a significant amount of disk space as they are a duplicate copy of the data.
D. The system keeps a copy of changes in memory and can cause an out of memory event.
Answer: C
Q5. User A issues the command:
LOCK TABLES pets READ;
Which command can User B execute against the pets table?
A. UPDATE pets…
B. SELECT….FROM pets
C. INSERT INTO pets…
D. ALTER TABLE pets…
Answer: B
Q6. You want to start monitoring statistics on the distribution of storage engines that are being used and the average sizes of tables in the various databases.
Some details are as follows: . The Mysql instance has 400 databases. . Each database on an average consists of 25-50 tables.
You use the query:
SELECT TABLE_SCHEMA,
‘ENGINE’,
COUNT (*),
SUM (data_length) total_size
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = ‘BASE TABLE’
GROUP BY TABLE_SCHEMA, ‘ENGINE’
;
Why is this query slow to execute?
A. Counting and summarizing all table pages in the InnoDB shared tablespace is time consuming.
B. Collecting information requires various disk-level operations and is time consuming.
C. Aggregating details from various storage engine caches for the final output is time consuming.
D. Collecting information requires large numbers of locks on various INFORMATION_SCHEMA tables.
Answer: B
Q7. Which three data components are needed for point-in-time recovery?
A. The error log
B. The backup log
C. The general query log
D. Binary logs
E. The data backup
F. Configuration files
Answer: D,E,F
Q8. In a test database, you issue the SELECT … INTO OUTFILE statement to create a file with your t1 table data.
You then TRUNCATE this table to empty it.
Mysql> SELECT * INTO OUTFILE ‘/tmp/t1.sql’ from t1;
mysql> TRUNCATE t1;
Which two methods will restore data to the t1 table?
A. Mysql> LOAD DATA INFILE ‘/tmp/t1.sql’ INTO TABLE t1;
B. $ mysqladmin – u root – p – h localhost test – restore /tmp/t1.sql
C. $ mysql – u root – p – h localhost test < /tmp/t1.sql
D. $ mysqlinport – u root – p – h localhost test /tmp/t1.sql
E. Mysql> INSERT INTO t1 VALUES FROM ‘/tmp/t1.sql’;
Answer: A
Q9. Consider typical High Availability (HA) solutions that do not use shared storage.
Which three HA solutions do not use shared storage?
A. Mysql Replication
B. Distributed Replicated Block Device (DRBD) and Mysql
C. Windows Cluster and Mysql
D. Solaris Cluster and Mysql
E. Mysql NDB Cluster
Answer: A,C,D
Q10. You attempt to connect to a Mysql Server by using the mysql program. However, you receive the following notice:
ERROR 2059 (HY000): Authentication plugin ‘mysql_clear_password’ connot be loaded: plugin not enabled
What would you run to fix the issue?
A. The mysql client with the – ignore-password-hashing option
B. The mysql_secure_installation script to update server security settings
C. The mysql client with the – enable-cleartext-plugin option
D. The mysql_upgrade script
E. The install plugin command for the mysql_cleartext_password plugin
Answer: C
Reference: http://planet.mysql.com/entry/?id=34077