Given a Particular Complex Customer Org Setup, Describe How Apex Sharing (and Calculation) Can Impact System Performance. SHARING-AND-VISIBILITY-ARCHITECT Practice Questions (Page 2)

Questions 6–10

1. 6foundation · easy

   What is the effect of the 'with sharing' keyword on a query in Apex?

   • AIt enforces the current user's sharing rules and permissions
   • BIt only applies to custom objects, not standard objects
   • CIt bypasses all sharing rules and returns all records
   • DIt improves query performance by skipping sharing calculations
   Reveal Solution Discussion Select an answer first
2. 7application · medium

   A developer creates Apex managed sharing records in a trigger on the 'Invoice__c' object. The trigger runs on every insert and update. The org has 10,000 invoices, and each trigger execution creates an average of 5 sharing records. The developer notices that the trigger is consuming a lot of CPU time. What is the most likely cause?

   • AThe trigger uses a SOQL query inside the loop to retrieve related records.
   • BThe trigger creates sharing records individually inside a loop, causing excessive DML operations.
   • CThe trigger uses 'without sharing' to bypass sharing rules, increasing CPU usage.
   • DThe trigger runs on both insert and update, doubling the number of sharing records created.
   Reveal Solution Discussion Select an answer first
4. 8expert · hard

   A company has a custom object 'Claim__c' with 2 million records. The org uses Apex managed sharing to grant access based on a complex business rule. The sharing logic runs in a trigger on the 'Claim__c' object and creates sharing records for related 'Adjuster__c' records. The trigger is causing performance issues, and the admin wants to reduce the overhead. What is the most effective strategy?

   • AMove the sharing logic from the trigger to a scheduled batch job that runs during off-peak hours.
   • BReplace Apex managed sharing with sharing rules to reduce CPU overhead.
   • CUse a formula field to determine access instead of sharing records.
   • DKeep the sharing logic in the trigger but bulkify the DML operations.
   Reveal Solution Discussion Select an answer first
5. 9foundation · easy

   Which statement accurately describes the performance impact of Apex managed sharing in a Salesforce org?

   • AIt requires a platform event to be published for every sharing change.
   • BIt adds CPU time and DML operations for each sharing record created or updated.
   • CIt only affects query performance and has no impact on DML limits.
   • DIt is automatically optimized by Salesforce and never causes governor limit issues.
   Reveal Solution Discussion Select an answer first
6. 10expert · hard

   A company has a custom object 'Document__c' with 5 million records. The org uses Apex managed sharing to grant access to documents based on complex business logic. The sharing logic runs in a trigger on the 'Document__c' object and creates sharing records for related 'User__c' records. The trigger is causing performance issues, and the admin wants to reduce the overhead. What is the most effective strategy?

   • AUse a formula field to determine access instead of sharing records.
   • BReplace Apex managed sharing with sharing rules to reduce CPU overhead.
   • CKeep the sharing logic in the trigger but bulkify the DML operations.
   • DMove the sharing logic from the trigger to a scheduled batch job that runs during off-peak hours.
   Reveal Solution Discussion Select an answer first