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

Which three backup scenarios can be accommodated with MySQL Enterprise Backup? (Choose three.)

• A.making partial backup and optimistic backup
• B.making a single file backup by creating backups in single-file format
• C.creating a cloud backup
• D.converting a database backup from another database vendor to MySQL
• E.making a backup directly into tape device by using MySQL Enterprise Backup Media Management Software (MMS)

Which two statements are true about MySQL Enterprise Firewall?

• A.The firewall functionality is dependent upon SHA-256 and ANSI-specific functions built in to the mysql.firewall table. These functions cannot be deleted, even by the root user.
• B.On Windows systems, MySQL Enterprise Firewall is controlled and managed by using the Windows Internet Connection Firewall control panel.
• C.Server-side plug-ins named MYSQL_FIREWALL_USERS and MYSQL_FIREWALL-WHITELIST implement INFORMATION_SCHEMA tables that provide views into the firewall data cache.
• D.System tables named firewall_users and firewall_whitelist in the mysql database provide persistent storage of firewall data.
• E.MySQL Enterprise Firewall shows only notifications blocked connections, which originated outside of your network's primary domain.
• F.MySQL Enterprise Firewall is available only in MySQL Enterprise versions 5.7.10.and later.

By using the asynchronous MySQL Replication architecture, data can be replicated to slaves. Identify three use cases of MySQL Replication.

• A.It allows backup to be done on the slave without impacting the master.
• B.It provides multi-master access where the application can write and read data across the database servers.
• C.MySQL Replication Connector/J (ReplicationDriver) is provided to allow read capability on slave and write capability on master.
• D.MySQL Enterprise Backup will back up from Slave automatically.
• E.You can create a slave server for reporting applications, which get only read access to the slave servers.
  It off-loads the master server. Additional servers allow different database server configuration.

You want to monitor SQL statements, which are executed on the MySQL server, in MySQL Enterprise Monitor (MEM).
Select three possible ways.

• A.Configure the MySQL Router to send normalized SQL statements to MEM.
• B.Configure the Performance Schema statement digests with MySQL Server 5.6.14 or later.
• C.Configure a MySQL Connector that sends information directly to MySQL Enterprise Service Manager.
• D.Configure MySQL to replicate data via the MySQL binlog to MEM.
• E.Route MySQL SQL statements through a MySQL Monitor Proxy.

What command should be used to execute a stored procedure named run_daily_report with the parameter
2016/12/31?

• A.EXECUTE PROC run_daily_report INCLUDE PARAMETER ('2016/12/31');
• B.UPDATE PROCEDURE run_daily_report WHERE VARIABLE = ("2016/12/31');
• C.CALL run_daily_report ('2016/12/31');
• D.SELECT SP run_daily_report ('2016/12/31') from mysql.procedures;