File Info
| Exam | MySQL Cloud Service 2018 Implementation Essential |
| Number | 1z0-320 |
| File Name | Oracle.1z0-320.CertKiller.2019-02-27.79q.tqb |
| Size | 465 KB |
| Posted | Feb 27, 2019 |
| Download | Oracle.1z0-320.CertKiller.2019-02-27.79q.tqb |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: MASTEREXAM
With discount: 20%
Demo Questions
Question 1
By using the asynchronous MySQL Replication architecture, data can be replicated to slaves. Identify three use cases of MySQL Replication.
- MySQL Replication Connector/J (ReplicationDriver) is provided to allow read capability on slave and write capability on master.
- MySQL Enterprise Backup will back up from Slave automatically.
- It provides multi-master access where the application can write and read data across the database servers.
- It allows backup to be done on the slave without impacting the master.
- 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.
Correct answer: BDE
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?
- 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.
- 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.
- 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.
- 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.
- Logins are granted only if the user’s client application and the corresponding MySQL instance are on the same IP address.
Correct answer: BD
Question 3
You get a Maintenance notification about your Oracle MySQL Cloud Service. What are the implications?
- There are no maintenance operations planned. You need to do them manually.
- Depending on the planned outage, you may not be affected by it. You need to read the maintenance details in the support notice.
- You need to agree to the maintenance windows. If not, you are not affected by the outage.
- You can expect an outage of your MySQL Cloud Service during the planned time.
Correct answer: D
