- (Exam Topic 1)
Example 1: AggregateResult[] groupedResults = [SELECT Campaignid, AVG(Amount) FROM Opportunity GROUP BY CampaignId]; for (AggregateResult ar : groupedResuits) { System.debug ('Campaign ID' + ar.get('CampaignId'-); System.debug ('Average amount' + ar.get('exprd')); } Example 2: AggregateResult[] groupedResults = [SELECT Campaignid, AVG(Amount) theAverage FROM Opportunity GROUP BY Campaignid]; for (AggregateResult ar : groupedResuits) { System.debug(*Campaign ID' + ar.get('CampaignId')); System.debug ('Average amount' + ar.get('theAverage')); } Example 3: AggregateResult[] groupedResults = [SELECT CampaignId, AVG(Amount) FROM Opportunity GROUP BY CampaignId]; for (AggregateResult ar : groupedResuits) System.debug(*Campaign ID' + ar.get('CampaignId')); System.debug('Average amount' + ar.get.AVG(-); } Example 4:AggregateResult[] groupedResults = [SELECT CampaigniId, AVG(Amount) theAverage FROM Opportunity GROUP BY Campaignid]; for (AggregateResult ar : groupedResults) { System.debug('Campaign ID' + ar.get('CampaignId')); System.debug ('Average amount' + ar.theAverage-; } Which two of the examples above have correct System.debug statements? Choose 2 answers
Correct Answer:AB
- (Exam Topic 3)
Which two queries are selective SOQL queries and can be used for a large data set of 200,000 Account records? Choose 2 answers
Correct Answer:CD
- (Exam Topic 1)
Universal Containers implements a private sharing model for the Convention_Attendence_c custom object. As part of a new quality assurance effort, the company created an Event Reviewer___c user lookup field on the object. Management wants the event reviewer to automatically
gain Read/write access to every record they are assigned to.
What is the best approach to ensure the assigned reviewer obtains Read/Write access to the record?
Correct Answer:B
- (Exam Topic 1)
What is the best way to display field-level error messages in Lightning?
Correct Answer:A
- (Exam Topic 3)
Universal Containers (UC) currently does not development in its full copy sandbox.
Recently, UC has projects that require multiple developers to develop concurrently. UC is running into issues with developers making changes that cause errors In work done by other developers.
Additionally, when they are ready to deploy, many unit tests fail which prevents the deployment. which three types of orgs should be recommended to UC to eliminate these problems?
Choose 3 answers
Correct Answer:ACE
- (Exam Topic 1)
What is the transaction limit for the number of SOSL queries?
Correct Answer:A