Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have been looking at sample questions on logging for 70-463 exam. For the below, the answers given do not make sense to me.

The first answer given does not even say how to implement logging. I would have selected C as the answer.

The second answer suggests using dtexecui, which is for legacy only? Again I would use the 'Create an OnError event handler' (F) as the answer.

Am I wrong?

Thanks!

enter image description here

enter image description here

enter image description here

share|improve this question

1 Answer 1

Root question

Why would using the Project Deployment Model provide the lowest cost of logging assuming the desire is to have

  • Centralized
  • automated
  • SQL Server based

Answer

Because it's built in. The new project model automatically logs at the Basic level when executed on the server. For completeness, your available logging options are None, Basic, Performance, Verbose. Basic is going to have everything you need for a standard run. If it fails, you will know information about the failure - what failed and why. You'll have start and stop times for all your executables and as the first sentence mentions, you don't have to do a single thing to get it.

Prior to this, a new package is created, goes through all the SOX/SAS-70 deployment checks and what not and it blows up in production. Look at the logs to see what happened and oh snap, nobody turned logging on. The package must then be edited which requires running back through all the approval and testing process and generally is a PITA.

Finally, if you add on OnError event handler to the package great, but now what? You will need to write your own logic, maybe a stored proc, whatever, to do something with the error. That's probably not going to meet the automated requirement.

dtexecui is just a gui for dtexec which is used whether you're using the project deployment or the classic package deployment model. It's just a matter of whether you indicate a package lives inside an ispac/ssisdb or not.

Final thoughts

Study up on the Project Deployment Model. Really dig in and play through how all this works. The test is trying to ascertain whether you understand what comes part and parcel with it so you can deliver the most effective solutions.

share|improve this answer
1  
Thank you! Makes perfect sense. –  k09 Feb 6 at 15:35
    
Hi, I have updated my question above to include another sample question. This time the answer given is OnError event handler even though the question states the solution must minimize deployment and development. Any thoughts? –  k09 Feb 6 at 21:37

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.