The 100 Most Asked Salesforce Admin Interview Questions with Answers

Salesforce Admins sit at the crossroads of business logic, user experience, and platform security. Recruiters know this, so their questions probe far deeper than “How do you reset a password?” They want proof you can translate a vague VP request into a scalable solution without creating technical debt.

This curated list of 100 real-world questions—and the concise, field-tested answers beneath each—mirrors what hiring panels at Fortune 500s, boutique consultancies, and fast-growing start-ups actually ask. Treat it as a live rehearsal: read the question, hide the answer, speak your version aloud, then refine against the text.

Core Salesforce Knowledge

Interviewers open with fundamentals to filter out résumé padding. If you hesitate on profiles vs. permission sets, the conversation ends early.

1–10: Org-Wide Basics

1. What is the difference between a role and a profile? Profile controls object and field-level access; role controls record-level access through the sharing model.

2. When would you use a sandbox over a developer org? Sandboxes replicate production metadata and data for realistic testing; developer orgs are blank slates for package development or training.

3. How many sandboxes can an Unlimited Edition customer activate? Up to 15 full sandboxes plus 100 developer pro and developer sandboxes, but licenses govern actual usage.

4. Explain the primary function of the System Administrator profile. It bypasses all security to provide emergency access and is the only profile that can modify critical org settings like company information.

5. What happens if you delete the System Admin user? The deletion fails unless another active user holds a System Administrator profile.

6. Name three ways to access setup without clicking the gear icon. /lightning/setup/SetupOneHome in the URL, the .lightning suffix, or the classic /ui/setup/Setup page.

7. How do you check org-wide defaults in Lightning? Navigate to Setup → Sharing Settings; the panel lists OWDs per object with links to change them.

8. What is the maximum number of custom objects in Enterprise Edition? 2,000, but only 800 can be created, while the rest come from managed packages.

9. Why would you enable “Enhanced Profile Management”? It loads profile permissions in a separate, faster UI and exposes the “View Setup” permission explicitly.

10. What is the consequence of deselecting “View All Data” on a custom profile? Users lose access to the Recycle Bin, Setup menu, and any report folder shared with “All Internal Users.”

11–20: Data Modeling

1. When should you choose a master-detail over a lookup? When you need rollup summaries, cascade deletion, or automatic sharing of child records.

2. Can you convert a lookup to master-detail if orphan records exist? No; populate or delete the lookup values first.

3. How many external IDs can you enable per object? Up to 25 fields marked as External ID, but only one can be a unique External ID.

4. What is the difference between a junction object and a many-to-many relationship? The junction object is the physical custom object that materializes the many-to-many relationship.

5. Give a real-world use case for a junction object. A “Certification” junction between Contact and Course tracks which students passed which courses on what date.

6. How do you enforce that every Opportunity has exactly one Active Contact Role? A before-save Flow counts related active roles and throws an addError() if the count ≠ 1.

7. What happens to existing records when you add a new required field? Nothing until they are edited; the field is not back-filled as required.

8. Can you change the data type of a field that is referenced in Apex? Yes, but the code must recompile and pass tests; otherwise deployment fails.

9. Why would you pick Text over Auto Number for an external system key? Text allows external systems to send alphanumeric identifiers with leading zeros.

10. How many custom fields can you create on an object in Unlimited Edition? 900 per object, including both standard and custom objects.

Security & Access Design

Flawed sharing causes audit failures and angry VPs. Expect scenario questions that force you to pick the least-privilege path.

21–30: Sharing Architecture

1. Explain the order of execution for record access. Org-Wide Defaults, role hierarchy, sharing rules, manual shares, territory hierarchy, team shares, Apex managed sharing.

2. When would you use a public read-only OWD? When 80% of users need visibility but only 20% need edit, minimizing sharing rule overhead.

3. Can a user with “View All” on Campaign still be restricted from a single campaign? No; “View All” overrides ownership and sharing for that object.

4. How do you grant edit rights to one record without a sharing rule? Insert a manual share via the Sharing button or an Apex share row.

5. What is the downside of Apex managed sharing? It bypasses recalculation queues, so bulk deletes can lock tables for minutes.

6. Give a use case for territory management. A medical-device company assigns reps by hospital network, not geography, to avoid splitting account families.

7. How do you migrate territory hierarchy changes? Use the Territory Management 2.0 API with a staging model; activate only after validation.

8. What permission is required to run the “Recalculate Sharing” button? “Manage Sharing Calculation” or “Modify All Data.”

9. Can a sharing rule reference a formula field? No; criteria-based rules only reference indexed, non-cross-object fields.

10. How do you diagnose why a user sees a record? Use the Sharing button → “Why?” link or the Salesforce Optimizer Chrome plug-in.

