Question

In BigQuery, what is the difference between Backup/Recovery through Manual and Auto methods?

a) Manual backup requires user intervention, while Auto backup is automatic and scheduled.
b) Manual recovery is more reliable than Auto recovery.
c) Manual backup is a paid service, while Auto backup is free.
d) Manual backup is suitable for small datasets, while Auto backup is for large datasets.

Answer 1

The difference between Backup/Recovery through Manual and Auto methods in BigQuery is that Manual backup requires user intervention, while Auto backup is automatic and scheduled. Manual backup is a paid service, while Auto backup is free. Both methods ensure data recovery in case of accidental deletion or corruption.

Step-by-step explanation:

The difference between Backup/Recovery through Manual and Auto methods in BigQuery is that Manual backup requires user intervention, while Auto backup is automatic and scheduled.

Manual backup is a paid service, while Auto backup is free. However, both Manual and Auto methods ensure data recovery in case of accidental deletion or corruption.

Manual backup allows users to have more control over the process and is suitable for both small and large datasets. Auto backup, on the other hand, is convenient for regular, automated backups of large datasets.