Salesforce Solution & Technical Architect Interview Questions & Answers.
Q1. Tell us about yourself.
Take your time to introduce yourself. Tell about your education, prior work experience, hobbies interests, any certifications, patents or volunteer experience you may have.
Q2. Can you please explain about your current project?
Please explain your current project in detail. In case you have recently joined the project and, don’t have much contributions to the project then you can explain about any prior projects. The next few questions may be based on the project you explained.
Q3. What are your roles and responsibilities in your current company?
Explain your roles and responsibilities.
Q4. Why are you looking for a change?
Whether looking for better role, higher salary, visa sponsorship or relocating to a new city, you can explain your scenario.
Q5. What was the most challenging project you have worked yet? What were the challenges and how did you overcome those?
Explain the most challenging project you have worked. Project Challenges can be technical such as the project involved multiple complex integrations, organizational such as project involved multiple vendors with poor collaboration between them or tight budget/schedule.
 |  |  |  |  |  |
Q6. A customer you are working for is planning to implement a feature. There are several AppExchange App which offer the required functionality. What is your recommendation when it comes to buying an App vs implementing a custom solution?
Q7. What is Salesforce Center of Excellence (COE) and what are its key responsibilities?
A Center of Excellence drives the execution of processes by which organizations identify, prioritize, assign, execute and communicate while optimally leveraging people, processes, knowledge, and technology.
Center of Excellence Key Responsibilities:
- Drive global or large multi-division projects
- Reduce deployment risk and raises quality of the release lifecycle
- Align business and IT operations
- Develop in-house salesforce.com expertise across different areas
- Drive the execution of processes by which organizations identify, prioritize, assign, execute and communicate while optimally leveraging knowledge, resources, and tools
Q8. A customer you are working for has been using Salesforce for more than 5 years. Recently some users have started complaining that some of the reports which used to work fine earlier have started timing out. What will be your approach to investigate the issue?
Large data volumes (LDV) can lead to sluggish performance, including slower queries, slower search and list views, and slower sandbox refreshing. You can avoid this predicament if you plan for accommodating LDV up front, designing your data model to build scalability in from the get-go.
There are three types of data skew that can occur and negatively affect performance:
- Account data skew – Too many child records associated with the same parent Account causes account data skew
- Ownership skew – When a large number of records with the same object type are owned by a single user, this imbalance causes ownership skew
- Lookup skew – Lookup skew happens when a very large number of records are associated with a single record in the lookup object
There are two approaches to resolve the Large Data Volume problem:
- Short Term Solution
- Use Query Optimizer to identify possible indexes
- Check possibility of Skinny Tables / Big Objects
- Eliminate Data Skew
- Long Term Solution
- Implement Data Archival Strategy
- Expose data using External Objects
