Free Download 1z0-320 Examp Dump: Oracle.1z0-320.PracticeTest.2018-04-04.46q.vcex

Question 1

You are required to set up a backup user (mysqlbackup@localhost) on the MySQL Database. The user should have the backup and restore privileges and additional privileges required for using transportable tablespaces (TTS). To back up and restore InnoDB tables.

Which syntax accomplishes this?

CREATE USER ‘mysqlbackup’@localhost’IDENTIFIED BY ‘new-password’;
CREATE USER ‘mysqlbackup’@localhost’ IDENTIFIED BY ‘new-password’;
GRANT RELOAD ON *.* TO ‘mysqlbackup’@’localhost’;
GRANT CREATE, INSERT, DROP, UPDATE ON mysql.backup_progress TO ‘mysqlbackup’@’localhost’;
GRANT CREATE, INSERT, SELECT, DROP, UPDATE ON mysql.backup_history TO ‘mysqlbackup’@’localhost’;
GRANT REPLICATION CLIENT ON *.* TO ‘mysqlbackup’@’localhost’;
GRANT SUPER ON *.* TO ‘mysqlbackup’@’ localhost;
GRANT PROCESS ON *.* ‘mysqlbackup’@’localhost’;
CREATE USER ‘mysqlbackup’@’localhost’ IDENTIFIED BY ‘new-password’;
GRANT RELOAD ON *.* TO ‘’mysqlbackup’@’localhost’;
GRANT CREATE, INSERT, DROP, UPDATE ON mysql.backup_progress TO ‘mysqlbackup’@’localhost’;
GRANT CREATE, INSERT, SELECT, DROP, UPDATE ON mysql.backup_history TO ‘mysqlbackup’@localhost’;
CREATE USER ‘mysqlbackup’@’localhost’ IDENTIFIED BY ‘new-password’;
GRANT RELOAD ON *.* to ‘mysqlbackup’@localhost’;
GRANT CREATE, INSERT, DROP, UPDATE ON, mysql.backup_progress TO ‘mysqlbackup’@’localhost’;
GRANT CREATE, INSERT, SELECT, DROP, UPDATE ON
mysql.backup_history TO ‘mysqlbackup’@’localhost’;
GRANT REPLICATION CLIENT ON *.* to ‘mysqlbackup’@’localhost’;
GRANT SUPER ON *.* TO ‘mysqlbackup’@’localhost’;
GRANT PROCESS ON *.* TO ‘mysqlbackup’@’localhost’;
GRANT LOCK TABLES, SELECT, CREATE, ALTER ON *.* TO ‘mysqlbackup’@’localhost’;
GRANT CREATE, INSERT, DROP, UPDATE ON mysql.backup_sbt_history TO ‘mysqlbackup’@’localhost’;
CREATE USER ‘mysqlbackup’@’localhost’ IDENTIFIED BY ‘new-password’;
GRANT RELOAD ON *.* TO ‘mysqlbackup’@’localhost’;
GRANT CREATE, INSERT, DROP, UPDATE ON mysql.backup_progress TO ‘mysqlbackup’@’localhost’;
GRANT CREATE, INSERT, SELECT, DROP, UPDATE ON mysql.backup_history TO ‘mysqlbackup’@’localhost’;
GRANT REPLICATION CLIENT ON *.* TO ‘mysqlbackup’@’localhost’;

Correct answer: A

Question 2

You are using the InnoDB engine and the innodb_file_per_table option is set. You delete a significant number of a large table named INVENTORY. What command will reorganize the physical storage of table data and associated index data for the INVENTORY table, in order to reduce storage space and improve I/O efficiency?

ANALYZE TABLE INVENTORY;
mysqlcheck INVENTORY
mysqldump INVENTORY
OPTIMIZE TABLE INVENTORY;

Correct answer: D

Explanation:

Reference: https://dev.mysql.com/doc/refman/5.7/en/optimize-table.html

Question 3

You execute the following statement SELECT NULL_NULL;

What is the result?

0
1
TRUE
FALSE
NULL

Correct answer: D

Question 4

What are two key differences between the use of ndbd and ndbmtd?

ndbd can be configured as ndbmtd by applying the option - - mtd.
In the event of critical errors, ndbd generates a trace file with the name ndb_node_id_trace.log.trace_id, whereas ndbmtd generates a trace file with the name pattern ndb_node_id_trace.log.trace_id_tthread_id
ndbd is single-threaded mode; however, ndbmtd runs by default in multithreaded mode.
ndbd is single-threaded mode.ndbmtd runs by default in single-threaded mode; you must configure it to use multithreads.
In the event of critical errors, ndbd generates all trace in error log, whereas ndbmtd generates a trace file with the name pattern ndb_node_id_trace.log.trace_id_tthread_id.

Correct answer: DE

Question 5

When there are long-running queries, mysqbackup hangs there to wait for the completion of the queries. You know that the system has only user data on InnoDB and there is no DDL execution during the backup period. There is no update/alternation to tables with non-InnoDB storage engines.

Which two ways allow the MySQL Enterprise Backup to be executed without being blocked or without locking?

