Salesforce Data Architect Practice Exam
Verified Questions, Correct Answers, and
Detailed Explanations for Computer Science
Students||Already Graded A+
1. Which Salesforce feature helps enforce referential integrity
between related objects?
A. Validation Rules
B. Lookup Filters
C. Escalation Rules
D. Approval Processes
Lookup filters restrict which records can be selected in lookup fields,
supporting data integrity.
2. Which data model supports storing multiple sets of address
information on a single Salesforce Account?
A. External Objects
B. Account Contact Relationship + Addresses
C. Schema Builder
D. Custom Metadata
The Account Contact Relationship framework supports multiple
addresses via related objects.
3. Which Salesforce sharing model is most performant for large
data volumes?
A. Per-record sharing
B. Manual sharing
C. Role hierarchy-based sharing
D. Criteria-based sharing rules
,Role hierarchy recalculations are optimized compared to many
discrete sharing rows.
4. What is the primary benefit of skinny tables?
A. More granular security
B. Improved read performance for frequently queried fields
C. Replicated data across orgs
D. Allows unlimited fields
Skinny tables help speed SOQL queries on large objects by reducing
joined fields.
5. Which feature is required when data must be accessible from
external systems without copying data into Salesforce?
A. Big Objects
B. Salesforce Connect
C. Change Data Capture
D. Data Export
Salesforce Connect enables real-time access to external data without
duplication.
6. When should you use a Big Object?
A. When full CRUD operations are required
B. When data must be transacted
C. When storing billions of records with queryable performance
D. When records must participate in workflows
Big Objects store massive volumes efficiently but with limited
automation.
7. What is a best practice for migrating millions of records?
, A. Data Import Wizard
B. Manually use the UI
C. Bulk API
D. SOQL queries
Bulk API supports asynchronous large-volume imports.
8. Which statement about External IDs is true?
A. Must be text only
B. Can be unique and used for upsert operations
C. Cannot be used for deduplication
D. Cannot be used in API calls
External IDs often power upserts and dedupe.
9. Which Salesforce feature supports capturing change events for
downstream integration?
A. Debug Logs
B. Change Data Capture
C. Reports
D. Static Resources
Change Data Capture emits real-time change events for integrations.
10. Which relationship type allows a child to have multiple parents?
A. Master-Detail
B. Many-to-Many (via Junction Object)
C. Hierarchical
D. Lookup
Many-to-many relationships are built using junction objects.
11. Which storage type is unlimited for Big Objects?
Verified Questions, Correct Answers, and
Detailed Explanations for Computer Science
Students||Already Graded A+
1. Which Salesforce feature helps enforce referential integrity
between related objects?
A. Validation Rules
B. Lookup Filters
C. Escalation Rules
D. Approval Processes
Lookup filters restrict which records can be selected in lookup fields,
supporting data integrity.
2. Which data model supports storing multiple sets of address
information on a single Salesforce Account?
A. External Objects
B. Account Contact Relationship + Addresses
C. Schema Builder
D. Custom Metadata
The Account Contact Relationship framework supports multiple
addresses via related objects.
3. Which Salesforce sharing model is most performant for large
data volumes?
A. Per-record sharing
B. Manual sharing
C. Role hierarchy-based sharing
D. Criteria-based sharing rules
,Role hierarchy recalculations are optimized compared to many
discrete sharing rows.
4. What is the primary benefit of skinny tables?
A. More granular security
B. Improved read performance for frequently queried fields
C. Replicated data across orgs
D. Allows unlimited fields
Skinny tables help speed SOQL queries on large objects by reducing
joined fields.
5. Which feature is required when data must be accessible from
external systems without copying data into Salesforce?
A. Big Objects
B. Salesforce Connect
C. Change Data Capture
D. Data Export
Salesforce Connect enables real-time access to external data without
duplication.
6. When should you use a Big Object?
A. When full CRUD operations are required
B. When data must be transacted
C. When storing billions of records with queryable performance
D. When records must participate in workflows
Big Objects store massive volumes efficiently but with limited
automation.
7. What is a best practice for migrating millions of records?
, A. Data Import Wizard
B. Manually use the UI
C. Bulk API
D. SOQL queries
Bulk API supports asynchronous large-volume imports.
8. Which statement about External IDs is true?
A. Must be text only
B. Can be unique and used for upsert operations
C. Cannot be used for deduplication
D. Cannot be used in API calls
External IDs often power upserts and dedupe.
9. Which Salesforce feature supports capturing change events for
downstream integration?
A. Debug Logs
B. Change Data Capture
C. Reports
D. Static Resources
Change Data Capture emits real-time change events for integrations.
10. Which relationship type allows a child to have multiple parents?
A. Master-Detail
B. Many-to-Many (via Junction Object)
C. Hierarchical
D. Lookup
Many-to-many relationships are built using junction objects.
11. Which storage type is unlimited for Big Objects?
