PD2 practice questions 231–240

1. Question 231 · 279 in bank

   Select 2

   A large company uses Salesforce across several departments. Each department has its own Salesforce Administrator. It was agreed that each Administrator would have their own sandbox in which to test changes. Recently, users notice that fields that were recently added for one department suddenly disappear without warning. Also, Workflows that once sent emails and created tasks no longer do so. Which two statements are true regarding these issues and resolution? (Choose two.)

   • AThe administrators are deploying their own Change Sets, thus deleting each other's fields from the objects in production.
   • BA sandbox should be created to use as a unified testing environment instead of deploying Change Sets directly to production.
   • CPage Layouts should never be deployed via Change Sets, as this causes Workflows and Field-level Security to be reset and fields to disappear.
   • DThe administrators are deploying their own Change Sets over each other, thus replacing entire Page Layouts and Workflows in Production.

   Show answer

   Answer: BD

   Explanation

   It is not A because Change Sets can NOT delete metadata and not C because layout 'field security' is separate from Field Level Security.

   Source: Adapted from community discussion — lorenac2

   Next question

2. Question 232 · 279 in bank

   A developer is writing a Visualforce page that queries accounts in the system and presents a data table with the results. The users want to be able to filter the results based on up to five fields. However, the users want to pick the five fields to use as filter fields when they run the page. Which feature of Apex code is required to facilitate this solution?

   • ASOSL queries
   • BdescribeSObjects()
   • CDynamic Schema binding
   • DREST API

   Show answer

   Answer: B

   Explanation

   I honestly would throw this question out. It would be better to use dynamic SOQL, not SOSL, because we are searching a single object. I don't see B being relavent as describeSobjects() provides a list of describe results for, generally, a list of sObjects. Again, we are only interested in one. D is irrelavent as the information is already in the org. C doesn't seem to be a thing, so unless there is a typo here and should be simplified to 'dynamic apex', then C is wrong as well.

   Source: Adapted from community discussion — lorenac2

   References

   • developer.salesforce.com documentation

   Next question

3. Question 233 · 279 in bank

   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?

   • ASELECT 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
   • BSELECT 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
   • CSELECT 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
   • DSELECT 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

   Show answer

   Answer: A

   Explanation

   I tried to find out when and how you can query non-indexed field, but couldn't get an answer. For more info: https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/big_object_querying.htm

   Source: Adapted from community discussion — lorenac2

   References

   • developer.salesforce.com documentation

   Next question

4. Question 234 · 279 in bank

   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?

   • AApex Batch job that counts the number of Opportunity records
   • BSUM() SOQL aggregate query on the Opportunity object
   • CSOQL for loop that counts the number of Opportunities records
   • DCOUNT() SOQL aggregate query on the Opportunity object

   Show answer

   Answer: D

   Explanation

   Aditya97 I think D. COUNT() could be right because: Queries that include aggregate functions are still subject to the limit on total number of query rows i.e 50,000. All aggregate functions other than COUNT() or COUNT(fieldname) include each row used by the aggregation as a query row for the purposes of limit tracking. For COUNT() or COUNT(fieldname) queries, limits are counted as one query row, unless the query contains a GROUP BY clause, in which case one query row per grouping is consumed.

   Source: Adapted from community discussion — rodmfpwc

   References

   • developer.salesforce.com documentation
   • developer.salesforce.com documentation
   • Salesforce Help

   Next question

5. Question 235 · 279 in bank

   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?

   • AMove the prerequisite reference data setup to a TestDataFactory and call that from each test method.
   • BMove the prerequisite reference data setup to a @testSetup method in the test class.
   • CMove the prerequisite reference data setup to a static method in the test class and call that from each test method.
   • DMove the prerequisite reference data setup to the constructor for the test class.

   Show answer

   Answer: B

   Explanation

   The answer is B. Answer A just moves the logic outside of the test class, but still runs the same amount of code. When you could do is use a TestDataFactory class marked with @IsTest and put that in the @TestSetup method, especially if more than one test class will be using the same data.

   Source: Adapted from community discussion — lorenac2

   Next question