31–40: Permission Sets & Groups

1. Why assign permission sets instead of cloning profiles? Sets are additive, reduce profile sprawl, and can be revoked in bulk.

2. Can a permission set grant page-layout overrides? No; layout assignment is profile-driven, but Dynamic Forms can hide fields per set.

3. What is the maximum number of permission sets per user? 1000, but best practice keeps it under 10 for human readability.

4. How do you mass-remove a permission set? Use the Permission Set Assignment list view → Remove Assignments, or Data Loader on PermissionSetAssignment object.

5. When would you use a permission set group? To bundle job-function permissions (e.g., “International Sales Rep”) and maintain a single assignment point.

6. Can a permission set group be mutually exclusive? Yes; enable the “Mutual Exclusion” checkbox to prevent users from holding conflicting groups.

7. What is the impact of changing a custom permission in a set assigned to 5,000 users? The change is instantaneous; no deployment window needed.

8. How do you report on who has “Export Reports”? Create a custom report type on Permission Set → Permission Set Assignment filtered by the “Export Reports” permission.

9. Why would you enable “Session-Based Permission Sets”? To temporarily elevate rights for sensitive operations like mass transfer without permanent grants.

10. Can a flow check if the running user has a custom permission? Yes; use the $Permission global variable in Decision elements.

Automation & Declarative Logic

Point-and-click automation now rivals code for complexity. Panels will grill you on edge cases and governor limits.

41–50: Flows

1. When do you pick a Record-Triggered Flow over Process Builder? When you need before-save updates or scheduled paths, both unavailable in Process Builder.

2. How many scheduled paths can one flow have? Up to 200, each with its own offset and criteria.

3. What happens if a flow element exceeds CPU limits? The entire transaction rolls back, and the user sees a generic “unhandled fault” unless you build a fault path.

4. Can a flow delete records without code? Yes; use the Delete Records element, but it respects user permissions unless run in system mode.

5. How do you bulkify a flow that updates related records? Use a Get element with a single SOQL filter, then an Update element on the collection; avoid inside loops.

6. What is the maximum number of elements in one flow? 2,000, but performance degrades after 200; break into sub-flows.

7. How do you pass a collection from a parent flow to a sub-flow? Define an input variable of type Collection in the sub-flow and map it in the Subflow element.

8. Can a flow call an Apex method that performs callouts? Yes, but mark the Apex annotation as @InvocableMethod and ensure the flow runs in a user context that allows callouts.

9. What is the fastest way to debug a flow hitting governor limits? Add a Screen element that displays {!$Flow.CurrentElement} in debug mode to pinpoint the bottleneck.

10. How do you migrate flows between orgs without breaking IDs? Use Change Sets or Salesforce CLI with source format; flow definitions auto-relocate if packaged.

51–60: Validation & Workflow Rules

1. Write a validation rule that blocks closed-won deals without a contact role. AND(ISPICKVAL(StageName,”Closed Won”),NOT(CONTAINS(TEXT(Contact_Count__c),”1″)))

2. Why would you prefer a validation rule over a before-trigger? Rules give instant user feedback without code deployment cycles.

3. Can a validation rule reference a long-text area field? Yes, but it cannot exceed 3,900 characters in the formula.

4. What is the order of execution for validation rules? They fire after before-triggers but after flow before-save updates, so flows can populate fields that rules then check.

5. How do you bypass a validation rule for a data-loader upload? Add a custom checkbox “Data Load Override,” default false; reference it in the rule with NOT(Data_Load_Override__c).

6. When would you still use a workflow field update? When you need cross-object updates to the parent and the org still runs classic workflows.

7. How many workflow rules can one object have? 500 active rules, but only 50 field updates per object.

8. What is the downside of time-dependent workflow? It cannot re-evaluate criteria if the record changes before the trigger date, leading to stale actions.

9. Can you reference a rollup summary in a workflow rule? Yes, but the rollup must be on the same object or the master object in a master-detail relationship.

10. How do you monitor queue-based workflow failures? Monitor the Time-Based Workflow queue under Setup and set email alerts for failures.

Data Management & Integration

A single bad import can cascade into millions of bad rollup values. Interviewers test your disaster-prevention reflexes.

61–70: Import & Export

1. How many records can Data Loader insert in one batch? 10,000 by default, but you can raise it to 200 via Settings → Batch Size.

2. What is the difference between “Insert” and “Upsert” in Data Loader? Upsert uses an External ID to match existing records instead of Salesforce ID.

3. How do you prevent duplicate contacts during import? Enable Duplicate Rules with Blocking action and map Email + Last Name as matching criteria.

