Free MySQL 2019 Implementation Essentials Exam 1Z0-920 Exam Practice Test

MySQL Enterprise Masking and De-identification can hide or obfuscate sensitive data, by controlling how the data appears. Which three are MySQL Enterprise Masking and De-identification functions?

• misspelling
• strict or relaxed masking
• random data substitution
• whitelisting and substitution
• dictionary substitution

The user -os-user'@'localhost' was created to monitor connections and shut down the server, and was granted these privileges:GRANT PROCESS, SHUTDOWN ON *.* TO 'OS-user*@'localhost';Which three are commands that the os-user can execute?

• SHOW PROCESSLIST;
• SHUTDOWN
• SHOW STATUS;
• SHOW BINLOG EVENTS;
• KILL PROCESS;
• GRANT PROXY

Which Oracle product is certified to work with MySQL Enterprise Edition?

• Oracle Enterprise Backup
• Oracle Data Pump
• Oracle Enterprise Manager
• Oracle Application Express

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

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

When using an Oracle Cloud Infrastructure Compute Instance with MySQL Enterprise Edition installed, you have two choices for backup destinations. What are these two choices?

• Flash-archive recovery area
• Cloud storage only
• Cloud tape library
• Both Cloud storage and local storage

You need to load the MySQL Enterprise Audit plug-in at database startup and prevent the audit plug-in from being removed at run time.Which two options should you include in the MySQL configuration file?

• audit_log_permanent=ON
• audit-log=FORCE_PLUS_PERMANENT
• plugin-load=audit_log.so
• plugin-audit=ON, ALWAYS
• LOAD PLUGIN=AUDIT_LOG

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?

• On the Master server, disable binlog by removing the --log-bin option.
• Set the expire_logs_days system variable to expire binary log files automatically after a given number of days.
• 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
• Execute the purge binary logs statement without argument.
• Delete all binlog files manually on the file system to release storage spaces.

Which statement will display the status of the partitioning plug-in?

• SHOW STATUS PLUGINS WHERE Name= 'PARTITIONING';
• SHOW PLUGINS WHERE Name= 'partition';
• SELECT PLUGIN_NAME, PLUGIN_VERSION, PLUGIN_STATUS FROM INFOMRATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME= 'partition';
• USE SYS SCHEMA; SHOW PLUGINS STATUS;

Which three prerequisites are needed for creating an Oracle Linux VM instance in the Oracle Cloud Infrastructure?

• Custom Image
• Object Storage
• existing VCN
• bare metal Oracle Linux shape
• ssh key pair
• subnet configured on a Virtual Cloud Network (VCN)

You are testing a new application and want to use data masking but the database is empty. What option will generate dummy data for you to use for testing?

• Execute the sakila-data. sqi script to populate the database
• Alter the table with the statement: ALTER TABLE IMPORT DATA WITH data_masking plugin;
• Use MySQL Enterprise High Availability to access one of the available data tables
• Use mysqldump to import data from the sakila_dummy database sample data set.