Practice Free Certified Advanced Administrator Exam Online Questions
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?
- A . Export
- B . Update
- C . Insert
- D . Upsert
D
Explanation:
Upsert is an operation that can either update existing records or insert new records based on the External Id field. This way, the administrator can match existing leads and add new ones with Data Loader.
Reference: https://help.salesforce.com/s/articleView?id=sf.data_loader_upsert.htm&type=5
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?
- 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.
D
Explanation:
The resume event is recalculated and the email goes out to the account owner immediately because the flow uses a scheduled path that evaluates the expiration date field every time it changes. When the expiration date is changed to yesterday, the flow resumes immediately and executes the action of sending the email
Sales teams at Cloud Kicks ask each visiting customer to fill out a form that capturing their contact information and some basic footwear preferences. This information is saved to a spreadsheet and used by the sales team to alert their contacts when new shows are added to the inventory that matches their preferences. The sales team wants to be able to track this in Salesforce and see the information when viewing the contact Record.
Which two ways should the administrator configure this requirement? Choose 2 answers
- A . Data Loader
- B . Lookup Field
- C . Lightning Object Creator
- D . Schema Builder
A, C
Explanation:
Data Loader is a tool that allows administrators to import, export, insert, update, delete, or upsert records in Salesforce using CSV files. Data Loader can handle large data sets and complex data transformations. Data Loader can be used to import records for a custom object from a spreadsheet. Lightning Object Creator is a tool that allows administrators to create custom objects in Salesforce from spreadsheets. Lightning Object Creator can automatically map spreadsheet columns to fields and create relationships between objects. Lightning Object Creator can be used to create a custom object from a spreadsheet and import records at the same time.
What should an administrator use to restrict a user’s ability to view a specific field in both reports and record pages?
- A . Page Layouts
- B . Field-Level Security
- C . Permission Sets
- D . Profile Settings
Ursa Major Solar wants to add a chat component to its corporate website, where its service agents can respond directly from Salesforce.
What are two considerations the administrator should understand before adding Chat to the Service Console? Choose 2 answers
- A . Chat is unavailable in Lightning Experience if also using Omni-Channel.
- B . Chat can only be added to Standard navigation Lightning apps.
- C . Chat must be routed with Omni-Channel in Lightning Experience.
- D . Chat can only be added to Console navigation Lightning apps.
C, D
Explanation:
Chat must be routed with Omni-Channel in Lightning Experience because Omni-Channel is the only way to route chats to agents in Lightning Experience1. Chat can only be added to Console navigation Lightning apps because Chat is a console app feature and requires a console app with a console navigation style2.
Reference:
1 https://help.salesforce.com/s/articleView?id=sf.live_agent_chat_omnichannel.htm&ty pe=5
2 https://help.salesforce.com/s/articleView?id=sf.live_agent_chat_app.htm&type=5
The sales manager at Cloud Kicks (CK) wants to make sure the accounts that CK serves are happy. One way they track this is by how many open cases an account has with CK. The sales manager asks CK’s administrator to build a report to show Accounts with Open Cases.
What report type would this be?
- A . Bucket Report
- B . Joined Report
- C . Summary Report
- D . Matrix Report
B
Explanation:
A joined report is a type of report that allows you to create multiple report blocks that provide different views of your data. Each report block can have its own fields, columns, sorting, and filtering. A joined report can only be created from summary or matrix reports. You can use a joined report to show data from different report types or data sources on a single report. In this case, you can use a joined report to show Accounts with Open Cases by creating two report blocks: one for accounts and one for cases with a filter for open status. You can then join the two blocks by a common field such as Account ID or Account Name.
Reference:
https://help.salesforce.com/s/articleView?id=sf.reports_joined_format.htm&type=5
https://help.salesforce.com/s/articleView?id=sf.reports_examples_joined.htm&type=5
An administrator needs to create a junction object called Account Region to link the standard Account object with a custom object called Region.
Once the junction object is created, what are the next two steps the administrator should take? Choose 2 answers
- A . Make a master-detail relationship field on the junction object to the Region object.
- B . Build a master-detail relationship field on the Region object to the junction object.
- C . Create a master-detail relationship field on the Account object to the junction object.
- D . Configure a master-detail relationship field on the junction object to the Account object.
A, D
Explanation:
A junction object is a custom object that has two master-detail relationships with two other objects.
A junction object allows administrators to create many-to-many relationships between objects, such as relating multiple accounts to multiple regions.
To create a junction object called Account Region to link the standard Account object with a custom object called Region, an administrator needs to do the following steps:
A) Make a master-detail relationship field on the junction object to the Region object.
A master-detail relationship field is a field that links a child record to a parent record. The child record inherits the sharing and security settings of the parent record. By making a master-detail relationship field on the junction object to the Region object, an administrator can link each Account Region record to one Region record and make Region the first master of the junction object.
Reference: https://help.salesforce.com/s/articleView?id=sf.relationships_considerations.htm&type=5
D) Configure a master-detail relationship field on the junction object to the Account object.
By configuring a master-detail relationship field on the junction object to the Account object, an administrator can link each Account Region record to one Account record and make Account the second master of the junction object. This allows administrators to relate multiple accounts to multiple regions through the junction object.
Reference: https://help.salesforce.com/s/articleView?id=sf.relationships_considerations.htm&type=5
Support staff at Cloud Kicks work on multiple accounts and opportunities at the same time, Currently, they are switching between browser tabs, which is tedious and confusing. Support managers put in a request for a better agent experience.
What should an administrator recommend?
- A . Create a screen flow to pull all related opportunities onto one page.
- B . Enable Subtab Record Browsing in the Setup menu.
- C . Configure Split Lit Views.
- D . Implement Service Console.
D
Explanation:
Implement Service Console is what the administrator should recommend to support staff at Cloud Kicks for a better agent experience. Service Console is a Salesforce app that provides a unified interface for agents to manage multiple customer interactions and records at once. Service Console can help agents work more efficiently and productively by providing features such as tabs, subtabs, list views, related lists, highlights panel, interaction log, macros, keyboard shortcuts, and more
An administrator need a business process automated, but only for certain user and profiles. The administrator will need to frequently update which users and profiles will use the process. After evaluating the declarative options, it was determined that this functionality must be done via an Apex trigger.
What software requirement should the administrator request so that process execution can be declaratively controlled?
- A . Use Process Automation Setting in Setup to the appropriate users or profiles.
- B . Use a System permission that is assigned to the user or profile.
- C . Use Apex Class Access to assign the Apex code to the user or profile.
- D . Use a custom permission set that is assigned to the user.
D
Explanation:
Use a custom permission set that is assigned to the user because custom permissions are a way to grant access to custom processes or functionality based on user profiles or permission sets. Custom permissions can be referenced by Apex code, validation rules, flows, or other logic to control whether a process should run for a user or not. Custom permissions can be used to declaratively control process execution by assigning them to users or profiles.
The Cloud Kicks administrator wants to open up opportunity sharing to directors who oversee regional managers so they can access records to assist regional managers.
What sharing mechanism should be used?
- A . organization wide Defaults
- B . Role Hierarchy
- C . Manual Sharing
- D . Sharing Settings
B
Explanation:
Role hierarchy is a sharing mechanism that should be used to open up opportunity sharing to directors who oversee regional managers so they can access records to assist regional managers. Role hierarchy is a way to grant access to records based on the user’s position in an organization’s hierarchy of roles. Role hierarchy can grant users access to records owned by or shared with users below them in the hierarchy for objects that have organization-wide defaults set to Private or Public Read Only. By using role hierarchy, the administrator can ensure that directors can access opportunities owned by or shared with regional managers who report to them