Weekend Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: cramtick70

Data-Architect Salesforce Certified Data Architect (SP25) Questions and Answers

Questions 4

Universal Containers is establishing a call center that will use Salesforce. UC receives 10 million calls and creates 100 million cases every month. Cases are linked to a custom call object using lookup relationship. UC would like to run reports and dashboard to better understand different case types being created on calls to better serve customers.

What solution should a data architect recommend to meet the business requirement?

Options:

A.

Archive records to a data warehouse and run analytics on the data warehouse.

B.

Leverage big objects to archive records and Einstein Analytics to run reports.

C.

Leverage custom objects to store aggregate data and run analytics.

D.

Leverage out-of-the-box reports and dashboard on case and interactive voice response (IVR) custom object.

Buy Now
Questions 5

US is implementing salesforce and will be using salesforce to track customer complaints, provide white papers on products and provide subscription (Fee) – based support.

Which license type will US users need to fulfil US’s requirements?

Options:

A.

Lightning platform starter license.

B.

Service cloud license.

C.

Salesforce license.

D.

Sales cloud license

Buy Now
Questions 6

Get Cloudy Consulting uses an invoicing system that has specific requirements. One requirement is that attachments associated with the Invoice_c custom object be classified by Types (i.e., ""Purchase Order"", ""Receipt"", etc.) so that reporting can be performed on invoices showing the number of attachments grouped by Type.

What should an Architect do to categorize the attachments to fulfill these requirements?

Options:

A.

Add additional options to the standard ContentType picklist field for the Attachment object.

B.

Add a ContentType picklist field to the Attachment layout and create additional picklist options.

C.

Create a custom picklist field for the Type on the standard Attachment object with the values.

D.

Create a custom object related to the Invoice object with a picklist field for the Type.

Buy Now
Questions 7

Universal Containers (UC) wants to store product data in Salesforce, but the standard Product object does not support the more complex hierarchical structure which is currently being used in the product master system. How can UC modify the standard Product object model to support a hierarchical data structure in order to synchronize product data from the source system to Salesforce?

Options:

A.

Create a custom lookup filed on the standard Product to reference the child record in the hierarchy.

B.

Create a custom lookup field on the standard Product to reference the parent record in the hierarchy.

C.

Create a custom master-detail field on the standard Product to reference the child record in the hierarchy.

D.

Create an Apex trigger to synchronize the Product Family standard picklist field on the Product object.

Buy Now
Questions 8

Universal Containers wishes to maintain Lead data from Leads even after they are deleted and cleared from the Recycle Bin. What approach should be implemented to achieve this solution?

Options:

A.

Use a Lead standard report and filter on the IsDeleted standard field.

B.

Use a Converted Lead report to display data on Leads that have been deleted.

C.

Query Salesforce with the queryAll API method or using the ALL ROWS SOQL keywords.

D.

Send data to a Data Warehouse and mark Leads as deleted in that system.

Buy Now
Questions 9

Universal Containers wants to implement a data -quality process to monitor the data that users are manually entering into the system through the Salesforce UI. Which approach should the architect recommend?

Options:

A.

Allow users to import their data using the Salesforce Import tools.

B.

Utilize a 3rd -party solution from the AppExchange for data uploads.

C.

Utilize an app from the AppExchange to create data -quality dashboards.

D.

Use Apex to validate the format of phone numbers and postal codes.

Buy Now
Questions 10

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

Options:

A.

Limitations on master -detail relationships.

B.

Org data storage limitations.

C.

Bulk API limitations on picklist fields.

D.

Standard list view in -line editing.

Buy Now
Questions 11

Universal Containers (UC) has implemented Salesforce, UC is running out of storage and needs to have an archiving solution, UC would like to maintain two years of data in Saleforce and archive older data out of Salesforce.

Which solution should a data architect recommend as an archiving solution?

Options:

A.

Use a third-party backup solution to backup all data off platform.

B.

Build a batch join move all records off platform, and delete all records from Salesforce.

C.

Build a batch join to move two-year-old records off platform, and delete records from Salesforce.

D.

Build a batch job to move all restore off platform, and delete old records from Salesforce.

Buy Now
Questions 12

UC developers have created a new lightning component that uses an Apex controller using a SOQL query to populate a custom list view. Users are complaining that the component often fails to load and returns a time-out error.

What tool should a data architect use to identify why the query is taking too long?

Options:

A.

Use Splunk to query the system logs looking for transaction time and CPU usage.

B.

Enable and use the query plan tool in the developer console.

C.

Use salesforce’s query optimizer to analyze the query in the developer console.

