Câu 71: 70-462: MCSA Administering Microsoft SQL Server 20122014 Databases
You have a SQL Server database named DB1. You plan to load 10 million rows to DB1 by running bcp.exe. You need to modify DB1 to minimize the amount of space required to store the transaction logs during the load operation. The solution must ensure that you can perform a point-in-time restore. What data base setting sh…
Nội dung câu hỏi
You have a SQL Server database named DB1. You plan to load 10 million rows to DB1 by running bcp.exe. You need to modify DB1 to minimize the amount of space required to store the transaction logs during the load operation. The solution must ensure that you can perform a point-in-time restore. What data base setting should you modify?
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. Compatibility level to 120
- B. Recovery model to Bulk logged
- C. Containment type to Partial — đáp án hiện tại
- D. Recovery model to Simple
Cộng đồng
0 bình luận công khai. Tên thành viên được ẩn một phần.