1z0-320 MySQL Cloud Service 2018 Implementation Essentials

INFO
STADISTICS
RECORDS
Title of test:
1z0-320 MySQL Cloud Service 2018 Implementation Essentials

Description:
MySQL Cloud Service 2018 Implementation Essentials

Author:
PrepWay
(Other tests from this author)

Creation Date:
06/11/2019

Category:
Others
Click 'LIKE' to follow the bests test of daypo at facebook
Last comments
No comments about this test.
Content:
QUESTION 1 By using the asynchronous MySQL Replication architecture, data can be replicated to slaves. Identify three use cases of MySQL Replication. A. MySQL Replication Connector/J (ReplicationDriver) is provided to allow read capability on slave and write capability on master. B. MySQL Enterprise Backup will back up from Slave automatically. C. It provides multi-master access where the application can write and read data across the database servers. D. It allows backup to be done on the slave without impacting the master. 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.
QUESTION 2 The MySQL pluggable authentication plug-in for Windows is enabled and configured. The following command is executed on a MySQL Server: CREATE USER ‘SQL_admin’@’%’ IDENTIFIED WITH authentication_windows AS ‘joe, henry, “Power Users”’; Which two statements are valid? A. When any of the named users is using a Linux Client, the user can access the MySQL Server from a MYSQL Client with the password configured in MySQL. B. User Joe may log in to a Windows Client and then access the MySQL Server from a MySQL Client without being asked about a password. C. When any of the named users is using a Linux Client, the user can access the MySQL Server from s MySQL Client with the password configured in the Windows Active Directory. D. When any of the named users is using a Java application based on his or her Windows Client, no authentication is necessary to log in to MySQL. E. Logins are granted only if the user’s client application and the corresponding MySQL instance are on the same IP address.
QUESTION 3 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. Depending on the planned outage, you may not be affected by it. You need to read the maintenance details in the support notice. C. You need to agree to the maintenance windows. If not, you are not affected by the outage. D. You can expect an outage of your MySQL Cloud Service during the planned time.
QUESTION 4 A keyfile has been generated as follows: # openssl rand 32 –hex >keyfile # cat keyfile 6a1d325e6ef0577f3400b7cd624ae574f5186d0da2eeb946895de418297ed75b You are required to do a backup on the MySQL database using MySQL Enterprise Backup with encryption. Which option can perform the backup with the keyfile provided in order to encrypt the backup files? A. # mysqlbackup - - backup-image=/backups/image.enc - - encrypt - -key-file= keyfile - -backup-dir=/var/tmp/ backup backup-to-image B. # mysqlbackup- - encrypt - -key-file=keyfile - -backup-dir=/var/tmp/backup backup C. # mysqlbackup - - backup-image=/backups/image.enc - - encrypt- - encrypt-key=keyfile - - backup-dir=/var/ tmp/backup backup-to-image D. # mysqlbackup - - backup-image=/backups/image.enc - - encrypt - -key=keyfile - -backup-dir=/var/tmp/ backup backup-to-image E. # mysqlbackup- - encrypt - -key-file=keyfile - -backup-dir=/var/tmp/backup – timestamp backup.
QUESTION 5 You use MySQL Enterprise Monitor for a group of MySQL servers. In recent weeks, the MySQL Enterprise Monitor has slowed down significantly. Which two preventative actions should you take if your number of monitored MySQL instances has changed? A. Increase the disk space with at least 10% of the database size. B. Increase the necessary operating system swap space (Linux): mkswap /dev/sdx; swapon/dev/sdx, /etc/ fstab. C. Increase the amount of RAM available to the JVM installed with Tomcat. The JVM memory settings are defined by the JAVA_OPTS line of the setenv file, which sets the environment variables for Tomcat (-- JvmMs/-Xms and –JvmMx/-Xmx). D. Tune the InnoDB Buffer Pool of the MySQL Enterprise Monitor Repository database. This can have a significant impact on performance (innodb_buffer_pool_size).
QUESTION 6 Your newly created MySQL Cloud Service is not available from your application. Select the two correct options that apply. A. You forgot to create the correct SSL/TLC certificate during the setup process. B. The ‘opc’ user can be used to access MySQL only with the created SSH-Key. C. Only ‘root’ is allowed to access from non-localhost. D. The MySQL instance is still in the “Creation” process. E. You forgot to enable port 3306.
QUESTION 7 The slave connects to the master and asks for updated records. What command was issued for this to happen? A. RUN SLAVE B. START RUN SLAVE C. SLAVE RUN D. SLAVE START E. START SLAVE.
QUESTION 8 Which two architecture options can provide Active/Active Master configuration for the MySQL Database? A. Execute the following on the 2x MySQL Server Instances mysql> ALTER REPLICATION set mode= active; B. Deploy MySQL Cluster on the following machines: Machine 1: MySQL Node+ MySQL Management Node Machine 2: MySQL Node+ MySQL Management Node Machine 3: Data Node Machine 4: Data Node Application can access MySQL Node on Machine 1 or Machine 2 for Active/Active Configuration. C. Configure MySQL Replication for two MySQL Database instances with circular Replication Topology, where two different applications with each using different database schemas connecting to a specified MySQL Database Instance. MySQL Database Instance1 < -----Replication---> MySQL Database Instance 2 Application A connecting to MySQL Database Instance 1 for schema db1 Application B connecting to MySQL Database Instance 2 for schema db2 D. Configure MySQL Replication between two MySQL Database instances and setting Replication mode = active. E. 2x MySQL Server Instances should be deployed on two machines with shared NFS volume. Datadir points to the shared folder. Applications can access either one of the MySQL Servers for the same set of data.
QUESTION 9 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 (Advisors) and create a new advisor rule for new MySQL instances based on the MySQL Advisor Wizard. D. Go to the configuration section (MEM) and configure the default login credentials.
QUESTION 10 Which command in MySQL Utility can perform and start replication among a slave and multiple masters? A. mysqlrplcheck B. mysqlrplms C. mysqlrpladmin D. mysqlreplicatems E. mysqlreplicate.
QUESTION 11 The MySQL Cloud Service (CS) is a database offering from Oracle. Which three statements are correct? A. MySQL CS is based on an IaaS Oracle Linux image including full root privileges to the OS. B. Oracle MySQL Enterprise Tools & Plugins are available as optional services (installation Feature Pack I/II). C. MySQL CS is installed based on the Oracle Flexible Architecture Standard. D. MySQL CS is based on the MySQL Enterprise Product Suite. E. MySQL CS is based on the MySQL GPLv2 version from the Oracle Linux 6 with optimizations for the Cloud (Oracle Flexible Architecture Standard). F. MySQL CS configuration can be changed in /etc/my.cnf.
QUESTION 12 Which three installation options are available for installing the MySQL Enterprise Monitor/Agent on Linux? A. A GUI for installing MySQL Enterprise Monitor, Agent, and a MySQL Repository database B. A CLI-based wizard MySQL Enterprise Monitor, Agent, and a MySQL Repository database C. A script (with an option file) for installing MySQL Enterprise Monitor, Agent, and a MySQL Repository database D. A MySQL Enterprise Monitor to remotely deploy the MySQL Monitor Agent E. A browser-based wizard to remotely deploy the MySQL Monitor Agent.
QUESTION 13 Which three statements are true about MySQL Enterprise Backup? A. It cannot backup encrypted tablespaces. B. It provides the ability to create incremental backups. C. It performs hot or warm backups. D. It performs logical backups. E. It enables you to take non-locking backups.
QUESTION 14 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 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 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 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; D. 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 VCEConvert. E. 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.
QUESTION 15 Identify two features of MySQL Enterprise Firewall. A. You set the firewall per database. B. You can automatically delete a user if the user breaks your firewall. C. You can block out potential threats by setting up a preapproved whitelist. D. You can set a recording mode to record incoming SQL statement to create a whitelist of permitted commands. E. You can modify a request with a SQL statement substitution.
QUESTION 16 Name three ways in which customers can receive notifications such as outages, configuration changes, database emergencies, and other information on their Database as a Service instances. A. Email B. SMS C. Notification tab on the dashboard D. Browser pop-ups E. Direct support call from an Oracle representative.
QUESTION 17 You are using the MySQL Enterprise Audit plug-in, and the audit.log file is corrupted. What steps would you perform to create a new audit file? A. As the root user, execute the FLUSH AUDIT LOGS command. Refresh the audit plug-in with SET GLOBAL audit_log_status =REFRESH. B. Stop the MySQL server. Move or rename the existing audit.log file. Restart the MySQL server. C. Stop the MySQL server. Reinstall the audit plug-in by using INSTALL PLUGIN audit_log SONAME ‘audit_log.so’; Delete the corrupted file. Restart the MySQL server. D. As the root user, execute the SET GLOBAL audit_log_flush=ON command.
QUESTION 18 You are required to set up a backup user (mysqlbackup@localhost) on the MySQL Database. The user should have the backup and restore privileges and additional privileges required for using transportable tablespaces (TTS). To back up and restore InnoDB tables. Which syntax accomplishes this? A. CREATE USER ‘mysqlbackup’@localhost’IDENTIFIED BY ‘new-password’; B. CREATE USER ‘mysqlbackup’@localhost’ IDENTIFIED BY ‘new-password’; GRANT RELOAD ON *.* TO ‘mysqlbackup’@’localhost’; GRANT CREATE, INSERT, DROP, UPDATE ON mysql.backup_progress TO ‘mysqlbackup’@’localhost’; GRANT CREATE, INSERT, SELECT, DROP, UPDATE ON mysql.backup_history TO ‘mysqlbackup’@’localhost’; GRANT REPLICATION CLIENT ON *.* TO ‘mysqlbackup’@’localhost’; GRANT SUPER ON *.* TO ‘mysqlbackup’@’ localhost; GRANT PROCESS ON *.* ‘mysqlbackup’@’localhost’; C. CREATE USER ‘mysqlbackup’@’localhost’ IDENTIFIED BY ‘new-password’; GRANT RELOAD ON *.* TO ‘’mysqlbackup’@’localhost’; GRANT CREATE, INSERT, DROP, UPDATE ON mysql.backup_progress TO ‘mysqlbackup’@’localhost’; GRANT CREATE, INSERT, SELECT, DROP, UPDATE ON mysql.backup_history TO ‘mysqlbackup’@localhost’; D. CREATE USER ‘mysqlbackup’@’localhost’ IDENTIFIED BY ‘new-password’; GRANT RELOAD ON *.* to ‘mysqlbackup’@localhost’; GRANT CREATE, INSERT, DROP, UPDATE ON, mysql.backup_progress TO ‘mysqlbackup’@’localhost’; GRANT CREATE, INSERT, SELECT, DROP, UPDATE ON mysql.backup_history TO ‘mysqlbackup’@’localhost’; GRANT REPLICATION CLIENT ON *.* to ‘mysqlbackup’@’localhost’; GRANT SUPER ON *.* TO ‘mysqlbackup’@’localhost’; GRANT PROCESS ON *.* TO ‘mysqlbackup’@’localhost’; GRANT LOCK TABLES, SELECT, CREATE, ALTER ON *.* TO ‘mysqlbackup’@’localhost’; GRANT CREATE, INSERT, DROP, UPDATE ON mysql.backup_sbt_history TO ‘mysqlbackup’@’localhost’; E. CREATE USER ‘mysqlbackup’@’localhost’ IDENTIFIED BY ‘new-password’; GRANT RELOAD ON *.* TO ‘mysqlbackup’@’localhost’; GRANT CREATE, INSERT, DROP, UPDATE ON mysql.backup_progress TO ‘mysqlbackup’@’localhost’; GRANT CREATE, INSERT, SELECT, DROP, UPDATE ON mysql.backup_history TO ‘mysqlbackup’@’localhost’; GRANT REPLICATION CLIENT ON *.* TO ‘mysqlbackup’@’localhost’;.
QUESTION 19 You are using the InnoDB engine and the innodb_file_per_table option is set. You delete a significant number of a large table named INVENTORY. What command will reorganize the physical storage of table data and associated index data for the INVENTORY table, in order to reduce storage space and improve I/O efficiency? A. ANALYZE TABLE INVENTORY; B. mysqlcheck INVENTORY C. mysqldump INVENTORY D. OPTIMIZE TABLE INVENTORY;.
QUESTION 20 You execute the following statement SELECT NULL=NULL; What is the result? A. 0 B. 1 C. TRUE D. FALSE E. NULL.
QUESTION 21 What are two key differences between the use of ndbd and ndbmtd? A. ndbd can be configured as ndbmtd by applying the option - - mtd. B. In the event of critical errors, ndbd generates a trace file with the name ndb_node_id_trace.log.trace_id, whereas ndbmtd generates a trace file with the name pattern ndb_node_id_trace.log.trace_id_tthread_id C. ndbd is single-threaded mode; however, ndbmtd runs by default in multithreaded mode. D. ndbd is single-threaded mode.ndbmtd runs by default in single-threaded mode; you must configure it to use multithreads. E. In the event of critical errors, ndbd generates all trace in error log, whereas ndbmtd generates a trace file with the name pattern ndb_node_id_trace.log.trace_id_tthread_id.
QUESTION 22 When there are long-running queries, mysqbackup hangs there to wait for the completion of the queries. You know that the system has only user data on InnoDB and there is no DDL execution during the backup period. There is no update/alternation to tables with non-InnoDB storage engines. Which two ways allow the MySQL Enterprise Backup to be executed without being blocked or without locking? A. Running mysqlbqckup from a remote machine enabled you to back up the database without locking. B. The locked phase at the end of a mysqlbackup run is short (maybe a few seconds) and does not disturb the normal processing of mysqld much. However, use - -single-user-mode to back up the long-running queries to allow mysqlbackup to run successfully without locking. C. There is no extra option. MySQL Enterprise Backup does this automatically by kicking out the long-running queries. D. The locked phase at the end of a mysqlbackup run is short (maybe a few seconds), and does not disturb the normal processing of mysqld much. However, use the - - only-innodb option to back up only InnoDB tables, to avoid blocking. E. The locked phase at the end of a mysqlbackup run is short (maybe a few seconds), and does not disturb the normal processing of mysqld much. However, use the - -no-locking option to backup up the non-InnoDB files. Note that MyISAM, .frm, and other files copied under the --no-locking setting cannot be guaranteed to be consistent, if they are updated during this final phase of the backup.
QUESTION 23 You are setting up a MySQL Cluster on two machines, where each machine is hosting the following: -1x ndbmtd -1x ndb_mgmd -1x mysqld The cluster is started. What will happen if the network connection between the two machines is disconnected? A. A MySQL Cluster backup process will be kick-started automatically. B. The entire cluster will be shut down. C. Components from one of the machines will be chosen as victim. Only one machine will provide service. D. All components will be running correctly and independently. Machine1 and Machine2 have all data and they can provide service online. E. The MySQL Cluster service will be paused. After the network is online, the MySQL Cluster service will be resumed.
QUESTION 24 You need to load the MySQL Enterprise Audit plug-in at database startup and prevent the audit plug-in from being removed at run time. Which two options should you include in the MySQL configuration file? A. audit_log_permanent=ON B. audit-log=FORCE_PLUS_PERMANENT C. plugin-load=audit_log.so D. plugin-audit=ON, ALWAYS E. LOAD PLUGIN=AUDIT_LOG.
QUESTION 25 Assume that MySQL Enterprise Monitor is configured to monitor MySQL 5.6 or a later instance. Which three features are available? A. Deploying MySQL Agent on supported target operating system B. Tracing import and export with mysqldump C. Monitoring the availability of the MySQL instance D. Creating E-Mail Alerts and SNMP Traps for MySQL Warnings E. Starting and Stopping the MySQL Instance F. Analyzing executed MySQL queries.
QUESTION 26 You have three machines with MySQL Databases running on Linux platform. Which backup procedures would allow online and remote backup of the MySQL Database on three machines to a connected Storage NFS? A. 1. Mount the Remote Storage NFS volume to each of the three machines with proper privilege for the backup OS user to have all access. 2. Install MySQL Enterprise Backup on machine which is used to start the backup. 3. Start mysqlbackup on only one machine with the installation to back up the databases for the three machines to the mounted volume using - -backup-dir and by giving --hosts=machine1:port1, machine2:port2, machine3:port3. 4. Validate the backups using the mysqlbackup program to ensure that the backups created are valid. B. 1. Mount the Remote Storage NFS volume to each of the three machines with proper privilege for the backup OS user to have all access. 2. Install MySQL Enterprise Backup on all three machines. 3. Start mysqlbackup on all machines to back up the database to the mounted volume using - -backup-dir. 4. Validate the backup using the mysqlbackup program to ensure that the backup created is valid. C. 1. Mount the Remote Storage NFS volume to each of the three machines with proper privilege for the backup OS user to have all access. 2. Install MySQL Enterprise Backup on the machine that is used to start the backup. 3. Start mysqlbackup on only one machine with the installation to back up the databases for the three machines to the mounted volume using - - backup-dir and by specifying -- config-files=my1.cnf, my2.cnf, my3.cnf.my1.cnf, my2cnf, and my3.cnf are the MySQL Database Configuration files on the three machines. 4. Validate the backup by using the mysqlbackup program to ensure that the backup created is valid. D. 1. Mount the Remote Storage NFS volume to each of the three machines with proper privilege for the backup OS user to have all access. 2. Install MySQL Workbench on a separate machine, which is used to connect to the three machines to back up and restore. 3. Startup MySQL backup from MySQL Workbench to back up the three databases. 4. Validate the backup by using MySQL Workbench to ensure that the backup created is valid.
QUESTION 27 After the installation of the MySQL Server, you cannot find MySQL Utilities. How would you correct the problem? A. MySQL Utilities comes with MySQL Enterprise Monitor. Download MySQL Enterprise Monitor to install. B. MySQL Utilities is installed with MySQL Server Binary. Put the MySQL bin folder into PATH to allow execution. C. MySQL Utilities is a package from MySQL Connector. Download the MySQL/Connector and install. D. MySQL Utilities comes with MySQL Enterprise Backup. Download MySQL Enterprise Monitor to install. E. MySQL Utilities is a package of utilities that are used for maintenance and administration of MySQL servers. Download the MySQL Utilities separately from www.mysql.com.
QUESTION 28 Identify an example of creating an Enterprise Encryption function. A. SET@function = CREATE_ASYMMETRIC_PRIV_KEY (@algo, @key_len); B. VALIDATE FUNCTION create_asymmetric_priv_key WITH ‘openssl_udf.so’; C. INSERT INTO t1 (key-col) FUNCTION(CREATE_ASYMMETRIC_PRIV_KEY(‘RSA’, 1024)); D. CREATE FUNCTION asymmetric_decrypt RETURNS STRING SONAME ‘openssl_udf.so’;.
QUESTION 29 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. 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. C. MySQL Enterprise Firewall is available only in MySQL Enterprise versions 5.7.10.and later. 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. MySQL Enterprise Firewall shows only notifications blocked connections, which originated outside of your network’s primary domain.
QUESTION 30 Your customer wants you to install and configure MySQL on the customer’s Oracle Linux 6 server with tarball binaries in the /app/mysql1/directory, where the bin directory is found at /app/mysql/bin and a data directory at / app/data. What are two correct and required server configurations, excluding redundant configuration entries, to build a MySQL instance supporting your customer’s requirement? A. The configuration datadir=/app/mysql/data is needed. B. The configuration basedir=/app/mysql/bin is needed. C. The configuration log-bin=/app/data is needed. D. The configuration datadir=/app/data is needed. E. The configuration innodb_log_group_home_dir=/datadir is needed. F. The configuration basedir=/app/mysql is needed.
QUESTION 31 Which statement will display the status of the partitioning plug-in? A. SHOW STATUS PLUGINS WHERE Name= ‘PARTITIONING’; B. SHOW PLUGINS WHERE Name= ‘partition’; C. SELECT PLUGIN_NAME, PLUGIN_VERSION, PLUGIN_STATUS FROM INFOMRATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME= ‘partition’; D. USE SYS SCHEMA; SHOW PLUGINS STATUS;.
QUESTION 32 How do you restrict a user named joe from being able to connect from any IP address to a MySQL database? A. Insert Joe’s name into the mysql.user_restriction table, and issue the FLUSH PRIVILEGES command. B. You cannot deny access to a user based on his or her username. C. CREATE USER ‘joe’@%’ DENY ALL PRIVILEGES D. UPDATE mysql.user SET Password=PASSWORD (‘Invalid’) WHERE User= ‘joe’; E. CREATE USER ‘joe’@’0.0.0.0’SET Password=PASSWORD (‘%!%’).
QUESTION 33 Your customer runs several Oracle products and would like to reuse them. Identify four options that are certified to work with the MySQL Enterprise Edition features. A. MySQL Server can be monitored by Oracle Enterprise Manager both for performance and alerting. B. MySQL Server can be hosted using Oracle VM for hard-partitioned virtualization installations. C. MySQL Enterprise Firewall uses Oracle Database Firewall to block intrusive users and queries. D. MySQL Enterprise Backup can send its backups directly to Oracle Secure Backup. E. MySQL Enterprise Encryption uses Cloud Key Vault’s access to OpenSSL to create encrypted keys. F. MySQL Server’s configuration can be saved by Oracle Enterprise Manager so that configuration changes can be tracked.
QUESTION 34 Identify three levels in which MySQL Enterprise Monitor provides access control. A. MySQL Enterprise Operations: the right to start/stop/restart/update MySQL Enterprise Monitor Services B. Asset visibility: the rights to access data collected from hosts or MySQL instances C. Application administration: the rights to view or change the MySQL Enterprise Monitor configuration D. Specific data access: the rights to view specific types of potentially sensitive data E. MySQL Enterprise Operations: the right to deploy the necessary MySQL Enterprise Agent.
QUESTION 35 After installing MySQL 5.7, you initialize the data directory with the - -initialize command. Identify two places in which you would find the root password. A. As root, execute the SHOW PASSWORD command by using the SHA-256 password encryption plug-in. B. The root password will be displayed on the screen via a [Warning] message. C. The root password will be inserted in the error log set by the - -log error= [file_name] variable. D. You will find it as a root_pw variable stored in the mysql.install table. E. The root password is not given and is blank. You must manually set the root password.
QUESTION 36 Which two MySQL features are provided exclusively with the Enterprise Edition license, in addition to the database server? A. MySQL Enterprise Monitor B. MySQL Cluster Manager C. MySQL Enterprise Firewall D. MySQL Replication.
QUESTION 37 The MySQL database for backup with used data is configured only with the InnoDB storage engine. System data including SP, VIEWs, and users in the system database are all static. For any changes with system data, the database backup will be done separately. You are requested to optimize backup performance to reduce backup time by using MySQL Enterprise Backup for the daily backup operation with user data (configured with the InnoDB storage engine). Which three options would you choose to optimize the backup performance? A. Shutting down the MySQL database and using MySQL Enterprise Backup to restart the MySQL Database to remove any potential locking B. Using the - - only- innodb or - - only- innodb- with –frm option to back up only InnoDB tables C. Running multiple MySQL Enterprise Backups at the same time to back up the same database to allow parallel database backups on MySQL D. Running the backup with the backup policy, full backup and incremental backup, supported by MySQL Enterprise Backup to reduce the daily backup time E. Using the - - no-locking option to backup non_InnoDB files.
QUESTION 38 A MySQL installation has the following required architecture components: client programs, MySQL utilities, and MySQL Server. Which client program would you use to emulate client load? A. mysqlslap B. mysqlshow C. mysqlimport D. mysqlcheck E. mysqladmin.
QUESTION 39 You have the MySQL 5.7 database running. MySQL Enterprise Backup 3.12 is installed and it is used to back up the MySQL 5.7 database. The backup has failed. Identify the reason. A. MySQL Enterprise Backup 3.x does not support MySQL 5.7. MySQL Enterprise Backup 4.x or later is required to back up MySQL 5.7. B. MySQL Workbench must be installed with MySQL Enterprise Backup to enable the backup to run successfully. C. MySQL 5.7 is supported in MySQL Enterprise Backup 3.x with the MySQL 5.7 extension pack D. MySQL 5.7 is supported in MySQL Enterprise Backup 3.x providing that the MySQL 5.7 is pre-registered in the MySQL Enterprise Backup configuration file. E. mysqlbackup with MySQL Enterprise Backup 3.x must be executed once with the - -upgrade on MySQL 5.7 database to allow the mysql.backup_progress and mysql.backup_history tables to be patched.
QUESTION 40 Which three statements describe MySQL Cloud Service Backup? A. MySQL Enterprise Backup can be used to send backups to Oracle Cloud Storage Service. B. MySQL Enterprise Backup can be used to import/export data from on-premises MySQL installations. C. MySQL Cloud Service offers backup based on Oracle RMAN with optimized row locking. D. MySQL Cloud Service Backup is an optimized backup based on mysqldump with optimized row locking. E. MySQL Cloud Service Backup provides the point-in-time recovery functionality.
QUESTION 41 The user ‘fwuser’@’localhost’ was registered with the MySQL Enterprise Firewall and was granted privileges for the SAKILA database. You executed commands: mysql> SELECT MODE FROM INFORMATION_SCHEMA.MYSQL_FIREWALL_USERS WHERE USERHOST= 'fwuser@localhost' ................... You want to clear the account whitelist for the ‘fwuser’@’localhost’ user. Which statement would you run to accomplish this? A. CALL mysql.sp_reload_firewall_rules (‘fwuser@localhost’); B. SET mysql.sp_set_firewall_mode= ‘RECORDING’; C. CALL mysql.sp_set_firewall_mode (‘fwuser@localhost’, ‘CLEAR’); D. DELETE TABLE INFORMATION_SCHEMA.MYSQL_FIREWALL_WHITELIST;.
QUESTION 42 The MySQL server looks for option files in standard locations. The server might read multiple files from different locations. For a Linux installation, which two methods would you use to view the options file lookup locations, the order in which they are read, and groups? A. $ mysql - - print-defaults B. SHOW GLOBAL VARIABLES; C. $ mysqld - -help - -verbose | grep-A1 “Default options” D. $ mysqld --help.
QUESTION 43 A Cloud customer already has many database instances configured and running in the cloud, however, they are reporting that they are unable to create any more instances. What could be the problem? A. The customer does not have proper user rights. B. The customer account might have reached its compute quota. C. The customer reached the database instance limit of 32. D. The customer has not kept up with their patching requirements; new instances cannot be created unless the majority or the template of existing instances are up-to date.
QUESTION 44 Which two ports need to be opened on a network firewall to allow an outside client (on the other side of the firewall) to be able to access a MySQL instance inside the firewall? A. Port 13306/tcp [MySQL], when using TCP/IP via a command-line client B. Port 3306/tcp [MySQL], when tunneling is not used from within MySQL Workbench C. Port 18443/tcp [MySQL], when connecting from MySQL Workbench to a Windows MySQL server D. Port 22/tcp [SSH], when using TCP/IP over SSH.
QUESTION 45 MySQL is installed on a Linux server and has the following configuration: [mysqld] User=mysql Datadir=/data/mysql Which two methods should you use to change the default options to use the authentication plug-in that implements SHA-256 hashing for user account passwords? A. Create user by using CREATE USER ‘newuser’ @’localhost’ SET PASSWORD AS ‘Sh@256Pa33’; B. Add --default_authentication_plugin=sha256_password on the command line when you invoke the server. C. Add default_authentication_plugin=sha256_password under [mysqld] in the configuration file. D. Create user by using CREATE USER ‘newuser’@’localhost’ IDENTIFIED WITH ‘Sh@256Pa33’;.
QUESTION 46 You want to monitor SQL statements, which are executed on the MySQL server, in MySQL Enterprise Monitor (MEM). Select three possible ways. A. Configure a MySQL Connector that sends information directly to MySQL Enterprise Service Manager. B. Route MySQL SQL statements through a MySQL Monitor Proxy. C. Configure the Performance Schema statement digests with MySQL Server 5.6.14 or later. D. Configure MySQL to replicate data via the MySQL binlog to MEM. E. Configure the MySQL Router to send normalized SQL statements to MEM.
QUESTION 47 You have a MySQL Server instance (running with Port# 3306) monitored by the Service Manager in MySQL Enterprise Monitor. You cloned the MySQL Database instance and configured it to be a replicated MySQL instance as Slave using Port# 3316 on the same machine as the Master Server. The replication configuration is working correctly. The Master and Slave Servers are running. You are trying to add the newly created MySQL Slave instance to the Monitor. The Service Manager in MySQL Enterprise Monitor notifies you that the new instance is successfully added; however, it is not added correctly at the newly added configuration points to the old Master monitored items. The Monitor shows only one monitored MySQL instance for Master and Slave. Identify two reasons for this problem. A. The SLAVE and MASTER instances are started with the same configured value for the option - - monitor_server_uuid. B. The MASTER and SLAVE are grouped as one instance for monitoring. C. The mysql.inventory table on SLAVE is cloned with the same content as MASTER, which has the same server UUID. D. The mysql.instance table on SLAVE is cloned with the same content as MASTER, which has the same server UUID. E. All the MySQL instances (Master and Slave) have the same server_uuid in <datadir>/auto.cnf.
QUESTION 48 Which query will find rows in a table that have no counterpart in another table? A. SELECT *FROM table1 INNER JOIN table2 ON table1.id=table2.id WHERE table1.id=! table2.id; B. SELECT left_tbl.* FROM left_tbl LEFT JOIN right_tbl ON left_tbl.id=right_tbl.id WHERE right_tbl.id IS NULL; C. SELECT t1.name, t2.name2 FROM employee AS t1 INNER JOIN info AS t2 ON t1.name= t2.name2; D. SELECT t1.name, t2.name2.
QUESTION 49 A MySQL 5.7 is monitored via 3306 without a MySQL agent (agentless installation). Which two options are not available in such a setup in the MEM GUI? A. Network-related information and network characteristics B. Security-related advisors warning (for example, password warnings and firewall warnings) C. MySQL Query Analysis data. D. Disk usage and disk characteristics including disk advisors warnings E. MySQL Replication monitoring.
QUESTION 50 Identify the MySQL plug-in that is provided only with MySQL Enterprise Edition and servers to increase performance and high availability. A. the MySQL memcached plug-in B. the MySQL PAM Authentication plug-in C. the MySQL Thread Pool plug-in D. the MySQL No-Login Authentication plug-in E. the MySQL Firewall plug-in F. the MySQL Semisynchronous replication plug-in.
QUESTION 51 The user ‘OS-user’@’localhost’ was created to monitor connections and shut down the server, and was granted the following privileges: GRANT PROCESS, SHUTDOWN ON *.* to ‘OS-user’@’localhost’; Identify three commands that the OS-user can execute. A. SHOW STATUS; B. SHUTDOWN; C. SHOW BINLOG EVENTS; D. SHOW PROCESSLIST; E. KILL PROCESS;.
QUESTION 52 MySQL Enterprise provides query analyzing metrics for SQL statements. Which four MySQL environments will provide QUAN metrics? A. All MySQL (when MySQL connectors with Aggregator is used for the application) B. MySQL 5.5.9 (and later) C. MySQL 5.7.9 Community (and later) D. MySQL 5.6.14 Commercial (and later) E. All MySQL (with MySQL Enterprise Monitor Proxy).
QUESTION 53 What are security rules in Compute Cloud Service? A. They allow administrators access to applications in the cloud. B. Security are essentially firewall rules that can help to control traffic between Cloud Service instances, as well as between instances and external hosts. C. They are user-role designation that assign rights to certain users. D. Security rules are data encryption levels that control who can see the data. E. These are rules established by HIPAA for securing end-user data.
QUESTION 54 Which four options are valid reasons for using a PRIMARY KEY in a table? A. Eliminating the need for accessing the database cache B. Preventing duplicate keys C. Maintaining a history of row insertions or updates D. Automatic storage of data in a sorted order E. Increasing performance when using SELECT statements F. Auto-generating values via AUTO_INCREMENT G. Exporting data faster with mysqldump.
QUESTION 55 Which three features are available only on MySQL Enterprise Workbench? A. GUI for MySQL Enterprise Backup B. MySQL Audit Log Inspector C. Database Design D. Database Migration inclusive Support E. Visual Performance Dashboard.
QUESTION 56 Select three privileges that are necessary to successfully back up a server instance with the mysqlbackup command after the initial installation. A. CREATE TEMPORARY TABLES B. REPLICATION CLIENT C. GRAND OPTION D. RELOAD E. INDEX.
QUESTION 57 When creating a FOREIGN KEY constraint, what SQL variable must be specified? A. UNIQUE PRIMARY KEY values for both child and parent tables B. a REFERENCE in the child table to the parent table C. the SET_FOREIGN_KEY variable in the my.cnf file D. an INDEX on the FOREIGN KEY E. a TRIGGER on the child table for cascading DELETE statements.
QUESTION 58 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 Max Updates to 4 for ‘employee1’. B. Set Max. Queries to 14 for ‘employee1’. C. Set Max. Connections to 14 for ‘employee1’. D. Set Max. Queries to 10 for ‘employee1’. E. Set Concurrent Connections to 14 for ‘employee1’.
QUESTION 59 Consider the following SQL statement which is using the InnoDB storage engine and with global AUTOCOMMIT=1. BEGIN; CREATE TABLE t1 (c1 INT); CREATE TABLE t2 (c1 INT); ROLLBACK; What is the result after issuing the ROLLBACK command? A. Both the tables, t1 and t2, are created. B. Only the t1 table is created. C. Both the tables, t1 and t2, are not created because there is an explicit ROLLBACK. D. Only the t2 table is created.
QUESTION 60 For accessing a new default MySQL Cloud Service (CS) cloud environment, you used the “Create SSH Keys function” during the guided MySQL CS setup. You want to use Putty from your Windows Client. Identify the correct steps. A. You open Port 22 on your MySQL CS Instance and configure Putty with the provided private key. B. Convert the private key to ppk format first, and use the new private key for authentication. C. Use the provided private key for authentication. D. Open Port 22 on your MySQL CS Instance and convert the private key to ppk format. This new private key can be used for authentication.
QUESTION 61 Identify three characteristics of the JSON data type. A. Key or array references enable quick read-access to look up document elements directly. B. It is based on the TEXT data type. C. It validates the JSON syntax on insert or merge. D. it supports indexing directly against the JSON-defined column. E. Comparisons of JSON values are not case-sensitive. F. A set of SQL functions substantially support the SQL utilization of the data type.
QUESTION 62 You want to use Workbench to connect your local MySQL instance by using a local socket. Where would you find the location of the socket file? A. The socket file is located in the MySQL data directory. B. You can find the file by querying the GLOBAL VARIABLE SOCKET_LOCATION parameter. C. The file location is set by using the socket parameter located in the global or local option file. D. You always use port 3307 for connecting by using the local socket. E. You have to set up your session to be able to accept LOCAL SOCKET, and then connect via port 22.
QUESTION 63 You have a backup image file that is backed up using MySQL Enterprise Backup with the - - compress option: /home/mysql/backup/full/mybackup/myimage.img mysqlbackup.cnf is shown as follows: [mysqlbackup] backup-dir=/home/mysql/backup/full/mybackup backup-image=/home/mysql/backup/full/mybackup/myimage.img You are required to perform a database restore to a new machine to provision the database. Which command can provision the new database in the datadir as /home/mysql/data/MEB? A. #mysqlbackup - -defaults-file= config/mysqlbackup.cnf - -port=3306 - -host= 127.0.0.1\ - - user= mysqlbackup - -password - - uncompress - - backup-dir=/home/mysql/backup/full/myrestore\ - -datadir=/home/mysql/data/MEB image-to-dir-and-apply-log B. #mysqlbackup - -defaults-file= config/mysqlbackup.cnf - -port=3306 - -host= 127.0.0.1\ - - user= mysqlbackup - -password - - uncompress - - backup-dir=/home/mysql/backup/full/myrestore\ - -datadir=/home/mysql/data/MEB apply-log-and-copy-back C. #mysqlbackup - -defaults-file= config/mysqlbackup.cnf - -port=3306 - -host= 127.0.0.1\ - - user= mysqlbackup - -password - - uncompress - - backup-dir=/home/mysql/backup/full/myrestore\ - -datadir=/home/mysql/data/MEB copy-back-and-apply-log D. #mysqlbackup - -defaults-file= config/mysqlbackup.cnf - -port=3306 - -host= 127.0.0.1\ - - user= mysqlbackup - -password - - uncompress - - backup-dir=/home/mysql/backup/full/myrestore\ - -datadir=/home/mysql/data/MEB restore-and-apply-log E. #mysqlbackup - -defaults-file= config/mysqlbackup.cnf - -port=3306 - -host= 127.0.0.1\ - - user= mysqlbackup - -password - - uncompress - - backup-dir=/home/mysql/backup/full/myrestore\ - -datadir=/home/mysql/data/MEB image-to-dir.
QUESTION 64 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-and-apply-log B. --apply-log-and-copy-back C. --copy-back-and-apply-log D. --uncompress E. --decompress.
QUESTION 65 You need to change the password level for a test system. Which two options enable to change this level before you create new test user/passwords? A. SET GLOBAL validate_password_policy=’new level’; B. SET GLOBAL force_password_complex_policy=0; C. Add validate_password_policy=’new level’ in the [mysql] section of the MySQL configuration file. D. Add validate_password=’new level’ in the [security] section of the MySQL configuration file.
QUESTION 66 Which statement is true about MySQL Enterprise Transparent Data Encryption (TDE)? A. TDE supports at-rest encryption for InnoDB tables stored in file-per-table tablespaces. B. Lost tablespace encryption keys can be regenerated only if the master database key is known or present in the KEY VAULT file. C. Both MyISAM and InnoDB table can be encrypted by setting the keyring_engine =ALL variable in the MySQL configuration file. D. TDE can encrypt InnoDB and MyISAM tables only when the tables are stored in the SYSTEM tablespace.
QUESTION 67 Which statement would create an index by using the first 10 characters of the name column in the customer table (assuming that name is a nonbinary string type?) A. CREATE SUB INDEX part_of_name ON (customer, name, 10); B. CREATE INDEX (10) ON (customer.name); C. CREATE INDEX part_of_name ON customer (name(10)); D. CREATE PARTIAL INDEX part-of_name ON customer (name, 10); E. CREATE INDEX part_of_name ON customer.name LIMIT 10 CHAR;.
QUESTION 68 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. MySQL Enterprise Monitor creates the required users automatically. B. Monitoring metrics need super and root privileges because they are not available for a less-privileged user. 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.
QUESTION 69 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 mysqldump with - -incremental together with the - -compress option to back up incrementally based on previous full backup and compress the incremental backup files. B. Use mysqldump with the - -changesonly option. C. Use MySQL Enterprise Backup with the - -size=compress to compress the backup file. D. Use MySQL Enterprise Backup with the - - incremental policy to back up incrementally based on previous full backup. E. Use MySQL Enterprise Backup with the - -compress option to compress the backup files and use - - compress-level to select the level of compression.
QUESTION 70 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. Sort the “Exec” column and check for SQL queries with low 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.).
QUESTION 71 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. The default JDBC driver is automatically configured with High Availability Option by pointing the connection URL to any one of the MySQL instances. B. Use MySQL Router with the following configuration: [DEFAULT] logging_folder= /var/log/mysqlrouter [logger] level=INFO [routing: failover] bind_port = 7001 mode=replication destinations=master:3306, slave:3306 The 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 = 7001 mode=read-write destinations= master:3306, slave:3306 The Java application can connect to bind_port=7001. D. Use MySQL Connector/J with the com.mysql.jdbc.ReplicationDriver with JDBC URL as jdbc:mysql:replication://[mater host] [:port], [slave host 1] [:port] [, [slave host 2] [:port]] … [/[database]] [? propertyName=propertyValue1 [&propertyName2-propertyValue2]…].
QUESTION 72 You want to access your MySQL Cloud Service cloud environment from an external application based on ODBC. What are the required steps? A. Enable ora_p2admin_mysql, which opens port 3306 on the Access Rules tab. B. Enable SSH tunnel and access MySQL based on TCP/IP over SSH. C. Access to the OS (SSH) and MySQL (3306) are open by default. D. Switch to the Compute Cloud Service Dashboard and disable reject:*.public-internet E. Create a new SSH key for your ODBC connector.
QUESTION 73 The replication for a Master and Slave MySQL Servers is up and running. The disk space for Master Server is continuously growing. The binlog size keeps growing. Identify two methods to fix the issue A. Execute the PURGE BINARY LOGS statement without argument. B. On the Master server, disable binlog by removing the - - log –bin option. C. Delete all binlog files manually on the file system to release storage spaces. D. Set the expire_logs_days system variable to expire binary log files automatically after a given number of days. E. To safely purge binary log files, perform the following steps: 1. On each slave server, use SHOW SLAVE STATUS to check which log file it is reading. 2. Obtain a listing of the binary log files on the master server with SHOW BINARY LOGS. 3. Determine the earliest log file among all the slaves. This is the target file. If all the slaves are up-to-date, this is the last log file on the list. 4. Make a backup of all the log files you are about to delete. (This step is optional, but always advisable.) 5. Purge all log files up to but not including the target file by using the PURGE BINARY LOGS statement.
QUESTION 74 Your system is being swamped by business users running multiple ad hoc queries. What is a valid way to limit the resources for a particular user? A. MAX_CONNECTIONS B. MAX_UPDATES_PER_DAY C. MAX_QUERY_SIZE D. MAX_QUERIES_PER_HOUR E. CONNECTIONS_PER_HOUR.
QUESTION 75 Which command would you use to create a user named jenny for the localhost server with the hashed password SecretPass123!? A. CREATE USER ‘jenny’@localhost’ IDENTIFIED WITH HASH PASSWORD (‘SecretPass123!’); B. CREATE USER ‘jenny’@localhost’ IDENTIFIED BY SHA (‘SecretPass123!’, ‘256’); C. CREATE USER ‘jenny’@localhost’ WITH HASHED (password, ‘SecretPass123!’); D. CREATE USER ‘jenny’@localhost’ IDENTIFIED WITH sha_256PASSWORD by ‘SecretPass123!’;.
QUESTION 76 You want to prevent any unauthorized users from gaining access to the personal information of your employees, which is stored in the EMPLOYEE table in a MySQL database. How would you use the MySQL Enterprise Edition Firewall to prevent the following SQL injection attack from exposing the salaries of all your employees? SELECT fl_name, salary FROM EMPLOYEE WHERE fl_name= ‘JHacker’ OR 1=1; A. Create a blacklist of the SQL commands, which would restrict access to the EMPLOYEE table by using the DETECTING mode. B. Create a FIREWALL STORED PROCEDURE to block any external user from executing this SQL statement. C. Create a list of approved SQL users by using the INTERROGATION mode. D. Create a whitelist of approved SQL commands by using the RECORDING mode, and enable protection by changing it to PROTECTION mode.
QUESTION 77 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 Nodes Machine B with 2 x mysqld node Machine C with 2 x ndb_mgmd node B. setting up Master and Slave with MySQL Semi-Sync Replication Plugin C. creating an NFS volume with multiple running MySQL Server Instances attaching the same NFS Volume with the same datadir D. setting up three machines configured as follows: Machine 1: Data Node and mysqld node Machine 2: Data Node and mysqld node Machine 3: ndb_mgmd E. 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.
QUESTION 78 An existing MySQL Database environment has been doing backup and restore in a logical way by using the mysqldump and mysql client utilities. When the backup is started using mysqldump with single-transaction mode, the existing application has long wait time. When the restore is required, it takes more than three hours to restore. What are two benefits of using mysqlbackup from MySQL Enterprise Backup in this situation? A. MySQL Enterprise Backup does not back up system data so that it is much faster. B. MySQL Enterprise Backup provides tape backup integration by default. It has the virtual tape option, which allows backup to tape device directly without extra third-party software integration. C. mysqlbackup can back up tables with the InnoDB engine without blocking. The backup is hot with InnoDB. Together with Incremental Backup, mysqlbackup from MySQL Enterprise Backup shortens the backup windows. D. mysqlbackup utilities dump the full database into a SQL file, which is imported into the mysql client in single-thread mode. mysqlbackup restores data from physical backups. Physical backup methods are faster than logical methods because they involve only file coping without conversion E. mysqlbackup from MySQL Enterprise Backup allows logical backup with concurrency built in to get faster backup speed and restoration speed.
QUESTION 79 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. 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 D. Enable GTID by executing the following on MASTER and SLAVE: >set global GTID_ENALBED=on; E. Execute the following on SLAVE to enable GTID: >start slave io_thread - -gtid-mode=on;.
QUESTION 80 You have the following mysqlbackup-inc.cnf config file: [mysqlbackup] backup-dir=/home/mysql/backup/inc/mybackup backup-image=/home/mysql/backup/inc/mybackup/myimage.img incremental-backup-dir=/home/mysql/backup/inc incremental incremental-base=history:last_backup Which two commands allow MySQL Enterprise Backup to perform incremental backup based on the last full backup? A. # mysqlbackup --defaults-file=mysqlbackup-inc.cnf --port=3306 --host=127.0.0.1 –-user=mysqlbackup –- password –-with-timestamp backup B. # mysqlbackup –-defaults-file=mysqlbackup-inc.cnf –-port=3306 –-host=127.0.0.1 –-user=mysqlbackup –- password –-incremental backup-to-image C. # mysqlbackup –-defaults-file=mysqlbackup-inc.cnf –-port=3306 –-host=127.0.0.1 –-user=mysqlbackup –- password backup-incremental D. # mysqlbackup –defaults-file=mysqlbackup-inc.cnf –-port=3306 –-host=127.0.0.1 –-user=mysqlbackup –- password backup-to-incremental E. # mysqlbackup –-defaults-file=mysqlbackup-inc.cnf –-port=3306 –-host=127.0.0.1 –-user=mysqlbackup –- password incremental.
QUESTION 81 Your customer has provided you with the following server specifications: 64-bit, Oracle Linux 6, 24 Numa CPU cores, 48 GB memory, and sequential write-optimized drives in the /var/lib/seq-write directory. The customer wants you to optimize their MySQL 5.7.10 installation for the server resources available. Identify three correct configurations for this server setup. A. mysql_numa_interleave=ON, innodb_buffer_pool_instances=8, innodb_log_file_size=24G B. innodb_data_file_path=/var/lib/seq-write, innodb_buffer_pool_size=36G, innodb_page_cleaners=8 C. innodb_file_per_table=ON, innodb_numa_interleave=ON, lower_case_table_names=1 D. plugin_load= “thread_pool.so”, innodb_page_cleaners=12, innodb_log_group_home_dir=/var/lib/seq-write E. innodb_log_file_size=12G, innodb_buffer_pool_instances=12, innodb_buffer_pool_size=48G F. innodb_buffer_pool_instances=12, innodb_buffer_pool_size=24G, innodb_log_file_size=12G.
QUESTION 82 A MySQL server (Linux-based installation, Port 3306, default) needs to be monitored. The MySQL server and the MySQL Enterprise Monitor (MEM) are located in different security zones, which are protected with a firewall. Which port must be opened for MEM agentless monitoring? A. Port 21/tcp (ftp) from MySQL Enterprise Monitor to MySQL server B. Port 18443/tcp (Tomcat) from MySQL server to MySQL Enterprise Monitor C. Port 22/tcp (SSH) from MySQL Enterprise Monitor to MySQL server D. Port 3306/tcp (MySQL) from MySQL Enterprise Monitor to MySQL server.
QUESTION 83 You have configured MySQL Enterprise Transparent Data Encryption (TDE). What command would you use to encrypt a table? A. ALTER mysql.encryption SET tde_status = ‘YES’; B. UPDATE TABLE SET ENCRYPTION = ‘ON’; C. ALTER TABLE <table> ENCRYPTION = ‘Y’; D. ALTER INSTANCE ROTATE INNODB MASTER KEY;.
QUESTION 84 When working with the Linux operating system on a database cloud instance (non-RAC), which user accounts are available for database and non-database administration? A. admin, ora-cloud, and oracle B. administrator, opc, and oracle C. root, opc-administrator, and oracle through sudo D. cloud-admin, oracle, and root E. opc, oracle, and root (through sudo).
QUESTION 85 Identify three features of MySQL Enterprise Backup. A. You can edit the output file produced by a MySQL Enterprise Backup. B. You can back up individual tables or individual tablespaces with MySQL Enterprise Backup while your server instance is online. C. You can run the output file produced by a MySQL Enterprise Backup through a MySQL session because the output file consists of SQL statements. D. You can back up data that has changed since the last backup with incremental backup. E. You can validate the results of a MySQL Enterprise Backup to ensure that your backup has integrity.
QUESTION 86 You have a text file named “xyz.csv” exported from another system. [ ... ] You are asked to import data to a MySQL Database table named “country”. The table definition is as follows: [ ....... ] Identify the action that imports the data from Workbench or MySQL Client to the database correctly. A. Use the LOAD DATA INFILE syntax to load data into the database table. B. Use mysqlimport to load the mycountry.csv data file with the --csv option specified. C. Create a DIRECTORY LINK object on the database and use INSERT into mycountry SELECT * from mycountry.csv. D. Convert the data into MDI and restore the MySQL data from it.
QUESTION 87 What command should be used to execute a stored procedure named run_daily_report with the parameter 2016/12/31? A. SELECT SP run_daily_report (‘2016/12/31’) from mysql.procedures B. CALL run_daily_report (‘2016/12/31’); C. EXECUTE PROC run_daily_report INCLUDE PARAMETER (‘2016/12/31’); D. UPDATE PROCEDURE run_daily_report WHERE VARIABLE = (“2016/12/31’);.
QUESTION 88 You want to prevent your users from using a specific list of passwords. How would you implement this on your system? A. Specify the nonusable passwords via MySQL Enterprise Audit B. Store values in the mysql.user_invalid_passwords table C. Manually store the values in a file and use SHA-256 to check against the mysql.user table D. You cannot save a list of nonusable passwords in MySQ E. Store values in a plain-text file set by using the validate_password_dictionary_file command F. Set validate_password_dictionary_file=pass_dict.txt and store the nonusable passwords in the pass_dict.txt file in your data director.
QUESTION 89 Which two methods can change password expiration for a database user account? (Choose two.) A. Create a new database user account with an explicit password expiration time B. Use an ALTER USER command to change the password expiration C. Use the SET GLOBAL command to update the default password expiration time D. Update the my.cnf configuration to include default_password_lifetime=100 and restart the server.
QUESTION 90 You have installed MySQL 5.6.20 on Windows 2012. This MySQL Instance is monitored without an Enterprise Monitor Agent. You cannot see any MySQL queries. How can you enable this feature? A. MySQL query analyzing is available only in MySQL Version 5.7 and later. You need a later version of MySQL B. For query analyzing, it is mandatory to use a MySQL Enterprise Monitor agent on Windows 2012 Server. C. Use UPDATE performance_schema.setup_consumers SET enabled = ‘YES’ WHERE name=’statements_digest’; D. Use UPDATE performance_schema.setup_consumers SET enabled = ‘NO’ WHERE name = ‘statements_digest’;.
QUESTION 91 You want to create a copy of the City table and include all the data. The new table name is City_part. Which statement would accomplish this task? A. CREATE TABLE City_part AS SELECT * FROM City; B. CREATE TABLE City_part LIKE City INSERT INTO City_part * FROM City; C. CREATE TABLE City_part LIKE City; D. INSERT INTO City_part SELECT * FROM City;.
QUESTION 92 The following backup command is executed: mysqlbackup -–defaults-file=config/mysqlbackup.cnf -–compress -–port=3306 -–host=127.0.0.1 -– user=mysqlbackup –-password –-suspend-at-end backup *** log started ** …. 160308 14:43:00 mysqlbackup: INFO: Copying /home/mysql/data/07/test/xmltable.ibd (Barracuda file format). 160308 14:43:00 mysqlbackup: INFO: Completing the copy of innodb files. 160308 14:43:00 mysqlbackup: INFO: Preparing to lock tables: Connected to mysqld server. 160308 14:43:00 mysqlbackup: INFO: Starting to lock all the tables… 160308 14:43:00 mysqlbackup: INFO: All tables are locked and flushed to disk mysqlbackup: INFO: --suspendat- end option is specified. 160308 14:43:00 mysqlbackup: INFO: Suspending the backup procedure to wait until the marker file ‘/home/ mysql/backup/full/mybackup/datadir/ibbackup_suspended’ is deleted. …. *** log ended ** Which option allows mysqlbackup to continue backing up the rest of the data? A. Run a mysql command as follows.mysqlbackup will continue. mysql> resume mysqlbackup; B. Log in to the MySQL server and identify the processid, which issues GLOBAL READ LOCK. Connect the mysql session and terminate the session for the identified “processed” .mysqlbackup will continue C. An external program or manual work is to be executed to complete the backup and the marker file “/home/ mysql/backup/full/mybackup/datadir/ibbackup_suspended’ should be removed intentionally. After the file is removed, mysqlbackup will continue D. Issue a SIGTERM to the mysqlbackup process.mysqlbackup will continue E. Run a mysql command as follows,.mysqlbackup will continue. mysql>UNLOCK TABLES;.
QUESTION 93 Which three backup scenarios can be accommodated with MySQL Enterprise Backup? (Choose three.) A. making a backup directly into tape device by using MySQL Enterprise Backup Media Management Software (MMS) B. making partial backup and optimistic backup C. converting a database backup from another database vendor to MySQL D. making a single file backup by creating backups in single-file format E. creating a cloud backup.
QUESTION 94 Which three are part of the core MySQL architecture? (Choose three.) A. Parser B. mysqldump C. Disk parity/RAID D. Optimizer E. Storage engines.
QUESTION 95 You create two database tables as shown by the following CREATE TABLE statements: CREATE TABLE parent ( parent_id INT, name_first VARCHAR(30), name_last VARCHAR(30), PRIMARY KEY (parent_id) ); CREATE TABLE child ( child_id INT, parent_id INT, name_first VARCHAR(30), name_last VARCHAR(30), PRIMARY KEY (child_id) ); After populating both tables with data, which statement would produce an output of only the parents’ first and last names and the first and last names of the related children? A. SELECT * FROM parent, child LEFT JOIN (child) ON (child.parent_id=parent.parent_id); B. SELECT p1.name_first, p1.name_last, c1.name_first, c1.name_last FROM parent p1 LEFT JOIN child c1 ON (c1.parent_id=p1.parent_id); C. SELECT name_first, name_last FROM parent, child LEFT JOIN parent_id WHERE parent_id = child_id; D. SELECT * .name_first, *.name_last FROM BOTH parent, child WHERE parent_id IS EQUAL;.
Report abuse Terms of use
We use cookies to personalize your experience. If you continue browsing you will be accepting its use. More information.