Labour Day Special - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: top65certs

Salesforce Data-Architect Dumps

Salesforce Certified Data Architect (SP23) Questions and Answers

Question 1

A customer is facing locking issued when importing large data volumes of order records that are children in a master-detail relationship with the Account object. What is the recommended way to avoid locking issues during import?

Options:

A.

Import Account records first followed by order records after sorting order by OrderID.

B.

Import Account records first followed by order records after sorting orders by AccountID.

C.

Change the relationship to Lookup and update the relationship to master-detail after import.

D.

Import Order records and Account records separately and populate AccountID in orders using batch Apex.

Question 2

In their legacy system. Universal Containers has a monthly accounts receivable report that compiles data from Accounts, Contacts, Opportunities, Orders. and Order Line Items. What difficulty will an architect run into when implementing this in Salesforce?

Options:

A.

Salesforce allows up to four objects in a single report type.

B.

Salesforce does not support Orders or Order Line Items.

C.

A report cannot contain data from Accounts and Contacts.

D.

Custom report types cannot contain Opportunity data.

Question 3

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

Options:

A.

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

B.

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

C.

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

D.

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

E.

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

Question 4

An architect is planning on having different batches to load one million Opportunities into Salesforce using the Bulk API in parallel mode. What should be considered when loading the Opportunity records?

Options:

A.

Create indexes on Opportunity object text fields.

B.

Group batches by the AccountId field.

C.

Sort batches by Name field values.

D.

Order batches by Auto -number field.

Question 5

Universal Containers (UC) uses Salesforce for tracking opportunities (Opportunity). UC uses an internal ERP system for tracking deliveries and invoicing. The ERP system supports SOAP API and OData for bi-directional integration between Salesforce and the ERP system. UC has about one million opportunities. For each opportunity, UC sends 12 invoices, one per month. UC sales reps have requirements to view current invoice status and invoice amount from the opportunity page. When creating an object to model invoices, what should the architect recommend, considering performance and data storage space?

Options:

A.

Use Streaming API to get the current status from the ERP and display on the Opportunity page.

B.

Create an external object Invoice _x with a Lookup relationship with Opportunity.

C.

Create a custom object Invoice _c with a master -detail relationship with Opportunity.

D.

Create a custom object Invoice _c with a Lookup relationship with Opportunity.

Question 6

Universal Containers (UC) is using Salesforce Sales & Service Cloud for B2C sales and customer service but they are experiencing a lot of duplicate customers in the system. Which are two recommended approaches for UC to avoid duplicate data and increase the level of data quality?

Options:

A.

Use Duplicate Management.

B.

Use an Enterprise Service Bus.

C.

Use Data.com Clean

D.

Use a data wharehouse.

Question 7

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.

Question 8

Universal Containers (UC) has an open sharing model for its Salesforce users to allow all its Salesforce internal users to edit all contacts, regardless of who owns the contact. However, UC management wants to allow only the owner of a contact record to delete that contact. If a user does not own the contact, then the user should not be allowed to delete the record. How should the architect approach the project so that the requirements are met?

Options:

A.

Create a "before delete" trigger to check if the current user is not the owner.

B.

Set the Sharing settings as Public Read Only for the Contact object.

C.

Set the profile of the users to remove delete permission from the Contact object.

D.

Create a validation rule on the Contact object to check if the current user is not the owner.

Question 9

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).

Question 10

Cloud Kicks currently has a Public Read/Write sharing model for the company's Contacts. Cloud Kicks management team requests that only the owner of a contact record be allowed to delete that contact.

What should an Architect do to meet these requirements?

Options:

A.

Set the profile of the users to remove delete permission from the Contact object.

B.

Check if the current user is NOT the owner by creating a "before delete" trigger.

C.

Set the Sharing settings as Public Read Only for the Contact object.

D.

Check if the current user is NOT the owner by creating a validation rule on the Contact object.

Question 11

North Trail Outfitters (NTD) is in the process of evaluating big objects to store large amounts of asset data from an external system. NTO will need to report on this asset data weekly.

Which two native tools should a data architect recommend to achieve this reporting requirement?

Options:

A.

Standard reports and dashboards