D.

Open a ticket with salesforce support to retrieve transaction logs to e analyzed for processing time.

Buy Now
Questions 13

Salesforce is being deployed in Ursa Major Solar's disparate, multi-system ERP environment. Ursa major Solar wants to maintain data synchronization between systems.

Which two techniques should be used to achieve this goal? (Choose two.)

Options:

A.

Integrate Salesforce with the ERP environment.

B.

Utilize workbench to update files within systems.

C.

Utilize an MDM strategy to outline a single source of truth.

D.

Build synchronization reports and dashboards.

Buy Now
Questions 14

Universal Containers (UC) owns a complex Salesforce org with many Apex classes, triggers, and automated processes that will modify records if available. UC has identified that, in its current development state, UC runs change of encountering race condition on the same record.

What should a data architect recommend to guarantee that records are not being updated at the same time?

Options:

A.

Embed the keywords FOR UPDATE after SOQL statements.

B.

Disable classes or triggers that have the potential to obtain the same record.

C.

Migrate programmatic logic to processes and flows.

D.

Refactor or optimize classes and trigger for maximum CPU performance.

Buy Now
Questions 15

Which three characteristics of a skinny table help improve report and query performance?

Options:

A.

Skinny tables can contain frequently used fields and thereby help avoid joins.

B.

Skinny tables can be used to create custom indexes on multi-select picklist fields.

C.

Skinny tables provide a view across multiple objects for easy access to combined data.

D.

Skinny tables are kept in sync with changes to data in the source tables.

E.

Skinny tables do not include records that are available in the recycle bin.

Buy Now
Questions 16

Universal Containers (UC) is implementing a new customer categorization process where customers should be assigned to a Gold, Silver, or Bronze category if they've purchased UC's new support service. Customers are expected to be evenly distributed across all three categories. Currently, UC has around 500,000 customers, and is expecting 1% of existing non-categorized customers to purchase UC's new support service every month over the next five years. What is the recommended solution to ensure long-term performance, bearing in mind the above requirements?

Options:

A.

Implement a new global picklist custom field with Gold, Silver, and Bronze values and enable it in Account.

B.

Implement a new picklist custom field in the Account object with Gold, Silver, and Bronze values.

C.

Implement a new Categories custom object and a master-detail relationship from Account to Category.

D.

Implement a new Categories custom object and create a lookup field from Account to Category.

Buy Now
Questions 17

Universal Containers (UC) is implementing a formal, cross -business -unit data governance program As part of the program, UC will implement a team to make decisions on enterprise -wide data governance. Which two roles are appropriate as members of this team? Choose 2 answers

Options:

A.

Analytics/BI Owners

B.

Data Domain Stewards

C.

Salesforce Administrators

D.

Operational Data Users

Buy Now
Questions 18

Universal Containers (UC) loads bulk leads and campaigns from third-party lead aggregators on a weekly and monthly basis. The expected lead record volume is 500K records per week, and the expected campaign records volume is 10K campaigns per week. After the upload, Lead records are shared with various sales agents via sharing rules and added as Campaign members via Apex triggers on Lead creation. UC agents work on leads for 6 months, but want to keep the records in the system for at least 1 year for reference. Compliance requires them to be stored for a minimum of 3 years. After that, data can be deleted. What statement is true with respect to a data archiving strategy for UC?

Options:

A.

UC can store long-term lead records in custom storage objects to avoid counting against storage limits.

B.

UC can leverage the Salesforce Data Backup and Recovery feature for data archival needs.

C.

UC can leverage recycle bin capability, which guarantees record storage for 15 days after deletion.

D.

UC can leverage a “tier”-based approach to classify the record storage need.

Buy Now
Questions 19

Universal Containers (UC) is migrating data from legacy system to Salesforce. During data analysis it was discovered that data types of fields being migrated do not match with Salesforce data types.

Which solution should a data architect use to ensure successful data migrations?

Options:

A.

Migrate legacy data to a staging database for mapping then leverage an ETL tool to transform the data and load into Salesforce.

B.

Export legacy data into the staging database and leverage stored procedures to transform data types before loading into Salesforce.

C.

Migrate the legacy data leveraging an ETL tool to transform data types and load data into Salesforce.

D.

Export legacy data into CSV files and leverage data loader to load data into Salesforce.

Buy Now
Questions 20

Northern Trail Outfitters (NTO) has recently implemented Salesforce to track opportunities across all their regions. NTO sales teams across all regions have historically managed their sales process in Microsoft Excel. NTO sales teams are complaining that their data from the Excel files were not migrated as part of the implementation and NTO is now facing low Salesforce adoption.

