1Z0-920 Online Practice Questions and Answers
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 statement would you use to remove the population column from the city table?
A. ALTER TABLE city DROP population;
B. DELETE population FROM city;
C. ALTER TABLE city DELETE population;
D. ALTER TABLE city LESS population;
E. DROP population FROM city;
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';
The MySQL Replication Environment (Master and Slave) is prepared. What two are options for connecting a Java application to the MySQL Master and Slave?
A. Option A
B. Option B
C. Option C
D. Option D
Which three are recommended configurations for installing and running MySQL InnoDB Cluster?
A. The number of machines per group must be 3, 5, 7 or 9.
B. use SSD's for data and replication logs
C. Groups must be in even numbers; 2, 4, 6, 8.
D. isolated machine resources
E. Use Network-attached storage (NAS) for the data files.
F. smaller VM's work best - with a maximum of eight vCPU's and 16GB of RAM
G. Networks must be in separate regions.
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 SQL keyword must be specified when creating a foreign key constraint?
A. a TRIGGER on the child table for cascading delete statements
B. a REFERENCES in the child table to the parent table
C. unique PRIMARY key values for both child and parent tables
D. the SET_FOREGIN variable in the my .cnf file
E. an index on the foreign key
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)
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
Which two statements about the download of MySQL Enterprise Backup are correct?
A. MySQL Enterprise Backup can be downloaded from My Oracle Support (MOS).
B. MySQL Enterprise Backup comes with MySQL Utilities Package, which is available for download publicly on http://www.mysql.com.
C. MySQL Enterprise Backup is a separate package from MySQL Enterprise Edition. It can be downloaded from https://edelivery.oracle.com.
D. MySQL Enterprise Backup comes with all MySQL editions including community edition.
E. MySQL Enterprise Backup comes with MySQL Connector and is freely available for download.