Text Material Preview
Data Architect Salesforce Certified Data Architect exam dumps questions are the best material for you to test all the related Salesforce exam topics. By using the Data Architect exam dumps questions and practicing your skills, you can increase your confidence and chances of passing the Data Architect exam. Features of Dumpsinfo’s products Instant Download Free Update in 3 Months Money back guarantee PDF and Software 24/7 Customer Support Besides, Dumpsinfo also provides unlimited access. You can get all Dumpsinfo files at lowest price. Salesforce Certified Data Architect Data Architect exam free dumps questions are available below for you to study. Full version: Data Architect Exam Dumps Questions 1.An architect has been asked to provide errormessages when a future date is detected in a custom Birthdate _c field on the Contact object. The client wants the ability to translate the error messages. What are two approaches the architect should use to achieve this solution? Choose 2 answers A. Implement a third -party validation process with translate functionality. B. Create a trigger on Contact and add an error to the record with a custom label. C. Create a workflow field update to set the standard ErrorMessage field. D. Create a validation ruleand translate the error message with translation workbench. Answer: B,D 2.Universal Containers (UC) has implemented Salesforce, UC is running out of storage and needs to have an archiving solution, UC would like to maintaintwo years of data in Saleforce and archive older data out of Salesforce. 1 / 10 https://www.dumpsinfo.com/unlimited-access/ https://www.dumpsinfo.com/exam/data-architect Which solution should a data architect recommend as an archiving solution? A. Use a third-party backup solution to backup all data off platform. B. Build a batch join move all recordsoff platform, and delete all records from Salesforce. C. Build a batch join to move two-year-old records off platform, and delete records from Salesforce. D. Build a batch job to move all restore off platform, and delete old records from Salesforce. Answer: A 3.Universal Containers (UC) wants to store product data in Salesforce, but the standard Product object does not support the more complex hierarchical structure which is currently being used in the product master system. How can UC modify the standard Product object model to support a hierarchical data structure in order to synchronize product data from the source system to Salesforce? A. Create a custom lookup filed on the standard Product to reference the child record in the hierarchy. B. Create a custom lookup field on the standard Product to reference the parent record in the hierarchy. C. Create a custom master-detail field on the standard Product to reference the child record in the hierarchy. D. Create an Apex trigger to synchronize the Product Family standard picklist field on the Product object. Answer: B 4.Ursa Major Solar's legacy system has a quarterly accounts receivable report that compiles data from the following: - Accounts - Contacts - Opportunities - Orders - Order Line Items Which issue will an architect have when implementing this in Salesforce? A. Custom report types CANNOT contain Opportunity data. B. Salesforce does NOT support Orders or Order Line Items. C. Salesforce does NOT allow more than four objects in a single report type. D. A report CANNOT contain data from Accounts and Contacts. Answer: C 5.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? A. Create a custom object to store the data. B. Use a standard big objectdefined by salesforce. C. Use the standard “Order” object to store the data. D. Implement a custom big object to store the data. Answer: D 6.CloudKicks is launching a Partner Community, which will allow users to register shipment requests that are then processed by Cloud Kicks employees. Shipment requests contain header information, and then a list of no more than 5 items being shipped. First, Cloud Kicks will introduce its community to 6,000 customers in North America, and then to 2 / 10 https://www.dumpsinfo.com/ 24,000 customers worldwide within the next two years. Cloud Kicks expects 12 shipment requests per week per customer, on average, and wants customers to be able to view up to three years of shipment requests and use Salesforce reports. What is the recommended solution for the Cloud Kicks Data Architect to address the requirements? A. Create an external custom object to track shipment requests and a child external objectto track shipment items. External objects are stored off-platform in Heroku’s Postgres database. B. Create an external custom object to track shipment requests with five lookup custom fields for each item being shipped. External objects are stored off-platform in Heroku’s Postgres database. C. Create a custom object to track shipment requests and a child custom object to track shipment items. Implement an archiving process that moves data off-platform after three years. D. Create a custom object to track shipment requests with five lookup custom fields for each item being shipped Implement an archiving process that moves data off-platform after three years. Answer: C 7.Universal Containers (UC) is going thought major reorganization of their sales team. This would require changes to a large a number of group members and sharing rules. UCs administrator is concerned about long processing time and failure during the process. What should a Data architect implement to make changes efficiently? A. Log a case with salesforce to make sharing rule changes. B. Enable Defer Sharing Calculation prior to making sharing rule changes. C. Delete old sharing rules and build new sharing rules D. Log out all users and make changes to sharing rules. Answer: B 8.Universal Containers wants to implement a data -quality process to monitor the data that users are manually entering into the system through the Salesforce UI. Which approach should the architect recommend? A. Allow users to import their data using the Salesforce Import tools. B. Utilize a 3rd -party solution from the AppExchange for data uploads. C. Utilize an app from the AppExchange to create data -quality dashboards. D. Use Apex to validate the format of phone numbers and postal codes. Answer: C 9.UC is using SF CRM. UC sales managers are complaining about data quality and would like to monitor and measure data quality. Which 2 solutions should a data architect recommend to monitor and measure data quality? Choose 2 answers. A. Use custom objects and fieldsto identify issues. B. Review data quality reports and dashboards. C. Install and run data quality analysis dashboard app D. Export data and check for data completeness outside of Salesforce. Answer: B,C 10.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. 3 / 10 https://www.dumpsinfo.com/ Which two approaches will accomplish this goal? (Choose two.) A. Create the users, upload all data, and then deploy the sharing rules. B. Contact Salesforce to activate indexing before uploading the data. C. First, load all account records, and then load all user records. D. Defer sharing calculations until the data has finished uploading. Answer: A,D 11.Universal Containers has received complaints that customers are being calledby multiple Sales Reps where the second Sales Rep that calls is unaware of the previous call by their coworker. What is a data quality problem that could cause this? A. Missing phone number on the Contact record. B. Customer phone number has changed on the Contact record. C. Duplicate Contact records exist in the system. D. Duplicate Activity records on a Contact. Answer: C 12.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: 13. Delete those orders and order line items. C. 1. Annually export and delete orders and order line items. 14. Sales Orders are maintained in the on-premises enterprise resource planning (ERP). 15.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 3answers. A. Leverage Heroku Connect and Heroku Postgres to bidirectionally sync Opportunities. B. Install a 3rd party AppExchange tool to handle the data sharing C. Develop an Apex class that pushes opportunity data between orgs daily via the Apex schedule. D. Leverage middleware tools to bidirectionally send Opportunity data across orgs. E. Use Salesforce Connect and the cross-org adapter to visualize Opportunities into external objects Answer: C,D,E 16.Universal Container is Implementing salesforce andneeds 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? A. Define external IDs for an object, migrate second database to first database, and load into Salesforce. B. Define duplicate rules in Salesforce, and load data into Salesforce from both databases. C. Set up staging data base, and define external IDs to merge, clean duplicate data, and load into Salesforce. D. Define external IDs for an object, Insert data from one database, and use upsert for a second database Answer: D 4 / 10 https://www.dumpsinfo.com/ 17.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 A. 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. B. Write an Apex trigger on Contact after insert event and after update events and store the old values in another custom object. C. Turn on field Contact object history tracking for these ten fields, then create reports on contact history. D. Create a Contact report including these ten fields and Salesforce Id, then schedule the report to run once a day and sendemail to the admin. Answer: B,C 18.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? A. Use the Account object with Person Accounts and a new B2C page layout. B. Use the Account object with a newly created Record Type for B2C customers. C. Create a new picklist value for B2C customers on the Account Type field. D. Use 50 umbrella Accounts for each region, with customers asassociated Contacts. Answer: A 19.Universal Containers would like to have a Service-Level Agreement (SLA) of 1 day for any data loss due to unintentional or malicious updates of records in Salesforce. What approach should be suggested to address this requirement? A. Build a daily extract job and extract data to on-premise systems for long-term backup and archival purposes. B. Schedule a Weekly Extract Service for key objects and extract data in XL sheets to on-premise systems. C. Store all data in shadow custom objects on any updates and deletes, and extract them as needed . D. Evaluate a third-party AppExchange app, such as OwnBackup or Spanning, etc., for backup and archival purposes. Answer: D 20.DreamHouse Realty has a legacy system that captures Branch Offices and Transactions. DreamHouse Realty has 15 Branch Offices. Transactions can relate to anyBranch Office. DreamHouse Realty has created hundreds of thousands of Transactions per year. A Data Architect needs to denormalize this data model into a single Transaction object with a Branch Office picklist. What are two important considerations for the Data Architect in this scenario? (Choose two.) A. Standard list view in-line editing. B. Limitations on Org data storage. 5 / 10 https://www.dumpsinfo.com/ C. Bulk API limitations on picklist fields. D. Limitations on master-detail relationships. Answer: B,C 21.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 data. 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. Create a external id fieldfor each object in the target org and map source record ID’s to this field. C. Redefine the master detail relationship fields to lookup relationship fields in the target org. D. Replace source record ID’s with new record ID’s from the target org in the import file. E. Keep the relationship fields populated with the source record ID’s in the import file. Answer: A,B,D 22.DreamHouse Realty has a Salesforce org that is used to manage Contacts. What are two things an Architect should consider using to maintain data quality in this situation? (Choose two.) A. Use the private sharing model. B. Use Salesforce duplicate management. C. Use validation rules on new record create and edit. D. Use workflow to delete duplicate records. Answer: B,C 23.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 fulfillthis goal? (Choose two.) A. Third-party Integration Tool (ETL) B. Schedulable Batch Apex C. Third-party Business Intelligence system D. Apex Triggers Answer: A,B 24.Universal Container has a Sales Cloud implementation for a sales team and an enterprise resource planning (ERP) as a customer master Sales team are complaining about duplicate account and data quality issues with account data. Which two solution should a data architect recommend to resolve the complaints? A. Build a nightly batch job to de-dupe data, and merge account records. B. Integrate Salesforce with ERP, and make ERP as system of truth. C. Build a nightly sync job fromERP to Salesforce. D. Implement a de-dupe solution and establish account ownership in Salesforce Answer: B,D 25.Universal Containers hasa public website with several forms that create Lead records in 6 / 10 https://www.dumpsinfo.com/ Salesforce using the REST API. When designing these forms, which two techniques will help maintain a high level of data quality? A. Do client-side validation of phone number and email field formats. B. Prefer picklist form fields over free text fields, where possible. C. Ensure the website visitor is browsing using an HTTPS connection. D. Use cookies totrack when visitors submit multiple forms. Answer: A,B 26. Point of sales system: All purchases for a customer. 27.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 storedin 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? A. Master-detail relationship filed on Account, related to Inventory_c B. Master-detail relationship filed on Inventory_c, related to Account C. Indirect lookup relationship field on Account, related to Inventory_c D. Lookup relationship fields on Inventory related to Account Answer: A 28. Custom billing solution 29.Northern Trail Outfitter has implemented Salesforce for its associates nationwide, Senior managementis concerned that the executive dashboard are not reliable for their real-time decision- making. On analysis, the team the following issues with data entered in Salesforce. Information in certain records is incomplete. Incorrect entry in certain fields causes records to be excluded in report fitters. Duplicate entries cause incorrect counts. Which three steps should a data architect recommend to address the issues? A. Periodically export data to cleanse data and import them back into Salesforce for executive reports. B. Build a sales data warehouse with purpose-build data marts for dashboards and senior management reporting. C. Explore third-party data providers to enrich and augment information entered in salesforce. D. Leverage Salesforce features, suchas validate rules, to avoid incomplete and incorrect records. E. design and implement data-quality dashboard to monitor and act on records that are incomplete or incorrect Answer: B,C,D 30.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? A. Create indexes on Opportunity object text fields. B. Group batches by the AccountId field. C. Sortbatches by Name field values. 7 / 10 https://www.dumpsinfo.com/ D. Order batches by Auto -number field. Answer: D 31.Universal Containers has a legacy system that captures Conferences and Venues. These Conferences can occur at any Venue. They create hundreds of thousands of Conferences per year. Historically, they have only used 20 Venues. Which two things should the data architect consider when denormalizing this data model into a single Conference object with a Venue picklist? Choose 2 answers A. Limitations on master -detail relationships. B. Org data storage limitations. C. Bulk API limitations on picklist fields. D. Standard list view in-line editing. Answer: C,D 32.Universal Containers (UC) has a Salesforce org with multiple automated processes defined for group membership processing, UC also has multiple admins on staff that perform manual adjustments to the role hierarchy. The automated tasks and manual tasks overlap daily, and UC is experiencing "lock errors" consistently. What should a data architect recommend to mitigate these errors? A. Enable granular locking. B. Remove SOQL statements from Apex Loops. C. Enable sharing recalculations. D. Ask Salesforce supportfor additional CPU power. Answer: B 33. NTO has a product pricing system (PPS) that is used to update the Opportunity Amount field on opportunities on a daily basis. 34.Universal Containers (UC) owns a complex Salesforce org with many Apex classes, triggers, and automated processes that will modify records if available. UC has identified that, in its current development state, UC runs change of encountering race condition on the same record. What should a data architect recommend to guarantee that records are not being updated at the same time? A. Embed the keywords FOR UPDATE after SOQL statements. B. Disable classes or triggers that have the potential to obtain the same record. C. Migrate programmatic logic to processes and flows. D. Refactor or optimize classes and trigger for maximum CPU performance. Answer: A 35. External resellers are able to authenticate to the portal with a login. 36.Universal Containers (CU) is in the process of implementing an enterprise data warehouse (EDW). UC needs to extract 100 million records from Salesforce for migration to the EDW. What data extraction strategy should a data architect use for maximum performance? A. Install a third-party AppExchange tool. B. Call the REST API in successive queries. C. Utilize PK Chunking with the Bulk API. D. Use the Bulk API in parallel mode. 8 / 10 https://www.dumpsinfo.com/ Answer: C 37.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 unique global customer ID for each customer and store that in all system for referential identity. B. Use Salesforce CDCto sync customer data cross all systems to keep customer record in sync. C. Invest in data duplicate tool to de-dupe and merge duplicate records across all systems. D. Duplicate customer records across the system and provide a two-way sync of data between the systems. E. Create a customer master database external to Salesforce as a system of truth and sync the customer data with all systems. Answer: A,C,E 38. Lead data, opportunity data and order data are available to authenticated users. 39.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? A. validation Rule B. required Fields C. Apex Class D. Process Builder Answer: A 40.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? A. Use a 3rd-party data source to update contact information in salesforce. B. Email all customer andasked them to verify their information and to call NTO if their address is incorrect. C. Delete contacts when the mail is returned to save postal cost to NTO. D. Have the sales team to call all existing customers and ask to verify the contact details. Answer: A 41. 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? A. Customer community. B. Lightning external apps starter. C. Customer community plus. 9 /10 https://www.dumpsinfo.com/ D. Partner community. Answer: D 42.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? A. Use AppExchange package for backup and restore. B. Use ETL for backup and restore from EDW. C. Use Bulk API to extract data on daily basis to EDW and REST API for restore. D. Change weekly backup process to daily backup, and implement a custom restore solution. Answer: A 10 / 10 https://www.dumpsinfo.com/
