Salesforce Data-Architect Test Engine Practice Test Questions, Exam Dumps [Q121-Q136]

Rate this post

Salesforce Data-Architect Test Engine Practice Test Questions, Exam Dumps

100% Free Data-Architect Daily Practice Exam With 224 Questions

Salesforce Data-Architect Exam Syllabus Topics:

Topic	Details
Topic 1	Recommend and use techniques for establishing a “golden record” or “system of truth” Recommend a data archiving and purging plan that is optimal for customer’s data storage management needs
Topic 2	Recommend appropriate approaches and techniques to capture and maintain customer reference & metadata Compare and contrast various techniques for improving performance when migrating large data volumes into Salesforce
Topic 3	Recommend techniques to ensure data is persisted in a consistent manner Design a data model that scales considering large data volume and solution performance
Topic 4	Decide when to use virtualised data and describe virtualised data options Compare and contrast various techniques and considerations for exporting data from Salesforce
Topic 5	Recommend a design to effectively consolidate and or leverage data from multiple Salesforce instances Compare and contrast various techniques, approaches and considerations
Topic 6	Recommend approaches and techniques for consolidating data attributes from multiple sources Given a scenario with multiple systems of interaction
Topic 7	Describe techniques to represent a single view of the customer on the Salesforce platform Recommend appropriate techniques and methods for ensuring high data quality at load time

NEW QUESTION 121
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?

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

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

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

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

NEW QUESTION 122
Get Cloudy Consulting monitors 15,000 servers, and these servers automatically record their status every 10 minutes. Because of company policy, these status reports must be maintained for 5 years. Managers at Get Cloudy Consulting need access to up to one week’s worth of these status reports with all of their details.
An Architect is recommending what data should be integrated into Salesforce and for how long it should be stored in Salesforce.
Which two limits should the Architect be aware of? (Choose two.)

Workflow rule limits

Webservice callout limits

Data storage limits

API Request limits

NEW QUESTION 123
Universal Containers (UC) is concerned that data is being corrupted daily either through negligence or maliciousness. They want to implement a backup strategy to help recover any corrupted data or data mistakenly changed or even deleted. What should the data architect consider when designing a field -level audit and recovery plan?

Review projected data storage needs.

Reduce data storage by purging old data.

Schedule a weekly export file.

Implement an AppExchange package.

NEW QUESTION 124
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?

Use Salesforce Bulk API in parallel mode.

Use Salesforce Soap API in parallel mode.

Use Salesforce Soap API in serial mode.

Use Salesforce Bulk API in serial mode.

NEW QUESTION 125
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?

Customer Community license

Lightning Platform license

Partner Community license

Salesforce Sales Cloud license

NEW QUESTION 126
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?

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

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

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

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

NEW QUESTION 127
NTO has decided that it is going to build a channel sales portal with the following requirements:
1. External resellers are able to authenticate to the portal with a login.
2. Lead data, opportunity data and order data are available to authenticated users.
3. Authenticated users many need to run reports and dashboards.
4. 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 plus.

Lightning external apps starter.

Customer community.

Partner community.

NEW QUESTION 128
A casino is implementing Salesforce and is planning to build a customer 360 degree view for a customer who visits its resorts. The casino currently maintains the following systems that record customer activity: L Point-of-sale system: All purchases for a customer
2. Salesforce; All customer service activity and sales activities for a customer
3. Mobile app: All bookings, preferences, and browser activity for a customer
4. 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?

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

Migrate customer activities fro, all four system into Salesforce.

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

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

NEW QUESTION 129
UC migrating 100,000 Accounts from an enterprise resource planning (ERP) to salesforce and is concerned about ownership skew and performance.
Which 3 recommendations should a data architect provide to prevent ownership skew?
Choose 3 answers:

Assign a default user as owner of account and do not assign any role to default user.

Assigned a default user as owner of accounts, and assign role in hierarchy.

Assign a default user as owner of accounts and assigned top most role in hierarchy.

Assign “view all” permission on profile to give access to account.

Keep users out of public groups that can be used as the source for sharing rules.

NEW QUESTION 130
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.

Group batches by the AccountId field.

Create indexes on Opportunity object text fields.

Order batches by Auto-number field.

NEW QUESTION 131
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?

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

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

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

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

NEW QUESTION 132
A large multinational B2C Salesforce customer is looking to implement their distributor management application is Salesforce. the application has the following capabilities:
1.Distributor create sales order in salesforce
2.Sales order are based on product prices applicable to their region
3. Sales order are closed once they are fulfilled
4. It is decided to maintain the order in opportunity object
How should the data architect model this requirement?

Manually update Opportunities with Prices application to distributors.

Configure price Books for each region and share with distributors.

Create lookup to Custom Price object and share with distributors.

Add custom fields in Opportunity and use triggers to update prices.

NEW QUESTION 133
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?

Use Apex Crypto Class encrypt customer and standard fields.

Implement shield platform encryption to encrypt and standard fields

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

Implement classic encryption to encrypt custom and standard fields.

NEW QUESTION 134
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.

NEW QUESTION 135
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?

Number of records returned by report query.

Number of characters in report query.

Number of queries running at a time.

Number of joins used in report query.

NEW QUESTION 136
During the implementation of Salesforce, a customer has the following requirements for Sales Orders:
1. Sales Order information needs to be shown to users in Salesforce.
2. Sales Orders are maintained in the on-premises enterprise resource planning (ERP).
3. Sales Order information has more than 150 million records.
4. Sales Orders will not be updated in Salesforce.
What should a data architect recommend for maintaining Sales Orders in salesforce?

Use external objects to maintain Sales Order in Salesforce.

Use Standard order object to maintain Sale Orders in Salesforce

Us custom objects to maintain Sales Orders in Salesforce.

Use custom big objects to maintain Sales Orders in Salesforce.

Loading …