Certified Data Architect practice test

1. Question 1 · 1

   Northern Trail Outfitters (NTO) has been using Salesforce for Sales and Service for 10 years. For the past two years, the marketing group has noticed a rise from 0% to 35% in returned mail when sending mail using the contact information stored in Salesforce. Which solution should the data architect use to reduce the amount of returned mail?

   Choose one answer.

   • Email all customers and ask them to verify their information and to call NTO if their address is incorrect.
   • Delete contacts when the mail is returned to save postal costs for NTO.
   • Have the sales team call all existing customers and ask to verify the contact details.
   • Use a third-party data source to update the contact information in Salesforce.

2. Question 2 · 1

   Universal Containers (UC) is migrating data from legacy system to Salesforce. During data analysis it was discovered that data types of fields being migrated do not match with Salesforce data types. Which solution should a data architect use to ensure successful data migrations?

   Choose one answer.

   • Migrate legacy data to a staging database for mapping then leverage an ETL tool to transform the data and load into Salesforce.
   • Migrate the legacy data leveraging an ETL tool to transform data types and load data into Salesforce.
   • Export legacy data into CSV files and leverage data loader to load data into Salesforce.
   • Export legacy data into the staging database and leverage stored procedures to transform data types before loading into Salesforce.

3. Question 3 · 1

   Universal Containers has been a customer of Salesforce for 10 years. Currently they have 2 million accounts in the system. Due to an erroneous integration built 3 years ago, it is estimated there are 500,000 duplicates in the system. Which solution should a data architect recommend to remediate the duplication issue?

   Choose one answer.

   • Extract the data using data loader and use excel to merge the duplicate records
   • Utilize a data warehouse as the system of truth
   • Develop an ETL process that utilizes the merge API to merge the duplicate records
   • Implement duplicate rules

4. Question 4 · 1

   Northern Trail Outfitters (NTO) runs its entire business out of an enterprise data warehouse (EDW). NTO’s sales team is starting to use Salesforce after a recent implementation, but currently lacks the data required to advance leads and opportunities to the next stage. NTO’s management has researched Salesforce Connect and would like to use it to virtualize and report on data from the EOW within Salesforce. NTO will be running thousands of reports per day across 10 to 15 external objects. What should a data architect consider before implementing Salesforce Connect for reporting?

   Choose one answer.

   • Maximum page size for server-driven paging
   • Maximum external objects per org
   • OData callout limits per day
   • Maximum number of records returned

5. Question 5 · 1

   Universal Containers (UC) has implemented a master data management strategy, which uses a central system of truth, to ensure the entire company has the same customer information in all systems. UC customer data changes need to be accurate at all times in all of the systems. Salesforce is the identified system of record for this information. What is the correct solution for ensuring all systems using customer data are kept up to date?

   Choose one answer.

   • Send customer record changes from Salesforce to the system of truth in real time.
   • Send customer data nightly to the system of truth in a scheduled batch job.
   • Have each system pull the record changes from Salesforce using change data capture.
   • Send customer record changes from Salesforce to each system in a nightly batch job.

6. Question 6 · 1

   The data architect for Universal Containers has written a SOQL query that will return all records from the Task object that do not have a value in the whatID field: SELECT ID, Description, subject FROM Task WHERE WhatID != NULL When the data architect uses the query to select values for a process, a time-out error occurs. What does the data architect need to change to make this query more performant?

   Choose one answer.

   • Change the WHERE clause to filter by a deterministic defined value.
   • Change query to SOSL.
   • Remove description from the requested field set.
   • Add LIMIT 100 to the query.

7. Question 7 · 1

   Northern Trail Outfitters is planning to build a consent form to record customer authorization for marketing purposes. What should a data architect recommend to fulfill this requirement?

   Choose one answer.

   • Use AppExchange solution to address the requirement.
   • Utilize the Authorization Form Consent object to capture the consent.
   • Use custom fields to capture the authorization details.
   • Create a custom object to maintain the authorization.

8. Question 8 · 1

   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?

   Choose one answer.

   • Master Detail field on Project__c to VTOTime__c showing a list of VTOTime__c Records in a related list.
   • Lookup field on VTOTime__c to Project__c with formula filed on Project__c showing Sum of hours from VTOTime__c records.
   • Lookup Field on Project__c to VTOTime__C displaying a list of VTOTime__C in a related list.
   • Master Detail Field on VTOTime__c to Project__c with rollup summary field on Project__c showing sum of hours from VTOTime__c records.