What should a data architect recommend to increase Salesforce adoption?

Options:

A.

Use the Excel connector to Salesforce to sync data from individual Excel files.

B.

Define a standard mapping and train sales users to import opportunity data.

C.

Load data in external database and provide access to database to sales users.

D.

Create a chatter group and upload all Excel files to the group.

Buy Now
Questions 21

Universal Containers (UC) has lead assignment rules to assign leads to owners. Leads not routed by assignment rules are assigned to a dummy user. Sales rep are complaining of high load times and issues with accessing leads assigned to the dummy user.

What should a data architect recommend to solve these performance issues?

Options:

A.

Assign dummy user last role in role hierarchy

B.

Create multiple dummy user and assign leads to them

C.

Assign dummy user to highest role in role hierarchy

D.

Periodically delete leads to reduce number of leads

Buy Now
Questions 22

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?

Options:

A.

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

B.

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

C.

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

D.

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

Buy Now
Questions 23

UC has migrated its Back-office data into an on-premise database with REST API access. UC recently implemented Sales cloud for its sales organization. But users are complaining about a lack of order data inside SF.

UC is concerned about SF storage limits but would still like Sales cloud to have access to the data.

Which design patterns should a data architect select to satisfy the requirement?

Options:

A.

Migrate and persist the data in SF to take advantage of native functionality.

B.

Use SF Connect to virtualize the data in SF and avoid storage limits.

C.

Develop a bidirectional integration between the on-premise system and Salesforce.

D.

Build a UI for the on-premise system and iframe it in Salesforce

Buy Now
Questions 24

UC is implementing sales cloud for patient management and would like to encrypt sensitive patient records being stored in files.

Which solution should a data architect recommend to solve this requirement?

Options:

A.

Implement shield platform encryption to encrypt files.

B.

Use classic encryption to encrypt files.

C.

Implement 3rd party App Exchange app to encrypt files.

D.

Store files outside of salesforce and access them to real time.

Buy Now
Questions 25

Universal Containers (UC) is building a Service Cloud call center application and has a multi­system support solution. UC would like or ensure that all systems have access to the same customer information.

What solution should a data architect recommend?

Options:

A.

Make Salesforce the system of record for all data.

B.

Implement a master data management (MDM) strategy for customer data.

C.

Load customer data in all systems.

D.

Let each system be an owner of data it generates.

Buy Now
Questions 26

Get Cloudy Consulting is migrating their legacy system's users and data to Salesforce. They will be creating 15,000 users, 1.5 million Account records, and 15 million Invoice records. The visibility of these records is controlled by a 50 owner and criteria-based sharing rules.

Get Cloudy Consulting needs to minimize data loading time during this migration to a new organization.

Which two approaches will accomplish this goal? (Choose two.)

Options:

A.

Create the users, upload all data, and then deploy the sharing rules.

B.

Contact Salesforce to activate indexing before uploading the data.

C.

First, load all account records, and then load all user records.

D.

Defer sharing calculations until the data has finished uploading.

Buy Now
Questions 27

UC has millions of Cases and are running out of storage. Some user groups need to have access to historical cases for up to 7 years.

Which 2 solutions should a data architect recommend in order to minimize performance and storage issues?

Choose 2 answers:

Options:

A.

Export data out of salesforce and store in Flat files on external system.

B.

Create a custom object to store case history and run reports on it.

C.

Leverage on premise data archival and build integration to view archived data.

D.

Leverage big object to archive case data and lightning components to show archived data.

Buy Now
Questions 28

Universal Containers (UC) is planning to move away from legacy CRM to Salesforce. As part of one-time data migration, UC will need to keep the original date when a contact was created in the legacy system. How should an Architect design the data migration solution to meet this requirement?

Options:

A.

After the data is migrated, perform an update on all records to set the original date in a standard Created Date field.

B.

Create a new field on the Contact object to capture the Created Date. Hide the standard Created Date field using Field -Level Security.

C.

Enable "Set Audit Fields" and assign the permission to the user loading the data for the duration of the migration.

D.

Write an Apex trigger on the Contact object, before insert event to set the original value in a standard Created Date field.

Buy Now
Questions 29

Universal Containers (UC) wants to ensure their data on 100,000 Accounts pertaining mostly to US-based companies is enriched and cleansed on an ongoing basis. UC is looking for a solution that allows easy monitoring of key data quality metrics. What should be the recommended solution to meet this requirement?

Options:

A.

Use a declarative approach by installing and configuring Data.com Clean to monitor Account data quality.

B.

