Data Architect

A customer is facing locking issued when importing large data volumes of order records that are children in amaster-detail relationship with the Account object. What is the recommended way to avoid locking issues during import?A . Import Account records first followed by order records after sorting order by OrderID. B....

Universal Containers (UC) is implementing a new customer categorization process where customers should be assigned to a Gold, Silver, or Bronze category if they've purchased UC's new support service. Customers are expected to be evenly distributed across all three categories. Currently, UC has around 500,000 customers, and is expecting 1%...

A Customer is migrating 10 million order and 30 million order lines into Salesforce using Bulk API. The Engineer is experiencing time-out errors or long delaysquerying parents order IDs in Salesforce before importing related order line items. What is the recommended solution?A . Query only indexed ID field values on...

Universal Containers (UC) is migrating from a legacy system to Salesforce CRM, UC is concerned about the quality of data being entered by users and through external integrations. Which two solutionshould a data architect recommend to mitigate data quality issues?A . Leverage picklist and lookup fields where possible B. Leverage...

NTO has 1 million customer records spanning 25 years. As part of its new SF project, NTO would like to create a master data management strategy to help preserve the history and relevance of its customer data. Which 3activities will be required to identify a successful master data management strategy?...

A customer wants to maintain geographic location information including latitude and longitude in a custom object. What would a data architect recommend to satisfy this requirement?A . Create formula fields with geolocation function for this requirement. B. Create custom fields to maintain latitude and longitude information C. Create a geolocation...

Universal Containers (UC) is planning to move away from legacy CRM to Salesforce. As part of one-time data migration, UC will need to keep the original date when a contact was created in the legacy system. How should an Architect design the data migration solution to meet this requirement?A ....

Universal Containers (UC) is facing data quality issues where Sales Reps are creating duplicate customer accounts, contacts, and leads. UC wants to fix this issue immediately by prompting users about a record that possibly exists in Salesforce. UC wants a report regarding duplicate records. What would be the recommended approach...

Cloud Kicks has the following requirements: - Data needs to be sent from Salesforce to an external system to generate invoices from their Order Management System (OMS). - A Salesforce administrator must be able tocustomize which fields will be sent to the external system without changing code. What are two...

UC has a classic encryption for Custom fields and is leveraging weekly data reports for data backups. During the data validation of exported data UC discovered that encrypted field values are still being exported as part of data exported. What should a data architect recommend to make sure decrypted values...