The steps that the sales manager should follow to create a report that shows their top-selling product families by quantity are:

• Group by product family > Filter to show only Closed Won opportunities > Sum the total number sold

These steps will allow the sales manager to see how many products from each product family were sold in the closed opportunities, and compare the performance of different product families.

A spreadsheet is a representation of an object, where the records are rows and the fields are columns. An object is a collection of records that have the same fields, such as account, contact, or opportunity.

The easiest method to change the work hours information in the Salesforce org to reflect the new time zone is to go to Settings -> Personal Information -> My Work Information, and select the appropriate time zone from the drop-down menu.

Creating a dashboard is the recommended way to meet the requirements of displaying an easy-to-understand visual representation of accounts and opportunities that have been worked on by the sales agents in the current quarter. A dashboard is a collection of components that display data from one or more reports in a graphical format, such as charts, gauges, metrics, and tables. A dashboard allows the user to identify trends, sort data, and measure the impact of their activities. For example, a dashboard could show the number of accounts and opportunities by sales agent, the total amount of closed won opportunities by month, and the average deal size by industry. Creating a list view would not work, because a list view is a filtered set of records that display data in a tabular format, not a graphical format. A list view does not allow the user to identify trends, sort data, or measure the impact of their activities. Creating a custom tab would not work, because a custom tab is a user interface element that allows the user to access a custom object, a web page, or a Lightning page. A custom tab does not display data in a graphical format, but in a record detail or page layout format.

Permission sets are what should be used to allow additional field-level access to individual employees based on their job duties. Permission sets are a type of metadata that grant additional access and permissions to users based on their functional or departmental needs. Permission sets can include field-level security settings that allow read or edit access to specific fields on an object. Permission sets can be assigned to multiple users, regardless of their profile. Individual profiles are a type of metadata that define the baseline access and permissions for users based on their license type and job function. Profiles include field-level security settings that allow read or edit access to fields on an object. Profiles cannot be assigned to individual users, but to a group of users who share the same license and job function. Role hierarchy is a type of metadata that define the level of access and visibility of records for users based on their position in the organization. Role hierarchy allows users to access records owned by or shared with users below them in the hierarchy. Role hierarchy does not affect field-level access, but record-level access.

The Education Cloud is the cloud that provides Program Enrollment and Course Connections as standard offerings. The Education Cloud is a set of products and solutions designed specifically for educational institutions, such as schools, colleges, and universities. The Education Cloud includes the Education Data Architecture (EDA), which is a managed package that adds pre-built objects, fields, workflows, and reports to the standard Salesforce platform. Program Enrollment and Course Connections are two features of EDA that allow the user to manage the enrollment and connection of students to academic programs and courses. The Experience Cloud is a cloud that allows the creation of digital experiences, such as websites, portals, and mobile apps, for customers, partners, and employees. The Marketing Cloud is a cloud that provides tools for creating and managing personalized marketing campaigns across multiple channels, such as email, social media, web, and mobile.

The place where the user can find the Recycle Bin is the App Launcher. The App Launcher is a menu that allows users to access all the apps and items in their Salesforce org. The Recycle Bin is one of the items that can be found in the App Launcher. The user can search for “Recycle Bin” in the App Launcher and select it to view and restore their deleted records. The Recycle Bin is not located in Setup or Global Search.

The way that the associate can locate all the reports in a single location from the Report object is to click on All Folders and use the search bar. All Folders is a menu that shows all the report and dashboard folders that the associate has access to. The associate can search for the current month’s folder by entering its name or keyword in the search bar and then select it to view all the reports in that folder. Using the Global search bar or clicking on All Reports and using the search bar are not as efficient and accurate as using the All Folders menu, because they will return results from all the reports and folders, not just the current month’s folder.

Trailhead Academy is the resource that provides virtual and in-person learning that should help the in-house IT administration team of Get Cloudy Consulting accelerate their Salesforce knowledge. Trailhead Academy offers instructor-led training workshops, certification preparation courses, and custom learning programs for various Salesforce roles and products

