Explanation:Automatic checkpoints whose target recovery interval is specified by the user defined setting of the sp_configure recovery interval option. 9. Internal checkpoint are generated in response to the following event :
A. A database snapshot is deleted, whether explicitly or internally for DBCC CHECK
B. Bringing a SQL Server failover cluster instance (FCI) offline
C. Bringing a SQL Server failover cluster instance (FCI) online
D. None of the mentioned
Answer:A
Explanation:Automatic checkpoints whose target recovery interval is specified by the user defined setting of the sp_configure recovery interval option. 9. Internal checkpoint are generated in response to the following event :
A. A database snapshot is deleted, whether explicitly or internally for DBCC CHECK B. Bringing a SQL Server failover cluster instance (FCI) offline C. Bringing a SQL Server failover cluster instance (FCI) online D. None of the mentioned
Explanation:Internal Checkpoints are generated by various server components to guarantee that disk images match the current state of the log. 10. __________ backups are taken in bulk or full recovery models only.