Labour Day Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70percent

Salesforce Advanced-Administrator Salesforce Certified Advanced Administrator (SP23) Exam Practice Test

Salesforce Certified Advanced Administrator (SP23) Questions and Answers

Question 1

Ursa Major Solar (UMS) wants to identify customers that need to install a new solar panel monitor system it recently released. UMS tracks the installed products as Asset records that art related to the Account. Sales management has asked the administrator to create a report for users.

What is the recommended method for the administrator to meet the requirement?

Options:

A.

Use PREVGROUPVAL() in Report Builder.

B.

Use Role Hierarchy filter to restrict related records.

C.

Use a Summary report with Bucket Columns.

D.

Use a Cross Filter with WITHOUT logic.

Question 2

An administrator is creating a custom Opportunity record page for Sales users for new logo opportunities. They need to control what fields display on the record when a sales user is viewing the opportunity.

Where should the administrator edit what fields display in the details of the record page?

Options:

A.

Record Detail Component

B.

Custom Lightning Component

C.

Record Types

D.

Page Layout

Question 3

Ursa Major Solar has a global customer base. Recent issues with customs have greatly delayed shipping to Canadian customers. While the Country field is already on the page layout, the sales team wants Canadian customers highlighted as a potential challenge for fulfillment until the shipping issue is resolved.

How should the administrator solve this issue?

Options:

A.

Modify the page layouts to move the Country field into its own section.

B.

Add a rich text component to the Lightning page. Use conditional visibility to only show the component if the account is Canadian.

C.

Create an in-app guidance prompt for Canadian records.

D.

Create a new record type and page layout for Canadian customers, ensuring their pages look different.

Question 4

At Ursa Major Solar, several different planetary teams handle leads depending on which planet the lead is coming from. While most of the teams only need a few fields filled out to work the lead, the Jupiter team requires additional information to be filled out, such as which moon the lead is coming from. The administrator needs to automate which team is allocated the lead record based on the planet and ensure that every team has all of the information they need.

Which two features will satisfy these requirements?

Choose 2 answers

Options:

A.

Assignment Rules

B.

Validation Rules

C.

Matching Rules

D.

Workflow Rules

Question 5

The administrator at Cloud Kicks is troubleshooting an issue one user is having with a flow. They have decided to add a debug log to that user.

What debug log category should be used?

Options:

A.

Workflow

B.

Callout

C.

System

D.

Database

Question 6

Cloud Kicks (CK) typically sells Its products direct to consumer and tracks sales using the Order object In Salesforce. The head of sales has now decided that CK will also sell to retail locations for resale. The administrator wants to leverage opportunities and opportunity products for these new deals.

What should the administrator do to track accurate sales data on opportunities?

Options:

A.

Create new Products with the new retail pricing.

B.

Add a new Order Process for Orders generated from opportunities.

C.

Create a new Price Book for the new retail pricing.

D.

Add a required lookup field from the Order to the opportunity.

Question 7

Universal Containers' support team wants to use Salesforce Knowledge to allow customers and the support team to have access to the product documentation. There are many different types of documentation with usage across the globe.

What feature should the administrator configure?

Options:

A.

Enable the Case Feed.

B.

Create article types.

C.

Define data categories and visibility.

D.

Setup record types and page layouts.

Question 8

Management at Ursa Major Solar wants to understand how many accounts have opportunities in the overall pipeline.

What should the administrator use to create a report showing all open opportunities and the total number of accounts represented?

Options:

A.

The row count on a summary report grouped by account name

B.

A Cross Filter selecting opportunities with accounts

C.

A custom report type showing opportunities with accounts

D.

The Show Unique Count option on the account name column

Question 9

Users report that the industry picklist field is no longer visible on account records. What test can an administrator use to troubleshoot the issue?

Options:

A.

Field audit history

B.

Setup audit trail

C.

Field history tracking

D.

Debug log

Question 10

An administrator at Cloud Kicks has been tasked by the compliance team to flag where sensitive information is stored in Salesforce.

What feature should the administrator use to fulfill this requirement?

Options:

A.

Data Classification

B.

Schema Builder

C.

Classic Encryption

D.

Field-Level Security

Question 11

Cloud Kicks (CK) has a filed called Shoe Type Preference, CK,s product team wants to see a report that groups specific picklist values together into the one of two lists.

What functionality should the administrator use to fulfill the team’s request?

Options:

A.

PREVGROUPVALUE

B.

Summary Formula

C.

Bucket field

D.

Matrix Report

Question 12

An administrator needs to Import a large amount of historical data (more than 100,000 records) from another system.

how should the administrator import the data?

Options:

A.

SOAP based API with Developer console

B.

