certified-advanced-administrator Sample Questions & Answers
From record, field and territory-level access, the single biggest weight, to advanced reporting and dashboards, plus Service and Sales Cloud configuration, automation fixes, metadata migration, debug logs and audit trails, and data quality.
Launch the full certified-advanced-administrator simulator →Showing 10 of 20 free samples.
- Question 1Intermediate
Data Management · Duplicate Management
A marketing team frequently imports lead lists from trade shows. They report a high number of duplicate records being created, which is affecting reporting accuracy. The administrator needs to configure a solution that alerts users to potential duplicates when creating a lead manually and prevents duplicates from being created via the Data Import Wizard. What should the administrator configure?
Show answer & explanation
Correct answer: B
This is the standard Salesforce solution. A Matching Rule defines how duplicates are identified (e.g., based on email and name). A Duplicate Rule then uses the matching rule to specify what happens when a duplicate is detected, such as alerting the user or blocking the record creation. Duplicate rules can be configured to apply to different operations, including manual creation and imports.
- Question 2Intermediate
Process Automation · Process Builder Scheduled Actions
True or False: In a Process Builder process that is configured to evaluate a record when it's created, any scheduled actions are automatically removed from the queue if the record is subsequently edited and no longer meets the criteria.
Show answer & explanation
Correct answer: B
This statement is false. If a process is configured to run only when a record is created, its scheduled actions will remain in the queue even if the record is later edited to no longer meet the criteria. To have the system re-evaluate the criteria and potentially remove the scheduled action, the process must be configured to run when a record is 'created or edited'.
- Question 3Intermediate
Change Management · Change Sets
A development team is preparing to deploy a new feature from a Developer Pro sandbox to a Partial Copy sandbox for UAT. The feature includes a new custom object, several Apex classes, and a new custom field on the standard Account object. The administrator is using a change set for the deployment. After uploading the outbound change set, the deployment to the Partial Copy sandbox fails. What is a likely reason for the failure?
Show answer & explanation
Correct answer: C
When deploying Apex code to a sandbox or production environment, Salesforce runs all Apex tests in the target org. The deployment will fail if the overall code coverage in the target org, including the new code, is less than 75%. This is a common cause for deployment failures involving Apex.
- Question 4Intermediate
Analytics, Reports and Dashboards · Joined Reports
A marketing manager needs a single view that shows all Campaign records that have no Campaign Members, alongside a list of all Lead records that have an empty 'Company' field. The data from these two distinct queries needs to be displayed in separate blocks on one report screen. Which reporting tool should the administrator use to fulfill this requirement?
Show answer & explanation
Correct answer: C
Joined Reports are specifically designed to display data from different report types in separate blocks within a single report. This scenario requires one block for a Campaign report (using a cross-filter) and a second block for a Lead report. Only a Joined Report can combine these unrelated data sets into one view.
- Question 5Advanced
Content Management · Salesforce Content Permissions
The legal department at a large enterprise wants to control access to sensitive contract documents stored in Salesforce Content. They require that only members of the 'Legal Team' public group can access the 'Corporate Contracts' library, and within that library, only users with the 'Contract Manager' custom profile should be able to delete content. How should the administrator configure these permissions?
Show answer & explanation
Correct answer: C
Salesforce Content uses a specific permission model based on library membership. The administrator should first add the 'Legal Team' to the library. Then, to grant specific delete rights, they must create a custom library permission that includes the 'Delete Content' privilege. This custom permission can then be assigned to the specific Contract Manager users within that library, while other legal team members get a more restrictive permission (like Author or Viewer).
- Question 6Advanced
Extending Custom Objects and Applications · Object Relationship Limits
An administrator is building a complex solution on a custom object named 'Project'. There is a requirement for two different Roll-Up Summary Fields from a child object, 'Milestone'. Additionally, the 'Project' object needs to have a self-referencing lookup to create a parent-child hierarchy of projects. What is the maximum number of additional master-detail relationships that can be created on the 'Project' object?
Show answer & explanation
Correct answer: A
A custom object can have a maximum of two master-detail relationships. The scenario already describes one master-detail relationship where 'Project' is the master to 'Milestone'. Because an object can only be the master in two master-detail relationships, and it is the master to Milestone, it can only be the master in one more. However, the question asks for additional master-detail relationships on the project object, implying it would be the detail. Since it is already a master, it cannot also be the detail in a new master-detail relationship if it already has child records.
- Question 7Advanced
Security and Access · Troubleshooting Access
A user with the 'Sales Manager' profile reports they can see an 'Edit' button on an Opportunity record page but receive an 'Insufficient Privileges' error when they try to save their changes. The Opportunity OWD is Public Read-Only. The user is not the owner of the record. What is the most likely reason for this discrepancy between the UI and the user's actual permissions?
Show answer & explanation
Correct answer: A
This is a classic access control scenario. The user's profile grants them object-level permission to 'Edit' Opportunities, which makes the 'Edit' button visible. However, the Organization-Wide Default (OWD) is Read-Only, and because the user is not the owner, they need a sharing rule (or manual share) to grant them record-level write access. Without it, the system correctly prevents the save action with an error.
- Question 8Advanced
Service Cloud Applications · Entitlement Processes
Universal Containers wants to implement a multi-tiered support system using Entitlement Processes. 'Gold' level customers are entitled to 24/7 support with a 1-hour first response milestone. 'Silver' level customers get 12/5 support with a 4-hour first response. How should an administrator configure the milestones to respect the different business hours for each support level?
Show answer & explanation
Correct answer: B
The correct design is to create a distinct Entitlement Process for each support level ('Gold' and 'Silver'). Within each process, the administrator can define specific milestones. Crucially, different Business Hours can be associated with each Entitlement Process, ensuring that the milestone countdown for 'Silver' customers only occurs during their 12/5 support window, while the 'Gold' customers' clock runs 24/7.
- Question 9Intermediate
Analytics, Reports and Dashboards · Custom Report Types
An administrator needs to create a report that shows Accounts with and without related Opportunity records. The report must display all Accounts, regardless of whether they have an Opportunity. Which tool is best suited for this requirement?
Show answer & explanation
Correct answer: C
This specific option in the Custom Report Type setup creates a left outer join. It ensures that all records from the primary object (Accounts) are included in the report, and it will show related Opportunity data only where it exists. This perfectly matches the requirement to see all Accounts, both with and without Opportunities.
- Question 10Intermediate
Data Management · Lookup Filters
An administrator is designing a data quality process for a recruiting app. A custom object 'Candidate' has a lookup to another custom object 'Position'. The business requires that a Candidate record can only be linked to a Position record if the Position's 'Status' field is set to 'Open'. How should the administrator enforce this rule declaratively?
Show answer & explanation
Correct answer: B
A Lookup Filter is the ideal declarative tool for this. It restricts the valid records that can be selected in a lookup field based on criteria on the related object. By creating a filter on the Position lookup that requires 'Position: Status EQUALS Open', the administrator ensures users can only select and save valid records, improving both data quality and user experience.
Ready for the real thing?
The full certified-advanced-administrator simulator has every exam-style question, timed mode, and instant scoring.