Exam 1z0-078 All QuestionsBrowse all questions from this exam
Question 47

You support a RAC database with these characteristics:

1. There are six instances.

2. Server Pool prod has a maximum of four servers.

3. CRM is a policy managed, uniform service using Server Pool prod.

4. ERP is a policy managed, singleton service using Server Pool prod.

5. Grid infrastructure is installed and running in its default configuration.

Which four benefits are provided by this configuration in Oracle 19c? (Choose four.)

    Correct Answer: A, C, F, G

    Based on the given RAC database characteristics, the configuration provides the following benefits in Oracle 19c: High availability for the CRM service as it uses a uniform service with a policy-managed configuration. High availability for the ERP service as it uses a singleton service, ensuring it runs on one of the servers in the pool with failover capability. Load balancing of client connection requests for ERP across three Single Client Access Name (SCAN) listeners is valid since it is a singleton service and SCAN listeners facilitate connection management. Load balancing of connection requests for CRM across all database instances running on servers in the prod pool is ensured by the configuration, utilizing all available instances in the specified server pool.

Discussion
krwi1Options: ACFG

D is wrong - there are only three scan listeners (by default and recommended) F is correct (there is only singleton service but connection can be load balanced across three scan listeners)