Prepare with latest Oracle 1z1-320 Pass-King Actual Torrent

MySQL Replication Environment (Master and Slave) is prepared. What are the two options for connecting a Java application to the MySQL Master and Slave?

• A. Use MySQL Connector/J with the com.mysql.jdbc.ReplicationDriver with JDBC URL asjdbc:mysql:replication://[mater host] [:port], [slave host 1] [:port] [, [slave host 2] [:port]] ...
  [/[database]] [? propertyName=propertyValue1 [&propertyName2-propertyValue2]...]
• B. Use MySQL Router with the following
  configuration:[DEFAULT]logging_folder=/var/log/mysqlrouter[logger]level=INFO[routing:
  failover]bind_port = 7001mode=read-writedestinations= master:3306, slave:3306The Java application can connect to bind_port=7001.
• C. Use MySQL Router with the following configuration:[DEFAULT]logging_folder=
  /var/log/mysqlrouter[logger]level=INFO[routing: failover]bind_port =
  7001mode=replicationdestinations=master:3306, slave:3306The Java application can connect to bind_port=7001
• D. The default JDBC driver is automatically configured with High Availability Option by pointing the connection URL to any one of the MySQL instances.

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 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
• B. 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';
• C. 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
• D. 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;
• E. 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

The MySQL Enterprise Monitor Agent requires a user configured in each MySQL instance that is being monitored with suitable privileges to collect information about the server.
Identify the correct statement.

• A. Monitoring metrics need super and root privileges because they are not available for a less-privileged user.
• B. MySQL Enterprise Monitor creates the required users automatically.
• C. The super privilege is required when starting, stopping, or restarting monitored MySQL databases.
• D. The super privilege is required when creating and populating the inventory table, as well as running statements such as SHOW MASTER LOGS OR SHOW ENGINE INNODB STATUS.

You get a Maintenance notification about your Oracle MySQL Cloud Service. What are the implications?

• A. There are no maintenance operations planned. You need to do them manually.
• B. You need to agree to the maintenance windows. If not, you are not affected by the outage.
• C. You can expect an outage of your MySQL Cloud Service during the planned time.
• D. Depending on the planned outage, you may not be affected by it. You need to read the maintenance details in the support notice.

You are having performance issues with MySQL instances. Those servers are monitored with MySQL Enterprise Monitor (MEM). How would you proceed?

• A. Sort the "Exec" column and check for SQL queries with high QRTi values.
• B. Look for queries with big prolonged spikes in row activity/access graph in the times series graph (Query Analyzer.)
• C. Sort the "Exec" column and check for SQL queries with low QRTi values.
• D. Look for queries with low total latency times in the Latency section in the times series graph (Query Analyzer.)