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

Questions 11–15

1. 11application · medium

   A developer writes a SOQL query on the custom object 'Project__c' inside a class that runs in a system context. The query returns 10,000 records, but the user running the code can only see 3,000 of them. The developer wants to ensure the query returns all records the user has access to, without exposing records the user should not see. What should the developer do?

   • AUse the 'with sharing' keyword on the class to enforce sharing rules and return only accessible records.
   • BUse the 'without sharing' keyword on the class to bypass sharing rules and return all 10,000 records.
   • CAdd a WHERE clause with 'OwnerId = :UserInfo.getUserId()' to filter records by owner.
   • DUse 'WITH SECURITY_ENFORCED' in the SOQL query to enforce field-level security.
   Reveal Solution Discussion Select an answer first
2. 12foundation · easy

   Which pattern is considered bulkified when deleting Apex managed sharing records?

   • ACollect sharing record IDs in a list and call delete on the list
   • BCall delete on each sharing record inside a loop
   • CUse Database.rollback after each delete
   • DUse the sharingRecalculation() method
   Reveal Solution Discussion Select an answer first
4. 13expert · hard

   A developer is optimizing a SOQL query on the 'Order__c' object. The query is used in a Lightning component that displays orders to sales reps. The org has 2 million Order__c records and uses a mix of sharing rules and Apex managed sharing. The query currently returns 50,000 records for a sales rep, but the rep only needs to see 5,000. The developer wants to improve query performance. What is the most effective approach?

   • AUse a subquery to retrieve related records instead of a single query.
   • BAdd more specific filters to the WHERE clause to reduce the result set before sharing is applied.
   • CUse the 'without sharing' keyword to bypass sharing and return all records, then filter in the component.
   • DRemove all sharing rules and Apex managed sharing to speed up the query.
   Reveal Solution Discussion Select an answer first
5. 14expert · hard

   A developer is creating Apex managed sharing records for a custom object 'Asset__c' in a trigger. The trigger processes a batch of 1,000 Assets, each with an average of 10 related 'Contract__c' records. The developer wants to minimize DML operations and avoid hitting the DML limit of 150 per transaction. What is the best approach?

   • AInsert ContractShare records for each Asset in a separate DML statement.
   • BUse a batch class to process the sharing records asynchronously.
   • CUse Database.insert with allOrNothing set to false for each ContractShare record.
   • DCreate a single list of all ContractShare records and insert them in one DML statement.
   Reveal Solution Discussion Select an answer first
6. 15foundation · easy

   A developer needs to create Apex managed sharing records for 200 Account records. What is the most bulkified approach?

   • ACollect all sharing records in a list and insert them with a single DML call
   • BUse Database.emptyRecycleBin for each sharing record
   • CUse a batch class with a scope of 1
   • DInsert each sharing record individually inside a for loop
   Reveal Solution Discussion Select an answer first