Data-Architect Exam Dumps - Salesforce Certified Data Architect (SP23)

Question # 4

An architect has been asked to provide error messages when a future date is detected in a custom Birthdate _c field on the Contact object. The client wants the ability to translate the error messages. What are two approaches the architect should use to achieve this solution? Choose 2 answers

Implement a third -party validation process with translate functionality.

Create a trigger on Contact and add an error to the record with a custom label.

Create a workflow field update to set the standard ErrorMessage field.

Create a validation rule and translate the error message with translation workbench.

Full Access

Question # 5

How can an architect find information about who is creating, changing, or deleting certain fields within the past two months?

Remove "customize application" permissions from everyone else.

Export the metadata and search it for the fields in question.

Create a field history report for the fields in question.

Export the setup audit trail and find the fields in question.

Full Access

Question # 6

UC has a classic encryption for Custom fields and is leveraging weekly data reports for data backups. During the data validation of exported data UC discovered that encrypted field values are still being exported as part of data exported. What should a data architect recommend to make sure decrypted values are exported during data export?

Set a standard profile for Data Migration user, and assign view encrypted data

Create another field to copy data from encrypted field and use this field in export

Leverage Apex class to decrypt data before exporting it.

Set up a custom profile for data migration user and assign view encrypted data.

Full Access

Question # 7

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:

Assigned a default user as owner of accounts, and assign role in hierarchy.

Keep users out of public groups that can be used as the source for sharing rules.

Assign a default user as owner of account and do not assign any role to default user.

Assign â€œview allâ€ permission on profile to give access to account.

Assign a default user as owner of accounts and assigned top most role in hierarchy.

Full Access

Question # 8

UC needs to load a large volume of leads into salesforce on a weekly basis. During this process the validation rules are disabled.

What should a data architect recommend to ensure data quality is maintained in salesforce.

Activate validation rules once the leads are loaded into salesforce to maintain quality.

Allow validation rules to be activated during the load of leads into salesforce.

Develop custom APEX batch process to improve quality once the load is completed.

Ensure the lead data is preprocessed for quality before loading into salesforce.

Full Access

Question # 9

Universal Containers would like to remove data silos and connect their legacy CRM together with their ERP and with Salesforce. Most of their sales team has already migrated to Salesforce for daily use, although a few users are still on the old CRM until some functionality they require is completed. Which two techniques should be used for smooth interoperability now and in the future.

Replicate ongoing changes in the legacy CRM to Salesforce to facilitate a smooth transition when the legacy CRM is eventually retired.

Specify the legacy CRM as the system of record during transition until it is removed from operation and fully replaced by Salesforce.

Work with stakeholders to establish a Master Data Management plan for the system of record for specific objects, records, and fields.

Do not connect Salesforce and the legacy CRM to each other during this transition period, but do allow both to interact with the ERP.

Full Access

Question # 10

Universal Container has implemented Sales Cloud to manage patient and related health records. During a recent security audit of the system it was discovered that same standard and custom fields need to encrypted.

Which solution should a data architect recommend to encrypt existing fields?

Use Apex Crypto Class encrypt customer and standard fields.

Implement classic encryption to encrypt custom and standard fields.

Implement shield platform encryption to encrypt and standard fields

Expert data out of Salesforce and encrypt custom and standard fields.

Full Access

Question # 11

What is an advantage of using Custom metadata type over Custom setting?

Custom metadata records are not copied from production to sandbox.

Custom metadata types are available for reporting.

Custom metadata records are deployable using packages.

Custom metadata records are editable in Apex.

Full Access

Question # 12

Cloud Kicks stores Invoice records in a custom object. Invoice records are being sent to the Accounting department with missing States and incorrectly formatted Postal Codes.

Which two actions should Cloud Kicks take to improve data quality? (Choose two.)

Change each address field to required on the Page Layout.

Write an Apex Trigger to require all fields to be populated.

Utilize a Validation Rule with a REGEX operator on Postal Code.

Utilize a Validation Rule with a CONTAINS operator on address fields.

Full Access

Question # 13

Get Cloud Consulting needs to integrate two different systems with customer records into the Salesforce Account object. So that no duplicate records are created in Salesforce, Master Data Management will be used.

An Architect needs to determine which system is the system of record on a field level.

What should the Architect do to achieve this goal?

Master Data Management systems determine system of record, and the Architect doesn't have to think about what data is controlled by what system.

Key stakeholders should review any fields that share the same purpose between systems to see how they will be used in Salesforce.

The database schema for each external system should be reviewed, and fields with different names should always be separate fields in Salesforce.

Any field that is an input field in either external system will be overwritten by the last record integrated and can never have a system of record.

Full Access

Question # 14

UC has one SF org (Org A) and recently acquired a secondary company with its own Salesforce org (Org B). UC has decided to keep the orgs running separately but would like to bidirectionally share opportunities between the orgs in near-real time.

Which 3 options should a data architect recommend to share data between Org A and Org B?

Choose 3 answers.

Leverage Heroku Connect and Heroku Postgres to bidirectionally sync Opportunities.

Install a 3rd party AppExchange tool to handle the data sharing

