Online Access Free 1z1-320 Exam Questions

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

• A.Lost tablespace encryption keys can be regenerated only if the master database key is known or present in the KEY VAULT file.
• B.TDE can encrypt InnoDB and MyISAM tables only when the tables are stored in the SYSTEM tablespace.
• C.Both MyISAM and InnoDB table can be encrypted by setting the keyring_engine =ALL variable in the MySQL configuration file.
• D.TDE supports at-rest encryption for InnoDB tables stored in file-per-table tablespaces.

You are requested to export data from a set of the following tables in the database 'world_x'.
Tables (country, countryinfo, location)
Which two options would allow you to export data as files?

• A.using MySQL Client and EXPORT <table> TO <file> to export data one by one:mysql>EXPORT world_x.country TO '/output/country.txt';mysql>EXPORT world_x.countryinfo TO
  '/output/countryinfo.txt';mysql>EXPORT world_x.location TO '/output/location.txt';
• B.using mysqlexport to export multiple tables in a database in one command line:# mysqlexport -u<user>- h<host> -P<port> -p world_x country countryinfo location> mydump.sql
• C.using MySQL Client and SELECT ...INTO OUTFILE '<filename>' from <TABLE> to export data one by one:mysql>select * into outfile '/output/country.txt' from world_x.country;mysql>select * into outfile '/output/countryinfo.txt' from world_x.countryinfo;mysql>select * into outfile
  '/output/location.txt' from world_x.location;
• D.using MySQL Client and the - -dump option to dump the tables to files:# mysql -u<user> -p -h<host>
  -P<port> -- dump world_x.country world_x.countryinfo world_x.location
• E.using mysqldump to dump multiple tables in a database in one command line:# mysqldump -u<user>- h<host> -P<port> -p world_x country countryinfo location> mydump.sql

Which three are part of the core MySQL architecture? (Choose three.)

• A.Storage engines
• B.mysqldump
• C.Optimizer
• D.Disk parity/RAID
• E.Parser

You want to create a copy of the City table and include all the data. The new table name is City_part. Which statement would accomplish this task?

• A.CREATE TABLE City_part LIKE City INSERT INTO City_part * FROM City;
• B.CREATE TABLE City_part LIKE City;
• C.CREATE TABLE City_part AS SELECT * FROM City;
• D.INSERT INTO City_part SELECT * FROM City;

You have been using mysqldump for logical backups of your MySQL databases. Your MySQL database size has been growing.
Which two options can reduce the backup size and speed up the backup time?

• A.Use mysqldump with the - -changesonly option.
• B.Use MySQL Enterprise Backup with the - -size=compress to compress the backup file.
• C.Use mysqldump with - -incremental together with the - -compress option to back up incrementally based on previous full backup and compress the incremental backup files.
• D.Use MySQL Enterprise Backup with the - -compress option to compress the backup files and use - - compress-level to select the level of compression.
• E.Use MySQL Enterprise Backup with the - - incremental policy to back up incrementally based on previous full backup.