An insurer ran the DBCC checks against a copy of their production database and found three errors with high counts in the category Data update and reconciliation. What are two best practices for resolving the errors? (Select two)
A.
Analyze the errors to determine the root cause and correct the code responsible for the errors
B.
Promote the code to production and run the DBCCs again
C.
Wait to see if error counts increase; if they increase by more than 10%, fix the errors
D.
Identify any bad data and write a SQL script to correct the data; run the script immediately
E.
Search the Knowledge Base on the Guidewire Community for solutions to the problems found
Database Consistency Checks (DBCCs) are the " canary in the coal mine " for data integrity. When high error counts appear in the Data update and reconciliation category, it usually implies that recent configuration changes (Gosu rules, enhancements, or batch processes) are generating data that violates the underlying metadata constraints.
The first best practice is Root Cause Analysis (Option A). Simply fixing the data in the database is a " band-aid " solution; if the underlying Gosu code that created the bad data is not fixed, the errors will immediately return. Developers must trace the lifecycle of the affected entities to find where the logic is failing.
The second best practice is to leverage the Guidewire Community Knowledge Base (Option E). Many DBCC errors, especially those following a version upgrade or a major configuration change, have been encountered by other insurers. The Knowledge Base often provides specific SQL patterns or Gosu fixes tailored to known platform behaviors.
Why other options are incorrect:
Option B is dangerous; never promote code known to cause database inconsistencies to a production environment.
Option C is irresponsible; data corruption should be addressed as soon as it is detected.
Option D is a partial fix, but " running the script immediately " without a code fix or support review (as discussed in Question 61) is high-risk and violates Cloud Assurance standards.
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit