Brillio Interview Questions, Process, and Tips

Q1. Regarding Java 8, Spring boot,. Micro services
Add your answer

Q1. . Regarding Java 8, Spring boot,. Micro services
Add your answer

Q1. Difference between fact and dimension.
Ans. 
Fact tables contain quantitative data that can be measured, while dimension tables contain descriptive attributes related to the facts.
• Fact tables store numerical data such as sales revenue, quantity sold, etc.

• Dimension tables store descriptive attributes like product name, customer name, etc.

• Fact tables are typically larger in size compared to dimension tables.

• Fact tables are connected to dimension tables through fore
Answered by AI
Add your answer
Q2. SQL query to find second Max salary.
Ans. 
Use SQL query with subquery to find second highest salary.
• Use ORDER BY and LIMIT to get the second highest salary.

• Use a subquery to exclude the highest salary from the result set.

• Example: SELECT MAX(salary) FROM employees WHERE salary < (SELECT MAX(salary) FROM employees);
Answered by AI
Add your answer

Code in Python for checking palindromes and SQL for sales data based on months.

Q1. Different trigger pattern
Ans. 
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.
Answered by AI
Add your answer
Q2. Scenario based: trigger make one callout per record and 1000 record are updated how will you handle it?
Add your answer
Q3. Update account with count of contact.
Ans. 
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
Answered by AI
Add your answer
Q4. How do you share record using owd
Ans. 
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
Answered by AI
Add your answer

Q1. Difference between with sharing, without sharing and inherited sharing.
Ans. 
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
Answered by AI
Add your answer
Q2. Explain async process in Salesforce
Ans. 
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
Answered by AI
Add your answer

Q1. Create table view for different profile and can have more then 60 column. How to implement dynamically
Ans. 
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
Answered by AI
Add your answer
Q2. How to handle recursion
Ans. 
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
Answered by AI
Add your answer