Real Data-Architect Dumps – Salesforce Correct Answers updated on 2023 [Q147-Q170]

4/5 - (5 votes)

Use Real Data-Architect Dumps – Salesforce Correct Answers updated on 2023

Salesforce Application Architect Data-Architect Exam Practice Dumps

Earning the Salesforce Data-Architect certification demonstrates a candidate’s expertise in managing complex data architecture and integrations within the Salesforce platform. It is a valuable credential that can help professionals advance their careers and increase their earning potential. With the growing demand for data experts within the Salesforce ecosystem, the Salesforce Data-Architect certification is a valuable asset for any professional looking to advance in the industry.

Salesforce Data-Architect certification, also known as the Salesforce Certified Data Architect certification, is a prestigious certification that validates a professional’s ability to design, develop, and manage complex data solutions in Salesforce. Salesforce Certified Data Architect certification exam is designed to test a candidate’s knowledge and skills in data modeling, data integration, data governance, data migration, and data analytics.

QUESTION 147
Universal Containers (UC) has a Salesforce instance with over 10.000 Account records. They have noticed similar, but not identical. Account names and addresses. What should UC do to ensure proper data quality?

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

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.

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

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

QUESTION 149
Universal Containers (UC) is in the process of migrating lagacy inventory data from an enterprise resources planning (ERP) system into Sales Cloud with the following requirements:
Legacy inventory data will be stored in a custom child objects called Inventory_c.
Inventory data should be related to the standard Account object.
The Inventory_c object should Inhent the same sharing rules as the Account object.
Anytime an Account record is deleted in Salesforce, the related Inventory_c record(s) should be deleted as well.
What type of relationship field should a data architect recommend in this scenario?

Master-detail relationship filed on Account, related to Inventory_c

Master-detail relationship filed on Inventory_c, related to Account

Lookup relationship fields on Inventory related to Account

Indirect lookup relationship field on Account, related to Inventory_c

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

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

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

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

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

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

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

QUESTION 153
Universal Containers has implemented Salesforce for its operations. In order for customers to be created in their MDM solution, the customer record needs to have the following attributes:
1. First Name
2. Last Name
3. Email
Which option should the data architect recommend to mandate this when customers are created in Salesforce?

Configure Page Layout marking attributes as required fields.

Create validation rules to check If the required attributes are entered.

Mark Fields for the attributes as required under Setup.

Build validation in Integration with MDM to check required attributes.

QUESTION 154
A national nonprofit organization is using Salesforce to recruit members. The recruitment process requires a member to be matched with a volunteer opportunity. Given the following:
1. A record is created in Project__ c and used to track the project through completion.
2. The member may then start volunteering and is required to track their volunteer hours, which is stored in VTOTime_c object related to the project.
3. Ability to view or edit the VTOTime__c object needs to be the same as the Project__ c record.
4. Managers must see total hours volunteered while viewing the Project__ c record.
Which data relationship should the data architect use to support this requirement when creating the custom VTOTime__c object?

Lookup Field on Project_c to VTOTime_c displaying a list of VTOTime__c in a related list.

Lookup field on VTOTime_c to Project_c with formula filed on Project__ c showing Sum of hours from VTOTime__c records.

Master Detail Field on VTOTime_ c to Project_c with rollup summary field on Project __c showing sum of hours from VTOTime_c records.

Master Detail field on Project _c to VTOTime _c showing a list of VTOTime_c Records in a related list.

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

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

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

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

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

QUESTION 156
Universal Containers (UC) is implementing its new Internet of Things technology, which consists of smart containers that provide information on container temperature and humidity updated every 10 minutes back to UC. There are roughly 10,000 containers equipped with this technology with the number expected to increase to 50,000 across the next five years. It is essential that Salesforce user have access to current and historical temperature and humidity data for each container. What is the recommended solution?

Create new custom fields for temperature and humidity in the existing Container custom object, as well as an external ID field that is unique for each container. These custom fields are updated when a new measure is received.

