We have data that gets loaded once a week. With that in mind we have an application that clients enter search data in to and then SQL has to dynamically build a statement that has 25 different data points/relationships. It works fine, but takes upwards of 30 seconds to return the data to the client. You can not change the existing schema, but you can however add to it. Indexes are already present and optimized on all the different tables. What could you do to make this process much faster??
What aspects of the job do you like?
gave multiple hypothetical situations & asked how you would handle them, if unix machine completely failed, what steps need to be taken to recover to file level.
relocation
How comfortable was I with shifts
Tolerance for fast pace
If there are 10 people in a meeting and each one shakes their hands once, how many handshakes there was?
All are Scenario-based questions
1. Validation Rule 2. Scenerio on Permision Set 3. Data Loader Error Discussion 4. SOQL Query
Q3. What experience do you have with the cloud technology?
Viewing 111 - 120 interview questions