Profiles and permission sets are used to configure object access for users. Profiles define the baseline access for users based on their license type and job function. Permission sets grant additional access to users based on their functional or departmental needs. Sharing sets and manual sharing are used to configure record access for users. Validation and assignment rules are used to enforce data quality and automate business processes.

 A gauge is a dashboard component type that shows a single value within a range of custom values. A gauge is useful for showing whether a metric, such as revenue or customer satisfaction, is within a desired range. For example, a gauge could show the current revenue as a needle pointing to a green, yellow, or red zone, indicating whether the revenue is above, below, or on target. A metric is a dashboard component type that shows a single value, such as the total number of accounts or the average deal size. A metric does not show a range of values. A chart is a dashboard component type that shows data in a graphical format, such as a pie chart, a bar chart, or a line chart. A chart is useful for showing the distribution or trend of data, but not a single value within a range.

Wildcards and operators are symbols that can be used to search for records when the name of the record is not known. For example, the asterisk (*) can be used to match any string of characters, and the AND operator can be used to combine multiple terms.

The first step in building a report that shows all active contacts grouped by account is to create a new report using the Contacts & Accounts report type. The report type determines the objects and fields that are available for the report. The Contacts & Accounts report type allows users to report on contacts and their related accounts, as well as account fields such as industry, annual revenue, and number of employees

The related list of cases can be added to the account page layout, which determines the fields, buttons, and related lists that users see when they view an account record.

The type of chart that the associate should add to the report to help visualize the changes in a value over a series of points in time is a line chart. A line chart shows how a numeric value changes over time or across categories, using a continuous line that connects the data points. A line chart is useful for showing trends, patterns, or fluctuations in the data.

A roll-up summary field is the best way to display the sum of all closed won opportunity amounts at the account level. A roll-up summary field is a type of field that calculates a value from a set of related records, such as the sum, average, min, or max. A roll-up summary field can only be created on the master object of a master-detail relationship, and it can only calculate values from the detail object. For example, a roll-up summary field called Total Revenue could be created on the Account object, and it could calculate the sum of the Amount field from the Opportunity object, where the Stage field equals Closed Won. A custom report type is a tool that allows the user to create a report based on the relationships between a primary object and its related objects. A custom report type does not display a value at the account level, but at the report level. The opportunity related list is a component that shows the related opportunities for a specific account record. The opportunity related list does not display the sum of all closed won opportunity amounts, but only the individual amounts for each opportunity.

QUESTIONNO: 91

A Salesforce associate is asked to review all the objects within their company's instance. They also need to identify which are custom objects.

Where should the associate go to see this information?

A. App Launcher

B. Object Manager

C. Global Search

Answer: B

The Object Manager is where the associate should go to see the information about all the objects within their company’s instance and identify which are custom objects. The Object Manager allows the user to view and manage the metadata of standard and custom objects in Salesforce, such as fields, page layouts, record types, buttons, and actions. The Object Manager can be accessed by clicking the Setup icon in the header, then clicking Object Manager. The custom objects are indicated by a blue icon with a white asterisk, while the standard objects are indicated by a gray icon with a white letter. The App Launcher is where the user can access all the apps and objects in Salesforce, such as Sales, Service, Marketing, and so on. The App Launcher does not show the information about the objects, such as fields, page layouts, or record types. The Global Search is where the user can search for records across multiple objects and fields using keywords or phrases. The Global Search does not show the information about the objects, but only the records that match the search criteria.

 The type of group that the associate should create to share records about a carpool program with users is a public group. A public group is a set of users that can be used to define sharing rules, queues, and other features that require a group of users. A public group can include individual users, other groups, roles, or territories. A public group can be used to share records with a specific group of users who are interested in the carpool program. A private group is a type of Chatter group that is not related to record sharing. A queue is a feature that allows users to manage leads, cases, and other objects as a team, but it is not suitable for sharing records about a carpool program.

A validation rule on the Opportunity object is the best way to enforce the requirement that the Reason Lost field is required when the stage is changed to Closed Lost. A validation rule can specify a condition and an error message to display when the condition is not met. For example, the condition could be AND(ISPICKVAL(StageName, "Closed Lost"), ISBLANK(Reason_Lost__c)) and the error message could be “Please enter a reason for losing the opportunity.” Making the field required on the page layout or universally required would not work, because the field should only be required when the stage is changed to Closed Lost, not for other stages.

