Data Flashcards

1
Q

What operations can be performed directly through the graphical user interface of Data Loader? Choose 3

A. Migrate attachments from source to the target organization
B. Upload documents and links into content libraries
C. Upload Attachments
D. Hard Delete Records
E. Export content from content libraries

A

B. Upload documents and links into content libraries
C. Upload Attachments
D. Hard Delete Records

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

There are three custom objects, namely Position, Job Application, and Candidate. Lookup relationships have been created from Job Application to Position and Job Application to Candidate. What are valid reasons for creating lookup relationships instead of master-detail relationships? Choose 3

A. Job applications may be processed in a queue
B.) The owner of the job application could be different from the owner of the position record
C.) The total field for the number of applications for each position is required on the position object
D.) The Job Application object may already have two master detail relationships defined
E.) Security and permission settings of job applications should be dependent on the Position object

A

A. Job applications may be processed in a queue
B.) The owner of the job application could be different from the owner of the position record
D.) The Job Application object may already have two master detail relationships defined

It is possible to have the owner field separately for the detail record only when the relationship is lookup and not master-detail. So with lookup relationships, a job application record can have an owner different from the owner of its position record.

Job application records can be processed in a queue by assigning the queue as the owner.

Only 2 master-detail relationships are allowed per object.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

While trying to define a new custom field, the admin noticed that the “Master-detail relationship” field type is grayed out. What could be the reason? Choose 1

A.)There is already two master-detail relationships fields on the object
B.) There is already a master-detail relationship field on the object

A

A.)There is already two master-detail relationships fields on the object

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What is true regarding master-detail relationship with a standard and custom object? Choose 2

A. The standard object can only be the master side of this relationship
B. The standard object can be on the master or detail side of this relationship
C. The custom object can be on the master or detail side of this relationship
D. The object on the detail side will inherit the security and sharing settings of the master object

A

A. The standard object can only be the master side of this relationship
D. The object on the detail side will inherit the security and sharing settings of the master object

In master-detail relationships between standard and custom objects, the standard object is always the master. A standard object cannot be on the detail side with a custom object being on the master side. The detail records inherit the security and sharing settings of the master.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What is is true about lookup relationships? Choose 2

A.) Lookup fields are always optional
B.) A lookup relationship is used when two objects need to be linked tightly
C.) The objects in the relationship can have different owners
D.) Both objects in the lookup relationship can have independent sharing rules

A

C.) The objects in the relationship can have different owners
D.) Both objects in the lookup relationship can have independent sharing rules

In a lookup relationship, the two objects can have independent ownership and security settings. The objects are loosely linked, and the lookup fields can be optional or required

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Global Containers would like to create quotes related to opportunities. What would be the recommended data model to meet this requirement? Choose 1

A.) Use the standard Opportunity and Quote objects
B.) Create a Quote custom object and link it to the Opportunity standard object
C.) Install an AppExchange product to add custom Quote objects
D.) Extend the Opportunity object by including custom fields for Quotes

A

A.) Use the standard Opportunity and Quote objects

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Which of the following statements are true with regard to enabling the Bulk API in Data Loader? Choose 3

A.) Parallel processing is used to load data faster
B.) Data will be loading faster when using the Bulk API
C.) Serial processing is used to load data faster
D.) Synchronous processing is used to load data faster
E.) Data is processed in batches

A

A.) Parallel processing is used to load data faster
B.) Data will be loading faster when using the Bulk API
E.) Data is processed in batches

The bulk API loads data faster as it uses parallel processing of batches. Serial mode can be enabled via the “Settings” screen if data contention is a problem with parallel processing, but this will result in a slower overall process.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

The Sales team at Global Containers has created a list of opportunities which need to be imported to SFDC. There are about 200 records in the import file. Which of the following solutions should be used for the import? Choose 1

A.) Manually enter the records
B.) Use an AppExchange solution
C.) Use Data Loader
D.) Use Data Import Wizard

A

C.) Use Data Loader

The Opportunity object is not supported by the Data Import Wizard. It is only possible to import opportunity records using the Data Loader.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

The Admin working for company recently tried the Schema Builder, but found that it displays too many objects and relationships, has long loading times, and is too difficult to work with. Which of the following features could help with these issues? Choose 3

A.) The filter can be used to only display objects of interest
B.) Performance can be improved by selecting the “Hide Relationships” option.
C.) The map can be used to navigate to objects of interest
D.) Performance can be improved by selecting the “Hide Grids” option
E.) Fields can be hidden and only the objects can be displayed

A

A.) The filter can be used to only display objects of interest
B.) Performance can be improved by selecting the “Hide Relationships” option.
C.) The map can be used to navigate to objects of interest

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Company is migrating customer data from a legacy CRM application into SFDC and needs to ensure that the original created date of the account records is retained when the records are imported into SFDC. How can a developer meet this requirement? Choose 1

A.) Request Salesforce to enable the “Update System Fields” setting
B.) Enable the “Set Audit Fields upon Record Creation” setting in Setup
C.) Disable the “Lock System Fields” setting on the Account object
D.) No Action is required since the Created Date can always be updated but only via the API

A

B.) Enable the “Set Audit Fields upon Record Creation” setting in Setup

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

You have determined that you need to store information about Prospects, Customers, Policies, Claims and Benefits in SFDC. Which of the following statements is true regarding the types of objects what would be required? Choose 1

A.) Customers could be stored in the Account standard object, but all other data would require custom objects
B.) Both standard and custom objects could be used to store the data
C.) Custom objects would need to be created to store all of the required data
D.) Standard objects could store all of the required data

A

B.) Both standard and custom objects could be used to store the data

While it is possible to use custom objects to store all of the data, standard objects should be examined first to determine if they are appropriate for the use case. The Lead standard object could be used for prospects. The Account standard object could be used for both individual and business customers. All other data would require a custom object to be created.

Note: The Financial Services Cloud insurance data model includes Insurance Policies, Claims, and Insurance Coverage standard objects.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Which of the following are true about external objects and Salesforce Connect? Choose 3

A.) External objects support lookup relationships
B.) External objects can be created for any data source that supports OData 2.0 or OData 4.0
C.) External object data can be viewed together with data from within Salesforce on the same page
D.) External objects do not support lookup relationships

A

A.) External objects support lookup relationships
B.) External objects can be created for any data source that supports OData 2.0 or OData 4.0
C.) External object data can be viewed together with data from within Salesforce on the same page

External Data is available in the Salesforce mobile app and Global Search. External objects require the creation of an external data source. While defining an external data source, it is possible to specify its type as either Salesforce Connect: OData 2.0 or Salesforce Connect: OData 4.0. External object data can be viewed with data from standard or custom Salesforce objects through related lists. Lookup relationship fields can be created on external objects.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Which of the following statements are true about a master-detail relationship in Salesforce? Choose 2

A.) The relationship field is not required on the page layout of the detail object
B.) The security settings of the detail records depend on the master record
C.) The master objects can be a standard or custom object
D.) By default, records can be reparented in master-detail relationships

A

B.) The security settings of the detail records depend on the master record
C.) The master objects can be a standard or custom object

Reparenting of detail records can be set up, but it is not the default setting. The master-detail relationship field is required on the page layout of the detail record.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Which of the following is used for record matching when using the Data Loader. Choose 1

A.) External ID or Record ID
B.) Record ID
C.) External ID
D) Record owner

A

A.) External ID or Record ID

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

The data model for company includes Policy and Claim object. A Claim should always be related to a Policy. Related Claims must be visible on the Policy detail page. Claims are processed by the claims team, which requires an efficient way to organize, assign, and manage claims. What type of relationship would be required in this situation to be able to use queue functionality? Choose 1

A.) A one-to-many relationship between the two objects
B.) A master-detail relationship between the two objects as they are tightly linked
C.) A lookup relationship since child records cannot have an owner in a master-detail relationship
D.) A master-detail relationship with sharing rules on the detail object

A

C.) A lookup relationship since child records cannot have an owner in a master-detail relationship
In this case, queues are required to manage and assign claims. A queue requires an owner field, which is not available on child records in a master-detail relationship, so a lookup relationship would
be required. The ‘Always require a value in this field in order to save a record’ option on the lookup relationship field should be selected to require a Claim record to always have a parent Policy.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Company wants to track the location of each container it owns. Which of the following are valid reasons for creating a Location custom object and a lookup relationship field on the Container object instead of using a picklist field? Choose 3

A.) Validation needs to be performed on the location value
B.) Additional information about the location needs to be recorded
C.) Location values need to be maintained by end users
D.) The criteria for a workflow rule should use the location value
E.) There is a very large number of locations

A

B.) Additional information about the location needs to be recorded
C.) Location values need to be maintained by end users
E.) There is a very large number of locations

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

Company has a list of leads that need to be imported. The company follows a very strict data quality policy and does not want any duplicate leads to be created in the system as part of the import. What would a Salesforce developer recommend? Choose 1

A.) Use Data Loader
B.) Use Data Import Wizard
C.) use Data import CLI
D.) User Data Loader CLI

A

B.) Use Data Import Wizard

One advantage the Data Import Wizard has over Data Loader is that it is possible to prevent duplicates by uploading records according to account name and site, contact email address, or lead email address

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

Company wants to insert new customer records daily at 11am in the morning. How could this be automated? Choose 2

A.) Download and install an app from the AppExchange
B.) Data Loader GUI
C.) Data Loader Command Line Interface
D.) Force.com Excel Connector

A

A.) Download and install an app from the AppExchange
C.) Data Loader Command Line Interface

Data Loader’s command line interface or a third party app from the AppExchange can be used for this. The Data Loader GUI does not allow scheduling jobs. The Force.com Excel Connector is useful for cleaning and mass-updating Salesforce-based data from within a spreadsheet.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

Company uses custom objects extensively. Which of the following tools can be used to import data into custom objects? Choose 3

A.) Data Loader Command-Line Interface
B.) Data Import Wizard
C.) Data Loader
D.) Data Importer

A

A.) Data Loader Command-Line Interface
B.) Data Import Wizard
C.) Data Loader

Custom object data can be imported through Data Import Wizard as well as Data Loader. Data Loader can also be run from the command line for automated batch operations such as nightly scheduled loads and extractions.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

There is a requirement to view real-time data stored in SAP within the SFDC account record. What is the best way to meet this requirement? Choose 1

A.) Export the data from SAP and import into SFDC with a nightly batch job
B.) Create a custom integration between SFDC and SAP
C.) use a third-party integration tool to connect SFDC and SAP in real-time
D.) Define an external object in SFDC to access the SAP data

A

D.) Define an external object in SFDC to access the SAP data

External objects can be used to access data stored in an external system such as SAP in Salesforce

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

Which of the following are NOT capabilities of the Schema Builder? Choose 1

A.) Create formula fields
B.) Create lookup and master-detail relationships
C.) Create custom objects
D.) Create validation rules

A

D.) Create validation rules

Schema Builder provides the ability to add custom objects, lookup relationships, master-detail relationships, and all custom fields (including formula fields) except Geolocation.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

Which of the following are valid reasons for using external objects instead of a third-party application for integrating data with Salesforce? Choose 2

A.) There is a large amount of external data, but users need to access only a small amount at a time
B.) External object records need to be shared with users based on certain criteria
C.) External data needs to be stored in the Salesforce org
D.) Real-time access to the latest external data is required

A

A.) There is a large amount of external data, but users need to access only a small amount at a time
D.) Real-time access to the latest external data is required

Sharing is not supported for external objects. It is also not possible to store external data in Salesforce using external objects. However, external data can be made available in real-time and on demand.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

When adding a custom field to an object using the Schema Builder, which of the following is true? Choose 1

A.) The field-level security of custom fields is set to “Visible” for all profiles
B.) Custom fields are not automatically added to page layouts
C.) Custom fields are added to page layouts but the page layout needs to be edited to specify where the field should be displayed
D.) Roll-up summary fields cannot be added using the schema builder

A

B.) Custom fields are not automatically added to page layouts

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

Sam has completed the solution design for a SFDC application project and is ready to create the data model for the new application in Salesforce. There are several custom objects, each with a number of custom fields. What would be the most efficient way to complete the task? Choose 1

