Which can be Scaled independently of the number of CPUs in an Autonomous Database? (Choose the best answer.)
Click on the arrows to vote for the correct answer
A. B. C. D. E.B.
The correct answer is B. Storage.
Autonomous Database is a cloud-based database management system that provides automation and self-driving capabilities, making it easier for users to manage their databases. It allows users to create, manage, and scale databases quickly and easily without needing much knowledge about the underlying infrastructure.
Autonomous Database offers several features that enable users to scale their databases based on their business requirements. These features include:
A. Sessions: The number of user sessions that can be established in an Autonomous Database is determined by the number of CPUs allocated to the database. Therefore, the number of sessions that can be supported is directly proportional to the number of CPUs. Hence, this option is incorrect.
B. Storage: The amount of storage that can be allocated to an Autonomous Database can be scaled independently of the number of CPUs. The amount of storage can be increased or decreased dynamically based on the user's requirements. Hence, this option is the correct answer.
C. Parallelism: Autonomous Database provides parallelism for SQL processing, which enables multiple SQL statements to be executed simultaneously. The degree of parallelism is determined by the number of CPUs allocated to the database. Therefore, the level of parallelism that can be supported is directly proportional to the number of CPUs. Hence, this option is incorrect.
D. Concurrency: Concurrency refers to the number of users that can access the database simultaneously. The level of concurrency that can be supported in an Autonomous Database is determined by the number of CPUs allocated to the database. Therefore, the level of concurrency that can be supported is directly proportional to the number of CPUs. Hence, this option is incorrect.
E. Memory: The amount of memory that can be allocated to an Autonomous Database is determined by the number of CPUs allocated to the database. Therefore, the amount of memory that can be allocated is directly proportional to the number of CPUs. Hence, this option is incorrect.
In conclusion, the amount of storage that can be allocated to an Autonomous Database can be scaled independently of the number of CPUs. Therefore, option B is the correct answer.