Key Benefit of Using Oracle Cloud Infrastructure Autonomous Data Warehouse

B.

The key benefit of using Oracle Cloud Infrastructure Autonomous Data Warehouse is scalability without downtime, as option B suggests.

Oracle Cloud Infrastructure Autonomous Data Warehouse is a fully-managed, cloud-native database service that eliminates the need for complex database management tasks, such as infrastructure provisioning, patching, and backup/recovery.

The service is designed to provide elastic scalability, which means that it can automatically scale up or down based on workload demands. This is possible because the service uses a shared architecture that pools compute and storage resources, allowing it to scale both CPU and storage independently.

By using Autonomous Data Warehouse, organizations can benefit from reduced operational overhead, increased agility, and improved performance. In addition, because the service is fully managed, organizations do not need to worry about applying database patches or maintaining root-level access to the underlying operating system.

Option C is partially correct, as Autonomous Data Warehouse does apply patches as they become available, but this is not the key benefit of the service. Option A is incorrect, as Autonomous Data Warehouse is a fully-managed service, so users do not have root-level access to the underlying operating system. Option D is incorrect, as users still require a username and password to access Autonomous Data Warehouse.