1Z0-908 Online Practice Questions and Answers

You are using an existing server with a new configuration. MySQL Server fails to start.

Examine this snapshot of the error log:

Which action would allow the server to start?

A. Remove ib_logfile0 and ib_logfile1 files from the file system.

B. Execute mysqladmin flush-logs.

C. First run mysqld --initialize to refresh the Size of ib_logfile.

D. Create a new ib_logfile0 file of size 26214400.

Examine this command, which executes successfully: cluster.addInstance(`@:', {recoveryMethod: `clone'}) Which three statements are true? (Choose three.)

A. The account used to perform this recovery needs the BACKUP_ADMIN privilege.

B. A target instance must exist, then it will be provisioned with data from an instance already in the cluster and joined to the cluster.

C. InnoDB tablespaces outside the datadir are able to be cloned.

D. It is always slower than {recoveryMethod: `incremental'}.

E. A new instance is installed, initialized, and provisioned with data from an instance already in the cluster and joined to the cluster.

F. InnoDB redo logs must not rotate for the duration of the execution; otherwise, the recovery will fail.

Examine this command, which executes successfull mysqlbackup --defaults-file=/backups/server-my.cnf --backup-dir=/backups/full copy-back Which statement is true about the copy-back process?

A. The copy-back process is used to overwrite a new backup over an existing backup.

B. It restores files from the data directory to their original MySQL server locations.

C. It restores files from the backup directory to their original MySQL server locations.

D. The copy-back process makes inconsistent backups.

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 InnoDB Cluster parameter settings:

Now examine the partial status:

A permanent network failure isolates host3.

Which two statements are true? (Choose two.)

A. The instance deployed on host2 is elected as the new primary instance.

B. The instance deployed on host3 is expelled from the cluster and must be rejoined using cluster.addInstance ('host3:3377')

C. The instance deployed on host3 will automatically rejoin the cluster when connectivity is re-established.

D. Failure of the instance deployed on host1 provokes an outage.

E. The issuing command cluster.switchToMuitiPrimaryMode() will fail to enable multi- primary mode.

F. The primary instance can be specified by using the command cluster.setPrimaryInstance(:).

Examine this SQL statement:

Which set of privileges will allow Tom to execute this SQL statement?

A. GRANT ALL PRIVILEGES ON `world'.`city' TO `tom'@'%'; GRANT SELECT (`code') ON `world'.`country' TO `tom'@'%';

B. GRANT UPDATE ON `world'.* TO `tom'@'%'; GRANT ALL PRIVILEGES ON `world'.`country' TO `tom'@'%';

C. GRANT UPDATE ON `world'.`city' TO `tom'@'%'; GRANT SELECT ON `world'.* TO `tom'@'%';

D. GRANT UPDATE ON `world'.`city' TO `tom'@'%'; GRANT SELECT ON `world'.`country' TO `tom'@'%';

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 a physical backup of the MySQL system.

B. Use the Clone Plugin to copy the data to another MySQL system.

C. Take a logical backup of the MySQL system.

D. Take your backup from a slave of the MySQL system.

Which four are types of information stored in the MySQL data dictionary? (Choose four.)

A. performance metrics

B. table definitions

C. access control lists

D. view definitions

E. server runtime configuration

F. server configuration rollback

G. stored procedure definitions

H. InnoDB buffer pool LRU management data

Which statement is true about cold backups?

A. They are backups taken from snapshots of a running database.

B. They are backups taken from OS copy commands.

C. They are good to use if only data structures must be backed up but not log files.

D. They are good to use when many users are online accessing the database.

Which two are characteristics of snapshot-based backups? (Choose two.)

A. Snapshot-based backups greatly reduce time during which the database and applications are unavailable.

B. There is no need for InnoDB tables to perform its own recovery when restoring from the snapshot backup.

C. The frozen file system can be cloned to another virtual machine immediately into active service.

D. A separate physical copy must be made before releasing the snapshot backup.

E. Snapshot backups can be used only in virtual machines.