9. Question 9 · 1

   Northern Trail Outfitters (NTO) has a variety of customers that include households, businesses, and individuals. The following conditions exist within its system: 1. NTO has a total of five million customers. 2. Duplicate records exist, which is replicated across many systems, including Salesforce. Given these conditions, there is a lack of consistent presentation and clear identification of a customer record. Which three options should a data architect perform to resolve the Issues with the customer data? (Choose three.)

   Choose all answers that apply.

   • Invest in data duplication tool to de-dupe and merge duplicate records across all systems.
   • Use Salesforce CDC to sync customer data across all systems to keep customer record in sync.
   • Create a customer master database external to Salesforce as a system of truth and sync the customer data with all systems.
   • Create a unique global customer ID for each customer and store that in all systems for referential identity.
   • Duplicate customer records across the systems and provide a two-way sync of data between the systems.

10. Question 10 · 1

    Northern Trail Outfitters (NTO) wants to implement backup and restore for Salesforce data. Currently, it has data backup processes that runs weekly, which backs up all Salesforce data to an enterprise data warehouse (EDW). NTO wants to move to daily backups and provide restore capability to avoid any data loss in case of outage. What should a data architect recommend for a daily backup and restore solution?

    Choose one answer.

    • Change weekly backup process to daily backup, and implement a custom restore solution.
    • Use Bulk API to extract data on daily basis to EDW and REST API for restore.
    • Use ETL tool for backup and restore from EDW.
    • Use AppExchange package for backup and restore.

11. Question 11 · 1

    Northern Trail Outfitters (NTO) operates a majority of its business from a central Salesforce org. NTO also owns several secondary orgs that the service, finance, and marketing teams work out of. At the moment, there is no integration between central and secondary orgs, leading to data visibility issues. Moving forward, NTO has identified that a hub-and-spoke model is the proper architecture to manage its data, where the central org is the hub and the secondary orgs are the spokes. Which tool should a data architect use to orchestrate data between the hub org and spoke orgs?

    Choose one answer.

    • A middleware solution that extracts and distributes data across both the hub and spokes.
    • Develop custom APIs to poll the spoke org for change data and push into the hub org.
    • Develop custom APIs to poll the hub org for change data and push into the spoke orgs.
    • A backup and archive solution that extracts and restores data across orgs.

12. Question 12 · 1

    A large retail B2C customer wants to build a 360-degree view of its customers for its call center agents. The customer information is currently maintained in the following systems: 1. Salesforce CRM 2. Custom billing solution 3. Customer master data management (MDM) 4. Contract management system 5. Marketing solution What should a data architect recommend that would help uniquely identify the customer across multiple systems?

    Choose one answer.

    • Store the Salesforce ID in all the solutions to identify the customer.
    • Create a custom field as external ID to maintain the customer ID from the MDM solution.
    • Create a custom object that will serve as a cross-reference for the customer ID.
    • Create a customer database, and use this ID in all systems.

13. Question 13 · 1

    Northern Trail Outfitters (NTO) is in the process of evaluating big objects to store large amounts of asset data from an external system. NTO will need to report on this asset data weekly. Which two native tools should a data architect recommend to achieve this reporting requirement? (Choose two.)

    Choose all answers that apply.

    • Standard SOQL queries
    • Async SOQL with a custom object
    • Standard reports and dashboards
    • Einstein Analytics

14. Question 14 · 1

    To address different compliance requirements such as General Data Protection Regulation (GDPR), personally identifiable information (PII), Health Insurance Portability and Accountability Act (HIPPA) and others, a Salesforce customer decided to categorize each data element in Salesforce with the following: 1. Data owner 2. Security level (i.e. confidential) 3. Compliance type (i.e. GDPR. PII, HIPAA) A compliance audit would require Salesforce admins to generate reports to manage compliance. What should a data architect recommend to address this requirement?

    Choose one answer.

    • Build reports for field Information, then export the information to classify and report for audits.
    • Create a custom object and field to capture necessary compliance information and build custom reports.
    • Use the Metadata API to extract field attribute information and use the extract to classify and build reports.
    • Use field metadata attributes for compliance categorization, data owner, and data sensitivity level.

15. Question 15 · 1

    Universal Containers (UC) is in the process of implementing an enterprise data warehouse (EDW). UC needs to extract 100 million records from Salesforce for migration to the EDW. What data extraction strategy should a data architect use for maximum performance?

    Choose one answer.

    • Utilize PK Chunking with the Bulk API.
    • Install a third-party AppExchange tool.
    • Use the Bulk API in parallel mode.
    • Call the REST API in successive queries.

Paid access to all 78 questions

Each purchase applies to this certification. Prices are one-time payments, not monthly subscriptions.