We help IT Professionals succeed at work.

70-100 Exam

bufordk
bufordk asked
on
268 Views
Last Modified: 2010-05-02
I recently failed the 70-100 exam and I am giving it another try today. I'm aware that calculated fields should not be included as a field but how about the # of something. On the test there was a scenario on an insurance company. The premium is calculated on many fields including the # of Violations. This was listed as one of the fields to choose from. The #of Violations can be derived by doing a count on the driver violations table. Should it be included in the drivers table or would this be considered a calculated field? Also there is a driverflag field that could be used based on the #of Violations for a driver. Should this be added since it is must be derived from the #ofViolations? Help!AnyOne?????
Comment
Watch Question

Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Commented:
Now.. Lets talk the real world.. <wink>.

Depending on how VOLATILE your Violation data is and how precisely you have to know the number of violations (ie.. timing and quantity), summarizing referential information can improve application performance dramatically and greatly simplify data retrieval programming. Yes, referential errors may occur (and hence incorrect output), but one has to balance the risk of this with the value of data accuracy. When working with limited resources, there is some wisdom to the old saying.. "Close enough for Government work".

To greatly reduce the risk of bad data, the developer should always provide easily accessible and/or routinely timed table referential integrity audits.. to assure that the data is accurate at a given moment or predetermined interval. "Good Housekeeping" is a must practice, and a very popular magazine.. <smile>.

Commented:
PSsssst.. Let me know how you make out.. k?

Author

Commented:
Thank You ........I Passed!
By a whole......FIVE POINTS!

Commented:
Atta B!!!... <huge smile>
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.