Certified Data Architect Practice Test

Certified Data Architect Practice Test practice questions, page 5 of 6, with answer review and explanations.

Question 21

Universal Containers has a legacy client server app that has a relational database that needs to be migrated to Salesforce. What are the three key actions that should be done when data modeling in Salesforce? (Choose three.)

  1. Work with legacy application owner to analyze the legacy data model.
  2. Map legacy data to Salesforce objects.
  3. Implement the legacy data model within Salesforce using custom fields.
  4. Identify data elements to be persisted in Salesforce.
  5. Map legacy data to custom metadata types.

Question 22

A customer wants to maintain geographic location information including latitude and longitude in a custom object. What should a data architect recommend to satisfy this requirement?

  1. Create formula fields with geolocation functions for this requirement.
  2. Create custom fields to maintain latitude and longitude information.
  3. Create a geolocation custom field to maintain this requirement.
  4. Recommend AppExchange packages to support this requirement.

Question 23

Universal Containers (UC) is in the process of selling half of its company. As part of this split, UC’s main Salesforce org will be divided into two orgs: Org A and Org B. UC has delivered these requirements to its data architect: 1. The data model for Org B will drastically change with different objects, fields, and picklist values. 2. Three million records will need to be migrated from Org A to Org B for compliance reasons. 3. The migration will need occur within the next two months, prior to the spilt. Which migration strategy should a data architect use to successfully migrate the data?

  1. Use an ETL tool to orchestrate the migration.
  2. Write a script to use the Bulk API.
  3. Use the Salesforce CLI to query, export, and import.
  4. Use Data Loader for export and Data Import Wizard for import.

Question 24

Universal Containers has a requirement to store more than 100 million records in Salesforce and needs to create a custom big object to support this business requirement. Which two tools should a data architect use to build custom big object? (Choose two.)

  1. Go to Big Object in Setup and select new to create big object.
  2. Use Metadata API to create big object.
  3. Go to Object Manager in Setup and select new to create big object.
  4. Use DX to create big object.

Question 25

A casino is implementing Salesforce and is planning to build a customer 360-degree view for a customer who visits its resorts. The casino currently maintains the following systems that record customer activity: 1. Point-of-sale system: All purchases for a customer 2. Salesforce: Ail customer service activity and sales activities for a customer 3. Mobile app: All bookings, preferences, and browser activity for a customer 4. Marketing: All email, SMS, and social campaigns for a customer Customer service agents using Salesforce would like to view the activities from all four systems to provide support to customers. The information has to be current and real time. What strategy should the data architect implement to satisfy this requirement?

  1. Use a customer data mart to create the 360-degree view of the customer.
  2. Periodically upload summary information in Salesforce to build a 360-degree view.
  3. Migrate customer activities from all four systems into Salesforce.
  4. Explore external data sources in Salesforce to build a 360-degree view of the customer.