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?

AUpdates to child records that have the same parent records are being processed simultaneously.

BContact records should be imposed in the same data batch as Account records.

CAn Apex Trigger on the Account object is firing on insert and causing the Contact import to fail.

DThe consultant has incorrect permissions to import data using Data Loader.

Show Suggested 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:

Submit Cancel

Kristel

3 months ago

Wait, are we sure it's not a permissions issue? That seems odd.

upvoted 0 times

...

Genevieve

3 months ago

C could be the culprit too, those triggers can be sneaky!

upvoted 0 times

...

Dortha

4 months ago

I thought it was B at first, but now I'm not so sure.

upvoted 0 times

...

Portia

4 months ago

Definitely A! Multiple updates can cause that.

upvoted 0 times

...

Laine

4 months ago

Sounds like a classic row lock issue.

upvoted 0 times

...

Nana

4 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

5 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

5 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

5 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

5 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

5 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

5 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

5 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

5 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

5 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

5 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

5 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

5 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

5 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

...