Data-Architect Self-Study Guide for Becoming an Salesforce Certified Data Architect Expert
Data-Architect Study Guide Realistic Verified Data-Architect Dumps
NEW QUESTION # 90
Universal Containers (UC) has implemented a master data management strategy, which uses a central system of truth, to ensure the entire company has the same customer information in all systems. UC customer data changes need to be accurate at all times in all of the systems. Salesforce is the identified system of record for this information.
What is the correct solution for ensuring all systems using customer data are kept up to date?
- A. Send customer record changes from Salesforce to the system of truth in real time.
- B. Send customer data nightly to the system of truth in a scheduled batch job.
- C. Send customer record changes from Salesforce to each system in a nightly batch job.
- D. Have each system pull the record changes from Salesforce using change data capture.
Answer: A
Explanation:
Having each system pull the record changes from Salesforce using change data capture (option D) is the correct solution for ensuring all systems using customer data are kept up to date, as it allows the systems to subscribe to real-time events from Salesforce and receive notifications when customer records are created, updated, deleted, or undeleted. Sending customer data nightly to the system of truth in a scheduled batch job (option A) or sending customer record changes from Salesforce to each system in a nightly batch job (option B) are not good solutions, as they may cause data latency and inconsistency, and they do not provide real-time updates. Sending customer record changes from Salesforce to the system of truth in real time (option C) is also not a good solution, as it does not address how the other systems will receive the updates from the system of truth.
NEW QUESTION # 91
UC has a roll-up summary field on Account to calculate the count of contacts associated with an account.
During the account load, SF is throwing an "Unable to lock a row" error.
Which solution should a data architect recommend, to resolve the error?
- A. Perform Batch job in serial mode and reduce batch size
- B. Defer roll-up summary fields calculation during data migration.
- C. Perform Batch job in parallel mode and reduce Batch size
- D. Leverage data loader platform API to load data.
Answer: A
Explanation:
The best solution to resolve the error of "Unable to lock a row" during the account load is to perform batch job in serial mode and reduce batch size. This is because roll-up summary fields are calculated synchronously when the parent record is updated, and asynchronously when the child record is updated. Therefore, updating many child records at once can cause locking issues on the parent record. To avoid this, it is recommended to use serial mode and smaller batch sizes when loading data using tools like Data Loader or Bulk API12.
Leverage data loader platform API to load data is not a good option because it does not specify the mode or batch size. Perform batch job in parallel mode and reduce batch size is not a good option because parallel mode can still cause locking issues even with smaller batches. Defer roll-up summary fields calculation during data migration is not a good option because it is not possible to defer or disable roll-up summary fields calculation
NEW QUESTION # 92
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. Email address.
- C. Phone number.
- D. Full name.
Answer: A
NEW QUESTION # 93
UC has a classic encryption for Custom fields and is leveraging weekly data reports for data backups. During the data validation of exported data UC discovered that encrypted field values are still being exported as part of data exported. What should a data architect recommend to make sure decrypted values are exported during data export?
- A. Set a standard profile for Data Migration user, and assign view encrypted data
- B. Leverage Apex class to decrypt data before exporting it.
- C. Set up a custom profile for data migration user and assign view encrypted data.
- D. Create another field to copy data from encrypted field and use this field in export
Answer: D
Explanation:
The best solution to make sure decrypted values are exported during data export is to create another field to copy data from encrypted field and use this field in export. This is because classic encryption does not support exporting decrypted values of encrypted fields. The view encrypted data permission only allows users to view decrypted values in the user interface, but not in reports or data exports. Therefore, a workaround is to create a formula field or a workflow field update that copies the value of the encrypted field to another field, and use that field for data export. However, this solution has some drawbacks, such as exposing sensitive data in plain text and consuming extra storage space. A better solution would be to use Shield Platform Encryption, which supports exporting decrypted values of encrypted fields with the Export Encrypted Data permission
NEW QUESTION # 94
Universal Containers (UC) is implementing its new Internet of Things technology, which consists of smart containers that provide information on container temperature and humidity updated every 10 minutes back to UC. There are roughly 10,000 containers equipped with this technology with the number expected to increase to 50,000 across the next five years. It is essential that Salesforce user have access to current and historical temperature and humidity data for each container. What is the recommended solution?
- A. Create a new Lightning Component that displays last humidity and temperature data for a specific container and can also display historical trends obtaining relevant data from UC's existing data warehouse.
- B. Create a new Container Reading custom object, which is created when a new measure is received for a specific container. The Container Reading custom object has a master-detail relationship to the container object.
- C. Create new custom fields for temperature and humidity in the existing Container custom object, as well as an external ID field that is unique for each container. These custom fields are updated when a new measure is received.
- D. Create a new Container Reading custom object with a master-detail relationship to Container which is created when a new measure is received for a specific container. Implement an archiving process that runs every hour.
Answer: D
NEW QUESTION # 95
UC is planning a massive SF implementation with large volumes of data. 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. Enable granular locking to avoid "UNABLE _TO_LOCK_ROW" error.
- B. Enable defer sharing calculations, and suspend sharing rule calculations
- C. Leverage the Bulk API and concurrent processing with multiple batches
- D. Load the data through data loader, and turn on parallel processing.
Answer: B
Explanation:
The correct answer is A, enable defer sharing calculations, and suspend sharing rule calculations. Defer sharing calculations and suspend sharing rule calculations are features that allow you to temporarily disable the automatic recalculation of sharing rules when you load large volumes of data. This can improve the performance and speed of your data load process by avoiding unnecessary system calculations. Loading the data through data loader, leveraging the bulk API, or enabling granular locking are also options that can help with data load times, but they do not directly address the system calculations issue.
NEW QUESTION # 96
Universal Containers (UC) has three systems: Salesforce, a cloud -based ERP system, and an on -premise Order Management System (OMS). An architect has been tasked with creating a solution that uses Salesforce as the system of record for Leads and the OMS as the system of record for Account and Contacts. UC wants Accounts and Contacts to be able to maintain their names in each system (i.e., "John Doe" in the OMS and
"Johnny Doe" in Salesforce), but wants to have a consolidated data store which links referenced records across the systems. What approach should an architect suggest so the requirements are met?
- A. Implement an integration tool to send OMS Accounts and Contacts to Salesforce.
- B. Implement a Master Data Management strategy to reconcile Leads, Accounts, and Contacts.
- C. Have Salesforce poll the OMS nightly and bring in the desired Accounts and Contacts.
- D. Use the Streaming API to send Account and Contact data from Salesforce to the OMS.
Answer: B
Explanation:
Implementing a Master Data Management strategy to reconcile Leads, Accounts, and Contacts is the approach that the architect should suggest so that the requirements are met for UC. A Master Data Management strategy can provide a consistent and unified view of data across multiple systems, by defining and enforcing rules for data quality, governance, and integration. A Master Data Management strategy can also handle complex scenarios where different systems have different systems of record for different entities or fields, and where data can be modified in different systems with different values. A Master Data Management strategy can also provide a consolidated data store that links referenced records across systems and enables cross-system reporting and analysis. The other options are not suitable or sufficient for meeting the requirements, as they would either not provide a consolidated data store, not handle different systems of record, or not allow data modification in different system
NEW QUESTION # 97
Northern Trail Outfitters (NTO) has an external product master system that syncs product and pricing information with Salesforce. Users have been complaining that they are seeing discrepancies in product and pricing information displayed on the NTO website and Salesforce.
As a data architect, which action is recommended to avoid data sync issues?
- A. Build a custom integration for one-way sync of product and pricing information from product master to Salesforce.
- B. Build a custom integration for two-way sync of product and pricing information between product master to Salesforce.
- C. Use the Customer 360 data manager to sync product and pricing information from product master database to Salesforce.
- D. Implement a manual process to update the products from an extract from the products master on a weekly basis.
Answer: C
NEW QUESTION # 98
UC has to built a B2C ecommerce site on Heroku that shares customer and order data with a Heroku Postgres database. UC is currently utilizing Postgres as the single source of truth for both customers and orders. UC has asked a data architect to replicate the data into salesforce so that salesforce can now act as the system of record.
What are the 3 considerations that data architect should weigh before implementing this requirement? Choose 23 answers:
- A. Consider whether the data is required for sales reports, dashboards and KPI's.
- B. Ensure the data is CRM center and able to populate standard of custom objects.
- C. A selection of the tool required to replicate the data.
- D. Ensure there is a tight relationship between order data and an enterprise resource plaining (ERP) application.
- E. Determine if the data is driver of key process implemented within salesforce.
Answer: B,E
Explanation:
a. - Heroku Connect is required but this is confusing
NEW QUESTION # 99
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. Enable granular locking to avoid "UNABLE _TO_LOCK_ROW" error.
- B. Enable defer sharing calculations, and suspend sharing rule calculations
- C. Leverage the Bulk API and concurrent processing with multiple batches
- D. Load the data through data loader, and turn on parallel processing.
Answer: B
NEW QUESTION # 100
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 Contact report including these ten fields and Salesforce Id, then schedule the report to run once a day and send email to the admin.
- B. Turn on field Contact object history tracking for these ten fields, then create reports on contact history.
- C. Write an Apex trigger on Contact after insert event and after update events and store the old values in another custom object.
- D. 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.
Answer: B,C
Explanation:
To capture and report on any changes made to ten text fields on the Contact object for the past 3 months, the data architect should write an Apex trigger on Contact after insert and after update events and store the old values in another custom object, or turn on field Contact object history tracking for these ten fields and create reports on contact history. An Apex trigger can capture the old and new values of the fields, as well as the user and time of the change, and store them in a custom object that can be used for reporting. Field history tracking can also track the changes to the fields and store them in a history table that can be used for reporting.
However, field history tracking only retains data for up to 18 months or 24 months with an extension, so it may not be suitable for longer-term reporting needs. The other options are not feasible or effective for capturing and reporting on field data changes.
NEW QUESTION # 101
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 middleware tools to bidirectionally send Opportunity data across orgs.
- B. Install a 3rd party AppExchange tool to handle the data sharing
- C. Leverage Heroku Connect and Heroku Postgres to bidirectionally sync Opportunities.
- D. Use Salesforce Connect and the cross-org adapter to visualize Opportunities into external objects
- E. Develop an Apex class that pushes opportunity data between orgs daily via the Apex schedule.
Answer: A,C,D
Explanation:
Leveraging Heroku Connect and Heroku Postgres, middleware tools, or Salesforce Connect and the cross-org adapter are all viable options to share data between Org A and Org B in near-real time3. Installing a 3rd party AppExchange tool may not provide bidirectional sync or may have additional costs. Developing an Apex class that pushes opportunity data between orgs daily via the Apex schedule may not meet the near-real time requirement.
NEW QUESTION # 102
DreamHouse Realty has a Salesforce deployment that manages Sales, Support, and Marketing efforts in a multi-system ERP environment. The company recently reached the limits of native reports and dashboards and needs options for providing more analytical insights.
What are two approaches an Architect should recommend? (Choose two.)
- A. AppExchange Apps
- B. Setup Audit Trails
- C. Weekly Snapshots
- D. Einstein Analytics
Answer: A,D
Explanation:
Einstein Analytics can provide more analytical insights than native reports and dashboards by allowing users to explore data from multiple sources, create interactive visualizations, and apply AI-powered features5. AppExchange Apps can also provide more analytical insights by offering pre-built solutions or integrations with external tools that can enhance the reporting and analytics capabilities of Salesforce6.
NEW QUESTION # 103
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. Maintain a data dictionary with the justification for each field.
- C. Put the business purpose in the Description of each field.
- D. Use the Force.com IDE to save the metadata files in source control.
Answer: C,D
Explanation:
Option B is correct because putting the business purpose in the Description of each field is a method that an architect can use to trace back configuration changes to the detailed requirements1. The Description of each field provides a brief explanation of what the field is used for and why it is needed2. Option D is correct because using the Force.com IDE to save the metadata files in source control is another method that an architect can use to trace back configuration changes to the detailed requirements1. The Force.com IDE is an integrated development environment that allows developers to work with Salesforce metadata files and Apex code3. Source control is a system that tracks and manages changes to code and configuration files4. Option A is not correct because reviewing the setup audit trail for configuration changes is not a method to trace back configuration changes to the detailed requirements, but a way to monitor and audit the changes made in the setup area. Option C is not correct because maintaining a data dictionary with the justification for each field is not a method to trace back configuration changes to the detailed requirements, but a document that provides information about the data entities and attributes in a system.
NEW QUESTION # 104
Universal Containers uses Apex jobs to create leads in Salesforce. The business team has requested that lead creation failures should be reported to them.
Which option does Apex provide to report errors from this Apex job?
- A. Save Apex errors in a custom object, and allow access to this object for reporting.
- B. Use AppExchange package to clean lead information before Apex job processes them.
- C. Use Apex services to email failures to business when error occurs.
- D. Use Custom Object to store leads, and allow unprocessed leads to be reported.
Answer: C
NEW QUESTION # 105
Universal Containers has 30 million case records. The Case object has 80 fields. Agents are reporting 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. Contact Salesforce support to enable skinny table for cases.
- C. Move data off of the platform and run reporting outside Salesforce, and give access to reports.
- D. Build reports using custom Lightning components.
Answer: C
Explanation:
According to the Salesforce documentation1, reporting performance can be affected by various factors, such as the volume and complexity of data, the design and configuration of reports and dashboards, the number and type of users accessing the reports, etc. To improve reporting performance, some of the recommended solutions are:
Move data off of the platform and run reporting outside Salesforce, and give access to reports (option C). This means using an external service or tool that can extract, transform, and load (ETL) data from Salesforce to another system or database, such as a data warehouse or a business intelligence platform. This can improve reporting performance by reducing the load and latency on Salesforce, and enabling faster and more flexible reporting and analysis on the external system. Users can access the reports from the external system using a link or an embedded component in Salesforce.
Contact Salesforce support to enable skinny table for cases (option B). This means requesting Salesforce to create a custom table that contains a subset of fields from the Case object that are frequently used or queried. A skinny table can improve reporting performance by avoiding joins between standard and custom fields, omitting soft-deleted records, and leveraging indexes on the fields2.
Create a custom object to store aggregate data and run reports (option A). This means creating a custom object that contains summary or calculated data from the Case object, such as counts, sums, averages, etc. A custom object can improve reporting performance by reducing the number of records and fields that need to be queried and displayed.
Build reports using custom Lightning components (option D). This means creating custom components that use Lightning Web Components or Aura Components frameworks to display report data in Salesforce. A custom component can improve reporting performance by using client-side caching, pagination, lazy loading, or other techniques to optimize data rendering and interaction.
NEW QUESTION # 106
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 implemented this in Salesforce?
- A. A report CANNOT contain data from Accounts and Contacts.
- B. Salesforce does NOT allow more than four objects in a single report type.
- C. Custom report types CANNOT contain Opportunity data.
- D. Salesforce does NOT support Orders or Order Line Items.
Answer: B
Explanation:
The issue that an architect will have when implementing the quarterly accounts receivable report in Salesforce is that Salesforce does not allow more than four objects in a single report type. A report type defines the set of records and fields available to a report based on the relationships between a primary object and up to four related objects. A report type has the following limitations:
It cannot include more than four objects in a single report type, which means that the report cannot compile data from five objects (Accounts, Contacts, Opportunities, Orders, and Order Line Items) at once.
It cannot include objects that are more than two relationships away from each other, which means that the report cannot access fields from Order Line Items through Opportunities and Orders.
It cannot include objects that have a many-to-many relationship with each other, which means that the report cannot access fields from Contacts and Opportunities through the junction object Opportunity Contact Role.
NEW QUESTION # 107
......
Valid Data-Architect Exam Dumps Ensure you a HIGH SCORE: https://pass4sure.dumps4pdf.com/Data-Architect-valid-braindumps.html