PD2 practice questions 1–10

1. Question 1 · 279 in bank

   A Visualforce page loads slowly due to the large amount of data it displays. Which strategy can a developer use to improve the performance?

   • AUse Javascript to move data processing to the browser instead of the controller.
   • BUse the transient keywords for the List variables used in the custom controller.
   • CUse lazy loading to load the data on demand, instead of the controller's constructor.
   • DUse an <apex:actionPoller> in the page to load all of the data asynchronously.

   Show answer

   Answer: C

   References

   • developer.salesforce.com documentation
   • developer.salesforce.com documentation

   Next question

2. Question 2 · 279 in bank

   A custom object Trainer_c has a lookup field to another object Gym_c. Which SOQL query will get the record for the Viridian Gym and all it’s trainers?

   • ASELECT Id, (SELECT Id FROM Trainer_c) FROM Gym_c WHERE Name = ‘Viridian City Gym’
   • BSELECT Id, (SELECT Id FROM Trainers_c) FROM Gym_c WHERE Name = ‘Viridian City Gym’
   • CSELECT ID FROM Trainer_c WHERE Gym_r.Name = ‘Viridian City Gym’
   • DSELECT Id, (SELECT Id FROM Trainers_r) FROM Gym_c WHERE Name = ‘Viridian City Gym’

   Show answer

   Answer: D

   Next question

3. Question 3 · 279 in bank

   A company's support process dictates that any time a Case is closed with a Status of 'Could not fix', an Engineering Review custom object record should be created and populated with information from the Case, the Contact, and any of the Products associated with the Case. What is the correct way to automate this using an Apex trigger?

   • AAn after update trigger that creates the Engineering Review record and inserts it
   • BA before update trigger that creates the Engineering Review record and inserts it
   • CAn after upsert trigger that creates the Engineering Review record and inserts it
   • DA before upsert trigger that creates the Engineering Review record and inserts it

   Show answer

   Answer: A

   Explanation

   Before Trigger: In case of validation check in the same object. Update the same object. After Trigger: Insert/Update related object, not the same object. Notification Email.

   Source: Adapted from community discussion — rufusroffie

   Next question

4. Question 4 · 279 in bank

   Given the following Apex statement: Account myAccount = [SELECT Id, Name FROM Account]; What occurs when more than one Account is retuned by the SOQL query?

   • AThe query fails and an error is written to the debug log.
   • BAn unhandled exception is thrown and the code terminates.
   • CThe variable, myAccount, is automatically cast to the List data type.
   • DThe first Account returned is assigned to myAccount.

   Show answer

   Answer: B

   Next question

5. Question 5 · 279 in bank

   A developer writes the following Apex trigger so that when a Case is closed, a single Survey record is created for that Case. The issue is that multiple Survey_c records are being created per Case. trigger CaseTrigger on Case (after insert, after update){ List<Survey_c> createSurveys = new List<Survey_c>(); for (Case c : trigger.new){ if (c.IsClosed && (trigger.isInsert II trigger.isUpdate && trigger.oldMap.get(c.Id).IsClosed == false)){ createSurveys.add(new Survey_c(Case_c = c.Id)); } } insert createSurveys; } What could be the cause of this issue?

   • AA user is creating the record as Closed
   • BA workflow rule is firing with a Create Task action
   • CA workflow rule is firing with a Field Update action
   • DA user is editing the record multiple times

   Show answer

   Answer: C

   Explanation

   Answer is C. As the workflow field update, makes the trigger to run again, and in the same transaction instance, so trigger creates second record.

   Source: Adapted from community discussion — Sri_Vathsa

   Next question