A.) use the Schema Builder to create custom objects and fields, and then navigate to “Objects” in Setup to create relationships
B.) use the Schema Builder to create custom objects, and then navigate to “Objects” in Setup to create fields and relationships
C.) use the Schema Builder to create custom objects, fields and relationships
D.) Create the custom objects, fields and relationships by navigating to “Objects” in Setup, and use the Schema Builder to verify that the data model has been setup correctly

A

C.) use the Schema Builder to create custom objects, fields and relationships

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

The admin has determined that he needs a junction object to model a many to many relationship between Students and Subjects. He creates the junction object “Student Subjects” and then creates the first master detail relationship between Students and “Student Subjects”. What will be the result of creating this primary relationship? Choose 2

A.) The junction object detail and edit page uses the color from the primary object
B.) The junction object inherits the owner from the primary object
C.) The primary relationship cannot be deleted if there is a second master detail relationship
D.) Junction object records can always be created. edited or deleted if the users have at least Read access to the primary object

A

A.) The junction object detail and edit page uses the color from the primary object
B.) The junction object inherits the owner from the primary object

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q

After a review, it was decided that custom objects A and B need to be in a master-detail relationship instead of the current lookup relationship. A is the proposed master. Which of these items would you investigate before making the change? Choose 2

A.) Number of null values in the existing Lookup field on Object B
B.) Existing roll-up summary fields on Object A
C.) Number of existing master-detail relationships on Object B
D.) Validation rules applicable to the existing Lookup field on Object B

A

A.) Number of null values in the existing Lookup field on Object B
C.) Number of existing master-detail relationships on Object B

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
27
Q

A developer wants to link a custom object called Bug with itself to show how two different bugs are related to the same problem. Which type of relationship field should the developer use? Choose 1

A.) Self
B.) Lookup
C.) Master-Detail
D.) Hierarchical

A

B.) Lookup

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
28
Q

Which of the following is true about changing the field type of a Text Area (Rich) field? Choose 1

A.) Text Area (Rich) field can be converted to a Text Area (Long) field type but data may be truncated
B.) Test Area (Rich) field can be converted but only to a Text Area (Long) field type
C.) Images in a Text Area (Rich) field are deleted as soon as the field type is converted
D.) It is not possible to change the field type of a Text Area (Rich) field

A

B.) Test Area (Rich) field can be converted but only to a Text Area (Long) field type

A Rich text area can only be converted into a Long text Area. Rich text area fields and long text area fields have exactly the same quantitative capacity in storing characters such that converting a rich text area into a long text area does not result to truncation - that is cutting off the top or the end of a string

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
29
Q

While adding a custom field to a newly created custom object, you have determined that you need a field that can store up to 500 characters of text on separate lines. Which data type would you select? Choose 1

A.) Text Area
B.) Text
C.) Multi-Line Text
D.) Text Area (Long)

A

D.) Text Area (Long)

A Text field allows entering a single line of text. A Text Area field allows entering up to 255 characters on separate lines. Text Area (Long) can store up to 131,072 characters. Multi-Line Text is not a Salesforce field type.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
30
Q

A master-detail relationship can exist between which of the following? Choose 2

A.) Standard object master and custom object detail
B.) Custom object master and custom object detail
C.) Custom object master and standard object detail
D.) External object master and custom object detail

A

A.) Standard object master and custom object detail

B.) Custom object master and custom object detail

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
31
Q

What can be used to model a many-to-many relationship between two custom objects? Choose 2

A.) Junction object
B.) Lookup relationship
C.) Master-detail relationship
D.) Hierarchical relationship

A

A.) Junction object

C.) Master-detail relationship

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
32
Q

While designing a custom application in Salesforce, the admin is reviewing the data types that would be suitable for the fields. Which standard field types are available for custom fields? Choose 2

A.) Checkbox, Picklist, and Address
B.) Email, Phone and URL
C.) Text, Radio Button, and Date/Time
D.) Number, Currency, and Percent

A

B.) Email, Phone and URL
D.) Number, Currency, and Percent

Address fields are a special compound data type that is only used in standard fields on standard objects. Radio Button is not a salesforce field type.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
33
Q

Global Systems is planning to retire their legacy contact management system and move all the data to Salesforce. The legacy system allows exporting contact records, but there are close to 90,000 contact records that need to be migrated. What is the best option in order to achieve this migration?
Choose 1 answer.
A. Use Salesforce Connect
B. Use Data Loader to import data
C. Use the Data Import Wizard to import data
D. Buy and use an AppExchange tool

A

B. Use Data Loader to import data
Data Loader is the ideal choice when records to be imported are between 50,000 and 5 million. Salesforce Connect does not actually move data; it allows accessing external data in Salesforce. The
Data Import Wizard can only import up to 50,000 records.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
34
Q

Data Loader is a tool to insert data into and export data from a Salesforce organization. What other functionalities does it provide?
Choose 3 answers.
A. Delete
B. Upsert
C. Update
D. Archive
E. Undelete

A

A. Delete
B. Upsert
C. Update
Data Loader is a client application for the bulk import or export of data. lt can be used to insert, update, delete, or export Salesforce records. When importing data, Data Loader reads, extracts, and
loads data from comma separated values (CSV) files or from a data base connection. When exporting data, it outputs CSV files.
Upsert is a term used to mean that if a record in the import file matches an existing record,the record Will be updated, if no match if found a new record Will be inserted.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
35
Q

Worldwide Containers would like to create quotes related to opportunities. What would be the recommended data model to meet this requirement?
Choose 1 answer.
A. Create a Quote custom object and link it to the Opportunity standard object
B. Use the standard Opportunity and Quote objects.
C. Extend the Opportunity object by including custom fields for Quotes
D. Install an AppExchange product to add custom Quote objects

A

B. Use the standard Opportunity and Quote objects.
The standard Opportunity and Quote objects allow one or more quotes to be created and linked to an opportunity

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
36
Q

Two custom objects, A and B, are in a parent-child relationship. A record of object B cannot exist without a related record of object A. When a record of custom object A is deleted, all associated custom object B records are also deleted. Based on the given information, which of the following statements is true?
Choose 1 answer.
A. There is a master-detail relationship field on object B to object A
B. There is a lookup relationship field on object A to object B
C. There is a master-detail relationship field on object A to object B
D. There is a lookup relationship field on object B to object A

A

A. There is a master-detail relationship field on object B to object A
There can only be a master-detail relationship between the two objects. For every record of object B, there is a related record of object A, which means that the relationship field on object B is
required. Whenever a record of object A is deleted, the related records of object B are deleted, which is the standard behavior of a master-detail relationship. Also, since the relationship field is
required and child records are deleted automatically, the relationship cannot be a lookup relationship. In a lookup relationship, the option to delete related child records can only be selected if the
relationship field is optional.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
37
Q

Which of the following are true regarding the Data Import Wizard?
Choose 2 answers.
A. The Data Import Wizard maps as many data fields as possible to standard Salesforce data fields
B. Any standard or custom object can be imported
C. Records can be added, existing records can be updated, or records can be added and updated simultaneously
D. Only administrators can access the Data Import Wizard

A

A. The Data Import Wizard maps as many data fields as possible to standard Salesforce data fields
C. Records can be added, existing records can be updated, or records can be added and updated simultaneously
Not all standard objects can be imported using the Data Import Wizard. The objects available are accounts, contacts, leads, campaign members, solutions, and person accounts. Non
administrators can also access the Data Import Wizard from the ‘Import’ option under ‘My Settings’.
The Data Import Wizard automatically maps as many fields as possible to standard Salesforce data fields, and the rest needs to be mapped manually. For the most efficient auto-mapping offields,
column headings in the import file should match the field labels of the object.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
38
Q

Which of the following are true regarding master-detail relationships?
Choose 3 answers.
A. An object can have up to five master-detail relationship fields
B. Roll-up summary fields can be created on the master object
C. When a user deletes a master record, all detail records are deleted
D. The relationship field needs to be marked as required on the detail object
E. Ownership of detail records is determined by the master record

A

B. Roll-up summary fields can be created on the master object
C. When a user deletes a master record, all detail records are deleted
E. Ownership of detail records is determined by the master record
In a master-detail relationship, the relationship fields are automatically and always marked as required on the detail object, and there is no need to make it required. An object can have up to two
master-detail relationship fields.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
39
Q

Cosmic Solutions wants to insert new customer records at 11 am, daily. How could this be automated?
Choose 2 answers.
A. Force.com Excel Connector
B. Data Loader Command Line Interface
C. Data Loader GUI
D. Download and install an app from the AppExchange

A

B. Data Loader Command Line Interface
D. Download and install an app from the AppExchange
Data Loader’s command-line interface or a third-party app from the AppExchange can be used for this. The Data Loader GUI does not allow scheduling jobs. The Force.com Excel Connector is
useful for cleaning and mass-updating Salesforce-based data from within a spreadsheet.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
40
Q

Global Containers uses custom objects extensively. Which of the following tools can be used to import data into custom objects?
Choose 3 answers.
A. Data Loader Command-Line Interface
B. Record Loader
C. Data Importer
D. Data Loader
E. Data Import Wizard

A

A. Data Loader Command-Line Interface
D. Data Loader
E. Data Import Wizard
Custom object data can be imported through Data Import Wizard as well as Data Loader. Data Loader can also be run from the command line for automated batch operations such as nightly
scheduled loads and extractions.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
41
Q

On the custom object called ‘Vehicle’, a lookup relationship to the ‘Model’ custom object has been defined. What are the possibilities when a ‘Model’ record is deleted?
Choose 3 answers.
A. The lookup field value on ‘Vehicle’ is updated to the next model record
B. The lookup field value on ‘Vehicle’ is updated to the default model record
C. The lookup field value on ‘Vehicle’ can be cleared
D. The deletion of a model record can be restricted
E. The vehicle record can be deleted

A

C. The lookup field value on ‘Vehicle’ can be cleared
D. The deletion of a model record can be restricted
E. The vehicle record can be deleted
One of three behaviours can be specified when a lookup record is deleted. By default, only two options are visible in a lookup definition; the value of the lookup field can be cleared or the deletion
of the lookup record can be prevented if it is part of a lookup relationship. A third option allows deletion of the record with the lookup field, but it is only available if a custom object contains the
lookup relationship. Choosing the third option can result in a cascade-delete if multiple lookups are chained together.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
42
Q

TODO: Entender mas
Universal Sales Corp needs to create a data model using custom objects based on Order Groups, Orders, and Order Items. Order Group is a collection of Orders, and each Order has multiple associated Order Items. Order Groups can be deleted when necessary, but the related Order data should not be lost. Order Items should not exist without an Order record. Which types of relationships would need to be created for this requirement?
Choose 1 answer.
A. Look-up relationship between Order Group and Order, and master-detail relationship between Order and Order Item.
B. Master-detail relationship between Order Group and Order, and look-up relationship between Order and Order Item.
C. Look-up relationship between Order Group and Order, and look-up relationship between Order and Order Item.
D. Master-detail relationship between Order Group and Order, and master-detail relationship between Order and Order Item.

A

A. Look-up relationship between Order Group and Order, and master-detail relationship between Order and Order Item.
Order Group and Order would need to have a lookup relationship since a loose association with independent security is required between the two. Order and Order Item need to be in a master-detail relationship since Order Items should only exist if there is a related master record.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
43
Q

Which of the following provides an interactive environment for viewing, creating and modifying objects, fields, and relationships in Salesforce?
Choose 1 answer.
A. Process Visualizer
B. Flow Builder
C. Schema Builder
D. Process Builder

A

C. Schema Builder
Schema Builder provides a dynamic environment for viewing, creating and modifying all the objects, fields, and relationships in a Salesforce org. Existing schema can be viewed, and new custom
objects, custom fields, and relationships can be added using drag-and-drop in the interactive user interface.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
44
Q

