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. On the Master server, disable binlog by removing the --log-bin option.
B. Set the expire_logs_days system variable to expire binary log files automatically after a given number of days.
C. 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
D. Execute the purge binary logs statement without argument.
E. Delete all binlog files manually on the file system to release storage spaces.
What is true about MySQL Enterprise Transparent Data Encryption (TDE)?
A. Data is encrypted automatically, in real time, after it is written to storage.
B. Enables data-at-rest encryption by encrypting the physical files of the database.
C. Encryption key is stored in a centralized key memory location
D. Tablespace keys are managed manually behind the scenes.
Your newly-created Oracle Cloud Infrastructure instance is not available for login in. Which is a valid reason for this issue?
A. You forgot to enable port 3306.
B. The opc user can be used to access MySQL only with the created SSH-Key.
C. Only root is allowed to access from non-localhost.
D. You forgot to create the correct SSL/TLC certificate during the setup process.
E. The OCI instance is still in the "creation" process.
You need to change the password level for a test system. Which two allow to change this level before you create new test user/passwords?
A. Add validate_password='new level' in the [security] section of the MySQL configuration file.
B. SET GLOBAL validate_password_policy='new level';
C. SET GLOBAL force_password_complex_policy=0;
D. Add validate_password_policy='new level' in the [mysqld] section of the MySQL configuration file.
Which is a correct example of creating an Enterprise Encryption function?
A. SET @function = CREATE_ASYMMETRIC_PRIV_KEY(@algo, @key_len);
B. CREATE FUNCTION asymmetric_decrypt RETURNS STRING SONAME 'openss1_udf.so';
C. INSERT INTO t1 (key_co1) FUNCTION(CREATE_ASYMMETRIC_PRIV_KEY('RSA', 1024));
D. VALIDATE FUNCTION create_asymmetric_priv_key WITH 'openssl_udf.so';
You have three machines with MySQL Databases running on Linux platform. Which backup procedures would allow online and remote backup of the MySQL Database on the three machines to a connected Storage NFS?
A. 1. Mount the Remote Storage NFS volume to each of the three machines with proper privilege for the backup OS user to have all access.
2.
Install MySQL Enterprise Backup on machine which is used to start the backup.
3.
Start mysqlbackup on only one machine with the installation to back up the databases for the three machines to the mounted volume using - -backup-dir and by giving-- hosts=machine1:port1, machine2:port2, machine3:port3.
4.
Validate the backups using the mysqlbackup program to ensure that the backups created are valid.
B. 1. Mount the Remote Storage NFS volume to each of the three machines with proper privilege for the backup OS user to have all access.
2.
Install MySQL Enterprise Backup on all three machines.
3.
Start mysqlbackup on all machines to back up the database to the mounted volume using - -backupdir.
4.
Validate the backup using the mysqlbackup program to ensure that the backup created is valid.
C. 1. Mount the Remote Storage NFS volume to each of the three machines with proper privilege for the backup OS user to have all access.
2.
Install MySQL Enterprise Backup on the machine that is used to start the backup.
3.
Start mysqlbackup on only one machine with the installation to back up the databases for the three machines to the mounted volume using - - backup-dir and by specifying -- config-files=my1.cnf, my2.cnf, my3.cnf.my1.cnf, my2cnf, and my3.cnf are the MySQL Database Configuration files on the three machines.
4.
Validate the backup by using the mysqlbackup program to ensure that the backup created is valid.
D. 1. Mount the Remote Storage NFS volume to each of the three machines with proper privilege for the backup OS user to have all access.
2.
Install MySQL Workbench on a separate machine, which is used to connect to the three machines to back up and restore.
3.
Startup MySQL backup from MySQL Workbench to back up the three databases.
4.
Validate the backup by using MySQL Workbench to ensure that the backup created is valid.
Which best describes database horizontal scale-out architecture deployment in MySQL in a read- heavy environment?
A. Allocating more CPU to the database instance to improve throughput performance.
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. Adding more MySQL servers and sharing the same dacadir on a shared storage component like NFS.
E. Increasing the storage capacity so that the database can store more data to scale.
Which three are levels in which MySQL Enterprise Monitor provides access control?
A. MySQL Enterprise Operations: the right to start/stop/restart/update MySQL Enterprise Monitor Services
B. Asset visibility: the rights to access data collected from hosts or MySQL instances
C. Application administration: the rights to view or change the MySQL Enterprise Monitor configuration
D. Specific data access: the rights to view specific types of potentially sensitive data
E. MySQL Enterprise Operations: the right to deploy the necessary MySQL Enterprise Agent
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
Which features of MySQL Enterprise Edition should you use to proactively monitor and track data changes in your databases?
A. MySQL Enterprise Monitor and MySQL Audit
B. MySQL Workbench and MySQL Enterprise Firewall
C. MySQL Audit and MySQL Workbench
D. SQL Enterprise Monitor and MySQL Enterprise Authentication
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only Oracle exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your 1Z0-920 exam preparations and Oracle certification application, do not hesitate to visit our Vcedump.com to find your solutions here.