1Z0-908 Exam Questions & Answers

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

Consider this shell output and executed commands:

[root@oel7 ~]# ps aux | grep mysqld

mysql 2076 3.5 24.6 1386852 372572 ? Ssl 12:01 0:01 /usr/sbin/mysqid

[root@oel7 ~]# kill -15 2076

Which statement is true about MySQL server shutdown?

On examination, your MySQL installation datadir has become recursively world read/write/executable.

What are two major concerns of running an installation with incorrect file privileges? (Choose two.)

An existing asynchronous replication setup is running MySQL 8.

Which two steps are a part of implementing GTID replication? (Choose two.)

Your MySQL server was upgraded from an earlier major version.

The sales database contains three tables, one of which is the transactions table, which has 4 million rows.

You are running low on disk space on the datadir partition and begin to investigate.

Examine these commands and output:

Which two statements are true? (Choose two.)