6. Question 236 · 279 in bank

   A Visualforce page contains an industry select list and displays a table of Accounts that have a matching value in their Industry field. <apex:selectList value="{!selectedIndustry}"> <apex:selectOptions values="{!industries}"/> </apex:selectList> When a user changes the value in the industry select list, the table of Accounts should be automatically updated to show the Accounts associated with the selected industry. What is the optimal way to implement this?

   • AAdd an <apex:actionFunction> within the <apex:selectOptions>.
   • BAdd an <apex:actionFunction> within the <apex:selectList>.
   • CAdd an <apex:actionSupport> within the <apex:selectList>.
   • DAdd an <apex:actionSupport> within the <apex:selectOptions>.

   Show answer

   Answer: C

   Explanation

   This is actually correct. A component that provides support for invoking controller action methods directly from JavaScript code using an AJAX request. An component must be a child of an component. Unlike , which only provides support for invoking controller action methods from other Visualforce components, defines a new JavaScript function which can then be called from within a block of JavaScript code. Also A component that adds AJAX support to another component, allowing the component to be refreshed asynchronously by the server when a particular event occurs, such as a button click or mouseover. Use this component to get user input for a controller method that does not correspond to a field on an sObject. Only and apex:outfield can be used with sObject fields. In this instance, it does correspond to a sobject so B is correct

   Source: Adapted from community discussion — doggs119

   Next question

7. Question 237 · 279 in bank

   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?

   • AUse a MassEmailMessage() with an Apex Trigger.
   • BUse a Workflow Email Alert.
   • CUse an Email Alert with Process Builder.
   • DUse a SingleEmailMessage() with an Apex Trigger.

   Show answer

   Answer: C

   Explanation

   https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/apex_triggers_order_of_execution.htm Executes workflow rules. If there are workflow field updates: Updates the record again. Runs system validations again. Custom validation rules, flows, duplicate rules, processes, and escalation rules aren’t run again. Executes before update triggers and after update triggers, regardless of the record operation (insert or update), one more time (and only one more time) Can use A. Use a MassEmailMessage() with an Apex Trigger.

   Source: Adapted from community discussion — vm1406

   References

   • developer.salesforce.com documentation
   • developer.salesforce.com documentation
   • Salesforce Help

   Next question

8. Question 238 · 279 in bank

   UC Loans is a small company with a part time Salesforce administrator. UC Loans wants to create a Loan__c record whenever an Opportunity is won. What is the optimal solution for UC Loans to accomplish this?

   • AProcess Builder
   • BQuick Action
   • CWorkflow Rule
   • DApex Trigger

   Show answer

   Answer: A

   Next question

9. Question 239 · 279 in bank

   A developer needs to send Account records to an external system for backup purposes. The process must take a snapshot of Accounts as they are saved and then make a callout to a RESTful web service. The web service can only receive, at most, one record per call. Which feature should be used to implement these requirements?

   • A@future
   • BQueueable
   • CProcess Builder
   • DWorkflow

   Show answer

   Answer: B

   Explanation

   B Explanation "Takes a snapshot of accounts as they are" - this is all accounts - cannot be process builder for that reason, can not be future either, has to be queueable so you can queue each account one after the other.

   Source: Adapted from community discussion — Dev_Bond_ZA

   Next question

10. Question 240 · 279 in bank

    A developer gets an error saying 'Maximum Trigger Depth Exceeded'. What is a possible reason to get this error message?

    • AThe SOQL governor limits are being hit.
    • BA process Builder is running that sends mass emails.
    • CThere are numerous DML operations in the trigger logic.
    • DA trigger is recursively invoked more than 16 times.

    Show answer

    Answer: D

    References

    • Salesforce Help

    Next question

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

PD2 practice, question 231. 279 questions available.