Salesforce OmniStudio-Consultant Exam With Confidence Using Practice Dumps

Sorting by a formula field can be expensive because formula values are calculated rather than stored like normal indexed fields. If the formula is not indexed, Salesforce may need to calculate values across many candidate records before sorting or filtering them, increasing query processing time. The issue is not primarily JSON parsing memory, session CPU from OmniStudio itself, or cache bypassing. The database query plan is the real bottleneck. Salesforce large-data-volume guidance is clear that selective filters and usable indexes are central to query performance, and Salesforce notes that only certain deterministic formula fields can be custom-indexed. Therefore, sorting/filtering on non-indexed calculated values is a poor performance design for high-volume Data Mapper operations.

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

The three OmniScript elements that should be used to meet the requirements are: Text Block, HTTP Action, and Select. A Text Block element can display rich text and images using HTML tags in the OmniScript. An HTTP Action element can invoke a REST API and store the response in a JSON object. A Select element can display a dropdown list of options for the user to choose from

The consultant should embed the FlexCard using a Custom Lightning Web Component element inside the OmniScript. Salesforce supports embedding a FlexCard Lightning Web Component in an OmniScript through the Custom LWC element, allowing the existing asset overview to be reused instead of rebuilt. Rebuilding the dashboard with Text Blocks is poor design because Text Blocks are not intended to reproduce interactive FlexCard behavior. An iframe is not the recommended native OmniStudio approach and can create security, styling, and context-passing problems. Excluding the dashboard fails the requirement. The best design preserves the already-built FlexCard and places it inside the guided OmniScript flow using the supported LWC embedding approach.

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