1Z0-921 試験問題を無料オンラインアクセス

Which activity will take place if a table is created with both the compression and encryption options?

• A.The compression is performed before tablespace data is encrypted.
• B.The tablespace data is encrypted first and then compression is performed.
• C.The system generates an error because the COMPRESSION and ENCRYPTION options cannot be used together.
• D.The compression is performed, the ''data_at_rest_flag" is turned on and the tablespace data is encrypted.

Which two methods help prevent MySQL security risks?

• A.Use the secure installation script "mysql_alays_secure_installation".
• B.Ensure that MySQL accounts have short and easy passwords.
• C.Transmit plain (unencrypted) data over networks.
• D.Use a firewall to control access to MySQL ports.
• E.Allow unauthorized clients to connect to the server.
• F.Grant only permissions that a user requires.

Which statement is used to create a new MySQL database?
Response:

• A.CREATE SCHEMA
• B.CREATE TABLE
• C.CREATE DATABASE
• D.NEW DATABASE

You are testing a new application and want to use data masking but the database is empty. What option will generate dummy data for you to use for testing?

• A.Execute the sakila-data. sqi script to populate the database
• B.Use MySQL Enterprise High Availability to access one of the available data tables
• C.Alter the table with the statement: ALTER TABLE IMPORT DATA WITH data_masking plugin;
• D.Use mysqldump to import data from the sakila_dummy database sample data set.

You want to create an encrypted table. So, you enter this command:
CREATE TABLE 'test_encryption2% (
'id' int(10) unsigned NOT NULL AUTO_INCREMENT,
'server_name' varchar(15) NOT NULL,
PRIMARY KEY ('id') ) ENGINE=MYISAM AUTO_INCREMENT=l DEFAULT CHARSET=latin1 ENCRYPTION = 'Y1; You receive the following error:
ERROR 1031 (HY000): Table storage engine for 'test_encryption2' doesn't have this option Which statement correctly explains the reason for this error?

• A.The encryption feature only works with InnoDB tables. You are creating a MylSAM table, and it is causing the error.
• B.The term "server_name" is a reserved MySQL term. You cannot use it for the new table. This is what is causing the error.
• C.You cannot use the AUTO_INCREMENT option to create an encrypted table. This is what is causing the error.
• D.The test_encryption2 already exist. You are not using the correct option to recreate it and it is causing the error.