최신Oracle MySQL 8.0 Database Administrator - 1Z0-908무료샘플문제

A. Use resource groups to lock different instances on separate CPUs.

B. Run mysqld with --datadir defined for each instance.

C. Use systemd with different settings for each instance.

D. Run MySQL Server docker containers.

E. Use system tools to lock each instance to its own CPU.

F. Start mysqld or mysqld_safe using different option files for each instance.

A. Lost tablespace encryption keys can be regenerated only if the master database key is known or present in the Key Vault specification.

B. MySQL TDE uses an appropriate keyring plugin to store the keys in a centralized location.

C. Both MyISAM and InnoDB tables can be encrypted by setting the keyring_engine = ALL variable in the MySQL configuration file.

D. TDE can encrypt InnoDB and MyISAM tables only when the tables are stored in the SYSTEM tablespace.

A. Only internal temporary tables from the optimizer will be created in tmpdir.

B. Temporary tables will use the InnoDB temporary tablespace located in /tmp.

C. Temporary tables are created in tmpdir only after they reach tmp_tabie_size.

D. Temporary tables will use the InnoDB temporary tablespace located in datadir.

E. Temporary tables are created in tmpdir only if configured to use MyISAM.

A. Take a physical backup of the MySQL system.

B. Take a logical backup of the MySQL system.

C. Take your backup from a slave of the MySQL system.

D. Use the Clone Plugin to copy the data to another MySQL system.

A. Increase the number of buffer pool instances to 16.

B. Decrease the number of buffer pool instances to 4.

C. Decrease the number of buffer pool instances to 1.

D. Increase the number of buffer pool instances to 12.

E. Increase the number of buffer pool instances to 32.

A. It supports only non-blob datatypes.

B. It supports all indexes transparently.

C. It decrypts data for use in memory.

D. It does not support the transportable tablespaces feature.

E. It enforces encryption from disk to memory and over network transmission.

A. Use the AES_ENCRYPT() MySQL function on the option file.

B. Use mysql_secure_installation to encrypt stored login credentials.

C. Use mysql_config_editor to create an encrypted file.

D. Use a text editor to create a new defaults file and encrypt it from Linux prompt.

A. ALTER USER user -
IDENTIFIED WITH caching_sha2_password
BY 'password';

B. [mysqld]
default_authentication_plugin=caching_sha2_password

C. [mysqld]
default_authentication_plugin=sha256_password

D. ALTER USER user -
IDENTIFIED WITH mysql_native_password
BY 'password';

E. [mysqld]
default_authentication_plugin=mysql_native_password

F. ALTER USER user -
IDENTIFIED WITH sha256_password -
BY 'password';