Implement Batch Apex that calls out a third-party data quality API in order to monitor Account data quality.

C.

Use declarative approach by installing and configuring Data.com Prospector to monitor Account data quality.

D.

Implement an Apex Trigger on Account that queries a third-party data quality API to monitor Account data quality.

Buy Now
Questions 30

Universal Containers (UC) has implemented Sales Cloud and it has been noticed that Sales reps are not entering enough data to run insightful reports and dashboards. UC executives would like to monitor and measure data quality metrics. What solution addresses this requirement?

Options:

A.

Use third-party AppExchange tools to monitor and measure data quality.

B.

Generate reports to view the quality of sample data.

C.

Use custom objects and fields to calculate data quality.

D.

Export the data to an enterprise data warehouse and use BI tools for data quality.

Buy Now
Questions 31

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 solutions should a data architect recommend to mitigate data quality issues?

Options:

A.

Leverage picklist and lookup fields where possible

B.

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

C.

Leverage validation rules and workflows.

D.

Leverage third-party- AppExchange tools

Buy Now
Questions 32

Universal Containers (UC) is concerned about the accuracy of their Customer information in Salesforce. They have recently created an enterprise-wide trusted source MDM for Customer data which they have certified to be accurate. UC has over 20 million unique customer records in the trusted source and Salesforce. What should an Architect recommend to ensure the data in Salesforce is identical to the MDM?

Options:

A.

Extract the Salesforce data into Excel and manually compare this against the trusted source.

B.

Load the Trusted Source data into Salesforce and run an Apex Batch job to find difference.

C.

Use an AppExchange package for Data Quality to match Salesforce data against the Trusted source.

D.

Leave the data in Salesforce alone and assume that it will auto-correct itself over time.

Buy Now
Questions 33

Universal Containers has 30 million case records. The Case object has 80 fields. Agents are reporting reports in the Salesforce org.

Which solution should a data architect recommend to improve reporting performance?

Options:

A.

Create a custom object to store aggregate data and run reports.

B.

Contact Salesforce support to enable skinny table for cases.

C.

Move data off of the platform and run reporting outside Salesforce, and give access to reports.

D.

Build reports using custom Lightning components.

Buy Now
Questions 34

UC has large amount of orders coming in from its online portal. Historically all order are assigned to a generic user.

Which 2 measures should data architect recommend to avoid any performance issues while working with large number of order records? Choose 2 answers:

Options:

A.

Clear the role field in the generic user record.

B.

Salesforce handles the assignment of orders automatically and there is no performance impact.

C.

Create a role at top of role hierarchy and assign the role to the generic user.

D.

Create a pool of generic users and distribute the assignment of memory to the pool of users.

Buy Now
Questions 35

Universal Containers (UC) has built a custom application on Salesforce to help track shipments around the world. A majority of the shipping records are stored on premise in an external data source. UC needs shipment details to be exposed to the custom application, and the data needs to be accessible in real time. The external data source is not OData enabled, and UC does not own a middleware tool.

Which Salesforce Connect procedure should a data architect use to ensure UC's requirements are met?

Options:

A.

Write an Apex class that makes a REST callout to the external API.

B.

Develop a process that calls an inviable web service method.

C.

Migrate the data to Heroku and register Postgres as a data source.

D.

Write a custom adapter with the Apex Connector Framework.

Buy Now
Questions 36

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?

Options:

A.

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

B.

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

C.

Leverage Apex class to decrypt data before exporting it.

D.

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

Buy Now
Questions 37

A health care provider wishes to use salesforce to track patient care. The following actions are in Salesforce

1. Payment Providers: Orgas who pay for the care 2 patients.

2. Doctors: They provide care plan for patients and need to support multiple patients, they are provided access to patient information.

3. Patients: They are individuals who need care.

A data architect needs to map the actor to Sf objects. What should be the optimal selection by the data architect?

Options:

A.

Patients as Contacts, Payment providers as Accounts, & Doctors as Accounts

B.

Patients as Person Accounts, Payment providers as Accounts, & Doctors as Contacts

C.

Patients as Person Accounts, Payment providers as Accounts, & Doctors as Person Account

D.

Patients as Accounts, Payment providers as Accounts, & Doctors as Person Accounts

Buy Now
Questions 38

Universal Containers (UC) is transitioning from Classic to Lightning Experience.

What does UC need to do to ensure users have access to its notices and attachments in Lightning Experience?

Options:

A.

Add Notes and Attachments Related List to page Layout in Lighting Experience.

B.

Manually upload Notes in Lighting Experience.

C.

