Salesforce Salesforce Certifications DATA-ARCHITECT Questions & Answers

• Question 151:

  Universal Containers is planning out their archiving and purging plans going forward for their custom objects Topic__c and Comment__c. Several options are being considered, including analytics snapshots, offsite storage, scheduled purges, etc. Which three questions should be considered when designing an appropriate archiving strategy?

  A. How many fields are defined on the custom objects that need to be archived?

  B. Which profiles and users currently have access to these custom object records?

  C. If reporting is necessary, can the information be aggregated into fewer, summary records?

  D. Will the data being archived need to be reported on or accessed in any way in the future?

  E. Are there any regulatory restrictions that will influence the archiving and purging plans?

  Correct Answer: CDE

  Explanation: The three questions that should be considered when designing an appropriate archiving strategy are: If reporting is necessary, can the information be aggregated into fewer, summary records? Will the data being archived need to be reported on or accessed in any way in the future? Are there any regulatory restrictions that will influence the archiving and purging plans? These questions are important because they help determine the scope, frequency, and method of archiving and purging data from Salesforce. For example, if reporting is necessary, then summary records or analytics snapshots can be used to store aggregated data and reduce the number of records that need to be archived1. If the data being archived needs to be accessed in the future, then offsite storage or external objects can be used to retain the data and make it available on demand2. If there are any regulatory restrictions, such as GDPR or HIPAA, then the archiving and purging plans need to comply with them and ensure data security and privacy

• Question 152:

  Universal Container (UC) has accumulated data over years and has never deleted data from its Salesforce org. UC is now exceeding the storage allocations in the org. UC is now looking for option to delete unused from the org. Which three recommendations should a data architect make is order to reduce the number of records from the org?

  Choose 3 answers

  A. Use hard delete in Bulk API to permanently delete records from Salesforce.

  B. Use hard delete in batch Apex to permanently delete records from Salesforce.

  C. Identify records in objects that have not been modified or used In last 3 years.

  D. Use Rest API to permanently delete records from the Salesforce org.

  E. Archive the records in enterprise data warehouse (EDW) before deleting from Salesforce.

  Correct Answer: ACE

  Explanation: Using hard delete in Bulk API, identifying records that have not been modified or used in last 3 years, and archiving the records in EDW before deleting from Salesforce are all good recommendations to reduce the number of records from the org1. Using hard delete in batch Apex or Rest API may not be as efficient or scalable as Bulk API

• Question 153:

  Universal Containers (UC) plans to implement consent management for its customers to be compliant with General Data Protection Regulation (GDPR). UC has the following requirements:

  UC uses Person Accounts and Contacts in Salesforce for its customers.

  Data Protection and Privacy is enabled in Salesforce.

  Consent should be maintained in both these objects.

  UC plans to verify the consent provided by customers before contacting them through email or phone.

  Which option should the data architect recommend to implement these requirements?

  A. Configure custom fields in Person Account and Contact to store consent provided by customers, and validate consent against the fields.

  B. Build Custom object to store consent information in Person Account and Contact, validate against this object before contacting customers.

  C. Use the Consent Management Feature to validate consent provide under the person Account and Contact that is provided by the customer.

  D. Delete contact information from customers who have declined consent to be contacted.

  Correct Answer: C

  Explanation: Using the Consent Management Feature to validate consent provided under the person Account and Contact that is provided by the customer (option C) is the best option to implement these requirements, as it allows UC to store and manage consent preferences for Person Accounts and Contacts using native Salesforce features and tools. Configuring custom fields in Person Account and Contact to store consent provided by customers and validate consent against the fields (option A) or building Custom object to store consent information in Person Account and Contact and validate against this object before contacting customers (option B) are not good options, as they may require more customization and maintenance effort, and they do not leverage the existing Data Protection and Privacy feature. Deleting contact information from customers who have declined consent to be contacted (option D) is also not a good option, as it may cause data loss or compliance issues, and it does not allow UC to track or update consent preferences.

