Online Access Free 1z1-320 Practice Test

For accessing a new default MySQL Cloud Service (CS) cloud environment, you used the "Create SSH Keys function" during the guided MySQL CS setup. You want to use Putty from your Windows Client. Identify the correct steps.

• A.Convert the private key to ppk format first, and use the new private key for authentication.
• B.Use the provided private key for authentication.
• C.Open Port 22 on your MySQL CS Instance and convert the private key to ppk format. This new private key can be used for authentication.
• D.You open Port 22 on your MySQL CS Instance and configure Putty with the provided private key.

A Cloud customer already has many database instances configured and running in the cloud, however, they are reporting that they are unable to create any more instances.
What could be the problem?

• A.The customer does not have proper user rights.
• B.The customer has not kept up with their patching requirements; new instances cannot be created unless the majority or the template of existing instances are up-to date.
• C.The customer account might have reached its compute quota.
• D.The customer reached the database instance limit of 32.

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 (MEM) and configure the default login credentials.
• B.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.
• C.Go to the configuration section (Users) and create a new user according to the existing users of your new MySQL instances.
• D.Go to the configuration section (Advisors) and create a new advisor rule for new MySQL instances based on the MySQL Advisor Wizard.

You want to create a copy of the City table and include all the data. The new table name is City_part. Which statement would accomplish this task?

• A.INSERT INTO City_part SELECT * FROM City;
• B.CREATE TABLE City_part LIKE City INSERT INTO City_part * FROM City;
• C.CREATE TABLE City_part LIKE City;
• D.CREATE TABLE City_part AS SELECT * FROM City;

You have been using mysqldump for logical backups of your MySQL databases. Your MySQL database size has been growing.
Which two options can reduce the backup size and speed up the backup time?

• A.Use mysqldump with - -incremental together with the - -compress option to back up incrementally based on previous full backup and compress the incremental backup files.
• B.Use MySQL Enterprise Backup with the - -size=compress to compress the backup file.
• C.Use MySQL Enterprise Backup with the - - incremental policy to back up incrementally based on previous full backup.
• D.Use mysqldump with the - -changesonly option.
• E.Use MySQL Enterprise Backup with the - -compress option to compress the backup files and use - - compress-level to select the level of compression.