Salesforce Salesforce Certifications DATA-ARCHITECT Questions & Answers

• Question 51:

  Cloud Kicks currently has a Public Read/Write sharing model for the company's Contacts. Cloud Kicks management team requests that only the owner of a contact record be allowed to delete that contact.

  What should an Architect do to meet these requirements?

  A. Set the profile of the users to remove delete permission from the Contact object.

  B. Check if the current user is NOT the owner by creating a "before delete" trigger.

  C. Set the Sharing settings as Public Read Only for the Contact object.

  D. Check if the current user is NOT the owner by creating a validation rule on the Contact object.

  Correct Answer: B

  Explanation: Checking if the current user is NOT the owner by creating a "before delete" trigger can meet the requirement of allowing only the owner of a contact record to delete that contact. A trigger is a piece of Apex code that can execute before or after a record is inserted, updated, deleted, or undeleted. A "before delete" trigger can prevent the deletion of a record by using the addError() method.

• Question 52:

  Universal Containers is creating a new B2C service offering for consumers to ship goods across continents. This is in addition to their well-established B2B offering. Their current Salesforce org uses the standard Account object to track B2B customers. They are expecting to have over 50,000,000 consumers over the next five years across their 50 business regions. B2C customers will be individuals. Household data is not required to be stored. What is the recommended data model for consumer account data to be stored in Salesforce?

  A. Use the Account object with Person Accounts and a new B2C page layout.

  B. Use the Account object with a newly created Record Type for B2C customers.

  C. Create a new picklist value for B2C customers on the Account Type field.

  D. Use 50 umbrella Accounts for each region, with customers as associated Contacts.

  Correct Answer: A

  Explanation: The recommended data model for consumer account data to be stored in Salesforce is to use the Account object with Person Accounts and a new B2C page layout. Person Accounts are a special type of accounts that allow you

  to store information about individual consumers who are not associated with a business account2. Person Accounts have the following advantages3:

  They allow you to use the same standard objects and features that you use for business accounts, such as contacts, opportunities, cases, etc. They enable you to create different page layouts and record types for B2C and B2B customers,

  which allows you to customize the user interface and business logic for each segment.

  They support large data volumes and can scale up to 50 million records or more, which meets the expected growth of consumers over the next five years.

• Question 53:

  The architect is planning a large data migration for Universal Containers from their legacy CRM system to Salesforce. What three things should the architect consider to optimize performance of the data migration? Choose 3 answers

  A. Review the time zones of the User loading the data.

  B. Remove custom indexes on the data being loaded.

  C. Determine if the legacy system is still in use.

  D. Defer sharing calculations of the Salesforce Org.

  E. Deactivate approval processes and workflow rules.

  Correct Answer: BDE

  Explanation: Removing custom indexes on the data being loaded will prevent unnecessary index maintenance and improve the data load speed. Deferring sharing calculations of the Salesforce Org will avoid frequent sharing rule evaluations and reduce the load time. Deactivating approval processes and workflow rules will prevent triggering any automation logic that might slow down or fail the data load.

• Question 54:

  Universal Container has a Sales Cloud implementation for a sales team and an enterprise resource planning (ERP) as a customer master Sales team are complaining about duplicate account and data quality issues with account data.

  Which two solutions should a data architect recommend to resolve the complaints?

  A. Build a nightly batch job to de-dupe data, and merge account records.

  B. Integrate Salesforce with ERP, and make ERP as system of truth.

  C. Build a nightly sync job from ERP to Salesforce.

  D. Implement a de-dupe solution and establish account ownership in Salesforce

  Correct Answer: BD

  Explanation: Integrating Salesforce with ERP and making ERP the system of truth (option B) and implementing a de-dupe solution and establishing account ownership in Salesforce (option D) are the two solutions that a data architect should recommend to resolve the complaints. Option B ensures that account data is consistent and accurate across both systems, while option D prevents duplicate records and clarifies who owns each account in Salesforce. Building a nightly batch job to de-dupe data and merge account records (option A) is not a good solution, as it does not address the root cause of the duplication and may result in data loss or conflicts. Building a nightly sync job from ERP to Salesforce (option C) is also not sufficient, as it does not prevent duplication or establish ownership in Salesforce.

• Question 55:

  A customer is facing locking issued when importing large data volumes of order records that are children in a master-detail relationship with the Account object. What is the recommended way to avoid locking issues during import?

  A. Import Account records first followed by order records after sorting order by OrderID.

  B. Import Account records first followed by order records after sorting orders by AccountID.

  C. Change the relationship to Lookup and update the relationship to master-detail after import.

  D. Import Order records and Account records separately and populate AccountID in orders using batch Apex.

  Correct Answer: B

  Explanation: Importing Account records first followed by order records after sorting orders by AccountID is the recommended way to avoid locking issues during import. This can reduce the number of lock contention errors by minimizing the number of parent records that are concurrently processed by multiple batches. Sorting orders by AccountID can also group the child records by their parent records and avoid updating the same parent record in different batches3. Importing Account records first followed by order records after sorting order by OrderID will not help with avoiding locking issues because it does not group the child records by their parent records. Changing the relationship to Lookup and updating the relationship to master-detail after import will not work because changing a relationship from Lookup to master-detail requires that all child records have a parent record, which may not be the case after import. Importing Order records and Account records separately and populating AccountID in orders using batch Apex will not help with avoiding locking issues because it still requires updating the parent records in batches.