An app builder is building a recruitment management application. The application requires the ability to hold details regarding job positions, candidates, and their applications to one or more job positions. Which of the following represents the best data model to achieve this requirement?
Choose 1 answer.
A. Define the Position and Candidate objects as parent objects, and then Application as a junction object
B. Define the Position object as a parent object, the Candidate object as a child of Position, and Application as a child of Candidate
C. Define the Position object as a parent object, and then Candidate and Application as child objects
D. Define three unrelated objects, namely, Candidate, Position, and Application

A

A. Define the Position and Candidate objects as parent objects, and then Application as a junction object
Application refers to the logical relationship between a candidate and a job position. One candidate can applyfor many job positions, and one position can have multiple candidates. Therefore, the
Candidate and Position need to be in a many-to-many relationship with Application as the junction object. In Salesforce, such a relationship is possible by creating two master-detail relationship
fields on the junction object.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
45
Q

Your company would like to mass create new Salesforce users. What is the best way to do this?
Choose 1 answer.
A. Use the Data Loader
B. Use the Data Import Wizard
C. Create a Visualforce Page for the customers to mass upload the data
D. Manually create the records individually

A

A. Use the Data Loader
The Data Import Wizard cannot load user records, so Data Loader would be required.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
46
Q

A Salesforce administrator is trying to decide whether to use a master-detail or lookup relationship between two objects. Which of the following considerations are true
Choose 1 answer.
A. In a master-detail relationship, if the master record is deleted, the detail records are not deleted automatically
B. Child records in master-detail relationships on custom objects can be reparented
C. A custom object can be on the master side of a relationship with a standard object
D. Custom objects on the detail side of a master-detail relationship can have queues

A

B. Child records in master-detail relationships on custom objects can be reparented
Child records in master-detail relationships on custom objects can be reparented to different parent records by selecting the ‘Allow Reparenting’ option in the master-detail relationship definition.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
47
Q

While trying to define a new custom field, the Salesforce Administrator noticed that the ‘Master-Detail relationship’ field type is grayed out. What could be the reason?
Choose 1 answer.
A. There is already a master-detail relationship field on the object
B. There are already two master-detail relationship fields on the object
C. There are already 25 master-detail relationship fields on the object
D. There are already three master-detail relationship fields on the object

A

B. There are already two master-detail relationship fields on the object
A maximum of two master-detail relationships can be defined on an object, which means that an object can have a maximum of two distinct master objects. After these have been defined, further creation of master-detail relationship fields is not possible.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
48
Q

Worldwide Containers wants to track their suppliers for parts. A supplier can supply various parts, and the company always ensures that there are multiple suppliers for each part, in case a part is out of stock at one of the suppliers. What is the best way to model this in Salesforce?
Choose 1 answer.
A. Create a lookup relationship from the Part object to the Supplier object
B. Create a lookup relationship from the Supplier object to the Part object
C. Create a master-detail relationship from the Supplier object to the Part object
D. Create a many-to-many relationship by creating a new junction object between the Supplier and Part objects

A

D. Create a many-to-many relationship by creating a new junction object between the Supplier and Part objects
A many-to-many relationship between the Supplier and Part objects should be established so that one supplier can be associated with many parts, and one part can be associated with many
suppliers. In order to implement a many to-many relationship, a third object which is called a junction object in Salesforce, must be created. Two master-detail fields are then created on the
junction object - one for the Supplier object and the other for the Part object.
Creating a direct relationship between the Supplier and Part objects Will only create a one-to-many relationship.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
49
Q

Sam has created a custom application for recruitment in Salesforce by using custom objects that represent Candidates and Positions. A junction object called ‘Application’ has also been created.
Which of the following statements is true with regard to the ‘Application’ object?
Choose 1 answer.
A. The Application object cannot be part of a lookup relationship
B. The Application object cannot be on the master side of a master-detail relationship
C. The Application object cannot have a tab
D. Data cannot be imported to the Application object

A

B. The Application object cannot be on the master side of a master-detail relationship
Custom junction objects can not have detail objects. That is, a custom junction object cannot become the master object in a multilevel master-detail relationship. However, it can be part of a regular lookup relationship.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
50
Q

Sam is in the process of designing the Salesforce data model for Pacific Travels. He needs to be able to associate multiple ‘Booking Detail’ records to a single Contact record. In addition, the ‘Booking Detail’ records are of legal importance, which is why they should not be deleted, even if the associated Contact is deleted. How should Sam design the data model for this requirement?
Choose 1 answer.
A. Define a master-detail relationship field on the ‘Booking Detail’ object that references the ‘Contact’ object
B. Define a lookup relationship field on the ‘Contact’ object that references the ‘Booking Detail’ object
C. Define a master-detail relationship field on the ‘Contact’ object that references the ‘Booking Detail’ object
D. Define a lookup relationship field on the ‘Booking Detail’ object that references the ‘Contact’ object

A

D. Define a lookup relationship field on the ‘Booking Detail’ object that references the ‘Contact’ object According to the requirement, a one-to many relationship is required between Contact and Booking Detail. A lookup relationship field on the ‘Booking Detail’ object would allow a ‘Booking Detail’ to be associated with a Contact, and multiple Booking Details can be associated with a contact.
Since the cascade delete effect should be avoided when contacts are deleted, a master-detail relationship would not be suitable for this scenario.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
51
Q

A developer of Cosmic Solutions is building a project management application. According to the design, the application needs to be used to store information about Projects and functional Modules. Each Project can have multiple functional Modules related to it. Furthermore, each functional Module must also store information regarding the responsibility assigned to each person working on the Module. Each responsibility must contain information such as due date and status. Which of the following represents the most optimal data model for this requirement?
Choose 1 answer.
A. Define Project and Module as parent objects, and then define Responsibility as a junction object.
B. Define Project object, enable the Task object for it, and then define Module as a field on the Task object.
C. Define Project as a parent object and Module as its child object, and enable the Task object for the Module object.
D. Define Project as a parent object and Module as its child object, and enable the Task object for the Project object.

A

C. Define Project as a parent object and Module as its child object, and enable the Task object for the Module object.
The most suitable design would be to define Project and Module as parent and child objects in a master detail relationship. The standard functionality of Tasks can be utilized to define responsibilities. ‘Due Date’ and ‘Status’ are fields on Tasks. To enable Tasks, the Allow Activities’ checkbox can be selected while creating a custom object.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
52
Q

Global Travels has conducted a 1 week long global marketing campaign and has around 70,000 Leads to import. Which of the following is true with regard to importing this data into Salesforce, if they need to load the records at one time?
Choose 1 answer.
A. Only Data Loader would work
B. Only Data Import Wizard would work
C. Neither Data Loader nor Data Import Wizard would work
D. Both Data Loader and Data Import Wizard would work

A

A. Only Data Loader would work
The Data Import Wizard can load up to 50,000 records at one time. Data Loader can be used to load up to 5 million records.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
53
Q

Which of the following are true statements about accessing external object data in Salesforce?
Choose 3 answers.
A. External object data can be accessed via list views.
B. A user can use a custom tab to access records of an external object.
C. Formula fields can be used to access information about related objects.
D. External object data synchronization runs regularly in the background.
E. Detail pages can be accessed to view external object data.

A

A. External object data can be accessed via list views.
B. A user can use a custom tab to access records of an external object.
E. Detail pages can be accessed to view external object data.
External objects share much of the same user interface functionality as custom objects. lt is possible to access external objects via list views, detail pages, record feeds, custom tabs, and page
layouts. However, formula fields cannot be added to external objects. Also, external object data is not stored in Salesforce. Salesforce Connect provides a live connection to external object data
rather than a copy that consumes storage and must be regularly synced.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
54
Q

Worldwide Containers would like to track which leads and contacts receive a direct mail promotion. What would be the recommended data model to meet this requirement?
Choose 1 answer.
A. Use the standard Campaign List object
B. Use the standard Campaign Members object
C. Create a custom object for Campaign Leads and Contacts
D. Create custom objects for Campaign Leads and Campaign Contacts

A

B. Use the standard Campaign Members object
Leads and Contacts can both be stored in the standard Campaign Members object.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
55
Q

What does a Salesforce Administrator need to consider when loading data into fields in Salesforce through an API based tool?
Choose 3 answers.
A. New picklist values are always imported
B. Values can be imported if a user has only ‘Read’ access through field-level security
C. Validation Rules Will fire
D. Triggers Will fire
E. Workfiow Rules Will run

A

C. Validation Rules Will fire
D. Triggers Will fire
E. Workfiow Rules Will run
When loading data using Data Loader or other API based tools, Workflow Rules, Validation Rules, and Triggers are executed. Records that fail validation checks are not processed. A user requires
‘Read’ and ‘Edit’ access to a field to import values into it. Field-level security can be used to restrict a user’s access to update fields through the API. New values are imported into a Picklist or
Multi-Select Picklist field only if the Picklist is unrestricted.

56
Q

John, the Salesforce administrator at Global Consulting, is required to design the data model for project and employee data. A project can have many employees working on it, and an employee can work on multiple projects. What design should John propose?
Choose 1 answer.
A. Create a master-detail relationship from Project object to Employee object
B. Create a lookup relationship from Employee object to Project object
C. Create a lookup relationship from Project object to Employee object
D. Create a many-to-many relationship by creating a new junction object between Project and Employee objects

A

D. Create a many-to-many relationship by creating a new junction object between Project and Employee objects
Based on the requirement, Project and Employee data should have a many-to-many relationship. In Salesforce, such relationships are possible by creating a junction object between the two
objects.

57
Q

There is a many-to-many relationship between Employees and Projects. An employee can work on many projects and a project can have many employees working on it. Ajunction object called ‘Project Assignment’ has been defined. What would happen to a Project Assignment record if an Employee record is deleted?
Choose 1 answer.
A. The Employee record could not be deleted if there were Project Assignment records
B. The Project Assignment record would remain with the Employee field cleared
C. The Project Assignment record would be deleted and moved to the recycle bin
D. The Project Assignment record would be deleted permanently

A

C. The Project Assignment record would be deleted and moved to the recycle bin
A many-to-many relationship allows the linking of one record to multiple records and vice versa. lt is comprised of two master-detail relationships created on a junction object. If one of the
associated master records is deleted, the junction object record is moved to the recycle bin. If both associated master records are deleted, the junction object record is deleted permanently.

58
Q

Which of the following options can be used to automate batch operations such as loading or importing large sets of data from a local machine on a daily basis?
Choose 1 answer.
A. Manually complete the batch operation
B. Run Data Loader from the command line
C. Use the Data Import Wizard
D. Utilize a schedule-triggered flow

A

B. Run Data Loader from the command line
Data Loader can be invoked from the command line and can be used to automate batch operations. Data Import Wizard operations cannot be scheduled. Although a flow can be scheduled to run
on specified timings, it cannot load data from a local machine nor is it a recommended tool to use for processing large datasets.

59
Q

Objects A and B are in a master-detail relationship, with A as the master. There is a sharing rule that grants all Marketing Users ‘Edit’ permission to object A. Based on the given information, which of the following statements are true?
Choose 2 answers.
A. Object A cannot be part of another master-detail relationship
B. Object B cannot have an Ownerfield
C. Object B cannot be part of another master-detail relationship
D. Marketing Users have edit access to object B

A

B. Object B cannot have an Ownerfield
D. Marketing Users have edit access to object B
The custom object on the detail side of a master detail relationship cannot have an owner and inherits access rules from the master.
Reference Link

60
Q

Samantha has completed designing a solution that involves a complex data model for a new Salesforce application project. She would like to visualize the data model when creating the objects, fields, and relationships. lt is necessary that any customization can be revised quickly on the spot. What would be the most suitable approach for completing the task?
Choose 1 answer.
A. Use the Object Manager to build and visualize the data model
B. Use the Object Manager to build the data model and use the Schema Builder to visualize it
C. Use the Schema Builder to build and visualize the data model
D. Use the Schema Builder to build the data model, and use the Object Manager to visualize it

A

C. Use the Schema Builder to build and visualize the data model
Schema Builder is a tool, which can be accessed from Setup, that allows visualizing and editing a data model. Building custom objects, fields, and relationships can be performed in one interface
without the need to switch from one page to another.

61
Q

