Salesforce Platform Administrator Practice Test

Salesforce Admin Data & Analytics Management Practice Questions

Data & Analytics Management makes up 10 of every 60 questions on a Tigertest Salesforce Admin practice test. Here are 10 of the 33 questions on it, each with the answer and the reason.

Updated 2026-11-10 by the Tigertest team. Based on the Salesforce Certified Platform Administrator exam guide. Original questions; 60 per test, weighted like the real exam, 68% to pass. Not affiliated with Salesforce.

1. 1. An admin must load 400,000 contact records from a legacy system. Which tool fits?

   • A.Schema Builder
   • B.Data Loader
   • C.Data Import Wizard
   • D.Mass Transfer Records

   Answer: B. The Data Import Wizard handles up to 50,000 records at a time. Larger loads need Data Loader, which uses the Bulk API.

2. 2. A marketing user with no admin skills must import 2,000 leads from a spreadsheet and skip duplicates. Which tool is easiest?

   • A.Workbench
   • B.A sandbox refresh
   • C.Data Loader command line
   • D.Data Import Wizard

   Answer: D. The Data Import Wizard runs in the browser, handles up to 50,000 records of common objects and can match on fields to avoid duplicates.

3. 3. Which object can the Data Import Wizard not import into?

   • A.Opportunities
   • B.Custom objects
   • C.Accounts
   • D.Leads

   Answer: A. The Data Import Wizard supports accounts, contacts, leads, solutions, person accounts, campaign members and custom objects. Opportunities need Data Loader.

4. 4. An import should update records that already exist and insert the rest, matching on an ID from the old system. Which operation fits?

   • A.Export All then Insert
   • B.Hard delete then Insert
   • C.Upsert on an External ID
   • D.Insert with new IDs

   Answer: C. Upsert updates records whose key matches and inserts the others. Marking the legacy ID field as an External ID lets it be the match key.

5. 5. An auditor needs an extract that includes records in the Recycle Bin. Which Data Loader operation should the admin use?

   • A.Upsert
   • B.Insert
   • C.Export All
   • D.Export

   Answer: C. Export All includes soft-deleted and archived records; a plain Export only returns active records.

6. 6. Deleted records should skip the Recycle Bin and be removed for good during a bulk cleanup. What does this need?

   • A.Hard delete in Data Loader
   • B.Export All then delete
   • C.Empty the user's own bin
   • D.Mass Delete Records

   Answer: A. Data Loader's hard delete, using the Bulk API, removes records permanently and needs the Bulk API Hard Delete permission.

7. 7. A user deleted an account by mistake yesterday. Where can it be restored from?

   • A.Deleted Fields
   • B.Setup Audit Trail
   • C.Field history
   • D.The Recycle Bin

   Answer: D. Deleted records stay in the Recycle Bin for 15 days, and restoring them brings back related records deleted with them.

8. 8. A rep is leaving and all of her open accounts must move to a new owner in one action. What should the admin use?

   • A.A report subscription
   • B.Mass Transfer Records
   • C.Data Import Wizard
   • D.A matching rule

   Answer: B. Mass Transfer Records changes ownership of accounts, leads and custom object records in bulk, with options for related records.

9. 9. The company needs a weekly copy of all its data as CSV files. Which built-in feature fits?

   • A.Setup Audit Trail
   • B.Data Export service
   • C.Data Import Wizard
   • D.Report subscriptions

   Answer: B. The Data Export service creates scheduled export files of the org's data, weekly or monthly depending on the edition.

10. 10. Users should be warned, but still allowed to save, when they create a lead that looks like an existing one. What should the admin set?

    • A.A lookup filter on Lead
    • B.A sharing rule on leads
    • C.A validation rule on Lead
    • D.A duplicate rule that alerts

    Answer: D. Duplicate rules decide what happens when a matching rule finds possible duplicates: block the save, or allow it with an alert and report.