The Far Out Guide To 1z0-320 Training Tools

NEW QUESTION 1
The MySQL Cloud Service (CS) is a database offering from Oracle. Which three statements are correct?

• A. MySQL CS is based on an IaaS Oracle Linux image including full root privileges to the OS.
• B. Oracle MySQL Enterprise Tools & Plugins are available as optional services (installation Feature Pack I/II).
• C. MySQL CS is installed based on the Oracle Flexible Architecture Standard.
• D. MySQL CS is based on the MySQL Enterprise Product Suite.
• E. MySQL CS is based on the MySQL GPLv2 version from the Oracle Linux 6 with optimizations for the Cloud(Oracle Flexible Architecture Standard).
• F. MySQL CS configuration can be changed in /etc/my.cnf.

Answer: BDF

NEW QUESTION 2
You set up a compressed full backup file from mysqlbackup by using the --compress option for MySQL Database backup.
You are required to restore the database and apply the log.
Which two options should you add to the mysqlbackup to achieve the restoration of the database?

• A. --uncompress-and-apply-log
• B. --apply-log-and-copy-back
• C. --copy-back-and-apply-log
• D. --uncompress
• E. --decompress

Answer: CD

NEW QUESTION 3
Which statement would create an index by using the first 10 characters of the name column in the customer table (assuming that name is a nonbinary string type?)

• A. CREATE SUB INDEX part_of_name ON (customer, name, 10);
• B. CREATE INDEX (10) ON (customer.name);
• C. CREATE INDEX part_of_name ON customer (name(10));
• D. CREATE PARTIAL INDEX part-of_name ON customer (name, 10);
• E. CREATE INDEX part_of_name ON customer.name LIMIT 10 CHAR;

Answer: C

NEW QUESTION 4
For accessing a new default MySQL Cloud Service (CS) cloud environment, you used the “Create SSH Keys function” during the guided MySQL CS setup. You want to use Putty from your Windows Client. Identify the correct steps.

• A. You open Port 22 on your MySQL CS Instance and configure Putty with the provided private key.
• B. Convert the private key to ppk format first, and use the new private key for authentication.
• C. Use the providedprivate key for authentication.
• D. Open Port 22 on your MySQL CS Instance and convert the private key to ppk forma
• E. This new private key can be used for authentication.

Answer: D

NEW QUESTION 5
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?

