Online Access Free 1Z1-920 Practice Test

The user -os-user'@"localhost" was created to monitor connections and shut down the server, and was granted these privileges:
GRANT PROCESS, SHUTDOWN ON *.* TO "OS-user*@"localhost';
Which three are commands that the os-user can execute?

• A.SHOW PROCESSLIST;
• B.SHOW BINLOG EVENTS;
• C.SHUTDOWN
• D.GRANT PROXY
• E.KILL PROCESS;
• F.SHOW STATUS;

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.MySQL Enterprise Firewall is available only in MySQL Enterprise versions 5.7.10.and later.
• C.MySQL Enterprise Firewall shows only notifications blocked connections, which originated outside of your network's primary domain.
• D.Server-side plug-ins named MYSQL_FIREWALL_USERS and MYSQL_FIREWALL-WHITELIST implement INFORMATION_SCHEMA tables that provide views into the firewall data cache.
• E.System tables named firewall_users and firewall_whitelist in the mysql database provide persistent storage of firewall data.
• F.On Windows systems, MySQL Enterprise Firewall is controlled and managed by using the Windows Internet Connection Firewall control panel.

Which statement would you use to remove the population column from the city table?

• A.ALTER TABLE city DELETE population;
• B.DROP population FROM city;
• C.ALTER TABLE city LESS population;
• D.ALTER TABLE city DROP population;
• E.DELETE population FROM city;

Assume that MySQL Enterprise Monitor is configured to monitor MySQL 8.0.10 or a later instance. Which three features are available?

• A.starting and stopping the MySQL instance
• B.tracing import and export with mysqldump
• C.creating e-mail alerts and SNMP traps for MySQL warnings
• D.deploying MySQL agent on supported target operating system
• E.analyzing executed MySQL queries
• F.monitoring the availability of the MySQL Instance

Which two deployment architectures could you use for scaling-out database reads?

• A.Adding a memcached-tier for caching data and objects in RAM to reduce the number of times an external data source must be read.
• B.Edit the configuration file and increase the value for parallel_read_workers and reboot the server
• C.Implementing a three-node, single-primary InnoDB Cluster.
• D.Changing the system setting with memory stickiness to true in order not to swap out mysq1dfrom memory.
• E.Altering the storage engine for all tables to memory to increase performance.