Data-Architect Certification Overview - [Jun 04, 2023] Latest Data-Architect PDF Dumps
The Best Salesforce Data-Architect Study Guides and Dumps of 2023
NEW QUESTION # 44
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:
- A. Use data loader to export the data from source org and then import or Upsert into the target org in sequential order.
- B. Redefine the master detail relationship fields to lookup relationship fields in the target org.
- C. Create a external id field for each object in the target org and map source record ID's to this field.
- D. Keep the relationship fields populated with the source record ID's in the import file.
- E. Replace source record ID's with new record ID's from the target org in the import file.
Answer: A,C,E
NEW QUESTION # 45
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?
- A. 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.
- B. Provide a button so that the agent can quickly open the point of sales system displaying the customer history.
- C. 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.
- D. 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.
Answer: A
NEW QUESTION # 46
A Customer is migrating 10 million order and 30 million order lines into Salesforce using Bulk API. The Engineer is experiencing time-out errors or long delays querying parents order IDs in Salesforce before importing related order line items. What is the recommended solution?
- A. Leverage Batch Apex to update order ID on related order lines after import.
- B. Leverage a sequence of numbers on the imported orders to import related order lines.
- C. Query only indexed ID field values on the imported order to import related order lines.
- D. Leverage an External ID from source system orders to import related order lines.
Answer: D
NEW QUESTION # 47
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:
- A. Clear the role field in the generic user record.
- B. Salesforce handles the assignment of orders automatically and there is no performance impact.
- C. Create a role at top of role hierarchy and assign the role to the generic user.
- D. Create a pool of generic users and distribute the assignment of memory to the pool of users.
Answer: A,C
NEW QUESTION # 48
Universal Containers (UC) has an open sharing model for its Salesforce users to allow all its Salesforce internal users to edit all contacts, regardless of who owns the contact. However, UC management wants to allow only the owner of a contact record to delete that contact. If a user does not own the contact, then the user should not be allowed to delete the record. How should the architect approach the project so that the requirements are met?
- A. Create a "before delete" trigger to check if the current user is not the owner.
- B. Create a validation rule on the Contact object to check if the current user is not the owner.
- C. Set the Sharing settings as Public Read Only for the Contact object.
- D. Set the profile of the users to remove delete permission from the Contact object.
Answer: A
NEW QUESTION # 49
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?
- A. Create a mashup page that will present the billing system records within Salesforce.
- B. Create a visual force tab with the billing system encapsulated within an iframe.
- C. Create a custom object and migrate the last 12 months of Invoice data into Salesforce so it can be displayed on the Account layout.
- D. Write an Apex callout and populate a related list to display on the account record.
Answer: A
NEW QUESTION # 50
Universal Containers (UC) wants to ensure their data on 100,000 Accounts pertaining mostly to US-based companies is enriched and cleansed on an ongoing basis. UC is looking for a solution that allows easy monitoring of key data quality metrics. What should be the recommended solution to meet this requirement?
- A. Implement an Apex Trigger on Account that queries a third-party data quality API to monitor Account data quality.
- B. Use a declarative approach by installing and configuring Data.com Clean to monitor Account data quality.
- C. Implement Batch Apex that calls out a third-party data quality API in order to monitor Account data quality.
- D. Use declarative approach by installing and configuring Data.com Prospector to monitor Account data quality.
Answer: B
NEW QUESTION # 51
UC is migrating data from legacy system to SF. UC would like to preserve the following information on records being migrated:
Date time stamps for created date and last modified date.
Ownership of records belonging to inactive users being migrated to Salesforce.
Which 2 solutions should a data architect recommends to preserve the date timestamps and ownership on records? Choose 2 answers.
- A. Log a case with SF to update these fields
- B. Enable Set Audit fields upon Record Creation Permission
- C. Enable update records with Inactive Owners Permission
- D. Enable modify all and view all permission.
Answer: B,C
NEW QUESTION # 52
A large Automobile company has implemented SF for its Sales Associates. Leads flow from its website to SF using a batch integration in SF. The Batch job connects the leads to Accounts in SF. Customer visiting their retail stores are also created in SF as Accounts.
The company has noticed a large number of duplicate accounts in SF. On analysis, it was found that certain customers could interact with its website and also visit the store. The Sales associates use Global Search to search for customers in Salesforce before they create the customers.
Which scalable option should a data Architect choose to implement to avoid duplicates?
- A. Implement a MDM solution to validate the customer information before creating Accounts in SF.
- B. Customize Account creation process to search if customer exists before creating an Account.
- C. Create duplicate rules in SF to validate duplicates during the account creation process
- D. Build Custom search based on fields on Accounts which can be matched with customer when they visit the store
Answer: C
NEW QUESTION # 53
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?
- A. Create a customer master database external to Salesforce as a system of truth and sync the customer data with all systems.
- B. Create a unique global customer ID for each customer and store that in all system for referential identity.
- C. Duplicate customer records across the system and provide a two-way sync of data between the systems.
- D. Use Salesforce CDC to sync customer data cross all systems to keep customer record in sync.
- E. Invest in data duplicate tool to de-dupe and merge duplicate records across all systems.
Answer: A,B,E
NEW QUESTION # 54
Which two best practices should be followed when using SOSL for searching?
- A. Keep searches specific and avoid wildcards where possible.
- B. Use SOSL option to ignore custom indexes as search fields are pre-indexed.
- C. Use searches against single Objects for greater speed and accuracy.
- D. Use Find in "ALL FIELDS" for faster searches.
Answer: A,D
NEW QUESTION # 55
US is implementing salesforce and will be using salesforce to track customer complaints, provide white papers on products and provide subscription (Fee) - based support.
Which license type will US users need to fulfil US's requirements?
- A. Lightning platform starter license.
- B. Sales cloud license
- C. Salesforce license.
- D. Service cloud license.
Answer: D
NEW QUESTION # 56
Universal Containers (UC) has a data model as shown in the image. The Project object has a private sharing model, and it has Roll -Up summary fields to calculate the number of resources assigned to the project, total hours for the project, and the number of work items associated to the project. What should the architect consider, knowing there will be a large amount of time entry records to be loaded regularly from an external system into Salesforce.com?
- A. Load all data using external IDs to link to parent records.
- B. Use triggers to calculate summary values instead of Roll -Up.
- C. Use workflow to calculate summary values instead of Roll -Up.
- D. Load all data after deferring sharing calculations.
Answer: D
NEW QUESTION # 57
Northern trail Outfitters (NTO) uses Sales Cloud and service Cloud to manage sales and support processes. Some of NTOs team are complaining they see new fields on their page unsure of which values need be input. NTO is concerned about lack of governance in making changes to Salesforce.
Which governance measure should a data architect recommend to solve this issue?
- A. Add description fields to explain why the field is used, and mark the field as required.
- B. Create reports to identify which users are leaving blank, and use external data sources o agreement the missing data.
- C. Create and manage a data dictionary and ups a governance process for changes made to common objects.
- D. Create validation rules with error messages to explain why the fields is used
Answer: C
NEW QUESTION # 58
Universal Containers (UC) is launching an RFP to acquire a new accounting product available on AppExchange. UC is expecting to issue 5 million invoices per year, with each invoice containing an average of 10 line items. What should UC's Data Architect recommend to ensure scalability?
- A. Ensure the accounting product runs 100% natively on the Salesforce platform.
- B. Ensure invoice line items simply reference existing Opportunity line items.
- C. Ensure the account product vendor includes Wave Analytics in their offering.
- D. Ensure the account product vendor provides a sound data archiving strategy.
Answer: D
NEW QUESTION # 59
UC is planning a massive SF implementation with large volumes of dat
a. As part of the org's implementation, several roles, territories, groups, and sharing rules have been configured. The data architect has been tasked with loading all of the required data, including user data, in a timely manner.
What should a data architect do to minimize data load times due to system calculations?
- A. Load the data through data loader, and turn on parallel processing.
- B. Leverage the Bulk API and concurrent processing with multiple batches
- C. Enable granular locking to avoid "UNABLE _TO_LOCK_ROW" error.
- D. Enable defer sharing calculations, and suspend sharing rule calculations
Answer: D
NEW QUESTION # 60
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?
- A. Review projected data storage needs.
- B. Schedule a weekly export file.
- C. Reduce data storage by purging old data.
- D. Implement an AppExchange package.
Answer: C
NEW QUESTION # 61
A company has 12 million records, and a nightly integration queries these records.
Which two areas should a Data Architect investigate during troubleshooting if queries are timing out? (Choose two.)
- A. Create a formula field instead of having multiple filter criteria.
- B. Make sure the query doesn't contain NULL in any filter criteria.
- C. Modify the integration users' profile to have View All Data.
- D. Create custom indexes on the fields used in the filter criteria.
Answer: B,D
NEW QUESTION # 62
A large automobile company has implemented Salesforce for its sales associates. Leads flow from its website to Salesforce using a batch integration in Salesforce. The batch job converts the leads to Accounts in Salesforce. Customers visiting their retail stores are also created in Salesforce as Accounts.
The company has noticed a large number of duplicate Accounts in Salesforce. On analysis, it was found that certain customers could interact with its website and also visit the store. The sales associates use Global Search to search for customers in Salesforce before they create the customers.
Which option should a data architect choose to implement to avoid duplicates?
- A. Build a custom search functionality that allows sales associates to search for customer in real time upon visiting their retail stores.
- B. leverage duplicate rules in Salesforce to validate duplicates during the account creation process.
- C. Implement an MDM solution to validate the customer information before creating Salesforce.
- D. Develop an Apex class that searches for duplicates and removes them nightly.
Answer: B
NEW QUESTION # 63
Universal Containers (UC) has several custom Visualforce applications have been developed in which users are able to edit Opportunity records. UC struggles with data completeness on their Opportunity records and has decided to make certain fields required that have not been in the past. The newly required fields are dependent on the Stage of the Opportunity, such that certain fields are only required once an Opportunity advances to later stages. There are two fields. What is the simplest approach to handle this new requirement?
- A. Use a validation rule for each field that takes the Stage into consideration.
- B. Update the Opportunity page layout to mark these fields as required.
- C. Write an Apex trigger that checks each field when records are saved.
- D. Update these Opportunity field definitions in Setup to be required.
Answer: A
NEW QUESTION # 64
NTO has multiple systems across its enterprise landscape including salesforce, with disparate version the customer records.
In salesforce, the customer is represented by the contact object.
NTO utilizes an MDM solution with these attributes:
1. The MDM solution keeps track of customer master with a master key.
2. The master key is a map to the record ID's from each external system that customer data is stored within.
3. The MDM solution provides de-duplication features, so it acts as the single source of truth.
How should a data architect implement the storage of master key within salesforce?
- A. Store the master key in Heroku postgres and use Heroku connect for synchronization.
- B. Create a custom object to store the master key with a lookup field to contact.
- C. Store the master key on the contact object as an external ID (Field for referential imports)
- D. Create an external object to store the master key with a lookup field to contact.
Answer: C
NEW QUESTION # 65
Every year, Ursa Major Solar has more than 1 million orders. Each order contains an average of 10 line items. The Chief Executive Officer (CEO) needs the Sales Reps to see how much money each customer generates year-over-year. However, data storage is running low in Salesforce.
Which approach for data archiving is appropriate for this scenario?
- A. 1. Annually delete orders and order line items. 2. Ensure the customer has order information in another system.
- B. 1. Annually aggregate order amount data to store in a custom object. 2. Delete those orders and order line items.
- C. 1. Annually export and delete order line items. 2. Store them in a zip file in case the data is needed later.
- D. 1. Annually export and delete orders and order line items. 2. Store them in a zip file in case the data is needed later.
Answer: B
NEW QUESTION # 66
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?
- A. Explore external data sources in Salesforce to build a 360 degree view of the customer.
- B. Migrate customer activities fro, all four system into Salesforce.
- C. Periodically upload summary information in Salesforce to build a 360 degree view.
- D. Use a customer data mart to create the 360 degree view of the customer.
Answer: A
NEW QUESTION # 67
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?
- A. Email address.
- B. Full name.
- C. Phone number.
- D. Global unique customer number.
Answer: D
NEW QUESTION # 68
......
Valid Data-Architect Exam Updates - 2023 Study Guide: https://pass4sures.freepdfdump.top/Data-Architect-valid-torrent.html
