Online Access Free 1z1-883 Practice Test

A Mysql instance is running on a dedicated server. Developers access the server from the same network subnet. Users access the database through an application that is running on a separate server in a DMZ.
Which two will optimize the security of this setup?

• A.Starting the server with - bind- address=0.0.0.0 specified
• B.Enabling and using SSL for connections to the Mysql database
• C.Disabling connections from named pipes or socket files (depending on the operating system of the server)
• D.Installing Mysql on the application server, and running the database and application on the same server
• E.Running the server with - skip-networking specified
• F.Limiting logins to originate from the application server or the server's subnet

MySQL is installed on a Linux server and has the following configuration:
[mysqld]
User=mysql
Datadir=/data/mysql
As the 'root' user, change the datadir location by executing:
Shell> cp -R /var/lib/mysql/data/mysql/
Shell> chown -R mysql /data/mysql/
What is the purpose of changing ownership of datadir to the 'mysql' user?

• A.The mysqld process requires all permissions within datadir to be the same.
• B.MySQL requires correct file ownership while remaining secure.
• C.MySQL needs to be run as the root user, but file cannot be owned by it.
• D.MySQL cannot be run as the root user.

Which three data components are needed for point-in-time recovery?

• A.The data backup
• B.Binary logs
• C.The backup log
• D.The error log
• E.Configuration files
• F.The general query log

You have a login-path named "adamlocal" that was created by using the mysql_config_editor command.
You need to check what is defined for this login_path to ensure that it is correct for you deployment.
You execute this command:
$ mysql_config_editor print -login-path=adamlocal
What is the expected output of this command?

• A.The command prints all parameters for the login-path. The password is shown only when you provide the -password option.
• B.The command prints all parameter for the login-path. The password is replaced with stars.
• C.The command prints the encrypted entry for the login-path. The is only possible to see if an entry exists.
• D.The command prints all parameters for the login-path. The password is printed in plain text.

Which two capabilities are granted with the SUPER privilege?

• A.Allowing a client to shut down the server
• B.Allowing client accounts to take over the account of another user
• C.Allowing a client to kill other client connections
• D.Allowing change of the server runtime configuration