A. MySQL Enterprise Data Masking and De-identification
B. MySQL Enterprise Audit
C. MySQL Enterprise Transparent Data Encryption (TDE)
D. MySQL Enterprise No-Login Authentication
E. MySQL Enterprise Scalability
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. Allocating more CPU to the database instance to improve throughput performance.
D. Increasing the memory capacity so that there is a larger pooling buffer to increase the database read performance.
E. Deploy MySQL read-only slaves utilizing replication so that the slaves can be used for reads.
A. /var/lib/mysql/innodb
B. /usr/redo
C. /etc/my.cnf
D. /usr/mysql
E. /var/lib/mysql
F. /usr/bin/logs
A. MySQL can store XML as a schema-less database
B. MySQL provides a native data type to index PDF documents
C. MySQL provides a NoSQL API to access the document store
D. MySQL is a document database allowing PDF and Word documents
E. MySQL provides a native data type to store JSON data as a document
A. You cannot insert a single line, you have to replace the entire document with a new document.
B. Any new lines can only be inserted at the end of the document.
C. You specify the new element's position in the JSON_ARRAY_INSERT statement.
D. The path specified must be an array position past the end of an array using the JSON_POSITION statement.
A. START SLAVE
B. SLAVE START
C. RUN SLAVE
D. SLAVE RUN
E. START RUN SLAVE
A. Add --default_authentication_plugin=sha256_password on the command line when you invoke the server.
B. Create user by using CREATE USER 'newuser' @'localhost' SET PASSWORD AS 'Sh@256Pa33';
C. Add default_authentication_plugin=sha256_password under [mysqld] in the configuration file.
D. Create user by using CREATE USER 'newuser'@'localhost' IDENTIFIED WITH 'Sh@256Pa33';
