Data Backup and Mirroring — Learn free

Self-check

Questions 1–10 of 10

1. What is the main purpose of data backup?
Question 1A. To create an identical replica for User Acceptance TestingB. To speed up queries on active databasesC. To safeguard information for future use, regulatory adherence, or retrieval in the event of lossD. To distribute data evenly across cluster nodesE. To give developers a fresh copy of data each morning
2. In the banking example for data backup, how long must customer data be retained after the customer leaves the bank?
Question 2A. A minimum of seven yearsB. One yearC. Three monthsD. Twelve months after the account is closedE. Indefinitely, with no time limit
3. According to the banking example, how long is data about active customers kept?
Question 3A. Seven yearsB. Until the next annual backupC. Ninety daysD. Only while the account has a balanceE. Indefinitely
4. Which active databases are named as housing the particular data that decision support systems demand?
Question 4A. Tape libraries and object storageB. OLTP (Online Transaction Processing) and OLAP (Online Analytical Processing)C. Spreadsheets and flat filesD. Mirrored laptops and workstationsE. Archive and cold storage
5. Which technologies are mentioned for backing up data that is not needed operationally?
Question 5A. In-memory cachesB. OLAP cubesC. Solid-state drives inside the production serverD. Tape drives or affordable storage such as Object StorageE. Mirrored laptops
6. What is the key distinction between data mirroring and data backup?
Question 6A. Mirroring is not about long-term retention but about establishing a starting point from which data can be restoredB. Mirroring keeps data for longer than backup doesC. Mirroring only applies to databases while backup applies to filesD. Mirroring is required by regulation while backup is optionalE. Mirroring compresses data while backup does not
7. In the laptop example of data mirroring, when would a user restore from the mirrored copy?
Question 7A. When the laptop is soldB. When a regulator requests historical recordsC. When the laptop's storage is fullD. When moving data to a colleague's machineE. When data is corrupted by bugs, viruses or patches, to revert to a previous state
8. Within the data domain, for which testing activity is data mirroring used?
Question 8A. Penetration testingB. Load testing of network linksC. User Acceptance Testing (UAT), where an identical replica is created for business users to testD. Unit testing of individual functionsE. Regulatory compliance audits
9. How do backup and mirroring differ regarding incremental updates?
Question 9A. Both are always incrementalB. Backups can be incremental, saving only changes since the last backup, while mirroring does not involve incremental updatesC. Mirroring is incremental while backups always copy everythingD. Neither can be incrementalE. Only cloud backups can be incremental
10. Which of these is NOT listed as a frequency on which backups can be performed?
Question 10A. DailyB. WeeklyC. QuarterlyD. HourlyE. Annual