Oracle MySQL 2019 Implementation Essentials - 1Z0-920 Exam Practice Test

A. You forgot to create the correct SSL/TLC certificate during the setup process.

B. Only root is allowed to access from non-localhost.

C. You forgot to enable port 3306.

D. The OCI instance is still in the "creation" process.

E. The opc user can be used to access MySQL only with the created SSH-Key.

A. Use MySQL Enterprise Backup with the - - incremental policy to back up incrementally based on previous full backup.

B. Use mysqldump with the - -changesonly option.

C. Use mysqldump with - -incremental together with the - -compress option to back up incrementally based on previous full backup and compress the incremental backup files.

D. Use MySQL Enterprise Backup with the - -size=compress to compress the backup file.

E. Use MySQL Enterprise Backup with the - -compress option to compress the backup files and use - - compress-level to select the level of compression.

A. MySQL Enterprise Backup does not back up system data so that it is much faster.

B. mysqlbackup can back up tables with the InnoDB engine without blocking. The backup is hot with InnoDB. Together with Incremental Backup, mysqlbackup from MySQL Enterprise Backup shortens the backup windows.

C. mysqlbackup from MySQL Enterprise Backup allows logical backup with concurrency built in to get faster backup speed and restoration speed.

D. MySQL Enterprise Backup provides tape backup integration by default. It has the virtual tape option, which allows backup to tape device directly without extra third-party software integration.

E. mysqlbackup utilities dump the full database into a SQL file, which is imported into the mysql client in single-thread mode. mysqlbackup restores data from physical backups. Physical backup methods are faster than logical methods because they involve only file coping without conversion.

A. connections through the local host via the UNIX socket file

B. authentication using SHA-256 password hashing

C. authentication via Pluggable Authentication Modules (PAMs)

D. Native Windows services

E. SECURID authentication and authorization identity

F. Simple Authentication and Security Layer

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

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

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

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

E. The 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.

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

A. SQL Data Export and Import Wizard

B. Result Data Export and Import

C. Backup Data Export and Import Wizard

D. Data Modeling Import Export Wizard

E. Table Data Export and Import Wizard

F. Binary Data Export and Import Wizard

A. The system generates an error because the COMPRESSION and ENCRYPTION options cannot be used together.

B. The tablespace data is encrypted first and then compression is performed.

C. The compression is performed, the ''data_at_rest_flag" is turned on and the tablespace data is encrypted.

D. The compression is performed before tablespace data is encrypted.