Some Very Blurry Questions I Really Need Answers To!

Hello all,


I recently started learning SQL 2000(70-228)in hopes of getting a certification, after having ordered the nuggets for this and reading through the official microsoft book I am doing some tests I found online. But here's where my problem starts, some of these test questions go against what I think I just learned. To give you an example, check out following screenshot,







If you read the question thoroughly you eventually come at the last line, which states clearly "You do not want to change the way analysts query the database". So if you don't want that, then options B, C and D are all out of the question cuz you will have to instruct the analysts how to select either from the view, or how to execute your stored procedure, or how they should query from the new table, this all changes the way they query the database. This would only leave option A to be the logical choice, but when I click the "SHOW ANSWER" button on the question it says the correct answer is answer D????? Am I missing the boat or has this question just plain got it wrong.


Now onto my next question, this is in line with my previous question, it also involves a question to which I am sure I know the answer but ofcourse my answer is found wrong by the testking answer,







see how it says that you should remove the tablock option, this option to me is just plain wrong, cuz placing a tablock would improve performance when doing a bulk insert. Users would not be vying for locks on the table and you could run your insert at optimal speed. Options A, B, C, D are all guesswork and you would not be able to know beforehand which would give you the best performance(5% or 10%), so you can safely exclude these.



After checking the MSDN webpage on the BULK INSERT you can see why the Tablock option certainly would not have to be removed,







Which leaves option E as the only logical choice, it would be far more logical to drop the indexes, cuz doing a large bulk insert would leave you with lots of indexes to be rearranged and ordered(lots of IO operations). Removing the rowterminator ofcourse should not be removed, so hence thats why I thought option E would be the only correct answer.



So now I am asking of the kind users here with lots more knowledge than me what their opinion is on the matter, am I right or is the testking answer right?



Hoping to hear from you soon,


Thnx,


Peter