Salesforce Advanced Admin Exam with
Questions and Correct Answers
What should be used to track changes in the sales pipeline? - ✔✔Historical Trending Report
What are the attributes of Historical Trending Report? - ✔✔1. Stores previous 3 months and
current month
2. Highlights changes between up to 5 snapshot dates
What are cross block custom summary formulas? - ✔✔Formulas used to calculate a value
referring to summary values from multiple blocks in a joined report
What can you do with custom summary formulas? - ✔✔Use up to 5 formulas
Conditional highlighting
What is bucketing? - ✔✔Bucketing enables the segmentation of report data on the fly by
defining a set of categories, or "buckets", to sort, group, or filter the records. Example "High,
Low, Zero" for Annual Revenue
What types of fields can be used in bucketing? - ✔✔Number, percent, currency, picklist, and
text
What is an exception report? - ✔✔An exception report uses a "without" relationship to how
where data doesn't exist (e.g. Accounts without opportunities)
What do cross filters do? - ✔✔Cross filters enable filtering of the parent records in a report
by their related child records (using WITH or WITHOUT conditions).
,How many cross filters can be applied to a single report? - ✔✔Three
What fields can have conditional highlighting in a report? - ✔✔Custom summary formulas
What is a sub-filter? - ✔✔A sub-filter provides an option to extend a cross filter by including
only child records that meet certain criteria.
How many sub-filters can be applied to a single cross filter? - ✔✔Five
What are two important aspects of the primary object? - ✔✔1. It dictates which related
objects can be included in the report type.
2. It controls which object appears in the show filter and other filters in the report builder.
What are report types? - ✔✔Report types are predetermined combinations of related
objects and their fields that are used as starting points when building new, custom reports.
True or False: Standard report types are available by defaults for standard objects only. -
✔✔False. Standard report types are available by default for standard and custom objects as
well as their related objects.
True or False: New custom fields are NOT automatically added to standard report types. -
✔✔False
True or False: Standard report types show "with" relationships. - ✔✔True
Where is the Field Audit Trail stored? - ✔✔The FieldHistoryArchive object from the history
related list
How many fields can you track per object using Field History Tracking? - ✔✔20
, How long does Field Audit Trail retain history? - ✔✔10 years
Where would you go to check on which admins made changes to users or custom objects? -
✔✔Setup Audit Trail
How are Email logs saved? - ✔✔CSV file
What permission do you need to access email logs? - ✔✔Modify all data
How long are login histories saved? - ✔✔6 months or 20,000 records
How do you track unusual behavior in Salesforce? - ✔✔Login Forensics
Where would you check on a broken workflow rule? - ✔✔Debug Log
What sections are under monitoring in Setup? (10) - ✔✔Health Check
System Overview
Storage Usage
Debug log
Jobs
Outbound messages
Paused flows
Important queue
Time-Based workflow
API usage notifications
Questions and Correct Answers
What should be used to track changes in the sales pipeline? - ✔✔Historical Trending Report
What are the attributes of Historical Trending Report? - ✔✔1. Stores previous 3 months and
current month
2. Highlights changes between up to 5 snapshot dates
What are cross block custom summary formulas? - ✔✔Formulas used to calculate a value
referring to summary values from multiple blocks in a joined report
What can you do with custom summary formulas? - ✔✔Use up to 5 formulas
Conditional highlighting
What is bucketing? - ✔✔Bucketing enables the segmentation of report data on the fly by
defining a set of categories, or "buckets", to sort, group, or filter the records. Example "High,
Low, Zero" for Annual Revenue
What types of fields can be used in bucketing? - ✔✔Number, percent, currency, picklist, and
text
What is an exception report? - ✔✔An exception report uses a "without" relationship to how
where data doesn't exist (e.g. Accounts without opportunities)
What do cross filters do? - ✔✔Cross filters enable filtering of the parent records in a report
by their related child records (using WITH or WITHOUT conditions).
,How many cross filters can be applied to a single report? - ✔✔Three
What fields can have conditional highlighting in a report? - ✔✔Custom summary formulas
What is a sub-filter? - ✔✔A sub-filter provides an option to extend a cross filter by including
only child records that meet certain criteria.
How many sub-filters can be applied to a single cross filter? - ✔✔Five
What are two important aspects of the primary object? - ✔✔1. It dictates which related
objects can be included in the report type.
2. It controls which object appears in the show filter and other filters in the report builder.
What are report types? - ✔✔Report types are predetermined combinations of related
objects and their fields that are used as starting points when building new, custom reports.
True or False: Standard report types are available by defaults for standard objects only. -
✔✔False. Standard report types are available by default for standard and custom objects as
well as their related objects.
True or False: New custom fields are NOT automatically added to standard report types. -
✔✔False
True or False: Standard report types show "with" relationships. - ✔✔True
Where is the Field Audit Trail stored? - ✔✔The FieldHistoryArchive object from the history
related list
How many fields can you track per object using Field History Tracking? - ✔✔20
, How long does Field Audit Trail retain history? - ✔✔10 years
Where would you go to check on which admins made changes to users or custom objects? -
✔✔Setup Audit Trail
How are Email logs saved? - ✔✔CSV file
What permission do you need to access email logs? - ✔✔Modify all data
How long are login histories saved? - ✔✔6 months or 20,000 records
How do you track unusual behavior in Salesforce? - ✔✔Login Forensics
Where would you check on a broken workflow rule? - ✔✔Debug Log
What sections are under monitoring in Setup? (10) - ✔✔Health Check
System Overview
Storage Usage
Debug log
Jobs
Outbound messages
Paused flows
Important queue
Time-Based workflow
API usage notifications
