70-028 Administering Microsoft SQL Server 7.0
Note 1: 70-028 Exhibit and all related diagrams are not shown in demo questions.
Note 2: 70-028 Answers are not shown in demo questions.
Exhibits and Answers are only provided in the Full Version.
Note 2: 70-028 Answers are not shown in demo questions.
Exhibits and Answers are only provided in the Full Version.
Demo Question 9.
You are using data transformation service to load 500MB of data from a flat file to a SQL server table. Each row contains 6,000 bytes. You have 100MB of free disk space for the transaction log. Which is the most important option set on the target database to minimize the possibility that the transaction log will not have any disk space available?
A. autoshrink
B. trunc.log on chkpt.
C. Select into/bulkcopy
D. Autoclose
Display Answer
Purchase Full Version:
70-028 Printable PDF Prep Guide $59.95 BUY NOW!
70-028 Test Simulation Engine $69.95 BUY NOW!
70-028 PDF & Test Simulation Engine $99.95 BUY NOW!
Answer: B.
Explanation: We don't the transaction log to be updated while we import 500MB of data.
If a database log backup sequence is not being maintained for a database, the database can be set into log
truncate mode. trunc. log on chkpt. database option sets the database into log truncate mode.
Incorrect
- Based on the latest 70-028 exam objectives!
- Designed like actual 70-028 exam questions!
- 100% Verified Realistic 70-028 Exam Questions and Answers!
- Exhibits, Drag&Drop and Simulation 70-028 Questions Included!
- Constantly Updated Guide to Reflect the Current 70-028 Exams!
- Detailed Explanations for Most Guide Practice Exams!
Sponsored Links
jay kapoor
Great thanks to EliteCertify for such excellent products! It really helped me a lot for passing 70-305 Exam. With the ...
Australia
Great exam practice questions. Highly recommended! ...
New Zealand
I am from New Zealand, and good quality IT certification training is hard to find. Thank you for offering your ...
Keyword
