Certified Data Architect
Free trial
Verified
Question 1
Universal 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?
- A: Leverage real-time integration to pull records into Salesforce.
- B: Build a swivel chair solution to go into the legacy system and display records.
- C: Leverage mashup to display historical records in Salesforce.
- D: Bring all data in Salesforce, and delete it after a year.
Question 2
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?
- A: Email all customers and ask them to verify their information and to call NTO if their address is incorrect.
- B: Delete contacts when the mail is returned to save postal costs for NTO.
- C: Have the sales team call all existing customers and ask to verify the contact details.
- D: Use a third-party data source to update the contact information in Salesforce.
Question 3
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?
- A: Migrate legacy data to a staging database for mapping then leverage an ETL tool to transform the data and load into Salesforce.
- B: Migrate the legacy data leveraging an ETL tool to transform data types and load data into Salesforce.
- C: Export legacy data into CSV files and leverage data loader to load data into Salesforce.
- D: Export legacy data into the staging database and leverage stored procedures to transform data types before loading into Salesforce.
Question 4
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?
- A: Extract the data using data loader and use excel to merge the duplicate records
- B: Utilize a data warehouse as the system of truth
- C: Develop an ETL process that utilizes the merge API to merge the duplicate records
- D: Implement duplicate rules
Question 5
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?
- A: Maximum page size for server-driven paging
- B: Maximum external objects per org
- C: OData callout limits per day
- D: Maximum number of records returned
Question 6
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?
- A: Send customer record changes from Salesforce to the system of truth in real time.
- B: Send customer data nightly to the system of truth in a scheduled batch job.
- C: Have each system pull the record changes from Salesforce using change data capture.
- D: Send customer record changes from Salesforce to each system in a nightly batch job.
Question 7
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?
- A: Change the WHERE clause to filter by a deterministic defined value.
- B: Change query to SOSL.
- C: Remove description from the requested field set.
- D: Add LIMIT 100 to the query.
Question 8
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?
- A: Use AppExchange solution to address the requirement.
- B: Utilize the Authorization Form Consent object to capture the consent.
- C: Use custom fields to capture the authorization details.
- D: Create a custom object to maintain the authorization.
Question 9
Northern Trail Outfitters (NTO) plans to maintain contact preferences for customers and employees. NTO has implemented the following:
- Customers are Person Accounts for their retail business.
- Customers are represented as Contacts for their commercial business.
- Employees are maintained as Users.
- 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?
- A: Create case for contact preferences, and use this to validate the preferences for Lead, Person Accounts, and Users.
- B: Use Individual objects to maintain the preferences with relationships to Lead, Person Account, and Users.
- C: Create custom fields for contact preferences in Lead, Person Account, and Users objects.
- D: Create a custom object to maintain preferences and build relationships to Lead, Person Account, and Users.
Question 10
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:
- A record is created in Project__c and used to track the project through completion.
- 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.
- Ability to view or edit the VTOTime__c object needs to be the same as the Project__c record.
- 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: Master Detail field on Project__c to VTOTime__c showing a list of VTOTime__c Records 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: Lookup Field on Project__c to VTOTime__C displaying a list of VTOTime__C in a related list.
- D: Master Detail Field on VTOTime__c to Project__c with rollup summary field on Project__c showing sum of hours from VTOTime__c records.
Question 11
Northern Trail Outfitters (NTO) has a variety of customers that include households, businesses, and individuals.
The following conditions exist within its system:
- NTO has a total of five million customers.
- 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.)
- A: Invest in data duplication tool to de-dupe and merge duplicate records across all systems.
- B: Use Salesforce CDC to sync customer data across all systems to keep customer record in sync.
- C: Create a customer master database external to Salesforce as a system of truth and sync the customer data with all systems.
- D: Create a unique global customer ID for each customer and store that in all systems for referential identity.
- E: Duplicate customer records across the systems and provide a two-way sync of data between the systems.
Question 12
Northern Trail Outfitters (NTO) has multiple Salesforce orgs based on regions. Users need read-only access to customers across all Salesforce orgs.
Which feature in Salesforce can be used to provide access to customer records across all NTO orgs?
- A: Salesforce 2 Salesforce
- B: External APIs
- C: Salesforce Connect
- D: Federated Search
Question 13
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?
- A: Change weekly backup process to daily backup, and implement a custom restore solution.
- B: Use Bulk API to extract data on daily basis to EDW and REST API for restore.
- C: Use ETL tool for backup and restore from EDW.
- D: Use AppExchange package for backup and restore.
Question 14
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?
- A: A middleware solution that extracts and distributes data across both the hub and spokes.
- B: Develop custom APIs to poll the spoke org for change data and push into the hub org.
- C: Develop custom APIs to poll the hub org for change data and push into the spoke orgs.
- D: A backup and archive solution that extracts and restores data across orgs.
Question 15
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:
- Salesforce CRM
- Custom billing solution
- Customer master data management (MDM)
- Contract management system
- Marketing solution
What should a data architect recommend that would help uniquely identify the customer across multiple systems?
- A: Store the Salesforce ID in all the solutions to identify the customer.
- B: Create a custom field as external ID to maintain the customer ID from the MDM solution.
- C: Create a custom object that will serve as a cross-reference for the customer ID.
- D: Create a customer database, and use this ID in all systems.
Question 16
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.)
- A: Standard SOQL queries
- B: Async SOQL with a custom object
- C: Standard reports and dashboards
- D: Einstein Analytics
Question 17
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:
- Data owner
- Security level (i.e. confidential)
- 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?
- A: Build reports for field Information, then export the information to classify and report for audits.
- B: Create a custom object and field to capture necessary compliance information and build custom reports.
- C: Use the Metadata API to extract field attribute information and use the extract to classify and build reports.
- D: Use field metadata attributes for compliance categorization, data owner, and data sensitivity level.
That’s the end of your free questions
You’ve reached the preview limit for Certified Data ArchitectConsider upgrading to gain full access!
Free preview mode
Enjoy the free questions and consider upgrading to gain full access!