Salesforce Data Architect Exam
Questions With 100% Verified Answers
UC migrating 100,000 Accounts from an enterprise resource
planning (ERP) to salesforce and is concerned about ownership
skew and performance.
Which 3 recommendations should a data architect provide to
prevent ownership skew? ( Choose 3 answers: )
A - Keep users out of public groups that can be used as the source
for sharing rules.
B - Assign a default user as owner of account and do not assign any
role to default user.
C - Assign "view all" permission on profile to give access to account.
D - Assign a default user as owner of accounts and assigned top
most role in hierarchy.
E - Assigned a default user as owner of accounts, and assign any
role in hierarchy. -
correct answer ✅A - Keep users out of public groups that can be
used as the source for sharing rules.
B - Assign a default user as owner of account and do not assign any
role to default user.
D - Assign a default user as owner of accounts and assigned top
most role in hierarchy.
,Salesforce Data Architect Exam
Questions With 100% Verified Answers
Universal Containers (UC) has a variety of systems across its
technology landscape, including Salesforce, legacy enterprise
resource planning (ERP) applications, and homegrown CRM tools.
UC has decided that they would like to consolidate all customer,
opportunity, and order data into Salesforce as part of its master
data management strategy.
What are the three key steps that a data architect should take when
merging data from multiple systems into Salesforce? (Choose
three.)
A - Analyze each system's data model and perform gap analysis
B - Create new fields to store additional values from all of the
systems
C - Install a third-party AppExchange tool to handle the merger
D - Utilize an ETL tool to migrate, transform, and deduplicate data
E - Work with stakeholders to define record and field survivorship
rules -
correct answer ✅A - Analyze each system's data model and
perform gap analysis
D - Utilize an ETL tool to migrate, transform, and deduplicate data
E - Work with stakeholders to define record and field survivorship
rules
,Salesforce Data Architect Exam
Questions With 100% Verified Answers
Universal Container (UC) is migrating data from legacy system to
Salesforce. UC would like to preserve the following information on
records being migrated:
1. Date time stamps for created date and last modified date.
2. Ownership of records belonging to inactive users being migrated
to Salesforce.
Which two solutions should a data architect recommend to
preserve date timestamps and ownership on records? (Choose
two.)
A. Enable Update Records with Inactive Owners Permission
B. Enable modify all and view all permission
C. Enable Set Audit Fields upon Record Creation Permission
D. Log a case with Salesforce to allow updating these fields -
correct answer ✅A. Enable Update Records with Inactive Owners
Permission
C. Enable Set Audit Fields upon Record Creation Permission
Universal Containers has a classic encryption for custom fields and
is leveraging weekly data export for data backups. During the data
validation of exported data, UC discovered that encrypted field
values are still being exported as part of the data export.
, Salesforce Data Architect Exam
Questions With 100% Verified Answers
What should a data architect recommend to make sure decrypted
values are exported during data export?
A. Set up a custom profile for data migration user, and assign View
Encrypted Data
B. Set up a standard profile for data migration user, and assign View
Encrypted Data
C. Create another field to copy data from encrypted field, and use
this field in export
D. Leverage Apex class to decrypt data before exporting it -
correct answer ✅A. Set up a custom profile for data migration
user, and assign View Encrypted Data
**Universal Containers (UC) recently migrated 1 billion customer
related records from a legacy datastore to Heroku Postgres. A
subnet of the data needs to be synchronized with Salesforce so that
service agents are able to support customers directly within the
service console. The remaining non-synchronized set of data will
need to be accessed by Salesforce at any point in time, but UC
management is concerned about storage limitations.
What should a data architect recommend to meet these
requirements with minimal effort?
Questions With 100% Verified Answers
UC migrating 100,000 Accounts from an enterprise resource
planning (ERP) to salesforce and is concerned about ownership
skew and performance.
Which 3 recommendations should a data architect provide to
prevent ownership skew? ( Choose 3 answers: )
A - Keep users out of public groups that can be used as the source
for sharing rules.
B - Assign a default user as owner of account and do not assign any
role to default user.
C - Assign "view all" permission on profile to give access to account.
D - Assign a default user as owner of accounts and assigned top
most role in hierarchy.
E - Assigned a default user as owner of accounts, and assign any
role in hierarchy. -
correct answer ✅A - Keep users out of public groups that can be
used as the source for sharing rules.
B - Assign a default user as owner of account and do not assign any
role to default user.
D - Assign a default user as owner of accounts and assigned top
most role in hierarchy.
,Salesforce Data Architect Exam
Questions With 100% Verified Answers
Universal Containers (UC) has a variety of systems across its
technology landscape, including Salesforce, legacy enterprise
resource planning (ERP) applications, and homegrown CRM tools.
UC has decided that they would like to consolidate all customer,
opportunity, and order data into Salesforce as part of its master
data management strategy.
What are the three key steps that a data architect should take when
merging data from multiple systems into Salesforce? (Choose
three.)
A - Analyze each system's data model and perform gap analysis
B - Create new fields to store additional values from all of the
systems
C - Install a third-party AppExchange tool to handle the merger
D - Utilize an ETL tool to migrate, transform, and deduplicate data
E - Work with stakeholders to define record and field survivorship
rules -
correct answer ✅A - Analyze each system's data model and
perform gap analysis
D - Utilize an ETL tool to migrate, transform, and deduplicate data
E - Work with stakeholders to define record and field survivorship
rules
,Salesforce Data Architect Exam
Questions With 100% Verified Answers
Universal Container (UC) is migrating data from legacy system to
Salesforce. UC would like to preserve the following information on
records being migrated:
1. Date time stamps for created date and last modified date.
2. Ownership of records belonging to inactive users being migrated
to Salesforce.
Which two solutions should a data architect recommend to
preserve date timestamps and ownership on records? (Choose
two.)
A. Enable Update Records with Inactive Owners Permission
B. Enable modify all and view all permission
C. Enable Set Audit Fields upon Record Creation Permission
D. Log a case with Salesforce to allow updating these fields -
correct answer ✅A. Enable Update Records with Inactive Owners
Permission
C. Enable Set Audit Fields upon Record Creation Permission
Universal Containers has a classic encryption for custom fields and
is leveraging weekly data export for data backups. During the data
validation of exported data, UC discovered that encrypted field
values are still being exported as part of the data export.
, Salesforce Data Architect Exam
Questions With 100% Verified Answers
What should a data architect recommend to make sure decrypted
values are exported during data export?
A. Set up a custom profile for data migration user, and assign View
Encrypted Data
B. Set up a standard profile for data migration user, and assign View
Encrypted Data
C. Create another field to copy data from encrypted field, and use
this field in export
D. Leverage Apex class to decrypt data before exporting it -
correct answer ✅A. Set up a custom profile for data migration
user, and assign View Encrypted Data
**Universal Containers (UC) recently migrated 1 billion customer
related records from a legacy datastore to Heroku Postgres. A
subnet of the data needs to be synchronized with Salesforce so that
service agents are able to support customers directly within the
service console. The remaining non-synchronized set of data will
need to be accessed by Salesforce at any point in time, but UC
management is concerned about storage limitations.
What should a data architect recommend to meet these
requirements with minimal effort?