Salesforce Salesforce Certifications PDII Questions & Answers

• Question 351:

  Which method should be used to convert a Date to a String in the current user's locale?

  A. Date.format

  B. Date.parse

  C. String.format

  D. String. valueOf

  Correct Answer: A

• Question 352:

  A company has a custom object, Order__c, that has a required, unique, external ID field called Order_Number__c. Which statement should be used to perform the DML necessary to insert new records and update existing records in a List of Order__c records?

  A. upsert orders;

  B. merge orders;

  C. merge orders Order_Number__c;

  D. upsert orders Order_Number__c;

  Correct Answer: D

• Question 353:

  Business rules require a Contact to always be created when a new Account is created. What can be used when developing a custom screen to ensure an Account is not created if the creation of the Contact fails?

  A. use the Database.Delete method if the Contact insertion fails.

  B. Disable validation rules on Contacts and set default values with a Trigger.

  C. use the Database.Insert method with allOrNone set to False.

  D. use setSavePoint() and rollback() with a try/catch block.

  Correct Answer: D

• Question 354:

  Consider the above trigger intended to assign the Account to the manager of the Account''s region.

  

  Which two changes should a developer make in this trigger to adhere to best practices? Choose 2 answers

  A. Use a Map accountMap instead of List accountList.

  B. Use a Map to cache the results of the Region__c query by Id.

  C. Move the Region__c query to outside the loop.

  D. Remove the last line updating accountList as it is not needed.

  Correct Answer: CD

• Question 355:

  Example 1:

  AggregateResult[] groupedResults = [SELECT CampaignId, AVG(Amount) FROM Opportunity GROUP BY CampaignId];

  for (AggregateResult ar : groupedResults)

  {

  System.debug('Campaign ID' + ar.get('CampaignId'));

  System.debug('Average amount' + ar.get('expr0'));

  }

  Example 2:

  AggregateResult[] groupedResults = [SELECT CampaignId, AVG(Amount) theAverage FROM Opportunity GROUP BY CampaignId];

  for (AggregateResult ar : groupedResults)

  {

  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 : groupedResults)

  {

  System.debug('Campaign ID' + ar.get('CampaignId'));

  System.debug('Average amount' + ar.get.AVG());

  }

  Example 4:

  AggregateResult[] groupedResults = [SELECT CampaignId, 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 two.)

  A. Example 1

  B. Example 2

  C. Example 3

  D. Example 4

  Correct Answer: AB

• Question 356:

  An Apex Trigger creates a Contract record every time an Opportunity record is marked as Closed and Won. This trigger is working great, except (due to a recent acquisition) historical Opportunity records need to be loaded into the Salesforce instance.

  When a test batch of records is loaded, the Apex Trigger creates Contract records. A developer is tasked with preventing Contract records from being created when mass loading the Opportunities, but the daily users still need to have the Contract records created.

  What is the most extendable way to update the Apex Trigger to accomplish this?

  A. Use a Hierarchy Custom Setting to disable the Trigger for the user who does the data loading.

  B. Add a Validation Rule to the Contract to prevent Contract creation by the user who does the data loading.

  C. Use a List Custom Setting to disable the Trigger for the user who does the data loading.

  D. add the Profile Id of the user who does the data loading to the Trigger so the Trigger won't fire for this user.

  Correct Answer: A

• Question 357:

  A developer built a Component to be used at the front desk for guests to self-register upon arrival at a kiosk. The developer is now asked to create a Component for the Utility Tray to alert Users whenever a guest has arrived at the front desk. What should be used?

  A. Changelog

  B. Component Event

  C. Application Event

  D. DML Operation

  Correct Answer: C

• Question 358:

  Given a list of Opportunity records named opportunityList, which code snippet is best for querying all Contacts of the Opportunity's Account?

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: C

• Question 359:

  Which two relationship queries use the proper syntax? Choose 2 answers

  A. SELECT Name, (SELECT LastName FROM Contacts__r) FROM Account

  B. SELECT Name, (SELECT LastName FROM Contacts) FROM Account

  C. SELECT Id, Name, Account __r.Name FROM Contact WHERE Account r.Industry = 'Media'

  D. SELECT Id, Name, Account.Name FROM Contact WHERE Account.Industry = 'Media'

  Correct Answer: BD

• Question 360:

  Which statement should be used to allow some of the records in a list of records to be inserted if others fail to be inserted?

  A. Database.insert(records, false)

  B. Database.insert(records, true)

  C. insert records

  D. insert (records, false)

  Correct Answer: A