DF Process Automation an Logic P3 Flashcards
A Salesforce Administrator has created a record-triggered flow that will be used to set a ‘Status’ field of an account to ‘Premium’ if the record meets certain conditions. Which of the options below represents a valid step for creating automated flow tests in Flow Builder to verify the flow’s expected behavior?
A. Use the ‘View Tests’ button to create, save, and run flow tests
B. Minimize assertions to create more efficient and reliable flow tests
C. Use the ‘Debug’ button to build unit tests and verify flow behavior
D. Create and run automated flow tests using the Action element
A. Use the ‘View Tests’ button to create, save, and run flow tests
Salesforce allows creating tests in Flow Builder specifically for record-triggered flows. To manage flow tests, the ‘View Tests’ button is used. To build a test, the test details, trigger, and path are first specified. Paths that run immediately, as well as scheduled paths, can be tested. Then, record values are set. Lastly, assertions are defined to validate flow behavior and determine whether the operation produced the expected results. So, creating more assertions to cover additional scenarios and use cases leads to more efficient and reliable tests. Once a test has been created, it can be run using the ‘Run Test and View Details’ option on each test in the ‘Tests’ table. Note, however, that flow tests cannot be created for record-triggered flows that are configured to run when a record is deleted.
The ‘Debug’ button or an Action element cannot be used to create or run unit tests.
A developer needs to write code that should display ‘I am a Trailblazer’ if a string variable called ‘answer’ equals ‘Salesforce’. No action is required if the variable does not meet the criteria. What control flow statement should the developer use?
A. if statement
B. if-else statement
C. Repeated ELSE-IF statement
D. SWITCH statement
A. if statement
The IF statement is the most basic control flow statement and is used to execute a code block only if its condition is satisfied (or its Boolean condition statement returns true).
An IF-ELSE statement is used to execute an alternative code block if its Boolean condition is not satisfied. Repeated ELSE-IF statements are used to execute one of several code blocks when its respective Boolean condition is satisfied. The SWITCH statement is used to execute a code block accordingly when an expression matches one of several values.
Which of the following methods can a developer use to determine if the current Apex transaction is close to hitting the DML rows governor limit?
A. Database.countQuery() and Database.getDMLRows()
B. Limits.getLimitDMLStatements() and Limits.getDMLStatements()
C. Limits.getLimitDMLRows() and Limits.getDMLRows()
D. Database.getDMLRows() and Limits.getDMLRows()
C. Limits.getLimitDMLRows() and Limits.getDMLRows()
Limits.getDMLRows() returns the number of records that have been processed using any DML statement that counts against the DML limits. This can be used together with the getLimitDMLRows() method, which returns the actual limit.
While Limits.getLimitDMLStatements() returns the number of DML operations that can be called in a single transaction, Limits.getDMLStatements() returns the number of DML operations that have already been called. Database.countQuery() is a method used to return the number of records that a dynamic SOQL query would return if executed. A Database.getDMLRows() method does not exist.
Which of the following statements about while and do-while loops is true?
Choose 1 answer.
A. The code block of a while loop is executed first before its condition is evaluated.
B. A while loop repeatedly executes its code block as long as its condition remains false.
C. The code block of a do-while loop will always be executed at least once.
D. A do-while loop can be used instead of a while loop to avoid running into infinite loops.
C. The code block of a do-while loop will always be executed at least once.
A do-while loop will execute its code block first before evaluating its Boolean condition statement. Hence, the code block in a do-while loop will always be executed at least once. In contrast, the while loop will evaluate its Boolean condition statement first before executing its code block. Note that as long as the Boolean condition statement of a while or do-while loop remains true, the loop will keep on iterating. Therefore, these loops can result in an infinite loop and reach governor limits if not properly implemented.
A collection variable in a flow contains a list of names of supported shipping countries. A list of accounts needs to be generated where their Shipping Country does not exist in the supported shipping countries. How should this requirement be implemented in the flow?
Choose 1 answer.
A. Use the ‘Get Records’ element and query the accounts using the ‘Not In’ operator
B. Build a Loop that iterates the collection and queries the accounts during each loop
C. Build an Apex invocable action that can be used by the flow to query the accounts
D. Use the ‘Get Records’ element and query the accounts using the ‘Not Contains’ operator
A. Use the ‘Get Records’ element and query the accounts using the ‘Not In’ operator
The list of records can be generated using the ‘Get Records’ element and the ‘Not In’ operator, which can access a collection of primitive values. The ‘Not In’ as well as the ‘In’ operators, which are supported by the ‘Get Records’, ‘Update Records’, or ‘Delete Records’ elements, can be used to access a collection resource that contains Text, Number, Date, Date/Time, Currency, or Boolean values.
Using Apex is not necessary as the operation is supported in flow. A ‘Not Contains’ operator is not supported in these flow elements. The ‘Contains’ operator, however, is used to determine whether a string value exists or is contained in another string value. Performing a loop in a query is not a recommended practice and is also not necessary in this scenario.
Use In and Not In Operators in Flows to Find Related Records
Which of the following statements are true about using a SOQL for loop to process records in Apex?
Choose 1 answer.
A. SOQL for loops can be used to avoid the limit on heap size
B. SOQL for loops should not perform DML statements on batches
C. SOQL for loops can process one record only during each iteration
D. SOQL for loops can process sObject results in batches of 500
A. SOQL for loops can be used to avoid the limit on heap size
SOQL for loops can be configured to process records in batches by using a List variable to store the query results, or one record at a time by assigning a single sObject variable instead. It is a best practice to perform DML operations on records in batches using a SOQL for loop. Since SOQL for loops (list format) returns up to a maximum of 200 records only during each iteration, the memory heap size is minimized.
However, note that using a SOQL for loop does not guarantee other limits from being hit. For example, if there are more than 10,000 records that will be processed, the transaction will hit the limit on maximum records that can be processed. If the SOQL for loop causes to execute more than 150 DML statements, then the limit on DML statements that can be issued will be hit.
A travel agency uses flow screens to capture different types of data, such as customer details, booking information, travel itineraries, and more. The agency would like to minimize the height of the screens that their agents scroll through by using multiple columns and collapsible sections in the flow screen. How should this requirement be achieved?
Options:
A. Define the ‘Columns’ property that is available in the ‘Screen Properties’ panel.
B. Build a Lightning web component as a custom screen component for the flow screen.
C. Add multiple ‘Column’ screen components to the ‘Accordion’ screen component.
D. Use the ‘Section’ component in the flow screen to specify columns and header labels.
D. Use the ‘Section’ component in the flow screen to specify columns and header labels.
The ‘Section’ screen component can be used to create multi-column collapsible sections in a flow screen. A section can contain up to 4 columns, which are responsive and stack vertically when viewed on smaller devices such as mobile phones. To easily identify grouped components, a header label can be specified in each section. Also, conditional visibility can be configured on a section to avoid the need to configure the conditional visibility of individual screen components when necessary.
‘Column’ and ‘Accordion’ screen components do not exist. Building a custom screen component is not required as a declarative option can be used. The ‘Screen Properties’ panel of a flow screen does not have a ‘Columns’ property.
A developer needs to automatically execute an operation such as updating a list of records in Salesforce when a platform event is published by an external app. How should this requirement be achieved?
Options:
A. Develop a custom Lightning component that subscribes to the platform event.
B. Create an Apex trigger to handle the platform event from the external app.
C. Use the Salesforce REST API to subscribe to and receive the platform events.
D. Build a flow in Flow Builder that waits for incoming platform event messages.
B. Create an Apex trigger to handle the platform event from the external app.
External systems are allowed to publish (or create) platform events in Salesforce by using a Salesforce API such as the REST API, SOAP API, or BULK API 2.0. Salesforce can then respond to the platform event by using declarative tools such as Flow Builder (platform event-triggered flow) and Process Builder (event process) or programmatic tools such as Apex triggers and custom Lightning components. Since declarative tools are preferred over programmatic solutions, and flows are recommended over the other declarative tools, using a flow in Flow Builder is the best option.
Note that as of the Summer ‘23 release, the creation of new processes is no longer allowed in Process Builder except in Developer Edition orgs. However, existing processes continue to operate normally and can be updated, activated, or deactivated.
Which of the following options contain valid expressions for initializing a list collection variable?
Choose 1 answer.
A.
~~~
new accList1 = List<Account>();
List<Account> new = accList2;
~~~</Account></Account>
B.
~~~
List<Account> accList1 = new Account[]{};
new accList2 = List<Account>();
~~~</Account></Account>
C.
~~~
Account[] accList1 = new Account[]{};
List<Account> new = accList2;
~~~</Account>
D.
~~~
List<Account> accounts1 = new List<Account>();
Account[] accounts2 = new Account[]{};
~~~</Account></Account>
D.
~~~
List<Account> accounts1 = new List<Account>();
Account[] accounts2 = new Account[]{};
~~~</Account></Account>
The initialization of a new sObject, Apex object, list, set, or map is one of the several expression types in Apex. A list is an ordered collection of elements that can be initialized using the ‘List’ keyword followed by the primitive data type, sObject, list, map, or set enclosed in angular brackets (< and >). Alternatively, the array notation can be used for initialization by specifying the name of the data type followed by empty square brackets ([]). Hence, only the following initialization expressions are valid from the given options:
Which of the following corresponds to the proper declaration of a constant variable?
Choose 1 answer.
Options:
A. public static String myConstant = ‘Private’;
B. private String myConstant = ‘Private’;
C. global static Integer myConstant = 250;
D. static final Integer myConstant = 200;
D. static final Integer myConstant = 200;
Declaring a constant variable requires using the ‘final’ keyword. Variables that are declared as static are associated with the class and accessed directly without instantiating the class. In this example, a static numeric constant named ‘myConstant’ is assigned the value of 200.
The keywords private, public, and global are access modifiers.
Salesforce supports different data types for storing numeric values. Which of the following represents valid numerical Apex variable declarations?
Choose 1 answer.
Options:
A. Double grade; Number year; Long counter;
B. ID phone; Long counter; Decimal price;
C. Integer age; Decimal price; Double grade;
D. Number year; ID phone; Integer age;
C. Integer age; Decimal price; Double grade;
The Integer and Long data types are used to store numeric values with no decimal points. While Integer is a 32-bit number, Long is 64-bit. The Decimal data type is used to store numeric values with decimal points. Double is a 64-bit number that can also be used to store numbers with decimal values.
The ID data type is used to store an 18-character string that is used to uniquely identify a Salesforce record. A ‘Number’ data type does not exist.
When a user is created in Salesforce, details of the new user need to be stored in a third-party application using an HTTP callout. Which of the following options represents a recommended action in meeting the requirement?
Choose 1 answer.
Options:
A. Configure an HTTP Callout with a POST method
B. Perform Apex callout with a POST method
C. Perform Apex callout with a GET method
D. Configure an HTTP Callout with a GET method
A. Configure an HTTP Callout with a POST method
The HTTP Callout action in Flow Builder can be used to perform callouts declaratively. POST methods, in general, are used to create new records in the external system using data that is sent along the request.
Although an Apex callout can be used to meet the requirement, a programmatic solution is not required since a declarative tool can be used. GET methods are used for retrieving data from a server and do not modify the database. In addition to GET and POST, the HTTP Callout action in Flow Builder also supports other methods such as PATCH and PUT (updating data) as well as DELETE (deleting data).
Send Salesforce Data to an External Server Without Code via HTTP Callout (Generally Available)
A SOQL statement may evaluate to which of the following data types?
Choose 1 answer.
Options:
A. single sObject, Integer, or String
B. list of sObjects, single sObject, or Integer
C. list of sObjects, single sObject, or Boolean
D. Integer, Boolean, or list of sObjects
B. list of sObjects, single sObject, or Integer
A SOQL statement can be used to either return a single record, a list of records (which can be assigned to a list, map, or set collection), or an Integer (when the COUNT method is used).
Boolean, String, and other data types are unsupported. It is important to note that when an aggregate function (except COUNT()) such as SUM, AVG, MIN, MAX, COUNT_DISTINCT, and COUNT(field_name) is used in a SOQL statement, the query returns results as an array of read-only AggregateResult objects.
A Currency field is automatically assigned to what data type in Apex?
Choose 1 answer.
Options:
A. Decimal
B. Long
C. Number
D. Currency
A. Decimal
In Apex, currency fields are automatically assigned the type Decimal.
Currency and Number are invalid data types. Long is a data type for storing 64-bit numbers and does not include a decimal point.
Which of the following is true regarding list or set iteration for-loops?
Choose 1 answer.
Options:
A. The variable defined in the for-loop declaration should be of the exact data type as the collection elements.
B. The standard syntax of a list or set iteration for-loop is: for (data_type variable_name : list_or_set) { code_block }
C. Elements can be added or removed from the collection while being iterated as long as its elements remain unique.
D. A single element or a batch of elements can be assigned to the variable during each iteration in the for-loop.
B. The standard syntax of a list or set iteration for-loop is: for (data_type variable_name : list_or_set) { code_block }
In general, the variable defined in the for-loop must be of the same data type as the collection. Otherwise, an error will be encountered during compile time. Meaning, if a list of cases needs to be iterated, for example, then the data type of the variable should be the Case sObject. An exception to this, however, is when a variable is implicitly converted using the rules of conversion (i.e. when a number of a lower type such as an Integer is implicitly converted to a number of a higher type such as a Double). For example, the following is allowed:
Adding or removing elements in a collection while it is being iterated is not allowed and will throw an exception during runtime. Unlike SOQL for-loops, a single element is always returned from the collection during each iteration in a list or set iteration for-loop.
A Salesforce developer needs to create a new Account record that contains the following standard field values:
Account Name = Sample Account
Account Number = 123456789
Account Rating = Hot
Billing Country = Australia
Which of the options below is a valid statement for assigning the field values accordingly on the Account sObject?
A.
~~~
Account acc = new Account[Name = ‘Sample Account’, AccountNumber = 123456789, Rating = ‘Hot’, BillingCountry = ‘Australia’];
~~~
B.
~~~
acc = new Account(Name = ‘Sample Account’, AccountNumber = 123456789, Rating = ‘Hot’, BillingCountry = ‘Australia’);
~~~
C.
~~~
Account acc = new Account(Name = ‘Sample Account’, AccountNumber = ‘123456789’, Rating = ‘Hot’, BillingCountry = ‘Australia’);
~~~
D.
~~~
Account acc = new Account;
Account.Name = ‘Sample Account’;
Account.AccountNumber = 123456789;
Account.Rating = ‘Hot’;
Account.BillingCountry = ‘Australia’;
~~~
C.
~~~
Account acc = new Account(Name = ‘Sample Account’, AccountNumber = ‘123456789’, Rating = ‘Hot’, BillingCountry = ‘Australia’);
~~~
The standard fields Name, Account Number, Rating, and Billing Country store String values. Hence, the value should be enclosed in single quotes when assigning to each field. An alternate syntax that can be used is:
Which of the following is true regarding custom setting data?
Choose 1 answer.
Options:
A. Custom setting data can be stored using three custom setting types.
B. Custom setting data cannot be queried using SOQL.
C. Custom setting data can be accessed by formula fields, validation rules, Apex, and Visualforce pages.
D. Custom setting data needs to be queried once using SOQL and then it is stored in the cache.
C. Custom setting data can be accessed by formula fields, validation rules, Apex, and Visualforce pages.
The two types of custom settings are hierarchy and list. List custom setting data provides a list of data that can be reused and accessed by different tools across an org. Hierarchy custom setting data uses a hierarchical logic and allows settings to be customized specifically to a profile or user.
Custom settings data is exposed in the application cache, which avoids repeated queries to the database. Hierarchy custom settings can be accessed in Apex using Custom Settings methods or in formula fields, validation rules, flows, and processes using the $Setup variable. List custom settings, however, can only be accessed in Apex or through API calls.
Please note that Salesforce no longer recommends using List custom settings. Custom metadata types are preferred since, unlike custom settings, custom metadata types can be migrated to other orgs using packages or Metadata API tools.
What will be the result of the following code if there are two accounts named ‘ACME’?
try {
Account myAccount = [SELECT id, name FROM Account WHERE name = 'ACME' ];
} catch (Exception e) {
System.debug('Exception caught');
}
System.debug('Continuing');
string myString = 'Salesforce';
System.debug('String size is ' + myString.length());
A. No exceptions will be thrown and the code will execute normally.
B. An exception will be thrown and the code will stop immediately.
C. An exception will be caught and the code will stop after executing the code in the catch block.
D. An exception will be caught and the code will continue after executing the code in the catch block.
D. An exception will be caught and the code will continue after executing the code in the catch block.
As implied in the question, the SOQL query will return more than 1 Account record. However, a single sObject variable cannot be used to store more than one record, so a query exception will be thrown. When thrown, the exception will be caught and handled by the catch block. Since the exception has been handled, the transaction will not terminate and proceed in executing the statements after the try-catch block.
In an update trigger, how can a list of the previous versions of the records be accessed?
Choose 1 answer.
Options:
A. By accessing the Trigger.updated context variable
B. By accessing the Trigger.oldList context variable
C. By accessing the Trigger.previous context variable
D. By accessing the Trigger.old context variable
D. By accessing the Trigger.old context variable
Trigger.old returns a list of the old versions of the sObject records. This sObject list is only available in update and delete triggers.
The Trigger.previous, Trigger.updated, and Trigger.oldList context variables do not exist.
Question:
A developer is required to create an Apex trigger on the Case object to populate a custom Case field whose value should be determined based on field values on the parent Account record. Which trigger event should be used to define the Apex trigger?
Choose 1 answer.
Options:
A. before update or before insert
B. before insert or after insert
C. after insert or after update
D. after update or before update
A. before update or before insert
An object’s field values can be populated programmatically using the Trigger.new context variable for “before” triggers. The action is allowed since this event occurs prior to the record being inserted or updated. So, field values can still be set.
However, populating the fields in “after triggers” will result in an exception since at this point the record will have been inserted or updated already. So, field values cannot be set anymore.
A custom object has an escalation rule, an assignment rule, a process, and an after-update trigger defined. In what order will these automations execute when a record is saved?
Choose 1 answer.
A. After-update trigger, process, assignment rule, escalation rule
B. After-update trigger, process, escalation rule, assignment rule
C. After-update trigger, assignment rule, escalation rule, process
D. After-update trigger, escalation rule, process, assignment rule
C. After-update trigger, assignment rule, escalation rule, process
Assignment rules fire before escalation rules, and escalation rules fire before processes.
Triggers and Order of Execution
Explanation:
When a record is saved in Salesforce, the order of execution follows a predefined sequence:
Triggers execute first (in this case, the after-update trigger).
Assignment rules execute to determine the owner of the record.
Escalation rules execute to determine if the case needs to be escalated.
Processes and workflow rules execute after these rules.
Thus, the correct sequence is:
After-update trigger
Assignment rule
Escalation rule
Process
Cosmic Orders uses platform events to receive updates from an external system that handles their order distribution.
To meet the increasing volume of events and process them faster, their developer would like to implement parallel subscriptions for the Apex triggers subscribed to the platform events.
Which of the following is a valid statement regarding this solution?
Choose 1 answer.
A. Parallel subscriptions support custom high-volume platform events, standard events, and change events.
B. Parallel subscriptions can be enabled by selecting the ‘Enable Parallel Subscription’ option in Setup.
C. Parallel subscriptions enable an Apex trigger to process multiple events simultaneously using partitions.
D. Parallel subscriptions require additional configuration on the platform event publisher in order to work.
C. Parallel subscriptions enable an Apex trigger to process multiple events simultaneously using partitions.
When parallel subscriptions is enabled for a subscribed Apex trigger, platform events are distributed across partitions and processed simultaneously. Up to 10 partitions, which can also be referred to as parallel subscriptions, can be specified for each Apex trigger subscriber.
Process Platform Events at Scale with Parallel Subscriptions for Apex Triggers (Generally Available)
Platform Event Processing at Scale with Parallel Subscriptions for Apex Triggers
What is true regarding cascading execution of triggers?
Choose 1 answer.
A. Cascading execution of triggers will cause an exception.
B. There is a limit of 5 triggers that can be executed from a cascading execution.
C. Cascading triggers are part of the same execution context with respect to governor limits.
D. Each trigger will start a new execution context.
C. Cascading triggers are part of the same execution context with respect to governor limits.
If the execution of one trigger causes one or more additional triggers to be fired, the triggers are said to be cascading triggers.
Cascading triggers are part of the same execution context with respect to governor limits.
Salesforce enforces limits on operations such as the number of DML statements and SOQL queries that can be issued to prevent recursion, but does not set a limit on the number of triggers that can be executed.
What will be the result of an unhandled exception on any DML statements?
Choose 1 answer.
A. A savepoint will be generated automatically.
B. All successful DML operations will be rolled back.
C. Unhandled exceptions have no impact on DML statements.
D. Any DML changes before the exception will be saved.
B. All successful DML operations will be rolled back.
When an unhandled exception occurs, the transaction is immediately terminated and any DML operations or changes made to the database are rolled back.
Savepoints are not automatically generated and are explicitly defined at a point in code typically before a DML operation is started.
A ‘before update’ trigger has performed validation and determined that the record should not be saved. A custom message also needs to be displayed in the application interface to notify the user about the failed validation. How should this be handled in Apex code?
Choose 1 answer:
A. Raise a custom exception
B. Use the addError() method
C. Raise an unhandled exception
D. Use the break method
B. Use the addError() method
Apex triggers can be used to prevent DML operations from succeeding by using the addError() method on a record or field. When used on Trigger.new records in insert and update triggers, and on Trigger.old records in delete triggers, the custom error message is displayed in the application interface and logged.
Throwing a custom exception may terminate the transaction, however, the error message displayed on the user interface will include other details such as Apex method name, exception type, line number, and other information that is not intended for normal end-users. The break method is used to break out of a loop.
A Salesforce developer uses a SOQL query to retrieve a single Account record and assigns the result to a variable called myAccount. To avoid null references, the developer would like to assign a default account if the SOQL query does not return a result. If defaultAccount is a variable representing the default account, which of the following options can be used to meet the requirement?
Choose 1 answer:
A.
~~~
Account myAccount = [SELECT Name FROM Account LIMIT 1] !? defaultAccount;
~~~
B.
~~~
Account myAccount = [SELECT Name FROM Account LIMIT 1] ?? defaultAccount;
~~~
C.
~~~
Account myAccount = [SELECT Name FROM Account LIMIT 1] ?? defaultAccount : [SELECT Name FROM Account LIMIT 1];
~~~
D.
~~~
Account myAccount = [SELECT Name FROM Account LIMIT 1].isEmpty() ? [SELECT Name FROM Account LIMIT 1] : defaultAccount;
~~~
B.
~~~
Account myAccount = [SELECT Name FROM Account LIMIT 1] ?? defaultAccount;
~~~
The following statement uses the null coalescing operator (??), which operates in the syntax <left-hand> ?? <right-hand>. When using this operator, the right-hand argument is returned whenever the left-hand argument returns null. Meaning, if the SOQL query in this example does not return a result, 'defaultAccount' will be assigned to 'myAccount'.</right-hand></left-hand>
Account myAccount = [SELECT Name FROM Account LIMIT 1] ?? defaultAccount;
The following statement uses the ternary operator. However, in this example, ‘defaultAccount’ will be assigned to ‘myAccount’ if the SOQL query result is not empty, which does not meet the requirement.
Account myAccount = [SELECT Name FROM Account LIMIT 1].isEmpty() ? [SELECT Name FROM Account LIMIT 1] : defaultAccount;
The rest of the options represent Apex code using invalid operators or syntax.
A developer has created two custom objects that use the API names Sales_Order__c and Shipment__c for tracking orders and shipments, respectively. The custom objects are related using a master-detail relationship where Sales Order is the parent object, and Shipment is the child object.
The Shipment__c object has a custom field called Tracking_Number__c used for storing tracking numbers of the shipments associated with each sales order.
The developer needs to write a SOQL query to retrieve the names of all sales orders along with the tracking numbers of their related shipments. Which of the following represents the correct query syntax?
A.
~~~
SELECT Name, (SELECT Tracking_Number__c FROM Shipment__c) FROM Sales_Order__c
~~~
B.
~~~
SELECT Name, Shipments__r.Tracking_Number__c FROM Sales_Order__c
~~~
C.
~~~
SELECT Name, (SELECT Tracking_Number__c FROM Shipments__r) FROM Sales_Order__c
~~~
D.
~~~
SELECT Sales_Order__c.Name, Shipment__c.Tracking_Number__c FROM Sales_Order__c, Shipment__c
~~~
C.
~~~
SELECT Name, (SELECT Tracking_Number__c FROM Shipments__r) FROM Sales_Order__c
~~~
Parent-child relationships can be traversed in the SELECT clause of a SOQL query by using what is called a subselect or nested query. SOQL can query child records using the relationship name, which is typically the plural name of the child object, and then appended with the “__r” suffix. This suffix indicates that the relationship established between the objects is a custom relationship. Meaning, the suffix will not be required when performing relationship queries on standard objects using standard relationship names. The name of the relationship, or Child Relationship Name, can be found on the relationship field configuration of the child object. In this scenario, ‘Shipments’ is the name of the custom relationship, so ‘Shipments__r’ is used to query the child records.
Understanding Relationship Names
Understanding Relationship Names, Custom Objects, and Custom Fields
Explanation:
In SOQL, when querying parent-to-child relationships, we use a subquery inside parentheses.
The child relationship name is pluralized and typically follows the API naming convention with __r instead of __c.
Here, since Sales_Order__c is the parent and Shipment__c is the child, we use the child relationship name (Shipments__r) in the subquery.
Exceptions disrupt the normal flow of code execution and display errors on the user interface. Which of the following statements is true about exception handling in Apex?
Choose 1 answer.
Answer Choices:
A. The finally statement is a required block that gets executed regardless of whether an exception has been thrown or not.
B. The try-catch block can be used to recover from the exception when a governor limit has been exceeded in the transaction.
C. The try statement encapsulates code in which an exception may occur, and the catch statement handles the thrown exception.
D. If multiple catch blocks are used to handle different exception types, the generic exception must be defined in the first catch block.
C. The try statement encapsulates code in which an exception may occur, and the catch statement handles the thrown exception.
Try-catch blocks are used to gracefully recover from exceptions. However, the Limit exception, which is the exception thrown when a governor limit has been exceeded, can never be caught nor handled. The finally statement is an optional block and, if added, will be executed after the catch statement(s). Furthermore, the finally block will always be executed regardless of whether a (catchable) exception was thrown. Multiple catch blocks can be used to catch specific types of built-in or custom exceptions. In this case, the generic exception handling must be defined in the last catch block.
A developer needs to update 10,005 Account records daily in an org. What method can the developer use to avoid governor limits?
Choose 1 answer.
Answer Choices:
A. Use Batch Apex for processing the records.
B. Create a method with a @future annotation.
C. Write the code and execute it in an anonymous block.
D. Use a LIMIT clause to restrict the number of records.
A. Use Batch Apex for processing the records.
Salesforce allows performing DML operations on up to 10,000 records only in a single transaction. Processing more than 10,000 records will throw a Limit exception. A recommended solution is to use Batch Apex, which will automatically process the records in batches of 200 (default) records where each batch execution is considered a distinct transaction.
Executing the code in a future method or anonymous block cannot bypass governor limit restrictions.
Which of the following statements are true about querying a multi-select picklist field?
Choose 1 answer.
Answer Choices:
A. Picklist values can only be specified using AND logic.
B. Picklist values can only be specified using OR logic.
C. Both semicolon and comma characters must be used in the filter.
D. Picklist values can be specified with AND / OR logic.
D. Picklist values can be specified with AND / OR logic.
Semicolon and comma characters can be used to add filter logic when querying multi-select picklist fields. A semicolon is used as a special character to implement AND logic. For example, ‘AAA;BBB’ means ‘AAA’ AND ‘BBB’ A comma is used as a special character to implement OR logic. For example, ‘AAA’,’BBB’ means ‘AAA’ OR ‘BBB’:
SOQL Query on a multi-select picklist
Explanation:
When querying a multi-select picklist in SOQL, you can use both AND & OR logic depending on how you structure the query:
Using INCLUDES (OR logic):
Retrieves records that contain at least one of the specified values in the picklist field.
Example:
sql
Copiar
Editar
SELECT Name FROM Account WHERE Multi_Picklist__c INCLUDES (‘Value1’, ‘Value2’)
Returns records where the field contains either Value1 or Value2.
Using EXCLUDES (AND logic):
Retrieves records that do not contain any of the specified values.
Example:
sql
Copiar
Editar
SELECT Name FROM Account WHERE Multi_Picklist__c EXCLUDES (‘Value1’, ‘Value2’)
Returns records where the field does not contain Value1 or Value2.
Which of the following events occur before escalation rules in the order of execution?
Choose 1 answer.
Answer Choices:
A. Auto-response rules and entitlement rules
B. Roll-up summary calculations and duplicate rules
C. Duplicate rules and assignment rules
D. Workflow rules and entitlement rules
C. Duplicate rules and assignment rules
Duplicate rules, assignment rules, auto-response rules, and workflow rules are executed before escalation rules. On the other hand, roll-up summary calculations and entitlement rules occur after escalation rules.
Explanation:
Salesforce has a well-defined Order of Execution during record save operations. Here’s the relevant sequence related to this question:
Duplicate rules
Assignment rules
Auto-response rules
Workflow rules
Escalation rules
Entitlement rules
Which of the following Apex control statements allows traversing through a list or set without referencing the size of the collection?
Choose 1 answer.
Answer Choices:
A. Iteration for loop
B. Traditional for loop
C. Do-While loop
D. While loop
A. Iteration for loop
A List or Set Iteration For Loop, also known as iteration for loop, is used to traverse a list or set and follows the syntax: For (Type variable: listOrSet) { … }. To traverse a collection, only the type, a variable, and collection are included in the loop declaration. The type of the variable should match the type of the elements in the list or set.
A List or Set Iteration For Loop, also known as iteration for loop, is used to traverse a list or set and follows the syntax: For (Type variable: listOrSet) { … }. To traverse a collection, only the type, a variable, and collection are included in the loop declaration. The type of the variable should match the type of the elements in the list or set.
