PD1 Data Modeling and Management 4 — Questions and Answers
Question 1: A developer creates a custom object without enabling the 'Allow Reports' checkbox. What is the consequence?
- Records cannot be exported to CSV
- The object does not appear in the Report Type wizard (Correct answer)
- SOQL queries against the object are disabled
- Sharing rules cannot be applied to the object
Correct answer: The object does not appear in the Report Type wizard
If 'Allow Reports' is not checked during object creation, the object won't be available as a primary object in custom Report Types.
Question 2: Which field type in Salesforce is most appropriate for storing a value that must not be visible to most users and needs to be masked?
- Text (Encrypted) (Correct answer)
- Long Text Area
- Text (Masked)
- Formula
Correct answer: Text (Encrypted)
The Encrypted Text field type stores data in encrypted form and can be masked to restrict visibility based on permissions.
Question 3: A developer needs to store a user's response as one of several predefined choices AND allow multiple selections. Which field type supports this?
- Picklist
- Multi-Select Picklist (Correct answer)
- Text Area
- Checkbox
Correct answer: Multi-Select Picklist
Multi-Select Picklist allows users to select multiple values from a predefined list, storing them as a semicolon-delimited string.
Question 4: Which statement is TRUE about the Hierarchical relationship field type in Salesforce?
- It is available on all standard and custom objects
- It is exclusively available on the User object (Correct answer)
- It supports Roll-Up Summary fields
- It allows up to 5 levels of hierarchy
Correct answer: It is exclusively available on the User object
The Hierarchical relationship field type is unique to the User object and is used to model manager-subordinate relationships.
Question 5: A developer wants field values to default to a specific value when a new record is created, without using Apex. Which feature should they use?
- Workflow Rule
- Process Builder
- Default Field Value (Correct answer)
- Validation Rule
Correct answer: Default Field Value
Default Field Values allow developers to set a formula-based or literal default that populates automatically when a new record is created.
Question 6: What is the maximum length of a standard Text field in Salesforce?
- 255 characters (Correct answer)
- 1,000 characters
- 32,768 characters
- 131,072 characters
Correct answer: 255 characters
Standard Text fields in Salesforce support a maximum of 255 characters; use Text Area or Long Text Area for longer content.
Question 7: A developer is using SOQL to retrieve parent and child records in a single query. Which SOQL feature enables this?
- Semi-join
- Aggregate query
- Relationship query (inner query) (Correct answer)
- Cross-object formula query
Correct answer: Relationship query (inner query)
SOQL relationship queries (inner queries or subqueries) let you retrieve child records nested within a parent query in one operation.
PD1 Data Modeling and Management 4
A developer creates a custom object without enabling the 'Allow Reports' checkbox.
What is the consequence?