The switches that the associate should toggle to only show the Record Count are Row Counts and Grand Total. Row Counts is a switch that shows the number of rows in the report, which is the same as the number of records. Grand Total is a switch that shows the sum, average, minimum, maximum, or other aggregate functions of a numeric field in the report. By toggling these two switches on and the other two switches off, the associate can see the Record Count and the Grand Total of the report, without seeing the individual records or the subtotals. Subtotals and Detail Rows are switches that show the breakdown and the details of the records in the report, which are not needed for the Record Count.

 The type of org that the associate should create from within Trailhead to quickly learn, practice, and develop Salesforce skills is a Playground. A Playground is a free, fully functional Salesforce org that you can use to test and explore the platform. You can create multiple Playgrounds from Trailhead and use them to complete hands-on challenges and projects1. A Developer Edition is a type of org that you can create from the Salesforce website, not from Trailhead. A Sandbox is a type of org that you can create from a production org as a copy of it for testing and development purposes

 The Salesforce solution that GCC should use for customer service where complaints can be logged through a web form and email is Service Cloud. Service Cloud is a product that helps companies deliver fast and personalized customer service across multiple channels, such as phone, email, web, chat, and social media. Service Cloud allows GCC to create cases from web forms and emails, assign them to agents, track their status, and resolve them efficiently

Deactivating the user is the best way to change the user’s access and free up the Salesforce license. Deactivating a user prevents the user from logging in to Salesforce and removes the user from any assigned permission sets, queues, and groups. However, the user’s record and related data are still preserved and can be reactivated if needed. Deleting the user would also free up the license, but it would also delete the user’s record and related data, which may not be desirable. Doing nothing would not change the user’s access or free up the license, and it would pose a security risk if the user still has the login credentials.

Creating a permission set that grants Edit access to leads and assigning it to the marketing managers is the best way to grant them the access they need, without affecting the other users on the marketing team profile.

The opportunities Kanban view is a visual summary of opportunities in a list view, where the associate can summarize, filter, and move opportunities along the pipeline by dragging and dropping them.

 The Contact object is where the associate should add the new employee record. The Contact object is used to store information about individuals who are associated with an account, such as name, phone, email, title, and role. The Contact object has a lookup relationship with the Account object, which allows the user to select an account that the contact is related to. The Accounts object is used to store information about companies or organizations that are customers, partners, or competitors. The Accounts object does not store information about individual employees. The Leads object is used to store information about potential customers who have shown interest in a product or service, but have not yet been qualified. The Leads object does not store information about existing employees.

 A sandbox is the type of environment that GCC should use to onboard new hires as well as develop, implement, and test new requirements. A sandbox is a copy of the production environment that allows the user to create and test changes without affecting the live data and users. A sandbox can have different types and sizes, depending on the purpose and scope of the changes. For example, a developer sandbox can be used to create and test code, a partial copy sandbox can be used to test large data sets, and a full sandbox can be used to perform performance testing and user acceptance testing. A production environment is the live environment that contains the real data and users. A production environment should not be used to onboard new hires or develop, implement, and test new requirements, because it could compromise the data quality and security, and disrupt the user experience. A Trailhead Playground is a type of environment that allows the user to learn and practice Salesforce skills using Trailhead. A Trailhead Playground is not connected to the production environment, and it does not have the same features and functionality as a sandbox.

 Selecting Fields to Display is what the associate should do to add the missing key columns to the custom Contact list view. Selecting Fields to Display is a feature that allows the user to choose which fields to show as columns in the list view, and in what order. The user can select up to 15 fields to display, and drag and drop the fields to rearrange the column order. Editing list filters is a feature that allows the user to apply one or more criteria to filter the records that are displayed in the list view. The user can select a field, an operator, and a value for each filter, and combine multiple filters with AND or OR logic. Editing sharing settings is a feature that allows the user to control the access and visibility of records for different users and groups. The user can define the organization-wide default, role hierarchy, sharing rules, and manual sharing for each object.

 The person that the associate would typically work with to get a new field added in their Salesforce org is a Salesforce Administrator. A Salesforce Administrator is someone who configures and manages the Salesforce platform for their organization. They can create and customize objects, fields, layouts, reports, dashboards, and other features to meet the specific needs of their users