Develop an Apex class that pushes opportunity data between orgs daily via the Apex schedule.

Leverage middleware tools to bidirectionally send Opportunity data across orgs.

Use Salesforce Connect and the cross-org adapter to visualize Opportunities into external objects

Full Access

Question # 15

Cloud Kicks has the following requirements:

- Data needs to be sent from Salesforce to an external system to generate invoices from their Order Management System (OMS).

- A Salesforce administrator must be able to customize which fields will be sent to the external system without changing code.

What are two approaches for fulfilling these requirements? (Choose two.)

A set to determine which fields to send in an HTTP callout.

An Outbound Message to determine which fields to send to the OMS.

A Field Set that determines which fields to send in an HTTP callout.

Enable the field -level security permissions for the fields to send.

Full Access

Question # 16

Universal Containers (UC) has over 10 million accounts with an average of 20 opportunities with each account. A Sales Executive at UC needs to generate a daily report for all opportunities in a specific opportunity stage.

Which two key considerations should be made to make sure the performance of the report is not degraded due to large data volume?

Number of queries running at a time.

Number of joins used in report query.

Number of records returned by report query.

Number of characters in report query.

Full Access

Question # 17

Universal Containers wants to automatically archive all inactive Account data that is older than 3 years. The information does not need to remain accessible within the application. Which two methods should be recommended to meet this requirement? Choose 2 answers

Use the Force.com Workbench to export the data.

Schedule a weekly export file from the Salesforce UI.

Schedule jobs to export and delete using an ETL tool.

Schedule jobs to export and delete using the Data Loader.

Full Access

Question # 18

Universal Container is Implementing salesforce and needs to migrate data from two legacy systems. UC would like to clean and duplicate data before migrate to Salesforce.

Which solution should a data architect recommend a clean migration?

Define external IDs for an object, migrate second database to first database, and load into Salesforce.

Define duplicate rules in Salesforce, and load data into Salesforce from both databases.

Set up staging data base, and define external IDs to merge, clean duplicate data, and load into Salesforce.

Define external IDs for an object, Insert data from one database, and use upsert for a second database

Full Access

Question # 19

North Trail Outfitters (NTO) operates a majority of its business from a central Salesforce org, NTO also owns several secondary orgs that the service, finance, and marketing teams work out of, At the moment, there is no integration between central and secondary orgs, leading to data-visibility issues.

Moving forward, NTO has identified that a hub-and-spoke model is the proper architect to manage its data, where the central org is the hub and the secondary orgs are the spokes.

Which tool should a data architect use to orchestrate data between the hub org and spoke orgs?

A middleware solution that extracts and distributes data across both the hub and spokes.

Develop custom APIs to poll the hub org for change data and push into the spoke orgs.

Develop custom APIs to poll the spoke for change data and push into the org.

A backup and archive solution that extracts and restores data across orgs.

Full Access

Question # 20

Universal Containers keeps its Account data in Salesforce and its Invoice data in a third -party ERP system. They have connected the Invoice data through a Salesforce external object. They want data from both Accounts and Invoices visible in one report in one place. What two approaches should an architect suggest for achieving this solution? Choose 2 answers

Create a report in an external system combining Salesforce Account data and Invoice data from the ERP.

Create a report combining data from the Account standard object and the Invoices external object.

Create a Visualforce page combining Salesforce Account data and Invoice external object data.

Create a separate Salesforce report for Accounts and Invoices and combine them in a dashboard.

Full Access

Question # 21

Universal Containers has a requirement to store more than 100 million records in salesforce and needs to create a custom big object to support this business requirement.

Which two tools should a data architect use to build custom object?

Use DX to create big object.

Use Metadata API to create big object.

Go to Big Object In setup select new to create big object.

Go to Object manager In setup and select new to create big object.

Full Access

Question # 22

Northern Trail Outfitter has implemented Salesforce for its associates nationwide, Senior management is concerned that the executive dashboard are not reliable for their real-time decision-making. On analysis , the team the following issues with data entered in Salesforce.

Information in certain records is incomplete.

Incorrect entry in certain fields causes records to be excluded in report fitters.

Duplicate entries cause incorrect counts.

Which three steps should a data architect recommend to address the issues?

Periodically export data to cleanse data and import them back into Salesforce for executive reports.

Build a sales data warehouse with purpose-build data marts for dashboards and senior management reporting.

Explore third-party data providers to enrich and augment information entered in salesforce.

Leverage Salesforce features, such as validate rules, to avoid incomplete and incorrect records.

design and implement data-quality dashboard to monitor and act on records that are incomplete or incorrect

Full Access

Question # 23

UC is rolling out Sales App globally to bring sales teams together on one platform. UC expects millions of opportunities and accounts to be creates and is concerned about the performance of the application.

Which 3 recommendations should the data architect make to avoid the data skew? Choose 3 answers.

Use picklist fields rather than lookup to custom object.

Limit assigning one user 10000 records ownership.

Assign 10000 opportunities to one account.

Limit associating 10000 opportunities to one account.

Limit associating 10000 records looking up to same records.

Full Access

Question # 24

