Examice

Exam 1z0-908 All QuestionsBrowse all questions from this exam

Go to Exam

Question 107

What is the correct syntax for using transparent data encryption with an existing InnoDB table?

ALTER TABLE t1 ADD ENCRYPTED_TABLESPACE = 'Y';

ALTER TABLE t1 ENCRYPTION='Y';

ALTER TABLE t1 WITH ENCRYPTION USING MASTER KEY;

ALTER TABLE t1 SET TDE = 'ON';

Correct Answer: B

To enable transparent data encryption (TDE) on an existing InnoDB table, the correct syntax is ALTER TABLE t1 ENCRYPTION='Y';. This command modifies the table to use encryption.

Discussion

DhanushkaOption: B

To alter the encryption of an existing file-per-table tablespace, an ENCRYPTION clause must be specified. mysql> ALTER TABLE t1 ENCRYPTION = 'Y';

FelipeKOption: B

Run a tablespace encryption operation. In this example, a general tablespace named ts1 is encrypted. mysql> ALTER TABLESPACE ts1 ENCRYPTION = 'Y'; https://dev.mysql.com/doc/refman/8.0/en/innodb-data-encryption.html

marklvOption: B

ALTER TABLE t1 ENCRYPTION = 'Y'; B