Data and Analytics Management — Administrator Practice Quiz

Question 1

A sales manager wants a report that lists all Accounts that do NOT have any related Opportunities, so the team can prioritize outreach to inactive customers. Which reporting feature should the administrator use to build this report?

Accepted Answer

Add a cross filter on the Accounts report using 'without Opportunities'

Answer

Create a bucket column that groups Accounts by Opportunity count

Answer

Add a standard field filter where Opportunity Name equals blank

Answer

Use a summary formula (PARENTGROUPVAL) to count Opportunities per Account

Question 2

A sales manager clicks on a bar within a dashboard chart component and expects to see the underlying list of Opportunity records that make up that bar. Instead, nothing happens. The manager asks the administrator how users can view the detailed records behind a dashboard component. What should the administrator explain about dashboards in Lightning Experience?

Accepted Answer

Dashboard components display aggregated data only; to see the underlying records, users must open the source report the component is built on.

Answer

Users must be granted the 'View All Data' permission before any dashboard component becomes clickable.

Answer

The administrator must convert the dashboard to a dynamic dashboard so that records become viewable on click.

Answer

Dashboard components can never link to detailed records; the manager must build a separate report from scratch.

Question 3

The VP of Sales wants to receive an updated version of a key pipeline dashboard in her inbox every Monday morning at 7:00 AM without having to log in to Salesforce. The dashboard should reflect data as of the time it is sent. What should the administrator recommend to meet this requirement?

Accepted Answer

Subscribe the VP to the dashboard and set the subscription schedule to refresh and email the dashboard every Monday at 7:00 AM.

Answer

Convert the dashboard to a dynamic dashboard so it refreshes automatically for each viewer.

Answer

Create a report subscription on each source report and email them individually to the VP.

Answer

Add the VP as an additional running user so the dashboard updates when she opens the app.

Question 4

A sales operations analyst needs to import approximately 120,000 new Lead records from a purchased list. The import must trigger the org's active assignment rules and check for duplicates. Which tool should the administrator recommend?

Accepted Answer

Data Loader, because the Data Import Wizard is limited to 50,000 records per import

Answer

Data Import Wizard, because it can process any record volume and always runs assignment rules automatically

Answer

Mass Transfer Records tool, since it handles large-volume record creation

Answer

Data Loader, because the Data Import Wizard cannot import Lead objects

Question 5

A Salesforce administrator needs to extract all Contact records from the org for a compliance audit, including records that have been soft-deleted and are currently sitting in the Recycle Bin. The admin plans to use Data Loader for the extraction. Which Data Loader operation should the admin choose to include the soft-deleted records in the output file?

Accepted Answer

Use the Export All operation, which includes records that have been soft-deleted and are still in the Recycle Bin.

Answer

Use the Export operation, which retrieves all Contact records regardless of deletion status.

Answer

Use the Extract operation and check the 'Include Archived' checkbox in the field mapping dialog.

Answer

Use the Data Import Wizard's export feature and select the 'Recycle Bin' data source.

Question 6

An administrator needs to permanently remove 200,000 obsolete Lead records from Salesforce. Data storage is nearly at its limit, and the business wants the storage freed immediately without the records occupying the Recycle Bin. Which approach should the administrator use?

Accepted Answer

Use Data Loader with the Hard Delete operation

Answer

Use Data Loader with the Delete operation, then empty the Recycle Bin manually

Answer

Use the Data Import Wizard and select the delete option

Answer

Use Mass Delete Records from Setup and check the option to permanently remove

Question 7

An administrator needs to update 150,000 existing Account records by matching on a custom External ID field and inserting any records that don't yet exist. The source file also contains records for a custom object that has no import support in the point-and-click tool. Which tool and operation should the administrator use?

Accepted Answer

Data Loader using the Upsert operation, matching on the External ID field

Answer

Data Import Wizard using the Update operation, matching on the External ID field

Answer

Data Import Wizard using the Add new and update existing records option

Answer

Data Loader using separate Insert and Update operations run sequentially

Question 8

The sales operations team complains that reps keep creating duplicate Account records during manual entry. Management wants to completely prevent reps from saving a new Account when it matches an existing one, while still letting them see which record it duplicates. As the administrator, what should you configure?

Accepted Answer

Create a duplicate rule with the action set to 'Block' and reference a matching rule that identifies duplicate Accounts.

Answer

Create a duplicate rule with the action set to 'Allow' and enable the alert, so reps are warned but can still save.

Answer

Create a validation rule on the Account object that fires when the Account Name already exists.

Answer

Enable the standard Account matching rule only, which automatically blocks duplicate records on save.

Question 9

A sales VP wants a single dashboard where each viewer sees only the opportunity data they are permitted to see based on their own role and sharing access, rather than the data of a fixed running user. Multiple sales managers with different levels of visibility will access this dashboard. What should the administrator configure to meet this requirement?

Accepted Answer

Create a dynamic dashboard configured to run as the logged-in user

Answer

Set the running user to the sales VP so all managers see the VP's data

Answer

Schedule a dashboard subscription for each manager individually

Answer

Create separate static dashboards for each sales manager

Question 10

A sales manager wants a dashboard component that displays the total closed-won revenue for the current quarter as a single number, and also shows whether that value has crossed low, medium, and high breakpoint thresholds toward a $2M goal. Which dashboard component should the administrator use?

Accepted Answer

