Whenever possible, all storage space should be minimized for all databases and all backups. Error Handling There is currently no error handling code in any stored procedure. You plan to log errors in called stored procedures and nested stored procedures. Nested stored procedures are never called directly. You need to recommend a disaster recovery strategy for the Inventory database. What should you include in the recommendation? A Datum has limited storage. B. Log shipping C. SQL Server Failover Clustering D. AlwaysOn availability groups E. Peer-to-peer replication
正解:
A,B Explanation/Reference: Explanation: Scenario: - You must be able to recover data from the Inventory database if a storage failure occurs. You have a Recovery Point Objective (RPO) of one hour. - A Datum Corporation has offices in Miami and Montreal. - SQL Server Log shipping allows you to automatically send transaction log backups from a primary database on a primary server instance to one or more secondary databases on separate secondary server instances. The transaction log backups are applied to each of the secondary databases individually.