Data-Architect exam questions for practice in 2023 Updated 224 Questions
Updated Jul-2023 Premium Data-Architect Exam Engine pdf - Download Free Updated 224 Questions
Salesforce Certified Data Architect is an advanced-level certification that validates a professional's knowledge and skills in designing and implementing data architecture solutions in the Salesforce platform. The certification is intended for individuals who have extensive experience in data modeling, database design, data integration, and data governance. It also requires a deep understanding of the Salesforce data architecture, including the platform's data model, data storage options, data security, and data management features.
NEW QUESTION # 74
UC is having issues using Informatica Cloud Louder to export +10MOrder records. Each Order record has 10 Order Line Items. What two steps can you take to help correct this? Choose two answers.
- A. Export in multiple batches
- B. Use PK Chunking
- C. Export Bulk API in parallel mode
- D. Limit Batch to 10K records
Answer: A,B
NEW QUESTION # 75
Cloud Kicks 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 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 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.
- B. Create an external custom object to track shipment requests and a child external object to track shipment items. External objects are stored off-platform in Heroku's Postgres database.
- C. 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.
- D. 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.
Answer: D
NEW QUESTION # 76
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.
- A. Integrate legacy CRM to salesforce and keep data in synch till new functionality is in place
- B. Integrate SAP with Salesforce, SAP to legacy CRM but not legacy CRM to Salesforce
- C. Suggest MDM solution and link MDM to salesforce and SAP
- D. Do not integrate legacy CRM to Salesforce, but integrate salesforce to SAP
Answer: B,C
NEW QUESTION # 77
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. Create a new picklist value for B2C customers on the Account Type field.
- B. Use the Account object with Person Accounts and a new B2C page layout.
- C. Use 50 umbrella Accounts for each region, with customers as associated Contacts.
- D. Use the Account object with a newly created Record Type for B2C customers.
Answer: B
NEW QUESTION # 78
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 custom indexes on the fields used in the 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 a formula field instead of having multiple filter criteria.
Answer: A,B
NEW QUESTION # 79
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. Migrate programmatic logic to processes and flows.
- B. Embed the keywords FOR UPDATE after SOQL statements.
- C. Refactor or optimize classes and trigger for maximum CPU performance.
- D. Disable classes or triggers that have the potential to obtain the same record.
Answer: B
NEW QUESTION # 80
Universal Containers has successfully migrated 50 million records into five different objects multiple times in a full copy sandbox. The Integration Engineer wants to re-run the test again a month before it goes live into Production. What is the recommended approach to re-run the test?
- A. Truncate all 5 objects quickly and re-run the data migration test.
- B. Truncate all 5 objects and hard delete before running the migration test.
- C. Hard delete all 5 objects' data and re-run the data migration test.
- D. Refresh the full copy sandbox and re-run the data migration test.
Answer: D
NEW QUESTION # 81
As part of a phased Salesforce rollout. there will be 3 deployments spread out over the year. The requirements have been carefully documented. Which two methods should an architect use to trace back configuration changes to the detailed requirements? Choose 2 answers
- A. Review the setup audit trail for configuration changes.
- B. Use the Force.com IDE to save the metadata files in source control.
- C. Maintain a data dictionary with the justification for each field.
- D. Put the business purpose in the Description of each field.
Answer: C,D
NEW QUESTION # 82
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. Change weekly backup process to daily backup, and implement a custom restore solution.
- B. Use Bulk API to extract data on daily basis to EDW and REST API for restore.
- C. Use ETL for backup and restore from EDW.
- D. Use AppExchange package for backup and restore.
Answer: D
NEW QUESTION # 83
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. Utilize PK Chunking with the Bulk API.
- C. Call the REST API in successive queries.
- D. Use the Bulk API in parallel mode.
Answer: B
NEW QUESTION # 84
What is an advantage of using Custom metadata type over Custom setting?
- A. Custom metadata records are deployable using packages.
- B. Custom metadata types are available for reporting.
- C. Custom metadata records are not copied from production to sandbox.
- D. Custom metadata records are editable in Apex.
Answer: A
NEW QUESTION # 85
Universal Containers has received complaints that customers are being called by 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. Duplicate Contact records exist in the system.
- C. Customer phone number has changed on the Contact record.
- D. Duplicate Activity records on a Contact.
Answer: B
NEW QUESTION # 86
During the implementation of Salesforce, a customer has the following requirements for Sales Orders:
1. Sales Order information needs to be shown to users in Salesforce.
2. Sales Orders are maintained in the on-premises enterprise resource planning (ERP).
3. Sales Order information has more than 150 million records.
4. Sales Orders will not be updated in Salesforce.
What should a data architect recommend for maintaining Sales Orders in salesforce?
- A. Use external objects to maintain Sales Order in Salesforce.
- B. Use custom big objects to maintain Sales Orders in Salesforce.
- C. Use Standard order object to maintain Sale Orders in Salesforce
- D. Us custom objects to maintain Sales Orders in Salesforce.
Answer: A
NEW QUESTION # 87
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 Big Object In setup select new to create big object.
- B. Go to Object manager In setup and select new to create big object.
- C. Use Metadata API to create big object.
- D. Use DX to create big object.
Answer: A,C
NEW QUESTION # 88
DreamHouse Realty 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.
There will be a large amount of time entry records to be loaded regularly from an external system into Salesforce.
What should the Architect consider in this situation?
- A. Load all data using external IDs to link to parent records.
- B. Calculate summary values instead of Roll-Up by using workflow.
- C. Load all data after deferring sharing calculations.
- D. Calculate summary values instead of Roll-Up by using triggers.
Answer: C
NEW QUESTION # 89
Universal Containers is experiencing frequent and persistent group membership locking issues that severely restricts its ability to manage manual and a automated updates at the same time.
What should a data architect do in order to restore the issue?
- A. Enable granular locking
- B. Enable parallel sharing rule calculation.
- C. Enable defer sharing calculation
- D. Enable implicit sharing
Answer: A
NEW QUESTION # 90
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.
- A. Leverage Heroku Connect and Heroku Postgres to bidirectionally sync Opportunities.
- B. Leverage middleware tools to bidirectionally send Opportunity data across orgs.
- C. Use Salesforce Connect and the cross-org adapter to visualize Opportunities into external objects
- D. Install a 3rd party AppExchange tool to handle the data sharing
- E. Develop an Apex class that pushes opportunity data between orgs daily via the Apex schedule.
Answer: B,C,E
NEW QUESTION # 91
......
To earn the Salesforce Certified Data Architect certification, candidates must pass the certification exam and demonstrate their knowledge and skills in designing and implementing data solutions in the Salesforce platform. This certification program is ideal for professionals who are looking to take their careers to the next level and showcase their expertise in data architecture and management. The Salesforce Certified Data Architect certification is a valuable asset for professionals in the field and is recognized globally.
Authentic Data-Architect Dumps With 100% Passing Rate Practice Tests Dumps: https://www.2pass4sure.com/Salesforce-Application-Architect/Data-Architect-actual-exam-braindumps.html
Salesforce Data-Architect Real Exam Questions Guaranteed Updated Dump from 2Pass4sure: https://drive.google.com/open?id=1E-XH8vf9N2N9OdQaSSn8jpT7bS1vFp15