You will configure a MySQL Server to act as a replication master. Which two options must be configured correctly to allow this? (Choose two.)

• A.log-bin
• B.log-master-updates
• C.master-logging
• D.server-id
• E.rpl-recovery-rank
• F.enable-master-start

Comment: *

Name: *

Email: *

Verification: *

You are setting up a new installation of MySQL Server 5.7 (a GA release.) You have used a ZIP or TAR package to ensure that the mysqld binary, along with its support files, such as plug-ins and error messages, now exist on the host. Assume that the default datadir exists on the host.
You installed the binary in the default location (the default --basedir value) for your operating system.
Which step should you perform before defining your own databases and database tables?

• A.Execute a command with a minimal form of: mysql --initialize
• B.Create additional login accounts (so that everyone does not need to log in as root) and assign them appropriate privileges.
• C.Set an exception in the host machine's firewall to allow external users to talk to mysqld.
• D.Register mysqld as a service that will start automatically on this host machine.
• E.Create a configuration file containing default-storage-engine=InnoDB.

Comment: *

Name: *

Email: *

Verification: *

You are no longer able to log in to an existing MySQL Server because the root password credentials not working. You need to reset the root password to complete various administrative tasks. What are the two major methods that will achieve this?

• A.Start the MySQL Server in --safe-mode, which only loads the privilege system for changes as data is inaccessible.
• B.Start the MySQL Server with reset-root-password in my.cnf, which will prompt you to enter a new root user password.
• C.Start the MySQL Server with --init-file pointing to SQL that executes an ALTER USER statement to change the root user password.
• D.Start the MySQL Server with --skip-grant-tables and execute SQL, which will update the root password.
• E.Start the MySQL Server with --initialize-insecure to force a password reset procedure on the command line.

Comment: *

Name: *

Email: *

Verification: *

Which two general properties relate to the mysqlimport client program? (Choose two.)

• A.It bypasses the server and writes directly to the data files.
• B.It can load files both on the client host and the server host.
• C.It can load files only on the server host.
• D.It provides a command-line interface to the LOAD DATA INFILE.
• E.It can be used to easily import full binary backups.

Comment: *

Name: *

Email: *

Verification: *

A particular government's security policy is to have very strict data encryption and safety settings. This is done by restricting access based on their own CA authority and limiting access to particular users within a department. Which method could be used to restrict access as required?

• A.using GRANT USAGE, X509, .......ON *.* TO user@remotehost IDENTIFIED BY `secret_password'
• B.using GRANT ... REQUIRE SSL for a secure connection
• C.using GRANT ... REQUIRE X509 AND REQUIRE ISSUER `/C=.....' AND REQUIRE SUBJECT `/C=.....'
• D.using GRANT USAGE, SSL, .....ON *.* TO user@remotehost IDENTIFIED BY `secret_password'

Comment: *

Name: *

Email: *

Verification: *