Migrate Notes and Attachment to Enhanced Notes and Files a migration tool

D.

Manually upload Attachments in Lighting Experience.

Buy Now
Questions 39

UC is having issues using Informatica Cloud Louder to export +10MOrder records. Each Order record has 10 Order Line Items. What two steps can you take to help correct this? Choose two answers.

Options:

A.

Export in multiple batches

B.

Export Bulk API in parallel mode

C.

Use PK Chunking

D.

Limit Batch to 10K records

Buy Now
Questions 40

UC recently migrated 1 Billion customer related records from a legacy data store to Heroku Postgres. A subset of the data need 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?

Options:

A.

Virtualize the remaining set of data with salesforce connect and external objects.

B.

Use Heroku connect to bi-directional, sync all data between systems.

C.

As needed, make call outs into Heroku postgres and persist the data in salesforce.

D.

Migrate the data to big objects and leverage async SOQL with custom objects.

Buy Now
Questions 41

UC has a legacy client server app that as a relational data base that needs to be migrated to salesforce.

What are the 3 key actions that should be done when data modeling in salesforce?

Choose 3 answers:

Options:

A.

Identify data elements to be persisted in salesforce.

B.

Map legacy data to salesforce objects.

C.

Map legacy data to salesforce custom objects.

D.

Work with legacy application owner to analysis legacy data model.

E.

Implement legacy data model within salesforce using custom fields.

Buy Now
Questions 42

Northern trail Outfitters (NTO) runs its entire out of an enterprise data warehouse (EDW), NTD’s sales team starting to use Salesforce after a recent implementation, but currently lacks data required to advanced and opportunity to the next stage.

NTO’s management has research Salesforce Connect and would like to use It to virtualize and report on data from the EDW within Salesforce. NTO will be running thousands of reports per day across 10 to 15 external objects.

What should a data architect consider before implementing Salesforce Connect for reporting?

Options:

A.

Maximum number for records returned

B.

OData callout limits per day

C.

Maximum page size for server-driven paging

D.

Maximum external objects per org

Buy Now
Questions 43

Northern Trail Outfitters needs to implement an archive solution for Salesforce data. This archive solution needs to help NTO do the following:

1. Remove outdated Information not required on a day-to-day basis.

2. Improve Salesforce performance.

Which solution should be used to meet these requirements?

Options:

A.

Identify a location to store archived data and use scheduled batch jobs to migrate and purge the aged data on a nightly basis,

B.

Identify a location to store archived data, and move data to the location using a time-based workflow.

C.

Use a formula field that shows true when a record reaches a defined age and use that field to run a report and export a report into SharePoint.

D.

Create a full copy sandbox, and use it as a source for retaining archived data.

Buy Now
Questions 44

Universals Containers’ system administrators have been complaining that they are not able to make changes to its users’ record, including moving them to new territories without getting “unable to lock row” errors. This is causing the system admins to spend hours updating user records every day.

What should the data architect do to prevent the error?

Options:

A.

Reduce number of users updated concurrently.

B.

Enable granular locking.

C.

Analyze Splunk query to spot offending records.

D.

Increase CPU for the Salesforce org.

Buy Now
Questions 45

Universal Container require all customers to provide either a phone number of an email address when registering for an account.

What should the data architect use to ensure this requirement is met?

Options:

A.

validation Rule

B.

required Fields

C.

Apex Class

D.

Process Builder

Buy Now
Questions 46

A Customer is migrating 10 million order and 30 million order lines into Salesforce using Bulk API. The Engineer is experiencing time-out errors or long delays querying parents order IDs in Salesforce before importing related order line items. What is the recommended solution?

Options:

A.

Query only indexed ID field values on the imported order to import related order lines.

B.

Leverage an External ID from source system orders to import related order lines.

C.

Leverage Batch Apex to update order ID on related order lines after import.

D.

Leverage a sequence of numbers on the imported orders to import related order lines.

Buy Now
Questions 47

Universal Container (UC) has around 200,000 Customers (stored in Account object). They get 1 or 2 Orders every month from each Customer. Orders are stored in a custom object called "Order c"; this has about 50 fields. UC is expecting a growth of 10% year -over -year. What are two considerations an architect should consider to improve the performance of SOQL queries that retrieve data from the Order _c object? Choose 2 answers

Options:

A.

Use SOQL queries without WHERE conditions.

B.

Work with Salesforce Support to enable Skinny Tables.

C.

Reduce the number of triggers on Order _c object.

D.

Make the queries more selective using indexed fields.

Buy Now
Questions 48

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.

Options:

A.

