Certified Data Architect — Free Practice Questions
10 free sample questions from a bank of 83, with the correct answers and explanations. No signup required — start practising right now.
1Universal Containers (UC) is replacing a home grown CRM solution with Salesforce. UC has decided to migrate operational (open and active) records to Salesforce, while keeping historical records in legacy system. UC would like historical records to be available in Salesforce on an as needed basis.
Which solution should a data architect recommend to meet business requirement?
Leverage real-time integration to pull records into Salesforce.
Build a swivel chair solution to go into the legacy system and display records.
Leverage mashup to display historical records in Salesforce.
Bring all data in Salesforce, and delete it after a year.
Answer: C
2Northern 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?
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.
Answer: D
3Universal 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?
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.
Answer: B
4Universal 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?
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
Answer: C
5Northern 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?
Maximum page size for server-driven paging
Maximum external objects per org
OData callout limits per day
Maximum number of records returned
Answer: C
6Universal 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?
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.
Answer: C
7The 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?
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.
Answer: C
8Northern 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?
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.
Answer: B
9Northern Trail Outfitters (NTO) plans to maintain contact preferences for customers and employees. NTO has implemented the following:
1. Customers are Person Accounts for their retail business.
2. Customers are represented as Contacts for their commercial business.
3. Employees are maintained as Users.
4. Prospects are maintained as Leads.
NTO needs to implement a standard communication preference management model for Person Accounts, Contacts, Users, and Leads.
Which option should the data architect recommend NTO to satisfy this requirement?
Create case for contact preferences, and use this to validate the preferences for Lead, Person Accounts, and Users.
Use Individual objects to maintain the preferences with relationships to Lead, Person Account, and Users.
Create custom fields for contact preferences in Lead, Person Account, and Users objects.
Create a custom object to maintain preferences and build relationships to Lead, Person Account, and Users.
Answer: D
10A 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?
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.