Font size
WorksheetsApp Builder - Data Modeling and Management
Total questions: 10
Worksheet time: 10mins
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. It is necessary that any customization can be revised quickly on the spot. What would be the most suitable approach for completing the task?
Use the Object Manager to build the data model and use the Schema Builder to visualize it
Use the Schema Builder to build and visualize the data model
Use the Schema Builder to build the data model, and use the Object Manager to visualize it
Use the Object Manager to build and visualize the data model
¿Which of the following are true regarding master-detail relationships?
When a user deletes a master record, all detail records are deleted
Roll-up summary fields can be created on the master object
An object can have up to five master-detail relationship fields
Ownership of detail records is determined by the master record
The relationship field needs to be marked as required on the detail object
A Salesforce Administrator is building an application for which a master-detail relationship needs to be created between the Account object and a custom object. What is true regarding the relationship?
The standard object can be on the master or detail side of this relationship
The object on the detail side will inherit the security and sharing settings of the master object
The custom object can be on the master or detail side of this relationship
The standard object can only be on the master side of this relationship
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?
Marketing Users have edit access to object B
Object B cannot be part of another master-detail relationship
Object B cannot have an Owner field
Object A cannot be part of another master-detail relationship
Sam is a system administrator of Cosmic Solutions who 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?
The junction object detail and edit pages use the color from the primary object.
The primary relationship cannot be deleted if there is a second master-detail relationship.
The junction object inherits the owner from the primary object.
Junction object records can always be created, edited, or deleted if the users have at least Read access to the primary object.
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?
Define a master-detail relationship field on the 'Vehicle' object that references the 'Cargo' object.
Define a lookup relationship field on the 'Vehicle' object that references the 'Cargo' object.
Define a master-detail relationship field on the 'Cargo' object that references the 'Vehicle' object.
Define a lookup relationship field on the 'Cargo' object that references the 'Vehicle' object.
While adding custom fields 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?
Multi-Line Text
Text Area (Long)
Text Area
Text
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?
ProfileId
Company
Role
Username
Record types have been defined on the Account object. What does this mean?
Different page layouts can be assigned for each record type
Different fields can be defined for each record type
Different users can be assigned to each record type
Different picklist values can be defined for each record type
Which of the following are required to model a many-to-many relationship between two custom objects?
Lookup relationship
Hierarchical relationship
Master-detail relationship
Junction object
