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?
A. misspelling
B. strict or relaxed masking
C. random data substitution
D. whitelisting and substitution
E. dictionary substitution
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 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?
A. audit_log_permanent=ON
B. audit-log=FORCE_PLUS_PERMANENT
C. plugin-load=audit_log.so
D. plugin-audit=ON, ALWAYS
E. LOAD PLUGIN=AUDIT_LOG
Which three installation options are available for installing the MySQL Enterprise Monitor/Agent on Linux?
A. A GUI for installing MySQL Enterprise Monitor, Agent, and a MySQL Repository database
B. A CLI-based wizard MySQL Enterprise Monitor, Agent, and a MySQL Repository database
C. A script (with an option file) for installing MySQL Enterprise Monitor, Agent, and a MySQL Repository database
D. A MySQL Enterprise Monitor to remotely deploy the MySQL Monitor Agent
E. A browser-based wizard to remotely deploy the MySQL Monitor Agent
What are two ways in which customers can receive notifications such as outages, configuration changes, database emergencies, and other information on their Database as a Service instances?
A. Email
B. Browser pop-ups
C. Direct support call from an Oracle representative
D. SMS-notification tab on the dashboard
E. Application-to-application messaging
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. Option A
B. Option B
C. Option C
D. Option D
E. Option E
Which two deployment architectures could you use for scaling-out database reads?
A. Implementing a three-node, single-primary InnoDB Cluster.
B. Edit the configuration file and increase the value for parallel_read_workers and reboot the server
C. Changing the system setting with memory stickiness to true in order not to swap out mysq1dfrom memory.
D. Altering the storage engine for all tables to memory to increase performance.
E. Adding a memcached-tier for caching data and objects in RAM to reduce the number of times an external data source must be read.
You want to create the user named jenny for any host server with the password secretpassi23! and the password is expired? Which command should you use?
A. CREATE USER 'jenny'@'%' IDENTIFIED WITH sha256_password BY `SecretPass123!';
B. CREATE USER ,jenny,0,%t IDENTIFIED BY 'SecretPass123!' PASSWORD EXPIRE;
C. CREATE USER 'jenny'@'%' WITH HASHED(password,'SecretPass123!'), PASSWORD EXPIRE
D. CREATE USER 'jenny *@'localhost' IDENTIFIED WITH HASH PASSWORD('SecretPass123!')
E. CREATE USER 'jenny'@'localhost' IDENTIFIED BY ('SecretPass123!','256', Expired)
The MySQL Enterprise Monitor Agent requires a user configured in each MySQL instance that is being
monitored with suitable privileges to collect information about the server.
Which statement is correct?
A. The super privilege is required when starting, stopping, or restarting monitored MySQL databases.
B. MySQL Enterprise Monitor creates the required users automatically.
C. The super privilege is required when creating and populating the inventory table, as well as running statements such as show master logs or SHOW ENGINE INNODB STATUS.
D. Monitoring metrics need super and root privileges because they are not available for a less- privileged user.
Which MySQL Enterprise Edition plug-in replaces real values with substitutes?
A. MySQL Enterprise Audit
B. MySQL Enterprise Scalability
C. MySQL Enterprise No-Login Authentication
D. MySQL Enterprise Transparent Data Encryption (TDE)
E. MySQL Enterprise Data Masking and De-identification