Download Salesforce Data-Architect Mock Test Study Material [Q97-Q114]

Rate this post

Download Salesforce Data-Architect Mock Test Study Material

Data-Architect Questions Prepare with Learning Information

QUESTION 97
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.

QUESTION 98
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?

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

Add limit 100 to the query.

Remove description from the requested field set.

Change query to SOSL. ??

QUESTION 99
US has released a new disaster recovery (DR)policy that states that cloud solutions need a business continuity plan in place separate from the cloud providers built in data recovery solution.
Which solution should a data architect use to comply with the DR policy?

Leverage salesforce weekly exports, and store data in Flat files on a protected system.

Utilize an ETL tool to migrate data to an on-premise archive solution.

Leverage a 3rd party tool that extract salesforce data/metadata and stores the information in an external protected system.

Write a custom batch job to extract data changes nightly, and store in an external protected system.

QUESTION 100
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

Run key reports to determine what fields should be required.

Review the metadata xml files for redundant fields to consolidate.

Review the sharing model to determine impact on duplicate records.

Determine if any integration points create records in Salesforce.

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

QUESTION 101
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 executive sponsorship to assess enterprise data strategy and goals.

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

Engage with database administrators to assess current database performance metrics.

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

QUESTION 102
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?

Refactor or optimize classes and trigger for maximum CPU performance.

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

Embed the keywords FOR UPDATE after SOQL statements.

Migrate programmatic logic to processes and flows.

QUESTION 103
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?

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

Defer rollup summary field calculation during data migration.

Leverage Data Loader’s platform API to load data.

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

QUESTION 104
Universal Containers has a large volume of Contact data going into Salesforce.com. There are 100,000 existing contact records. 200,000 new contacts will be loaded. The Contact object has an external ID field that is unique and must be populated for all existing records. What should the architect recommend to reduce data load processing time?

Load all records via the Upsert operation to determine new records vs. existing records.

Load Contact records together using the Streaming API via the Upsert operation.

Load new records via the Insert operation and existing records via the Update operation.

Delete all existing records, and then load all records together via the Insert operation.

QUESTION 105
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?

Maximum external objects per org

Maximum page size for server-driven paging

Maximum number for records returned

OData callout limits per day

QUESTION 106
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:

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

Identify the external tables to sync into external objects

Configure a middleware tool to poll external table data

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

Develop an object relationship strategy.

QUESTION 107
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

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

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

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

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

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

QUESTION 108
Get Cloudy Consulting needs to evaluate the completeness and consistency of contact information in Salesforce. Their sales reps often have incomplete information about their accounts and contacts. Additionally, they are not able to interpret the information in a consistent manner. Get Cloudy Consulting has identified certain “”key”” fields which are important to their sales reps.
What are two actions Get Cloudy Consulting can take to review their data for completeness and consistency? (Choose two.)

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

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

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

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

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

Add custom help text in default value for the field.

Provide custom help text under field properties.

Create a custom page with help text for user guidance.

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

QUESTION 110
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:

Clear the role field in the generic user record.

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

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

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

QUESTION 111
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?

Perform Batch job in parallel mode and reduce Batch size

Defer roll-up summary fields calculation during data migration.

Leverage data loader platform API to load data.

Perform Batch job in serial mode and reduce batch size

QUESTION 112
Universal Containers (UC) requires 2 years of customer related cases to be available on SF for operational reporting. Any cases older than 2 years and upto 7 years need to be available on demand to the Service agents. UC creates 5 million cases per yr.
Which 2 data archiving strategies should a data architect recommend? Choose 2 options:

Use Big objects for cases older than 2 years, and use nightly batch to move them.

Sync cases older than 2 years to an external database, and provide access to Service agents to the database

Use custom objects for cases older than 2 years and use nightly batch to move them.

Use Heroku and external objects to display cases older than 2 years and bulk API to hard delete from Salesforce.

QUESTION 113
NTO has a loyalty program to reward repeat customers. The following conditions exists:
1. Reward levels are earned based on the amount spent during the previous 12 months.
2. The program will track every item a customer has bought and grant them points for discount.
3. The program generates 100 million records each month.
NTO customer support would like to see a summary of a customer’s recent transaction and reward level(s) they have attained.
Which solution should the data architect use to provide the information within the salesforce for the customer support agents?

Create a custom object in salesforce to capture and store all reward program. Populate nightly from the point-of-scale system, and present on the customer record.

Provide a button so that the agent can quickly open the point of sales system displaying the customer history.

Capture the reward program data in an external data store and present the 12 months trailing summary in salesforce using salesforce connect and then external object.

Create a custom big object to capture the reward program data and display it on the contact record and update nightly from the point-of-scale system.

QUESTION 114
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 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.

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 matching criteria.

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 standard matching rules for these objects, and set the action to block for both creates and edits.