Free 1z0-908 Exam Dumps

No Installation Required, Instantly Prepare for the 1z0-908 exam and please click the below link to start the 1z0-908 Exam Simulator with a real 1z0-908 practice exam questions.
Use directly our on-line 1z0-908 exam dumps materials and try our Testing Engine to pass the 1z0-908 which is always updated.

Exam Code: 1z0-908
Exam Title: MySQL 8.0 Database Administrator
Vendor: Oracle
Exam Questions: 85
Last Updated: July 3rd,2024

Question 1

Where is the default data directory located after installing MySQL using RPM on Oracle Linux 7?

A. /usr/mysql
B. /usr/bin
C. /etc/my.cnf
D. /var/lib/mysql
E. /usr

Correct Answer:B
Reference: https://dev.mysql.com/doc/mysql-installation-excerpt/5.7/en/linux-installation-rpm.html

Question 2

You have an InnoDB Cluster configured with three servers.
Examine this command, which executes successfully:
mysqldump -uroot -p -d mydatabase > mydatabase_backup.sql
Due to data loss, the cluster is initialized and a restore is attempted resulting in this error:
ERROR 13176 (HY000) at line 23: Cannot update GTID_PURGED with the Group Replication plugin running
Which two actions, either one of which, can fix this error and allow a successful restore of the cluster? (Choose two.)

A. Stop all instances except the primary read/write master instance and run the restore.
B. Remove the @@GLOBAL.gtid_purged statement from the dump file.
C. Create the backup by using the --set-gtid-purged=OFF option.
D. Remove the group replication plugin from each instance before restoring.
E. Remove the @@GLOBAL.gtid_executed statement from the dump file.
F. Restore using the --set-gtid-purged=OFF option.

Correct Answer:BC
https://scriptingmysql.wordpress.com/2013/07/18/mysql-creating-and-restoring-databasebackups-with-mysqldump-and-mysql-enterprise-backup-part-1-of-2/

Question 3

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.

Correct Answer:CF

Question 4

Which two storage engines provide a view of the data consistent with the storage system at any moment? (Choose two.)

A. MyISAM
B. NDB
C. MEMORY
D. ARCHIVE
E. InnoDB

Correct Answer:AC

Question 5

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

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

Correct Answer:BFG