Create a new Lightning Component that displays last humidity and temperature data for a specific container and can also display historical trends obtaining relevant data from UC’s existing data warehouse.

Create a new Container Reading custom object with a master-detail relationship to Container which is created when a new measure is received for a specific container. Implement an archiving process that runs every hour.

Create a new Container Reading custom object, which is created when a new measure is received for a specific container. The Container Reading custom object has a master-detail relationship to the container object.

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

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

Generate reports to view the quality of sample data.

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

Use custom objects and fields to calculate data quality.

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

QUESTION 159
Universal Containers (UC) is using Salesforce Sales & Service Cloud for B2C sales and customer service but they are experiencing a lot of duplicate customers in the system. Which are two recommended approaches for UC to avoid duplicate data and increase the level of data quality?

Use Duplicate Management.

Use an Enterprise Service Bus.

Use Data.com Clean

Use a data warehouse.

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

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

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

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.

QUESTION 161
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 Contact records together using the Streaming API via the Upsert operation.

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

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

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

QUESTION 162
Which two aspects of data does an Enterprise data governance program aim to improve?

Data integrity

Data distribution

Data usability

Data modeling

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

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

QUESTION 165
NTO has implemented salesforce for its sales users. The opportunity management in salesforce is implemented as follows:
1. Sales users enter their opportunities in salesforce for forecasting and reporting purposes.
2. NTO has a product pricing system (PPS) that is used to update opportunity amount field on opportunities on a daily basis.
3. PPS is the trusted source within the NTO for opportunity amount.
4. NTO uses opportunity forecast for its sales planning and management.
Sales users have noticed that their updates to the opportunity amount field are overwritten when PPS updates their opportunities.
How should a data architect address this overriding issue?

Create a custom field for opportunity amount that sales users update separating the fields that PPS updates.

Create a custom field for opportunity amount that PPS updates separating the field that sales user updates.

Change opportunity amount field access to read only for sales users using field level security.

Change PPS integration to update only opportunity amount fields when values is NULL.

QUESTION 166
UC has multiple SF orgs that are distributed 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.

QUESTION 167
Northern Trail Outfitters (NTO) wants to start a loyalty program to reward repeat customers. The program will track every item a customer has bought and grants them points for discounts. The following conditions will exist upon implementation:
Data will be used to drive marketing and product development initiatives.
NTO estimates that the program will generate 100 million rows of date monthly.
NTO will use Salesforce’s Einstein Analytics and Discovery to leverage their data and make business and marketing decisions.
What should the Data Architect do to store, collect, and use the reward program data?

Create a custom big object in Salesforce which will be used to capture the Reward Program data for consumption by Einstein.

Have Einstein connect to the point of sales system to capture the Reward Program data.

Create a big object in Einstein Analytics to capture the Loyalty Program data.

Create a custom object in Salesforce that will be used to capture the Reward Program data.

QUESTION 168
Universal Containers is creating a new B2C service offering for consumers to ship goods across continents. This is in addition to their well-established B2B offering. Their current Salesforce org uses the standard Account object to track B2B customers. They are expecting to have over 50,000,000 consumers over the next five years across their 50 business regions. B2C customers will be individuals. Household data is not required to be stored. What is the recommended data model for consumer account data to be stored in Salesforce?

Use the Account object with Person Accounts and a new B2C page layout.

Use the Account object with a newly created Record Type for B2C customers.

Create a new picklist value for B2C customers on the Account Type field.

Use 50 umbrella Accounts for each region, with customers as associated Contacts.

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

Work with Stakeholders to define record and field survivorship rules

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

Create new fields to store additional 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

QUESTION 170
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 Salesforce Object Query Language.

Use a data definition language.

Use an entity relationship diagram.

Use the Salesforce Metadata API.

Get ready to pass the Data-Architect Exam right now using our Salesforce Application Architect Exam Package: https://www.surepassexams.com/Data-Architect-exam-bootcamp.html

Leave a Reply Cancel reply