Online 1Z0-908 Practice Test

Question 1

You are setting up a new server and you want to reserve 50GB of RAM for InnoDB use. What option would you set

Options :

A : innodb_ram_size=50GB

B : innodb_buffer_pool_size=50GB

C : innodb_buffer_pool=50G

Answer: B

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.)

Options :

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.

Answer: B,C

Question 3

You need to replicate a table from a master to a slave. The master and slave copies of the table will have different number of columns.

Which two conditions must be true? (Choose two.)

Options :

A : Each extra column in the copy with more columns must not have a default value.

B : Columns that are common to both versions of the table must be defined in the same order on the master and the slave.

C :

The slave database cannot have more columns than the master. Only the master database can have more columns.

D : Columns that are common to both versions of the table must come first in the table definition, before any additional columns are additional columns are defined on either server.

E : The master database cannot have more columns than the slave. Only the slave deatbase can have more columns.

Answer: B,D

Question 4

How can we start MySQL when it was installed using RPM in Oracle Enterprise Linux 7?

Options :

A : mysqld_safe --user=mysql &

B : systemctl start mysqld

C : service start mysql

D : mysqladmin -u root start

Answer: B

Question 5

You have forgotten the root user account password. You decide to reset the password and execute:

2020-03-14-14-37-11-4ec4153145d3e66368ed58ed6f5922f5

Which additional argument makes this operation safer?

Options :

A : --old-passwords, to start MySQL to use the old password format while running without the grant tables.

B : --reset-grant-tables, to start the server with only the mysql database accessible.

C : --read-only, to set all data to read-only except for super users

D : --skip-networking, to prohibit access from remote locations

Answer: D

EXPERTY DESIGNED 1Z0-908 PRACTICE TEST