Salesforce Data Architect Dumps Updated: Latest Version (V9.03) to Pass Salesforce Certified Data Architect Exam

1. Universal Containers (UC) has a very large and complex Salesforce org with hundreds of validation rules and triggers. The triggers are responsible for system updates and data manipulation as records arecreated or updates by users. A majority of the automation tool within UC’’ org were not designed to run during a data load. UC is importing 100,000 records into Salesforce across several objects over the weekend.

What should a data architect do to mitigate any unwanted results during the import?

Ensure validation rules, triggers and other automation tools are disabled.

Ensure duplication and matching rules and defined.

Import the data in smaller batches over a 24-hour period.

Bulkily the trigger to handle import leads.

2. UC is migrating data from legacy system to SF.

UC would like to preserve the following information on records being migrated:

✑ Date time stamps for created date and last modified date.

✑ Ownership of records belonging to inactive users being migrated to Salesforce.

Which 2 solutions should a data architect recommends to preserve the date timestamps and ownership on records? Choose 2 answers.

Log a case with SF to update these fields

Enable update records with Inactive Owners Permission

Enable Set Audit fields upon Record Creation Permission

Enable modify all and view all permission.

3. A company wants to document the data architecture of a Salesforce organization.

What are two valid metadata types that should be included? (Choose two.)

RecordType

Document

CustomField

SecuritySettings

4. Universal Containers (UC) has implemented Sales Cloud for its entire sales organization, UC has built a custom object called projects_c that stores customers project detail and employee bitable hours.

The following requirements are needed:

A subnet of individuals from the finance team will need to access to the projects object for reporting and adjusting employee utilization.

The finance users will not access to any sales objects, but they will need to interact with the custom object.

Which license type a data architect recommend for the finance team that best meets the requirements?

Service Cloud

Sales Cloud

Light Platform Start

Lighting platform plus

5. Universal Containers has received complaints that customers are being called by multiple Sales Reps where the second Sales Rep that calls is unaware of the previous call by their coworker.

What is a data quality problem that could cause this?

Missing phone number on the Contact record.

Customer phone number has changed on the Contact record.

Duplicate Contact records exist in the system.

Duplicate Activity records on a Contact.

6. What should a data architect do to provide additional guidance for users when they enter information in a standard field?

Provide custom help text under field properties.

Create a custom page with help text for user guidance.

Add custom help text in default value for the field.

Add a label field with help text adjacent to the custom field.

7. A manager at Cloud Kicks is importing Leads into Salesforce and needs to avoid creating duplicate records.

Which two approaches should the manager take to achieve this goal? (Choose two.)

Acquire an AppExchange Lead de-duplication application.

Implement Salesforce Matching and Duplicate Rules.

Run the Salesforce Lead Mass de-duplication tool.

Create a Workflow Rule to check for duplicate records.

8. NTO processes orders from its website via an order management system (OMS). The OMS stores over 2 million historical records and is currently not integrated with SF. The Sales team at NTO using Sales cloud and would like visibility into related customer orders yet they do not want to persist millions of records directly in Salesforce. NTO has asked the data architect to evaluate SF connect and the concept of data verification.

Which 3 considerations are needed prior to a SF Connect implementation? Choose 3 answers

Create a 2nd system Admin user for authentication to the external source.

Develop an object relationship strategy.

Identify the external tables to sync into external objects

Assess whether the external data source is reachable via an ODATA endpoint.

Configure a middleware tool to poll external table data

9. UC has multiple SF orgs that aredistributed across regional branches. Each branch stores local customer data inside its org’s Account and Contact objects. This creates a scenario where UC is unable to view customers across all orgs.

UC has an initiative to create a 360-degree view of the customer, as UC would like to see Account and Contact data from all orgs in one place.

What should a data architect suggest to achieve this 360-degree view of the customer?

Consolidate the data from each org into a centralized datastore

Use Salesforce Connect’s cross-org adapter.

Build a bidirectional integration between all orgs.

Use an ETL tool to migrate gap Accounts and Contacts into each org.

10. Universal Containers (UC) has multi -level account hierarchies that represent departments within their major Accounts. Users are creating duplicate Contacts across multiple departments. UC wants to clean the data so as to have a single Contact across departments.

What two solutions should UC implement to cleanse their data? Choose 2 answers

Make use of a third -party tool to help merge duplicate Contacts across Accounts.

Use Data.com to standardize Contact address information to help identify duplicates.

Use Workflow rules to standardize Contact information to identify and prevent duplicates.

