Question No. 1

Which MySQL Enterprise Edition plug-in replaces real values with substitutes?

AMySQL Enterprise Audit

BMySQL Enterprise Scalability

CMySQL Enterprise No-Login Authentication

DMySQL Enterprise Transparent Data Encryption (TDE)

EMySQL Enterprise Data Masking and De-identification

Show Answer

Correct Answer: E

New!MySQL Enterprise Masking and De-identification

MySQL Enterprise Masking and De-identification provides an easy to use, built-in database solution to help organizations protect sensitive data from unauthorized uses by hiding and replacing real values with substitutes.

https://www.mysql.com/products/enterprise/#:~:text=New!&text=MySQL%20Enterprise%20Masking%20and%20De%2Didentification%20provides%20an%20easy%20to,replacing%20real%20values%20with%20substitutes.

Question No. 2

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?

AAdd validate_password='new level' in the [security] section of the MySQL configuration file.

BSET GLOBAL validate_password_policy='new level';

CSET GLOBAL force_password_complex_policy=0;

DAdd validate_password_policy='new level' in the [mysqld] section of the MySQL configuration file.

Show Answer

Correct Answer: B, D

Question No. 3

Which two statements are true about MySQL Enterprise Firewall?

AOn Windows systems, MySQL Enterprise Firewall is controlled and managed by using the Windows Internet Connection Firewall control panel.

BThe firewall functionality is dependent upon SHA-256 and ANSI-specific functions built in to the mysql.firewall table. These functions cannot be deleted, even by the root user.

CMySQL Enterprise Firewall is available only in MySQL Enterprise versions 5.7.10.and later.

DServer-side plug-ins named MYSQL_FIREWALL_USERS and MYSQL_FIREWALL-WHITELIST implement INFORMATION_SCHEMA tables that provide views into the firewall data cache.

ESystem tables named firewall_users and firewall_whitelist in the mysql database provide persistent storage of firewall data.

FMySQL Enterprise Firewall shows only notifications blocked connections, which originated outside of your network's primary domain.

Show Answer

Correct Answer: D, E

Question No. 4

Which is true about inserting an additional line in a single document stored in MySQL document store?

AYou specify the new element's position in the JSON_ARRAY_INSERT statement.

BAny new lines can only be inserted at the end of the document.

CYou cannot insert a single line, you have to replace the entire document with a new document.

DThe path specified must be an array position past the end of an array using the JSON_POSITION statement.

Show Answer

Correct Answer: A

Question No. 5

The slave connects to the master and asks for updated records. What command was issued for this to happen?

ASLAVE RUN

BSLAVE START

CSTART RUN SLAVE

DRUN SLAVE

ESTART SLAVE

Show Answer

Correct Answer: B

Free Oracle 1Z0-920 Exam Actual Questions

The questions for 1Z0-920 were last updated On Nov 7, 2024