Data and Analytics Management — Salesforce Platform Administrator practice questions

Which is the BEST way to delete 50,000 inactive contact records?

1. Have users open each record and delete it by hand, working through the list over the coming weeks
2. Use Data Loader to run a bulk delete, choosing hard delete when the rows should skip the recycle bin
3. Add a validation rule that blocks edits to inactive contacts so they stop appearing in list views
4. Build an approval process that routes each inactive contact to its record owner for a deletion decision

Answer: B — Use Data Loader to run a bulk delete, choosing hard delete when the rows should skip the recycle bin

B) Correct. Data Loader supports bulk delete from a file of record IDs, with hard delete available when the rows should not sit in the recycle bin. A) Manual deletion cannot scale. C) Blocking edits leaves the records in place. D) An approval per record is impractical at this volume.

An executive wants a dashboard element that displays a single number, current pipeline value, with no chart. Which component type fits BEST?

1. Gauge, because it renders one value against defined breakpoints
2. Funnel, because it shows how the value progresses through stages
3. Table, because it lists the top records contributing to the value
4. Metric, because it displays a single summary value with a label

Answer: D — Metric, because it displays a single summary value with a label

D) Correct — the metric component surfaces one grand-total or summary value with a caption, which is exactly a single-number tile. A) is close and often chosen, but a gauge is for showing progress toward a target across ranges, which the request did not include. C) returns rows rather than one figure. B) visualises stage-to-stage progression and is the wrong shape for a single value.

Which report format allows GROUPING by two field dimensions (rows and columns) and is useful for comparing data across categories?

1. Tabular
2. Summary
3. Matrix
4. Joined
5. Dashboard

Answer: C — Matrix

Report formats: Tabular (rows only — like spreadsheet), Summary (groups by rows), Matrix (groups by both rows and columns — for cross-tabulation), Joined (multiple report blocks). Matrix is ideal for analyzing by 2 dimensions.

Which feature prevents duplicate contacts from being created on insert?

1. A validation rule, which evaluates only the record being saved and cannot compare it to other records
2. A sharing rule, which extends record visibility to more users and has no effect on data quality at save
3. Matching rules paired with duplicate rules, which detect and then alert on or block duplicates at save
4. A permission set, which grants object and field permissions but performs no comparison between records

Answer: C — Matching rules paired with duplicate rules, which detect and then alert on or block duplicates at save

C) Correct. A matching rule defines how records are compared, and the duplicate rule decides whether to allow with an alert or block the save. A) Validation formulas see only the current record. B) Sharing governs visibility, not duplication. D) Permission sets grant access; they enforce no data quality.

Which report format groups data by ROWS only?

1. Tabular
2. Summary
3. Matrix
4. Joined

Answer: B — Summary

B) Correct. Summary reports group by rows only. A) Tabular has no grouping. C) Matrix groups rows + columns. D) Joined combines blocks.

An admin wants Salesforce to warn users, but not block them, when they create a Lead that resembles an existing Contact. Which statement about the configuration is accurate?

1. The matching rule sets the comparison logic; the duplicate rule sets the action
2. A duplicate rule defines the comparison logic and a matching rule defines the action
3. A single duplicate rule defines both the comparison logic and the alert action
4. A validation rule must be added because duplicate rules can only block, never warn

Answer: A — The matching rule sets the comparison logic; the duplicate rule sets the action

A) Correct — the matching rule determines how records are compared, and the duplicate rule points at that matching rule and decides whether to allow with an alert or block. B) reverses the two roles, which is the single most common mix-up on this topic. C) collapses two objects into one; the duplicate rule cannot compare records without referencing a matching rule. D) rests on a misconception — duplicate rules explicitly support an allow-with-alert action, so no validation rule is needed.

Which is the BEST approach to protecting Salesforce data against accidental loss?

1. Combine a scheduled data export with a backup product, rather than relying on the recycle bin alone
2. Rely on the recycle bin, which holds deleted records only briefly before they are purged permanently
3. Use sharing rules to restrict who can delete records, which limits loss but keeps no copy of the data
4. Use profiles to remove the delete permission from most users, which again produces no recoverable copy

