When creating a Bastion service to connect to a MySQL DB system, the following are true:
The Bastion CIDR block allowlist must include the IP address of all valid client machines(Answer C): This ensures that only the IP addresses specified in the allowlist can access the Bastion service, enhancing security by restricting access to known clients.
The Bastion subnet must have an ingress rule to allow stateful connections on the MySQL DB system port number(Answer E): This allows the Bastion service to communicate with the MySQL DB system by permitting traffic through the necessary ports.
References:
OCI Bastion Service Documentation
Setting Up Bastion with MySQL DB System
Question # 18
Why would you select "Source cannot use GTID auto-positioning" when creating a channel?
A.
The target DB system is a high-availability DB system.
When creating a replication channel and selecting "Source cannot use GTID auto-positioning", it typically indicates that the source's GTID mode is off. GTID (Global Transaction Identifier) auto-positioning allows for automated recovery and positioning of transactions in replication, but it requires that GTID mode be enabled on the source database.
[: MySQL documentation:Global Transaction ID, ]
Question # 19
What is the benefit of creating a new DB system with data import?
Creating a new DB system with data import provides the benefit of faster import with minimal logging. This process is optimized to import large datasets efficiently and quickly, reducing the amount of logging overhead and ensuring a rapid setup of the new DB system.