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?

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
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
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
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

Answer(s): A

Reveal Solution Next Question

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?

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

Answer(s): D

Reveal Solution Next Question

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?

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

Answer(s): B

Reveal Solution Next Question

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?

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

Answer(s): C

Reveal Solution Next Question

Free Certified Platform Developer II Exam Braindumps (page: 15)

QUESTION: 57

QUESTION: 58

QUESTION: 59

QUESTION: 60