Download MySQL Cloud Service 2018 Implementation Essential.1z0-320.CertKiller.2018-05-11.48q.vcex

ProfExam Suite - Black Friday
Vendor: Oracle
Exam Code: 1z0-320
Exam Name: MySQL Cloud Service 2018 Implementation Essential
Date: May 11, 2018
File Size: 39 KB
Download Exam

How to open VCEX files?

Files with VCEX extension can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase
Coupon: EXAM_HUB

Discount: 20%

ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator

Demo Questions

Question 1
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?
  1. using MySQL Client and the - -dump option to dump the tables to files: 
    # mysql –u<user> -p –h<host> -P<port> -- dump world_x.country world_x.countryinfo world_x.location
  2. 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’;
  3. 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;
  4. 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
  5. 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
Correct answer: CE
Question 2
Identify two features of MySQL Enterprise Firewall.
  1. You set the firewall per database.
  2. You can automatically delete a user if the user breaks your firewall.
  3. You can block out potential threats by setting up a preapproved whitelist.
  4. You can set a recording mode to record incoming SQL statement to create a whitelist of permitted commands.
  5. You can modify a request with a SQL statement substitution.
Correct answer: CD
Explanation:
Reference: https://www.mysql.com/products/enterprise/firewall/features.html
Reference: https://www.mysql.com/products/enterprise/firewall/features.html
Question 3
Name three ways in which customers can receive notifications such as outages, configuration changes, database emergencies, and other information on their Database as a Service instances.
  1. Email
  2. SMS
  3. Notification tab on the dashboard
  4. Browser pop-ups
  5. Direct support call from an Oracle representative
Correct answer: ABC
Question 4
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?
  1. As the root user, execute the FLUSH AUDIT LOGS command. Refresh the audit plug-in with SET GLOBAL audit_log_status =REFRESH.
  2. Stop the MySQL server. Move or rename the existing audit.log file. Restart the MySQL server.
  3. Stop the MySQL server. Reinstall the audit plug-in by using INSTALL PLUGIN audit_log SONAME ‘audit_log.so’; Delete the corrupted file. Restart the MySQL server.
  4. As the root user, execute the SET GLOBAL audit_log_flush=ON command.
Correct answer: C
Question 5
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?
  1. CREATE USER ‘mysqlbackup’@localhost’IDENTIFIED BY ‘new-password’;
  2. 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’;
  3. 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’;
  4. 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’;
  5. 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 6
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?
  1. ANALYZE TABLE INVENTORY;
  2. mysqlcheck INVENTORY
  3. mysqldump INVENTORY
  4. OPTIMIZE TABLE INVENTORY;
Correct answer: D
Explanation:
Reference: https://dev.mysql.com/doc/refman/5.7/en/optimize-table.html
Reference: https://dev.mysql.com/doc/refman/5.7/en/optimize-table.html
Question 7
You execute the following statement SELECT NULL_NULL; 
What is the result?
  1. 0
  2. 1
  3. TRUE
  4. FALSE
  5. NULL
Correct answer: D
Question 8
What are two key differences between the use of ndbd and ndbmtd?
  1. ndbd can be configured as ndbmtd by applying the option - - mtd.
  2. 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
  3. ndbd is single-threaded mode; however, ndbmtd runs by default in multithreaded mode.
  4. ndbd is single-threaded mode.ndbmtd runs by default in single-threaded mode; you must configure it to use multithreads.
  5. 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 9
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?
  1. Running mysqlbqckup from a remote machine enabled you to back up the database without locking.
  2. 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.
  3. There is no extra option. MySQL Enterprise Backup does this automatically by kicking out the long-running queries.
  4. 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.
  5. 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)
Reference: https://docs.oracle.com/cd/E17952_01/mysql-enterprise-backup-3.10-en/mysql-enterprise-backup-3.10-en.pdf (page 62)
Question 10
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?
  1. A MySQL Cluster backup process will be kick-started automatically.
  2. The entire cluster will be shut down.
  3. Components from one of the machines will be chosen as victim. Only one machine will provide service.
  4. All components will be running correctly and independently. Machine1 and Machine2 have all data and they can provide service online.
  5. The MySQL Cluster service will be pause. After the network is online, the MySQL Cluster service will be resumed.
Correct answer: E
CONNECT US
HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset

HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen

ProfExam
ProfExam at a 20% markdown

You have the opportunity to purchase ProfExam at a 20% reduced price

Get Now!