Leverage Heroku Connect and Heroku Postgres to bidirectionally sync Opportunities.

B.

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

C.

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

D.

Leverage middleware tools to bidirectionally send Opportunity data across orgs.

E.

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

Buy Now
Questions 49

Universal Containers has a custom object with millions of rows of data.

When executing SOQL queries, which three options prevent a query from being selective? (Choose three.)

Options:

A.

Using leading % wildcards.

B.

Using trailing % wildcards.

C.

Performing large loads and deletions.

D.

Using NOT and != operators.

E.

Using a custom index on a deterministic formula field.

Buy Now
Questions 50

NTO has outgrown its current salesforce org and will be migrating to new org shortly. As part of this process NTO will be migrating all of its metadata and data. NTO’s data model in the source org has a complex relationship hierarchy with several master detail and lookup relationships across objects, which should be maintained in target org.

What 3 things should a data architect do to maintain the relationship hierarchy during migration?

Choose 3 answers:

Options:

A.

Use data loader to export the data from source org and then import or Upsert into the target org in sequential order.

B.

Create a external id field for each object in the target org and map source record ID’s to this field.

C.

Redefine the master detail relationship fields to lookup relationship fields in the target org.

D.

Replace source record ID’s with new record ID’s from the target org in the import file.

E.

Keep the relationship fields populated with the source record ID’s in the import file.

Buy Now
Questions 51

Universal Containers (UC) is implementing Salesforce Sales Cloud and Service Cloud. As part of their implementation, they are planning to create a new custom object (Shipments), which will have a lookup relationship to Opportunities. When creating shipment records, Salesforce users need to manually input a customer reference, which is provided by customers, and will be stored in the Customer_Reference__c text custom field. Support agents will likely use this customer reference to search for Shipment records when resolving shipping issues. UC is expecting to have around 5 million shipment records created per year. What is the recommended solution to ensure that support agents using global search and reports can quickly find shipment records?

Options:

A.

Implement an archiving process for shipment records created after five years.

B.

Implement an archiving process for shipment records created after three years.

C.

Set Customer-Reference_c as an External ID (non-unique).

D.

Set Customer-Reference_c as an External ID (unique).

Buy Now
Questions 52

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

Options:

A.

Custom metadata records are not copied from production to sandbox.

B.

Custom metadata types are available for reporting.

C.

Custom metadata records are deployable using packages.

D.

Custom metadata records are editable in Apex.

Buy Now
Questions 53

Universal Containers (UC) has implemented a master data management strategy, which uses a central system of truth, to ensure the entire company has the same customer information in all systems. UC customer data changes need to be accurate at all times in all of the systems. Salesforce is the identified system of record for this information.

What is the correct solution for ensuring all systems using customer data are kept up to date?

Options:

A.

Send customer data nightly to the system of truth in a scheduled batch job.

B.

Send customer record changes from Salesforce to each system in a nightly batch job.

C.

Send customer record changes from Salesforce to the system of truth in real time.

D.

Have each system pull the record changes from Salesforce using change data capture.

Buy Now
Questions 54

The data architect for UC has written a SOQL query that will return all records from the Task object that do not have a value in the WhatID field:

Select id, description, Subject from Task where WhatId!= NULL

When the data architect usages the query to select values for a process a time out error occurs.

What does the data architect need to change to make this query more performant?

Options:

A.

Remove description from the requested field set.

B.

Change query to SOSL.

C.

Add limit 100 to the query.

D.

Change the where clause to filter by a deterministic defined value.

Buy Now
Questions 55

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?

Options:

A.

Number of queries running at a time.

B.

Number of joins used in report query.

C.

Number of records returned by report query.

D.

Number of characters in report query.

Buy Now
Questions 56

As part of addressing general data protection regulation (GDPR) requirements, UC plans to implement a data classification policy for all its internal systems that stores customer information including salesforce.

What should a data architect recommend so that UC can easily classify consumer information maintained in salesforce under both standard and custom objects?

Options:

A.

Use App Exchange products to classify fields based on policy.

B.

Use data classification metadata fields available in field definition.

C.

Create a custom picklist field to capture classification of information on customer.

D.

Build reports for customer information and validate.

Buy Now
Questions 57

Universal Containers (UC) is implementing Salesforce and will be using Salesforce to track customer complaints, provide white papers on products, and provide subscription-based support.

Which license type will UC users need to fulfill UC's requirements?

Options:

A.

Sales Cloud License

B.

Lightning Platform Starter License

C.

Service Cloud License

D.

Salesforce License

Buy Now
Questions 58

