Specify the account 'sa' when you create the job step that runs the CMD job.  From BOL:

[@database_user_name =] 'user'

Is the name of the user account to use when executing a...

Won't the field "iTopicsQuery_id" be taken from the main query table, instead of the subquery, as you intended? 

Was that a homework assignment? 

The official MS Press books for 228 and 229 worked well for me.  I have both, if you're interested, though I won't give them to you for free.  I'm asking...

I read it, and usually follow a link or two to read the whole story. 

If the legacy applications are fairly tightly connected in function and purpose, it would make sense to integrate them into a single database.  This would make DB Maintenance and Backup...

I agree with the nightmare scenario.  Unless you think you are going to run out of numbers, is there a reason to reuse Product IDs?

The "correct" answer ignored the @NoisePattern parameter, so there really wasn't a completely correct answer amongst the four choices.

There should be another setting for when to delete transaction logs.  Someone else probably knows what the parameter name would be.

I truncate the log after the weekly maintenance tasks have run, where there is no production.  I do this because we archive the logs for HIPAA reasons, and I'd prefer...

When I first became the DBA for our SQL system, our techs were in the habit, from experience with NT and a different database system, of rebooting the server as...

From the percentatges of the answers, it looks to me like most people guessed.  (As did I, incorrectly.)

You'd probably want to build a front-end app to get the user input and call the stored procedure.  Access can make that very simple to do.

Trading network connections with the DBA next to you would let you rule out, or in, a hardware issue with your network. 

This won't be helpful, but there was a cartoon with a "super" DBA who was saying to a colleague "I can fly back in time to recover missing files.  What...