Salesforce Data Architecture and Management Designer

4.2 (10 reviews)

What is Multitenancy?

Click the card to flip 👆

1 / 124

Terms in this set (124)

Multitenancy is a means of providing a single application to multiple organizations from a single hardware/software stack.

What does Salesforce do when providing its CRM to a new customer?

Instead of providing a complete set of hardware/software resources to an organization, Salesforce inserts a layer of software between the single instance and other customer deployments. This layer is invisible to the organizations, which only see their own data and schemas while Salesforce reorganizes the data behind the scenes to perform efficient operations.

How does Salesforce ensure that tenant-specific customizations do not breach the security of other tenants or affect their performance?

Salesforce uses a runtime engine that generates application components for each organization using the customer's metadata.

How does Salesforce store the application data for each organization?

In a few large database tables that are partitioned by tenant and serve as heap storage. The platform's runtime engine then materializes virtual tables based on the customer's metadata.

What are two side-effects of the way that Salesforce stores customer application data?

1.) Traditional performance-tuning techniques will show little to no results.
2.) You cannot optimize the underlying SQL of the application because it is generated by the system, and not written by each tenant.

How long might it take before the text in a searchable object's created or updated record is searchable?

15 minutes or more

In what order does Salesforce perform indexed searches?

1.) Searches the indexes for appropriate records
2.) Narrows down the results by access permissions, search limits, and other filters, creating a result set
3.) Once a result set reaches a predetermined size, all other records are discarded
4.) Finally, the result set is used to query the records from the database to retrieve the fields that a user sees

What are the main areas of the application that are impacted by differing (or suboptimal) architectures in implementations with large data volumes?

1.) The loading or updating of large numbers of records, either directly or with integrations.
2.) Extracting records using reports, list views, or queries.

What is the Force.com Query Optimizer?

The Force.com Query Optimizer works behind the scenes to determine the best path to the data being requested based on the filters in the query. It will determine the best index from which to drive the query, the best table from which to drive the query if no good index is available, and more.

What is PK Chunking?

PK Chunking (or Primary Key Chunking) is a strategy for querying large data sets. PK Chunking is a feature of the Bulk API that splits a query into chunks of records with sequential record Ids (i.e. the Primary Keys). Ids are always indexed, so this is an efficient method for querying large data sets.