Northern Trail Outfitters (NTO) has an external product master system that syncs product and pricing information with Salesforce. Users have been complaining that they are seeing discrepancies in product and pricing information displayed on the NTO website and Salesforce.

As a data architect, which action is recommended to avoid data sync issues?

Options:

A.

Build a custom integration for two-way sync of product and pricing information between product master to Salesforce.

B.

Build a custom integration for one-way sync of product and pricing information from product master to Salesforce.

C.

Implement a manual process to update the products from an extract from the products master on a weekly basis.

D.

Use the Customer 360 data manager to sync product and pricing information from product master database to Salesforce.

Buy Now
Questions 59

Northern Trail Outfitters has these simple requirements for a data export process:

File format should be in CSV.

Process should be scheduled and run once per week.

The expert should be configurable through the Salesforce UI.

Which tool should a data architect leverage to accomplish these requirements?

Options:

A.

Bulk API

B.

Data export wizard

C.

Third-party ETL tool

D.

Data loader

Buy Now
Questions 60

A company has 12 million records, and a nightly integration queries these records.

Which two areas should a Data Architect investigate during troubleshooting if queries are timing out? (Choose two.)

Options:

A.

Make sure the query doesn't contain NULL in any filter criteria.

B.

Create a formula field instead of having multiple filter criteria.

C.

Create custom indexes on the fields used in the filter criteria.

D.

Modify the integration users' profile to have View All Data.

Buy Now
Questions 61

What makes Skinny tables fast? Choose three answers.

Options:

A.

They do not include soft-deleted records

B.

They avoid resource intensive joins

C.

Their tables are kept in sync with their source tables when the source tables are modified

D.

They can contain fields from other objects

E.

They support up to a max of 100 of columns

Buy Now
Questions 62

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?

Options:

A.

Load all data after deferring sharing calculations.

B.

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

C.

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

D.

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

Buy Now
Questions 63

Northern Trail Outfitters (NTO) plans to maintain contact preferences for customers and employees. NTO has implemented the following:

1. Customers are Person Accounts for their retail business.

2. Customers are represented as Contacts for their commercial business.

3. Employees are maintained as Users.

4. Prospects are maintained as Leads.

NTO needs to implement a standard communication preference management model for Person Accounts, Contacts, Users, and Leads.

Which option should the data architect recommend NTO to satisfy this requirement?

Options:

A.

Create custom fields for contact preferences in Lead, Person Account, and Users objects.

B.

Create case for contact preferences, and use this to validate the preferences for Lead, Person Accounts, and Users.

C.

Create a custom object to maintain preferences and build relationships to Lead, Person Account, and Users.

D.

Use Individual objects to maintain the preferences with relationships to Lead, Person Account, and Users.

Buy Now
Questions 64

Universal Containers has a large number of Opportunity fields (100) that they want to track field history on. Which two actions should an architect perform in order to meet this requirement? Choose 2 answers

Options:

A.

Create a custom object to store a copy of the record when changed.

B.

Create a custom object to store the previous and new field values.

C.

Use Analytic Snapshots to store a copy of the record when changed.

D.

Select the 100 fields in the Opportunity Set History Tracking page.

Buy Now
Questions 65

A large insurance provider is looking to implement Salesforce. The following exist.

1. Multiple channel for lead acquisition

2. Duplication leads across channels

3. Poor customer experience and higher costs

On analysis, it found that there are duplicate leads that are resulting to mitigate the issues?

Options:

A.

Build process is manually search and merge duplicates.

B.

Standard lead information across all channels.

C.

Build a custom solution to identify and merge duplicate leads.

D.

Implement third-party solution to clean and event lead data.

E.

Implement de-duplication strategy to prevent duplicate leads

Buy Now
Questions 66

To avoid creating duplicate Contacts, a customer frequently uses Data Loader to upsert Contact records into Salesforce. What common error should the data architect be aware of when using upsert?

Options:

A.

Errors with duplicate external Id values within the same CSV file.

B.

Errors with records being updated and inserted in the same CSV file.

C.

Errors when a duplicate Contact name is found cause upsert to fail.

D.

Errors with using the wrong external Id will cause the load to fail.

Buy Now
Questions 67

DreamHouse Realty has a Salesforce deployment that manages Sales, Support, and Marketing efforts in a multi-system ERP environment. The company recently reached the limits of native reports and dashboards and needs options for providing more analytical insights.

What are two approaches an Architect should recommend? (Choose two.)

Options:

A.

Weekly Snapshots

B.

Einstein Analytics

C.

Setup Audit Trails

D.

AppExchange Apps

Buy Now
Questions 68

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

Options:

A.

