MCQs

Disclaimer:

Educational Use Only:

The website links provided are to be used strictly for educational and knowledge-gaining purposes only.

No Misuse:

Do not misuse the links or the information contained therein for any commercial, illegal, or unethical activities.

Respect for Websites and Businesses:

Respect the intellectual property and business interests of the websites and their owners. Do not attempt to alter, copy, or redistribute content without proper authorization.

Acknowledge Value of Knowledge:

Recognize and value the knowledge and resources shared by these websites. Use the information responsibly and ethically.

No Endorsement:

The provision of these links does not imply endorsement of the linked sites, their content, or their products and services. Users are responsible for evaluating the suitability and accuracy of the information.

User Responsibility:

By accessing these links, you agree to use the information at your own risk and to comply with all applicable laws and website terms of use.

1. Which technique ensures that an application’s in-memory and pending I/O data is safely written to disk before backup?
   a. Crash-consistent backup
   b. Application-consistent backup
   c. File-level backup
   d. Image-based backup
   Answer: bn2ws+2
2. Which Windows feature is commonly used to achieve application-consistent backups?
   a. BitLocker
   b. Volume Shadow Copy Service (VSS)
   c. Windows Firewall
   d. NTFS Journaling
   Answer: bunitrends+1
3. In the context of database applications like SQL Server, which backup state guarantees transactional data integrity?
   a. Crash-consistent
   b. Snapshot
   c. Application-consistent
   d. Incremental
   Answer: cnakivo+2
4. What happens if an application’s pending writes aren’t flushed to disk before a backup?
   a. The backup is inconsistent
   b. Backup is smaller
   c. No effect on data integrity
   d. Backup is faster
   Answer: an2ws+1
5. Which component inside a VM coordinates with VSS to ensure application-consistent backups?
   a. VSS Requester
   b. VSS Writer
   c. VSS Reader
   d. VSS Subscriber
   Answer: bunitrends+1
6. Application-consistent backups are sometimes referred to as:
   a. Application-aware backups
   b. Crash-only backups
   c. File-dump backups
   d. Hot backups
   Answer: anakivo
7. What is the main advantage of an application-consistent backup?
   a. Data can be restored to a fully working state without extra steps
   b. Backups are faster
   c. Less storage required
   d. Backup window is reduced
   Answer: an2ws+2
8. In a crash-consistent backup, what data is usually NOT captured?
   a. OS files
   b. Application logs
   c. In-memory and pending I/O data
   d. Database files
   Answer: cnakivo+1
9. What mechanism is often used on Linux systems to achieve application-consistency?
   a. Linux VSS Writer
   b. Pre-freeze and Post-thaw scripts
   c. Sudo snapshots
   d. Ext4 Journaling
   Answer: bnakivo
10. What may be required after restoring a crash-consistent backup of a database?
    a. Nothing
    b. Reboot
    c. Manual recovery or log replay
    d. File deletion
    Answer: cnakivo
11. Which of the following best describes an application-consistent backup?
    a. Backup of individual files only
    b. Snapshot with all app and transactional data quiesced
    c. Partial copy of running application
    d. Backup only when system is powered off
    Answer: bunitrends+2
12. In virtual environments, which technology helps achieve application-consistency?
    a. Hypervisor Integration Services
    b. RDP
    c. SSH
    d. NFS shares
    Answer: aunitrends
13. Application-consistent backups always guarantee which type of database property?
    a. ACID compliance
    b. BASE property
    c. NoSQL compliance
    d. Flat file consistency
    Answer: asanfoundry
14. Which of the following is not a benefit of application-consistent backups?
    a. Reduced risk of data loss
    b. Transactional consistency
    c. Data written only in memory
    d. Recovery without data integrity concerns
    Answer: cn2ws+2
15. For a running SQL Server VM, what ensures backup consistency including committed transactions?
    a. VSS Writer communication
    b. Manual snapshot
    c. File export
    d. Cold backup
    Answer: aunitrends+1
16. What does the pre-freeze script do during Linux VM application-consistent backup?
    a. Thaws I/O
    b. Quiesces I/O and writes buffers to disk
    c. Deletes old backups
    d. Restarts services
    Answer: bnakivo
17. What is the impact of NOT using application-consistent backups for transactional databases?
    a. No impact
    b. Increased risk of data corruption upon recovery
    c. Faster restores
    d. Smaller backup size
    Answer: bn2ws+1
