QUESTION 1 Logical backups: These are backups that capture both the data and its logical structure within a database. These backups play a significant role in ensuring the migration of data from one database system to another is achieved through the creation of consistent database snapshots or extracting specific data subsets such as tables and views. Logical backups are usually performed at the application level rather than directly from the database files. The Data is exported to the database system in a human-readable format such as CSV files and SQL statements (Scott, 2023). Meanwhile, the advantages of logical backups include portability and flexibility. portability means that the database system can be backed up from one location and…show more content… n.d. - n.d. - n.d. https://www.upguard.com/blog/how-to-back-up-your-data.
Robb, D. (2023, September 14). 11. Data backup best practices. Enterprise Storage Forum -. https://www.enterprisestorageforum.com/backup/data-backup-best-practices/
Scott, P. (2023, August 30). Backup and recovery for databases: What you should know. Percona Database Performance Blog. https://www.percona.com/blog/backup-and-recovery-for-databases-what-you-should-know/
Sims, Z. 2023, March 30 -. The Ultimate Guide to Backup Strategy: 7 Essential Best Practices for Ensuring Data Safety - SecurIT360. SecurIT360.com - a secure online dating site. https://www.securit360.com/blog/the-ultimate-guide-to-backup-strategy-7-essential-best-practices-for-ensuring-data-safety/.
Team, D. (2023, May 22). Ensuring effective enterprise data backup: best practices and strategies. DataBank | Data Center Evolved. https://www.databank.com/resources/blogs/ensuring-effective-enterprise-data-backup-best-practices-and-strategies/
Top 10 security best practices for securing backups in AWS | Amazon Web Services. 2022, January 12 -. Amazon Web Services.
