Options for Restoring an Autonomous Data Warehouse

BE.

Sure, I'll provide a detailed explanation of the available options to restore an Autonomous Data Warehouse in Oracle Cloud.

An Autonomous Data Warehouse (ADW) is a fully-managed cloud service that provides a high-performance, elastic, and scalable data warehouse for analytics. ADW is built on Oracle's Autonomous Database technology, which provides self-driving, self-securing, and self-repairing capabilities.

To restore an Autonomous Data Warehouse, there are two options available, which are as follows:

1. Select the snapshot of the backup: One option to restore an ADW is to select the snapshot of the backup. This option allows you to restore the database to a previous state by selecting a snapshot of the database taken at a specific point in time. Snapshots are taken automatically every 24 hours and can be retained for up to 7 days. You can also manually take a snapshot of the database at any time using the Oracle Cloud Infrastructure Console or the CLI (Command-Line Interface).

2. Specify the point in time (timestamp) to restore: Another option to restore an ADW is to specify the point in time (timestamp) to restore. This option allows you to restore the database to a specific point in time by specifying the timestamp. This can be useful if you need to recover from data loss due to a user error or a system failure. This option requires that you have enabled the backup and recovery feature in the Autonomous Data Warehouse.

Therefore, the correct options are A (Select the snapshot of the backup) and E (Specify the point in time (timestamp) to restore). Option B is incorrect because you do not select the backup, but instead, you select the snapshot of the backup. Option C is incorrect because backup and recovery in ADW does not require Recovery Manager (RMAN). Option D is also incorrect because you do not select the archived redo logs for restoring an ADW.