Global Containers has a requirement to conduct a daily data backup. Which of the following is most suitable for achieving the task?
Choose 1 answer.
A. Use the Data Export service in Setup
B. Use the Data Loader command line
C. Use the Data Loader Ul to set a schedule
D. Use the Export button in Report Builder

A

B. Use the Data Loader command line

62
Q

When would an ETL (extract, transform, load) solution be preferable than using external objects and Salesforce Connect?
Choose 3 answers.
A. Workflow is required on the data
B. Validation rules are required on the data
C. Some external object fields need to be hidden for certain profiles
D. Different record types are required for the data
E. Visualforce pages need to be created with external data

A

A. Workflow is required on the data
B. Validation rules are required on the data
E. Visualforce pages need to be created with external data
There are a number offeatures, including workflow rules, validation rules and record types, that are not available or fully supported for external objects. However, Visualforce pages and field-level
security are supported by external objects. On the other hand, if an E TL solution is used, then it would allow storing the data in custom objects within Salesforce, which support features like
workflow rules, validation rules, and record types.

63
Q

A Salesforce Administrator wants to change the field type of a custom field from Text to Auto-Number. Which of the following should be considered before the field conversion?
Choose 1 answer.
A. lt is not possible to convert a text field into an auto-number field without losing data
B. Any record that contains more than 30 characters in the text field should be changed
C. Salesforce does not allow converting any type of custom field into an auto-number field
D. The text field value Will be automatically truncated beyond 30 characters after conversion

A

B. Any record that contains more than 30 characters in the text field should be changed
A custom text field can be converted into an auto-number field as long as the ‘textfield’ character limit Will be changed to 30 characters. Otherwise, the conversion Will not be allowed to proceed.
As a best practice, any record that exceeds the number of characters in that field should be modified to meet the auto-number field’s 30-character length limit, but it is not required. When
successfully converted, the field values Will be preserved.

64
Q

A Salesforce Administrator has set up two record types for both Leads and Opportunities, namely, ‘Hardware’ and ‘Software’, to differentiate between the business processes used for hardware and software products sold by the company. A profile has access to both the record types of the Opportunity object, with the default record type set as ‘Hardware’. If a user with that profile owns a lead with the ‘Software’ record type and converts it into an opportunity, what Will be the result?
Choose 1 answer.
A. The outcome depends on how the ‘Record Type’ field has been mapped in field mapping.
B. An option to choose which record type to use will be provided when converting the lead.
C. A new opportunity will be created using the ‘Software’ record type automatically.
D. A new opportunity will be created using the ‘Hardware’ record type automatically.

A

B. An option to choose which record type to use will be provided when converting the lead.
During lead conversion, if the user converting the lead record has access to both the Opportunity record types, then the conversion page displays a picklist option to choose between the two
record types, with the default record type of the profile appearing as the option selected by default.
Only when the user has access restricted to just one record type, then that record type is selected and cannot be edited. Also, only custom fields can be included in the field mapping and not the
standard ‘Record Type’ field.

65
Q

As an opportunity moves through different sales stages, different information is required on its detail page. Users should not be able to save an opportunity without entering the required information pertaining to its stage. What is the best way to meet this requirement?
Choose 1 answer.
A. Create a Visualforce page that is dynamically updated based on the sales stage
B. Use validation rules to ensure that the required information is captured at each sales stage
C. Group the information by multiple sections pertaining to the sales stages on the page layout
D. Use record types with different page layouts

A

B. Use validation rules to ensure that the required information is captured at each sales stage
Record types can be used with different page layouts, but this is more suitable when there are multiple types of opportunities and the information captured is different for each one. If different information is required at different stages, validation rules that reference the ‘Stage’ field could be used.

66
Q

Mark Jones is the Finance Director at Global Insurance. Global Insurance is the account on his contact record. He is also the Executive Facilitator at Fin Tech Corporation and needs to be added to the Fin Tech Corporation account record as a contact. How would this be represented in Salesforce if the ‘Contacts to Multiple Accounts’ feature is enabled?
Choose 1 answer.
A. Mark would be an affiliated contact at both organizations
B. Mark would be a direct contact at both Global Insurance and FinTech Corporation
C. Mark would be the indirect contact at Global Insurance and direct contact at FinTech Corporation
D. Mark would be a direct contact at Global Insurance and indirect contact at FinTech Corporation

A

D. Mark would be a direct contact at Global Insurance and indirect contact at FinTech Corporation
Mark would be a direct contact at Global Insurance as it is the account on his contact record. He would be an indirect contact at FinTech Corporation as he is related to it.

67
Q

For an e-commerce company selling to individuals, which of the following should be recommended for storing customer information?
Choose 1 answer.
A. Business Accounts
B. Person Accounts
C. Partner Accounts
D. Contacts

A

B. Person Accounts
Business accounts and person accounts both use the Account object. After “Person Accounts” is enabled in an org, a “ person account” account record type is created. Person accounts are used to
store information about individual people in a B2C, or business-to-consumer, business model.
Partner Accounts are accounts used to manage partner organizations, partner users, and activities when using a partner community or partner portal. Contact records are used to relate contacts
to business accounts.

68
Q

If a company is selling only to businesses, which features of Salesforce would be used?
Choose 2 answers.
A. Business Accounts
B. Private Contacts
C. Person Accounts
D. Contacts

A

A. Business Accounts
D. Contacts
When selling only to businesses, customer information is stored in Accounts. Accounts are the companies that business is done with. Contacts are the people that work for them and are related to
the Accounts in Salesforce. Private contacts are contacts that are not related to an account and are only visible to the owner and the Salesforce admin.

69
Q

A certain Salesforce org has three custom objects, namely, Programs, Projects, and Tasks. Programs can have a number of related projects, and a Project can have a number of related tasks. Master-detail relationships are used to link the objects. The total number of tasks under a program needs to be determined. How should this requirement be achieved?
Choose 1 answer.
A. Create a roll-up summary field on the Program object that rolls up tasks
B. Create a record-triggered flow on the Task object to update the Program record
C. Create roll-up summary fields on the Project and Program objects
D. Create an Apex trigger on the Task object to update the Program record

A

C. Create roll-up summary fields on the Project and Program objects
A master object cannot directly roll up fields on a sub-detail or grandchild object. To achieve this, a roll-up summaryfield must be defined on the detail object to summarize field information on the
sub-detail object, and another roll-up summary field must be defined on the master object to summarize field information on the detail object.
An Apex trigger is not required since a declarative solution is available. Although a record-triggered now is capable of this functionality, using it is also not necessary since roll-up summary fields
can be used to meet the requirement.

70
Q

A Salesforce administrator is not able to change the field type of a custom field. What could be possible reasons?
Choose 3 answers.
A. The field is referenced in a list view
B. The field is referenced by a flow
C. The field is set as an external ID
D. The field is referenced in Apex or a Visualforce page
E. The field is referenced in Process Builder

A

B. The field is referenced by a flow
D. The field is referenced in Apex or a Visualforce page
E. The field is referenced in Process Builder
lt is not possible to change the data type of a custom field that is referenced by other items in Setup, like Visualforce pages, Apex code, Process Builder, or flows.
The data type of a field that is referenced in a list view or set as an external ID can be changed.

71
Q

Which of the following are standard capabilities of the Lead object?
Choose 2 answers.
A. Leads can be automatically assigned to users or queues
B. Queues can be created to prioritize and assign leads to marketing or sales teams
C. The administrator can map standard or custom lead fields to fields on the Account, Contact, and Opportunity objects as part of lead conversion
D. Custom object records that have been related to a lead can be copied when a lead is converted to an account, contact and/or opportunity

A

A. Leads can be automatically assigned to users or queues
B. Queues can be created to prioritize and assign leads to marketing or sales teams
Lead queues can be created to prioritize and assign lead records to support agents. Lead Assignment Rules can be set up to assign leads automatically.
Only custom fields can be mapped as part of lead conversion. Salesforce automatically maps standard lead fields to standard account, contact, and opportunity fields; this standard mapping cannot
be changed. Records of related objects cannot be copied when a lead is converted.

72
Q

A sales manager often finds that a contact has a relationship with multiple companies and would like to keep track of these relationships. How can a Salesforce Administrator enable this?
Choose 2 answers.
A. Create a cross-object formula on the Contact object to add related accounts in the Related Accounts section
B. Enable the ‘Contacts to Multiple Accounts’ feature
C. Add the Related Accounts related list to the Contact page layout, add the Related Contacts related list on the Account page layout, and remove the existing Contact related list on the Account page layout
D. Add the Related Accounts related list to the Contact page layout and update the existing Contacts related list on the Account page layout

A

B. Enable the ‘Contacts to Multiple Accounts’ feature
C. Add the Related Accounts related list to the Contact page layout, add the Related Contacts related list on the Account page layout, and remove the existing Contact related list on the Account page layout
In order to allow multiple accounts to be associated with a contact, the ‘Contacts to Multiple Account’ feature must be enabled. After the feature has been enabled, the Related Accounts related list must be added to the Contact page layout and the Related Contacts related list added to the account page layout. The existing Contacts related list on the Account object can be removed as
the Related Contacts related list Will include direct and indirect contacts.

73
Q

TODO: Entender bien
Spotless Cleaning Equipment would like to track the parts that are most often faulty when a technician conducts field repair on cleaning equipment. The company uses Work Orders and Work Order Line Items in Salesforce to track work to be performed for a customer. How should this requirement be met?
Choose 1 answer.
A. Record the faulty part in a custom field on the Work Order object
B. Create a Work Order linked to the Asset for the faulty part
C. Create a Work Order Line Item linked to the Asset for the faulty part
D. Parts cannot be recorded in Salesforce

A

C. Create a Work Order Line Item linked to the Asset for the faulty part
A work order would need to be created and linked to the faulty cleaning equipment. An asset can be specified using a lookup relationship field while creating a work order line item associated with a work order. An asset hierarchy can be created with the parts that make up the equipment, and the faulty part could be linked to a work order line item.

74
Q

Which of the following is true regarding Person Accounts?
Choose 2 answers.
A. Person Accounts have the same fields as a business account
B. Person accounts can be merged with all types of accounts.
C. Person Accounts do not have an account hierarchy
D. Once Person Accounts are enabled they cannot be disabled

A

C. Person Accounts do not have an account hierarchy
D. Once Person Accounts are enabled they cannot be disabled
Person Accounts once enabled cannot be disabled. When creating a new account, the type of account must be selected. Person accounts can only be merged with person accounts. The fields of a
person account are made up of fields from the Account and Contact objects.

75
Q

Cool Air Conditioners has been using the Case object in Salesforce to manage issues faced by customers. The company would also like to use Salesforce to manage field service jobs performed for customers by technicians. They would like to track information about the tasks performed for the customers. What is the recommended solution to meet this requirement?
Choose 1 answer.
A. Install an AppExchange solution that adds the required functionality.
B. Create a custom object to manage field service jobs.
C. Utilize the standard objects Work Order and Work Order Line Item.
D. Create an external field service application and use REST API to integrate it with Salesforce.

A

C. Utilize the standard objects Work Order and Work Order Line Item.
Two standard objects in Salesforce, namely, Work Order and Work Order Line Item, can be used to track the field service work performed for customers. A work order can have related work order
line items that represent the subdivisions or tasks to be completed.
In orgs that don’t have the Field Service add-on license, an option to enable Work Orders is available.
Installing an AppExchange application or creating a custom object is unnecessary to meet the requirement since standard objects are readily available. Creating an external application and
integrating it with Salesforce is also not required.

76
Q

A restricted picklist has been defined on a field. When loading data via Data Import Wizard or Data Loader, what Will happen if the data import file contains a picklist value that does not match one of the defined values?
Choose 1 answer.
A. The default value for the field Will be used
B. The field value Will be set to null
C. The new value Will be added to the list ofvalid picklist values
D. An error Will be reported for the record

A

D. An error Will be reported for the record
Picklists can be defined as restricted, unrestricted, or use a global value set. Picklists that use a global value set are always restricted. Restricted picklists require the value to be one of those listed
in the field definition. If a value for a restricted picklist field in an import file does not match one of the defined values, the record Will not be imported and a “bad value for restricted picklist field”
error message Will be returned.
Note: The default values Will only apply if the field was not mapped to any file header during the import.

