You establish MySQL Enterprise Server on Oracle Cloud Infrastructure connection via Secure Shell (SSH).
When accessing a new MySQL Enterprise Edition Oracle Cloud Infrastructure (OCI) instance, you want to use MySQL Enterprise Workbench for SQL and remote management.
What are two ways to successfully configure Workbench based on the MySQL access credentials?

• A.Convert the private key to ppk format first. Based on TCP/IP over SSH and based on the created private key, opc-user, and MySQL access credentials, you can access the MySQL CS instance.
• B.Configure TCP/IP over SSH and based on the created private key, opc-User, and MySQL access credentials, you can access the MySQL OCI instance.
• C.Configure the MySQL Router first and based on those settings, you access your MySQL CS instance.
• D.Open the MySQL OCI instance access port 3306. For the MySQL connection, you use this port, and, in addition, you configure the remote management based on SSH based on the provided key.

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *

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?

• A.SET GLOBAL validate_password_policy='new level';
• B.SET GLOBAL force_password_complex_policy=0;
• C.Add validate_password_policy='new level' in the [mysqld] section of the MySQL configuration file.
• D.Add validate_password='new level' in the [security] section of the MySQL configuration file.

Comment: *

Name: *

Email: *

Verification: *

You want to change the default behavior of MySQL Enterprise Monitor (MEM). New instances detected by a MEM agent should automatically monitor discovered instances.
How can you change the Advisor Setting?

• A.Go to the configuration section (Users) and create a new user according to the existing users of your new MySQL instances.
• B.Go to the configuration section (MEM) and configure the default login credentials.
• C.Go to the configuration section (Advisors) and create a new advisor rule for new MySQL instances based on the MySQL Advisor Wizard.
• D.Go to the configuration section (Advisors) and edit the default settings of the MySQL Process Discovery according to the existing users of your new MySQL instances.

Comment: *

Name: *

Email: *

Verification: *

What three are ways to export and import data in MySQL Workbench?

• A.Result Data Export and Import
• B.Binary Data Export and Import Wizard
• C.SQL Data Export and Import Wizard
• D.Backup Data Export and Import Wizard
• E.Table Data Export and Import Wizard
• F.Data Modeling Import Export Wizard

Comment: *

Name: *

Email: *

Verification: *