Download MySQL Cloud Service 2018 Implementation Essential.1z0-320.CertKiller.2019-03-18.50q.vcex

Vendor: Oracle
Exam Code: 1z0-320
Exam Name: MySQL Cloud Service 2018 Implementation Essential
Date: Mar 18, 2019
File Size: 115 KB
Downloads: 1
Download Exam

How to open VCEX files?

Files with VCEX extension can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase
Coupon: EXAMFILESCOM

Discount: 20%

ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator

Demo Questions

Question 1
By using the asynchronous MySQL Replication architecture, data can be replicated to slaves. Identify three use cases of MySQL Replication.
  1. MySQL Replication Connector/J (ReplicationDriver) is provided to allow read capability on slave and write capability on master.
  2. MySQL Enterprise Backup will back up from Slave automatically.
  3. It provides multi-master access where the application can write and read data across the database servers.
  4. It allows backup to be done on the slave without impacting the master.
  5. 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.
Correct answer: BDE
Question 2
You get a Maintenance notification about your Oracle MySQL Cloud Service. What are the implications?
  1. There are no maintenance operations planned. You need to do them manually.
  2. Depending on the planned outage, you may not be affected by it. You need to read the maintenance details in the support notice.
  3. You need to agree to the maintenance windows. If not, you are not affected by the outage.
  4. You can expect an outage of your MySQL Cloud Service during the planned time.
Correct answer: D
Question 3
You use MySQL Enterprise Monitor for a group of MySQL servers. In recent weeks, the MySQL Enterprise Monitor has slowed down significantly. 
Which two preventative actions should you take if your number of monitored MySQL instances has changed?
  1. Increase the disk space with at least 10% of the database size.
  2. Increase the necessary operating system swap space (Linux): mkswap /dev/sdx; swapon/dev/sdx, /etc/fstab.
  3. Increase the amount of RAM available to the JVM installed with Tomcat. The JVM memory settings are defined by the JAVA_OPTS line of the setenv file, which sets the environment variables for Tomcat (--JvmMs/-Xms and –JvmMx/-Xmx).
  4. Tune the InnoDB Buffer Pool of the MySQL Enterprise Monitor Repository database. This can have a significant impact on performance (innodb_buffer_pool_size).
Correct answer: AD
Explanation:
Reference: https://dev.mysql.com/doc/refman/5.6/en/innodb-buffer-pool.html
Reference: https://dev.mysql.com/doc/refman/5.6/en/innodb-buffer-pool.html
Question 4
Your newly created MySQL Cloud Service is not available from your application. Select the two correct options that apply.
  1. You forgot to create the correct SSL/TLC certificate during the setup process.
  2. The ‘opc’ user can be used to access MySQL only with the created SSH-Key.
  3. Only ‘root’ is allowed to access from non-localhost.
  4. The MySQL instance is still in the “Creation” process.
  5. You forgot to enable port 3306.
Correct answer: CE
Question 5
The slave connects to the master and asks for updated records. What command was issued for this to happen?
  1. RUN SLAVE
  2. START RUN SLAVE
  3. SLAVE RUN
  4. SLAVE START
  5. START SLAVE
Correct answer: D
Question 6
Which two architecture options can provide Active/Active Master configuration for the MySQL Database?
  1. Execute the following on the 2x MySQL Server Instances 
    mysql> ALTER REPLICATION set mode= active;
  2. Deploy MySQL Cluster on the following machines: 
    Machine 1: MySQL Node+ MySQL Management Node
    Machine 2: MySQL Node+ MySQL Management Node
    Machine 3: Data Node
    Machine 4: Data Node
    Application can access MySQL Node on Machine 1 or Machine 2 for Active/Active Configuration.
  3. 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 2 
    Application A connecting to MySQL Database Instance 1 for schema db1 
    Application B connecting to MySQL Database Instance 2 for schema db2
  4. Configure MySQL Replication between two MySQL Database instances and setting Replication mode = active.
  5. 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.
Correct answer: CD
Question 7
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?
  1. Go to the configuration section (Users) and create a new user according to the existing users of your new MySQL instances.
  2. 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.
  3. Go to the configuration section (Advisors) and create a new advisor rule for new MySQL instances based on the MySQL Advisor Wizard.
  4. Go to the configuration section (MEM) and configure the default login credentials.
Correct answer: B
Explanation:
Reference: https://docs.oracle.com/cd/E17952_01/mysql-monitor-3.0-relnotes-en/news-3-0-0.html
Reference: https://docs.oracle.com/cd/E17952_01/mysql-monitor-3.0-relnotes-en/news-3-0-0.html
Question 8
Which command in MySQL Utility can perform and start replication among a slave and multiple masters?
  1. mysqlrplcheck
  2. mysqlrplms
  3. mysqlrpladmin
  4. mysqlreplicatems
  5. mysqlreplicate
Correct answer: B
Explanation:
Reference: https://dev.mysql.com/doc/mysql-utilities/1.5/en/mysqlrplms.html
Reference: https://dev.mysql.com/doc/mysql-utilities/1.5/en/mysqlrplms.html
Question 9
The MySQL Cloud Service (CS) is a database offering from Oracle. Which three statements are correct?
  1. MySQL CS is based on an IaaS Oracle Linux image including full root privileges to the OS.
  2. Oracle MySQL Enterprise Tools & Plugins are available as optional services (installation Feature Pack I/II).
  3. MySQL CS is installed based on the Oracle Flexible Architecture Standard.
  4. MySQL CS is based on the MySQL Enterprise Product Suite.
  5. MySQL CS is based on the MySQL GPLv2 version from the Oracle Linux 6 with optimizations for the Cloud (Oracle Flexible Architecture Standard).
  6. MySQL CS configuration can be changed in /etc/my.cnf.
Correct answer: BDF
Question 10
Which three installation options are available for installing the MySQL Enterprise Monitor/Agent on Linux?
  1. A GUI for installing MySQL Enterprise Monitor, Agent, and a MySQL Repository database
  2. A CLI-based wizard MySQL Enterprise Monitor, Agent, and a MySQL Repository database
  3. A script (with an option file) for installing MySQL Enterprise Monitor, Agent, and a MySQL Repository database
  4. A MySQL Enterprise Monitor to remotely deploy the MySQL Monitor Agent
  5. A browser-based wizard to remotely deploy the MySQL Monitor Agent
Correct answer: ABC
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!