6. Question 6 · 279 in bank

   The OrderHelper class is a utility class that contains business logic for processing orders. Consider the following code snippet: public class without sharing OrderHelper( //code implementation } A developer needs to create a constant named DELIVERY_MULTIPLIER with a value of 4.15. The value of the constant should not change at any time in the code. How should the developer declare the DELIVERY_MULTIPLIER constant to meet the business objectives?

   • AA decimal DELIVERY_MULTIPLIER = 4.15;
   • Bstatic final decimal DELIVERY_MULTIPLIER = 4.15;
   • Cconstant decimal DELIVERY_MULTIPLIER = 4.15;
   • Dstatic decimal DELIVERY_MULTIPLIER = 4.15;

   Show answer

   Answer: B

   Next question

7. Question 7 · 279 in bank

   What is a potential design issue with the following code? trigger accountTrigger on Account (before update){ Boolean processOpportunity = false; List<opportunity> opptysClosedLost = new List<opportunity>() List<opportunity> IstAllOpp = [select StageName from Opportunity where accountId IN :Trigger.newMap.keySet()]; if(!IstAllOpp.isEmpty()) processOpportunity = true; while(processOpportunity) { for(opportunity o : IstAllOpp) if(o.StageName == 'Closed - Lost') opptysClosedLost.add(o); processOpportunity = false; if(!opptysClosedLost.isEmpty()) delete opptysClosedLost;

   • ASOQL could be avoided by creating a formula field for StageName in Account from the related Opportunity
   • BThe code will result in a System.LimitException : Too many script statements error
   • CThe code will result in a System.DmlException:Entity_is_Deleted error
   • DThe code will result in a System.LimitException: Apex CPU time limit exceeded error

   Show answer

   Answer: D

   Explanation

   Here is a better format of the code in case someone else wants to compare: trigger accountTrigger on Account (before update){ Boolean processOpportunity = false; List opptysClosedLost = new List (); List IstAllOpp = [select StageName from Opportunity where accountId IN :Trigger.newMap.keySet()]; if(!IstAllOpp.isEmpty()){ processOpportunity = true; while(processOpportunity){ for(opportunity o : IstAllOpp){if(o.StageName == 'Closed - Lost'){ opptysClosedLost.add(o); processOpportunity = false;}}} if(!opptysClosedLost.isEmpty()){delete opptysClosedLost;} The design flaw is that neither loop is necessary, a proper query could have collected the correct records to begin with and then delete them.

   Source: Adapted from community discussion — lorenac2

   References

   • Salesforce Help

   Next question

8. Question 8 · 279 in bank

   The Contact object has a custom field called "Zone." Its data type is "Text" and field length is 3. What is the outcome after executing the following code snippet in the org? List<Contact> contactsToBeInserted=new List<Contact>(); Contact contactInstance= new Contact(LastName='Smith', Department='Tech', Zone_c='IAD'); contactsToBeInserted.add(contactInstance); contactInstance= new Contact (LastName='Sm1th', Department='Tech', Zone_c='PITT'); contactsToBeInserted.add(contactInstance); Database.insert (contactsToBeInserted,true);

   • ABoth inserts succeed and the contact record that has the Zone value of 'PI'I'I' is set to NULL
   • BA partial insert succeeds and the contact record that has the Zone value 'IAD' is inserted
   • CBoth inserts succeed and the contact record that has the Zone value of 'PITT' is truncated
   • DAn unhandled DML exception is thrown and no contact records are inserted

   Show answer

   Answer: D

   Explanation

   no contacts will be inserted: System.DmlException: Insert failed. First exception on row 1; first error: STRING_TOO_LONG, Zone: data value too large: PITT (max length=3): [Zone__c]

   Source: Adapted from community discussion — drwebber

   References

   • developer.salesforce.com documentation

   Next question

9. Question 9 · 279 in bank

   Which annotation should a developer use on an Apex method to make it available to be wired to a property in a Lightning web component?

   • A@RemoteAction (cacheable=true)
   • B@AuraEnabled
   • C@AuraEnabled (cacheable=true)
   • D@RemoteAction

   Show answer

   Answer: C

   Next question

10. Question 10 · 279 in bank

    Which statement is true regarding the use of user input as part of a dynamic SOQL query?

    • AFree text input should not be allowed, to avoid SOQL injection
    • BThe String.format() method should be used to prevent injection
    • CQuotes should be escaped to protect against SOQL injection
    • DThe string should be URL encoded by the input form to prevent errors

    Show answer

    Answer: C

    References

    • developer.salesforce.com documentation

    Next question

Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page

PD2 practice, question 1. 279 questions available.