• Question 154:

  UC is using SF CRM. UC sales managers are complaining about data quality and would like to monitor and measure data quality.

  Which 2 solutions should a data architect recommend to monitor and measure data quality?

  Choose 2 answers.

  A. Use custom objects and fields to identify issues.

  B. Review data quality reports and dashboards.

  C. Install and run data quality analysis dashboard app

  D. Export data and check for data completeness outside of Salesforce.

  Correct Answer: BC

  Explanation: Reviewing data quality reports and dashboards and installing and running data quality analysis dashboard app are two solutions that can help monitor and measure data quality. Data quality reports and dashboards can provide insights into the completeness, accuracy, and consistency of the data. Data quality analysis dashboard app is a free app from AppExchange that can help analyze and improve data quality by identifying duplicate, incomplete, or inaccurate records.

• Question 155:

  UC migrating 100,000 Accounts from an enterprise resource planning (ERP) to salesforce and is concerned about ownership skew and performance.

  Which 3 recommendations should a data architect provide to prevent ownership skew?

  Choose 3 answers:

  A. Assigned a default user as owner of accounts, and assign role in hierarchy.

  B. Keep users out of public groups that can be used as the source for sharing rules.

  C. Assign a default user as owner of account and do not assign any role to default user.

  D. Assign "view all" permission on profile to give access to account.

  E. Assign a default user as owner of accounts and assigned top most role in hierarchy.

  Correct Answer: BCE

  Explanation: According to the Salesforce documentation1, ownership skew occurs when a large number of records (more than 10,000) are owned by a single user or queue. This can cause performance issues and lock contention when

  multiple users try to access or update those records. To prevent ownership skew, some of the recommended practices are:

  Assign a default user as the owner of the records and do not assign any role to the default user (option C). This way, the records will not be visible to other users in the role hierarchy and will not cause sharing recalculations. Keep users out of

  public groups that can be used as the source for sharing rules (option B). Sharing rules based on public groups can cause excessive sharing calculations and lock contention when many records are owned by a single user or queue.

  Assign a default user as the owner of the records and assign the top most role in the hierarchy to the default user (option E). This way, the records will be visible to all users in the role hierarchy, but will not cause sharing recalculations or lock

  contention.

  Assigning a default user as the owner of the records and assigning a role in the hierarchy (option A) is not a good practice, as it can cause sharing recalculations and lock contention when the role is updated or moved. Assigning "view all"

  permission on profile to give access to the records (option D) is also not a good practice, as it can bypass the security and sharing model and expose sensitive data to unauthorized users.

• Question 156:

  Universal Containers (UC) has adopted Salesforce as its primary sales automated tool. UC has 100,00 customers with a growth rate of 10% a year, UC uses an on-premise web- based billing and invoice system that generates over 1 million invoices a year supporting a monthly billing cycle.

  The UC sales team needs to be able to pull a customer record and view their account status, Invoice history, and opportunities without navigating outside of Salesforce.

  What should a data architect use to provide the sales team with the required functionality?

  A. Create a custom object and migrate the last 12 months of Invoice data into Salesforce so it can be displayed on the Account layout.

  B. Write an Apex callout and populate a related list to display on the account record.

  C. Create a mashup page that will present the billing system records within Salesforce.

  D. Create a visual force tab with the billing system encapsulated within an iframe.

  Correct Answer: C

  Explanation: To provide the sales team with the required functionality, a data architect should use a mashup page that will present the billing system records within Salesforce. A mashup page is a web page that combines data from multiple sources into a single integrated view. A mashup page can be created using Visualforce or Lightning Web Components, and can use Salesforce Connect or custom integrations to access external data from the on-premise web-based billing and invoice system. This will allow the sales team to pull a customer record and view their account status, invoice history, and opportunities without navigating outside of Salesforce. Option A is incorrect because creating a custom object and migrating the last 12 months of invoice data into Salesforce so it can be displayed on the account layout will consume a lot of storage space and may not reflect the latest data from the billing system. Option B is incorrect because writing an Apex callout and populating a related list to display on the account record will require additional development effort and may not be scalable or performant for large volumes of data. Option D is incorrect because creating a visual force tab with the billing system encapsulated within an iframe will not allow the sales team to view the billing system records within the customer record, but rather in a separate tab.