77
Q

A Salesforce developer is explaining to another developer, who is not familiar with Salesforce, how an External ID field can be used to work with data coming from another system. Which of the following options are features that can be mentioned?
Choose 3 answers.
A. A standard field can be marked as an External ID
B. An external ID is used to represent an identifier for a record from an external system
C. An external ID can either be a text, number, or email field
D. An external ID is indexed and increases query performance
E. An external ID can never be case-sensitive

A

B. An external ID is used to represent an identifier for a record from an external system
C. An external ID can either be a text, number, or email field
D. An external ID is indexed and increases query performance
Fields that are marked as external IDs are indexed which can be used in selective filters for optimizing queries. Custom text, number, or email fields support the External ID attribute. External ID
fields are designed to contain record IDs that belong to an external system and are typically used for matching external records via upsert calls in data import operations.
Standard fields do not support the External ID attribute. External IDs can be optionally configured as case-sensitive by marking the field as unique and specifying the proper “Is Case Sensitive”
option.

78
Q

Global Systems wants to capture some additional information while selling to accounts that belong to government authorities. Which of these steps represent the best solution?
Choose 2 answers.
A. Define a separate account page layout for government accounts
B. Create a record type to identify government accounts
C. Create validation rules for the account fields specific to government accounts
D. Create a custom object called ‘Government Accounts’

A

A. Define a separate account page layout for government accounts
B. Create a record type to identify government accounts
Record types allow offering different business processes, picklist values, and page layouts to different users.

79
Q

A sales rep of Cosmic Electronics is required to import contacts in Salesforce using a CSV file. The sales rep should be able to import the records using a guided process and a simple data-mapping interface. Which option should be enabled in Salesforce Setup for this use case?
Choose 1 answer.
A. Basic Data Import
B. Data Loader
C. Contact Import
D. Data Import Wizard

A

A. Basic Data Import
Basic Data Import can be turned on in Salesforce Setup to give sales reps access to a guided process for importing contacts and leads using a CSV file and a simple data-mapping interface. Data
Import Wizard and Data Loader are more suitable for large or complex import jobs or to import data for other objects, such as Account and custom objects. There is no import option called
‘Contact Import’.

80
Q

Global Containers has defined a custom object to track shipments. Now the company wants to store which truck is used for handling a particular shipment. However, there are only 5 trucks, and there is no plan to buy or sell any trucks in the future. What can be done to meet this requirement?
Choose 1 answer.
A. Define ‘Trucks’ as a formula field
B. Define ‘Trucks’ as a custom object
C. Define ‘Trucks’ as a text field
D. Define ‘Trucks’ as a picklist field

A

D. Define ‘Trucks’ as a picklist field
Since there is not going to be any addition or removal of trucks, a picklist field can be defined on the ‘Shipment’ object to note which truck was used
Salesforce Reference Link

81
Q

A Salesforce Administrator would like to use the Data Loader to create several User records. Which of the following User fields are required for inserting Users via the Data Loader?
Choose 3 answers.
A. Email
B. Role
C. Company
D. Username
E. Profileld

A

A. Email
D. Username
E. Profileld
The followingfields are required when inserting Users via the Data Loader: Alias, Username, Email, First Name, Last Name, Locale (LOCALESIDKEY), Language (LANGUAGELOCALEKEY), Email Encoding (EMAILENCODINGKEY), Time Zone (TIMEZONESIDKEY), Currency (CURRENCYISOCODE), and Profileld.

82
Q

Cosmic Computers has a custom field of ‘Number’ type on the Account object to store the probability of a future sale. The Salesforce Administrator has been asked to change the type of this field to ‘Percent’. What are some valid considerations regarding this change?
Choose 3 answers.
A. Changing the data type of this field can cause data loss
B. If data is lost, any list view based on the custom field is not affected
C. lt is not possible to change the data type if the field is mapped for lead conversion
D. If the field is referenced by Apex, its data type can still be changed
E. The request for changing the field type may be queued

A

A. Changing the data type of this field can cause data loss
C. lt is not possible to change the data type if the field is mapped for lead conversion
E. The request for changing the field type may be queued
Only custom fields for which no data exists should be converted or there may be a risk of data loss. Data can be lost when changing to ‘Percent’ from any other type. If data is lost, any list view
based on the custom field is deleted. The data type of any custom field that is mapped for lead conversion cannot be changed. If a custom field is referenced by other items in Setup, such as Apex
code, Visualforce, Process Builder, or flows, its data type cannot be changed. Since changing the data type may require changing many records at once, the request may be queued.

83
Q

A Salesforce administrator is encountering difficulties while attempting to convert a lookup relationship into a master-detail relationship. Which of the given options represent potential reasons?
Choose 3 answers.
A. Not all records have a value in the lookup field
B. The lookup field is not marked as required
C. The lookup field has an active lookup filter and needs to be deactivated
D. The object has reached the allowed number of master-detail relationships
E. There is already a master-detail relationship between the same two objects

A

A. Not all records have a value in the lookup field
D. The object has reached the allowed number of master-detail relationships
E. There is already a master-detail relationship between the same two objects
A lookup relationship field cannot be converted to a master-detail relationship field if there are existing records on the object that have a null value set for the lookup field. Only two master-detail
relationships per object is allowed. If a master-detail relationship already exists for the same object, the option to select the master-detail relationship field type Will be disabled.
Marking a field as required or removing an active filter from a field is not necessary when converting a lookup relationship field to a master-detail relationship field.

84
Q

Global Containers plans to start using Lead Management in Salesforce. What standard capabilities of the Lead object could they make use of?
Choose 3 answers.
A. Lead Update Reminders
B. Lead Conversion to Account and Contact
C. Lead Conversion to Opportunity
D. Email-to-Lead
E. Web-to-Lead

A

B. Lead Conversion to Account and Contact
C. Lead Conversion to Opportunity
E. Web-to-Lead
Email-to-Lead and Lead Update Reminders are not standard functionalities of the Lead object.
Objective: Data Modeling and Management
Detailed Objective: Given a scenario, determine the appropriate data model.

85
Q

A global retailer is implementing a Quick Buy feature, where customers are allowed to store their credit card information for future purchases. Credit card information is sensitive in nature.
However, the call center agents need to use the last 4 digits of the card for authentication purposes. What is the best way to model this in Salesforce?
Choose 1 answer.
A. Set field-level security to ‘private’ for the Call Center Agent profile
B. Create a Visualforce page that masks credit card information
C. Maintain a copy of the last 4 digits in another field
D. Create the credit card information field as a ‘Text (Encrypted)’ field

A

D. Create the credit card information field as a ‘Text (Encrypted)’ field
Text (Encrypted) fields allow users to store sensitive data in encrypted form and apply a mask when the data is displayed, for example, credit card number can be displayed as follows: XXX-XXX-1234

86
Q

Which is true regarding person accounts in Salesforce?
Choose 2 answers.
A. Person accounts cannot be related to Contacts
B. Person accounts do not have a ‘Parent Account’ field
C. Person accounts do not support the Account Hierarchy feature
D. Person accounts cannot be enabled by Admins

A

A. Person accounts cannot be related to Contacts
B. Person accounts do not have a ‘Parent Account’ field
Person accounts do not have the Parent Account field and do not support the ‘Account Hierarchy’ feature.
The ‘Contacts to Multiple Accounts’ feature can be used to create indirect relationships between a person account and a contact.
A Salesforce Administrator can check a box in Account Settings to ‘Allow Customer Support to enable Person Accounts’.

87
Q

What should be done before changing a field type?
Choose 3 answers.
A. Back up the data in the object
B. Check if the field is the target of a workflow field update or formula
C. Check if the field is marked as ‘Required’
D. Check if the field is marked as ‘Unique’
E. Check if the field is mapped for lead conversion

A

A. Back up the data in the object
B. Check if the field is the target of a workflow field update or formula
E. Check if the field is mapped for lead conversion
Data should be backed up since data loss or truncation may occur when changing the field type. A workflow field update or formula could be invalidated if a field type is changed. The data type of a
custom field that is mapped for lead conversion cannot be changed.

88
Q

While designing your application, you have determined that you could use a dependent picklist to ensure that the values selected in two picklist fields are valid. What do you need to keep in mind in relation to dependent picklists?
Choose 3 answers.
A. Standard picklist fields can be either controlling fields or dependent fields.
B. Custom picklist fields can be either control ling fields or dependent fields.
C. A multi-select picklist cannot be a controlling field.
D. Checkbox fields can be either controlling fields or dependent fields.
E. There is a maximum number of values allowed in a controlling field.

A

B. Custom picklist fields can be either control ling fields or dependent fields.
C. A multi-select picklist cannot be a controlling field.
E. There is a maximum number of values allowed in a controlling field.
Standard picklist fields can be controlling fields but not dependent fields. Checkbox fields can be controlling fields but not dependent fields. The maximum number ofvalues allowed in a controlling
field is 300.

89
Q

TODO: Entender mas
Global Containers is planning to use two custom objects to track vehicle and cargo data. A vehicle can transport multiple cargo containers, while a cargo container is always associated with one vehicle. The company decommissions certain vehicles if they do not pass the quality checks; such vehicle records are deleted. In addition, it is mandatory to keep the history of all cargo data for compliance purposes. What would be recommended for defining the data model for these custom objects?
Choose 1 answer.
A. Define a lookup relationship field on the ‘Cargo’ object that references the ‘Vehicle’ object.
B. Define a master-detail relationship field on the ‘Vehicle’ object that references the ‘Cargo’ object.
C. Define a lookup relationship field on the ‘Vehicle’ object that references the ‘Cargo’ object.
D. Define a master-detail relationship field on the ‘Cargo’ object that references the ‘Vehicle’ object.

A

A. Define a lookup relationship field on the ‘Cargo’ object that references the ‘Vehicle’ object.
Lookup relationships connect two objects in a parent-child relationship. However, they do not establish the cascade-delete behavior by default. In this case, Cargo would need to be the child
object of the Vehicle. The lookup relationship field to Vehicle would be added on the Cargo object.
In the lookup relationship, ‘Clear the value of this field’ can be selected to ensure that a Cargo record is retained even if the related Vehicle record is deleted.

90
Q

TODO: Entender mas
Mary is a Salesforce administrator who is considering various requirements for managing customers. Which standard account features could she make use of?
Choose 3 answers.
A. Tracking the team that works on a customer account
B. Relating customers in a hierarchy
C. Automatically updating the customer’s credit rating
D. Specifying the part that a person plays in an organization
E. Creating an internal organizational chart for the account

A

A. Tracking the team that works on a customer account
B. Relating customers in a hierarchy
D. Specifying the part that a person plays in an organization
Automatically updating an account credit rating is not a standard account feature. Relating customers in a hierarchy means linking different account records to one another. An account may have
one or more subsidiary or supervisory organizations, but they’re all external with regard to the account.
On the other hand, an internal organizational chart shows how the people in an organization are related to one another. For example, it could show the director acting as the supervisor for
managers in different departments.
The Contacts hierarchy feature makes this somewhat possible in Salesforce, but as the name suggests, it is a standard feature available for the Contact object. Contact roles specify the part that
each contact plays in an account, case, contract, or opportunity.

91
Q

TODO: Entender bien
Global Containers needs to view the margin of a product on the Opportunity Line Item by calculating the Sales Price minus the Product Cost. The Product Cost value fluctuates over time and is stored in a custom field on the Product object. If the opportunity is closed then there should not be anyfurther change in the value of the margin. What would be the recommended way to meet this requirement?
Choose 1 answer.
A. Create a custom field on the Opportunity Line Item object to store the value of the cost and use a formula field to calculate the margin.
B. Create a formula field that obtains the value of the Product Cost custom field from the Product record and use another formula field to calculate the margin.
C. Create one formula field that references the cost field on the Product object and the Sales Price in the Opportunity Line Item object.
D. Create an Apex trigger on Opportunity to calculate the margin of Opportunity Line Items.

A

