Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Salesforce Certified Sales Cloud Consultant (Sales-Con-201) Exam - Topic 3 Question 77 Discussion

A consultant for Cloud Kicks is migrating data from an on-premise system to Salesforce. The consultant has imported.Account records, and is attempting to import the associated Contacts using Data Loader, but the import has failed records. The error messages all read UNABLE TO LOCK ROW,What could be causing these records to fail?
A) Updates to child records that have the same parent records are being processed simultaneously.
B) Contact records should be imposed in the same data batch as Account records.
C) An Apex Trigger on the Account object is firing on insert and causing the Contact import to fail.
D) The consultant has incorrect permissions to import data using Data Loader.

Salesforce Certified Sales Cloud Consultant (Sales-Con-201) Exam - Topic 3 Question 77 Discussion

Actual exam question for Salesforce's Salesforce Certified Sales Cloud Consultant (Sales-Con-201) exam
Question #: 77
Topic #: 3
[All Salesforce Certified Sales Cloud Consultant (Sales-Con-201) Questions]

A consultant for Cloud Kicks is migrating data from an on-premise system to Salesforce. The consultant has imported.

Account records, and is attempting to import the associated Contacts using Data Loader, but the import has failed records. The error messages all read UNABLE TO LOCK ROW,

What could be causing these records to fail?

Show Suggested Answer Hide Answer
Suggested Answer: A

The most likely cause of the records failing is that updates to child records that have the same parent record are being processed simultaneously. This can cause the records to fail because child records must be imported after the parent records have been imported, and if the parent record is being updated at the same time as the child records, the import will fail. The other options are not likely to be the cause of the failed import.


by Quentin at Aug 31, 2023, 11:48 PM

Limited Time Offer

25%

Off

Get Premium Salesforce Certified Sales Cloud Consultant (Sales-Con-201) Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Kristel
8 months ago
Wait, are we sure it's not a permissions issue? That seems odd.
upvoted 0 times
...
Genevieve
8 months ago
C could be the culprit too, those triggers can be sneaky!
upvoted 0 times
...
Dortha
8 months ago
I thought it was B at first, but now I'm not so sure.
upvoted 0 times
...
Portia
9 months ago
Definitely A! Multiple updates can cause that.
upvoted 0 times
...
Laine
9 months ago
Sounds like a classic row lock issue.
upvoted 0 times
...
Nana
9 months ago
I doubt it’s a permissions issue since Data Loader usually works if you have the right access, but I guess it’s still a possibility.
upvoted 0 times
...
Hailey
9 months ago
I feel like I’ve seen a similar question where an Apex Trigger caused problems during data imports. That could be a factor here too.
upvoted 0 times
...
Erinn
9 months ago
I’m not entirely sure, but I think the Contacts need to be imported in the same batch as the Accounts to avoid issues.
upvoted 0 times
...
Santos
9 months ago
I remember something about row locking issues when multiple processes try to update the same parent record. That might be what's happening here.
upvoted 0 times
...
Torie
10 months ago
I feel pretty confident that the answer is C. An Apex Trigger on the Account object that's firing on insert could definitely be the culprit here, causing the Contact import to fail.
upvoted 0 times
...
Barney
10 months ago
Okay, let's see here. Based on the information provided, my best guess would be option A. If the Contact records are being imported at the same time as updates to the parent Account records, that could definitely cause locking issues and the import to fail.
upvoted 0 times
...
Paz
10 months ago
I'm a bit confused by this question. The options all seem plausible, but I'm not sure which one is the most likely cause of the problem. I'll need to think this through carefully.
upvoted 0 times
...
Harrison
10 months ago
Hmm, this seems like a tricky one. The error message about being unable to lock the row makes me think there might be some kind of concurrency issue going on.
upvoted 0 times
...
Sharita
10 months ago
Adding an additional vNIC? I don't think that's the right solution for this problem. Let me re-read the question carefully and think through the networking concepts involved.
upvoted 0 times
...
Sean
10 months ago
This is a tricky one. I think I need to focus on understanding what benchmarking really means and how it can impact innovation.
upvoted 0 times
...
Holley
10 months ago
Hmm, this looks like a tricky one. I'll need to carefully review the options and think through the potential issues with the guest portal configuration.
upvoted 0 times
...
Lashawnda
10 months ago
Hmm, this is a tricky one. I'm not totally clear on the difference between well-known mandatory and well-known discretionary attributes. I'll have to think this through carefully.
upvoted 0 times
...
Sharee
10 months ago
I think I remember studying that not all of these direct connections are encrypted by default, though some may offer options for encryption.
upvoted 0 times
...
Royce
10 months ago
Okay, let me think this through. The question is asking about legal data transfer instruments for the EU to Asia, so the Privacy Shield is definitely not the right answer since that's EU-US only. I think the Standard Contractual Clauses or Binding Corporate Rules are the most likely options here.
upvoted 0 times
...

Save Cancel