Online Access Free 1Z0-908 Practice Test

Which two are contained in the InnoDB system tablespace (ibdata1) by default? (Chose two.)

• A.InnoDB Data Dictionary
• B.primary indexes
• C.doublewrite buffer
• D.change buffer
• E.user privileges
• F.table data

Which three actions are effective in capacity planning? (Choose three.)

• A.adding circular replication nodes for increased DML capability
• B.buying more RAM
• C.upgrading to the latest application version
• D.buying more disk
• E.consulting the application team about any future projects and use
• F.buying more CPU
• G.monitoring OS resources for patterns
• H.basing expected growth on an average of the last 3 years

You have a MySQL system with 500 GB of data that needs frequent backups.
You use a mix of MyISAM and InnoDB storage engines for your data. Examine your backup requirement:
* The MySQL system being backed up can never be unavailable or locked to the client applications.
* The recovery from the backup must work on any system.
* Only 1 hour of data can be lost on recovery of the backup.
Which option fulfills all backup requirements?

• A.Take your backup from a slave of the MySQL system.
• B.Use the Clone Plugin to copy the data to another MySQL system.
• C.Take a physical backup of the MySQL system.
• D.Take a logical backup of the MySQL system.

User account baduser@hostname on your MySQL instance has been compromised.
Which two commands stop any new connections using the compromised account? (Choose two.)

• A.ALTER USER baduser@hostname PASSWORD DISABLED;
• B.ALTER USER baduser@hostname MAX_USER_CONNECTIONS 0;
• C.ALTER USER baduser@hostname DEFAULT ROLE NONE;
• D.ALTER USER baduser@hostname IDENTIFIED WITH mysql_no_login;
• E.ALTER USER baduser@hostname ACCOUNT LOCK;

Examine this parameter setting:
audit_log=FORCE_LOG_PERMANENT
What effect does this have on auditing?

• A.It will force the load of the audit plugin even in case of errors at server start.
• B.It prevents the audit log from being removed or rotated.
• C.It causes the audit log to be created if it does not exist.
• D.It prevents the audit plugin from being removed from the running server.