1Z0-908 Online Practice Questions and Answers

Examine this command, which executes successfully:

shell> mysqldump --master-data=2 --single-transaction --result-file=dump.sql mydb

Which two statements are true? (Choose two.)

A. It executes flush tables with read lock.

B. It enforces consistent backups for all storage engines.

C. The backup created is a consistent data dump.

D. This option uses the READ COMMITTED transaction isolation mode.

E. It is a cold backup.

Which two statements are true about MySQL server multi-source replication? (Choose two.)

A. It is not compatible with auto-positioning.

B. It needs to be re-instanced after a crash to maintain consistency.

C. It uses only time-based replication conflict resolution.

D. It relies on relay_log_recovery for resilient operations.

E. It does not attempt to detect or resolve replication conflicts.

F. It must use GTID replication.

You have configured MySQL Enterprise Monitor to monitor your MySQL server.

Which four features are available? (Choose four.)

A. starting and stopping the MySQL instance

B. tracing import and export with mysqidump

C. deploying the MySQL agent on supported target operating system

D. creating e-mail alerts and SNMP traps for MySQL warnings

E. monitoring the availability of the MySQL instance

F. analyzing executed MySQL queries

G. monitoring of NDB Cluster API nodes

Which two are true about differences between logical and physical upgrades of MySQL databases? (Choose two.)

A. Post-upgrade table storage requirements after logical upgrades are usually smaller than that after physical upgrades.

B. Physical upgrades are performed for current instances on bare metal deployments, whereas logical upgrades are used for virtual machines or containerized instances.

C. Logical upgrades are much faster because they do not require restarting the mysqld process.

D. Post-upgrade table storage requirements after physical upgrades are usually smaller than that after logical upgrades.

E. Physical upgrades are much faster because they do not require restarting the mysqld process.

F. Physical upgrades leave data in place, whereas logical upgrades require data to be restored from mysqldump-type backups taken before the upgrades.

Which two statements are true about using backups of the binary log? (Choose two.)

A. Multiple binary logs can be used to restore data.

B. Multiple binary logs can be applied in parallel for faster data restoration.

C. Binary logs are relatively small, and therefore, excellent for long-term storage and disaster recovery.

D. Binary logs can always be used to unapply unwanted schema changes.

E. They allow for point-in-time recovery of the data.

You have upgraded the MySQL binaries from 5.7.28 to 8.0.18 by using an in-place upgrade. Examine the message sequence generated during the first start of MySQL 8.0.18:

Which step or set of steps will resolve the errors?

A. Remove the redo logs. Replace the MySQL binaries with the 5.7.28 binaries. Prepare the tables for upgrade. Upgrade to 8.0.18 again.

B. Execute: mysqlcheck --check-upgrade mysql columns_priv event proc proxies_priv tables_priv.

C. Start mysqld again using the --upgrade=FORCE option.

D. Execute: mysqlcheck --repair mysql columns_priv event proc proxies_priv tables_priv.

E. Go to the /mysql directory and execute: myisamchk --update-state columns_priv event proc proxies_priv tables_priv.

Examine this command, which executes successfully:

Which two statements are true? (Choose two.)

A. A single-file backup is created.

B. The backup operation will finish only when backup-and-apply-log is executed.

C. The --backup-dir option holds temporary output, status, and metadata files.

D. The backup operation will finish only when apply-log is executed.

E. A raw backup is created.

Which two are true about binary logs used in asynchronous replication? (Choose two.)

A. They are pushed from the master to the slave.

B. They contain events that describe database changes on the master.

C. They contain events that describe all queries run on the master.

D. They contain events that describe only administrative commands run on the master.

E. They are pulled from the master to the slave.

You want to log only the changes made to the database objects and data on the MySQL system.

Which log will do this by default?

A. general query log

B. audit log

C. slow query log

D. binary log

E. error log

Which three sets of item information are visible in the mysql system database? (Choose three.)

A. help topics

B. performance monitoring information

C. plugins

D. information about table structures

E. audit log events

F. rollback segments

G. time zone information and definitions