[2026] Oracle MySQL Cloud Service 2018 Implementation Essentials

문제1

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 - - incremental policy to back up incrementally based on previous full backup.

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 mysqldump with - -incremental together with the - -compress option to back up incrementally based on previous full backup and compress the incremental backup files.

D. Use MySQL Enterprise Backup with the - -size=compress to compress the backup file.

E. Use mysqldump with the - -changesonly option.

정답: B,E

문제2

The MySQL Cloud Service (CS) is a database offering from Oracle. Which three statements are correct?

A. Oracle MySQL Enterprise Tools & Plugins are available as optional services (installation Feature Pack I/II).

B. MySQL CS configuration can be changed in /etc/my.cnf.

C. MySQL CS is based on the MySQL Enterprise Product Suite.

D. MySQL CS is based on the MySQL GPLv2 version from the Oracle Linux 6 with optimizations for the Cloud (Oracle Flexible Architecture Standard).

E. MySQL CS is installed based on the Oracle Flexible Architecture Standard.

F. MySQL CS is based on an IaaS Oracle Linux image including full root privileges to the OS.

정답: A,B,C

문제3

You want to change the default behavior of MySQL Enterprise Monitor (MEM). New instances detected by a MEM agent should automatically monitor discovered instances.
How can you change the Advisor Setting?

A. Go to the configuration section (Users) and create a new user according to the existing users of your new MySQL instances.

B. Go to the configuration section (Advisors) and edit the default settings of the MySQL Process Discovery according to the existing users of your new MySQL instances.

C. Go to the configuration section (MEM) and configure the default login credentials.

D. Go to the configuration section (Advisors) and create a new advisor rule for new MySQL instances based on the MySQL Advisor Wizard.

정답: B

문제4

The slave connects to the master and asks for updated records. What command was issued for this to happen?

A. SLAVE START

B. START SLAVE

C. START RUN SLAVE

D. RUN SLAVE

E. SLAVE RUN

정답: A

문제5

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 low QRTi values.

B. Sort the "Exec" column and check for SQL queries with high QRTi values.

C. Look for queries with low total latency times in the Latency section in the times series graph (Query Analyzer.)

D. Look for queries with big prolonged spikes in row activity/access graph in the times series graph (Query Analyzer.)

정답: C

문제6

You set up a compressed full backup file from mysqlbackup by using the --compress option for MySQL Database backup.
You are required to restore the database and apply the log.
Which two options should you add to the mysqlbackup to achieve the restoration of the database?

A. --uncompress

B. --copy-back-and-apply-log

C. --uncompress-and-apply-log

D. --apply-log-and-copy-back

E. --decompress

정답: A,B

문제7

You execute the following statement SELECT NULL=NULL;
What is the result?

A. 0

B. FALSE

C. TRUE

D. NULL

E. 1

정답: B

문제8

You have a user on your MySQL instance who is flooding the server with complex queries and large INSERTS, which prevents another user with a higher priority from running queries. Which two choices will limit the number of SELECTS to 10 per hour and the number of INSERTS to 4 per hour for user 'employee1' from MySQL Workbench by first selecting Server> Users and Privileges> employee1?

A. Set Concurrent Connections to 14 for 'employee1'.

B. Set Max. Connections to 14 for 'employee1'.

C. Set Max Updates to 4 for 'employee1'.

D. Set Max. Queries to 10 for 'employee1'.

E. Set Max. Queries to 14 for 'employee1'.

정답: B,D

문제9

The replication setup for Master and Slave MySQL 5.6 instances is configured and running correctly without using Global Transaction ID (GTID).
You are required to perform a replication change to implement GTID for the MASTER and SLAVE configuration.
Which two steps would you perform?

A. Restart MySQL (MASTER and SLAVE) with the following options enabled:- - gtid_mode=ON- - log-bin- -log-slave-updates- - enforce-gtid-consistency

B. On the SLAVE, alter the mysql master connection setting with:> CHANGE MASTER TO>MASTER_HOST = host,>MASTER_PORT = port,>MASTER_USER = user,>MASTER_PASSWORD= password,>MASTER_AUTO_POSITION=1

C. Enable GTID by executing the following on MASTER and SLAVE:>set global GTID_ENALBED=on;

D. On the SLAVE, alter the mysql master connection setting with:> ALTER system CHANGE MASTER TO>MASTER_HOST = host,>MASTER_PORT = port,>MASTER_USER = user,>MASTER_PASSWORD= password,>MASTER_AUTO_POSITION=1

E. Execute the following on SLAVE to enable GTID:>start slave io_thread - -gtid-mode=on;

정답: A,B

문제10

Which three options describe the setup of MySQL High Availability solutions?

A. Setting up three machines configured as follows:Machine A with 2 x Data NodesMachine B with 2 x mysqld nodeMachine C with 2 x ndb_mgmd node

B. setting up Master and Slave with MySQL Semi-Sync Replication Plugin

C. providing the Active/Passive setup of MySQL Server running on two machines with Shared Storage together with OS clustering to provide storage and Virtual IP failover

D. setting up three machines configured as follows:Machine 1: Data Node and mysqld nodeMachine 2:
Data Node and mysqld nodeMachine 3: ndb_mgmd

E. creating an NFS volume with multiple running MySQL Server Instances attaching the same NFS Volume with the same datadir

정답: C,D,E

Oracle MySQL Cloud Service 2018 Implementation Essentials - 1z0-320무료 덤프문제 풀어보기

우리와 연락하기

유용한 링크

최신 업데이트