A gauge component with the segment breakpoints set to the target thresholds

Answer

A metric component showing the single value with a conditional color range

Answer

A funnel component grouped by opportunity stage

Answer

A table component sorted by the revenue summary field

Question 11

A sales operations analyst needs a single report that displays open Opportunities and open Cases for the same set of Accounts, shown side by side in separate result blocks so the VP can review both pipelines and support issues in one place. Which report format should the analyst use?

Accepted Answer

Joined report

Answer

Matrix report

Answer

Summary report with a cross filter

Answer

Tabular report with bucketing

Question 12

An administrator used the Mass Delete Records tool to remove 5,000 obsolete Lead records to free up storage. The next day, a manager reports that about 300 of those Leads were still active and need to be recovered. The deletion happened 20 hours ago and no other mass operations have run since. What is the fastest way for the administrator to restore the 300 Leads?

Accepted Answer

Restore the records from the Recycle Bin, which retains deleted records for 15 days.

Answer

Contact Salesforce Support to recover the records from a backup, since Mass Delete permanently removes records.

Answer

Re-import all 5,000 Leads using the Data Import Wizard and manually delete the ones that should stay deleted.

Answer

Use Data Loader with the Undelete operation against the original CSV of Lead IDs.

Question 13

A sales rep is leaving the company, and their 350 open Accounts must be reassigned to another active rep. The admin wants to move all of the departing rep's accounts (and their related open opportunities owned by the same rep) to the new owner as quickly as possible without exporting and re-importing data. Which tool should the admin use?

Accepted Answer

Mass Transfer Records in Setup, transferring Accounts from the old owner to the new owner

Answer

Data Import Wizard to update the OwnerId field on each Account

Answer

Data Loader to export the accounts, change the owner column, and re-import them

Answer

Manual sharing to grant the new rep access to each of the old rep's accounts

Question 14

An administrator wants to prevent sales reps from creating duplicate Lead records based on matching email address and company name. They create a new duplicate rule but notice they cannot select any criteria that compares fields for matching. What must the administrator configure first before the duplicate rule can identify potential duplicates?

Accepted Answer

A matching rule that defines which fields are compared to identify duplicate records

Answer

A validation rule that checks for duplicate email addresses on the Lead object

Answer

A workflow rule that flags records containing duplicate company names

Answer

A report that groups Leads by email and company to find existing duplicates

Question 15

A sales operations analyst needs a report that shows total closed-won revenue broken down by both Sales Region (as row groupings) and Product Family (as column groupings), so managers can see the revenue at each intersection in a grid layout. Which report format should the administrator choose?

Accepted Answer

Matrix report

Answer

Tabular report

Answer

Summary report

Answer

Joined report

Question 16

A sales manager wants a report that groups opportunities into three categories based on their Amount: 'Small' (under $10,000), 'Medium' ($10,000–$50,000), and 'Large' (over $50,000). The manager wants this grouping to appear in the report without creating any new fields on the Opportunity object. What should the administrator use to meet this requirement?

Accepted Answer

Create a bucket column on the Amount field within the report

Answer

Create a formula field on the Opportunity object that categorizes the Amount

Answer

Add a cross filter on the Amount field to segment the opportunities

Answer

Create a summary formula in the report to calculate the ranges

Question 17

A sales operations analyst needs to export data from a Salesforce report so it can be loaded into an external analytics tool. The external tool requires a clean file containing only the raw row data — no report title, groupings, subtotals, or header formatting. Which export option should the analyst choose?

Accepted Answer

Export in 'Details Only' format as a .csv file

Answer

Export in 'Formatted' report format as an .xlsx file

Answer

Use a printable view and save the page as a PDF

Answer

Subscribe to the report so it emails the results as an attachment

Question 18

A sales manager asks for a report that always shows Opportunities with a Close Date falling within the organization's current fiscal quarter. The manager will view this report daily and does not want to manually edit the date filter each quarter. Which filter configuration should the administrator use?

Accepted Answer

Set a filter of Close Date equals THIS FISCAL QUARTER using the relative date value

Answer

Set two filters: Close Date greater or equal to the quarter start date and less or equal to the quarter end date, entered manually

Answer

Add a cross filter on Opportunities with Close Date and configure a bucket column for the quarter

Answer

Set a filter of Close Date equals LAST 90 DAYS to approximate the current quarter

Question 19

A sales manager wants a report that lists individual open opportunities grouped by Stage, with a subtotal of the Amount field displayed for each stage grouping and a grand total at the bottom. Which report format should the administrator choose to meet this requirement?

Accepted Answer

Summary report

Answer

Tabular report

Answer

Matrix report

Answer

Joined report

Question 20

A sales operations analyst needs to build a report showing Accounts along with their related custom object 'Site Visits.' They also want to include Accounts that have NO Site Visit records so gaps in coverage are visible. When they look at the available report types, none of the standard ones let them include Accounts without Site Visits. What should the administrator do to enable this report?

Accepted Answer

Create a custom report type with Accounts as the primary object and Site Visits related with 'A' records may or may not have related 'B' records.

Answer

Create a custom report type with Site Visits as the primary object and Accounts related with 'each A record must have at least one related B record.'

Answer

Use the standard Accounts report type and add a cross filter for 'Accounts without Site Visits.'

Answer

Create a custom report type with Accounts as the primary object and Site Visits related with 'each A record must have at least one related B record.'

More Administrator practice