1z1-320 무료 덤프문제 온라인 액세스

Select three privileges that are necessary to successfully back up a server instance with the mysqlbackup command after the initial installation.

• A.INDEX
• B.REPLICATION CLIENT
• C.CREATE TEMPORARY TABLES
• D.RELOAD
• E.GRAND OPTION

Identify three features of MySQL Enterprise Backup.

• A.You can validate the results of a MySQL Enterprise Backup to ensure that your backup has integrity.
• B.You can back up individual tables or individual tablespaces with MySQL Enterprise Backup while your server instance is online.
• C.You can back up data that has changed since the last backup with incremental backup.
• D.You can edit the output file produced by a MySQL Enterprise Backup.
• E.You can run the output file produced by a MySQL Enterprise Backup through a MySQL session because the output file consists of SQL statements.

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

Which statement would create an index by using the first 10 characters of the name column in the customer table (assuming that name is a nonbinary string type?)

• A.CREATE INDEX part_of_name ON customer.name LIMIT 10 CHAR;
• B.CREATE INDEX part_of_name ON customer (name(10));
• C.CREATE INDEX (10) ON (customer.name);
• D.CREATE SUB INDEX part_of_name ON (customer, name, 10);
• E.CREATE PARTIAL INDEX part-of_name ON customer (name, 10);

You have installed MySQL 5.6.20 on Windows 2012. This MySQL Instance is monitored without an Enterprise Monitor Agent. You cannot see any MySQL queries. How can you enable this feature?

• A.Use UPDATE performance_schema.setup_consumers SET enabled = 'NO' WHERE name =
  'statements_digest';
• B.Use UPDATE performance_schema.setup_consumers SET enabled = 'YES' WHERE name='statements_digest';
• C.MySQL query analyzing is available only in MySQL Version 5.7 and later. You need a later version of MySQL
• D.For query analyzing, it is mandatory to use a MySQL Enterprise Monitor agent on Windows 2012 Server.