Data Loader with Bulk API Enabled

C.

An AppExchange package

D.

Import Wizard with Add Only

Question 13

An administrator wants to determine if brute-force password attacks are being used against the org. A brute-force attack is when multiple password combinations are attempted in a short time period.

Where should the administrator look for more information?

Options:

A.

Login Forensics

B.

Connected Apps OAuth Usage

C.

Event Manager

D.

User Field History Tracking

Question 14

Cloud Kicks wants its sales reps to always use the same full zip code format with a hyphen where applicable.

What should the administrator implement to help ensure consistent formatting?

Options:

A.

Edit the standard field length to five characters.

B.

Add a quick create function for the sales reps to use.

C.

Create a REGEX function to use in a validation rule on the field.

D.

Add a help text instructing the sales rep on how to enter this field.

Question 15

An administrator is given a .csv file of 5,000 leads with External Id and Status fields. They need to match existing and add new records with Data Loader.

What action should be taken to populate the Status field on the records and add new records?

Options:

A.

Export

B.

Update

C.

Insert

D.

Upsert

Question 16

At Cloud Kicks, users are able to run reports. However, when users try to export a report, they are taken to a login screen and prompted for additional verification.

What is causing this issue?

Options:

A.

Users need to update their browser to the latest version.

B.

The users are logged Into an Insecure network.

C.

The users' profile is missing the Export Reports permission.

D.

Exporting Is configured to require a high assurance session.

Question 17

The Service team at Cloud Kicks needs a way to show the current status from the Account on the Case. This value should be on the page and is used in validation rules.

What should the administrator recommend to solve this?

Options:

A.

Create a cross-object formula.

B.

Use a picklist field.

C.

Make a Rollup Summary.

D.

Add a lookup field to Account.

Question 18

Sales reps at AW Computing hove been reporting that contact phone numbers sometimes revert book to on old value after being updated.

What should the administrator do to resolve this issue?

Options:

A.

Schedule Apex jobs.

B.

Delete all workflow rules.

C.

Add an invocable process.

D.

Consolidate automation tools.

Question 19

Northern Trail Outfitters (NTO) wants to start using Salesforce for its HR recruiting process. NTO needs to ensure that every application is linked to both a job posting and an applicants can apply for more one job posting, and each job posting can have more than one application.

How should an administrator configure the objects?

Options:

A.

Make Job Application as a junction object with a master-detail relationship to Applications and a lookup relationship to Job Posting.

B.

Create Application as a junction object with a master- detail relations to Job Postings and a lookup relationship to Job Applications.

C.

Add applicants as a junction object with master-detail relationship to both Posting and Job Applications.

D.

Configure Job Application as a Junction object with master-detail relationship to both Application and Job Postings.

Question 20

A user accidentally created a duplicate opportunity and is unable to delete the duplicate record.

What should an administrator do to troubleshoot this issue?

Options:

A.

Run a report of all opportunities to identify other possible duplicates.

B.

Check the user profile permissions on the Opportunity object to see if they have permission to delete.

C.

Advise the user to mark the duplicate opportunity Closed Lost and keep it in the system.

D.

Change the user's profile to System Administrator so they have full permissions to delete object records.

Question 21

The accounting team at Universal Containers is looking to roll out two new custom objects: a parent Invoice object and a child Payment object. Whenever a Payment record is created, the Invoice object should be updated to reflect the current outstanding value of the Invoice.

What should the administrator do to build this functionality?

Options:

A.

Create a lookup-relationship on the Payment with a Roll-up Summary field on the Invoice.

B.

Create a lookup-relationship on the Payment and a workflow cross object field update.

C.

Create a master-detail relationship on the Payment and a workflow cross object field update.

D.

Create a master-detail relationship on the Payment with a Roll-up Summary field on the Invoice.

Question 22

AW Computing sells a variety of software programs for Its customers to choose from. Management wants to ensure that the customer automatically receives phone support when they purchase photo editing. software.

how should an administrator meet these retirements?

Options:

A.

Add an entitlement template to the product for phone support.

B.

Include a milestone to the product with a term of 365 days for phone support.

C.

Configure a flow to create a milestone co the asset upon purchase.

D.

Create a flow to attach an entitlement to the asset upon purchase.

Question 23

Universal Containers wants to assign a task due date on one of two fields. Estimated Shipping Date or Client Need By Date, which is further in the future.

Which two combined automation tools should the administrator use to create the task record and assign based on date criteria?

Choose 2 answers

Options:

A.

Create a formula capture the MAX date.

B.

Make a Process Builder to create the task.

C.

Design an approval process to capture the furthest date.

D.

Configure a workflow to create the task.

Question 24