18. Which backup type is equivalent to pulling the power from the server while active?
    a. Synthetic backup
    b. Crash-consistent backup
    c. Application-consistent backup
    d. Incremental backup
    Answer: bunitrends+1
19. Application-consistent backups are essential for all EXCEPT:
    a. Databases
    b. File shares
    c. Simple static websites
    d. Transactional email servers
    Answer: cn2ws+2
20. Upon backup request, what does the backup software notify via VSS for application consistency?
    a. Operating system only
    b. Storage subsystem only
    c. Registered application VSS writers
    d. Hypervisor only
    Answer: cunitrends+1
21. Which backup should be used to ensure no data corruption in applications using frequent disk and memory access?
    a. Crash-consistent
    b. Application-consistent
    c. Manual copy
    d. Log shipping
    Answer: bn2ws+2
22. Which action is performed as part of making a snapshot application-consistent?
    a. Deleting logs
    b. Flushing memory buffers to disk
    c. Disabling networking
    d. Locking user accounts
    Answer: bnakivo+2
23. On Azure workloads, what state is aimed for before taking application-consistent backups?
    a. Paused
    b. Quiesced
    c. Live-active
    d. Offline
    Answer: bn2ws
24. Which of the following is not a property achieved by application-consistent backup?
    a. Replay of incomplete transactions is required
    b. Transactional freeze
    c. No post-restore manual recovery
    d. Write order fidelity
    Answer: aunitrends+2
25. Which component is NOT directly involved in VSS-based application-consistent backup?
    a. VSS Requester
    b. VSS Writer
    c. VSS Provider
    d. DNS Resolver
    Answer: dnakivo+1
26. During backup, the term “quiesce” refers to:
    a. Deleting old files
    b. Stopping all operations
    c. Pausing application to flush data, creating a consistent state
    d. Restarting application
    Answer: cn2ws+2
27. Which of the following best ensures backup includes recent in-flight transactions?
    a. Cold backup
    b. Application-consistent backup
    c. File copy
    d. Crash-consistent backup
    Answer: bunitrends+2
28. Volume Shadow Copy Service operates as part of which operating system to achieve application consistency?
    a. Linux
    b. Mac OS
    c. Windows
    d. BSD
    Answer: cnakivo+1
29. What may occur if crash-consistent backup is used for a critical database application?
    a. All data consistent, ready for instant restore
    b. Need post-restore log replay and risk of corruption
    c. No recovery possible
    d. Files are all encrypted
    Answer: bunitrends+1
30. A backup which requires manual application intervention after restore is likely:
    a. Application-consistent
    b. Crash-consistent
    c. Log-based
    d. Mirror backup
    Answer: bnakivo+1
31. Which property is NOT associated with application-consistent backup?
    a. Captures in-memory changes
    b. Captures pending I/O
    c. Guarantees point-in-time integrity
    d. Ignores transactional state
    Answer: dn2ws+2
32. In a backup utility, specifying ‘application-aware’ ensures:
    a. Only files are backed up
    b. Application and OS are both paused for a consistent state
    c. Only system states are backed up
    d. Only static files are captured
    Answer: bnakivo
33. Which statement best describes transactional consistency in application-consistent backups?
    a. Captures only the file structure
    b. Captures all committed transactions and flushes in-transit data
    c. Snapshots only memory state
    d. Captures only one application
    Answer: bn2ws+2
34. Why are post-restore steps minimized in application-consistent backups?
    a. Data is agentless
    b. App is offline during backup
    c. In-memory and pending I/O are flushed, no rollbacks required
    d. All files are encrypted
    Answer: cunitrends+2
35. Application-consistent backups are critical for which restoration goal?
    a. Read-only restore
    b. Operational continuity with no data loss
    c. Shorter backup times
    d. Multi-location restore
    Answer: bn2ws+2
36. Which occurs first in VSS-enabled application-consistent backup?
    a. Files are copied
    b. Memory is flushed to disk by VSS writers
    c. OS is rebooted
    d. File permission change
    Answer: bunitrends+1
37. Which backup approach is typically used for legacy applications not supporting VSS?
    a. Crash-consistent
    b. File-level with downtime
    c. Log-based copy
    d. Hot backup
    Answer: bnakivo+1
38. Pending I/O refers to:
    a. Data already written to disk
    b. Data still in buffers, not yet written to storage
    c. Data in cloud
    d. Unused space
    Answer: bn2ws+1