Running mysqlbqckup from a remote machine enabled you to back up the database without locking.
The locked phase at the end of a mysqlbackup run is short (maybe a few seconds) and does not disturb the normal processing of mysqld much. However, use - -single-user-mode to back up the long-running queries to allow mysqlbackup to run successfully without locking.
There is no extra option. MySQL Enterprise Backup does this automatically by kicking out the long-running queries.
The locked phase at the end of a mysqlbackup run is short (maybe a few seconds), and does not disturb the normal processing of mysqld much. However, use the - - only-innodb option to back up only InnoDB tables, to avoid blocking.
The locked phase at the end of a mysqlbackup run is short (maybe a few seconds), and does not disturb the normal processing of mysqld non-InnoDB files. Note that MyISAM, .frm, and other files copied under the --no-locking setting cannot be guaranteed to be consistent, if they are updated during this final phase of the backup.

Correct answer: BE

Explanation:

Reference: https://docs.oracle.com/cd/E17952_01/mysql-enterprise-backup-3.10-en/mysql-enterprise-backup-3.10-en.pdf (page 62)

Question 6

You are setting up a MySQL Cluster on two machines, where each machine is hosting the following:

1x ndbmtd
1x ndb_mgmd
1x mysqld

The cluster is started. What will happen if the network connection between the two machines is disconnected?

A MySQL Cluster backup process will be kick-started automatically.
The entire cluster will be shut down.
Components from one of the machines will be chosen as victim. Only one machine will provide service.
All components will be running correctly and independently. Machine1 and Machine2 have all data and they can provide service online.
The MySQL Cluster service will be pause. After the network is online, the MySQL Cluster service will be resumed.

Correct answer: E

Question 7

You need to load the MySQL Enterprise Audit plug-in at database startup and prevent the audit plug-in from being removed at run time.

Which two options should you include in the MySQL configuration file?

audit_log_permanent=ON
audit-log=FORCE_PLUS_PERMANENT
plugin-load=audit_log.so
plugin-audit=ON, ALWAYS
LOAD PLUGIN=AUDIT_LOG

Correct answer: AB

Explanation:

Reference: https://dev.mysql.com/doc/refman/5.7/en/audit-log-installation.html

Question 8

Assume that MySQL Enterprise Monitor is configured to monitor MySQL 5.6 or a later instance. Which three features are available?

Deploying MySQL Agent on supported target operating system
Tracing import and export with mysqldump
Monitoring the availability of the MySQL instance
Creating E-Mail Alerts and SNMP Traps for MySQL Warnings
Starting and Stopping the MySQL Instance
Analyzing executed MySQL queries

Correct answer: ABD

Question 9

You have three machines with MySQL Databases running on Linux platform.

Which backup procedures would allow online and remote backup of the MySQL Database on three machines to a connected Storage NFS?

1. Mount the Remote Storage NFS volume to each of the three machines with proper privilege for the backup OS user to have all access.
2. Install MySQL Enterprise Backup on machine which is used to start the backup.
3. Start mysqlbackup on only one machine with the installation to back up the databases for the three machines to the mounted volume using - -backup-dir and by giving
--hosts=machine1:port1, machine2:port2, machine3:port3.
4. Validate the backups using the mysqlbackup program to ensure that the backups created are valid.
1. Mount the Remote Storage NFS volume to each of the three machines with proper privilege for the backup OS user to have all access.
2. Install MySQL Enterprise Backup on all three machines.
3. Start mysqlbackup on all machines to back up the database to the mounted volume using - -backup-dir.
4. Validate the backup using the mysqlbackup program to ensure that the backup created is valid.
1. Mount the Remote Storage NFS volume to each of the three machines with proper privilege for the backup OS user to have all access.
2. Install MySQL Enterprise Backup on the machine that is used to start the backup.
3. Start mysqlbackup on only one machine with the installation to back up the databases for the three machines to the mounted volume using - - backup-dir and by specifying -- config-files=my1.cnf, my2.cnf, my3.cnf.my1.cnf, my2cnf, and my3.cnf are the MySQL Database Configuration files on the three machines.
4. Validate the backup by using the mysqlbackup program to ensure that the backup created is valid.
1. Mount the Remote Storage NFS volume to each of the three machines with proper privilege for the backup OS user to have all access.
2. Install MySQL Workbench on a separate machine, which is used to connect to the three machines to back up and restore.
3. Startup MySQL backup from MySQL Workbench to back up the three databases.
4. Validate the backup by using MySQL Workbench to ensure that the backup created is valid.

Correct answer: B

Question 10

After the installation of the MySQL Server, you cannot find MySQL Utilities.

How would you correct the problem?

MySQL Utilities comes with MySQL Enterprise Monitor. Download MySQL Enterprise Monitor to install.
MySQL Utilities is installed with MySQL Server Binary. Put the MySQL bin folder into PATH to allow execution.
MySQL Utilities is a package from MySQL Connector. Download the MySQL/Connector and install.
MySQL Utilities comes with MySQL Enterprise Backup. Download MySQL Enterprise Monitor to install.
MySQL Utilities is a package of utilities that are used for maintenance and administration of MySQL servers. Download the MySQL Utilities separately from www.mysql.com.

Correct answer: E

Explanation:

Reference: https://dev.mysql.com/doc/workbench/en/wb-mysql-utilities.html

Exam	MySQL Cloud Service 2018 Implementation Essential
Number	1z0-320
File Name	Oracle.1z0-320.PracticeTest.2018-04-04.46q.vcex
Size	138 KB
Posted	Apr 04, 2018
Download	Oracle.1z0-320.PracticeTest.2018-04-04.46q.vcex

Download Oracle.1z0-320.PracticeTest.2018-04-04.46q.vcex

File Info

How to open VCEX & EXAM Files?

Demo Questions