[Q72-Q89] Data-Architect Dumps are Available for Instant Access [2024]

NO.72 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 and make this user part of the highest-level role in the Role Hierarchy.

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.

NO.73 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?

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

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

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

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

NO.74 Northern Trail outfitters in migrating to salesforce from a legacy CRM system that identifies the agent relationships in a look-up table.
What should the data architect do in order to migrate the data to Salesfoce?

Migrate to Salesforce without a record owner.

Create custom objects to store agent relationships.

Assign record owner based on relationship.

Migrate the data and assign to a non-person system user.

NO.75 Universal Containers has a public website with several forms that create Lead records in Salesforce using the REST API. When designing these forms, which two techniques will help maintain a high level of data quality?

Do client-side validation of phone number and email field formats.

Prefer picklist form fields over free text fields, where possible.

Ensure the website visitor is browsing using an HTTPS connection.

Use cookies to track when visitors submit multiple forms.

NO.76 Universal Containers (UC) has adopted Salesforce as its primary sales automated tool. UC has 100,00 customers with a growth rate of 10% a year, UC uses an on-premise web-based billing and invoice system that generates over 1 million invoices a year supporting a monthly billing cycle.
The UC sales team needs to be able to pull a customer record and view their account status, Invoice history, and opportunities without navigating outside of Salesforce.
What should a data architect use to provide the sales team with the required functionality?

Create a custom object and migrate the last 12 months of Invoice data into Salesforce so it can be displayed on the Account layout.

Write an Apex callout and populate a related list to display on the account record.

Create a mashup page that will present the billing system records within Salesforce.

Create a visual force tab with the billing system encapsulated within an iframe.

NO.77 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?

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

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

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

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

NO.78 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?

Defer rollup summary field calculation during data migration.

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

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

Leverage Data Loader’s platform API to load data.

NO.79 Universal Container (UC) stores 10 million rows of inventory data in a cloud database, As part of creating a connected experience in Salesforce, UC would like to this inventory data to Sales Cloud without a import. UC has asked its data architect to determine if Salesforce Connect is needed.
Which three consideration should the data architect make when evaluating the need for Salesforce Connect?

You have a large amount of data that you don’t want to copy into your Salesforce org.

You need to expose data via a virtual private connection.

You have a large amount of data and would like to copy subsets of it into Salesforce.

You need to small amounts of external data at any one time.

You want real-time access to the latest data, from other systems.

NO.80 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?

Reduce number of users updated concurrently.

Enable granular locking.

Analyze Splunk query to spot offending records.

Increase CPU for the Salesforce org.

NO.81 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?

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

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

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

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

NO.82 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?

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

Generate reports to view the quality of sample data.

Use custom objects and fields to calculate data quality.

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

NO.83 Northern Trail Outfitters (NTO) has a variety of customers that include householder, businesses, and individuals.
The following conditions exist within its system:
NTO has a total of five million customers.
Duplicate records exist, which is replicated across many systems, including Salesforce.
Given these conditions, there is a lack of consistent presentation and clear identification of a customer record.
Which three option should a data architect perform to resolve the issues with the customer data?

Create a unique global customer ID for each customer and store that in all system for referential identity.

Duplicate customer records across the system and provide a two-way sync of data between the systems.

Create a customer master database external to Salesforce as a system of truth and sync the customer data with all systems.

Invest in data duplicate tool to de-dupe and merge duplicate records across all systems.

Use Salesforce CDC to sync customer data cross all systems to keep customer record in sync.

NO.84 Universal Containers (UC) needs to run monthly and yearly reports on opportunities and orders for sales reporting. There are 5 million opportunities and 10 million orders. Sales users are complaining that the report will regularly timeout.
What is the fastest and most effective way for a data architect to solve the time-out issue?

Create custom fields on opportunity, and copy data from order into those custom fields and run all reports on Opportunity object.

Extract opportunity and order data from Salesforce, and use a third-party reporting tool to run reports outside of Salesforce.

Create a skinny table in Salesforce, and copy order and opportunity fields into the skinny table and create the required reports on It.

Create an aggregate custom object that summarizes the monthly and yearly values into the required format for the required reports.

NO.85 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.

NO.86 Universal Container is Implementing salesforce and needs to migrate data from two legacy systems. UC would like to clean and duplicate data before migrate to Salesforce.
Which solution should a data architect recommend a clean migration?

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

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

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

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

NO.87 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?

Order batches by Auto -number field.

Group batches by the AccountId field.

Sort batches by Name field values.

Create indexes on Opportunity object text fields.

NO.88 Northern trail Outfitters (NTO) uses Sales Cloud and service Cloud to manage sales and support processes.
Some of NTOs team are complaining they see new fields on their page unsure of which values need be input.
NTO is concerned about lack of governance in making changes to Salesforce.
Which governance measure should a data architect recommend to solve this issue?

Add description fields to explain why the field is used, and mark the field as required.

Create and manage a data dictionary and ups a governance process for changes made to common objects.

Create reports to identify which users are leaving blank, and use external data sources o agreement the missing data.

Create validation rules with error messages to explain why the fields is used

NO.89 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