nerdexam
SalesforceSalesforce

PLAT-ADMN-201 · Question #144

PLAT-ADMN-201 Question #144: Real Exam Question with Answer & Explanation

The correct answer is C: Unique Count. Unique Count is the correct tool because it counts each distinct Account value only once, even when that account appears across multiple opportunity rows - giving the sales rep an accurate count of how many accounts have open opportunities, not how many opportunities exist. Think

Submitted by yaw92· Apr 18, 2026Data and Analytics Management

Question

A sales rep typically has several open opportunities for each of their accounts. Which tool should a Platform Administrator suggest to the sales rep to obtain the total number of accounts associated with open opportunities in a report?

Options

  • ABucket Column
  • Bexclude records. Grouping Rows (Option D) visually organizes the report by Account but does
  • CUnique Count
  • DGroup Rows

Explanation

Unique Count is the correct tool because it counts each distinct Account value only once, even when that account appears across multiple opportunity rows - giving the sales rep an accurate count of how many accounts have open opportunities, not how many opportunities exist. Think of it as Salesforce's equivalent of COUNT(DISTINCT Account) in SQL.

Why the distractors are wrong:

  • Bucket Column (A) categorizes field values into custom groups (e.g., "Small/Medium/Large"), it does not count distinct records.
  • Option B appears to describe filtering behavior - excluding records narrows the data set but produces no aggregate count.
  • Group Rows (D) organizes report rows by Account (useful for visual grouping), but it does not surface a single count of unique accounts; each grouped account still appears as a separate section.

Memory tip: Whenever a question mentions "one-to-many" data (one account → many opportunities) and asks for a count of the parent side, reach for Unique Count - it deduplicates before counting, so repeated accounts are only tallied once.

Topics

#Salesforce Reports#Report Summarization#Unique Count#Opportunity Reporting

Community Discussion

No community discussion yet for this question.

Full PLAT-ADMN-201 PracticeBrowse All PLAT-ADMN-201 Questions