B.

Async SOQL with a custom object

C.

Standard SOQL queries

D.

Einstein Analytics

Question 12

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.

Question 13

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.

Question 14

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?

Options:

A.

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

B.

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

C.

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

D.

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.

Question 15

Universal Containers has defined a new Data Quality Plan for their Salesforce data and wants to know how they can enforce it throughout the organization. Which two approaches should an architect recommend to enforce this new plan?

Choose 2 answers

Options:

A.

Schedule a weekly dashboard displaying records that are missing information to be sent to managers for review.

B.

Use Workflow, Validation Rules, and Force.com code (Apex) to enforce critical business processes.

C.

Schedule reports that will automatically catch duplicates and merge or delete the records every week.

D.

Store all data in an external system and set up an integration to Salesforce for view -only access.

Question 16

UC is building a salesforce application to track contacts and their respective conferences that they have attended with the following requirements:

1.Contacts will be stored in the standard contact object.

2.Conferences will be stored in a custom conference__c object.

3.Each contact may attend multiple conferences and each conference may be related to multiple contacts.

How should a data architect model the relationship between the contact and conference objects?

Options:

A.

Implement a Contact Conference junction object with master detail relationship to both contact and conference__c.

B.

Create a master detail relationship field on the Contact object.

C.

Create a master detail relationship field on the Conference object.

D.

Create a lookup relationship field on contact object.

Question 17

To address different compliance requirements, such as general data protection regulation (GDPR), personally identifiable information (PII), of health insurance Portability and Accountability Act (HIPPA) and others, a SF customer decided to categorize each data element in SF with the following:

  • Data owner
  • Security Level, such as confidential
  • Compliance types such as GDPR, PII, HIPPA

A compliance audit would require SF admins to generate reports to manage compliance.

What should a data architect recommend to address this requirement?

Options:

A.

Use metadata API, to extract field attribute information and use the extract to classify and build reports

B.

Use field metadata attributes for compliance categorization, data owner, and data sensitivity level.

C.

Create a custom object and field to capture necessary compliance information and build custom reports.

D.

Build reports for field information, then export the information to classify and report for Audits.

Question 18

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.

Question 19

A custom pricing engine for a Salesforce customer has to be decided by factors with the following hierarchy:

State in which the customer is located

City in which the customer is located if available

Zip code In which the customer is located if available

Changes to this information should have minimum code changes

What should a data architect recommend to maintain this information for the custom pricing engine that is to be built in Salesforce?

Options:

A.

Create a custom object to maintain the pricing criteria.

B.

Assign the pricing criteria within customer pricing engine.

C.

Maintain require pricing criteria in custom metadata types.

D.

Configure the pricing criteria in price books.

Question 20

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.

Question 21

Universal Container is using Salesforce for Opportunity management and enterprise resource planning (ERP) for order management. Sales reps do not have access to the ERP and have no visibility into order status.

What solution a data architect recommend to give the sales team visibility into order status?

Options:

A.

Leverage Canvas to bring the order management UI in to the Salesforce tab.

B.

Build batch jobs to push order line items to salesforce.

C.

leverage Salesforce Connect top bring the order line item from the legacy system to Salesforce.

D.

Build real-time integration to pull order line items into Salesforce when viewing orders.

Question 22

A customer wishes to migrate 700,000 Account records in a single migration into Salesforce. What is the recommended solution to migrate these records while minimizing migration time?

Options:

A.

Use Salesforce Soap API in parallel mode.

B.

Use Salesforce Bulk API in serial mode.

C.

Use Salesforce Bulk API in parallel mode.

D.

Use Salesforce Soap API in serial mode.

Question 23

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.)

Options:

A.

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

B.

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

C.

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

D.

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

Question 24

Universal Containers (UC) management has identified a total of ten text fields on the Contact object as important to capture any changes made to these fields, such as who made the change, when they made the change, what is the old value, and what is the new value. UC needs to be able to report on these field data changes within Salesforce for the past 3 months. What are two approaches that will meet this requirement? Choose 2 answers

Options:

A.

Create a workflow to evaluate the rule when a record is created and use field update actions to store previous values for these ten fields in ten new fields.

