Which two are available when creating a new MySQL DB system in OCI Console? (Choose two.)
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Correct Answer:
A, C
Q: 2
You want to import data into a DB system with MySQL Shell util.loadDump().
Which option can speed up the load?
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Correct Answer:
C
Q: 3
You have a MySQL DB system with five active read replicas. The workload consists of 5% writes and
95% reads.
Which connection method provides the fastest query response time?
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Correct Answer:
C
Q: 4
You create a new MySQL DB system. It fails because you use mysql.sys as the administrator
username.
What is the reason?
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Correct Answer:
A
Q: 5
You create a MySQL DB system with default port numbers, and attach it to a subnet.
Which configuration is required on the subnet to enable client applications to connect to the DB
system?
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Correct Answer:
C
Q: 6
You want to replicate data from an on-premises MySQL server to a MySQL DB system. The on-
premises MySQL server runs in your corporate network. The MySQL server accepts incoming
connections from the Internet on a public IP endpoint.
The DB system runs in Oracle Cloud Infrastructure. The DB system endpoint is connected to a private
subnet of a VCN.
Which network configuration is required?
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Correct Answer:
A
Q: 7
Which three must be provided when creating a channel? (Choose three.)
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Correct Answer:
A, C, D
Q: 8
Which placement is NOT valid for a high-availability DB system? (Note: AD refers to availability
domain and FD refers to fault domain.)
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Correct Answer:
D
Q: 9
You want to create a custom configuration for the MySQL DB system in OCI Console. Which three can
you set? (Choose three.)
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Correct Answer:
A, C, E
Q: 10
You have successfully provisioned a MySQL DB system on Oracle Cloud Infrastructure by using OCI
Console. You have installed the standard MySQL client libraries and MySQL Shell on your workstation
that is not connected to any VPN, FastConnect, or SSH tunnel.
You CANNOT connect directly to the DB system endpoint from your workstation connected to the
Internet.
What is the reason?
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Correct Answer:
B
Q: 11
Which is true about automatic DB system version upgrades?
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Correct Answer:
C
Q: 12
You want to restore the backup of a stand-alone DB system to a new DB system.
Which two changes are allowed? (Choose two.)
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Correct Answer:
B, C
Q: 13
Which two are benefits of read replicas? (Choose two.)
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Correct Answer:
A, D
Q: 14
You want to create a new DB system with data import. How do you prepare the data?
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Correct Answer:
B
Q: 15
You have an inbound replication channel that replicates data from one DB system to another DB
system. Both DB systems are created with the default configuration.
You encountered the following error on the target DB system:
What is the possible cause?
