Which two options are available to restore an Autonomous Data Warehouse? (Choose two.)
Click on the arrows to vote for the correct answer
A. B. C. D. E.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:
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).
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.