AW Computing is conducting an audit and wants to understand how many objects have been shared as public externally.

which tool should the administrator use to quickly obtain this details?

Options:

A.

Security Health Check

B.

Setup Audit Trail

C.

Session Security Settings

D.

Object Manager

Question 25

Ursa Major Solar offers customers annual service contracts. Account owners should receive an email renewal reminder l month before their customer's planned expiration date. The administrator builds a flow to automate the process, which runs when a record is created, and tests several possible scenarios.

What win occur if the expiration date is changed from January 1 of the next year to yesterday?

Options:

A.

The flow is unable to run and a flow error message Is sent to the user who Initiates the flow.

B.

The Interview resumes 1 month before the original expiration date and will send the email at that rime.

C.

The Interview is rescheduled based on the expiration date and sends the email on the last day of the current month.

D.

The resume event is recalculated and the email goes out to the account owner immediately.

Question 26

At Cloud Kicks, the Sales team uses a specific dashboard to see how they are doing daily. The team has asked the administrator for an easier way to see this dashboard.

What should the administrator recommend?

Options:

A.

Add the dashboard to the Sales team's home page.

B.

Create a custom app with a dashboard.

C.

Email the dashboard to the Sales Team every morning.

D.

Update the Sales team's app with a new dashboard.

Question 27

The distributors at Cloud Kicks are eligible for support based on a specific service contract-How should the administrator show this in Salesforce?

Options:

A.

Use entitlement management.

B.

Add a service contract to the record.

C.

Turn on Service Cloud.

D.

Build a new custom object.

Question 28

AW Computing has a private sharing model for Its accounts, but a sales rep occasionally needs ass/stance from an engineer. What feature should be used to grant the engineer access to the necessary account, while maintaining the company's data security?

Options:

A.

Permission Set

B.

Permission Set Group

C.

Account Teams

D.

Custom Profile

Question 29

Ursa Major Solar has a junction object that connects Docs with Solar Panels. The administrator needs users to be able to see all the solar panels that a Dot is related to. Users already have access to the Bot and the Junction, but not the Solar Panel object.

What access docs the user need to be able to see the solar panel records?

Options:

A.

Read permission is required on both master records.

B.

Access permission Is not required on either master record.

C.

Create permission Is required on both master records.

D.

Read permission is required on at least are master record.

Question 30

AW Computing has been advertising a new keyboard that was released at the beginning of the month. The sales team has an additional incentive to add the keyboards to every sale. The administrator already added the product to Salesforce but the reps are unable to select the product on the opportunity.

Which two options should an administrator check to ensure the product is available?

Choose 2 answers

Options:

A.

Confirm the correct price book is selected on the opportunity.

B.

Make sure the price book Is in the company currency.

C.

Ensure the product is associated with the correct price book.

D.

Verify the product has a start date entered.

Question 31

The administrator at Cloud Kicks created a flow in a sandbox that walks service agents through the Return Merchandise Authorization creation process. The administrator deployed the flow to production with a Change Set. Users are unable to use the flow in production.

Which step should the administrator take?

Activate the flow administrator take?

Options:

A.

Activate the flow manually after deployment.

B.

Include the active and prior inactive flow version in the Change Set.

C.

Ensure there is an active flow version in the sandbox.

D.

Deployment the flow, with the Metadata API instead of Change Sets

Question 32

The Cloud Kicks online Lead Intake form was recently updated to allow for new choices on some older picklist fields. The leads are all being created properly in Salesforce, but reps are getting errors as they try to work the leads.

What tool should the administrator use to evaluate what is causing the errors?

Options:

A.

Login History

B.

Debug Log

C.

Setup Audit Log

D.

Record History

Question 33

What are three options available to the administrator to help with this issue? Choose 3 answers

Options:

A.

Move some page components behind a tab.

B.

Remove some of the fields displayed.

C.

Deactivate unnecessary validation rules.

D.

Convert all Process builders to flows.

E.

Reduce the number of related lists displayed.

Question 34

An administrator has a request to write a report listing accounts that have sales from this year and that have a completed activity in the last 30 days.

What reporting feature should the administrator employ to provide only the list of accounts, without listing the details of the opportunities?

Options:

A.

Joined Report

B.

Cross-Filter

C.

Summary Report

D.

Filter Logic

Question 35

Ursa Major Solar's administrator has configured multiple record-triggered flows to run before or after the record is saved on the Account object.

What should the administrator consider when a record-triggered flow executes first?

Options:

A.

Assign the highest priority to the record-triggered flow which should execute first.

B.

The flow with the longest execution time will execute first.

C.

The flow with the shortest execution time will execute first.

D.

The order in which those flows are executed is not guaranteed.