SF-Admin Sales and Marketing Applications Practice Question
A sales manager at AW Computing wants to analyze the performance of sales reps by comparing the total value of closed-won opportunities to their quotas. The administrator needs to create a report that shows each rep's total closed-won amount and their quota attainment percentage. Which report type should the administrator use?
⚠ Common exam trap
The trap here is assuming that the standard Opportunities report can include quota data, but quotas are stored separately and require a specific report type to combine them.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Opportunity with Quota
Opportunity with Quota is the correct report type because it includes both opportunity and quota data, allowing the administrator to create a report that shows each rep's closed-won amount and their quota attainment percentage. The other report types either lack quota information or focus on different aspects like products or history.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Opportunities with Products
Why it's wrong here
Opportunities with Products is used to report on opportunity line items and product details. It does not include quota information, which is stored in the User object or a custom object. Therefore, it cannot show quota attainment percentage and is not suitable for this requirement.
- ✗
Opportunities with Opportunity History
Why it's wrong here
Opportunities with Opportunity History reports on stage duration and historical changes, not on quota attainment. Quota data is not available in this report type. The sales manager needs to compare closed-won amounts to quotas, so this report type lacks the necessary quota fields.
- ✓
Opportunity with Quota
Why this is correct
Opportunity with Quota is a standard report type that combines opportunity data with quota information. It allows reporting on closed-won amounts alongside quota amounts, enabling the calculation of attainment percentage. This report type is specifically designed for comparing performance against quotas.
- ✗
Opportunities
Why it's wrong here
The standard Opportunities report type includes opportunity fields but does not include quota information. While it can show closed-won amounts, it cannot display quota attainment unless custom fields are created and added. Without quotas, it cannot calculate the attainment percentage, so it is not the best choice.
About these practice questions
This SF-Admin question is part of Courseiva's 202-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Salesforce exam blueprint
This SF-Admin practice question is part of Courseiva's free Salesforce certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the SF-Admin exam.