Salesforce Data Model & Database Design Flashcards

1
Q

Q. What is the Salesforce data model?

A

A. The Salesforce data model consists of objects, fields, and relationships that define how data is structured and stored in the Salesforce database.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Q. What are the main types of objects in Salesforce?

A

A. Standard Objects, Custom Objects, External Objects, Big Objects, and Junction Objects.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Q. What are records in Salesforce?

A

A. Records are instances of objects that store specific data entries, similar to rows in a database table.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Q. What are standard objects?

A

A. Predefined objects provided by Salesforce, such as Accounts, Contacts, Leads, and Opportunities.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Q. What are custom objects?

A

A. User-defined objects that extend Salesforce functionality and store organization-specific data.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Q. What are external objects?

A

A. Objects that represent data stored outside Salesforce, accessed using Salesforce Connect.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Q. What are Big Objects?

A

A. Special objects designed to store large amounts of data efficiently in Salesforce.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Q. What are the different types of fields in Salesforce?

A

A. Standard Fields, Custom Fields, Formula Fields, Roll-Up Summary Fields, Lookup Fields, Master-Detail Fields, and External Lookup Fields.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Q. What is the difference between a standard field and a custom field?

A

A. Standard fields come prebuilt with Salesforce objects, while custom fields are user-defined.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Q. What are the different types of relationships in Salesforce?

A

A. Lookup Relationship, Master-Detail Relationship, Many-to-Many Relationship (via Junction Objects), and Hierarchical Relationship.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Q. What is a lookup relationship?

A

A. A loose association between two objects where one object can reference another without dependency.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Q. What is a master-detail relationship?

A

A. A strong relationship where the child record is dependent on the parent record and inherits security and ownership settings.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Q. What is a junction object?

A

A. A custom object that enables many-to-many relationships between two other objects.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Q. What is the difference between lookup and master-detail relationships?

A

A. Lookup relationships are optional, while master-detail relationships enforce parent-child dependency.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Q. What happens when a parent record in a master-detail relationship is deleted?

A

A. All related child records are also deleted (cascade delete).

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Q. What is the Schema Builder in Salesforce?

A

A. A visual tool that allows users to view and design object relationships graphically.

17
Q

Q. What is metadata in Salesforce?

A

A. Metadata is data about data, defining object structure, field settings, workflows, and page layouts.

18
Q

Q. What is the difference between metadata and data in Salesforce?

A

A. Metadata defines the structure of Salesforce (objects, fields, layouts), while data refers to actual records stored in objects.

19
Q

Q. What are record types in Salesforce?

A

A. Record types allow different business processes, page layouts, and picklist values for the same object.

20
Q

Q. What is a page layout in Salesforce?

A

A. A tool that controls the fields, sections, and related lists displayed on a record’s detail page.

21
Q

Q. What is the difference between record types and page layouts?

A

A. Record types define different business processes, while page layouts control the user interface.

22
Q

Q. What are validation rules in Salesforce?

A

A. Rules that enforce data quality by preventing incorrect data entry using formulas.

23
Q

Q. What is a unique field in Salesforce?

A

A. A field that ensures no duplicate values exist in the database for that specific field.

24
Q

Q. What is a required field?

A

A. A field that must have a value before a record can be saved.

25
Q

Q. What is a default value in Salesforce fields?

A

A. A predefined value assigned to a field when a new record is created.

26
Q

Q. What is a formula field?

A

A. A read-only field that calculates values dynamically based on other fields.

27
Q

Q. What is a roll-up summary field?

A

A. A field that calculates aggregate values (SUM, COUNT, MIN, MAX) from related child records in a master-detail relationship.

28
Q

Q. What is the difference between a formula field and a roll-up summary field?

A

A. Formula fields compute values at the record level, while roll-up summary fields aggregate data from related child records.

29
Q

Q. What are best practices for designing a Salesforce data model?

A

A. Use standard objects when possible, minimize the number of fields, optimize relationships, leverage formula fields, and ensure data security.

30
Q

Q. Why is it important to minimize custom objects?

A

A. Excessive custom objects can lead to performance issues and increased maintenance costs.

31
Q

Q. What is the impact of large data volumes (LDV) on the Salesforce data model?

A

A. LDV can affect query performance, indexing, and storage limits.

32
Q

Q. What are the primary storage types in Salesforce?

A

A. Data Storage (records) and File Storage (attachments, documents).

33
Q

Q. How is Salesforce storage calculated?

A

A. Based on the number of records stored and file sizes.

34
Q

Q. What are governor limits in Salesforce?

A

A. Limits imposed by Salesforce to ensure efficient processing and prevent monopolization of resources.

35
Q

Q. What are the methods for exporting data from Salesforce?

A

A. Data Export Service, Data Loader, and APIs.

36
Q

Q. What is the difference between Data Loader and Data Import Wizard?

A

A. Data Loader is for bulk operations with more control, while Data Import Wizard is a simple tool for standard objects with predefined mappings.

37
Q

Q. What is Salesforce Data Masking?

A

A. A technique to obfuscate sensitive data when moving records between environments.