A. Create a custom field on the Opportunity Line Item object to store the value of the cost and use a formula field to calculate the margin.
To calculate the margin of a product, the Product Cost is subtracted from the Sales Price on the Opportunity Line Item. Since the Product Cost changes over time and formula fields fetch values at
run-time, a formula field cannot be used to extract the Product Cost as its value is not fixed. Instead, a custom field on the Opportunity Line Item should be created, and populated with the Product
Cost value when the opportunity is closed. A formula field can then be created on the Opportunity Line Item that calculates the product margin.
Programmatic customization is not recommended when a declarative tool can meet the requirement. In addition, two formula fields are not necessary for this requirement.

92
Q

Which of the following are true with regard to changing the field type of a custom field?
Choose 2 answers.
A. To change the field type of a custom field, the data must be backed up, and the custom field must be deleted and recreated with the new data type
B. Changing the field type of a custom field Will always result in data loss
C. Changing the field type may result in data truncation
D. Changing the field type of a custom field may result in data loss

A

C. Changing the field type may result in data truncation
D. Changing the field type of a custom field may result in data loss
Changing the field type can result in data loss or truncation depending on the situation.

93
Q

A Salesforce administrator is required to define a custom field on the User object that would record a user’s secondary manager in a matrix organizational structure. Which relationship type should be used to achieve this?
Choose 1 answer.
A. Master-detail
B. Lookup
C. Hierarchical
D. None of these options

A

C. Hierarchical
Lookup and master-detail relationships are not available on the User object. The User object can only be linked with itself, which is possible by using a hierarchical relationship.

94
Q

Which of the following statements about master picklists are true?
Choose 2 answers.
A. The master picklist contains possible values for all record types
B. Values added to the master picklist are always added to each record type
C. The master picklist is the list of picklist values for the master record type
D. Values added to the master picklist can optionally be added to each record type

A

A. The master picklist contains possible values for all record types
D. Values added to the master picklist can optionally be added to each record type
The master picklist is a regular picklist field on an object which uses multiple record types and contains the complete set of values that can be used in any of the object’s record types. When adding
new values in a master picklist, an option is provided to add the values to selected record types. When configuring a record type, the picklist and its values can be selected from the values available
on the master picklist.

95
Q

If a user does not have a certain record type assigned in their profile, which of the following is true?
Choose 1 answer.
A. The user will not be able to select the record type when creating records
B. The user will not be able to access records of the record type
C. The user will not be able to edit records of the record type
D. The user will not be able to delete records of the record type

A

A. The user will not be able to select the record type when creating records
The user Will not be prompted with an option to select the record type when creating a record. The default record type Will be automatically used for the new record.
Users can view records of any record type even if the record type is not associated with their profile. The ability to edit and delete records is controlled by object level permissions.

96
Q

Which of the following is true about enabling the ‘Roll Up of Activities to a Contact’s Primary Account’ feature in Activity Settings?
Choose 1 answer.
A. Activity field values can be aggregated and rolled up in a custom field on the primary account.
B. All tasks and events are assigned to the record owner of the contact’s primary account.
C. By enabling the roll-up activities feature, both new and existing activities are affected.
D. Related tasks and events of the contact are displayed on the contact’s primary account.

A

D. Related tasks and events of the contact are displayed on the contact’s primary account.
When activities roll-up is enabled via the Activity Settings in an org, activities related to the contact Will also be displayed in the primary account of the contact.
Activity details related to the contact Will always be displayed in the activity feed of the contact, whether or not the activities roll-up feature is enabled. Tasks and events related to the contact
cannot be automatically assigned to the account owner using this feature. Activity field values cannot be aggregated at the related account record using this option. When the roll-up activities
setting is changed, only the new activities are affected. Existing activities are only affected if they are updated in a way that triggers a recalculation of the roll-up, e.g. when an activity is closed

97
Q

Global Insurance Will use Salesforce to collect lead information from different sources. The information collected about a lead Will vary greatly depending on if the lead is interested in life insurance
or business insurance. Which of the following Salesforce features can be configured for this requirement?
Choose 1 answer.
A. Record Types
B. Visualforce Pages
C. Custom Objects
D. Tab Settings

A

A. Record Types
Record Types can be used to display different picklist values and page layouts for different types of leads depending on the business requirements. Visualforce page can be created to meet the
requirement but a declarative solution (in this case record type) is always preferred if available. A custom object does not have to be created in order to separate the information between two
types of leads. Tab settings can be used to configure the tab visibility per profile.

98
Q

A financial institution would like to share and collaborate on files, publish the best and most relevant content, and track it all in real-time. How could this be achieved?
Choose 1 answer.
A. Create a new custom object to track the files.
B. Create a custom application for content.
C. Use the standard Documents functionality.
D. Use Files and Libraries.

A

D. Use Files and Libraries.
Salesforce Files and Libraries give users the ability to share and collaborate on files, publish the best and most relevant content, and track it all in real-time. The File tab is where users can store
files privately, manage version updates, organize files, and follow files.
There is no need to create a custom object or custom application for the requirement.

99
Q

What Will happen to a roll-up summary field when attempting to convert a master-detail relationship to a lookup relationship?
Choose 1 answer.
A. Nothing, as the roll-up summary field Will not be affected after the conversion
B. The roll-up summary field Will be deleted as long as it’s not referenced in any formula field
C. The roll-up summary field Will be converted to a Number field
D. Nothing, as the conversion to the lookup relationship Will not be allowed

A

D. Nothing, as the conversion to the lookup relationship Will not be allowed
If a roll-up summary field exists on the master object in a master-detail relationship, converting the relationship type to a lookup relationship Will not be allowed. Therefore, no changes Will happen
to the roll-up summary field since the conversion is not possible.

100
Q

TODO: Entender mas
Global Containers plans to run a direct mail promotion and needs to add campaign members. What are the standard capabilities available to add campaign members?
Choose 3 answers.
A. Add related leads from the account detail page
B. Add a related contact from a case detail page
C. Add contacts, leads, or person accounts from a report
D. Add contacts, leads, and person accounts individually from their record page
E. Import leads and contacts from a CSV file

A

C. Add contacts, leads, or person accounts from a report
D. Add contacts, leads, and person accounts individually from their record page
E. Import leads and contacts from a CSV file
Campaign members can be added to a campaign by importing leads or contacts from a CSV file. Contacts, leads, and person accounts can be added to a campaign as campaign members by clicking
on the ‘Add to Campaign’ button available in the Campaign History related list or ‘Add to Campaign’ action on each record page. In Reports, the option to Add to Campaign can be found in a
report’s dropdown menu.
Contacts cannot be added to a campaign from the Case detail page. Leads are not associated with an Account.

101
Q

Which of the following statements is true regarding the use of an external ID field for matching records in the Data Import Wizard?
Choose 1 answer.
A. Matching by external ID is only available for custom objects
B. Matching by external ID is available for custom objects and some standard objects
C. When multiple external ID fields exist, the too’ automatically selects the field for matching
D. Matching by external ID is only available when importing solutions

A

B. Matching by external ID is available for custom objects and some standard objects
Matching by external ID is available for supported standard objects in Data Import Wizard such as Accounts & Contacts, Leads, Solutions, and Campaign Members as well as custom objects.
If an object has multiple external ID fields, the field to match by can be selected by a user.

102
Q

A Salesforce Administrator is assigned to import 10,000 accounts into an org. Which of the following Salesforce features can the Salesforce Administrator use in order to achieve the task and prevent duplicate records from being created during the data import?
Choose 2 answers.
A. Use Data Import Wizard and set the ‘Match Account by’ option accordingly.
B. Define the matching rules and duplicate rules for the Account object.
C. Use Data Loader and set the ‘Match Account by’ option accordingly.
D. Define the criteria in the ‘Duplicate Prevention Rules’ for the Account object.

A

A. Use Data Import Wizard and set the ‘Match Account by’ option accordingly.
B. Define the matching rules and duplicate rules for the Account object.
The Data Import Wizard can be used to prevent duplicate records during an import by using its ‘Match Account by’ setting to match records, for example, by their ‘Name & Site’ fields. Meaning, if
the same Name and Site field values already exist in another record, then the current record is a duplicate. Salesforce also provides matching rules to control how duplicate records are identified
and duplicate rules to determine what actions to take whenever duplicates are caught.
Data Loader does not provide a ‘Match Account by’ option. A ‘Duplicate Prevent Rules’ setting does not exist.

103
Q

Which field type would be appropriate to use for a requirement to record the opening and closing hours for store locations?
Choose 1 answer.
A. Business Hours
B. Hours
C. Time
D. Date/Time

A

C. Time
The Time field type can store a time value that is not bound to a date. A time of day can be selected. In this case, two time fields would be created; one for opening hours and one for closing hours.

104
Q

Which of the following capabilities are provided by the core CRM objects in the Salesforce schema?
Choose 3 answers.
A. Recording customer feedback, problems or questions
B. Tracking sales deals and pipelines
C. Tracking customer invoices
D. Tracking prospective customers
E. Recording time spent on projects in timesheets

A

A. Recording customer feedback, problems or questions
B. Tracking sales deals and pipelines
D. Tracking prospective customers
Sales deals and pipelines are tracked in opportunities. Cases can track customer feedback, questions and problems. Leads track and record prospective customers.

105
Q

Record types have been defined on the Account object. What does this mean?
Choose 2 answers.
A. Different users can be assigned to each record type
B. Different page layouts can be assigned for each record type
C. Different fields can be defined for each record type
D. Different picklist values can be defined for each record type

A

B. Different page layouts can be assigned for each record type
D. Different picklist values can be defined for each record type
Record types allow a different set of picklist values to be defined per record type, as well as different page layouts. Record types are assigned to profiles, not users.

106
Q

At Cosmic Chemicals, only the users assigned to the Sales and Account Manager profiles can create accounts with the “Industrial applications” record type. However, five sales reps should be able to create accounts with this record type. Which solution would best fit this requirement?
Choose 1 answer.
A. Assign the 5 sales reps to the Sales Manager profile.
B. Change the 5 sales rep’s role to Sales Manager.
C. Create a permission set and assign the 5 sales reps to it.
D. Create a criteria-based sharing rule and assign the 5 sales reps to it.

A

C. Create a permission set and assign the 5 sales reps to it.
A user’s assignment to a record type does not determine his/her access to records with that record type and vice versa. Roles or sharing rules cannot be used to assign a record type to users. A
record type can be assigned to users via Profiles or Permission Sets. Changing the profile of a number of users is not practical if they only need additional access to a specific record type. In this
case, a new permission set can be used to grant additional access to certain users without compromising existing data sharing settings.

107
Q

Which of the following are required to model a many-to-many relationship between two custom objects?
Choose 2 answers.
A. Hierarchical relationship
B. Junction object
C. Master-detail relationship
D. Lookup relationship

A

B. Junction object
C. Master-detail relationship
Master-detail relationships are used to model many-to many relationships between two objects. Ajunction object is a custom object with two master-detail relationships and is used to connect
the two objects that are related to each other.
Both of these are necessary to build a many-to-many relationship between two custom objects. A junction object is a custom object used to connect the two objects that should have the many-to
many relationship. The junction object contains a Master-Detail field for each of the two objects. In each ofthese fields, one of the objects in the many-to-many relationship is the “Master” and the
junction object is the “Detail.”
A lookup relationship does not have to be populated and therefore cannot be used to a connection to both objects on a junction object. A hierarchical relationship is only for the user
object and allows for the creation of a reporting structure within the user object.

108
Q

TODO: Entender mas
A Customer Service agent has received a call regarding a printer that needs repair. A technician needs to visit the customer to fix it. How can this information be stored in Salesforce?
Choose 1 answer.
A. Create an Asset linked to a Case
B. Create a Case Product linked to a Case
C. Create an Order Product linked to the customer’s Asset
D. Create a Work Order linked to the customer’s Asset

A

D. Create a Work Order linked to the customer’s Asset
Work orders can be used to store information related to work that needs to be performed in the field for a customer by a technician. A work order can be linked to standard and custom objects. In
this case, a work order could be created and linked to the customer’s asset.

109
Q

