Nov-2022 Data-Architect Study Material, Preparation Guide and PDF Download
Free Data-Architect Certification Sample Questions with Online Practice Test
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 an External ID from source system orders to import related order lines.
- B. Query only indexed ID field values on the imported order to import related order lines.
- C. Leverage Batch Apex to update order ID on related order lines after import.
- D. Leverage a sequence of numbers on the imported orders to import related order lines.
Answer: A
NEW QUESTION 47
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?
- A. Let a "system user" own all the Account records and make this user part of the highest-level role in the Role Hierarchy.
- B. Let a "system user" own the Account records and assign this user to the lowest-level role in the Role Hierarchy.
- C. Let a "system user" own all the Account records without assigning any role to this user in Role Hierarchy.
- D. Let the VP of the Sales department, who will report directly to the senior VP, own all the Account records.
Answer: B,C
NEW QUESTION 48
UC needs to load a large volume of leads into salesforce on a weekly basis. During this process the validation rules are disabled.
What should a data architect recommend to ensure data quality is maintained in salesforce.
- A. Ensure the lead data is preprocessed for quality before loading into salesforce.
- B. Activate validation rules once the leads are loaded into salesforce to maintain quality.
- C. Allow validation rules to be activated during the load of leads into salesforce.
- D. Develop custom APEX batch process to improve quality once the load is completed.
Answer: D
NEW QUESTION 49
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. Replace source record ID's with new record ID's from the target org in the import file.
- B. Create a external id field for each object in the target org and map source record ID's to this field.
- C. Keep the relationship fields populated with the source record ID's in the import file.
- D. Redefine the master detail relationship fields to lookup relationship fields in the target org.
- E. Use data loader to export the data from source org and then import or Upsert into the target org in sequential order.
Answer: A,B,E
NEW QUESTION 50
Universal Containers is looking to use Salesforce to manage their sales organization. They will be migrating legacy account data from two aging systems into Salesforce. Which two design considerations should an architect take to minimize data duplication? Choose 2 answers
- A. Use Salesforce matching and duplicate rules.
- B. Import the data concurrently.
- C. Use a workflow to check and prevent duplicates.
- D. Clean data before importing to Salesforce.
Answer: A,D
NEW QUESTION 51
Universal Containers (UC) is implementing a Salesforce project with large volumes of data and daily transactions. The solution includes both real-time web service integrations and Visualforce mash -ups with back -end systems. The Salesforce Full sandbox used by the project integrates with full-scale back -end testing systems. What two types of performance testing are appropriate for this project?
Choose 2 answers
- A. Stress testing against the web services hosted by the integration middleware.
- B. Pre -go -live unit testing in the Salesforce Full sandbox.
- C. Pre -go -live automated page -load testing against the Salesforce Full sandbox.
- D. Post go -live automated page -load testing against the Salesforce Production org.
Answer: A,C
NEW QUESTION 52
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. Salesforce license.
- B. Sales cloud license
- C. Service cloud license.
- D. Lightning platform starter license.
Answer: C
NEW QUESTION 53
Universal Containers is integrating a new Opportunity engagement system with Salesforce. According to their Master Data Management strategy, Salesforce is the system of record for Account, Contact, and Opportunity dat a. However, there does seem to be valuable Opportunity data in the new system that potentially conflicts with what is stored in Salesforce. What is the recommended course of action to appropriately integrate this new system?
- A. A policy should be adopted so that the system whose record was most recently updated should prevail in conflicts.
- B. Stakeholders should be brought together to discuss the appropriate data strategy moving forward.
- C. The MDM strategy defines Salesforce as the system of record, so Salesforce Opportunity values prevail in all conflicts.
- D. The Opportunity engagement system should become the system of record for Opportunity records.
Answer: B
NEW QUESTION 54
Universal Containers has a requirement to store more than 100 million records in salesforce and needs to create a custom big object to support this business requirement.
Which two tools should a data architect use to build custom object?
- A. Go to Object manager In setup and select new to create big object.
- B. Use DX to create big object.
- C. Use Metadata API to create big object.
- D. Go to Big Object In setup select new to create big object.
Answer: C,D
NEW QUESTION 55
A large multinational B2C Salesforce customer is looking to implement their distributor management application is Salesforce. the application has the following capabilities:
1.Distributor create sales order in salesforce
2.Sales order are based on product prices applicable to their region
3. Sales order are closed once they are fulfilled
4. It is decided to maintain the order in opportunity object
How should the data architect model this requirement?
- A. Create lookup to Custom Price object and share with distributors.
- B. Manually update Opportunities with Prices application to distributors.
- C. Configure price Books for each region and share with distributors.
- D. Add custom fields in Opportunity and use triggers to update prices.
Answer: C
NEW QUESTION 56
Get Cloudy Consulting monitors 15,000 servers, and these servers automatically record their status every 10 minutes. Because of company policy, these status reports must be maintained for 5 years. Managers at Get Cloudy Consulting need access to up to one week's worth of these status reports with all of their details.
An Architect is recommending what data should be integrated into Salesforce and for how long it should be stored in Salesforce.
Which two limits should the Architect be aware of? (Choose two.)
- A. Webservice callout limits
- B. Workflow rule limits
- C. Data storage limits
- D. API Request limits
Answer: C,D
NEW QUESTION 57
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. Leverage the Bulk API and concurrent processing with multiple batches
- B. Enable defer sharing calculations, and suspend sharing rule calculations
- C. Load the data through data loader, and turn on parallel processing.
- D. Enable granular locking to avoid "UNABLE _TO_LOCK_ROW" error.
Answer: B
NEW QUESTION 58
Universal Containers has 30 million case records. The Case object has 80 fields. Agents are reporting performance issues and time-outs while running case reports in the Salesforce org.
Which solution should a data architect recommend to improve reporting performance?
- A. Create a custom object to store aggregate data and run reports.
- B. Build reports using custom Lightning components.
- C. Move data off of the platform and run reporting outside Salesforce, and give access to reports.
- D. Contact Salesforce support to enable skinny table for cases.
Answer: A
NEW QUESTION 59
UC has migrated its Back-office data into an on-premise database with REST API access. UC recently implemented Sales cloud for its sales organization. But users are complaining about a lack of order data inside SF.
UC is concerned about SF storage limits but would still like Sales cloud to have access to the data.
Which design patterns should a data architect select to satisfy the requirement?
- A. Migrate and persist the data in SF to take advantage of native functionality.
- B. Build a UI for the on-premise system and iframe it in Salesforce
- C. Develop a bidirectional integration between the on-premise system and Salesforce.
- D. Use SF Connect to virtualize the data in SF and avoid storage limits.
Answer: D
NEW QUESTION 60
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. Write an Apex trigger on Contact after insert event and after update events and store the old values in another custom object.
- B. 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.
- 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 send email to the admin.
Answer: A,C
NEW QUESTION 61
A Salesforce customer has plenty of data storage. Sales Reps are complaining that searches are bringing back old records that aren't relevant any longer. Sales Managers need the data for their historical reporting.What strategy should a data architect use to ensure a better user experience for the Sales Reps?
- A. Create a Permission Set to hide old data from Sales Reps.
- B. Set data access to Private to hide old data from Sales Reps.
- C. Use Batch Apex to archive old data on a rolling nightly basis.
- D. Archive and purge old data from Salesforce on a monthly basis.
Answer: D
NEW QUESTION 62
Universal Containers (UC) has implemented Salesforce, UC is running out of storage and needs to have an archiving solution, UC would like to maintain two years of data in Saleforce and archive older data out of Salesforce.
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 to move two-year-old records off platform, and delete records from Salesforce.
- C. Build a batch join move all records off platform, and delete all records from Salesforce.
- D. Build a batch job to move all restore off platform, and delete old records from Salesforce.
Answer: A
NEW QUESTION 63
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.)
- A. Performing large loads and deletions.
- B. Using trailing % wildcards.
- C. Using leading % wildcards.
- D. Using a custom index on a deterministic formula field.
- E. Using NOT and != operators.
Answer: C,D,E
NEW QUESTION 64
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?
- A. Load all records via the Upsert operation to determine new records vs. existing records.
- B. Delete all existing records, and then load all records together via the Insert operation.
- C. Load new records via the Insert operation and existing records via the Update operation.
- D. Load Contact records together using the Streaming API via the Upsert operation.
Answer: C
NEW QUESTION 65
Two million Opportunities need to be loaded in different batches into Salesforce using the Bulk API in parallel mode.
What should an Architect consider when loading the Opportunity records?
- A. Create indexes on Opportunity object text fields.
- B. Use the Name field values to sort batches.
- C. Group batches by the AccountId field.
- D. Order batches by Auto-number field.
Answer: C
NEW QUESTION 66
Universal Containers (UC) is implementing Salesforce and will be using Salesforce to track customer complaints, provide white papers on products, and provide subscription based support.
Which license type will UC users need to fulfill UC's requirements?
- A. Salesforce License
- B. Sales Cloud License
- C. Service Cloud License
- D. Lightning Platform Starter License
Answer: C
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. Global unique customer number.
- B. Phone number.
- C. Full name.
- D. Email address.
Answer: A
NEW QUESTION 68
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. Bulk API limitations on picklist fields.
- B. Standard list view in -line editing.
- C. Org data storage limitations.
- D. Limitations on master -detail relationships.
Answer: A,B
NEW QUESTION 69
......
Salesforce Data-Architect Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
Data-Architect Certification Study Guide Pass Data-Architect Fast: https://braindumps.exam4docs.com/Data-Architect-study-questions.html