• 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 configurationsection (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

NEW QUESTION 6
You are using the MySQL Enterprise Audit plug-in, and the audit.log file is corrupted. What steps would you perform to create a new audit file?

• A. As the root user, execute the FLUSH AUDIT LOGS comman
• B. Refresh the audit plug-in with SET GLOBAL audit_log_status =REFRESH.
• C. Stop the MySQL serve
• D. Move or rename the existing audit.log fil
• E. Restart the MySQL server.
• F. Stop the MySQL serve
• G. Reinstall the audit plug-in by using INSTALL PLUGIN audit_log SONAME ‘audit_log.so’; Delete the corrupted fil
• H. Restart the MySQL server.
• I. As the root user, execute the SET GLOBAL audit_log_flush=ON command.

Answer: C

NEW QUESTION 7
Your customer wants you to install and configure MySQL on the customer’s Oracle Linux 6 server with tarball binaries in the /app/mysql1/directory, where the bin directory is found at /app/mysql/bin and a data directory at /app/data.
What are two correct and required server configurations, excluding redundant configuration entries, to build a MySQL instance supporting your customer’s requirement?

• A. Theconfiguration datadir=/app/mysql/data is needed.
• B. The configuration basedir=/app/mysql/bin is needed.
• C. The configuration log-bin=/app/data is needed.
• D. The configuration datadir=/app/data is needed.
• E. The configuration innodb_log_group_home_dir=/datadir is needed.
• F. The configuration basedir=/app/mysql is needed.

Answer: BD

NEW QUESTION 8
Which statement will display the status of the partitioning plug-in?

• A. SHOW STATUS PLUGINS WHERE Name= ‘PARTITIONING’;
• B. SHOW PLUGINS WHERE Name= ‘partition’;
• C. SELECT PLUGIN_NAME, PLUGIN_VERSION, PLUGIN_STATUS FROM INFOMRATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME= ‘partition’;
• D. USE SYS SCHEMA; SHOW PLUGINS STATUS;

Answer: C

NEW QUESTION 9
You are having performance issues with MySQL instances. Those servers are monitored with MySQL Enterprise Monitor (MEM). How would you proceed?

• A. Sort the “Exec” column and check for SQL queries with high QRTi values.
• B. Sort the “Exec” column and check for SQL querieswith low QRTi values.
• C. Look for queries with low total latency times in the Latency section in the times series graph (Query Analyzer.)
• D. Look for queries with big prolonged spikes in row activity/access graph in the times series graph (Query Analyzer.)

Answer: C

NEW QUESTION 10
Which two ports need to be opened on a network firewall to allow an outside client (on the other side of the firewall) to be able to access a MySQL instance inside the firewall?

• A. Port 13306/tcp [MySQL], when using TCP/IP via a command-line client
• B. Port 3306/tcp [MySQL], when tunneling is not used from within MySQL Workbench
• C. Port 18443/tcp [MySQL], when connecting from MySQL Workbench to a Windows MySQL server
• D. Port 22/tcp [SSH], when using TCP/IP over SSH

Answer: BD

NEW QUESTION 11
Select three privileges that are necessary to successfully back up a server instance with the mysqlbackup command after the initial installation.

• A. CREATE TEMPORARY TABLES
• B. REPLICATION CLIENT
• C. GRAND OPTION
• D. RELOAD
• E. INDEX

Answer: ABD

NEW QUESTION 12
You get a Maintenance notification about your Oracle MySQL Cloud Service. What are the implications?

• A. There are no maintenance operations planne
• B. You need to do them manually.
• C. Depending on the planned outage, you may not be affected by i
• D. You need to read the maintenance details in the support notice.
• E. You need to agree to the maintenance window
• F. If not, you are not affected by the outage.
• G. You can expect an outage of your MySQL Cloud Service during the planned time.

Answer: D

NEW QUESTION 13
When working with the Linux operating system on a database cloud instance (non-RAC), which user accounts are available for database and non-database administration?

• A. admin, ora-cloud, andoracle
• B. administrator, opc,andoracle
• C. root, opc-administrator,andoraclethrough sudo
• D. cloud-admin, oracle,androot
• E. opc, oracle,androot(through sudo)

Answer: E

NEW QUESTION 14
The user ‘OS-user’@’localhost’ was created to monitor connections and shut down the server, and was granted the following privileges:
GRANT PROCESS, SHUTDOWN ON *.* to ‘OS-user’@’localhost’;
Identify three commands that the OS-user can execute.

• A. SHOW STATUS;
• B. SHUTDOWN;
• C. SHOW BINLOG EVENTS;
• D. SHOW PROCESSLIST;
• E. KILL PROCESS;

Answer: ABE

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

• A. ndbd can be configured as ndbmtd by applying the option - - mtd.
• B. 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
• C. ndbd is single-threaded mode; however, ndbmtd runs by default in multithreaded mode.
• D. ndbd is single-threaded mode.ndbmtd runs by default in single-threaded mode; you must configure it to use multithreads.
• E. 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.

Answer: DE

NEW QUESTION 16
You are requested to export data from a set of the following tables in the database ‘world_x’. Tables (country, countryinfo, location)
Which two options would allow you to export data as files?

• A. using MySQL Client and the - -dump option to dump the tables tofiles:# mysql –u<user> -p –h<host>-P<port> -- dump world_x.country world_x.countryinfo world_x.location
• B. using MySQL Client and EXPORT <table> TO <file> to export data one by one:mysql>EXPORT world_x.country TO ‘/output/country.txt’;mysql>EXPORT world_x.countryinfo TO ‘/output/countryinfo.txt’;mysql>EXPORT world_x.location TO ‘/output/location.txt’;
• C. using MySQL Client and SELECT …INTO OUTFILE ‘<filename>’ from <TABLE> to export data one by one:mysql>select * into outfile ‘/output/country.txt’ from world_x.country;mysql>select * into outfile ‘/output/countryinfo.txt’ from world_x.countryinfo;mysql>select * into outfile ‘/output/location.txt’ from world_x.location;
• D. using mysqlexport to export multiple tables in a database in one command line:#mysqlexport –u<user>- h<host> -P<port> -p world_x country countryinfo location> mydump.sql
• E. using mysqldump to dump multiple tables in a database in one command line:# mysqldump –u<user>- h<host> -P<port> -p world_x country countryinfo location> mydump.sql

Answer: CE

NEW QUESTION 17
A MySQL server (Linux-based installation, Port 3306, default) needs to be monitored. The MySQL server and the MySQL Enterprise Monitor (MEM) are located in different security zones, which are protected with a firewall. Which port must be opened for MEM agentless monitoring?

• A. Port 21/tcp (ftp) from MySQL Enterprise Monitor to MySQL server
• B. Port 18443/tcp (Tomcat) from MySQL server to MySQL Enterprise Monitor
• C. Port 22/tcp (SSH) from MySQL Enterprise Monitor to MySQL server
• D. Port 3306/tcp (MySQL) from MySQL Enterprise Monitor to MySQL server

Answer: B

NEW QUESTION 18
MySQL is installed on a Linux server and has the following configuration: [mysqld]
User=mysql Datadir=/data/mysql
Which two methods should you use to change the default options to use the authentication plug-in that implements SHA-256 hashing for user account passwords?

• A. Create user by using CREATE USER ‘newuser’ @’localhost’ SET PASSWORD AS ‘Sh@256Pa33’;
• B. Add --default_authentication_plugin=sha256_password on the command line when you invoke theserver.
• C. Add default_authentication_plugin=sha256_password under [mysqld] in the configuration file.
• D. Create user by using CREATE USER ‘newuser’@’localhost’ IDENTIFIED WITH ‘Sh@256Pa33’;

Answer: BD

NEW QUESTION 19
The MySQL database for backup with used data is configured only with the InnoDB storage engine. System data including SP, VIEWs, and users in the system database are all static. For any changes with system data, the database backup will be done separately.
You are requested to optimize backup performance to reduce backup time by using MySQL Enterprise Backup for the daily backup operation with user data (configured with the InnoDB storage engine).
Which three options would you choose to optimize the backup performance?

• A. Shutting down the MySQL database and using MySQL Enterprise Backup to restart the MySQL Database to remove any potential locking
• B. Using the - - only- innodb or - - only- innodb- with –frm option to back up only InnoDB tables
• C. Running multiple MySQL Enterprise Backups at the same time to back up the same database to allow parallel database backups on MySQL
• D. Running the backup with the backup policy, full backup and incremental backup,supported by MySQLEnterprise Backup to reduce the daily backup time
• E. Using the - - no-locking option to backup non_InnoDB files

Answer: CDE

NEW QUESTION 20
Identify three characteristics of the JSON data type.

• A. Key or array references enable quick read-access to look up document elements directly.
• B. It is based on the TEXT data type.
• C. It validates the JSON syntax on insert or merge.
• D. it supports indexing directly against the JSON-defined column.
• E. Comparisons of JSON values are not case-sensitive.
• F. A set of SQL functions substantially support the SQL utilization of the data type.

Answer: ACD

NEW QUESTION 21
MySQL Enterprise provides query analyzing metrics for SQL statements. Which four MySQL environments will provide QUAN metrics?

• A. All MySQL (when MySQL connectors with Aggregator is used for the application)
• B. MySQL 5.5.9 (and later)
• C. MySQL 5.7.9 Community (and later)
• D. MySQL 5.6.14 Commercial (and later)
• E. All MySQL (with MySQL Enterprise Monitor Proxy)

Answer: BCDE

NEW QUESTION 22
Which two MySQL features are provided exclusively with the Enterprise Edition license, in addition to the database server?

• A. MySQL Enterprise Monitor
• B. MySQL Cluster Manager
• C. MySQL Enterprise Firewall
• D. MySQL Replication

Answer: AC

NEW QUESTION 23
You have the following mysqlbackup-inc.cnf config file:

Which two commands allow MySQL Enterprise Backup to perform incremental backup based on the last full backup?

• A. # mysqlbackup --defaults-file=mysqlbackup-inc.cnf --port=3306 --host=127.0.0.1 –-user=mysqlbackup–-password –-with-timestamp backup
• B. # mysqlbackup–-defaults-file=mysqlbackup-inc.cnf –-port=3306 –-host=127.0.0.1 –-user=mysqlbackup–-password –-incremental backup-to-image
• C. # mysqlbackup –-defaults-file=mysqlbackup-inc.cnf –-port=3306 –-host=127.0.0.1 –-user=mysqlbackup–-password backup-incremental
• D. # mysqlbackup –defaults-file=mysqlbackup-inc.cnf –-port=3306 –-host=127.0.0.1 –-user=mysqlbackup–-password backup-to-incremental
• E. # mysqlbackup –-defaults-file=mysqlbackup-inc.cnf –-port=3306 –-host=127.0.0.1 –-user=mysqlbackup–-password incremental

Answer: B

Explanation:
Reference https://downloads.mysql.com/docs/mysql-enterprise-backup-3.8-en.a4.pdf

NEW QUESTION 24
......