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

Questions 16–20

1. 16application · medium

   A company uses a public group 'Sales Team' in multiple sharing rules for the custom object 'Opportunity_Extension__c'. The admin removes a user from the 'Sales Team' public group during business hours. Shortly after, users report that record access is slower than usual. What is the most likely cause of this performance degradation?

   • AThe removal invalidates the entire role hierarchy, forcing a full rebuild of all sharing records.
   • BThe removal causes all Apex managed sharing records to be deleted and recreated.
   • CThe removal triggers a recalculation of sharing rules, which recalculates sharing for all records affected by the group's sharing rules.
   • DThe removal causes a full index rebuild on all custom objects in the org.
   Reveal Solution Discussion Select an answer first
2. 17application · medium

   An admin changes the role hierarchy by moving a user to a higher role. After the change, users report that some records that were previously accessible are no longer visible. The admin suspects a sharing recalculation issue. What is the most likely cause?

   • AThe sharing rules were manually deleted by another admin.
   • BThe role hierarchy change triggered a recalculation of sharing rules, which may have removed access for some users.
   • CThe org-wide defaults were changed to Private, restricting access.
   • DThe user's profile was changed, removing object permissions.
   Reveal Solution Discussion Select an answer first
4. 18application · medium

   A developer is writing a trigger on the 'Account' object that creates Apex managed sharing records for related 'Contact' records. The trigger processes a batch of 500 Accounts, each with an average of 20 Contacts. The developer wants to minimize DML statements. What is the best approach?

   • AUse Database.insert with the allOrNothing parameter set to false for each ContactShare record.
   • BCreate a separate batch class to handle sharing records asynchronously.
   • CInsert ContactShare records inside the loop for each Account to keep the logic simple.
   • DCreate a list of all ContactShare records and insert them in a single DML statement after processing all Accounts.
   Reveal Solution Discussion Select an answer first
5. 19application · medium

   A company has a custom object 'Training_Module__c' with 1 million records. The org uses several sharing rules that grant access to different public groups. The admin notices that query performance has degraded significantly. What is the most effective strategy to reduce the performance impact of sharing?

   • AReview and consolidate sharing rules to minimize the number of rules and groups.
   • BUse Apex managed sharing to replace all sharing rules.
   • CIncrease the number of sharing rules to provide more granular access.
   • DSet the org-wide default to Public Read Only to eliminate the need for sharing rules.
   Reveal Solution Discussion Select an answer first
6. 20foundation · easy

   When a class is declared 'without sharing', what happens to SOQL queries inside it?

   • AThey return only records explicitly shared with the user
   • BThey ignore the current user's sharing rules and return all records the user can technically access via object permissions
   • CThey require a 'with sharing' keyword to compile
   • DThey fail with a governor limit exception
   Reveal Solution Discussion Select an answer first