Exam Certified Platform Developer II topic 1 question 47 discussion

Using a SOQL query inside for loop is bad practice and since it is before insert/update no need to perform DML. Ans is B and C.

B & C is the correct answer

B and C correct as per best parctices

B) Performing Queries inside a loop is not good practice, C) Changes made to records retrieved from 'Before' trigger context are automatically persisted if the trigger transaction completes successfully

B&C is correct if we're only talking about best practices. But we still need to tidy it up a bit like code below. trigger AssignOwnerByRegion on Account ( before insert, before update ) { Set<String> acctRegionNames = new Set<String>(); for( Account acc : Trigger.new){ acctRegionNames.add(acc.Region_Name__c); } Map<String, String> regionMap = new Map<String, String>(); for( Region__c reg : [SELECT Name, Region_Manager__c FROM Region__c Name IN :acctRegionNames]){ regionMap.put(reg.Name, reg.Region_Manager__c); } for( Account anAccount : trigger.new ){ if(regionMap.containsKey(anAccount.Name)){ anAccount.OwnerId = regionMap.get(anAccount.Name); } } }

B&C A is OK if Use a Map to cache the results of the Region__c query by Name

B & C are correc t

BC are correct answers

B&C it is

B and C, for sure

B & C obviously

b and c is the answer as it is a before trigger we don’t need to update the account and soql always outside of the loop