Different kinds of resources need to be assigned to several departments in an organization. The resource types are laptops, tablets, and phones. Although the different types of resources share common fields such as the serial number and purchase date, they also have fields that are unique to each type. Which of the following can be done to appropriately implement the requirements?
Choose 2 answers.
A. Use one record type and create two custom objects
B. Create one custom object and use record types
C. Use one standard object and use record types
D. Create a custom object for each resource type

A

B. Create one custom object and use record types
C. Use one standard object and use record types
If the resource types both have common and unique fields, a custom object can be created, and record types can be used to display a dedicated page layout for each resource type. Alternatively,
the standard Asset object can be used for tracking the resources, which are used internally.
Assets are used for tracking actual products or services that customers of a company (and even from its competitors) have purchased and installed. However, it can also be used to track assets, as
resources, that are used internally by the company. These assets can be identified by using the ‘Internal Asset’ checkbox field available on the object.

110
Q

An administrator needs to link two objects in a one-to-many relationship in Salesforce. Which of the following considerations are valid while trying to choose between lookup and master-detail relationship?
Choose 3 answers.
A. In a master-detail relationship, the parent object controls the security and sharing of the child records
B. In a lookup relationship, deleting the parent record always deletes related child records
C. In a master-detail relationship, the master object can only be a standard object
D. The master-detail relationship field is always required on the page layout of the child object
E. lt is possible to not allow deletion of the lookup record that is part of a lookup relationship

A

A. In a master-detail relationship, the parent object controls the security and sharing of the child records
D. The master-detail relationship field is always required on the page layout of the child object
E. lt is possible to not allow deletion of the lookup record that is part of a lookup relationship
In a master-detail relationship, the master or parent object controls the security and sharing of detail or child records. The master object can be either a sta
detail relationship field is always required on the page layouts of related detail and subdetail records.
In a lookup relationship, deleting the parent record does not always delete related child records, unless the lookup field is optional and this behavior has be
contacted to enable visibility of this option. Another possible behavior is not allowing the deletion of the lookup record that is part of a lookup relationship.

111
Q

TODO: Entender mas
Global Insurance is using a custom object to record Insurance Policy Applications. For travel insurance applications, the country and duration of stay are required. For life insurance applications, these fields should be hidden as they are not applicable. The users have read access to all ‘Insurance Policy Application’ fields. Which features should be used to meet this requirement?
Choose 2 answers.
A. Record types
B. Field-level security
C. Permission sets
D. Page layouts

A

A. Record types
D. Page layouts
Record types could be defined for different types of insurance applications. A different page layout could be used for each application record type to show the appropriate fields and make them
required at the user interface.
Field-level security defines access to fields at the user level. If the field-level access was removed, the users Will not be able to access the field even though the field is in the page layout. Permission
sets are used to extend permissions to specified users.

112
Q

Which of the following types of fields do not support changing the data type?
Choose 2 answers.
A. Formula
B. Text (Encrypted)
C. Text Area (Rich)
D. External ID field

A

A. Formula
B. Text (Encrypted)
Formula and encrypted fields cannot be changed to another data type.
The Formula field type is ‘read-only’. lt cannot be converted to another data type because it can only obtain its value from a defined formula expression. Similarly, the Text (Encrypted) field has
identical standard behavior in terms of changing field types since it is a special data type that uses the classic encryption algorithm.

113
Q

A Salesforce Administrator is having trouble converting a master-detail relationship into a lookup relationship. What could be the possible reason?
Choose 1 answer.
A. The relationship field is marked as required
B. There is already a lookup relationship with the same object
C. The object has reached the maximum number of lookup relationships
D. A roll-up summary field exists on the master object

A

D. A roll-up summary field exists on the master object
A master-detail relationship can be converted to a lookup relationship as long as no roll-up summary fields exist on the master object.
In addition, the limit of the total number of lookup and master-detail fields is based on the number of Custom Foreign Keys per entity which is 40 by default and can be adjusted up to a maximum
of 50. There is no defined limit for lookup fields. When converting a master detail field to a lookup field, their total Will remain the same which also means that no additional relationship Will be
counted against the limit. On the other hand, the case is different when converting a lookup field to a master-detail because there is a limit of only two Master-Detail relationships per object.
Lastly, if the field is required and a lookup relationship already exists with the same object, the Master-Detail field can still be converted with no error.

114
Q

Global Containers needs an Order Management app in Salesforce. The Salesforce Administrator of the company has created a custom object called ‘Invoice’ to store invoice records. Every new invoice that is created should be identified by a unique system-generated Order ID with the format INV#151227-001, where 151227 represents the creation date in YYMMDD format. Which field type would be appropriate for this requirement?
Choose 1 answer.
A. Number
B. Formula
C. Auto Number
D. Text

A

C. Auto Number
Auto Number fields can contain a prefix or suffix text and a unique number that is incremented for each new record.
The date format in the auto-number represents the record creation date. There could be multiple records created on the same date and in that case, it would be the number that acts as the suffix
to the date which would uniquely identify the records.

115
Q

TODO: Entender mas
Global Containers plans to start using Orders in Salesforce to track customers’ requests for products and services. What standard features of the ‘Order’ object could they make use of?
Choose 3 answers.
A. Create recurring orders for purchases made regularly
B. Create an order directly from a contract’s detail page
C. Create an order directly from an account’s detail page
D. Associate an order with an account and optionally with a contract
E. Change a new order’s currency after cloning from an existing order with products

A

B. Create an order directly from a contract’s detail page
C. Create an order directly from an account’s detail page
D. Associate an order with an account and optionally with a contract
Orders can be created directly from the detail page of an account or contract. lt is not possible to create recurring orders in Salesforce. After cloning an order with products, the new order’s
currency or price book cannot be changed.

116
Q

Cosmic Insurance needs to store information about accounts and their related properties in Salesforce. Each account can have one or more properties, and when an account is deleted, all the related properties should be deleted automatically. The owner of all the related properties should be the same as the owner of the account. Which of the following relationship types should be used for this requirement?
Choose 1 answer.
A. Lookup
B. Master-detail
C. Hierarchical
D. Many-to-many

A

B. Master-detail
A master-detail relationship is appropriate when the parent and child records are supposed to be closely linked together. In this case, the account object would act as the parent, and the property
object would act as the child. If an account record is deleted, all related property records Will be deleted automatically. Also, unlike lookup relationships, master-detail relationships do not allow
the ‘Owner’ field on child records, since they have the same owner as their parent record.

117
Q

Global Containers requires a custom recruitment app in Salesforce. The Salesforce Administrator of the company has decided to use a custom object to track candidates. However, there should only be one record per candidate, which should be verified through a unique Email ID field. What would be the easiest way to implement this?
Choose 1 answer.
A. Mark the Email ID field as ‘Unique’
B. Write an Apex trigger to check for duplicate Email ID on save
C. Mark the Email ID field as ‘Required’ and ‘Unique’
D. Use Flow Builder to check for duplicate Email ID on save

A

C. Mark the Email ID field as ‘Required’ and ‘Unique’
A field can be marked as ‘Unique’ to ensure that no other record exists with the same value for the field. In this case, it also needs to be made ‘Required’ to ensure that blank values are not saved in
the Email ID field, which can still lead to duplicate records.
Writing an Apex trigger is not required since a simple declarative solution is available. Flow Builder cannot be used to identify and avoid duplicate records from being created.

118
Q

**TODO: Entender bien **
There is a many-to-many relationship between the custom objects ‘Candidate’ and ‘Position’ via the junction object ‘Job Application’. What would happen to the second master-detail relationship if an administrator tried to convert the master-detail relationship between ‘Job Application’ and ‘Candidate’ into a lookup relationship?
Choose 1 answer.
A. The second master-detail relationship’s field type would remain unchanged
B. Salesforce would prevent the conversion of the relationship by showing an error
C. The second master-detail relationship would cease to exist
D. The second master-detail relationship would be converted into a lookup relationship

A

A. The second master-detail relationship’s field type would remain unchanged
A master-detail relationship on a junction object can be converted into a lookup relationship. This does not have any effect on the other master-detail relationship on the junction object.
However, once the first master detail relationship has been converted, the many to-many relationship between ‘Candidate’ and ‘Job’ would cease to exist, and the junction object would no longer
act as one between the two custom objects. In addition, the secondary master-detail relationship left behind Will become the primary master-detail relationship.

119
Q

The Sales Director of a company recently noticed duplicate contact records created for different accounts. The duplicate records are valid since the contacts, for example, are full-time employees on one account and at the same time volunteer staff on another account. What can a Salesforce Administrator do to fix this?
Choose 1 answer.
A. This cannot be fixed since a contact can only be linked to a single account; if a contact is affiliated with multiple accounts, then a contact record would be created for each account.
B. The Salesforce Administrator should enable the ‘Account to Multiple Contacts’ feature, and then designate the primary and related Contacts in the ‘Related Contacts’ list on Account.
C. The Salesforce Administrator should create a multi-select picklist field on the Contact object and use it to associate the record to multiple Account records.
D. The Salesforce Administrator should enable the ‘Contacts to Multiple Accounts’ feature, and then designate the primary and related Accounts in the ‘Related Accounts’ list on Contact.

A

D. The Salesforce Administrator should enable the ‘Contacts to Multiple Accounts’ feature, and then designate the primary and related Accounts in the ‘Related Accounts’ list on Contact.
The ‘Contacts to Multiple Accounts’ feature can be enabled to allow a single contact to be linked to multiple accounts.
Accounts can have multiple contacts by default. There is no need to enable it, hence there is no setting called ‘Account to Multiple Contacts’. A multi-select picklist field cannot be used to relate a
record to another.

120
Q

TODO: Encontrar opcion correcta
Which feature can be utilized to share picklist values across custom picklist fields and objects?
Choose 1 answer.
A. Common Picklists
B. Master Picklist Value Set
C. Reusable Picklists
D. Global Picklist Value Set

A

Which feature can be utilized to share picklist values across custom picklist fields and objects?
Choose 1 answer.
A. Common Picklists
B. Master Picklist Value Set
C. Reusable Picklists
D. Global Picklist Value Set

121
Q

A Salesforce Administrator is required to convert a Text field into a Picklist field. Which of the following statements is valid regarding this field type conversion?
Choose 1 answer.
A. The field type conversion is allowed, but the picklist values created should not exceed limits.
B. The field type conversion will succeed, and the field values will be truncated accordingly.
C. The field type conversion will fail since converting a Text field to a Picklist field is not allowed.
D. The field type conversion will succeed, but all Text field data will be lost after the conversion.

A

A. The field type conversion is allowed, but the picklist values created should not exceed limits.
Converting a Textfield to a Picklist field is allowed. However, one must note that restricted picklists have a combined active and inactive limit of 1,000 values. Unrestricted picklists can have up to
1,000 active and 4,000 inactive values.
Data Will not be lost since the conversion is not allowed to proceed if it Will exceed the picklist limits. Truncation of field values Will not occur since the Text and Picklist field values have the same
255-character limits.

122
Q

TODO: Entender mas
What is true regarding picklists that use a global picklist value set?
Choose 2 answers.
A. Picklists that are based on a global picklist value set cannot be made required
B. Another picklist can be dependent on the picklist based on a global picklist value set
C. The picklist can optionally be restricted
D. The picklist is always restricted

A

B. Another picklist can be dependent on the picklist based on a global picklist value set
D. The picklist is always restricted
When a picklist field uses a global value set, it is fixed to be restricted to only the values defined in the value set used. This is Salesforce standard behavior. Only a Salesforce Administrator can add
or modify the values. Moreover, any standard or custom picklist can be a controlling field.

123
Q

While designing an application, the Salesforce Administrator determined that certain fields need to be required, either if records are entered in the user interface or through Data Loader. What does one need to keep in mind regarding the required fields?
Choose 2 answers.
A. Any standard field can be made universally required
B. Setting a field as required on a page layout will not make it required if a record is loaded with Data Loader
C. Enabling the ‘Required’ checkbox while defining a custom field will make a field universally required
D. Any custom field can be made universally required

A

