Câu 21: 70-462: MCSA Administering Microsoft SQL Server 20122014 Databases
You administer a Microsoft SQL Server 2012 instance. The instance contains a database that supports a retail sales application. The application generates hundreds of transactions per second and is online 24 hours per day and 7 days per week. You plan to define a backup strategy for the database. You need to ensure tha…
Nội dung câu hỏi
You administer a Microsoft SQL Server 2012 instance. The instance contains a database that supports a retail sales application. The application generates hundreds of transactions per second and is online 24 hours per day and 7 days per week. You plan to define a backup strategy for the database. You need to ensure that the following requirements are met: ✑ No more than 5 minutes worth of transactions are lost. ✑ Data can be recovered by using the minimum amount of administrative effort. What should you do? Choose three.
Các lựa chọn
Đáp án được giữ gọn theo nhãn A, B, C, D trong phần bình chọn tương tác.
- A. Configure the database to use the SIMPLE recovery model.
- B. Create a DIFFERENTIAL database backup every 4 hours.
- C. Create a LOG backup every 5 minutes. — đáp án hiện tại
- D. Configure the database to use the FULL recovery model. — đáp án hiện tại
- E. Create a FULL database backup every 24 hours. — đáp án hiện tại
- F. Create a DIFFERENTIAL database backup every 24 hours.
Cộng đồng
0 bình luận công khai. Tên thành viên được ẩn một phần.