Question 1

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

Question 2

Force Majeure is a catastrophic failure on a major level of the database operation. Regular backups are key to helping avoid data loss in such situations.

Which two other steps can help avoid data loss in a major catastrophe? (Choose two.)

Options :

A : Implement a failover strategy to another geographic location.

B : Create a master-master pair for each service.

C : Have a second data centre in a different region or country.

D : Keep software updated to the latest version.

E : Use RAID 10 storage for data.

F : Use on-site network-attached storage to separate service from data.

Answer: A,C

Question 3

Which two are valid uses for binary logs on a MySQL instance? (Choose two.)

Options :

A : recording the order in which queries are issued

B : audit of all queries

C : point-in-time recovery

D : replication

E : logging the duration and locks for all queries

Answer: A,C

Question 4

Your MySQL environment has asynchronous position based-replication with one master and one slave.

The slave instance had a disk I/O problem, so it was stopped.

You determined that the slave relay log files were corrupted and unusable, but no other files are damaged.

You restart MySQL Server.

How can replication be restored?

Options :

A : The slave relay logs should be deleted; then execute START SLAVE;

B : The relay logs from the master should be used to replace the corrupted relay logs.

C : The slave relay logs should be deleted; execute CHANGE MASTER to adjust the replication relay log file name, then issue start SLAVE;

D : The slave needs to be restored from backup.

Answer: B

Question 5

Examine this MySQL client command to connect to a remote database:mysql -h remote.example.org -u root -p --protocol=TCP --ssl-mode=Which two --ssl-mode values will ensure that an X.509-compliant certificate will be used to establish theSSL/TLS connection to MySQL?

Options :

A : REQUIRED

B : VERIFY_CA

C : VERIFY_IDENTITY

D : PREFERRED

E : DISABLED

Answer: A

Free 1Z0-908 Mock Exam – Practice Online Confidently

Buying Options: