Salesforce Certified Platform Developer II — Question 140

What is the most efficient way in Visualforce to show information based on data filters defined by an end-user for a large volume of data?

Answer options

• A. Use the rendered condition in Visualforce to limit data based on data filters
• B. Use filter conditions in a SOQL query to limit data based on data filters
• C. Use an Apex controller to refine raw data based on data filters and store the result in a transient variable
• D. Use an Apex controller to refine raw data based on data filters and store the result in a static variable

Correct answer: B

Explanation

The correct answer is B because using filter conditions in a SOQL query allows for efficient data retrieval directly from the database, minimizing the volume of data processed in the application. Options A, C, and D do not leverage the database's filtering capabilities as effectively, leading to potential performance issues when handling large datasets.