1Z0-320 Actual Free And Updated Dumps - 1Z0-320 RealExamDumps.us

Question No 9

You want to change the default behavior of MySQL Enterprise Monitor (MEM). New instances detected by a MEM agent should automatically monitor discovered instances.How can you change the Advisor Setting?

Options

A.Go to the configuration section (Users) and create a new user according to the existing users of your new MySQL instances.
B.Go to the configuration section (Advisors) and edit the default settings of the MySQL Process Discovery according to the existing users of your new MySQL instances.
C.Go to the configuration section (Advisors) and create a new advisor rule for new MySQL instances based on the MySQL Advisor Wizard.
D.Go to the configuration section (MEM) and configure the default login credentials.

Answer: B
Explanation
References:

Download 1Z0-320 Exam Study Material - 1Z0-320 Braindumps

Question No 8

Which two architecture options can provide Active/Active Master configuration for the MySQL Database?

Options

A. Execute the following on the 2x MySQL Server Instancesmysql> ALTER REPLICATION set mode= active;
B. Deploy MySQL Cluster on the following machines:Machine 1: MySQL Node+ MySQL Management NodeMachine 2: MySQL Node+ MySQL Management NodeMachine 3: Data NodeMachine 4: Data
NodeApplication can access MySQL Node on Machine 1 or Machine 2 for Active/Active Configuration.
C. Configure MySQL Replication for two MySQL Database instances with circular Replication Topology,where two different applications with each using different database schemas connecting to a specified MySQL Database Instance.MySQL Database Instance1 < -----Replication---> MySQL Database Instance 2Application A connecting to MySQL Database Instance 1 for schema db1Application B connecting to MySQL Database Instance 2 for schema db2
D. Configure MySQL Replication between two MySQL Database instances and setting Replication mode = active.
E. 2x MySQL Server Instances should be deployed on two machines with shared NFS volume. Datadir points to the shared folder. Applications can access either one of the MySQL Servers for the same set of data.

Answer: C,D

Exam Study Material 1Z0-320 Exam Real Dumps - 1Z0-320 RealExamDumps.us

Question No 7

The slave connects to the master and asks for updated records. What command was issued for this to happen?

Options

A. RUN SLAVE
B. START RUN SLAVE
C. SLAVE RUN
D. SLAVE START
E. START SLAVE

Answer: D

Actual Free And Updated Dumps 1Z0-320 Exam Real Dumps - 1Z0-320 Braindump

Question No 6

Your newly created MySQL Cloud Service is not available from your application. Select the two correct options that apply.

Options

A. You forgot to create the correct SSL/TLC certificate during the setup process.
B. The ‘opc’ user can be used to access MySQL only with the created SSH-Key.
C. Only ‘root’ is allowed to access from non-localhost.
D. The MySQL instance is still in the “Creation” process.
E. You forgot to enable port 3306.

Answer: C,E

Get Updated 1Z0-320 Exam Dumps - 1Z0-320 Dumps PDF Questions | Braindumps

Download Exam Study Material 1Z0-320 Exam Real Dumps - 1Z0-320 Braindumps

Question No 5

By using the asynchronous MySQL Replication architecture, data can be replicated to slaves. Identify three use cases of MySQL Replication.

Options

A. MySQL Replication Connector/J (ReplicationDriver) is provided to allow read capability on slave and write capability on master.
B. MySQL Enterprise Backup will back up from Slave automatically.
C. It provides multi-master access where the application can write and read data across the database servers.
D. It allows backup to be done on the slave without impacting the master.
E. You can create a slave server for reporting applications, which get only read access to the slave servers. It off-loads the master server. Additional servers allow different database server configuration.

Answer: B,D,E

RealExamDumps 1Z0-320 Exam Real Dumps - 1Z0-320 Braindumps

Question No 4

A keyfile has been generated as follows:
# openssl rand 32 –hex >keyfile
# cat keyfile
6a1d325e6ef0577f3400b7cd624ae574f5186d0da2eeb946895de418297ed75b
You are required to do a backup on the MySQL database using MySQL Enterprise Backup with encryption.
Which option can perform the backup with the keyfile provided in order to encrypt the backup files?

Options

A.# mysqlbackup - - backup-image=/backups/image.enc - - encrypt - -key-file= keyfile - -backup-dir=/var/tmp/backup backup-to-image
B.# mysqlbackup- - encrypt - -key-file=keyfile - -backup-dir=/var/tmp/backup backup
C.# mysqlbackup - - backup-image=/backups/image.enc - - encrypt- - encrypt-key=keyfile - -backup-dir=/var/tmp/backup backup-to-image
D.# mysqlbackup - - backup-image=/backups/image.enc - - encrypt - -key=keyfile --backup-dir=/var/tmp/backup backup-to-image
E.# mysqlbackup- - encrypt - -key-file=keyfile - -backup-dir=/var/tmp/backup – timestamp backup

Answer: D
Explanation
References: