Data Migration Flashcards
“Cosmic Furniture is setting up a new data warehouse where all the organizational data need to be consolidated from various enterprise systems. The company currently stores almost 20 million account records in Salesforce which need to be extracted for this purpose. Which approach should be recommended by a data architect to avoid timeouts and ensure the best performance during the export?↵Choose 1 answer.”
A. Use Bulk API in parallel mode with PK Chunking
B. Use Bulk API in serial mode with default chunking
C. Use SOAP API in serial mode with PK Chunking
D. Use SOAP API in parallel mode with default chunking
A
“Which of the following are steps that could be taken to optimize a data migration activity?↵Choose 3 answers.”
A. Remove the owners of the records from the role hierarchy.
B. Postpone the creation of sharing rules on the object.
C. Disable workflow rules, validation rules, and triggers.
D. Establish all the lookup and master-detail relationships.
E. Load data with a ‘Public Read/Write’ sharing model.
B,C,E
“The administrator of Cosmic Marketing Solutions will import more than 10 million lead records into Salesforce. However, he is concerned about the large number of duplicate records in the import files. Which of the following can be utilized to ensure that there are no duplicate lead records in Salesforce?↵Choose 2 answers.”
A. Command-line interface of Data Loader
B. Matching and duplicate rules in Salesforce
C. Workflow and validation rules
D. An AppExchange application that allows de-duplication of lead records
B,D
“Cosmic Enterprises has a custom object which has been created to store sales orders in Salesforce only for the purpose of generating reports. An ERP system is the primary system that is used for creating and managing sales orders. There are millions of sales orders that are currently stored in Salesforce. Sales managers often need to see the total number and value of sales orders placed by different types of customers on an yearly basis in Salesforce. However, the sales director is concerned about the data storage required for storing the sales order data. What data archiving strategy should a data architect recommend?↵Choose 1 answer.”
A. Aggregate and store the sales order data in a custom object and delete the original sales orders annually.
B. Aggregate and store the sales order data in a custom object and export the original sales orders monthly.
C. Aggregate and store the sales order data in a custom object and migrate the original sales orders to another org monthly.
D. Aggregate and store the sales order data in a custom object and migrate the original sales orders to another org annually.
A
“Cosmic Service Solutions would like to load more than 10 million account records into Salesforce. More than 20 sharing rules have been defined on the Account object to grant different public groups and roles access to different types of account records based on custom criteria or ownership of records. Which of the following is a valid option for minimizing the time it takes to load the records?↵Choose 1 answer.”
A. Archive the oldest account records before loading the new account records.
B. Defer sharing calculation to temporarily suspend the processing of sharing rules before loading the records.
C. Change the organization-wide default sharing setting to ‘Public Read Only’ before loading the records.
D. Ask Salesforce Support to create skinny tables prior to loading the data.
B
“Cosmic Luxiam has obtained more than 5 million account records from a third-party data source. The sales director of the company would like these records loaded into Salesforce so that sales representatives can reach out to the companies that these accounts represent. Which of the following should a data architect recommend for loading the records?↵Choose 1 answer.”
A. Bulk API
B. Data Loader
C. Data Import Wizard
D. SOAP API
A
“The system administrator of Cosmic Enterprises has been asked to load 1,000 users, 20 million accounts, 30 million contacts, and 50 million opportunities into Salesforce. A number of sharing rules need to be created to define the users’ access to the records of these objects. Which of the following are important considerations for minimizing the loading time?↵Choose 3 answers.”
A. The users should be loaded before other records.
B. Calculation of sharing rules should be deferred until data load is complete.
C. Account records should be loaded before users, contacts, and opportunities.
D. Custom fields should be indexed before loading the data.
E. Sharing rules should be deployed after loading all the data.
A,B,E
“Cosmic Supermarket has recently redefined its security policies due to a data breach. One of the new policies requires regular backup of data. The IT director of the company has asked the administrator to export all the sales data, including accounts, contacts, leads, and opportunities on a weekly basis. In addition, he would also like events such as logins and logouts exported regularly. Which of the following should a data architect recommend for this requirement?↵Choose 2 answers.”
A. Setup Audit Trail
B. AppExchange Application
C. Data Export service
D. Event Monitoring
C,D
“Cosmic Repair Solutions has been using an enterprise system other than Salesforce for managing accounts and cases. The company has recently switched to Salesforce, and the system administrator is trying to import 20 million account records and 50 million related case records into Salesforce using the Bulk API. However, while querying the parent account IDs to import the related case records, he is experiencing long delays. What should a data architect suggest to resolve this issue?↵Choose 1 answer.”
A. Use the external IDs obtained from the enterprise system to query account records and import related case records.
B. Use batch Apex to update the parent account IDs after importing the related case records.
C. Define and populate an auto-number field on the account records and use it to import related case records.
D. Define and populate an indexed text field on the account records and use it to import related case records.
A
“Cosmic Solutions would like to load one million new account records and update 200,000 existing account records. The IT manager has asked a system administrator to use Data Loader for these operations. What should a data architect recommend in order to minimize the data loading time?↵Choose 1 answer.”
A. Use the ‘Insert’ operation to insert the new account records and the ‘Update’ operation to update the existing account records.
B. Use the ‘Upsert’ operation to insert the new account records and update the existing account records.
C. Use the ‘Delete’ operation to delete the existing account records and the ‘Insert’ operation to insert all the account records.
D. Use the ‘Delete’ operation to delete the existing account records and the ‘Upsert’ operation to insert and update all the account records.
A
“The eastern support director of Cosmic Service Solutions would like the regional administrator of the company to load 1000 account records and more than a million related case records into Salesforce. The administrator has already inserted the account records, but while inserting the related cases in batches of 10,000 using Bulk API in parallel mode, he’s experiencing a number of lock errors. What should a data architect recommend to avoid these errors?↵Choose 1 answer.”
A. Group the batches of case records by an external ID field on the Account object.
B. Group the batches of case records by an indexed field that represents the parent account.
C. Group the batches of case records by an autonumber field on the Account object.
D. Group the batches of case records by the Account ID field that represents the parent account.
D
“Cosmic Modular Blocks is a construction company that has migrated its customer data from multiple legacy systems into Salesforce. The migration team detected a high volume of duplicate account records and spent a few weeks on successfully merging the duplicate records prior to going live. The CRM manager of the company has requested the implementation of a process to prevent the creation of duplicate records in the future, especially when loading new records into Salesforce using a tool such as Data Loader. For matching the records, the specific matching algorithms that need to be used are ‘Acronym’, ‘Edit Distance’, and ‘Exact’. Which solution should a data architect recommend for the requirement?↵Choose 1 answer.”
A. Create an Apex trigger on the Account object that performs de-duplication using the ‘System.Deduplication’ Apex class.
B. Use an Apex trigger on the Account object to implement the matching algorithms and prevent the duplication of records.
C. Configure a validation rule on the Account object that is triggered when a matching rule is satisfied for the algorithms.
D. Enable standard account duplicate and matching rules to prevent the duplication of records.
D
“The administrator of Cosmic Solutions is experiencing locking issues while loading millions of account and related opportunity records into Salesforce using Bulk API. What should a data architect recommend to avoid these locking issues?↵Choose 1 answer.”
A. Import the account records, sort the related opportunity records by the AccountId field, and then import the related opportunity records.
B. Import the opportunity records and then import the parent account records.
C. Import the account records, sort the related opportunity records by the Name field, and then import the related opportunity records.
D. Import the opportunity records, sort the parent account records in ascending order, and then import the parent account records.
A
“Cosmic Solutions has more than 10 million records of a custom object called ‘Performance Review’. A developer recently tried to retrieve these records using a Bulk API query for the purpose of extraction, but the query timed out. What should be used to resolve the timeout issue?↵Choose 1 answer.”
A. PK Chunking
B. Metadata API
C. SOAP API
D. Third-party data export tool
A
“The Salesforce Administrator of Cosmic Innovation has loaded more than 100 million test records for two custom objects into a full copy sandbox. This has been done to allow the company’s software engineers to perform some extensive testing prior to the deployment of a custom application. The sandbox is being used exclusively for testing the custom application. One month after loading the data, the lead engineer has requested the deletion of the test records. He would like the engineering team to perform some additional testing that does not require the two custom objects, test records or any other data added by the team. What should a data architect recommend to meet this requirement?↵Choose 1 answer.”
A. Delete the test records permanently using Data Loader.
B. Truncate the two custom objects prior to the test.
C. Refresh the full-copy sandbox prior to the test.
D. Manually delete the metadata and data of the custom objects.
C
