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

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

Comment: *

Name: *

Email: *

Verification: *

Which three are recommended configurations for installing and running MySQL InnoDB Cluster?

• A.Use Network-attached storage (NAS) for the data files.
• B.Groups must be in even numbers; 2, 4, 6, 8.
• C.use SSD's for data and replication logs
• D.Networks must be in separate regions.
• E.isolated machine resources
• F.The number of machines per group must be 3, 5, 7 or 9.
• G.smaller VM's work best - with a maximum of eight vCPU's and 16GB of RAM

Comment: *

Name: *

Email: *

Verification: *

Which three are characteristics of the JSON data type?

• A.Comparisons of JSON values are not case-sensitive.
• B.It supports indexing directly against the JSON-defined column.
• C.Key or array references enable quick read-access to look up document elements directly.
• D.It is based on the TEXT data type.
• E.It validates the JSON syntax on insert or merge.
• F.A set of SQL functions substantially support the SQL utilization of the data type.

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about MySQL Enterprise Firewall?

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

Comment: *

Name: *

Email: *

Verification: *

The user 'fwuser'@'localhost% was registered with the MySQL Enterprise Firewall and was granted privileges for the SAKILA database. You executed the commands:

You want to clear the account whitelist for the * fwuser" @* localhost* user. Which statement should you run to accomplish this?
A)

B)

C)

D)

• A.Option B
• B.Option C
• C.Option A
• D.Option D

Comment: *

Name: *

Email: *

Verification: *