Performance & Scalability Flashcards

1
Q

Q. What is performance optimization in Salesforce?

A

A. Performance optimization in Salesforce ensures that applications run efficiently and quickly by minimizing latency, CPU time, and governor limit consumption.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Q. What is scalability in Salesforce?

A

A. Scalability refers to the ability of Salesforce to handle increasing volumes of data, users, and transactions without performance degradation.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Q. What are the key factors affecting Salesforce performance?

A
  • SOQL query efficiency
  • Data storage & indexing
  • API call optimization
  • Governor limits & execution context
  • User interface performance
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Q. What are governor limits in Salesforce?

A

A. Governor limits are restrictions imposed by Salesforce to ensure fair resource usage in a multi-tenant environment.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Q. What are key Apex governor limits?

A
  • SOQL queries per transaction: 100
  • DML statements per transaction: 150
  • CPU time per transaction: 10,000ms
  • Heap size limit: 6MB (synchronous), 12MB (asynchronous)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Q. How can you optimize Apex code to avoid governor limits?

A
  • Use bulkified SOQL & DML operations
  • Use collections (Lists, Sets, Maps)
  • Implement asynchronous processing (Batch Apex, Queueable Apex)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Q. What is Large Data Volume (LDV) in Salesforce?

A

A. LDV refers to datasets exceeding 1 million records, requiring performance optimization techniques.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Q. What are best practices for handling LDV?

A
  • Use indexed fields in SOQL queries
  • Implement Skinny Tables
  • Use archiving strategies
  • Enable Async SOQL & Batch Apex
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Q. What is a Skinny Table in Salesforce?

A

A. A special database table that contains frequently accessed fields to improve query performance.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Q. What is an Indexed Field in Salesforce?

A

A. A field that has an index stored in the database, allowing faster searches and SOQL execution.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Q. What is a selective SOQL query?

A

A. A query that uses indexed fields, returning less than 10% of total object records for efficiency.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Q. What are best practices for writing optimized SOQL queries?

A
  • Use SELECT specific fields instead of SELECT *
  • Filter queries with indexed fields
  • Avoid nested queries inside loops
  • Use LIMIT & ORDER BY for performance
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Q. How can you check if a SOQL query is selective?

A

A. Use the Query Plan Tool in Developer Console.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Q. What are common indexed fields in Salesforce?

A
  • Record ID
  • External ID
  • Name
  • CreatedDate
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Q. What are best practices for managing large datasets in Salesforce?

A
  • Implement Data Archiving Strategies
  • Use Big Objects for historical data
  • Offload data to external databases (AWS, Azure, GCP)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Q. What are Big Objects in Salesforce?

A

A. A storage-efficient object type used for handling billions of records without impacting performance.

17
Q

Q. What are archiving best practices for Salesforce data?

A
  • Move old records to external storage
  • Use Scheduled Flows or Batch Apex for cleanup
  • Implement soft deletes (IsDeleted field)
18
Q

Q. What are asynchronous processing methods in Salesforce?

A
  • Future Methods (Deferred execution)
  • Batch Apex (Large-scale data processing)
  • Queueable Apex (Flexible job chaining)
  • Platform Events (Event-driven processing)
19
Q

Q. When should you use Batch Apex instead of Future Methods?

A

A. When processing large datasets (over 50,000 records).

20
Q

Q. What are best practices for using Batch Apex?

A
  • Use batch sizes of 200-500 records
  • Minimize DML operations inside loops
  • Chain batches using Queueable Apex
21
Q

Q. What are best practices for optimizing API calls in Salesforce?

A
  • Use Bulk API for large data sets
  • Enable compression for REST API responses
  • Use query parameters to fetch only required fields
22
Q

Q. What is the difference between REST API and Bulk API?

A
  • REST API: Real-time, record-by-record data retrieval.
  • Bulk API: Asynchronous processing for millions of records.
23
Q

Q. How do you monitor API usage in Salesforce?

A
  • Use Event Monitoring Logs
  • Check API Usage in System Overview
24
Q

Q. What are best practices for improving Lightning Experience performance?

A
  • Use Lightning Data Service (LDS) instead of Apex calls
  • Reduce component re-rendering
  • Optimize SOQL queries in controllers
  • Use lazy loading for components
25
Q

Q. What is Lightning Data Service (LDS)?

A

A. LDS provides efficient, cache-based record access without SOQL queries.

26
Q

Q. How does caching improve Lightning UI performance?

A

A. It stores frequently accessed data in memory, reducing server requests.

27
Q

Q. How can you monitor performance in Salesforce?

A
  • Use Salesforce Optimizer for recommendations
  • Check Query Plan Tool for SOQL analysis
  • Enable Debug Logs & Event Monitoring
28
Q

Q. What are the key tools for troubleshooting Salesforce performance?

A
  • Apex Log Analyzer (Tracks execution time)
  • Performance Profiler in Developer Console
  • Einstein Performance Assistant
29
Q

Q. What are common causes of slow Salesforce performance?

A
  • Inefficient SOQL queries
  • Excessive automation (Workflow, Flow, Triggers)
  • Too many API calls & integrations
30
Q

Q. What are best practices for maintaining high performance in Salesforce?

A
  • Index frequently used fields
  • Use SOQL selectively & avoid loops
  • Minimize synchronous processing
  • Optimize Lightning components & caching
31
Q

Q. How can you ensure a scalable Salesforce architecture?

A
  • Use modular automation strategies
  • Implement event-driven architecture (Platform Events)
  • Design API-first integrations
32
Q

Q. What is the Salesforce Well-Architected Framework?

A

A. A best practice guide for designing scalable, secure, and high-performance Salesforce applications.