Universal Containers (CU) is in the process of implementing an enterprise data warehouse (EDW). UC needs to extract 100 million records from Salesforce for migration to the EDW.

What data extraction strategy should a data architect use for maximum performance?

Install a third-party AppExchange tool.

Call the REST API in successive queries.

Utilize PK Chunking with the Bulk API.

Use the Bulk API in parallel mode.

Full Access

Question # 25

DreamHouse Realty has a data model as shown in the image. The Project object has a private sharing model, and it has Roll-Up summary fields to calculate the number of resources assigned to the project, total hours for the project, and the number of work items associated to the project.

There will be a large amount of time entry records to be loaded regularly from an external system into Salesforce.

What should the Architect consider in this situation?

Load all data after deferring sharing calculations.

Calculate summary values instead of Roll-Up by using workflow.

Calculate summary values instead of Roll-Up by using triggers.

Load all data using external IDs to link to parent records.

Full Access

Question # 26

Universal Containers has a legacy system that captures Conferences and Venues. These Conferences can occur at any Venue. They create hundreds of thousands of Conferences per year. Historically, they have only used 20 Venues. Which two things should the data architect consider when denormalizing this data model into a single Conference object with a Venue picklist? Choose 2 answers

Limitations on master -detail relationships.

Org data storage limitations.

Bulk API limitations on picklist fields.

Standard list view in -line editing.

Full Access

Question # 27

Universal Containers (UC) has a data model as shown in the image. The Project object has a private sharing model, and it has Roll -Up summary fields to calculate the number of resources assigned to the project, total

hours for the project, and the number of work items associated to the project. What should the architect consider, knowing there will be a large amount of time entry records to be loaded regularly from an external

system into Salesforce.com?

Load all data using external IDs to link to parent records.

Use workflow to calculate summary values instead of Roll -Up.

Use triggers to calculate summary values instead of Roll -Up.

Load all data after deferring sharing calculations.

Full Access

Question # 28

Universal container (UC) would like to build a Human resources application on Salesforce to manage employee details, payroll, and hiring efforts. To adequately and store the relevant data, the application will need to leverage 45 custom objects. In addition to this, UC expects roughly 20,00 API calls into Salesfoce from an n-premises application daily.

Which license type should a data architect recommend that best fits these requirements?

Service Cloud

Lightning platform Start

Lightning Platform plus

Lightning External Apps Starts

Full Access

Question # 29

Universal Container (UC) has accumulated data over years and has never deleted data from its Salesforce org. UC is now exceeding the storage allocations in the org. UC is now looking for option to delete unused from the org.

Which three recommendations should a data architect make is order to reduce the number of records from the org?

Choose 3 answers

Use hard delete in Bulk API to permanently delete records from Salesforce.

Use hard delete in batch Apex to permanently delete records from Salesforce.

Identify records in objects that have not been modified or used In last 3 years.

Use Rest API to permanently delete records from the Salesforce org.

Archive the records in enterprise data warehouse (EDW) before deleting from Salesforce.

Full Access

Question # 30

For a production cutover, a large number of Account records will be loaded into Salesforce from a legacy system. The legacy system does not have enough information to determine the Ownership for these Accounts upon initial load. Which two recommended options assign Account ownership to mitigate potential performance problems?

Let a â€œsystem userâ€ own all the Account records without assigning any role to this user in Role Hierarchy.

Let a â€œsystem userâ€ own the Account records and assign this user to the lowest-level role in the Role Hierarchy.

Let the VP of the Sales department, who will report directly to the senior VP, own all the Account records.

Let a â€œsystem userâ€ own all the Account records and make this user part of the highest-level role in the Role Hierarchy.

Full Access

Question # 31

Developers at Universal Containers need to build a report for the business which displays Accounts opened in the past year grouped by industry. This report will also include information from contacts, opportunities, and orders. There are several million Accounts in the system. Which two options should be recommended to make this report perform well and satisfy the business need?

Use triggers to populate denormalized related fields on the Account.

Use an indexed data field with bounded data filters.

Use Formula fields to surface information I related entities on the report.

Use unbounded date ranges to filter the report.

Full Access

Question # 32

Get Cloudy Consulting needs to evaluate the completeness and consistency of contact information in Salesforce. Their sales reps often have incomplete information about their accounts and contacts. Additionally, they are not able to interpret the information in a consistent manner. Get Cloudy Consulting has identified certain ""key"" fields which are important to their sales reps.

What are two actions Get Cloudy Consulting can take to review their data for completeness and consistency? (Choose two.)

Run a report which shows the last time the key fields were updated.

Run one report per key field, grouped by that field, to understand its data variability.

Run a report that shows the percentage of blanks for the important fields.

Run a process that can fill in default values for blank fields.

Full Access

Question # 33

Universal Containers (UC) is migrating from a legacy system to Salesforce CRM, UC is concerned about the quality of data being entered by users and through external integrations.

Which two solution should a data architect recommend to mitigate data quality issues?

Leverage picklist and lookup fields where possible

Leverage Apex to validate the format of data being entered via a mobile device.

Leverage validation rules and workflows.

Leverage third-party- AppExchange tools

Full Access