ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 227 - Certified Data Architect discussion

Report
Export

Universals Containers' system administrators have been complaining that they are not able to make changes to its users' record, including moving them to new territories without getting ''unable to lock row'' errors. This is causing the system admins to spend hours updating user records every day.

What should the data architect do to prevent the error?

A.
Reduce number of users updated concurrently.
Answers
A.
Reduce number of users updated concurrently.
B.
Enable granular locking.
Answers
B.
Enable granular locking.
C.
Analyze Splunk query to spot offending records.
Answers
C.
Analyze Splunk query to spot offending records.
D.
Increase CPU for the Salesforce org.
Answers
D.
Increase CPU for the Salesforce org.
Suggested answer: B

Explanation:

Enabling granular locking (option B) is the best option to prevent the error, as it allows finer control over how records are locked during automated or manual processes, and reduces the chances of lock contention or deadlock. Reducing number of users updated concurrently (option A) is not a good option, as it may limit the productivity and efficiency of the system admins, and it does not address the root cause of the error. Analyzing Splunk query to spot offending records (option C) is also not a good option, as it may require more time and effort, and it does not provide a permanent solution for the error. Increasing CPU for the Salesforce org (option D) is also not a good option, as it may introduce additional cost and complexity, and it does not solve the root cause of the error.

asked 23/09/2024
Franziska Kreuz
36 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first