1Z0-908 practice question 18 of 25
Examine this MySQL client command to connect to a remote database: mysql -h remote.example.org -u root -p --protocol=TCP --ssl-mode= Which two --ssl-mode values will ensure that an X.509-compliant certificate will be used to establish the SSL/TLS connection to MySQL?
Full set: 140 questionsThe VERIFYCA and VERIFYIDENTITY modes both mandate an encrypted SSL/TLS connection and perform validation of the server's X.509 certificate. VERIFYCA requires the connection to be encrypted and verifies the server certificate against a configured Certificate Authority (CA). VERIFYIDENTITY provides the highest level of security by performing the VERIFYCA checks and also verifying that the server hostname matches the identity in the certificate. These modes ensure the certificate is not only used but also authenticated, which is crucial for secure communication and preventing man-in-the-middle attacks.
A. REQUIRED: Forces encryption but performs no certificate validation, so the identity of the server is not authenticated.
D. PREFERRED: Does not ensure an encrypted connection, as it will fall back to an unencrypted one if SSL/TLS negotiation fails.
E. DISABLED: Explicitly disables SSL/TLS, resulting in an unencrypted connection where no certificate is used.
1. MySQL 8.0 Reference Manual, Section 6.3.1, "Configuring MySQL to Use Encrypted Connections". The documentation describes the behavior of each --ssl-mode value. It specifies that VERIFYCA will "verify the server CA certificate against the configured CA certificate" and VERIFYIDENTITY will "also verify that the server host name...matches the identity in the server certificate." This confirms that these two modes perform validation, which is a higher level of assurance than REQUIRED, which only forces encryption without validation.
Keep practicing
Take the free 1Z0-908 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other 1Z0-908 practice questions
- Question 2You must run multiple instances of MySQL Server on a single host. Which three methods are…
- Question 3Which two tools are available to monitor the global status of InnoDB locking? (Choose two…
- Question 4Which two MySQL Server accounts are locked by default? (Choose two.)
- Question 5All MySQL Server instances belonging to InnoDB Cluster have SSL configured and enabled. Y…
- Question 6t is a non-empty InnoDB table. Examine these statements, which are executed in one sessio…
- Question 8Examine this command, which executes successfully: $ mysqlrouter --bootstrap user@hostnam…