Make use of the Merge Contacts feature of Salesforce to merge duplicates for an Account.

11. Universal Containers (UC) wants to capture information on how data entities are stored within the different applications and systems used within the company. For that purpose, the architecture team decided to create a data dictionary covering the main business domains within UC.

Which two common techniques are used building a data dictionary to store information on how business entities are defined?

Use SalesforceObject Query Language.

Use a data definition language.

Use an entity relationship diagram.

Use the Salesforce Metadata AP

12. Due to security requirements, Universal Containers needs to capture specific user actions, such as login, logout, file attachment download, package install, etc.

What is the recommended approach for defining a solution for this requirement?

Use a field audit trail to capture field changes.

Use a custom object and trigger to capture changes.

Use Event Monitoring to capture these changes.

Use a third-party AppExchange app to capture changes.

13. 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?

Log a case with salesforce to make sharing rule changes.

Enable Defer Sharing Calculation prior to making sharing rule changes.

Delete old sharing rules and build new sharing rules

Log out all users and make changes to sharing rules.

14. NTO would like to retrieve their SF orgs meta data programmatically for backup within a various external.

Which API is the best fit for accomplishing thistask?

Metadata API

Tooling API

Bulk API in serial mode

SOAP API

15. 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 solutionshould 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

16. 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?

validation Rule

required Fields

Apex Class

Process Builder

17. Universal Containers is looking to use Salesforce to manage their sales organization. They will be migrating legacy account data from two aging systems into Salesforce.

Which two design considerations should an architect take to minimize data duplication? Choose 2 answers

Use a workflow to check and prevent duplicates.

Clean data before importing to Salesforce.

Use Salesforce matching and duplicate rules.

Import the data concurrently.

18. There is no need for more than 10 custom objects or additional file storage.

Which community cloud license type should a data architect recommend to meet the portal requirements?

Customer community.

Lightning external apps starter.

Customer community plus.

Partner community.

19. 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?

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

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

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

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

20. Universal Container (US) is replacing a home grown CRM solution with Salesforce, UC has decided to migrate operational (Open and active) records to Salesforce, while keeping historical records in legacy system, UC would like historical records to be available in Salesforce on an as needed basis.

Which solution should a data architect recommend to meet business requirement?

Leverage real-time integration to pull records into Salesforce.

Bring all data Salesforce, and delete it after a year.

Leverage mashup to display historical records in Salesforce.

Build a chair solution to go the legacy system and display records.

21. 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?

Create a custom object to maintain the pricing criteria.

Assign the pricing criteria within customer pricing engine.

Maintain require pricing criteria in custom metadata types.

Configure the pricing criteria in price books.

22. 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:

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

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

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

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

23. UC has millions of case records with case history and SLA data. UC’s compliance team would like historical cases to be accessible for 10 years for Audit purpose.

What solution should a data architect recommend?

Archive Case data using Salesforce Archiving process

Purchase more data storage to support case object

Use a custom object to store archived case data.

Use a custom Big object to store archived case data.

24. 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?

Embed the keywords FOR UPDATE after SOQL statements.

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

Migrate programmatic logic to processes and flows.

Refactor or optimize classes and trigger for maximum CPU performance.

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

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

27. Universal Containers (UC) has a Salesforce instance with over 10.000Account records.

They have noticed similar, but not identical. Account names and addresses.

What should UC do to ensure proper data quality?

Use a service to standardize Account addresses, then use a 3rd -party tool to merge Accounts based on rules.

Run a report, find Accounts whose name starts with the same five characters, then merge those Accounts.

Enable Account de -duplication by creating matching rules in Salesforce, which will mass merge duplicate Accounts.

Make the Account Owner clean their Accounts' addresses, then merge Accounts with the same address.

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

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

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

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

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

29. Universal Containers (UC) has a multi-level master-detail relationship for opportunities, a custom opportunity line item object, and a custom discount request. UC has opportunity as master and custom line item object as detail in master-detail relationship. UC also has a custom line item object as master and a custom discount request object as detail in another master-detail relationship. UC has a requirement to show all sums of discounts across line items at an opportunity level.

What is the recommended solution to address these requirements?

Use roll-up for the line-item-level summary and a trigger for the opportunity amount summary, as only one level roll-up is allowed.

Update the master-detail relationships to lookup relationships in order to allow the discount amount to roll up.

Remove the master-detail relationships and rely completely on workflow/triggers to summarize the discount amount.