• Question 56:

  Universal Containers (UC) loads bulk leads and campaigns from third-party lead aggregators on a weekly and monthly basis. The expected lead record volume is 500K records per week, and the expected campaign records volume is 10K campaigns per week. After the upload, Lead records are shared with various sales agents via sharing rules and added as Campaign members via Apex triggers on Lead creation. UC agents work on leads for 6 months, but want to keep the records in the system for at least 1 year for reference. Compliance requires them to be stored for a minimum of 3 years. After that, data can be deleted. What statement is true with respect to a data archiving strategy for UC?

  A. UC can store long-term lead records in custom storage objects to avoid counting against storage limits.

  B. UC can leverage the Salesforce Data Backup and Recovery feature for data archival needs.

  C. UC can leverage recycle bin capability, which guarantees record storage for 15 days after deletion.

  D. UC can leverage a "tier"-based approach to classify the record storage need.

  Correct Answer: D

  Explanation: Leveraging a "tier"-based approach to classify the record storage need is a true statement with respect to a data archiving strategy for UC. This approach involves defining different tiers of data based on their usage, value, and retention policies, and then applying appropriate storage and archiving solutions for each tier.

• Question 57:

  Universal Containers has more than 10 million records in the Order_c object. The query has timed out when running a bulk query. What should be considered to resolve query timeout?

  A. Tooling API

  B. PK Chunking

  C. Metadata API

  D. Streaming API

  Correct Answer: B

  Explanation: PK Chunking can resolve query timeout when running a bulk query on an object with more than 10 million records. PK Chunking is a feature of the Bulk API that splits a query into multiple batches based on the record IDs (primary keys) of the queried object. This can improve the query performance and avoid timeouts by reducing the number of records processed in each batch.

• Question 58:

  Universal Containers (UC) manages Vehicle and Service History in Salesforce. Vehicle (Vehicle__ c) and Service History (Service-History__ c) are both custom objects related through a lookup relationship.

  Every week a batch synchronization process updates the Vehicle and Service History records in Salesforce. UC has two hours of migration window every week and is facing locking issues as part of the data migration process.

  What should a data architect recommend to avoid locking issues without affecting performance of data migration?

  A. Use Bulk API parallel mode for data migration

  B. Use Bulk API serial mode for data migration

  C. Insert the order in another custom object and use Batch Apex to move the records to Service_ Order__ c object.

  D. Change the lookup configuration to "Clear the value of this field" when lookup record is deleted.

  Correct Answer: B

  Explanation: According to the official Salesforce guide1, using Bulk API serial mode for data migration can help avoid locking issues by processing batches in a single thread. This mode ensures that batches are processed in the order they are received and that only one batch is processed at a time. This reduces the risk of lock contention and deadlocks, especially when updating parent and child records in a lookup relationship. Option B is the correct answer because it suggests using Bulk API serial mode for data migration. Option A is incorrect because using Bulk API parallel mode for data migration can cause locking issues by processing batches in multiple threads. This mode does not guarantee the order of batch processing and can result in concurrent updates to the same records, which can lead to lock contention and deadlocks. Option C is incorrect because inserting the order in another custom object and using Batch Apex to move the records to Service_Order__c object adds unnecessary complexity and overhead to the data migration process. Option D is incorrect because changing the lookup configuration to "Clear the value of this field" when lookup record is deleted does not address the locking issues caused by data migration, but rather by record deletion.

• Question 59:

  A national nonprofit organization is using Salesforce to recruit members. The recruitment process requires a member to be matched with a volunteer opportunity. Given the following:

  1.

  A record is created in Project__ c and used to track the project through completion.

  2.

  The member may then start volunteering and is required to track their volunteer hours, which is stored in VTOTime_c object related to the project.

  3.

  Ability to view or edit the VTOTime__c object needs to be the same as the Project__ c record.

  4.

  Managers must see total hours volunteered while viewing the Project__ c record.

  Which data relationship should the data architect use to support this requirement when creating the custom VTOTime__c object?

  A. Lookup Field on Project_c to VTOTime_c displaying a list of VTOTime__c in a related list.

  B. Lookup field on VTOTime_c to Project_c with formula filed on Project__ c showing Sum of hours from VTOTime__c records.

  C. Master Detail Field on VTOTime_ c to Project_c with rollup summary field on Project __c showing sum of hours from VTOTime_c records.

  D. Master Detail field on Project _c to VTOTime _c showing a list of VTOTime_c Records in a related list.

  Correct Answer: C

  A master-detail field on VTOTime__c to Project__c is the data relationship that the data architect should use to support the requirement when creating the custom VTOTime__c object. A master-detail relationship creates a parent-child relationship between two objects, where the master record controls certain behaviors of the detail record, such as security, ownership, deletion, and roll-up summary fields. By using a master-detail field on VTOTime__c to Project__c, you can ensure that the ability to view or edit the VTOTime__c object is the same as the Project__c record, and that managers can see the total hours volunteered while viewing the Project__c record using a roll-up summary field.

• Question 60:

  Universal Containers (UC) has users complaining about reports timing out or simply taking too long to run What two actions should the data architect recommend to improve the reporting experience? Choose 2 answers

  A. Index key fields used in report criteria.

  B. Enable Divisions for large data objects.

  C. Create one skinny table per report.

  D. Share each report with fewer users.

  Correct Answer: AC

  Explanation: Indexing key fields used in report criteria can speed up the query execution and reduce the report run time. Indexes can be created by Salesforce automatically or manually by request. Creating one skinny table per report can also improve the reporting performance by storing frequently used fields in a separate table that does not include complex formulas or joins.