The two OmniScript features that the consultant should recommend to meet this validation requirement are: Messaging and Formula. A Messaging element is an element that can display a text message with an icon and a color, such as blue for information or yellow for warning. The consultant can use a Messaging element to display an error message stating that the age cannot be less than 18 if the user’s birthday indicates they are under 18 years old. A Formula element is an element that can perform calculations or validations on data values using expressions or functions. The consultant can use a Formula element to validate the user’s birthday by subtracting it from the current date and checking if the result is greater than or equal to 18 years

The efficient pattern is to retrieve only the selected Case when the user reaches Step 2. A Data Mapper Extract Action can use the CaseId selected in Step 1 as an input filter and return only the required Case details. This avoids loading unnecessary records and keeps the OmniScript responsive. A Data Mapper Load is wrong because Loads write data to Salesforce; they do not read Case details. Fetching all Cases in the Init action is inefficient and can create performance and governor-limit risks. Asking the user to re-enter Case information is poor user experience and creates data-quality problems. Salesforce OmniStudio guidance separates Data Mapper Extract for reading Salesforce data from Data Mapper Load for saving updates.

================

The two cases where an integration procedure should be used as a data source for FlexCards and OmniScripts are: To retrieve multiple data sources in a single response and To separate the user interface from changes in the data sources. An integration procedure is a tool that can execute multiple DataRaptor actions, such as Extract, Transform, and Load, and also invoke REST or SOAP services. The consultant can use an integration procedure as a data source for FlexCards and OmniScripts when they need to retrieve data from different sources, such as Salesforce objects or external systems, and store it in a JSON object for display. This way, the integration procedure can provide multiple data sources in a single response, without requiring multiple elements or actions in the FlexCard or OmniScript. The consultant can also use an integration procedure as a data source for FlexCards and OmniScripts when they want to separate the user interface from changes in the data sources. This way, the integration procedure can handle any changes in the data sources without affecting the FlexCard or OmniScript design or configuration.

The three elements that the consultant should include in the OmniScript design solution are: Telephone, Line Break, and Text. A Telephone element can display a field for the user to enter a phone number, with validation and formatting options. A Line Break element can insert a line break between two elements, making them display on separate lines. A Text element can display a field for the user to enter text, such as a website URL

For a Data Mapper Extract running against a very large Salesforce object, the critical design concern is query selectivity. A filter on PolicyNumber__c must be supported by an indexed field so Salesforce can avoid a full table scan across millions of rows. Marking the field as an External ID creates an index-supported lookup pattern, and requesting a custom index is also a valid large-data-volume design approach. Making the field required does not make the query selective. A Text Area field is worse because long text-style fields are not appropriate for selective indexed filtering. Data Mappers do not magically solve poor physical data-model design; they still depend on Salesforce query performance rules. Salesforce large-data-volume guidance recommends indexed/selective filters for scalable queries.

================

The three functions that are performed by Action elements in OmniScript are get and update data through APIs, send DocuSign emails for signature, and get and update data in Salesforce. Action elements are used to perform various operations on data within an OmniScript. Display error messages to the user is not a function of Action elements, but of Error elements. Organize data into multiple pages is not a function of Action elements, but of Page elements.

A record locking error normally indicates concurrent update contention: two or more transactions are trying to modify the same Salesforce record, or related locked records, at the same time. During a Data Mapper Load, this can happen when multiple users, automations, batch jobs, integrations, or OmniStudio processes attempt to update the same parent or child record concurrently. It is not primarily a field-level security issue; permission failures produce authorization errors. It also does not automatically mean the record is being archived or that the object batch size has been exceeded. The fix is usually architectural: reduce concurrent writes to the same record, serialize critical updates, review automation on the object, and avoid unnecessary parent-record updates. Salesforce documents UNABLE_TO_LOCK_ROW style behavior as a concurrent update/record lock problem.

================

The requirement is to update 500 Leads using Data Loader, ensuring that blank (null) values in the CSV file (for Email or Phone) do not overwrite existing values in Salesforce records. The Salesforce Data Loader provides a specific setting to control this behavior, making A the correct answer.

Here’s why A. Open Data Loader -- > Setting -- > Uncheck the " Insert Null Values " checkbox is the correct answer:

Data Loader Behavior: By default, when you update records via Data Loader, blank values in the CSV file are treated as nulls and will overwrite the corresponding fields in Salesforce with null, replacing any existing data. For example, if a Lead record has Phone = " 555-1234 " and the CSV has a blank Phone column for that ID, the update will set Phone = null unless configured otherwise.

Insert Null Values Setting: The " Insert Null Values " checkbox in Data Loader’s Settings (found under Settings > Settings) determines whether blank CSV values are treated as nulls.

Checked: Blank values in the CSV overwrite existing field values with null (default behavior).

Unchecked: Blank values in the CSV are ignored, and the existing field values in Salesforce are preserved.

Meeting the Requirement: Unchecking " Insert Null Values " ensures that if a row in the CSV has a blank Email or Phone, those fields in the corresponding Lead record remain unchanged (e.g., retaining Email = " john@example.com " instead of setting it to null). Only non-blank values in the CSV (e.g., a new Phone number) will update the records.

Process: Open Data Loader, go to Settings > Settings, uncheck " Insert Null Values, " then proceed with the Update operation using the CSV file with ID, Email, and Phone columns.

Now, let’s examine why the other options are incorrect:

B. Null values cannot be ignored. If they are present in CSV, they get updated as null: This is false. Data Loader provides the " Insert Null Values " setting specifically to ignore nulls when unchecked, contradicting this option.

C. Open Data Loader -- > Setting -- > Check the " Ignore Null Values " checkbox: There’s no " Ignore Null Values " checkbox in Data Loader Settings. The relevant option is " Insert Null Values, " which must be unchecked (not checked) to ignore nulls, making this option incorrect due to inaccurate terminology and logic.

D. Modify the CSV file and remove the records which have null values, and update them manually: This is a workaround, not a best practice. Manually editing 500 records is inefficient and error-prone when Data Loader’s built-in setting can handle this automatically.

E. Null values do not get updated through Data Loader: This is false. By default, null values do update fields unless the " Insert Null Values " setting is unchecked.

 An advantage of calculation procedures that the consultant should highlight in this scenario is that they allow multiple versions that will execute based on when the request is made. A calculation procedure can have different versions with different effective dates, which determine when they are active or inactive. This way, the calculation procedure can use different rating or pricing tables depending on the date of the request, and handle frequent changes in prices

The two reasons that explain why Integration Procedures are recommended as the first choice of data sources for FlexCards and OmniScripts are: they future-proof your front-end design and they combine multiple actions into a single server call. An Integration Procedure can abstract the data source from the front-end design, making it easier to change or update the data source without affecting the FlexCard or OmniScript. An Integration Procedure can also execute multiple DataRaptor actions, such as Extract, Transform, and Load, and also invoke REST or SOAP services in one call, reducing the number of requests and processing time