Brillio Interview Questions, Process, and Tips

Different trigger patterns are used in software development to initiate actions based on specific events.

• Triggers can be based on time, user input, system events, etc.

• Examples include event-driven programming, polling triggers, and scheduled triggers.

Update account with count of contact involves updating the account with the number of contacts associated with it.

• Create a function to update the account with the count of contacts

• Retrieve the contacts associated with the account

• Calculate the count of contacts

• Update the account with the count of contacts

Sharing records using Organization Wide Defaults (OWD) in Salesforce

• Set OWD to Public Read Only to allow all users to view records but only the owner can edit

• Set OWD to Private to restrict access to only the record owner and users above in the role hierarchy

• Use Sharing Rules to extend access to specific groups of users

• Use Manual Sharing to grant access to individual users or groups on a case-by-case basis

with sharing enforces sharing rules, without sharing doesn't enforce sharing rules, inherited sharing uses the sharing rules of the parent class

• with sharing keyword enforces sharing rules specified in the organization-wide defaults

• without sharing keyword doesn't enforce sharing rules, allowing access to all records

• inherited sharing keyword uses the sharing rules of the parent class

Async process in Salesforce allows for executing tasks in the background without blocking the main thread.

• Async processes in Salesforce are used to perform time-consuming operations without affecting the user experience.

• Apex provides @future annotation for asynchronous processing.

• Batch Apex is used for processing large data sets asynchronously.

• Queueable Apex allows chaining of asynchronous jobs.

• Platform Events can be u

Use dynamic SQL to create table view with more than 60 columns for different profiles

• Use dynamic SQL to generate the CREATE VIEW statement based on the profile requirements

• Iterate through the profile columns and add them to the CREATE VIEW statement dynamically

• Consider using a loop or a mapping function to handle the large number of columns efficiently

Recursion is a programming technique where a function calls itself in order to solve a problem.

• Identify the base case to stop the recursion

• Ensure the recursive call moves towards the base case

• Optimize recursion by using memoization or tail recursion

• Examples: factorial calculation, Fibonacci sequence