← Back to exam page

Free CERTIFIED-DATA-ARCHITECT – Salesforce CERTIFIED-DATA-ARCHITECT Practice Test Question

Loading demo links...

Showing 7–9 of 9 questions

Question 7 (Topic 1)

Universal Containers (UC) is implementing Salesforce for lead management. UC procures lead data from multiple sources and would like to make sure lead data has company profile and location information. Which solution should a data architect recommend to make sure lead data has both profile and location information?

Select an option, then click Submit answer.

  • ○ Export data out of Salesforce and send to another team to populate company profile and location data.
  • ○ Leverage external data providers to populate company profile and location data.
  • ○ Run reports to identify records which do not have company profile and location data.
  • ○ Ask sales people to search for and populate company profile and location data.
Question 8 (Topic 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?

Select an option, then click Submit 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.
Question 9 (Topic 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?

Select an option, then click Submit 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.