Certified Platform Developer II Practice Test

Certified Platform Developer II Practice Test practice questions, page 12 of 17, with answer review and explanations.

Question 56

A developer is writing a Visualforce page that queries accounts in the system and presents a data table with the results. The users want to be able to filter the results based on up to five fields. However, the users want to pick the five fields to use as filter fields when they run the page. Which feature of Apex code is required to facilitate this solution?

  1. SOSL queries
  2. describeSObjects()
  3. Dynamic Schema binding
  4. REST API

Question 57

Universal Containers uses Big Objects to store almost a billion customer transactions called Customer_Transaction__b. These are the fields on Customer_Transaction__b: Account__c - Program__c - Points_Earned__c - Location__c - Transaction_Date__c - The following fields have been identified as Index Fields for the Customer_Transaction__b object: Account__c, Program__c, and Transaction_Date__c. Which SOQL query is valid on the Customer_Transaction__b Big Object?

  1. SELECT Account__c, Program__c, Transaction_Date__c FROM Customer_Transaction__b WHERE Account__c = '001R000000302D3' AND Program__c ='Shoppers' AND Transaction_Date__c=2019-05-31T00:00Z
  2. SELECT Account__c, Program__c, Transaction_Date__c FROM Customer_Transaction__b WHERE Account__c = '001R000000302D3' AND Program__c LIKE 'Shop%' AND Transaction_Date__c=2019-05-31T00:00Z
  3. SELECT Account__c, Program__c, Transaction_Date__c FROM Customer_Transaction__b WHERE Account__c = '001R000000302D3' AND Program__c INCLUDES ('Shoppers', 'Womens') AND Transaction_Date__c=2019-05-31T00:00Z
  4. SELECT Account__c, Program__c, Transaction_Date__c FROM Customer_Transaction__b WHERE Account__c = '001R000000302D3' AND Program__c EXCLUDES ('Shoppers', 'Womens') AND Transaction_Date__c=2019-05-31T00:00Z

Question 58

Part of a custom Lightning Component displays the total number of Opportunities in the org, which is in the millions. The Lightning Component uses an Apex Controller to get the data it needs. What is the optimal way for a developer to get the total number of Opportunities for the Lightning Component?

  1. Apex Batch job that counts the number of Opportunity records
  2. SUM() SOQL aggregate query on the Opportunity object
  3. SOQL for loop that counts the number of Opportunities records
  4. COUNT() SOQL aggregate query on the Opportunity object

Question 59

A company notices that their unit tests in a test class with many methods to create many records for prerequisite reference data are slow. What can a developer to do address the issue?

  1. Move the prerequisite reference data setup to a TestDataFactory and call that from each test method.
  2. Move the prerequisite reference data setup to a @testSetup method in the test class.
  3. Move the prerequisite reference data setup to a static method in the test class and call that from each test method.
  4. Move the prerequisite reference data setup to the constructor for the test class.

Question 60

A developer is asked to build a solution that will automatically send an email to the Customer when an Opportunity stage changes. The solution must scale to allow for 10,000 emails per day. The criteria to send the email should be evaluated after all Workflow Rules have fired. What is the optimal way to accomplish this?

  1. Use a MassEmailMessage() with an Apex Trigger.
  2. Use a Workflow Email Alert.
  3. Use an Email Alert with Process Builder.
  4. Use a SingleEmailMessage() with an Apex Trigger.