• Question 157:

  Which two statements are accurate with respect to performance testing a Force.com application?

  A. All Force.com applications must be performance tested in a sandbox as well as production.

  B. A performance test plan must be created and submitted to Salesforce customer support.

  C. Applications with highly customized code or large volumes should be performance tested.

  D. Application performance benchmarked in a sandbox can also be expected in production.

  Correct Answer: BC

  A performance test plan is required for any Force.com application that has highly customized code or large volumes of data. You need to create and submit a performance test plan to Salesforce customer support before conducting any performance testing in your sandbox or production org2. Applications with highly customized code or large volumes of data should be performance tested to ensure they meet the expected response time and throughput

• Question 158:

  UC is migrating data from legacy system to SF. UC would like to preserve the following information on records being migrated:

  Date time stamps for created date and last modified date. Ownership of records belonging to inactive users being migrated to Salesforce. Which 2 solutions should a data architect recommends to preserve the date timestamps and ownership on records? Choose 2 answers.

  A. Log a case with SF to update these fields

  B. Enable update records with Inactive Owners Permission

  C. Enable Set Audit fields upon Record Creation Permission

  D. Enable modify all and view all permission.

  Correct Answer: BC

  Explanation: The two solutions that a data architect should recommend to preserve the date timestamps and ownership on records being migrated are: Enable update records with Inactive Owners Permission: This permission allows users to update record owner and sharing-based records with inactive owners. This can help preserve the original ownership of records that belong to users who are no longer active in Salesforce8. Enable Set Audit fields upon Record Creation Permission: This permission allows users to set audit fields (such as Created By or Last Modified By) when they create a record via API importing tools like Data Loader. This can help preserve the original date timestamps of records that were created or modified in another system9. Log a case with SF to update these fields is not a good solution because it is not necessary or feasible to ask Salesforce support to update these fields manually or programmatically. Enable modify all and view all permission is not a good solution because it does not affect the ability to preserve the date timestamps and ownership on records, but rather grants users access to all records regardless of sharing settings

• Question 159:

  Universal Containers (UC) is implementing Salesforce and will be using Salesforce to track customer complaints, provide white papers on products, and provide subscription-based support.

  Which license type will UC users need to fulfill UC's requirements?

  A. Sales Cloud License

  B. Lightning Platform Starter License

  C. Service Cloud License

  D. Salesforce License

  Correct Answer: C

  Explanation: Service Cloud License (option C) is the license type that UC users need to fulfill UC's requirements, as it allows them to track customer complaints, provide white papers on products, and provide subscription-based support. Sales Cloud License (option A) is mainly for managing sales processes and leads, Lightning Platform Starter License (option B) is for building custom apps and workflows, and Salesforce License (option D) is a generic term that does not specify a particular license type.

• Question 160:

  Universal Container is Implementing salesforce and needs to migrate data from two legacy systems. UC would like to clean and duplicate data before migrate to Salesforce.

  Which solution should a data architect recommend a clean migration?

  A. Define external IDs for an object, migrate second database to first database, and load into Salesforce.

  B. Define duplicate rules in Salesforce, and load data into Salesforce from both databases.

  C. Set up staging data base, and define external IDs to merge, clean duplicate data, and load into Salesforce.

  D. Define external IDs for an object, Insert data from one database, and use upsert for a second database

  Correct Answer: C

  Explanation: To recommend a clean migration, the data architect should set up a staging database, and define external IDs to merge, clean duplicate data, and load into Salesforce. This will allow the data architect to consolidate and deduplicate the data from two legacy systems before importing it into Salesforce using external IDs as unique identifiers. Option A is incorrect because defining external IDs for an object, migrating second database to first database, and loading into Salesforce will not ensure that the data is clean and duplicate-free. Option B is incorrect because defining duplicate rules in Salesforce, and loading data into Salesforce from both databases will not prevent the duplicate data from being imported into Salesforce. Option D is incorrect because defining external IDs for an object, inserting data from one database, and using upsert for a second database will not handle the duplicate data from both databases.