4. What file encoding does Data Loader require? UTF-8 without BOM; ANSI causes accented characters to corrupt.

5. How do you extract attachments in bulk? Use the “Export” function on the Attachment object, then Base64 decode the Body field.

6. Can you schedule Data Loader runs? Yes, via command-line interface and Windows Task Scheduler or third-party tools like Jitterbit.

7. What is the maximum file size for Data Import Wizard? 100 MB or 50,000 rows, whichever comes first.

8. How do you migrate junction objects? First insert parent records, then export their new IDs, then upsert junction records with the new parent IDs mapped.

9. Why enable “Trigger Workflow Rules” in Data Loader? To ensure field updates and email alerts fire, but it slows the load.

10. How do you validate that an import succeeded? Compare success file row counts against a summary report filtered by Created Date = TODAY().

71–80: Backup & Storage

1. What is the cheapest native backup option? Weekly Data Export service; schedule includes attachments and schema.

2. How long does Salesforce retain deleted records? 15 days in the Recycle Bin, plus 5 days in the Archived Recycle Bin for large deletions.

3. Can you query deleted records in Apex? Yes; append ALL ROWS in SOQL or use the IsDeleted = true filter.

4. What counts against your file storage quota? Attachments, Files, ContentVersions, and Document records.

5. How do you reduce storage without losing data? Move attachments to an external object store like AWS S3 and replace them with links.

6. What is the maximum size of a single file upload? 2 GB for Files, 25 MB for Attachments in Lightning.

7. How do you monitor storage usage? Setup → Company Information shows file and data usage with red-bar indicators.

8. Can you purchase data storage alone? No; you must buy user licenses that include storage blocks.

9. What happens when you exceed storage? Users cannot upload files or create records until usage drops or storage is increased.

10. How do you automate storage alerts? Use a scheduled flow that queries OrgCapacitySnapshot and posts to Chatter or email.

Reporting & Analytics

Executives live in dashboards. If your report times out, you become the scapegoat.

81–90: Report Performance

1. Why add indexes to custom fields? Indexed fields speed up report filters and list views, especially when filtering on 10M+ rows.

2. How do you identify slow reports? Use the Salesforce Optimizer report that flags runtime > 10 seconds or row counts > 1M.

3. What is a skinny table? A Salesforce-maintained denormalized table that includes frequently used fields to reduce joins.

4. Can you request a skinny table yourself? No; log a case with Support and provide the slowest SOQL or report ID.

5. How many grouping levels can a summary report have? Three, plus a bucket field counts as an extra implicit group.

6. What is the row limit for joined reports? 2,000 visible rows, but the underlying query can fetch up to 10,000 per block.

7. How do you show real-time Opportunity amounts in a dashboard? Use a report with no time filter and set the dashboard to refresh every 5 minutes.

8. Can you schedule a joined report? No; only tabular, summary, and matrix reports support scheduled refresh.

9. What permission is required to create report folders? “Manage Public Report Folders” or be added as a folder manager.

10. How do you migrate dashboards without breaking dynamic filters? Include the source report in the same Change Set and verify filter logic references exist.

Lightning Experience & UX

UI questions separate admins who click from admins who design. Be ready to defend your page-layout choices.

91–100: Lightning Configuration

1. How do you hide the “New” button for a specific profile on one object? Create a custom permission, remove it from the profile, then add a Lightning Component visibility filter.

2. What is the maximum number of components on a Lightning page? 150, but page load slows after 25.

3. Can you make a Lightning page conditionally render based on user locale? Yes; use the “User Locale” filter in the component visibility rules.

4. How do you migrate page layouts to Dynamic Forms? Open the Lightning App Builder, click “Upgrade Now,” and drag fields from the palette into sections.

5. What happens to page-layout sections when you enable Dynamic Forms? Classic sections disappear; only the field components you configure remain.

6. How do you add a guided action to the utility bar? Create a Flow of type Screen, then add it as a “Flow” component in the Utility Bar.

7. Can you deploy Lightning pages with Ant Migration Tool? Yes; include the FlexiPage type in package.xml.

8. Why would you enable “Pause” on Path? To let reps stall an Opportunity stage while still tracking inactivity timeouts via reporting.

9. How do you track Lightning page performance? Use the Lightning Usage App and filter by “Page Performance Analysis.”

10. What is the quickest way to roll back a Lightning page change? Clone the page before edits; activate the clone only after QA, keeping the original as fallback.

Memorizing answers is useless if you cannot adapt them to the interviewer’s specific scenario. After you rehearse these 100, invent five follow-up questions for each answer and practice answering those aloud. That recursive depth—question, answer, deeper question—turns a nervous candidate into the admin every hiring manager wants on their team.