Free Oracle 1Z0-920 Exam Dumps Questions & Answers

You get a maintenance-notification about your MySQL Enterprise Edition in Oracle Cloud Infrastructure (OCI) Compute instance. What is re the implication?

• A.  You need to agree to the maintenance windows. If not, you are not affected by the outage.
• B.  Depending on the planned outage, you may not be affected by it. You need to read the maintenance details in the support notice.
• C.  You can expect an outage of your MySQL OCI instance during the planned time..
• D.  There are no maintenance operations planned. You need to do them manually.

Which best describes database horizontal scale-out architecture deployment in MySQL in a read-heavy environment?

• A.  Adding more MySQL servers and sharing the same dacadir on a shared storage component like NFS.
• B.  Deploy MySQL read-only slaves utilizing replication so that the slaves can be used for reads.
• C.  Increasing the memory capacity so that there is a larger pooling buffer to increase the database read performance.
• D.  Allocating more CPU to the database instance to improve throughput performance.
• E.  Increasing the storage capacity so that the database can store more data to scale.

What are Security Lists in Oracle Cloud Infrastructure?

• A.  They contain rules established by HIPAA for securing end-user data.
• B.  They allow administrators access to applications in the cloud and external servers.
• C.  Security lists are data encryption levels that control who can see the data.
• D.  They are essentially firewall rules that help control traffic between OCI instances.
• E.  They are user-role designations that assign rights to certain internal users and external users.

Which three installation options are available for installing the MySQL Enterprise Monitor/Agent on Linux?

• A.  A MySQL Enterprise Monitor to remotely deploy the MySQL Monitor Agent
• B.  A script (with an option file) for installing MySQL Enterprise Monitor, Agent, and a MySQL Repository database
• C.  A browser-based wizard to remotely deploy the MySQL Monitor Agent
• D.  A CLI-based wizard MySQL Enterprise Monitor, Agent, and a MySQL Repository database
• E.  A GUI for installing MySQL Enterprise Monitor, Agent, and a MySQL Repository database

You have a backup image file that is backed up using MySQL Enterprise Backup with the -compress option:
/home/mysq1/backup/full/mybackup/myimage. Img

You are required to perform a database restore to a new machine to provision the database. Which command can provision the new database in the datadir as /home/mysql/data/MEB?

• A. 
• B. 
• C. 
• D. 
• E.