Admin Interview Questions - v2
Admin Interview Questions - v2
1. What is CRM?
CRM, or Customer Relationship Management, is a way for businesses to manage
interactions with their customers. It uses software to store information about
customers, like their contact details and buying history, to improve how businesses
communicate with and serve them.
4. What benefits are there using salesforce with utilization of cloud computing.
Salesforce's utilization of cloud computing offers several benefits:
• Scalability: Easily adjust resources based on needs.
• Accessibility: Accessible from anywhere with an internet connection.
• Cost-effectiveness: Pay-as-you-go model, avoiding upfront infrastructure costs.
• Reliability and Performance: High reliability, performance, and security.
• Updates and Maintenance: Salesforce manages updates and maintenance.
• Integration Capabilities: Seamlessly integrate with other systems.
• Customization and Flexibility: Customize to fit specific business needs.
• Security: Cloud providers invest in robust security measures, often exceeding
what
individual organizations can achieve on their own.
5. What is Salesforce?
Salesforce is a company that provides software to help businesses manage their
relationships with customers. It offers tools for sales, marketing, and customer
service that are accessed over the internet, rather than being installed on individual
computers. This cloud-based approach makes it easier for businesses to organize
their customer information, communicate with clients, and track sales activities.
These factors contribute to Salesforce's reputation as the top CRM platform, trusted
by businesses worldwide to drive growth, improve customer relationships, and
achieve their business objectives.
• Cloud-Based Model:
Salesforce: It is a cloud-based CRM, meaning it operates entirely on the internet.
Users can access Salesforce from any device with an internet connection,
eliminating the need for on-premises servers and infrastructure.
Traditional CRM: Many traditional CRM solutions are on-premises software,
which requires organizations to invest in and maintain their own servers. This can
lead to higher upfront costs and increased complexity.
• AppExchange Marketplace:
Salesforce: Features the AppExchange marketplace, offering a vast ecosystem of
third-party applications and integrations that seamlessly extend the platform's
capabilities.
Traditional CRM: The availability of third-party integrations may be more limited,
and integrating additional functionalities could be more challenging.
• Mobile Accessibility:
Salesforce: Provides robust mobile accessibility, allowing users to access CRM
data and features on the go through dedicated mobile apps.
Traditional CRM: Mobile access in traditional CRM systems might be limited or
require additional configurations.
• User-Friendly Interface:
Salesforce: Known for its user-friendly interface and intuitive design, making it
easier for users to adapt to the platform without extensive training.
Traditional CRM: Some traditional CRM systems may have interfaces that are
perceived as less user-friendly, potentially requiring more training for users.
• Comprehensive Platform:
Salesforce: Offers a comprehensive platform that goes beyond traditional CRM,
including capabilities for marketing automation, analytics, application
development, and more.
Traditional CRM: Some traditional CRM solutions may focus primarily on core
CRM functionalities without the extensive range of additional features.
Starter Suite: Designed for small businesses with basic CRM needs.
Enterprise Edition: Provides more advanced features and customization options for
larger businesses.
Unlimited Edition: Offers maximum flexibility and customization capabilities for large
enterprises with complex requirements.
Developer Edition: Free edition primarily used by developers for building and testing
Salesforce applications.
These editions vary in terms of features, pricing, and scalability, allowing businesses
to choose the one that best fits their size and requirements.
Overall, Salesforce architecture provides a flexible, scalable, and secure platform for
building and deploying CRM solutions and business applications in the cloud.
10. Explain Sales process in salesforce, how you will be going to implement or track the
details or process for some of the product.
Product Details: Salesforce allows you to maintain detailed information about your
products or services in the product catalog. You can track product names,
descriptions, pricing, and other relevant details.
Target Market: Salesforce enables you to segment your target market using various
criteria, such as industry, geographic location, company size, or specific
demographics. You can create lists or reports to analyze and target specific segments
effectively.
Sales Team: Salesforce provides tools for managing your sales team, including user
profiles, roles, and permissions. You can assign territories, set up sales hierarchies,
and track individual performance using Salesforce's built-in reporting capabilities.
Leads: Leads are individuals or companies that have expressed interest in your
offerings. Salesforce allows you to capture lead information, qualify leads based on
predefined criteria, and convert them into accounts, contacts, and opportunities
when they become qualified prospects.
Quotes: Salesforce enables you to create and manage quotes for potential deals or
opportunities. You can generate quotes, track revisions, and send them to customers
for review and approval.
Orders: Once a deal is closed, Salesforce allows you to generate and manage orders
for products or services purchased by customers. You can track order status, manage
order fulfillment, and integrate with external systems for inventory management and
order processing.
Invoices: Salesforce enables you to generate and manage invoices for products or
services sold to customers. You can track invoice status, record payments, and
integrate with accounting systems for billing and invoicing processes.
Cases: Salesforce's service cloud provides tools for managing customer support cases
or tickets. You can track customer inquiries, assign cases to support agents, and
monitor case resolution times to ensure timely and effective customer service.
Solutions: Salesforce allows you to create and manage knowledge articles, FAQs, and
other resources to help customers find answers to their questions or resolve issues
on their own. You can organize solutions by category, publish them to a customer-
facing portal, and track their usage and effectiveness.
Reports & Dashboards: Salesforce offers robust reporting and dashboard capabilities
to track sales performance, analyze trends, and monitor key metrics. You can create
custom reports and dashboards to visualize data, share insights with stakeholders,
and make data-driven decisions to drive business growth.
Product Details: In Salesforce, you can create a product record for the "Premium
Executive Pen." This record would include details such as the product name,
description, price, and available quantity.
Target Market: You define your target market for the Premium Executive Pen as
professionals in industries like finance, law, and business, who appreciate high-
quality writing instruments.
Sales Team: Your sales team consists of sales representatives assigned to different
regions. Each sales representative has a Salesforce user profile with access to leads,
accounts, and opportunities related to the Premium Executive Pen.
Leads: One of the prospects, John Smith, fills out a contact form on your website to
request more information about the Premium Executive Pen. His information is
captured as a lead in Salesforce.
Orders: After John Smith approves the quote, you generate an order for the Premium
Executive Pen in Salesforce. The order confirms the purchase and initiates the order
fulfillment process.
Invoices: Once the order is fulfilled, you create an invoice for John Smith to bill him
for the purchase of the Premium Executive Pen. The invoice details the total amount
due and includes payment instructions.
Cases: After receiving the Premium Executive Pen, John Smith contacts your
customer support team with a question about the product's refill compatibility. A
support agent creates a case in Salesforce to address John's inquiry and provides him
with the necessary information.
Solutions: To help customers like John Smith find answers to common questions, you
create a knowledge article in Salesforce titled "Premium Executive Pen Refill
Compatibility." This article provides step-by-step instructions on how to identify and
purchase compatible pen refills.
Reports & Dashboards: You use Salesforce reports and dashboards to track sales
performance for the Premium Executive Pen, analyze trends in customer inquiries,
and monitor customer satisfaction levels based on support case resolution times.
By integrating the example product, the Premium Executive Pen, into the sales
process in Salesforce, you can effectively manage the end-to-end sales cycle, from
lead generation to customer support, while driving revenue growth for your
business.
In Salesforce, objects are database tables that store specific types of data. They are
the fundamental building blocks for organizing and managing information within the
platform. Salesforce provides two main types of objects: standard objects and
custom objects.
Standard Objects: These are predefined objects provided by Salesforce to support
common business functions. Examples of standard objects include:
Custom Objects: These are objects that you create to store data specific to your
organization's unique business needs. You can define custom fields, relationships,
and behaviors for custom objects. For example, you might create a custom object
called "Project" to track information about ongoing projects within your organization.
Overall, objects in Salesforce serve as containers for storing and organizing data,
providing a structured framework for managing business information across various
processes and use cases. They form the foundation of Salesforce's data model and
are essential for building custom applications, automating business processes, and
analyzing data to drive business insights.
12. What are fields in salesforce how they are used to store the data?
In Salesforce, fields are individual data elements that store specific pieces of
information within objects. Fields define the types of data that can be stored and
displayed for each record in an object.
Data Types: Salesforce offers a variety of data types for fields to accommodate
different types of information. Some common data types include:
Custom Fields: In addition to standard fields provided by Salesforce, you can create
custom fields to capture information specific to your organization's needs. Custom
fields can be added to both standard and custom objects and can be of any
supported data type.
Field-Level Security: Salesforce allows you to control access to fields at the object
level, profile level, and permission set level. You can define who can view, edit, or
delete specific fields based on user roles, profiles, or permissions.
Fields in Salesforce are essential for capturing, organizing, and analyzing data,
providing a structured framework for managing information across various business
processes and use cases. They play a crucial role in customizing Salesforce to meet
the specific needs of your organization and supporting your business objectives.
Master-Detail Relationship:
Example: Suppose you have two custom objects: "Account Plan" and "Opportunity
Plan." Each "Opportunity Plan" is associated with an "Account Plan" and represents a
detailed plan for a specific opportunity. Here, "Account Plan" would be the master
object, and "Opportunity Plan" would be the detail object. Deleting an "Account
Plan" record would also delete all related "Opportunity Plan" records.
Lookup Relationship:
Definition: A lookup relationship allows you to create a link between two objects,
where one object holds a reference (or "lookup") to another object. Unlike master-
detail relationships, lookup relationships do not enforce cascading behaviors or
sharing rules.
Example: In the standard Salesforce schema, the "Contact" object has a lookup
relationship with the "Account" object. Each contact record is associated with a
single account record, representing the company or organization the contact belongs
to. This relationship allows you to navigate from a contact record to its associated
account record.
Many-To-Many Relationships:
Self-Relationships:
Definition: Self relationships occur when an object has a relationship with itself. This
type of relationship is useful for modeling hierarchical or recursive structures within a
single object.
Example: In Salesforce, the "User" object has a standard self-relationship called the
"Manager" relationship. Each user record can have a manager, who is also a user in
the system. This self-relationship allows you to create hierarchies of users, where
each user reports to another user (their manager) within the organization.
External Lookup Relationship:
• Field Types: They can return different types of data, like text, numbers, dates, or
references to other records.
Example: Suppose you have a custom object called "Invoice" with fields for "Unit
Price" and "Quantity." You can create a formula field called "Total Amount" that
calculates the total amount for each invoice using the formula: Unit Price * Quantity.
• Read-Only: Formula fields are read-only and automatically update when source
data changes.
• Use Cases:
Field Types: They are limited to specific types of calculations, depending on the type
of relationship and the field being summarized.
Example: Suppose you have a parent object called "Account" and a child object called
"Opportunity." You can create a roll-up summary field on the "Account" object to
calculate the total amount of all related opportunities.
Use Cases: They are commonly used to aggregate data from related records, such as
summing up opportunity amounts, counting related tasks, or finding the maximum
value of a custom field.
Purpose: Validation rules ensure that data entered in Salesforce meets your
organization's requirements and adheres to predefined business rules.
Criteria: You define validation rules using a formula expression that evaluates to true
or false. The formula can reference fields on the record being saved, other related
records, or constants.
Always runs whenever record is inserted or updated.
Conditions: Validation rules can be based on various conditions, such as field values,
record types, user profiles, or related records.
Error Messages: When a user attempts to save a record that violates a validation
rule, Salesforce displays an error message explaining the issue and preventing the
record from being saved until the data is corrected.
Examples: Common use cases for validation rules include enforcing field format (e.g.,
ensuring phone numbers are in a specific format), enforcing data ranges (e.g.,
preventing future dates in a birthdate field), or ensuring data consistency (e.g.,
requiring a contact to be associated with an account).
Deployment: Validation rules are deployed declaratively through the Salesforce setup
menu and are automatically enforced on all applicable records.
User Interface
Page Layouts:
Definition: Page layouts determine the layout and organization of fields, related lists,
button , quick action buttons, sections, etc. on a record detail page in Salesforce.
Customization: Administrators can customize page layouts for each object to control
which fields are displayed, their order, and whether they are required or read-only.
User-Specific: Page layouts can be assigned to different user profiles, ensuring that
users see relevant information based on their roles and responsibilities.
Use Cases: Page layouts are commonly used to streamline data entry, improve user
productivity, and tailor the user experience for different user groups or business
processes.
Record Types:
Definition: Record types allow you to define different sets of picklist values, page
layouts, and business processes for records of the same object.
Customization: Administrators can create multiple record types for an object and
customize each record type with its own page layout, picklist values, and field
requirements.
Visibility Criteria: Record types can be assigned based on various criteria, such as
profile, user role, record owner, or even criteria-based rules.
Use Cases: Record types are commonly used to support different business scenarios,
such as sales stages, support processes, case classifications, or application forms.
They allow you to tailor the user experience and data entry requirements based on
specific use cases or requirements.
In summary, page layouts control the layout and organization of fields on record
detail pages, while record types allow you to define different sets of picklist values,
page layouts, and business processes for records of the same object. Together, they
enable administrators to customize the user interface and data visibility in Salesforce
to meet the needs of different users, roles, and business processes.
• Dynamic forms allow you to control the visibility of fields and sections on record
detail pages using the Lightning App Builder.
• With dynamic forms, you can create multiple variations of a single page layout
and assign visibility rules to determine which fields and sections are displayed to
users based on their profile, record type, or other criteria.
• Dynamic forms offer more granular control over the visibility of individual fields
and sections compared to traditional page layouts.
• Dynamic forms support personalized user experiences by displaying relevant
information and actions based on user context, such as their role, permissions, or
preferences.
• They help optimize screen real estate by showing only the most relevant fields
and sections to users, improving usability and reducing clutter on record detail
pages.
• Home Page:
The Home page is the landing page for users when they first log in to Salesforce.
It provides a customizable dashboard-like layout with components such as charts,
lists, and recent records.
Users can personalize their Home page by adding, removing, or rearranging
components to suit their needs.
• Record Page:
Record pages are used to view, edit, and interact with individual records in
Salesforce.
They provide a dynamic layout that displays relevant information and related
records using components such as highlights panel, related lists, and related
record cards.
Record pages can be customized using the Lightning App Builder to tailor the
layout and components based on user roles, record types, and business
requirements.
• App Page:
App pages are used to organize and present collections of related records or
functionality within a specific app or module.
They can include custom components, dashboards, reports, and other tools to
streamline workflows and provide a unified user experience.
App pages are often used to create custom navigation menus, dashboards, or
landing pages for specific user groups or business processes.
Filtering Data: List views enable users to filter records based on various criteria, such
as record owner, record type, status, or custom fields. This helps users focus on
relevant subsets of data.
Sorting Data: Users can sort records within a list view based on specific fields, such as
creation date, last modified date, or custom fields. This allows for better organization
and prioritization of records.
Customization: List views can be customized to display specific fields, columns, and
field widths, providing users with relevant information at a glance. Users can also
customize their own list views for their personal needs.
Mass Actions: List views support mass actions, allowing users to perform actions on
multiple records simultaneously, such as mass updating field values, sending email
templates, or assigning records to users.
Sharing and Visibility: List views can be shared with other users or groups, enabling
collaboration and visibility across the organization. Administrators can also control
visibility and access to list views based on user roles and permissions.
Reporting: List views serve as the basis for reports and dashboards in Salesforce.
Users can create reports and dashboards using the same criteria and filters defined in
list views to visualize data and gain insights.
Overall, list views are essential tools in Salesforce for organizing, filtering, and
managing records effectively. They provide users with customizable views of data
tailored to their specific needs and workflows, improving productivity and decision-
making across the organization.
Tabular Reports: These reports display data in a simple table format. They are useful
for viewing a list of records with their associated fields.
Summary Reports: Summary reports allow you to group data by a particular field,
such as by owner or by stage, and display subtotals and totals. They provide a higher-
level view of your data compared to tabular reports.
Matrix Reports: Matrix reports allow you to group data by both rows and columns,
providing a more comprehensive view of your data. They are useful for analyzing
data across multiple dimensions.
Joined Reports: Joined reports allow you to combine multiple reports into a single
report, each with its own set of data and columns. This is useful for comparing data
from different sources or for creating complex reports.
24. What are dashboards in salesforce?
In Salesforce, dashboards are a visual representation of your organization's data,
providing a snapshot of key metrics and performance indicators. They allow users to
quickly and easily analyze data, identify trends, and make informed decisions.
Dashboards typically consist of charts, graphs, tables, and other components that
display real-time or near-real-time data from Salesforce records.
Customization: Users can create custom dashboards tailored to their specific needs
and preferences. They can choose which metrics to display, how to visualize the data,
and the layout of the dashboard components.
Components: Dashboards can contain various components, such as bar charts, line
graphs, pie charts, tables, metrics, gauges, and more. Each component represents a
different aspect of the data and can be configured to display specific information.
Sharing and Collaboration: Users can share dashboards with others in their
organization, making it easy to collaborate and align on key metrics and goals.
Dashboards can be shared with specific users, groups, or roles, ensuring that each
user sees the most relevant information.
Mobile Access: Salesforce offers mobile capabilities, allowing users to access and
view dashboards from their mobile devices. This enables users to stay informed and
make decisions on the go.
29. Can we create custom formula fields also in reports to achieve the requirements?
Yes, Users can create custom formula fields and use them as filters to perform
calculations or manipulations on data before applying the filter conditions.
Salesforce Unlimited Edition: Unlimited Edition allows you to add up to 200 reports
to a single dashboard.
32. Explain data storage architecture that enables businesses to organize, manage, and
secure their data effectively, supporting various business processes and use cases.
In Salesforce, data is stored in a structured format within objects and records. Here's
how data storage works in Salesforce:
Objects: Objects are the fundamental building blocks for storing data in Salesforce.
Standard objects, such as Accounts, Contacts, Opportunities, and Cases, are provided
by Salesforce out of the box. Additionally, you can create custom objects to store
data specific to your business needs.
Fields: Each object in Salesforce contains fields that define the types of data that can
be stored. Standard fields, like Name, Email, Phone, and Address, are provided for
standard objects. For custom objects, you can create custom fields of various data
types, such as Text, Number, Date, Picklist, and Lookup.
Records: Records are individual instances of objects that store specific data. For
example, an Account record may contain information about a customer company,
such as its name, industry, and address. Similarly, a Contact record may contain
details about an individual associated with the account, such as their name, email,
and phone number.
Data Import: Salesforce provides tools for importing data into the platform, allowing
you to migrate existing data from spreadsheets, databases, or other systems. You can
use tools like the Salesforce Data Loader, Data Import Wizard, or third-party
integration tools to import data efficiently.
Data Security: Salesforce offers robust data security features to control access to
data and ensure data privacy and compliance. You can define security settings, such
as object-level security, field-level security, record-level security, and sharing rules, to
restrict access to sensitive data based on user roles, profiles, and permissions.
Data Management: Salesforce provides tools for managing and maintaining data
quality, such as data cleansing, deduplication, and data validation rules. You can
enforce data integrity rules to ensure that data entered into Salesforce is accurate,
consistent, and complete.
Backup and Recovery: Salesforce automatically backs up your data and provides
tools for data recovery in case of data loss or corruption. You can use features like
data export, data recovery service, and Salesforce's data retention policies to protect
your data and ensure business continuity.
Overall, Salesforce offers a robust and flexible data storage architecture that enables
businesses to organize, manage, and secure their data effectively, supporting various
business processes and use cases.
Use Cases:
Record Sharing: Public groups can be used to share records with a group of users
collectively, making it easier to manage sharing settings.
Collaboration: Public groups are often used in collaboration scenarios, such as
sending emails to a group or inviting a group to a Chatter group.
Access Control: Public groups can be assigned to profiles, permission sets, or
other groups to control access to various features and resources.
Use Cases:
Case Assignment: Cases can be placed in queues to distribute work among a group
of support agents. Agents can take ownership of cases from the queue. Lead or
Opportunity Distribution: In sales scenarios, leads or opportunities can be placed in
queues for distribution among sales representatives.
Service Requests: For managing various service requests, such as IT support t ickets
or customer inquiries.
35. How public groups and queues are different from each other?
1. Functionality:
Public Groups: Primarily used for collaboration, record sharing, and access
control. Queues: Used for managing and distributing records that require action,
often in a shared or collaborative environment.
2. Membership:
Public Groups: Comprise users, other groups, roles, or territories.
Queues: Comprise users or groups to whom records are assigned for processing.
3. Ownership:
Public Groups: Do not own records but can be used for sharing and access
control. Queues: Facilitate shared ownership of records among queue members.
4. Use Cases:
Public Groups: Collaboration, sharing settings, access control.
Queues: Case assignment, workload distribution, managing shared work items.
In summary, while both public groups and queues serve to streamline collaboration
and work distribution in Salesforce, they have distinct purposes. Public groups are
more focused on collaboration and access control, whereas queues are specifically
designed for managing and distributing records that require action.
Record Feed: When feed tracking is enabled, the changes made to tracked fields are
displayed in the record's feed. The feed provides a chronological view of all activities
and updates related to the record, including field changes, comments, file
attachments, and system-generated events.
Tracking Field Changes: Field History Tracking captures changes made to selected
fields on records. These changes include updates to the field values, such as
modifications to text, numbers, dates, picklist selections, and more.
Reporting and Analysis: Organizations can leverage field history data for reporting
and analysis purposes. They can generate reports or dashboards to analyze trends,
track user activity, and monitor changes to critical data fields over time.
38. What are key differences between feed tracking and field history tracking?
The key difference between Field History Tracking and Feed Tracking in Salesforce lies
in the scope of the changes tracked and the presentation of those changes:
Field History Tracking: It maintains a historical log of changes made to tracked fields,
storing old and new field values along with additional metadata. This log is typically
accessed through the Field History Tracking related list on records.
Feed Tracking: Changes tracked through feed tracking are displayed in the record's
feed, providing a chronological view of all activities and updates related to the
record, including field changes, comments, file attachments, etc.
In summary, while both Field History Tracking and Feed Tracking capture changes
made to record data, Field History Tracking focuses specifically on changes to field
values and maintains a detailed historical log, whereas Feed Tracking captures a
broader range of activities and updates related to records and presents them in a
feed format.
Apex Code
Field History Tracking: You can quickly get the old value and new value of the fields
on which you have enabled the history tracking using SOQL.
Standard Object: SELECT OldValue, NewValue, Field FROM AccountHistory
Custom Object: SELECT OldValue, NewValue, Field FROM customObject__History
39. For how many fields tracking can be enabled per objects?
Up to 20 fields.
40. Can we also display feed activity for related objects also?
Yes, checkbox is available to enable same for all related objects.
Salesforce allows users to manage their activities and tasks through the "Activities"
tab or related lists on relevant records (such as leads, contacts, and opportunities).
Users can create tasks and events, log calls, schedule appointments, and track
various interactions related to their work.
45. What can be the possibility that on object activity component is not available, how
we can enable and add this component.
Go to object details and check for checkbox Allow Activities.
If this is disabled then activity component will not be available on object once this is
enabled you can now go to the edit page and add the activity component on the
detail page.
For example:
If "Electronics" is selected for the category, then the subcategory options might be
"Smartphones," "Laptops," "Cameras," etc.
If "Clothing" is selected for the category, then the subcategory options might be
"Shirts," "Pants," "Dresses," etc.
49. What will happen if we convert Mult picklist to picklist field in salesforce?
If you convert a multi-select picklist field to a picklist field in Salesforce, the system
will remove all the values that were previously selected in the multi-select picklist.
Essentially, you'll lose the data stored in that field for existing records because a
picklist field can only store a single value, whereas a multi-select picklist can store
multiple values.
54. With whom user can share the list views created by him.
In Salesforce, users can share the list views they create with specific individuals,
groups, roles, or roles and subordinates.
However, in the case of the student object, checkboxes are not available, and we
cannot edit fields directly from the list view.
The reason behind this difference lies in the implementation of record types. When
record types are created on an object and users are given the choice to select record
types, checkboxes and field editing functionality are typically removed.
These options are only available when no record types are defined on the object.
61. How do matching and duplicate rules contribute to data quality in Salesforce?
Matching and duplicate rules help maintain data quality by identifying and
preventing the creation of duplicate records. By enforcing these rules, organizations
can reduce data redundancy, improve data accuracy, and enhance user productivity.
62. What are these two options in duplicate rules
Enforce Sharing Rules: In the context of record level security, such as sharing rules,
the system will respect the user's access permissions. When checking for duplicates,
it will only consider the records that the user has access to based on their sharing
rules and permissions. This means that duplicate checks will only be performed
within the subset of records that the user is permitted to view, rather than across all
records in the organization.
Bypass Sharing Rules: In this case, when checking for duplicates, the system will
disregard sharing rules and individual user permissions. Duplicate checks will be
performed across all records in the organization, regardless of whether a user has
access to a particular record or not.
63. What is the difference between exact match and fuzzy matching in matching rules?
Exact Match: Exact matching requires the values in the specified fields to be identical
to consider two records as potential duplicates. This means that each character and
space in the compared fields must match exactly for the records to be flagged as
duplicates. Exact matching is more stringent and is suitable for scenarios where
precise matches are necessary, such as when matching on unique identifiers like
email addresses or account numbers.
Fuzzy Matching: Fuzzy matching, on the other hand, allows for variations and
similarities in the values of the compared fields. It considers factors such as
typographical errors, abbreviations, misspellings, and slight variations in formatting.
Fuzzy matching uses algorithms to calculate a similarity score between the values in
the fields, and if the score exceeds a specified threshold, the records are considered
potential duplicates. Fuzzy matching is more flexible and can be useful when dealing
with data that may have inconsistencies or variations, such as names or addresses.
Example
Let's say you have a Salesforce org with a Contact object, and you want to identify
potential duplicate contacts based on their last names. You have two contacts with
the following last names:
Contact A: "Smith"
Contact B: "Smit"
Using fuzzy matching, the system would compare the last names of these contacts
and calculate a similarity score based on factors such as the number of characters in
common, the position of characters, and the likelihood of typographical errors.
In this example, even though the last names "Smith" and "Smit" are not identical,
they are very similar, differing by only one character. Fuzzy matching algorithms
might assign a high similarity score to these two last names, indicating that they are
likely to be duplicates.
66. Example differentiating between email alerts and email template in salesforce?
Scenario:
Suppose you're managing a sales team, and you want to notify the assigned sales
representative whenever a new high-priority lead is assigned to them.
Email Alert: You create an email alert workflow rule/PB/Salesforce Flow that triggers
whenever a new lead is created and meets the criteria of being high-priority.
Recipient: The email alert is configured to send an email notification to the assigned
sales representative when the lead meets the criteria.
Dynamic Content: The email alert includes dynamic content such as the lead's name,
contact information, and any other relevant details pulled from the lead record.
Automation: This email alert is automated and requires no manual intervention.
Whenever a high-priority lead is created and assigned, the system automatically
sends an email notification to the respective sales representative.
Summary:
Approval Processes:
• In the approval process setup, select the step where you want to assign approval
requests to a queue.
• Choose Automatically assign to approver(s).
• Select Queue and choose the appropriate queue.
• Ensure the queue members are set up correctly so they can act on the approval
requests.
73. Can you recall an approval request once it's been submitted?
Yes, users can recall an approval request if the approval process is configured to allow
it. To enable this:
Create a flow that triggers based on specified conditions (e.g., a record update or
creation).
Use the Submit for Approval action within the flow to submit the record to the
predefined approval process.
Configure the flow to handle the outcomes of the approval process, such as updating
record statuses or sending notifications.
Salesforce Flows
79. What is Salesforce Flow, and how does it differ from Process Builder and Workflow
Rules?
Salesforce Flow is a powerful automation tool that allows users to build custom
processes in Salesforce, guiding users through a series of screens and performing
complex logic and actions.
Unlike Process Builder and Workflow Rules, which are primarily used for automating
simple processes based on record changes, Flow provides more flexibility and can
handle more complex scenarios involving user interaction, decision-making, and
looping.
80. Explain the different types of flows available in Salesforce and their use cases.
Salesforce offers three main types of flows: Autolaunched flows, screen flows, and
scheduled flows.
Autolaunched flows are triggered by record changes or platform events and run in
the background without user interaction.
Screen flows involve user interaction, guiding users through a series of screens to
collect information or perform actions.
Scheduled flows run on a predefined schedule to perform actions such as data
cleanup or sending email alerts.
82. What are the advantages of using Salesforce Flow over other automation tools like
Workflow Rules or Process Builder?
Salesforce Flow offers greater flexibility and customization compared to Workflow
Rules and Process Builder. It can handle more complex business processes involving
user interaction, decision-making, and looping. Flow also provides better error
handling and debugging capabilities.
83. How do you debug and troubleshoot Flow errors?
Flow errors can be debugged using tools like debug logs, error emails, and the Flow
debugger. By analyzing debug logs and error messages, you can identify the source of
the problem and make necessary adjustments to the Flow logic or configuration.
84. Explain the concept of record-triggered flows and how they are different from
screen flows.
Record-triggered flows are triggered by record changes, such as when a record is
created or updated. They run in the background without user interaction and are
used for automating processes based on record data. Screen flows, on the other
hand, involve user interaction and guide users through a series of screens to collect
information or perform actions.
86. Describe how you would create a Flow to automate a business process in
Salesforce.
To automate a business process with Flow, I would start by identifying the specific
requirements and steps involved in the process. Then, I would use Flow Builder to
create the necessary elements, such as screens, decisions, and actions, to implement
the logic of the process. Finally, I would test the Flow thoroughly to ensure it meets
the requirements and functions correctly.
87. What are the limitations of Salesforce Flow, and how would you work around
them?
Some limitations of Salesforce Flow include complexity in handling large data
volumes, limitations in supported functionality compared to Apex code, and
limitations in integration capabilities. To work around these limitations, you can
optimize your Flow design, use Apex code where necessary, and leverage external
integrations through connectors or Apex callouts.
90. Can you integrate external systems or services with Salesforce Flow? If so, how?
Yes, Salesforce Flow can integrate with external systems or services using connectors,
Apex code, or external services. Connectors provide pre-built integration with
popular services such as Salesforce Connect, REST API, and SOAP API. Apex code can
be used to create custom integrations using callouts to external APIs. External
services allow you to invoke external processes or services from within a Flow.
91. What are the best practices for designing and optimizing Flows in Salesforce?
Some best practices for designing and optimizing Flows include keeping Flows simple
and modular, minimizing the use of resources and elements, optimizing queries and
data retrieval, using bulk processing techniques for large data volumes, and
thoroughly testing Flows in a sandbox environment before deployment.
93. Describe a scenario where you had to use a Flow to solve a specific business
problem.
In a previous project, we needed to automate the process of capturing customer
feedback after a service interaction. I created a Flow that triggered when a service
case was closed. The Flow guided the service agent through a series of screens to
collect feedback from the customer and update relevant records in Salesforce. This
streamlined the feedback collection process and provided valuable insights for
improving service quality.
94. What are Flow interviews, and how do they enhance user interaction in Salesforce?
Flow interviews allow users to interact with Flows through a custom user interface,
such as a Lightning component or Visualforce page. This enhances user interaction by
providing a more intuitive and guided experience, allowing users to input data, make
selections, and perform actions within the context of the Flow.
95. Explain the concept of subflows and when you would use them.
Subflows are reusable Flow components that can be called from other Flows or
processes. They encapsulate a set of actions or logic and can accept input variables
and return output values. Subflows are useful for modularizing Flow logic, promoting
reusability, and simplifying complex processes by breaking them down into smaller,
manageable components.
97. What considerations should you keep in mind when designing Flows for mobile
users?
When designing Flows for mobile users, it's important to consider factors such as
screen size, touch interactions, and network connectivity. Use responsive design
principles to ensure that Flows are optimized for mobile devices and provide a
seamless user experience. Minimize the use of large or complex screens, and
optimize data retrieval and processing to minimize network usage and improve
performance on mobile devices.
98. Describe the differences between Flow Builder and Cloud Flow Designer.
Flow Builder is the successor to Cloud Flow Designer and provides an enhanced user
interface and additional features for building Flows. Flow Builder offers a more
intuitive and streamlined design experience, with features such as a simplified
palette, improved layout options, and enhanced debugging capabilities. Additionally,
Flow Builder is tightly integrated with Lightning Experience and provides better
support for mobile devices compared to Cloud Flow Designer.
99. What is the Salesforce security model, and what are its key components?
The Salesforce security model refers to the framework of features and settings that
control access to data and functionality within the Salesforce platform. Key
components include profiles, permission sets, roles, role hierarchy, sharing rules,
organization-wide defaults (OWD), field-level security (FLS).
100. Can you explain the difference between profiles and permission sets in
Salesforce?
Profiles and permission sets are both used to control access to objects, fields, and
records in Salesforce, but they serve different purposes.
Profiles are assigned to users and define their baseline permissions, such as object-
level and field-level access, record types, and page layouts.
Permission sets are additional sets of permissions that can be assigned to users to
extend their access beyond what is defined in their profile, without changing the
profile itself.
101. How do you control access to records in Salesforce? What are the different
levels of record access?
Access to records in Salesforce is controlled through a combination of settings,
including organization-wide defaults (OWD), role hierarchy, sharing rules, manual
sharing, and criteria-based sharing.
The different levels of record access are private, public read-only, public read/write,
and controlled by parent.
102. What is the role hierarchy, and how does it impact record access in
Salesforce?
The role hierarchy is a representation of the reporting structure within an
organization. It determines the level of access users have to records owned by users
below them in the hierarchy. Users at higher levels in the hierarchy have access to
records owned by users at lower levels, based on their position in the hierarchy.
105. Can you describe the purpose of sharing rules and how they are used to
extend record access in Salesforce?
Sharing rules in Salesforce are used to extend record access to users who do not have
access through the role hierarchy or organization-wide defaults. They allow
administrators to define criteria-based or owner-based rules to grant additional
access to specific records.
106. What are the different types of sharing rules available in Salesforce, and
when would you use each type?
There are three types of sharing rules in Salesforce: criteria-based sharing rules,
owner-based sharing rules, and manual sharing. Criteria-based sharing rules use
criteria to determine which records are shared, owner-based sharing rules share
records owned by certain users, and manual sharing allows users to share individual
records with others.
107. How do you implement object-level security in Salesforce using profiles and
permission sets?
Object-level security in Salesforce is implemented using profiles and permission sets.
Profiles control access to objects, fields, and related records, while permission sets
extend permissions beyond what is defined in profiles. By assigning profiles and
permission sets, administrators can control who can view, create, edit, and delete
records of a particular object.
109. How do you enforce data security in Salesforce when integrating with
external systems?
Data security when integrating with external systems in Salesforce can be enforced
by using secure APIs, authentication mechanisms such as OAuth or SAML, and data
encryption techniques. Additionally, administrators can control access to external
data sources using profiles, permission sets, and IP whitelisting.
110. What is the difference between CRUD and FLS in Salesforce security?
CRUD (Create, Read, Update, Delete) and FLS (Field-Level Security) are both aspects
of data security in Salesforce. CRUD permissions control the ability to perform basic
operations on objects (such as creating, reading, updating, and deleting records),
while FLS permissions control access to individual fields on objects.
111. How do you audit and monitor user access and changes to data in
Salesforce?
Audit trails in Salesforce allow administrators to monitor user activity and changes to
data. They provide a record of login attempts, successful logins, and changes made to
records by users. Audit trails help organizations track user behaviour and maintain
data integrity.
112. Can you explain the concept of Field Dependency and its role in security?
Field Dependency is a feature in Salesforce that allows administrators to specify
dependencies between fields on an object. This can be used to control visibility and
editability of fields based on the value of another field. Field Dependency can play a
role in security by ensuring that sensitive fields are only visible when specific
conditions are met.
113. How do you ensure secure data transmission and storage in Salesforce?
Secure data transmission and storage in Salesforce are achieved through various
mechanisms, including encryption, secure sockets layer (SSL) encryption for data in
transit, and field-level encryption for sensitive data at rest. Salesforce also complies
with industry-standard security certifications and undergoes regular security audits
to ensure data protection.
• Ensure that role hierarchy and sharing rules are regularly reviewed and adjusted
as organizational structure or business requirements change.
• Use manual sharing to explicitly grant access to specific users or roles on an ad-
hoc basis.
116. Certain sensitive fields, such as Social Security numbers and financial
information, should only be accessible to designated users within the finance
department. How would you configure security to restrict access to these fields,
ensuring that only authorized personnel can view or modify sensitive information?
• Define profiles with appropriate permissions, including field-level security
settings to restrict access to sensitive fields.
• Assign users to profiles based on their roles and responsibilities within the
organization.
• Now using the permission sets, you can authorize the sensitive fields data to user.
117. You company has multiple business units, and you need to ensure that each
unit can only access their own data, with certain users needing access to all data
across all units. How do you set this up?
• First setup OWD as private so that each unit can only access their own data.
• Set up role hierarchies based on business units and use sharing rules or add
specific users to a public group with wider access as needed.
118. Two users, A and B are assigned with same profile and under same role
hierarchy. How can you restrict the records of A from B and vice a versa.
• Using OWD
• Ensure that OWD is private and make sure that users should not have “view All”
& “modify All” permissions on their profile or permission sets that could override
the record level security.
119. You have a large sales team and want to ensure that sales managers can
only see the data if the sales representatives that report to them. How would you
accomplish this in salesforce?
• Implement the role hierarchies where sales representatives are positioned under
their respective sales managers in the hierarchy to naturally control record
visibility base on roles.
120. Your company has recently acquired another company that uses different
salesforce org. How do you ensure that the data is shared between two orgs while
maintaining appropriate security levels?
• Utilize salesforce to salesforce connect to integrate the two orgs, ensuring base
level permissions are defined for data visibility and access.
121. You have a team of sales representatives who need access to certain
customer data but you want to restrict their access to sensitive information such as
credit card numbers. How do you achieve this?
Use field level security to hide the sensitive fields like account number, password
for those user’s profile and permission sets.
122. What are the condition on which we can see this manual sharing button on
page.
OWD needs to be restrictive then only we can see manual sharing button on
page.
Either private or Read-only then only manual sharing button will be available, for
Public Read/Write manual sharing button will not be available on page.
123. What are the different ways to create the records if object tab is not visible
or available.
124. External auditors need temporary read-only access to the financial records
in the Financials object for an audit. How would you set this up?
• Create a profile or permission set with 'Read-Only' access to the Financials object.
• Use sharing rules to grant read-only access to auditors during the audit period.
• Set an expiration date on the sharing rules or permission set assignments to
ensure access is revoked after the audit is complete.
125. A specific project in the Projects object is highly confidential and should
only be accessible to the project team members. How would you set up the
security for this?
• Set the organization-wide default for the Projects object to 'Private'.
• Manually share the project record with the specific team members.
• Create a public group for the project team and share the project record with this
group.
• Ensure only project team members' profiles have 'Read' and 'Edit' permissions on
the Projects object.
126. A specific project in the Projects object is highly confidential and should
only be accessible to the project team members. How would you set up the
security for this?
• Set the organization-wide default for the Projects object to 'Private'.
• Manually share the project record with the specific team members.
• Create a public group for the project team and share the project record with this
group.
• Ensure only project team members' profiles have 'Read' and 'Edit' permissions on
the Projects object.
127. You need to ensure that sales representatives can only see and edit
opportunities that belong to their own region, while sales managers can see all
opportunities. How would you configure this?
• Set up a role hierarchy where sales representatives report to sales managers.
• Set the organization-wide default for opportunities to 'Private'.
• Create sharing rules to share opportunities with users in the same region.
• Ensure sales managers have the necessary permissions to view and edit all
opportunities.
128. You need to restrict access to salary information in the Employee object so
that only HR personnel can view and edit it. How would you implement this?
• Create a custom profile for HR personnel.
• Assign 'Read' and 'Edit' permissions on the Salary field in the Employee object to
the HR profile.
• Ensure the Salary field is set to 'Visible' and 'Read-Only' for other profiles.
• Define sharing rules if necessary to share records with HR personnel based on
criteria.
• Account Data Skew: This occurs when a single user owns more than 10,000
account records. Because of the way Salesforce handles sharing rules and record
ownership, having one user own a disproportionately large number of records
can lead to performance degradation and sharing recalculation delays.
• Lookup Skew: Lookup skew happens when a single parent record (such as an
Account or Case) has more than 10,000 child records related to it. This can lead
to locking issues and performance degradation when multiple users attempt to
access or modify related child records.
• Ownership Skew: Ownership skew arises when a single user owns more than
10,000 records of a specific object. Similar to account data skew, this can lead to
performance issues and sharing recalculation delays due to the large number of
records owned by a single user.
130. Two objects are available, and there are a few records present in both
objects. Now, I want to relate both with a master-detail relationship. Will
Salesforce allow me, or will it give some error? If so, how can I achieve this
requirement?
Salesforce will not allow you to create a master-detail relationship directly if
already there are records in either of the objects. This is because master-detail
relationships in Salesforce require a parent-child hierarchy, where the child
records are dependent on the existence of parent records. If records already exist
in either object, Salesforce cannot establish this hierarchy.
To achieve this requirement, we will first relate both the objects with lookup
relationship now will fill lookup value in each record, once done now we will
convert this lookup relationship to master detail relationship.
131. Master-detail relationship exists between two objects A and B, now the
requirement is that each parent should only have one child related to it. If a user
tries to create more than one child, then they should receive an error indicating
that they cannot create more than one child.
We will achieve this requirement with the combination of rollup summary and
validation rule.
As master detail exist between two objects means we can now take help of rollup
summaries (as can only be created if relationship is master detail).
We will create roll up summary field on master object which give me count of
child records.
Now we will create one validation rule on child object where we will check the
value in the count rollup summary field. Will add the formula if count >1 then we
will throw a validation that already one child exists you cannot create more.
132. Object A contains a picklist field with five different values. The requirement
is that User A should only be able to see the first three values of this picklist out of
the five, while User B should only be able to see the remaining two values. How
can we achieve this?
We will achieve this using the record types.
When we create the Record Types at the time of creation it gives us the option to
edit the picklist fields where you can select the values which you want to make
visible for this record type.
Now based on the user we will assign him record Type permission on profile &
permission sets.
133. What is the difference between deactivate and freeze a user in salesforce?
Deactivate User: When you deactivate a user in Salesforce, you are essentially
disabling their user account. Deactivating a user prevents them from logging into
Salesforce and accessing any records or features within the system. This action is
typically used when an employee leaves the company or no longer requires
access to Salesforce.
135. Can a user have more than one role assigned to him?
No, a user can be assigned with single role at a time. Multiple roles cannot be
assigned to a single user at same time.
136. I have 2 users in same role, user A can see the records of user B but user B
cannot see the records of user A. What can be the possible reasons.
Sharing Rules: There might be sharing rules in place that explicitly grant access to
User A for certain records owned by User B. However, no reciprocal sharing rules
might exist for User B to access records owned by User A.
Manual Sharing: User A might have manually shared their records with User B, or
with a group that User B is a member of. However, User B may not have
reciprocated this sharing.
Criteria-Based Sharing: There could be criteria-based sharing rules or criteria-
based sharing settings on objects that grant access to User A based on specific
criteria that are not met for User B's records.
Role Hierarchy: Although both users are in the same role, the role hierarchy
could still be affecting access. Ensure that the role hierarchy is configured
correctly and that User B is not below User A in the hierarchy.
137. How you will be going to make sure that validation rule either only fires at
the time of insertion of records or at the time of updating of records.
Using ISNEW() and ISCHNAGED(), both functions are available in validation
formula.
ISNEW() ensure that to show and error whenever record is new or created.
ISCHANGED() ensure that the existing data or record values are changed so only
fire at the time of updating.
139. There is record type for which user U1 is not having the access. Will the user
still be able to see the records which are created by the same user U1 and are
assigned to record type to which user is not having access?
In Salesforce, if a user does not have access to a particular record type, they will
not be able to view or edit records assigned to that record type, even if those
records were created by users who do have access to that record type.
140. What happens to the related opportunities and contact records when
account is deleted?
Related contacts and opportunities for that account also get deleted with
account.
141. What happens to the related opportunities and contact records when the
account record is undeleted.
Related Contact and opportunities also get undeleted.
142. Who can see the manual sharing button on record page?
System Admin
Record Owner
User Up in Role Hierarchy.
User with ModifyAll and ViewAll access for that object.
150. If OWD is set as public read/write, can we still create the sharing rules?
No if already OWD is set as public Read/Write this means you already given full
access to users at the base level itself.
Now there is no use of sharing rules and manual sharing.
152. What is junction object in salesforce instead of master detail can we create
junction object using lookup relationship?
Imagine you have two objects in Salesforce: "Student" and "Course." Each
student can enrol in multiple courses, and each course can have multiple
students enrolled.
To represent this relationship, you would create a junction object, let's call it
"Enrolment."
The "Enrolment" object would have two master-detail relationships:
This allows you to manage the many-to-many relationship between students and
courses efficiently. You could also include additional information in the
"Enrolment" object, like enrolment date or grade, to track details specific to each
student's enrolment in a course.
Yes, you can create a junction object using a lookup relationship instead of a
master-detail relationship in Salesforce. However, you won't get features like
automatic ownership and cascade delete, roll-up summary fields, and there
might be differences in performance.
154. Can user have different licences if profile assigned to them is same?
Yes, user can be assigned with different licenses even if their profiles are same.
A user license determines the baseline of features that the user can access.
Let’s say you have a Sales Cloud license in Salesforce, which grants you access to
sales-related features like leads, opportunities, and forecasts. However, your
profile might restrict you from deleting opportunities or exporting sensitive data.
So, while your license allows you to use Sales Cloud features, your profile
determines exactly what you can do within those features.
View All grants read access to the object and read only access to all records
associated with a given object across the organization.
Modify All grants read, edit, and delete access to the object and full access to
records within that object.
The “View All” and “Modify All” permissions ignore sharing rules and settings.
157. Two users are there assigned with same profile P1 and Object A is there, for
which read access is given to profile P1 , additional permission set is also assigned
to both users where edit and delete permission is given.
Now the issue is user U1 can delete the record but user U2 is not able to delete
the records. What can be the reason behind this?
Possible reason can be the muting concept.
It might be possible that the user who is still not able to delete the record must
be assigned with the permission set group where muting for the delete access is
done. If yes then the user will not be able to delete the records.
158. Can we create master detail relationship between custom and standard
object?
Yes, we can make but the things which to make sure is that master will always be
standard object here it cannot be child for custom object.
159. What are the different ways to make field mandatory from UI in salesforce?
1. Using Required checkbox at the time of field creation
2. From the page Layout we can make field mandatory
3. Using dynamic forms
4. Validation Rules
160. A profile and object A is there, on profile no CRUD permission is given for
object A but still user able to create the records. What can be the possible reasons
for same?
Permission Set assigned to user where for object A read and create permission is
given, other than this no other possibility because from profile and permission
set, we manage the object level security.
161. Object A is there and profile P1. Same profile is assigned to two user, user
U1 and U2. OWD set for object A is public read and write. Still users are not able to
create the records for object A. What can be the possible reasons?
Will check for the object level permissions i. e profile and permission sets first. If
on object level permission read & create access are not given then record level
security settings will not matter.
162. Object A is there with total 5 fields, now the requirement is whenever user
creates a record all 5 fields should be visible to him and once the record is saved
now on detail page only 3 fields should be visible to him. How will going to achieve
this?
With the help of page layout and record types will going to achieve this plus with
small automation to change the record type automatically on save.
Create second page layout showing only 3 fields now and record type.
Now as soon as record saves/inserted run a record triggered flow where we will
now change the record type to which page layout assigned showing 3 fields.
You will need 18-digit Ids while using tools like Data loader and workbench. The
API tools will accept the 15-character IDs as input but it will always provide you
the 18-character Id when you export data.
164. No automations are implemented on account record but still the user is not
able to delete the account record. What can be the possible reason?
It might be possible because of the following reasons:
• Account has related opportunities with the status closed won. If yes you cannot
delete the account record.
• Account might be having some related cases which are open if yes again you
cannot delete the account record.
166. A new department needs access to certain reports and dashboards. How
would you ensure that they have the appropriate access without compromising
security?
I would create a new permission set or profile for the new department and assign
the necessary permissions to access the required reports and dashboards.
Additionally, I would review and adjust sharing settings to ensure that the data
remains secure.
168. The marketing team wants to automate the process of sending follow-up
emails to leads who have not responded to previous communications. How would
you set up an automated workflow for this scenario?
I would create a flow that triggers when a lead's status remains unchanged for a
specified period. The rule would then automatically send a predefined email
template to the lead, reminding them to respond. Additionally, I would schedule
regular flow evaluations to ensure timely follow-ups.
169. The company uses an external ERP system to manage inventory. How would
you integrate Salesforce with the ERP system to ensure that inventory data is
synchronized between the two systems?
I would explore options such as using Salesforce Connect, custom integrations
using APIs, or middleware solutions like MuleSoft to establish seamless
integration between Salesforce and the ERP system. I would prioritize data
consistency and real-time synchronization to ensure accurate inventory
management.
170. A new employee joins the company and needs training on using Salesforce.
How would you approach training and supporting the user to ensure they are
proficient in using the platform?
I would develop a comprehensive training plan covering basic navigation, data
entry, and advanced features relevant to the user's role. Additionally, I would
provide access to training resources such as documentation, videos, and sandbox
environments for hands-on practice. Ongoing support would be available through
a dedicated help desk or community forum.
171. Users have been experiencing slow performance when working with large
datasets in Salesforce. How would you diagnose and address this performance
issue?
I would analyse the data model, reports, and customizations to identify any
bottlenecks or inefficiencies. Potential optimizations could include indexing
frequently used fields, optimizing SOQL queries, reducing the number of
workflow rules or process builder flows, and leveraging caching mechanisms.
172. The company operates in a highly regulated industry and needs to ensure
compliance with data protection regulations. How would you configure Salesforce
to meet these compliance requirements?
I would configure Salesforce's built-in security features such as field-level security,
object permissions, and data encryption to ensure compliance. Additionally, I
would implement audit trails and regularly review security policies to maintain
compliance.
173. The sales manager needs a report that shows the conversion rates at each
stage of the sales pipeline. How would you create this report using Salesforce's
reporting tools?
I would create a custom report using Salesforce's report builder, selecting the
appropriate fields and filtering criteria to analyse the sales pipeline stages. I
would use summary and matrix reports to visualize conversion rates at each
stage, allowing the sales manager to identify areas for improvement.
174. A user reports that they are unable to log in to Salesforce. How would you
troubleshoot and resolve this issue?
I would first check if the user's login credentials are correct and if there are any
active login restrictions or IP restrictions in place. If the issue persists, I would
review login history and debug logs to identify any errors or issues with
authentication. Depending on the cause, I would take appropriate actions such as
resetting the user's password or contacting Salesforce support for further
assistance.
176. A company has a custom object for projects and wants to link them to
customer accounts. Would you use a master-detail or lookup relationship between
the project and account objects? Explain your reasoning.
I would use a lookup relationship between the project and account objects.
Master-detail relationships imply a stronger parent-child dependency and would
not be suitable if projects can exist independently of customer accounts.
177. The company is migrating data from a legacy system into Salesforce. How
would you ensure data integrity and consistency during the import process,
especially for related records with complex relationships?
I would carefully map fields from the legacy system to corresponding fields in
Salesforce, ensuring data consistency and integrity. For related records, I would
use external IDs or unique identifiers to maintain relationships during the import
process.
180. The company's Salesforce org is reaching its data storage limit. How would
you implement a data archiving strategy to retain historical data while reducing
storage usage and improving system performance?
I would use Salesforce's Data Archiving feature to archive older records based on
predefined criteria such as creation date or last modified date. Archived data
would be retained for compliance purposes while reducing storage usage and
improving system performance.
181. The company wants to ensure that all opportunities have a minimum of
three associated products. How would you enforce this requirement using data
validation rules?
I would create a validation rule on the opportunity object that checks if the count
of associated opportunity products is less than three. If the count is less than
three, the validation rule would display an error message prompting users to add
more products before saving the opportunity.
182. The company experiences slow performance when querying large datasets
due to a complex data model. How would you optimize the data model to improve
query performance without sacrificing functionality?
I would review the data model to identify any unnecessary relationships or fields
that could be removed or optimized. Additionally, I would consider denormalizing
data or using external objects to offload data storage and processing to improve
query performance.
183. The company offers both products and services and wants to capture
different sets of information for each type of offering. How would you use record
types and page layouts to customize the user experience based on the type of
offering being sold?
I would create separate record types for products and services and customize
page layouts for each record type to display relevant fields and related lists. This
would provide a tailored user experience based on the type of offering being
sold.
184. The company is merging with another organization, and there is a need to
consolidate data from both Salesforce orgs into a single org. How would you
approach migrating and transforming data to ensure compatibility and consistency
across systems?
I would develop a data migration plan outlining the steps for extracting,
transforming, and loading data from both Salesforce orgs into the target org. This
may involve data cleansing, mapping fields between systems, and using tools like
Data Loader or Salesforce's Import Wizard to facilitate the migration process.
Additionally, I would conduct thorough testing to ensure data accuracy and
consistency post-migration.
185. The sales team wants incoming leads to be assigned to sales representatives
in a round-robin fashion to ensure equitable distribution. How would you configure
a lead assignment rule to achieve this?
Create a custom field on the Lead object to calculate the next sales
representative in the round-robin sequence, this field can be updated with the
date and time of lead assigned and accordingly give him the order (like 1,2,3…).
Then, use a lead assignment rule that assigns leads to the sales representative
based on the order which is calculated using date and time lead assigned.
188. Certain leads are more valuable or urgent than others and should be
prioritized for immediate follow-up. How would you configure lead assignment
rules to ensure that high-priority leads are assigned first?
Define lead priority levels based on criteria such as lead score, urgency, and
potential value. Configure lead assignment rules to prioritize high-priority leads
for immediate assignment to sales representatives.
190. A company is implementing Salesforce for the first time and needs to
migrate existing customer data from their legacy CRM system into Salesforce. How
would you plan and execute the initial data migration process to ensure a smooth
transition?
Use Salesforce data import tools such as Data Loader or Import Wizard to map
and import data from the legacy CRM system into Salesforce. Prioritize data fields
based on business requirements and perform data validation checks to ensure
accuracy.
191. The company's Salesforce org contains duplicate or outdated records that
need to be cleaned up before migrating to a new system or org. How would you
identify and eliminate duplicate records and ensure data quality during the
migration process?
Use data cleansing tools and techniques to identify and remove duplicate or
outdated records. You can also use the merge DML operations to merge the
duplicates.
Implement data quality rules, duplicates, matching rules, and validation checks to
prevent duplicate data from being entered in the future.
192. Before finalizing the data migration, the company wants to ensure that the
migrated data is accurate and complete. How would you plan and conduct data
validation and testing to identify and resolve any issues or discrepancies?
Develop test plans and scenarios to validate the migrated data against source
data and business requirements. Use Salesforce's data validation tools and
reports to identify and resolve data discrepancies. Involve stakeholders in user
acceptance testing to ensure data accuracy and completeness.
193. After completing the data migration, the company encounters issues or
discrepancies with the migrated data. How would you provide ongoing support and
troubleshooting to address any post-migration issues and ensure data consistency
and integrity?
Provide training and support to users to address any issues or discrepancies with
the migrated data. Establish a process for ongoing data maintenance and cleanup
to prevent data quality issues in the future. Utilize Salesforce's support resources
and community forums to troubleshoot and resolve post-migration issues.
194. What are the factors based on which you will decide whether to establish
master detail or lookup relation between objects.
Here are the key factors:
1. Data Dependency
Master-Detail: Provides strict data dependency where detail records are
owned by master records.
Lookup: Offers more flexibility as child records can exist independently of the
parent.
USER STORIES
195. Explain how will you create a cab booking system in Salesforce which
involves setting up a combination of objects, relationships, automation, and logic
to handle the booking process, user management, and discount application.
2. Setup Relationships
Discount Application:
Use Formula fields or Apex triggers to calculate the discount based on conditions.
Example Formula Field on Booking Object for Discounted Fare.
IF(
NOT(ISBLANK(Discount__c)),
Fare__c - (Fare__c * Discount__r.Discount_Value__c / 100),
Fare__c
)
5. User Interface
Customize Lightning Record Pages for Contact, User, Booking, and Cab objects to
provide a user-friendly interface for managing bookings and viewing discounts.
Reports:
Dashboards:
Create dashboards to visualize key metrics like booking trends, cab utilization,
and discount impacts.
• Thoroughly test the system with various user scenarios to ensure the discounts
are applied correctly.
• Use Salesforce's Change Sets or other deployment tools to move your
configurations from a sandbox to production.
2. Automation:
Employee Management App: A custom Lightning App to view and manage employee
records and performance reviews.
Lightning Record Pages: Customized pages for Employee and Performance Review
objects for easy access and updates.
3. Reporting:
197. As a project manager, I want to track project progress, tasks, and team
collaboration.
1. Object and Field Setup:
2. Automation:
Flow to automate task assignment and send notifications when tasks are due or
overdue.
Setup Approval Processes for project budgets or milestone completions.
3. User Interface:
Project Management App: A custom Lightning App to track project timelines, task
status, and team collaboration.
Chatter: Use Chatter for team communication and document sharing within project
records.
4. Reporting:
Create reports to track project progress, task completion rates, and resource
utilization.
Dashboard: Visualize project health with metrics such as project status, completed
vs. pending tasks, and budget vs. actual spend.
198. As a marketing manager, I want to segment my leads and run targeted email
campaigns.
2. Automation:
Lead Assignment Rules to distribute leads to the appropriate sales reps based on
criteria such as geography or product interest.
Email Alerts to notify reps when they receive new leads.
3. User Interface:
Marketing Cloud Integration: Connect Salesforce with Marketing Cloud to manage
email campaigns and track engagement.
Lead Views and Reports: Create custom list views and reports to segment leads
based on demographics, behaviour, or lead score.
4. Campaign Management:
199. As a sales manager, I want to track the performance of my sales team and
forecast future sales.
2. Automation:
Sales Console: A customized Lightning App for sales reps to manage their pipeline,
log activities, and update opportunity stages.
Sales Forecasting: Use Salesforce’s forecasting tools to project future sales based on
current pipeline data.
Create reports to track team performance, win rates, and revenue by region.
Dashboard: Visualize sales KPIs such as total pipeline value, closed revenue, and
forecast accuracy.
200. As a customer service representative, I want to manage and resolve customer
complaints efficiently.
2. Automation:
Case Assignment Rules to automatically assign cases to the appropriate support team
based on criteria such as case type or priority.
Email Alerts to notify the customer when a case is created, updated, or closed.
3. User Interface:
4. Reporting:
Create reports to track case resolution times, open cases by priority, and customer
satisfaction scores.
Dashboard: Display key metrics such as average resolution time and case backlog.