Free Oracle 1Z1-920 Exam Dumps Questions & Answers

The replication for a Master and Slave MySQL Servers is up and running. The disk space for Master Server is continuously growing. The binlog size keeps growing. Which two methods can fix the issue?

• A.  Execute the purge binary logs statement without argument.
• B.  Set the expire_logs_days system variable to expire binary log files automatically after a given number of days.
• C.  On the Master server, disable binlog by removing the --log-bin option.
• D.  To safely purge binary log files, perform these steps:
  1. On each slave server, use show slave status to check which log file it is reading.
  2. Obtain a listing of the binary log files on the master server with show binary logs.
  3. Determine the earliest log file among all the slaves. This is the target file. If all the slaves are up-to-date, this is the last log file on the list.
  4. Make a backup of all the log files you are about to delete. (This step is optional, but always advisable.)
  5. Purge all log files up to but not including the target file by using the purge binary logs statement
• E.  Delete all binlog files manually on the file system to release storage spaces.

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

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

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. 

Which two statements are true about MySQL Enterprise Firewall?

• A.  Server-side plug-ins named MYSQL_FIREWALL_USERS and MYSQL_FIREWALL-WHITELIST implement INFORMATION_SCHEMA tables that provide views into the firewall data cache.
• B.  MySQL Enterprise Firewall is available only in MySQL Enterprise versions 5.7.10.and later.
• C.  On Windows systems, MySQL Enterprise Firewall is controlled and managed by using the Windows Internet Connection Firewall control panel.
• D.  System tables named firewall_users and firewall_whitelist in the mysql database provide persistent storage of firewall data.
• E.  MySQL Enterprise Firewall shows only notifications blocked connections, which originated outside of your network's primary domain.
• F.  The firewall functionality is dependent upon SHA-256 and ANSI-specific functions built in to the mysql.firewall table. These functions cannot be deleted, even by the root user.

Which three are recommended configurations for installing and running MySQL InnoDB Cluster?

• A.  Groups must be in even numbers; 2, 4, 6, 8.
• B.  The number of machines per group must be 3, 5, 7 or 9.
• C.  isolated machine resources
• D.  smaller VM's work best - with a maximum of eight vCPU's and 16GB of RAM
• E.  use SSD's for data and replication logs
• F.  Networks must be in separate regions.
• G.  Use Network-attached storage (NAS) for the data files.