B.

Write an Apex trigger on Contact after insert event and after update events and store the old values in another custom object.

C.

Turn on field Contact object history tracking for these ten fields, then create reports on contact history.

D.

Create a Contact report including these ten fields and Salesforce Id, then schedule the report to run once a day and send email to the admin.

Question 25

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.

Question 26

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

Question 27

A data architect has been tasked with optimizing a data stewardship engagement for a Salesforce instance Which three areas of Salesforce should the architect review before proposing any design recommendation? Choose 3 answers

Options:

A.

Review the metadata xml files for redundant fields to consolidate.

B.

Determine if any integration points create records in Salesforce.

C.

Run key reports to determine what fields should be required.

D.

Export the setup audit trail to review what fields are being used.

E.

Review the sharing model to determine impact on duplicate records.

Question 28

Ursa Major Solar's legacy system has a quarterly accounts receivable report that compiles data from the following:

- Accounts

- Contacts

- Opportunities

- Orders

- Order Line Items

Which issue will an architect have when implementing this in Salesforce?

Options:

A.

Custom report types CANNOT contain Opportunity data.

B.

Salesforce does NOT support Orders or Order Line Items.

C.

Salesforce does NOT allow more than four objects in a single report type.

D.

A report CANNOT contain data from Accounts and Contacts.

Question 29

DreamHouse Realty has an integration that creates records in a Salesforce Custom Object. The Custom Object has a field marked as required on the page layout.

DreamHouse Realty has noticed that many of the records coming from the external system are missing data in this field.

The Architect needs to ensure this field always contains data coming from the source system.

Which two approaches should the Architect take? Choose 2 answers

Options:

A.

Set up a Validation Rule to prevent blank values.

B.

Create a Workflow to default a value into this field.

C.

Mark the field required in setup at the field level.

D.

Blame the customer's external system for bad data.

Question 30

A large Automobile company has implemented SF for its Sales Associates. Leads flow from its website to SF using a batch integration in SF. The Batch job connects the leads to Accounts in SF. Customer visiting their retail stores are also created in SF as Accounts.

The company has noticed a large number of duplicate accounts in SF. On analysis, it was found that certain customers could interact with its website and also visit the store. The Sales associates use Global Search to search for customers in Salesforce before they create the customers.

Which scalable option should a data Architect choose to implement to avoid duplicates?

Options:

A.

Create duplicate rules in SF to validate duplicates during the account creation process

B.

Implement a MDM solution to validate the customer information before creating Accounts in SF.

C.

Build Custom search based on fields on Accounts which can be matched with customer when they visit the store

D.

Customize Account creation process to search if customer exists before creating an Account.

Question 31

UC has a roll-up summary field on Account to calculate the count of contacts associated with an account. During the account load, SF is throwing an “Unable to lock a row” error.

Which solution should a data architect recommend, to resolve the error?

Options:

A.

Leverage data loader platform API to load data.

B.

Perform Batch job in parallel mode and reduce Batch size

C.

Perform Batch job in serial mode and reduce batch size

D.

Defer roll-up summary fields calculation during data migration.

Question 32

Universal Containers would like to have a Service-Level Agreement (SLA) of 1 day for any data loss due to unintentional or malicious updates of records in Salesforce. What approach should be suggested to address this requirement?

Options:

A.

Build a daily extract job and extract data to on-premise systems for long-term backup and archival purposes.

B.

Schedule a Weekly Extract Service for key objects and extract data in XL sheets to on-premise systems.

C.

Store all data in shadow custom objects on any updates and deletes, and extract them as needed .

D.

Evaluate a third-party AppExchange app, such as OwnBackup or Spanning, etc., for backup and archival purposes.

Question 33

Universal Containers has a rollup summary field on account to calculate the number of contacts associated with an account. During the account load, Salesforce is throwing an "UNABLE _TO_LOCK_ROW" error.

Which solution should a data architect recommend to resolve the error?

Options:

A.

Defer rollup summary field calculation during data migration.

B.

Perform a batch job in serial mode and reduce the batch size.

C.

Perform a batch job in parallel mode and reduce the batch size.

D.

Leverage Data Loader's platform API to load data.