Large Data Volumes Flashcards
“The system administrator of Cosmic Marketing Solutions loads almost 200,000 leads, 100,000 contacts, and 40,000 campaign records into Salesforce every week. The marketing users of the company typically require access to a new contact, lead or campaign record for one year, but data compliance requirements make it necessary to store certain data for at least two years. A data archiving strategy needs to be defined to ensure that the old records are archived once they are not required. What should a data architect recommend for this use case?↵Choose 1 answer.”
A. Use a tier-based strategy for data storage and archiving.
B. Use a strategy that backs up partial data on a regular basis.
C. Use the Recycle Bin to delete old records.
D. Schedule a monthly export and deletion of contacts, leads, and campaigns.
A
“The data architect of Cosmic Solutions is designing a plan for regular archiving and purging of the records of certain custom objects such as ‘Performance Review’ and ‘Inventory’. Which of the following are important considerations for designing an effective archiving strategy?↵Choose 3 answers.”
A. It would be necessary to remove permissions from the profiles of users who can currently access the custom objects.
B. Any regulatory restrictions that would influence the archiving strategy would need to be considered.
C. The number of history retention policies that are defined on each custom object would need to be considered for archiving records.
D. For the purpose of reporting, the information can be aggregated into summary records.
E. It would be necessary to consider whether the archived data would be required for reporting.
B,D,E
“The system administrator of Cosmic Solutions would like to ask Salesforce Support to create skinny tables for certain custom objects to improve the performance of reports and SOQL queries that are called from Visualforce pages. Which of the following are valid reasons for doing this?↵Choose 3 answers.”
A. A skinny table does not include soft-deleted records, i.e., records in the Recycle Bin.
B. The data is always current since the records are synchronized between the base object and the skinny table.
C. A skinny table can contain fields from several custom objects as well as external objects.
D. Salesforce can add up to 200 fields to a skinny table that has been requested for a custom object.
E. Skinny tables perform better due to reduced table joins in the underlying database queries.
A,B,E
"An educational institution needs to connect their Salesforce org to an external system which is used for managing records related to instructors, students, and subjects. A custom object called Schedule has been created in Salesforce to manage class schedules where each schedule should be associated with an instructor, a subject, and students that should attend the class. A data architect has recommended to use Salesforce Connect for the integration. Which of the following statements make this integration solution a valid option?↵Choose 2 answers." A. Salesforce Connect works with custom objects only as standard objects require a different solution B. Salesforce Connect stores data from the external system and synchronizes records continuously C. Salesforce Connect uses external objects which enable remote data to be related with custom objects D. Salesforce Connect is one of the options to consider for org-to-external-system integrations
C,D
“Cosmic Tools uses a Salesforce org that consists of more than 40 million account records. When sales representatives of the company search for specific account records, they often find very old records of companies that are no longer purchasing products. Although these records are required by users like sales managers for reference and reporting in Salesforce, the sales representatives would prefer to not see these records in Salesforce anymore. What should the company’s data architect suggest for this requirement?↵Choose 2 answers.”
A. Schedule a weekly and monthly export of the old records.
B. Delete the old account records every year.
C. Purge the old records from Salesforce every month.
D. Archive the old account records every month.
C,D
“The sales associates of Cosmic Freight Solutions use a Heroku application to manage the lifecycle of orders placed by customers. The application uses a Heroku Postgres database to store order data for CRUD operations. Some users in the company’s sales department use Salesforce for managing records such as accounts. They would like to view all the orders placed by any customer on the customer’s account record in Salesforce. Which of the following should be used to meet this requirement?↵Choose 2 answers.”
A. Heroku External Objects
B. Heroku Redis
C. REST API
D. Salesforce Connect
A,D
“The system administrator of Cosmic Service Solutions is required to regularly load millions of lead records from an external system into a Salesforce org which is used for temporary data archiving and reference. The organization-wide default sharing setting of the Lead object has been set to ‘Private’. Which of the following are important considerations with regard to reducing the total data loading time?↵Choose 2 answers.”
A. Features such as workflow rules and validation rules should be disabled temporarily.
B. The organization-wide default sharing setting should be changed to ‘Public Read Only’.
C. Sharing calculations should be deferred prior to loading the data.
D. A single user should own all the lead records that are loaded.
A,C
“Cosmic Repair Solutions uses a custom object called ‘Repair Job’ to store repair jobs requested by customers in Salesforce. A custom field has been defined on the object to allow sales agents to specify the ‘Job ID’ of each repair job. There are more than 10 million repair jobs that are currently stored in Salesforce, and more than 100,000 new repair jobs are created every week. The data architect of the company has been asked to ensure that sales agents can quickly search for a repair job by using its Job ID as the search term in global search. What should the data architect recommend?↵Choose 1 answer.”
A. Repair jobs that are older than one year should be archived regularly.
B. The ‘Job ID’ field should be set as a non-unique External ID.
C. The ‘Job ID’ field should be set as a unique External ID.
D. Repair jobs should be sent to an external system and exposed in Salesforce.
C
“Cosmic Service Solutions has a Salesforce org with thousands of users who access it concurrently. There are more than 50 million account records and 20 million contact records in Salesforce. More than 200 GB of storage space has been used to store data. Due to large data volumes, users have been experiencing long search times and record saving times. Which of the following approaches can be utilized to mitigate such issues?↵Choose 3 answers.”
A. Use reporting snapshots for aggregating and storing large data volumes.
B. Move old data to an external platform for archiving on a regular basis.
C. Ask Salesforce Support to add indexes to custom fields that are often used for searches.
D. Ask Salesforce Support to create skinny tables for frequently used fields.
E. Utilize Apex triggers to delete accounts and contacts and store them in custom objects.
B,C,D
“Cosmic Service Solutions uses Salesforce for employee management using a custom object called ‘Employee’. A Heroku application is used by some employees in the IT department to manage internal support tickets. The HRIS Director of the company would like to make the internal support tickets visible in Salesforce. All internal support tickets submitted by an employee should be visible on the employee’s record in Salesforce. Salesforce will only be used to view the tickets and not manage them. Which of the following should be used to meet this requirement?↵Choose 3 answers.”
A. Indirect Lookup Relationship
B. External Lookup Relationship
C. External Service
D. External Data Source
E. External Object
A,D,E
“Cosmic Service Solutions would like to automatically archive opportunity records that are older than one year. Users do not require access to these records once they are archived. Which of the following can be used to meet this requirement?↵Choose 2 answers.”
A. Third-Party ETL Tool
B. Data Loader
C. Workbench
D. Data Export Wizard
A,B
“The system administrator of Cosmic Service Solutions has been asked to create a report that displays certain types of accounts and related cases in Salesforce. There are more than 50 million accounts, and on average, each account has 5 related cases. Which of the following approaches can be utilized to ensure that the performance of the report does not degrade?↵Choose 2 answers.”
A. Ensure that appropriate indexes have been created
B. Reduce the number of master-detail relationships in the application
C. Ensure that filters are applied to the report to selectively retrieve data
D. Ensure that there are no more than 1,000,000 accounts in the system
A,C
“The sales users of Cosmic Solutions regularly delete ‘Closed Lost’ opportunities. For the purpose of reference and reporting, the sales director of the company would like to maintain opportunity data even after opportunities have been removed from the Recycle Bin. However, he is concerned about data storage limitations due to the growing number of records. What should a data architect recommend to meet this requirement?↵Choose 1 answer.”
A. Send the opportunities to a data warehouse before they are deleted, and flag them as deleted in the data warehouse.
B. Send the opportunities to another enterprise system before they are deleted, and flag them as deleted in the target system.
C. Use a custom object and an Apex trigger to store deleted opportunities in Salesforce.
D. Create a custom field on the Opportunity object to allow users to specify which opportunities need to be deleted.
A
“The sales director of Cosmic Enterprises is concerned about data deletions in Salesforce due to a recent incident in the company. On average, the company adds 100 new account records to Salesforce every week. One of the sales users with API access deleted more than 100,000 account records permanently. The data architect has been asked to recommend an appropriate solution that can be utilized to recover from such incidents. The sales director is less concerned about the deletion of records that were created recently, since each user is required to use an Excel spreadsheet to record information about accounts created by them every day and submit it to their supervisor. Each spreadsheet is stored in a separate database for one week. What should the data architect recommend?↵Choose 1 answer.”
A. Use Data Loader to manually export all the account records regularly.
B. Install an AppExchange application that can be used to recover deleted account records.
C. Use a third-party solution that provides data recovery services.
D. Schedule a weekly export of all the account records in Salesforce.
D
“A local firm that uses Salesforce needs to access and work with data from a regional partner company. The org users require real-time access to the external data as well as make changes to it, create certain reports for their stakeholders and collaborate through Chatter to efficiently track progress and keep team members up-to-date. A Salesforce Architect has been delegated to assess endpoint capabilities of the partner company and finds that it uses an enterprise resource planning application that supports OData 2.0. What integration solution should be used to meet the requirement?↵Choose 1 answer.”
A. Use Salesforce Connect and choose an External Data Source that uses an OData adapter
B. Use Heroku Connect and use Accelerated Polling to utilize Streaming API capabilities
C. Use Salesforce Connect and choose an External Data Source that uses a Cross Org adapter
D. Use Heroku Connect and use Heroku External Object which connects through OData
A
