Want to pass your MySQL 2019 Implementation Essentials 1Z0-920 exam in the very first attempt? Try Pass2lead! It is equally effective for both starters and IT professionals.
VCE
Which three are characteristics of the JSON data type?
A. A set of SQL functions substantially support the SQL utilization of the data type.
B. It supports indexing directly against the JSON-defined column.
C. It validates the JSON syntax on insert or merge.
D. Comparisons of JSON values are not case-sensitive.
E. Key or array references enable quick read-access to look up document elements directly.
F. It is based on the TEXT data type.
Which three statements describe MySQL Enterprise Backup?
A. MySQL Enterprise Backup can be used to import/export data from on-premises MySQL installations.
B. MySQL Enterprise Backup provides the point-in-time recovery functionality.
C. MySQL Enterprise Backup can be used to send backups to Oracle Cloud Infrastructure Storage Service.
D. MySQL Enterprise Backup offers backup based on Oracle RMAN with optimized row locking.
E. MySQL Enterprise Backup is an optimized backup based on mysqldump with optimized row locking.
Which three are requirements for MySQL Group Replication (GR)?
A. Data to be replicated must be stored in the InnoDB transactional storage engine.
B. The use of global transaction identifiers is required.
C. Primary keys are required on every replicated table.
D. GR only works with MySQL versions 8.0.12 or higher.
E. The binary log format must be set to mixed.
F. The minimum number of required nodes for achieving a consensus is two.