AI Associate Data for AI Practice Question
A system administrator receives an error when running a Data Cloud data transform: 'Row-level security settings are preventing access to the source data.' The admin has appropriate permissions. What is the most likely cause?
⚠ Common exam trap
Salesforce often tests the distinction between row-level security and field-level security, and candidates mistakenly choose field-level security (Option A) because they confuse the two concepts, not realizing the error message explicitly points to row-level restrictions.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
The source object has sharing rules that restrict access for the data transform's running user.
Data Cloud data transforms run under a specific running user context, and row-level security (RLS) settings on the source object can restrict that user's access to rows, even if the admin has broad permissions. The error indicates that the running user lacks visibility to certain source data rows due to sharing rules or RLS policies, which is a common cause of this specific error message.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
The target object has field-level security.
Why it's wrong here
Field-level security would not cause a row-level error.
- ✗
The data stream is scheduled during maintenance.
Why it's wrong here
Scheduling does not affect row-level access.
- ✗
The data transform is set to run as the admin's default user.
Why it's wrong here
The admin likely has access, but the error suggests otherwise.
- ✓
The source object has sharing rules that restrict access for the data transform's running user.
Why this is correct
Row-level security is about sharing; the running user may not see all rows.
Go deeper
Related to this question
About these practice questions
One of 753 original AI Associate practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This AI Associate practice question is part of Courseiva's free Salesforce certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the AI Associate exam.