Large Data Volume Considerations: 20% Flashcards
What is the query plan tool?
In the developer console, can be used to check the available plans for executing a SOQL query
What are Skinny Tables?
Can be created for objects by contacting Salesforce support. They can increase the performance of queries
What is Salesforce Backup?
Add-on native product, which enables data backup and restoration. A single record or subset of records can be restored
What tools can be used to export data as part of an archiving strategy?
Data Loader or an ETL tool
How large is a default batch for Bulk API 2.0?
10000 records
What questions should be asked when trying to determine an archiving strategy?
- Is it necessary to create reports on the custom objects?
- Will the archived data be needed by users for reference or reporting?
- Will the purged data be needed by users for any business operation?
- How do regulatory and legal policies influence the data archiving requirements?
- What is the frequency?
- How will the frequency affect existing business operations?
How many fields can Field Audit History track?
Default is 20 fields but can be increased to 60 fields
What is an Indirect lookup relationship?
Indirect lookup relationship links a child external object to a parent standard or custom object.
What is an External lookup relationship?
External lookup relationship links a child standard, custom, or external object to a parent external object.
What is Heroku Connect?
Similar to Salesforce Connect in that it allows you to virtualize data in Salesforce from an external data source. The data is stored on a Heroku Postgres SQL database. Mapped data can be synchronized bidirectionally between Salesforce and Heroku
What are the aspects of Data Virtualization?
- Source/Target
- Integration Type
- Timing Nature
