If you are designing a system where a 'Vehicle' record must be able to change its 'Warehouse' assignment frequently, and sometimes Vehicles are in transit (not assigned to any Warehouse), which relationship should you use?

A Lookup relationship is best because it allows for 'loose coupling.' Master-Detail relationships are too restrictive as they usually require the parent field to be populated and make reparenting more complex.

A property object is named 'Property__c' and has a standard field 'Name'. Which of the following is a valid SOQL SELECT statement?

Standard fields like 'Name' do not take the '__c' suffix, even when they belong to a custom object. However, the custom object API name 'Property__c' must include the suffix.

Which of the following is a syntactically correct SOQL query to retrieve the Name and Phone fields from the Lead object?

Standard SOQL syntax requires fields to be comma-separated after the SELECT keyword, followed by the FROM keyword and the object name. Option B lacks a comma, and Option C and D use incorrect keyword ordering or prepositions.

A developer needs to identify the earliest possible delivery date from a custom 'Delivery__c' object. Which aggregate function is most appropriate for this task?

The MIN() function is used to find the lowest value in a set, which for Date or Date/Time fields represents the earliest point in time. SUM and AVG are restricted to numeric fields.

Learn Salesforce - Free Learning Path