B. Setting a field as required on a page layout Will not make it required if a record is loaded with Data Loader
C. Enabling the ‘Required’ checkbox while defining a custom field will make a field universally required
Ifthe ‘Required’ checkbox is enabled when defining a custom field, it is universally required. Universally required means that a field must have a value regardless of how a record is saved, i.e.,
through the user interface, API, or any other means. Standard fields cannot be made universally required. Not all data types of custom fields can be made universally required.
Making a field required on a page layout doesn’t make it required for the purpose of loading records via the API or Data Loader. One needs to make it universally required by selecting the
‘Required’ checkbox.

124
Q

What is true regarding classic encryption in Salesforce?
Choose 2 answers.
A. An existing custom text field can be converted to an encrypted field
B. Only text, number, and picklist fields can be encrypted
C. Only users with the permission ‘View Encrypted Data’ can see data in encrypted custom text fields
D. Encrypted fields are always masked in email templates regardless of the user permissions

A

C. Only users with the permission ‘View Encrypted Data’ can see data in encrypted custom text fields
D. Encrypted fields are always masked in email templates regardless of the user permissions
Regardless of user permission, encrypted fields are always masked in email templates. Only users with the ‘View Encrypted Data’ permission can see data in encrypted custom text fields.
Encrypted fields can be edited regardless ofwhether the user has the ‘View Encrypted Data’ permission. This means that users can edit the encrypted fields even if they don’t have permission to
view the actual encrypted data. Therefore, validation rules, field-level security settings, or page layout settings should be used in order to prevent users from editing encrypted fields.
Encrypted fields can only be custom text fields, and existing fields cannot be converted to an encrypted field.

125
Q

A user is assigned to a profile that has access to two record types called ‘Standard Contact’ and ‘Read Only Contact’. When creating a new contact, the user is always prompted to choose a record type, even though the user always selects ‘Standard Contact’. How can the process be improved?
Choose 2 answers.
A. Set the record type as the default in the user’s profile
B. Set the default record type in the user’s record
C. Set the default record type in the user’s role
D. Ask the user to set the default record type in ‘Settings’

A

A. Set the record type as the default in the user’s profile
D. Ask the user to set the default record type in ‘Settings’
In this scenario, if the ‘Standard Contact’ record type is selected as the default record type at the profile leve’, and the user selects the default record type in ‘Settings’, then the prompt to choose a
record type when creating a new contact Will be skipped. The newly created record Will automatically use the ‘Standard Contact’ record type. If the user does not select the default record type in
‘Settings’, the prompt Will be displayed with the ‘Standard Contact’ record type selected and ask the user to confirm before proceeding.

126
Q

Global Containers plans to start using Case Management in Salesforce. Which of the following capabilities are features of Case Management?
Choose 3 answers.
A. Assignment Rules
B. Case Monitoring
C. Escalation Rules
D. Case Duplicate Management
E. Case Queues

A

A. Assignment Rules
C. Escalation Rules
E. Case Queues
Case Monitoring and duplicate management are not yet standard capabilities of Case Management. Both of these capabilities would involve different tools, development, or possible third-party
apps. Salesforce supports case assignment rules, escalation rules, and case queues.

127
Q

What happens when a custom picklist field is changed to a custom multi -select picklist?
Choose 1 answer.
A. The value from the source picklist Will be lost and should be added manually to the multi-select picklist.
B. An error Will be displayed since a picklist cannot be converted to a multi-select picklist
C. The value from the source picklist Will be retained and selected in the multi-select picklist
D. The values from the picklist need to be mapped to values in the multi-select picklist

A

C. The value from the source picklist Will be retained and selected in the multi-select picklist
Custom picklist fields can be changed into multi-select picklists without losing any data for the defined values. Since the data from the original field type Will only contain single values, those Will
still be selected, but users can also select additional values.

128
Q

On a custom object in Salesforce, which of the following allows a user to make multiple selections from a list of values?
Choose 1 answer.
A. Multi-select picklist
B. Dependent picklist
C. Multi-select checkbox
D. Picklist

A

A. Multi-select picklist

129
Q

Which of the following are standard capa bilities of the Opportunity object?
Choose 3 answers.
A. Team selling using an Opportunity Team
B. Ability to define multiple sales processes
C. Opportunity assignment rules
D. Quote creation from an Opportunity
E. Cloning an Opportunity and selecting fields to copy

A

A. Team selling using an Opportunity Team
B. Ability to define multiple sales processes
D. Quote creation from an Opportunity
An Opportunity Team can be created to assign a group of users to work on an individual sales deal. Quotes can be created from Opportunities and have a built-in relationship with the Opportunity
object. Multiple sales processes can be defined for the ‘Stage’ field on the Opportunity object and associated with different record types and profiles.
There is no feature to select fields when cloning an Opportunity record. Opportunity assignment rules is not a feature in Salesforce.

130
Q

TODO: Entender mas
A Salesforce Administrator would like to ensure that the contacts to be shown and selected on a case are only those related to the account selected on the case. How should the Salesforce Administrator achieve this?
Choose 1 answer.
A. Create a validation rule for the ‘Contact Name’ field of the Case object
B. Create a validation rule for the ‘Account Name’ field of the Case object
C. Create a required lookup filter on the ‘Account Name’ field of the Case object
D. Create a required lookup fiIter on the ‘Contact Name’ field of the Case Object

A

D. Create a required lookup fiIter on the ‘Contact Name’ field of the Case Object
A required lookup filter needs to be created on the ‘Contact Name’ field as this field needs to filter contacts based on the account that is selected in the Case record. Enabling this filter turns the
relationship field into what is called a dependent lookup where the values (contacts) it Will display depends on field values in the source object (case).
In Salesforce Classic, the filter can be required or optional. If the filter is set to optional, only values that match the lookup filter criteria appear in the lookup dialog initially, but users can search all
results and select a different value. In Lightning Experience, all lookup filters are required, even if admins specify them as optional in Setup.
Although a validation rule can be used to prevent the Case record from being saved if the selected contact does not meet criteria, it cannot be used to only show contacts that meet criteria.

131
Q

John Smith, the Operations Director at Acme Solutions, volunteers as an Executive Facilitator at Girls Who Code (GWC) to fulfill his company’s corporate responsibility mission. However, belonging to two organizations creates a duplicate contact entry for him in their Salesforce CRM. How can a Salesforce Administrator handle this scenario?
Choose 1 answer.
A. Enable the ‘Contacts to Multiple Accounts’ feature, add John Smith in the ‘Related Contacts’ liston the GWC account record, and ensure that Acme is recorded in the account field on John Smith’s contact record
B. Create two record types for Acme and GWC respectively, and display John Smith as the Director of Operations in the Acme Record Type and John Smith as the Executive Sponsor in the GWC Record Type
C. Use Visualforce to flag the duplicate entry, which would indicate that the duplication is not an error but is required to maintain data integrity
D. Hide John Smith’ s contact record from the ‘Related Contacts’ list on GWCs Account Page Layout

A

A. Enable the ‘Contacts to Multiple Accounts’ feature, add John Smith in the ‘Related Contacts’ liston the GWC account record, and ensure that Acme is recorded in the account field on John Smith’s contact record
By enabling the Contact to Multiple Accounts feature, one contact can be related to multiple accounts without creating duplicate records.
Visualforce is not designed to flag duplicate entries. Hiding John Smith’s contact record is only possible if Contacts to Multiple Accounts feature has been
updated. Even more so, this is the opposite ofthe solution. Record types are used for controlling field visibility and picklist values, and not for hiding or
showing records.

132
Q

Which of the following are true with regard to relating Tasks and Events to other objects?
Choose 3 answers.
A. Leads are associated via the Whold
B. Opportunities are associated via the Whold
C. Cases are associated via the Whatld
D. Contacts are associated via the Whatld
E. Accounts are associated via the Whatld or Accountld

A

A. Leads are associated via the Whold
C. Cases are associated via the Whatld
E. Accounts are associated via the Whatld or Accountld
Accounts can be associated with a task or event via the Whatld or Accountld fields. The Whold and Whatld fields are polymorphic fields on the Task and
Event objects that are used to relate them to other objects. The Whold field is used to relate the record to an object that represents a person such as a
lead or a contact. The Whatld field is used to relate the record to a non-human object such as an account, opportunity, campaign, case, or custom object.
Contacts are associated with tasks or events using the Whold field. Opportunities are associated via the Whatld field.

133
Q

EDG Electronics created two different record types and sales processes for their service and consumer products. Which of the following should the Salesforce Administrator configure to define the sales processes and assign them to diferent users?
Choose 3 answers.
A. Profiles
B. Page Layouts
C. Assignment Rules
D. Validation Rules
E. Picklist Values

A

A. Profiles
B. Page Layouts
E. Picklist Values
A business process can be assigned to a record type. For a Sales Process, the picklist values chosen for the Opportunity Stage field determine which stages
can be selected for a deal of the record type associated with that Sales Process.
Other Opportunity picklist values can be included or excluded for each Opportunity picklist when configuring the “Picklists Available for Editing” for each
Opportunity record type. The page layout determines which fields are displayed in a record view. A page layout can be assigned to each profile for each
record type. Profiles determine which record types are available for users to records for that object.
Permission sets can also be used to add record types for an object to a group of users.
Validation rules are used for validating record field values. Assignment rules are used for automatically assigning cases or leads to users.

134
Q

Which of the following field types can be used as an External ID?
Choose 2 answers.
A. Picklist
B. Number
C. Text
D. Date

A

B. Number
C. Text

135
Q

TODO: Entender más
Cosmic Electronics uses multiple enterprise systems, including Salesforce and an ERP system. The ERP system contains customer and employee data, such as accounts, sales orders, invoices, compensation, performance reviews, etc. Some of the data tables are related via a lookup relationship. Certain Salesforce users need to view and edit the data stored in the ERP system without logging in separately. The CTO of the company would like to set up Salesforce Connect for this use case, but she’s concerned about connection timeout due to a large number of data tables. Furthermore, Salesforce contains a few objects that could cause naming conflicts during synchronization with the ERP system. Which of the following are valid considerations for configuring Salesforce Connect to meet the requirement?
Choose 3 answers.
A. A sync operation for an external data source can be executed in batches, paused, and resumed later.
B. Syncing the external data source fails if it causes the org to exceed 100 external objects.
C. An external lookup relationship is created automatically for two external objects related via a lookup relationship.
D. If the sync operation is likely to cause a connection timeout, it can be run asynchronously as a background job.
E. If an external object name conflicts with an existing name, inline editing can be used to edit the name.

A

C. An external lookup relationship iscreated automatically fortwo external objects related via a lookup relationship.
D. Ifthe sync operation is likely to cause a connection timeout, it can be run asynchronously as a background job.
E. If an external object name conflicts with an existing name, inline editing can be used toedit the name.
If syncing an external data source during Salesforce Connect setup causes a naming conflict between an external object name and an existing name in the
org, the name can be edited inline to save time and clicks. If the sync operation is likely to cause a connection timeout, such as due to many external data
tables, it can be run asynchronously in the background. An external lookup relationship is created automatically between parent and child objects mapped
to the same external system schema.
Syncing the external data source fails if it causes the org to exceed 200 external objects. Salesforce does not allow executing the sync operation in
batches. lt is also not possible to pause or resume it.

136
Q

A Salesforce Administrator is trying to insert Sales Order records with a unique record identifier from an external system. He has decided to use the Data Loader for this task. Sales Order records are related to the Account object in Salesforce. Accounts are previously exported from the same external system. Which type offield would need to be used in the Data Loader to match and associate related records with external records?
Choose 1 answer.
A. Salesforce Record ID
B. External ID
C. Encrypted
D. Lookup Relationship

A

B. External ID
The External ID column should be mapped to the External I D field in the Data Loader to associate related records with external records. As a best
practice, organizations that use or previously used external systems must utilize the external id field to maintain the record relationships.
Salesforce Record ID could be used for relating new records to existing records of another object, however, another unique identifier is required in order
to look up the Salesforce record ID of existing Salesforce records, and add them to the external record import file. For this reason, the external id field
would be easier to use.

137
Q

Data Import Wizard hasta cuántos registros puede importar?

A

50,000 records at one time