Salesforce Advanced-Administrator Exam Practice Test Instant Access

Question 1

A request was made to import a spreadsheet of new Campaign Members. He system administrator started Data import Wizard but the Campaign Members object was unavailable as a choice. What is causing as a choice.

What is causing this occur?

AThe Salesforce,id field is required and was missing from the file.

BThe marketing user feature license assignment is missing on the admin's user record.

CImport Wizard is only available for the Standard objects Accounts, Contacts, and Leads.

DThe Compaign Member option is only available for Update.

Answer : D

The Campaign Member option is only available for Update when using Data Import Wizard. This means that you can use Data Import Wizard to update existing campaign members with new or modified information, but you cannot use it to create new campaign members from a spreadsheet. To create new campaign members from a spreadsheet, you need to use other tools such as Data Loader, Import Wizard for Leads and Contacts, or Manage Members button on the campaign page. Reference: https://help.salesforce.com/s/articleView?id=sf.campaigns_members_adding_parent.htm&type=5 https://help.salesforce.com/s/articleView?id=sf.data_importer.htm&type=5

Question 2

Cloud Kicks would like to reassign ownership of all leads that are open and more than 60 days old. The system administrator has written an assignment rule to distribute these leads to the correct owners or queues.

Which two tools should the administrator use to update the owner of these leads?

Choose 2 answers

ABulk API

BMass Update

CDataloader.io

DImport Wizard

Answer : A, C

Bulk API and Dataloader.io are both tools that can be used to update large numbers of records in Salesforce. Bulk API is a RESTful API that allows you to create, update, delete, or query millions of records asynchronously by submitting batches of data. Dataloader.io is a web-based data loader tool that allows you to import, export, or delete data using a simple user interface. Reference: https://developer.salesforce.com/docs/atlas.en-us.api_asynch.meta/api_asynch/asynch_api_intro.htm https://dataloader.io/

Question 3

Cloud Kicks users report receiving an "Apex CPU time limit exceeded" error message when attempting to close certain opportunity records. This does not occur on every opportunity record change or for every user.

What is the recommended method for the administrator to identify the cause?

AMonitor with Login Forensics.

BEnable Debug Logging for users.

CReview the Setup Audit Trail.

DSet up Apex Exception Email alerts

Answer : B

Debug logs capture database operations, system processes, and errors that occur when executing a transaction or running unit tests. Debug logs can help identify the cause of Apex CPU time limit exceeded errors by showing the execution time of each Apex statement and trigger. Reference: https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/apex_debugging_debug_logs.htm

Question 4

Cloud Kicks uses a dashboard with multiple components based on Account, Case, and Opportunity reports. The system administrator adds a dashboard filter on Account Owner. When filtering the dashboard by Account Owner, records are now missing from several Opportunity components.

What is the recommended way for the system administrator to resolve this issue?

AAdd a cross-filter to the Opportunity source reports.

BUse a custom report type for Accounts with or without Opportunities.

COn the Opportunity components, change the equivalent field.

DCreate a joined Accounts and Opportunities report for the components.

Answer : C

The equivalent field is the field that matches the dashboard filter field on the source report object. For example, if the dashboard filter is on Account Owner, then the equivalent field on the Opportunity object is Opportunity Owner. Changing the equivalent field ensures that the dashboard filter applies correctly to the Opportunity components. Reference: https://help.salesforce.com/s/articleView?id=sf.dashboard_filters.htm&type=5

Question 5

When an Account has more than five open opportunities over US$10,000, the sales rep should have an option on the Account page to start the escalation process to allocate additional resources.

Which two configurations should the administrator create?

Choose 2 answers

AComponent Visibility filter

BFormula field

CRoll-Up Summary field

DDynamic Forms

Answer : B, D

Formula field and Dynamic Forms should be created to meet the requirements because a formula field can be used to count the number of open opportunities over US$10,000 related to an account using a roll-up summary filter condition, and Dynamic Forms can be used to display or hide a component on an account page based on a visibility filter using the formula field value. Reference: https://help.salesforce.com/s/articleView?id=sf.customize_functions_i_z.htm

Question 6

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?

AUse PREVGROUPVAL() in Report Builder.

BUse Role Hierarchy filter to restrict related records.

CUse a Summary report with Bucket Columns.

DUse a Cross Filter with WITHOUT logic.

Answer : D

A cross filter with WITHOUT logic is a method for creating a report that shows accounts that are missing certain related records. A cross filter is a filter that lets you include or exclude records in your report based on related objects and their fields. You can use cross filters to create reports on accounts with or without opportunities, contacts, cases, or other related objects. In this case, you can use a cross filter with WITHOUT logic to show accounts without assets that have a certain product name or code. This way, you can identify customers that need to install a new solar panel monitor system. Reference: https://help.salesforce.com/s/articleView?id=sf.reports_cross_filters.htm&type=5 https://help.salesforce.com/s/articleView?id=sf.reports_examples_cross_filters.htm&type=5

Question 7

DreamHouse Realty wants better insights into potential revenue in the next quarter and is considering using Collaborative Forecasts.

What should the administrator consider when setting up Collaborative Forecasts?

AOpportunity Split data cannot be viewed in a forecast.

BA forecast can be either revenue-based or quantity-based.

CA single org can have up to six different types of forecasts.

DThe default forecast categories cannot be customized.

Answer : B

A forecast is a projection of how much revenue or quantity you can generate from your sales pipeline for a given period of time. A forecast can be either revenue-based or quantity-based, depending on what you want to measure and track. A revenue-based forecast shows the amount of money expected from closed sales, while a quantity-based forecast shows the number of units expected from closed sales. You can choose the forecast type that best suits your business needs and goals when you set up Collaborative Forecasts in Salesforce. Reference: https://help.salesforce.com/s/articleView?id=sf.forecasts3_overview.htm&type=5 https://help.salesforce.com/s/articleView?id=sf.forecasts3_forecast_types.htm&type=5

Salesforce Certified Advanced Administrator Exam Practice Test