Roll-up discount request amount at the line-item-level and line-item-level summary discount at the opportunity level.

30. Universal Containers (UC) provides shipping services to its customers. They use Opportunities to track customer shipments. At any given time, shipping status can be one of the 10 values. UC has 200,000 Opportunity records.

When creating a new field to track shipping status on opportunity, what should the architect do to improve data quality and avoid data skew?

Create a picklist field, values sorted alphabetically.

Create a Master -Detail to custom object ShippingStatus c.

Create a Lookup to custom object ShippingStatus c.

Create a text field and make it an external I

31. 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?

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

Manually upload Notes in Lighting Experience.

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

Manually upload Attachments in Lighting Experience.

32. Marketing: All email, SMS, and social campaigns for a customer

Customer service agents using Salesforee would like to view the activities from all four systems to provide support to customers. The information has to be current and real time.

What strategy should the data architect implement to satisfy this requirement?

Explore external data sources in Salesforce to build a 360 degree view of the customer.

Use a customer data mart to create the 360 degree view of the customer.

Periodically upload summary information in Salesforce to build a 360 degree view.

Migrate customer activities fro, all four system into Salesforce.

33. Universal Containers (UC) is a major supplier of office supplies. Some products are produced by UC and some by other manufacturers. Recently, a number of customers have complained that product descriptions on the invoices do not match the descriptions in the online catalog and on some of the order confirmations (e.g., "ballpoint pen" in the catalog and "pen" on the invoice, anditem color labels are inconsistent: "what vs. "White" or "blk" vs. "Black"). All product data is consolidated in the company data warehouse and pushed to Salesforce to generate quotes and invoices. The online catalog and webshop is a Salesforce CustomerCommunity solution.

What is a correct technique UC should use to solve the data inconsistency?

Change integration to let product master systems update product data directly in Salesforce via the Salesforce AP

Add custom fields to the Product standard object in Salesforce to store data from the different source systems.

Define a data taxonomy for product data and apply the taxonomy to the product data in the data warehouse.

Build Apex Triggers in Salesforce that ensure products have the correct names and labels after data is loaded into salesforce.

34. 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 ER

35. Two million Opportunities need to be loaded in different batches into Salesforce using the Bulk API in parallel mode.

What should an Architect consider when loading the Opportunity records?

Use the Name field values to sort batches.

Order batches by Auto-number field.

Create indexes on Opportunity object text fields.

Group batches by the AccountId field.

36. 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?

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

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

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

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

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

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

Create a formula field instead of having multiple filter criteria.

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

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

38. Northern Trail Outfitters (NTO) wants to implement backup and restore for Salesforce data, Currently, it has data backup processes that runs weekly, which back up all Salesforce data to an enterprise data warehouse (EDW). NTO wants to move to daily backups and provide restore capability to avoid any data loss in case of outage.

What should a data architect recommend for a daily backup and restore solution?

Use AppExchange package for backup and restore.

Use ETL for backup and restore from ED

Use Bulk API to extract data on daily basis to EDW and REST API for restore.

Change weekly backup process to daily backup, and implement a custom restore solution.

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

40. 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?

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

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

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

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

41. A customer is operating in a highly reputated industry and is planning to implement SF.

The customer information maintained in SF, includes the following:

✑ Personally, identifiable information (PII)

✑ IP restrictions on profiles organized by Geographic location

✑ Financial records that need to be private and accessible only by the assigned Sales associate.

✑ User should not be allowed to export information from Salesforce.

Enterprise security has mandate access to be restricted to users within a specific geography and detail monitoring of user activity.

Which 3 Salesforce shield capabilities should a data architect recommend? Choose 3 answers:

Event monitoring to monitor all user activities

Restrict access to SF from users outside specific geography

Prevent Sales users access to customer PII information

Transaction security policies to prevent export of SF Data.

Encrypt Sensitive Customer information maintained in S

42. Universal Containers (UC) is migrating from an on-premise homegrown customer relationship management (CRM) system- During analysis, UC users highlight a pain point that there are multiple versions of many customers.

What should the data architect do for a successful migration to mitigate the pain point?

Hire an intern manually de-duplicate the records after migrating to Salesforce.

Migrate the data as is, and use Salesforce's de-duplicating feature.

Have the users manually clean the data in the old system prior to migration.

Store the data in a staging database, andde-duplicate identical records.

43. UC is using SF CRM. UC sales managers are complaining about data quality and would like to monitor and measure data quality.

Which 2 solutions should a data architect recommend to monitor and measure data quality? Choose 2 answers.

Use custom objects and fieldsto identify issues.

Review data quality reports and dashboards.

Install and run data quality analysis dashboard app

Export data and check for data completeness outside of Salesforce.

44. Universal Containers (UC) is facing data quality issues where Sales Reps are creating duplicate customer accounts, contacts, and leads. UC wants to fix this issue immediately by prompting users about a record that possibly exists in Salesforce. UC wants a report regarding duplicate records.

What would be the recommended approach to help UC start immediately?

Create an after insert and update trigger on the account, contact and lead, and send an error if a duplicate is found using a custom matchingcriteria.

Create a duplicate rule for account, lead, and contact, use standard matching rules for these objects, and set the action to report and alert for both creates and edits.

Create a duplicate rule for account, lead, and contact, use standardmatching rules for these objects, and set the action to block for both creates and edits.

Create a before insert and update trigger on account, contact, and lead, and send an error if a duplicate is found using a custom matching criteria.

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

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

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

Lightning platform starter license.

Service cloud license.

Salesforce license.

Sales cloud license

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

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

Contact Salesforce to activate indexing before uploading the data.

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

Defer sharing calculations until the data has finished uploading.

48. The head of sales at Get Cloudy Consulting wants to understand key relevant performance figures and help managers take corrective actions where appropriate.

What is one reporting option Get Cloudy Consulting should consider?

Case SLA performance report

Sales KPI Dashboard

Opportunity analytic snapshot

Lead conversion rate report

49. DreamHouseRealty has an integration that creates records in a Salesforce Custom Object.

The Custom Object has a field marked as required on the page layout.

Dream House 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

Set up a Validation Rule to prevent blank values.

Create a Workflow to default a value into this field.

Mark the field required in setup at the field level.

Blame the customer's external system for bad data.

50. A customer wants to maintain geographic location information including latitude and longitude in a custom object.

What would a data architect recommend to satisfy this requirement?

Create formula fields with geolocation function for this requirement.

Create custom fields to maintain latitude and longitude information

Create a geolocation custom field to maintain this requirement

Recommend app exchange packages to support this requirement.

51. Marketing solution

What should a data architect recommend that would help upgrade uniquely identify customer across multiple systems:

Store the salesforce id in all the solutions to identify the customer.

Create a custom object that will serve as a cross reference for the customer id.

Create a customer data base and use this id in all systems.

Create a custom field as external id to maintain the customer Id from the MDM solution.

52. Ursa Major Solar has defined a new Data Quality Plan for their Salesforce data.

Which two approaches should an Architect recommend to enforce the plan throughout the organization? (Choose two.)

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

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

Enforce critical business processes by using Workflow, Validation Rules, and Apex code.

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

53. Universal Containers (UC) has a complex system landscape and is implementing a data governance program for the first time Which two first steps would be appropriate for UC to initiate an assessment of data architecture? Choose 2 answers

Engage with IT program managers to assess current velocity of projects in the pipeline.

Engage with database administrators to assess current database performance metrics.

Engage with executive sponsorship to assess enterprise data strategy and goals.

Engage with business units and IT to assess current operational systems and data models.

54. UC has the following system:

✑ Billing system.

✑ Customer support system.

✑ CRM system.

US has been having trouble with business intelligence across the different systems. Recently US implemented a master data management (MDM) solution that will be the system of truth for the customer records.

Which MDM data element is needed to allow reporting across these systems?

Global unique customer number.

Email address.

Phone number.

Full name.

55. 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 delaysquerying parents order IDs in Salesforce before importing related order line items.

What is the recommended solution?

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

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

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

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

56. The migrate will need occur within the next two month, prior to be split.

Which migrate strategy should a data architect use to successfully migrate the date?

use as ETL tool to orchestrate the migration.

Use Data Loader for export and Data Import Wizard for import

Write a script to use the Bulk API

Use the Salesforces CLI to query, export, and import

57. 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 recommendationsshould 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 associating10000 opportunities to one account.

Limit associating 10000 records looking up to same records.

58. 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 tocustomize which fields will be sent to the external system without changing code.

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

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

An Outbound Message to determine which fields to send to the OM

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

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

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

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

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

Create a master detail relationship field on the Contact object.

Createa master detail relationship field on the Conference object.

Create a lookup relationship field on contact object.

60. Cloud Kicks needs to purge detailed transactional records from Salesforce. The data should be aggregated at a summary level and available in Salesforce.

What are two automated approaches to fulfillthis goal? (Choose two.)

Third-party Integration Tool (ETL)

Schedulable Batch Apex

Third-party Business Intelligence system

Apex Triggers

61. Universal Containers (UC) is expecting to have nearly 5 million shipments records in its Salesforce org. Each shipment record has up to 10 child shipment item records. The Shipment custom object has an Organization-wide Default (OWD) sharing model set to Private and the Shipment Item custom object has a Master-Detail relationship to Shipment. There are 25 sharing rules set on the Shipment custom object, which allow shipment records to be shared to each of UC's 25 business areas around the globe. These sharing rules use public groups, one for each business area plus a number of groups for management and support roles. UC has a high turnover of Sales Reps and often needs to move Sales Reps between business areas in order to meet local demand.

What feature would ensure that performance, when moving Sales Reps between regions, remains adequate while meeting existing requirements?

Implement data archiving for old Shipment records.

Contact Salesforce to create Skinny tables on Shipment.

Configure shipment OWD to Public Read/Write.

Contact Salesforce to enable Defer Sharing Rules

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

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

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

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

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

63. UC has a variety of systems across its technology landscape, including SF, 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 (MDM) strategy.

What are the 3 key steps that a data architect should take when merging data from multiple systems into Salesforce? Choose 3 answers:

Create new fields to storeadditional values from all the systems.

Install a 3rd party AppExchange tool to handle the merger

Analyze each system’s data model and perform gap analysis

Utilize an ETL tool to merge, transform and de-duplicate data.

Work with Stakeholders to define record and field survivorship rules

64. A customer is facing locking issued when importing large data volumes of order records that are children in amaster-detail relationship with the Account object.

What is the recommended way to avoid locking issues during import?

Import Account records first followed by order records after sorting order by OrderI

Import Account records first followed by order records after sorting orders by AccountI

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

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

65. Poor customer experience and higher costs

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

Build process is manually search and merge duplicates.

Standard lead information across all channels.

Build a custom solution to identify and merge duplicate leads.

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

Implement de-duplication strategy to prevent duplicate leads

66. Universal Containers (UC) is implementing Salesforce and will be using Salesforceto 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?

Sales Cloud License

Lightning Platform Starter License

Service Cloud License

Salesforce License

67. DreamHouse Realty has 15 million records in the Order_c custom object. When running a bulk query, the query times out.

What should be considered to address this issue?

Tooling API

PK Chunking

Metadata API

Streaming API

68. (NTO) has multiple salesforce orgs based on geographical reports (AMER, EMEA, APAC). NTO products are in the AMER org and need to be created in the EMEA and APAC after the products are approved.

Which two features should a data architect recommend to share records between salesforce orgs? Choose 2.

Change data capture (CDC)

Salesforce connect.

Federation search

Salesforce 2 Salesforce

69. 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 areexported 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.

70. Universal Containers (UC) is concerned about the accuracy of their Customer informationin 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?

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

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

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

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

71. NTO has 1 million customer records spanning 25 years. As part of its new SF project, NTO would like to create a master data management strategy to help preserve the history and relevance of its customer data.

Which 3activities will be required to identify a successful master data management strategy? Choose 3 answers:

Identify data to be replicated

Create a data archive strategy

Define the systems of record for critical data

Install a data warehouse

Choose a Business Intelligence tool.

72. Universal Containers has two systems. Salesforce and an on -premise ERP system. Anarchitect has been tasked with copying Opportunity records to the ERP once they reach a Closed/Won Stage. The Opportunity record in the ERP system will be read-only for all fields copied in from Salesforce.

What is the optimal real-time approach that achieves this solution?

Implement a Master Data Management system to determine system of record.

Implement a workflow rule that sends Opportunity data through Outbound Messaging.

Have the ERP poll Salesforce nightly and bring in the desired Opportunities.

Implement an hourly integration to send Salesforce Opportunities to the ERP system.

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?

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.

74. 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?

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

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

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

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

75. An Architect needs to document the data architecture for a multi-system, enterprise Salesforce implementation.

Which two key artifacts should the Architect use? (Choose two.)

User stories

Data model

Integration specification

Non-functional requirements

Salesforce Data Architect Dumps Updated: Latest Version (V9.03) to Pass Salesforce Certified Data Architect Exam

Read Salesforce Data Architect Free Dumps Demo Below

About The Author

dumps

Add a Comment

Read Salesforce Data Architect Free Dumps Demo Below

Related Posts

About The Author

dumps

Add a Comment