[Nov 02, 2022] Pass Salesforce Data-Architect Exam Info and Free Practice Test [Q75-Q97]

4/5 - (2 votes)

[Nov 02, 2022] Pass Salesforce Data-Architect Exam Info and Free Practice Test

Data-Architect Exam Dumps PDF Updated Dump from ExamcollectionPass Guaranteed Success

NO.75 A customer needs a sales model that allows the following:
Opportunities need to be assigned to sales people based on the zip code.
Each sales person can be assigned to multiple zip codes.
Each zip code is assigned to a sales area definition. Sales is aggregated by sales area for reporting.
What should a data architect recommend?

Configure territory management feature to support opportunity assignment.

Assign opportunities using list views using zip code.

Add custom fields in opportunities for zip code and use assignment rules.

Allow sales users to manually assign opportunity ownership based on zip code.

NO.76 Universal Containers (UC) maintains a collection of several million Account records that represent business in the United Sates. As a logistics company, this list is one of the most valuable and important components of UC’s business, and the accuracy of shipping addresses is paramount. Recently it has been noticed that too many of the addresses of these businesses are inaccurate, or the businesses don’t exist. Which two scalable strategies should UC consider to improve the quality of their Account addresses?

Contact each business on the list and ask them to review and update their address information.

Build a team of employees that validate Accounts by searching the web and making phone calls.

Leverage Data.com Clean to clean up Account address fields with the D&B database.

Integrate with a third-party database or services for address validation and enrichment.

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

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

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

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

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

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

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

Non-functional requirements

Integration specification

Data model

NO.80 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 3 activities will be required to identify a successful master data management strategy? Choose 3 answers:

Choose a Business Intelligence tool.

Identify data to be replicated

Define the systems of record for critical data

Create a data archive strategy

Install a data warehouse

NO.81 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 mashup page that will present the billing system records within Salesforce.

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

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

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

NO.82 A casino is implementing salesforce and is planning to build a customer 360 view for a customer who visits its resorts. The casino currently maintained the following systems that records customer activity:
1. Point of sales system: All purchases for a customer.
2. Salesforce: All customer service activity and sales activity 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 salesforce would like to view the activities from all system to provide supports to customers. The information has to be current and real time.
What strategy should the data architect implement to satisfy this requirement?

Periodically upload summary information in salesforce to build 360 view.

Migrate customer activities from all 4 systems into salesforce.

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

Explore external data sources in salesforce to build 360 view of customer.

NO.83 UC is implementing sales cloud for patient management and would like to encrypt sensitive patient records being stored in files.
Which solution should a data architect recommend to solve this requirement?

Implement 3rd party App Exchange app to encrypt files.

Use classic encryption to encrypt files.

Store files outside of salesforce and access them to real time.

Implement shield platform encryption to encrypt files.

NO.84 A health care provider wishes to use salesforce to track patient care. The following actions are in Salesforce
1. Payment Providers: Orgas who pay for the care 2 patients.
2. Doctors: They provide care plan for patients and need to support multiple patients, they are provided access to patient information.
3. 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 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

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

NO.85 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 a data definition language.

Use Salesforce Object Query Language.

Use an entity relationship diagram.

Use the Salesforce Metadata API.

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

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

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.

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.

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

NO.87 Universal Containers (UC) is in the process of selling half of its company. As part of this split, UC’s main Salesforce org will be divided into two org:org A and org B, UC has delivered these requirements to its data architect
1. The data model for Org B will drastically change with different objects, fields, and picklist values.
2. Three million records will need to be migrated from org A to org B for compliance reasons.
3. 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 the Salesforces CLI to query, export, and import

Use Data Loader for export and Data Import Wizard for import

Write a script to use the Bulk API

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

Configure shipment OWD to Public Read/Write.

Implement data archiving for old Shipment records.

Contact Salesforce to create Skinny tables on Shipment.

Contact Salesforce to enable Defer Sharing Rules

NO.89 Universal Containers (UC) has 1,000 accounts and 50,000 opportunities. UC has an enterprise security requirement to export all sales data outside of Salesforce on a weekly basis. The security requirement also calls for exporting key operational data that includes events such as file downloads, logins, logouts, etc. Which two recommended approaches would address the above requirement?

Use Event Monitoring to extract event data to on-premise systems.

Use a custom built extract job to extract operational data to on-premise systems.

Use Weekly Export to extract transactional data to on-premise systems.

Use Field Audit History to capture operational data and extract it to on-premise systems.

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

Using leading % wildcards.

Using NOT and != operators.

Using trailing % wildcards.

Using a custom index on a deterministic formula field.

Performing large loads and deletions.

NO.91 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 fulfill this goal? (Choose two.)

Apex Triggers

Third-party Integration Tool (ETL)

Schedulable Batch Apex

Third-party Business Intelligence system

NO.92 Northern Trail Outfitters has these simple requirements for a data export process:
File format should be in CSV.
Process should be scheduled and run once per week.
The expert should be configurable through the Salesforce UI.
Which tool should a data architect leverage to accomplish these requirements?

Third-party ETL tool

Data export wizard

Bulk API

Data loader

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

Standard SOQL queries

Einstein Analytics

Standard reports and dashboards

Async SOQL with a custom object

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

Apex Class

required Fields

validation Rule

Process Builder

NO.95 UC has a legacy client server app that as a relational data base that needs to be migrated to salesforce.
What are the 3 key actions that should be done when data modeling in salesforce?
Choose 3 answers:

Work with legacy application owner to analysis legacy data model.

Map legacy data to salesforce custom objects.

Identify data elements to be persisted in salesforce.

Map legacy data to salesforce objects.

Implement legacy data model within salesforce using custom fields.

NO.96 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 ETL for backup and restore from EDW.

Use AppExchange package for backup and restore.

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.

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

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

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

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