39. Application-consistent backups in cloud environments are vital for:
    a. Static web pages
    b. Stateless functions
    c. Stateful apps with complex transactions
    d. All scripting files
    Answer: cnakivo+1
40. In virtual platforms (like Hyper-V/VMware), what integration ensures application-consistent backups?
    a. Guest tools/Integration services
    b. Snapshot-only
    c. Partial VM export
    d. File sharing
    Answer: aunitrends+1
41. If a backup is taken midway through an uncommitted transaction, what type of backup is it likely to be?
    a. Application-consistent
    b. Crash-consistent
    c. Consistency not guaranteed
    d. Log-only
    Answer: bn2ws+1
42. Which scripting is used in Linux environments for app-consistent backup?
    a. Pre-freeze and post-thaw scripts
    b. Bash only
    c. init.d scripts
    d. Service scripts
    Answer: anakivo
43. The ability for multiple writes to occur in a consistent order across distributed systems is known as:
    a. Write order fidelity
    b. Write amplification
    c. Write cycle
    d. Write discard
    Answer: aunitrends+2
44. Which backup method most reduces the risk of restoring to a corrupt state?
    a. Crash-consistent
    b. Application-consistent
    c. File-copy
    d. Tape only
    Answer: bn2ws+2
45. What is ensured in an application-consistent backup for a running mail server?
    a. In-memory messages are flushed and pending deliveries committed
    b. Only disk files copied
    c. User accounts are paused
    d. Sent emails are deleted
    Answer: aunitrends+1
46. To ensure a consistent application backup, database logs must be:
    a. Flushed and synchronized with data files
    b. Deleted before backup
    c. Encrypted during backup
    d. Left unmodified
    Answer: anakivo+2
47. Which best describes the snapshot of a crash-consistent backup?
    a. Catches application mid-operation, may need additional recovery
    b. Waits for application to reach quiescent state
    c. Backs up only log files
    d. Captures only application binaries
    Answer: aunitrends+1
48. Application-consistent backups allow recovery:
    a. Without incomplete transactions needing replay
    b. Only when app is offline
    c. Only during scheduled window
    d. Only for flat files
    Answer: an2ws+2
49. In distributed databases, ensuring all nodes reflect latest committed state relates to:
    a. Application consistency
    b. Partial consistency
    c. Session consistency
    d. Eventual consistency
    Answer: ageeksforgeeks+1
50. Who is ultimately responsible for triggering application-consistent state prior to a backup operation?
    a. The application developer
    b. The backup software (via VSS or scripts)
    c. The system administrator only
    d. The storage array
    Answer: bnakivo+1

1. https://n2ws.com/blog/microsoft-azure-cloud-services/application-consistent-azure
2. https://www.unitrends.com/blog/application-consistency-agent-agentless-protection-virtual-machine-backups/
3. https://www.nakivo.com/blog/crash-consistent-vs-application-consistent-backup/
4. https://www.sanfoundry.com/cloud-computing-questions-answers-applications-clouds/
5. https://www.geeksforgeeks.org/system-design/consistency-in-system-design/
6. https://www.designgurus.io/blog/consistency-patterns-distributed-systems
7. https://cybotech.in/start-quiz/100-mcqs-database-backup-recovery-rdbms-quiz-online-test
8. https://trilio.io/resources/application-consistent-vs-crash-consistent-backup/
9. https://help.msp360.com/cloudberry-backup/backup/vmware/app-consistent
10. https://testbook.com/objective-questions/mcq-on-software-requirement–5eea6a0839140f30f369d71a
11. https://testbook.com/objective-questions/mcq-on-cloud-technology–5eea6a0d39140f30f369e30f
12. http://mcqquestion.blogspot.com/2012/08/application_11.html
13. https://www.metaplane.dev/blog/data-consistency-definition-examples
14. https://siteforinfotech.com/2014/12/mcq-on-database-backup-recovery-dbms.html
15. https://www.biz4solutions.com/blog/top-web-application-development-mcq-questions-to-ace-your-exam/
16. https://www.ramotion.com/blog/application-server-definition-workflow-comparison/
17. https://infohub.delltechnologies.com/fr-fr/l/dell-powerstore-microsoft-sql-server-best-practices-1/sql-server-application-consistent-backup/
18. https://javatechonline.com/java-microservices-mcq-questions/
19. https://www.geeksforgeeks.org/operating-systems/consistency-model-in-distributed-system/
20. https://www.sanfoundry.com/1000-database-management-system-questions-answers/