Which statement adds a column with the largest integer data type?

• A.ALTER TABLE SCIENTIFIC ADD scientific_value DECIMAL(10,10);
• B.ALTER TABLE SCIENTIFIC ADD scientific_value BIGINT;
• C.ALTER TABLE SCIENTIFIC ADD scientific_value INTEGER;
• D.ALTER TABLE SCIENTIFIC ADD scientific_value DECIMAL(15,10);

Comment: *

Name: *

Email: *

Verification: *

Which four authentication protocols are allowed when using MySQL Enterprise Authentication?

• A.Native Windows services
• B.authentication via Pluggable Authentication Modules (PAMs)
• C.Simple Authentication and Security Layer
• D.SECURID authentication and authorization identity
• E.authentication using SHA-256 password hashing
• F.connections through the local host via the UNIX socket file

Comment: *

Name: *

Email: *

Verification: *

What is true about MySQL Enterprise Transparent Data Encryption (TDE)?

• A.Enables data-at-rest encryption by encrypting the physical files of the database.
• B.Data is encrypted automatically, in real time, after it is written to storage.
• C.Tablespace keys are managed manually behind the scenes.
• D.Encryption key is stored in a centralized key memory location

Comment: *

Name: *

Email: *

Verification: *

Which three components can MySQL InnoDB Cluster use to Achieve database high availability?

• A.MySQL Servers with Group Replication to replicate data to all members of the cluster.
• B.MySQL Online Hot Backup to keep data consistent and always ready to be used.
• C.MySQL Shell to create and administer InnoDB Clusters using the built-in AdminAPI.
• D.MySQL X Plugin to enable MySQL to use the X Protocol to speed up and monitor data replication.
• E.MySQL Router to ensure client requests are load balanced and routed to the correct servers.

Comment: *

Name: *

Email: *

Verification: *

By using the asynchronous MySQL Replication architecture, data can be replicated to slaves. Identify three use cases of MySQL Replication.

• A.It provides multi-master access where the application can write and read data across the database servers.
• B.You can create a slave server for reporting applications, which get only read access to the slave servers. It off-loads the master server. Additional servers allow different database server configuration.
• C.It allows backup to be done on the slave without impacting the master.
• D.MySQL Enterprise Backup will back up from Slave automatically.
• E.MySQL Replication Connector/J (ReplicationDriver) is provided to allow read capability on slave and write capability on master.

Comment: *

Name: *

Email: *

Verification: *