Answer: A — Combine a scheduled data export with a backup product, rather than relying on the recycle bin alone

A) Correct. A real backup strategy pairs scheduled exports with a backup and restore product or partner tool, so data can be recovered rather than merely undeleted. B) The recycle bin is a short-lived safety net, not a backup. C) Sharing limits exposure but stores nothing. D) Permission tightening prevents some deletions but restores nothing.

Which is the BEST way to track how a specific field's value changed over time?

1. Enable field history tracking on the object for the fields that matter, then report on the history
2. Build a code routine that writes a copy of the old value to a custom logging object on every record save
3. Create a sharing rule so auditors can open the record and read the current field value whenever needed
4. Add a validation rule that requires a comment whenever the field changes, and report on those comments

Answer: A — Enable field history tracking on the object for the fields that matter, then report on the history

A) Correct. Field history tracking is the declarative way to capture old and new values, and the history data can then be reported on. B) Custom code duplicates a standard feature and is outside the administrator credential. C) Sharing shows the current value only. D) A comment field records opinion, not an audited value change.

An admin plans a nightly, unattended load of 30,000 Contact updates from a file server. Which statement about tool selection is MOST accurate?

1. The Data Import Wizard can be scheduled from Setup for recurring loads
2. Mass Transfer Records can be scheduled to apply the field updates nightly
3. Data Loader supports command-line operation suitable for scheduled loads
4. Scheduled loads require the Data Export Service pointed at the file server

Answer: C — Data Loader supports command-line operation suitable for scheduled loads

C) Correct — Data Loader offers a command-line interface that can be invoked by an external scheduler for unattended, repeatable loads. A) is a common misconception; the Data Import Wizard is an interactive browser tool with no scheduling. B) misreads Mass Transfer, which reassigns ownership and is not a general field-update loader. D) reverses the direction of the export service, which writes backups out of the org.

Data quality is poor because reps skip the Industry field on Accounts. Leadership wants entry blocked when the field is empty on save. The MOST direct control is:

1. A duplicate rule set to block on the Industry field
2. A report subscription alerting the manager to blank values
3. A page layout change marking Industry as read-only
4. A validation rule that fails when Industry is blank

Answer: D — A validation rule that fails when Industry is blank

D) Correct — a validation rule evaluates on save and blocks the record with an error when the condition is met, which is the direct enforcement asked for. A) misapplies duplicate rules, which compare records against each other rather than checking for blanks. C) reverses the intent; read-only prevents entry rather than requiring it. B) detects the problem after the fact instead of preventing it.

What is the current name, code and blueprint date of the Salesforce administrator credential, and what are its eight sections and weights?

It is the Salesforce Certified Platform Administrator, exam code Plat-Admn-201, with a blueprint effective 15 December 2025 (the ADM-201 name and old weights are superseded). Sections: Data and Analytics Management 17% • Configuration and Setup 15% • Object Manager and Lightning App Builder 15% • Automation 15% • Sales and Marketing Applications 10% • Service and Support Applications 10% • Productivity and Collaboration 10% • Agentforce 8%.

Why do admins use an External ID field when loading related records from another system?

Upsert combines insert and update in one pass, matching on the record Id or on a custom field marked External ID (and ideally Unique). An External ID also lets you relate child records to parents using the source system's key instead of Salesforce Ids, so you do not have to export parent Ids first. In Data Loader you map the child's lookup or master-detail field to ParentObject:ExternalIdField__c and the relationship resolves on load.

Report folder vs dashboard folder?

Folders organize and share reports/dashboards. Permissions controlled per folder.

Name the four Lightning report formats and the distinguishing feature of each.

Tabular — a simple list of rows, no grouping. Summary — rows grouped by one or more fields with subtotals. Matrix — grouped by both rows and columns for a cross-tab. Joined — multiple report blocks, which may use different report types, side by side.