Where can you use truncation?
Only in a sandbox org
What does truncation remove?
All records in the object Recycle bin History Related events Tasks Notes Attachments
How do you setup truncation?
Enable through the “User Interface” settings, and then go to Object Management settings for custom objects
When can you not truncate an object?
- When they are referenced by another object through a lookup field
- On the master side of a master-detail relationship
- Referenced in a reporting snapshot
- Have a custom index
- Have an external ID
- Have activated skinny tables
- When an org has reached its limit on allowed custom objects
Why would you backup Salesforce data (including metadata)?
Recover from data corruption (unintended user error or malicious activity)
Prepare for data migration rollback
Archive data to reduce volumes
Replicate data to a data warehouse / BI
Take snapshots of development versions
Which APIs can be used to backup data and metadata?
REST API
SOAP API
Bulk API
Metadata API
What does a Full Backup type do?
It Contains all the data
What does an Incremental Backup type do (and which API is best suited for it)?
Backup differences since last full backup (daily incremental backup, weekly, monthly, etc). The data replication API (SOAP API) is particularly adapted to this type of backup
What does a Partial Backup type do?
Backup a subset of data (for example, closed cases only)
If you need to preserve governor limits regarding the number of API calls, which API would be recommended?
Bulk API does not consume API calls, but consumes Bulk API calls which are less restrictive
If you need to preserve the governor limit regarding “number of batches per rolling 24 hour period”, which API would be recommended?
REST or SOAP are not subject to Bulk-specific governor limits, however they have their own limits
If you need to backup an object containing a large volume of records (i.e. more than 2M records) or do a backup that raises performance challenges, which API would be recommended
Bulk API will generally be faster than the other APIs but the REST or SOAP APIs might sometimes get better results depending on several factors: query batch size, current asynchronous load on the instance, degree of parallelization
If you need to backup an object that is not yet supported by the Bulk API (ie CaseStatus, OpportunityStage, AcceptedEventRelation, etc), which API would be recommended?
REST or SOAP. Bulk API does not yest support all queryable objects in Spring ‘15 release
If you need to backup an object that contains a lot of XML-like information (example: EmailMessage), which API would be recommended?
Rest or Bulk. While this is not directly caused by the Salesforce SOAP API, we have seen some XML parsers encountering difficulties when processing the HTTP response (mix of XML-based protocol and XML data)
If you need to backup metadata which API would be recommended?
The Metadata API is by far the most exhaustive API to retrieve metadata, however a large part of the metadata is also available in the REST, SOAP and Tooling APIs
If you need to backup files (Attachment, ContentVersion, Document, FeedItem, StaticResource, etc), which API would be recommended?
REST or SOAP. The Bulk API does not yet support Base64 fields in Spring 15 release
What does the Salesforce Data Recovery service provides?
SFDC backs up customer data for up to 90 days. If you do not have your own backup, SFDC can provide comma-separated values CSV files containing your data upon request (at an additional cost)
What does the Scheduled Data Export tool do?
Your org can generate backup files of your data on a weekly or monthly basis, depending on your edition. You can then download all your org data into a set of CSV files and insert the data into your org by running a data migration project
What does the Data Loader do?
Data Loader is a client application you can use to export your data (up to 5M records). Then insert the data into your org by running a data migration project
What does Organization Sync do?
The Organization Sync feature allows users to work on their most business-critical processes and data whenever their primary org is experiencing downtime or maintenance. It is a perfect solution for a failover strategy. However, it is not a replacement for a backup and restore strategy, since it can replicate erroneous data updates, or data deletions, in real-time
What do the SFDC Professional Services and Advisory Services do?
SFDC experts and innovators are available within Salesforce Services that will insert your data backups / exports into your organization for a fee
Scenario: Your full database backups configured using Data Loader is taking a lot of time to complete and sometimes slow down other jobs - every night. What could be a possible solution?
Instead of doing an entire local database refresh, do a nightly incremental data backup only (data that is new or updated since the previous incremental backup)
What does sharing recalculations and Bulk API jobs have in common?
They both draw from the org’s available pool of asynchronous processing threads. This competition causes both jobs to go slower than if they were scheduled to happen apart from one another.
What are three recommended methods for downloading data for a backup or archive? (Choose 3)
A. Schedule a weekly export from the system
B. Use the Dataloader to download the data
C. Schedule a report to email the Admin
D. Configure outbound messages for all objects
E. Use an Extract Transform Load (ETL) tool
A. Schedule a weekly export from the system
B. Use the Dataloader to download the data
E. Use an Extract Transform Load (ETL) tool