Implement a third -party validation process with translate functionality.

B.

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

C.

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

D.

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

Buy Now
Questions 69

Universal containers is implementing Salesforce lead management.  UC Procure lead data from multiple sources and would like to make sure lead data as company profile and location information. Which solution should a data architect recommend to make sure lead data has both profile and location information? Option

Options:

A.

Ask sales people to search for populating company profile and location data

B.

Run reports to identify records which does not have company profile and location data

C.

Leverage external data providers populate company profile and location data

D.

Export data out of Salesforce and send to another team to populate company profile and location data

Buy Now
Questions 70

NTO uses salesforce to manage relationships and track sales opportunities. It has 10 million customers and 100 million opportunities. The CEO has been complaining 10 minutes to run and sometimes failed to load, throwing a time out error.

Which 3 options should help improve the dashboard performance?

Choose 3 answers:

Options:

A.

Use selective queries to reduce the amount of data being returned.

B.

De-normalize the data by reducing the number of joins.

C.

Remove widgets from the dashboard to reduce the number of graphics loaded.

D.

Run the dashboard for CEO and send it via email.

E.

Reduce the amount of data queried by archiving unused opportunity records.

Buy Now
Questions 71

Universal Containers (UC) is going thought major reorganization of their sales team. This would require changes to a large a number of group members and sharing rules. UCs administrator is concerned about long processing time and failure during the process.

What should a Data architect implement to make changes efficiently?

Options:

A.

Log a case with salesforce to make sharing rule changes.

B.

Enable Defer Sharing Calculation prior to making sharing rule changes.

C.

Delete old sharing rules and build new sharing rules

D.

Log out all users and make changes to sharing rules.

Buy Now
Questions 72

Universal Containers (UC) owns several Salesforce orgs across a variety of business units. UC management has declared that it needs the ability to report on Accounts and Opportunities from each org in one place. Once the data is brought together into a global view, management would like to use advanced Al-driven analytics on the dataset.

Which tool should a data architect recommend to accomplish this reporting requirement?

Options:

A.

Run standard reports and dashboards.

B.

Install a third-party AppExchange tool for multi-org reporting.

C.

Use Einstein Analytics for multi-org.

D.

Write a Python script to aggregate and visualize the data.

Buy Now
Questions 73

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?

Options:

A.

Use DX to create big object.

B.

Use Metadata API to create big object.

C.

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

D.

Go to Object Manager in setup and select new to create big object.

Buy Now
Questions 74

NTO has decided to franchise its brand. Upon implementation, 1000 franchisees will be able to access BTO’s product information and track large customer sales and opportunities through a portal. The Franchisees will also be able to run monthly and quarterly sales reports and projections as well as view the reports in dashboards.

Which licenses does NTO need to provide these features to the Franchisees?

Options:

A.

Salesforce Sales Cloud license

B.

Lightning Platform license

C.

Customer Community license

D.

Partner Community license

Buy Now
Questions 75

Cloud Kicks has the following requirements:

• Their Shipment custom object must always relate to a Product, a Sender, and a Receiver (all separate custom objects).

• If a Shipment is currently associated with a Product, Sender, or Receiver, deletion of those records should not be allowed.

• Each custom object must have separate sharing models.

What should an Architect do to fulfill these requirements?

Options:

A.

Associate the Shipment to each parent record by using a VLOOKUP formula field.

B.

Create a required Lookup relationship to each of the three parent records.

C.

Create a Master-Detail relationship to each of the three parent records.

D.

Create two Master-Detail and one Lookup relationship to the parent records.

Buy Now
Questions 76

DreamHouse Realty has a Salesforce org that is used to manage Contacts.

What are two things an Architect should consider using to maintain data quality in this situation? (Choose two.)

Options:

A.

Use the private sharing model.

B.

Use Salesforce duplicate management.

C.

Use validation rules on new record create and edit.

D.

Use workflow to delete duplicate records.

Buy Now
Questions 77

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?

Options:

A.

Use Apex Crypto Class encrypt customer and standard fields.

B.

Implement classic encryption to encrypt custom and standard fields.

C.

Implement shield platform encryption to encrypt and standard fields

D.

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

Buy Now
Exam Code: Data-Architect
Exam Name: Salesforce Certified Data Architect (SP25)
Last Update: Jun 14, 2025
Questions: 257
Data-Architect pdf

Data-Architect PDF

$25.5  $84.99
Data-Architect Engine

Data-Architect Testing Engine

$30  $99.99
Data-Architect PDF + Engine

Data-Architect PDF + Testing Engine

$40.5  $134.99