Oracle Cloud Infrastructure 2019 Cloud Operations Associate — Question 8

Your Database as a Service (DBaaS) instance hosts a multitenant container database (CDB) with four pluggable database (PDB) tenants.
Users of an application in one PDB and users of another application in another PDB complain of poor performance.
Investigation shows that the application sessions are not using excessive CPU nor are they requesting an unusual amount of I/O.
Which two steps should you perform to resolve this problem?

Answer options

• A. Add storage to the DBaaS instance.
• B. Add CPU to the DBaaS instance.
• C. Examine the shares of resources allocated to each PDB within the CDB.
• D. Examine the shares of resources allocated to each consumer group within all four PDBs.
• E. Examine the shares of resources allocated to each consumer group within the PDBs that contain the two applications.
• F. Add memory to the DBaaS instance.

Correct answer: E, F

Explanation

The correct answer is E and F because examining the shares of resources allocated to the consumer groups within the PDBs of the applications can highlight any imbalances affecting performance. Adding memory to the DBaaS instance can also help improve overall performance. The other options may not directly address the specific issues related to resource allocation and application performance.