[Dec 09, 2022] New 2022 Salesforce Data-Architect Exam Dumps with PDF from ExamsTorrent (Updated 224 Questions) [Q99-Q120]

Rate this post

New 2022 Data-Architect exam questions Welcome to download the newest ExamsTorrent Data-Architect PDF dumps (224 Q&As)

P.S. Free 2022 Salesforce Application Architect Data-Architect dumps are available on Google Drive shared by ExamsTorrent

Q99. UC has one SF org (Org A) and recently acquired a secondary company with its own Salesforce org (Org B). UC has decided to keep the orgs running separately but would like to bidirectionally share opportunities between the orgs in near-real time.
Which 3 options should a data architect recommend to share data between Org A and Org B?
Choose 3 answers.

Install a 3rd party AppExchange tool to handle the data sharing

Leverage middleware tools to bidirectionally send Opportunity data across orgs.

Leverage Heroku Connect and Heroku Postgres to bidirectionally sync Opportunities.

Use Salesforce Connect and the cross-org adapter to visualize Opportunities into external objects

Develop an Apex class that pushes opportunity data between orgs daily via the Apex schedule.

Q100. UC is trying to switch from legacy CRM to salesforce and wants to keep legacy CRM and salesforce in place till all the functionality is deployed in salesforce. The want to keep data in synch b/w Salesforce, legacy CRM and SAP. What is the recommendation.

Do not integrate legacy CRM to Salesforce, but integrate salesforce to SAP

Suggest MDM solution and link MDM to salesforce and SAP

Integrate legacy CRM to salesforce and keep data in synch till new functionality is in place

Integrate SAP with Salesforce, SAP to legacy CRM but not legacy CRM to Salesforce

Q101. NTO has outgrown its current salesforce org and will be migrating to new org shortly. As part of this process NTO will be migrating all of its metadata and dat a. NTO’s data model in the source org has a complex relationship hierarchy with several master detail and lookup relationships across objects, which should be maintained in target org.
What 3 things should a data architect do to maintain the relationship hierarchy during migration?
Choose 3 answers:

Redefine the master detail relationship fields to lookup relationship fields in the target org.

Create a external id field for each object in the target org and map source record ID’s to this field.

Use data loader to export the data from source org and then import or Upsert into the target org in sequential order.

Keep the relationship fields populated with the source record ID’s in the import file.

Replace source record ID’s with new record ID’s from the target org in the import file.

Q102. 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

Q103. 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.

Q104. 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.

Q105. Which three characteristics of a Skinny table help improve report and query performance?

Skinny tables are kept in sync with changes to data in the source tables.

Skinny tables can contain frequently used fields and thereby help avoid joins.

Skinny tables do not include records that are available in the recycle bin.

Skinny tables can be used to create custom indexes on multi-select picklist fields.

Skinny tables provide a view across multiple objects for easy access to combined data.

Q106. UC has a requirement to migrate 100 million order records from a legacy ERP application into the salesforce platform. UC does not have any requirements around reporting on the migrated data.
What should a data architect recommend to reduce the performance degradation of the platform?

Implement a custom big object to store the data.

Create a custom object to store the data.

Use a standard big object defined by salesforce.

Use the standard “Order” object to store the data.

Q107. The architect is planning a large data migration for Universal Containers from their legacy CRM system to Salesforce. What three things should the architect consider to optimize performance of the data migration? Choose 3 answers

Review the time zones of the User loading the data.

Defer sharing calculations of the Salesforce Org.

Remove custom indexes on the data being loaded.

Deactivate approval processes and workflow rules.

Determine if the legacy system is still in use.

Q108. NTO has been using salesforce for sales and service for 10 years. For the past 2 years, the marketing group has noticed a raise from 0 to 35 % in returned mail when sending mail using the contact information stored in salesforce.
Which solution should the data architect use to reduce the amount of returned mails?

Email all customer and asked them to verify their information and to call NTO if their address is incorrect.

Have the sales team to call all existing customers and ask to verify the contact details.

Delete contacts when the mail is returned to save postal cost to NTO.

Use a 3rd-party data source to update contact information in salesforce.

Q109. 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.

Q110. 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 Data.com Clean

Use Duplicate Management.

Use an Enterprise Service Bus.

Use a data wharehouse.

Q111. UC has been using SF for 10 years. Lately, users have noticed, that the pages load slowly when viewing Customer and Account list view.
To mitigate, UC will implement a data archive strategy to reduce the amount of data actively loaded.
Which 2 tasks are required to define the strategy? Choose 2 answers:

Identify the recovery time objective.

Identify how the archive data will be accessed and used.

Identify the data retention requirements

Identify the recovery point objective.

Q112. 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.

Defer sharing calculations until the data has finished uploading.

First, load all account records, and then load all user records.

Q113. 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.

Q114. A large retail B2C customer wants to build a 360 view of its customer for its call center agents. The customer interaction is currently maintained in the following system: 1. Salesforce CRM
2. Custom billing solution
3. Customer Master Data management (MDM)
4. Contract Management system
5. Marketing solution
What should a data architect recommend that would help upgrade uniquely identify customer across multiple systems:

Create a custom object that will serve as a cross reference for the customer id.

Create a customer data base and use this id in all systems.

Create a custom field as external id to maintain the customer Id from the MDM solution.

Store the salesforce id in all the solutions to identify the customer.

Q115. Northern Trail Outfitters (NTO) has the following systems:
Customer master-source of truth for customer information
Service cloud-customer support
Marketing cloud-marketing support
Enterprise data warehouse-business reporting
The customer data is duplicated across all these system and are not kept in sync. Customers are also complaining that they get repeated marketing emails and have to call into update their information.
NTO is planning to implement master data management (MDM) solution across the enterprise.
Which three data will an MDM tool solve?
Choose 3 answers

Data loss and recovery

Data standardization

Data duplication

Data accuracy and quality

Data completeness

Q116. Which two best practices should be followed when using SOSL for searching?

Use SOSL option to ignore custom indexes as search fields are pre-indexed.

Use Find in “ALL FIELDS” for faster searches.

Use searches against single Objects for greater speed and accuracy.

Keep searches specific and avoid wildcards where possible.

Q117. 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.

Q118. 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.

Q119. 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.

Q120. 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.