Free Salesforce Platform Administrator Practice Test Questions
Topic: Data and Analytics Management
148 questionsUpdated 17-Nov-20268 topics
TopicData and Analytics Management
Question 1Choose 2
A Platform Administrator at Ursa Major Solar imported records into an object by mistake. Which two tools should the administrator use to undo this import?
Correct answer:
B. Data Loader
D. Mass Delete Records
Explanation:
To undo an accidental record import, the administrator needs tools that can delete records in bulk. Data Loader allows deletion using a CSV file of record IDs (exported after import). Mass Delete Records (in Setup) allows direct deletion of records matching criteria without a file. Both are appropriate for bulk deletion, whereas export and import tools are not designed for deletion.
Correct Option: B
Data Loader can delete records in bulk by performing a "Delete" operation using a CSV file containing record IDs.
The administrator can first export the mistakenly imported records (using their unique IDs), then delete them.
Supports large data volumes (millions of records).
Available as both a UI tool and command-line interface.
Correct Option: D
Mass Delete Records (Setup → Data Management) allows administrators to delete records directly based on object and criteria (e.g., all records created today).
No file preparation needed if deletion criteria are simple.
Best for smaller, targeted deletions without needing Data Loader.
Accessible directly from Setup.
Incorrect Option: A
Weekly Data Export is a backup tool that exports Salesforce data to a CSV file for archival purposes. It does not delete records.
Cannot undo an import; only provides a backup copy.
Not a deletion tool.
Incorrect Option: C
Data Import Wizard is used to insert or update records, not to delete them.
It cannot undo an import; it would only allow re-importing more records.
Incorrect tool for deletion.
Reference:
Salesforce Help Article: Delete Records in Bulk – Use Data Loader or Mass Delete Records to bulk delete records. Data Import Wizard is for insert/update only, and Weekly Data Export is for backup, not deletion. Choose based on volume and need for criteria-based selection.
Question 2Choose 1
Users at DreamHouse Realty are only allowed to see opportunities they own. Leadership wants an enterprisewide dashboard of all open opportunities in the pipeline so that users can see how the company is performing at any point in time. How should a Platform Administrator create the dashboard without changing any sharing settings?
Correct answer:
A. Create a dashboard with the running user set as someone who can see all opportunities.
Explanation:
Salesforce dashboards respect the running user's record-level access. By default, a dashboard shows data based on the viewer's permissions. To display an enterprise-wide view without changing individual user sharing settings (e.g., role hierarchy or sharing rules), the administrator can set the running user to a user profile (e.g., an integration user or admin) who has "View All" access to Opportunities. All viewers then see data as that running user.
Correct Option: A
Setting running user to a user with "View All Data" or "View All Opportunities" allows the dashboard to bypass individual user sharing restrictions.
No changes to user sharing settings (OWD, role hierarchy, sharing rules) are required.
The dashboard displays all open opportunities to all viewers without granting them direct record access.
This is the standard approach for executive or company-wide dashboards.
Incorrect Option: B
Filter by owner role would restrict data based on role, which does not solve the problem of users seeing only their own opportunities.
Users would only see opportunities owned by their role (or subordinates), not the entire pipeline.
Does not use a "running user" override.
Incorrect Option: C
Individual dashboards per profile would require duplicating the dashboard many times, each with a different running user—inefficient and hard to maintain.
Does not address the core issue; still requires a running user with full access on each.
Not scalable.
Incorrect Option: D
Dashboard folder settings (e.g., Manager for sales reps role) control who can view or edit the dashboard itself, not the data displayed within it.
Changing folder settings does not override record-level sharing for opportunity data.
Irrelevant to the requirement.
Reference:
Salesforce Help Article: Set the Running User for a Dashboard – Use the "Run As" option to specify a running user with broader record access. This allows viewers to see data they wouldn't normally have access to without changing individual sharing settings. Dashboard folder permissions do not affect data visibility.
Question 3Choose 1
A sales manager at DreamHouse Realty wants sales users to have a quick way to view and update the opportunities in their pipeline expected to close in the next 90 days. What should a Platform Administrator do to accomplish this request?
Correct answer:
D. Create a list view on the Opportunity object and recommend users switch the view to Kanban to edit by drag and drop.
Explanation:
The requirement asks for a quick way for sales users to both view and update opportunities in their pipeline expected to close in the next 90 days. A list view filtered by owner (current user) and close date criteria provides an immediate, filterable list. Switching to Kanban view allows drag‑and‑drop stage updates, making it very efficient for pipeline management.
Correct Option: D
List view can be filtered to show only opportunities owned by the current user with CloseDate <= TODAY() + 90.
Kanban view groups records by stage and allows drag‑and‑drop to change stage, updating the record instantly.
No development required; users can access from the Opportunities tab.
Sales reps can manage their pipeline visually in one place.
Incorrect Option: A
Custom report with a daily email provides a view but not an update capability.
Users cannot edit opportunities from an emailed report.
Does not fulfill the “quick way to update” part of the request.
Incorrect Option: B
A dashboard is read‑only. Users can view opportunities but cannot update them directly from a dashboard component.
Dashboard components link to reports, which then require opening record pages to edit.
Not efficient for bulk or quick updates.
Incorrect Option: C
Sales Console with multiple tabs is overkill for this simple requirement. It requires enabling console navigation and training users on tabs.
Does not by itself provide a filtered, editable view of the next‑90‑days pipeline.
More complex than needed for viewing and updating a filtered list.
Reference:
Salesforce Help Article: Work with Kanban View for List Views – Use a filtered list view on the Opportunities tab, then switch to Kanban view to update stages by drag and drop. This gives sales users both visibility and a quick update method. Dashboards are read‑only, reports cannot be edited, and console tabs add unnecessary complexity.
Question 4Choose 1
A Platform Administrator at Cloud Kicks needs to export a file of closed won opportunities from the last 90 days. The file should include the Opportunity Name, ID, Close Date, and Amount. What should the administrator use to export this file?
Correct answer:
A. Data Loader
Explanation:
The requirement is to export specific fields (Name, ID, Close Date, Amount) for a filtered set of records (Closed Won opportunities, last 90 days). Data Loader allows the administrator to export records using a SOQL query or by selecting an object and applying filters. It supports selective field export and is ideal for ad‑hoc or scheduled exports of moderate to large data volumes.
Correct Option: A
Data Loader can export records based on a SOQL query (e.g., SELECT Id, Name, CloseDate, Amount FROM Opportunity WHERE StageName = 'Closed Won' AND CloseDate = LAST_N_DAYS:90).
Allows selecting specific fields and applying complex filters.
Can be run interactively via the UI or scheduled from the command line.
Supports millions of records.
Incorrect Option: B
Data Import Wizard is primarily for inserting or updating records, not for exporting data.
It has very limited export capability (only for checking errors) and does not support custom SOQL or complex filters.
Not suitable for this export task.
Incorrect Option: C
Data Cloud Connection is used to connect Salesforce Data Cloud (CDP) with external systems for unified customer profiles, not for ad‑hoc file exports of Opportunity records.
Overkill and completely unrelated to exporting a simple CSV of opportunities.
Incorrect Option: D
Data Export Service (Weekly Export Service) exports a full backup of all data in the org (or all data for selected objects) weekly, not a filtered, field‑specific, on‑demand export.
Cannot filter by Stage (Closed Won) or restrict to last 90 days.
Designed for backup, not for operational reporting exports.
Reference:
Salesforce Help Article: Export Data Using Data Loader – Use Data Loader’s Export feature with a SOQL query to selectively export specific fields and records based on criteria like stage and date range. The Data Import Wizard does not export data, the Weekly Export Service is for full backups, and Data Cloud Connection is unrelated.
Question 5Choose 1
A Platform Administrator wants to limit the kinds of reports their users can create. Which tool should the administrator use?
Correct answer:
A. Hide Report Types
Explanation:
To limit the kinds of reports users can create, the administrator controls which Report Types are visible to them. Hide Report Types (via the Report Type's visibility settings) prevents users from seeing and selecting specific Report Types when creating new reports. This restricts them to only the Report Types that are unhidden, thereby limiting the kinds of reports available.
Correct Option: A
Hide Report Types is a setting on each Report Type (Setup → Report Types → Edit → "Hide in Report Type Selection").
When hidden, users cannot select that Report Type when creating a report.
This directly controls what report structures (objects and relationships) users can build reports on.
Does not remove existing reports; only prevents creation of new ones using that Report Type.
Incorrect Option: B
Report Folder Sharing controls who can view, edit, or manage existing reports within folders, not which Report Types are available for creating new reports.
Users with access to a folder can still create new reports using any visible Report Type.
Does not limit the kinds of reports.
Incorrect Option: C
Standard Report Types are the built-in Report Types provided by Salesforce (e.g., Opportunities, Cases with Contacts).
Enabling or disabling standard Report Types as a whole is not a granular control; administrators hide specific Standard Report Types individually.
The existence of Standard Report Types is not a tool for limiting report creation.
Incorrect Option: D
Joined Report is a type of report format (combines multiple report blocks), not a tool for limiting report creation.
Irrelevant to restricting which Report Types users can access.
Reference:
Salesforce Help Article: Control Access to Report Types – Use the "Hide in Report Type Selection" checkbox on a Report Type to prevent users from creating new reports based on that Report Type. Folder sharing controls access to existing reports, not report creation options. Joined reports are a format, not a restriction tool.
That's the last free question in Data and Analytics Management
You've seen the free 25% of this topic (5 of 22 questions). Get complete access for every question, explanation and the timed exam simulator.
Our timed 2026 Salesforce Platform Administrator practice test mirrors the format, number of questions and time limit of the official exam.
The #1 challenge isn't just knowing the material, it's managing the clock. The simulation builds your speed and stamina, so you walk in knowing exactly what to expect.