Data-Architect Braindumps Real Exam Updated on Oct 12, 2024 with 260 Questions
Latest Data-Architect PDF Dumps & Real Tests Free Updated Today
NEW QUESTION # 67
US has released a new disaster recovery (DR)policy that states that cloud solutions need a business continuity plan in place separate from the cloud providers built in data recovery solution.
Which solution should a data architect use to comply with the DR policy?
- A. Leverage a 3rd party tool that extract salesforce data/metadata and stores the information in an external protected system.
- B. Utilize an ETL tool to migrate data to an on-premise archive solution.
- C. Leverage salesforce weekly exports, and store data in Flat files on a protected system.
- D. Write a custom batch job to extract data changes nightly, and store in an external protected system.
Answer: A
Explanation:
The best solution to comply with the DR policy is to leverage a 3rd party tool that extract Salesforce data/metadata and stores the information in an external protected system. This solution can help create a backup of Salesforce data and metadata in case of a disaster or data loss event. It can also help restore data from the backup system to Salesforce if needed. There are various 3rd party tools available in the AppExchange or online that offer data backup and recovery services for Salesforce67. Leverage Salesforce weekly exports and store data in flat files on a protected system is not a good solution because it does not include metadata backup and it does not allow granular or automated data recovery. Utilize an ETL tool to migrate data to an on-premise archive solution is not a good solution because it does not include metadata backup and it may require complex data transformations and synchronizations. Write a custom batch job to extract data changes nightly and store in an external protected system is not a good solution because it does not include metadata backup and it may have performance or reliability issues.
NEW QUESTION # 68
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. Workflow rule limits
- B. Data storage limits
- C. API Request limits
- D. Webservice callout limits
Answer: B,C
Explanation:
Data storage limits and API request limits are two important factors that affect the data integration and storage in Salesforce. Data storage limits determine how much data can be stored in Salesforce, and API request limits determine how many API calls can be made to Salesforce in a 24-hour period. Both of these limits depend on the edition and license type of the Salesforce org. Workflow rule limits and webservice callout limits are not directly related to data integration and storage, but rather to business logic and external services.
NEW QUESTION # 69
Universal Containers (UC) is planning to move away from legacy CRM to Salesforce. As part of one-time data migration, UC will need to keep the original date when a contact was created in the legacy system. How should an Architect design the data migration solution to meet this requirement?
- A. Create a new field on Contact object to capture the Created Date. Hide the standard CreatedDate field using Field -Level Security.
- B. After the data is migrated, perform an update on all records to set the original date in a standard CreatedDate field.
- C. Enable "Set Audit Fields" and assign the permission to the user loading the data for the duration of the migration.
- D. Write an Apex trigger on the Contact object, before insert event to set the original value in a standard CreatedDate field.
Answer: C
NEW QUESTION # 70
Universal Containers has a rollup summary field on account to calculate the number of contacts associated with an account. During the account load, Salesforce is throwing an "UNABLE _TO_LOCK_ROW" error.
Which solution should a data architect recommend to resolve the error?
- A. Leverage Data Loader's platform API to load data.
- B. Perform a batch job in serial mode and reduce the batch size.
- C. Perform a batch job in parallel mode and reduce the batch size.
- D. Defer rollup summary field calculation during data migration.
Answer: B
Explanation:
According to the Salesforce documentation1, the "UNABLE _TO_LOCK_ROW" error occurs when a record is being updated or created, and another operation tries to access or update the same record at the same time.
This can cause lock contention and timeout issues. To resolve the error, some of the recommended solutions are:
Perform a batch job in serial mode and reduce the batch size (option B). This means running the batch job one at a time and processing fewer records per batch. This can reduce the chances of concurrent updates and lock contention on the same records.
Use the FOR UPDATE keyword to lock records in Apex code or API calls. This means explicitly locking the records that are being accessed or updated by a transaction, and preventing other transactions from modifying them until the lock is released. This can avoid conflicts and errors between concurrent operations on the same records2.
Defer rollup summary field calculation during data migration (option A). This means disabling the automatic calculation of rollup summary fields on the parent object when child records are inserted or updated. This can improve performance and avoid locking issues on the parent records. However, this option is only available for custom objects, not standard objects3.
Performing a batch job in parallel mode and reducing the batch size (option C) is not a good solution, as it can still cause lock contention and errors if multiple batches try to access or update the same records at the same time. Leveraging Data Loader's platform API to load data (option D) is also not a good solution, as it can still encounter locking issues if other operations are modifying the same records at the same time.
NEW QUESTION # 71
Northern Trail Outfitters (NTO) wants to capture a list of customers that have bought a particular product. The solution architect has recommended to create a custom object for product, and to create a lookup relationship between its customers and its products.
Products will be modeled as a custom object (NTO_ Product__ c) and customers are modeled as person accounts. Every NTO product may have millions of customers looking up a single product, resulting in a lookup skew.
What should a data architect suggest to mitigate Issues related to lookup skew?
- A. Create multiple similar products and distribute the skew across those products.
- B. Select Clear the value of this field option while configuring the lookup relationship.
- C. Change the lookup relationship to master-detail relationship.
- D. Create a custom object to maintain the relationship between products and customers.
Answer: A
Explanation:
creating multiple similar products and distributing the skew across those products can be a way to mitigate issues related to lookup skew. The article explains that lookup skew happens when a very large number of records are associated with a single record in the lookup object, and this can cause record locking and performance issues. The article suggests creating multiple copies of the same product record and assigning different child records to each copy, so that the number of child records per parent record is reduced.
NEW QUESTION # 72
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. Have each system pull the record changes from Salesforce using change data capture.
- 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. Send customer record changes from Salesforce to the system of truth in real time.
Answer: A
NEW QUESTION # 73
UC has a legacy client server app that as a relational data base that needs to be migrated to salesforce.
What are the 3 key actions that should be done when data modeling in salesforce?
Choose 3 answers:
- A. Map legacy data to salesforce custom objects.
- B. Implement legacy data model within salesforce using custom fields.
- C. Identify data elements to be persisted in salesforce.
- D. Work with legacy application owner to analysis legacy data model.
- E. Map legacy data to salesforce objects.
Answer: B,C,E
Explanation:
According to the Data Modeling unit on Trailhead, some of the key actions that should be done when data modeling in Salesforce are identifying data elements, mapping legacy data, and implementing legacy data model. The unit states that "Before you start creating objects and fields in Salesforce, you need to identify the data elements that you want to store and work with. ... Next, you need to map your legacy data to Salesforce objects and fields. ... Finally, you need to implement your data model in Salesforce by creating custom objects and fields using declarative tools or Metadata API." Therefore, these are the correct actions for migrating a legacy client server app to Salesforce.
NEW QUESTION # 74
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. - Heroku Connect is required but this is confusing
- 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. Determine if the data is driver of key process implemented within salesforce.
- E. Ensure there is a tight relationship between order data and an enterprise resource plaining (ERP) application.
- F. Consider whether the data is required for sales reports, dashboards and KPI's.
Answer: C,D,E
Explanation:
Before replicating the data from Heroku Postgres to Salesforce, the data architect should consider the following factors:
Whether the data is a driver of key processes implemented within Salesforce. For example, if the data is used for workflows, triggers, or validation rules, it should be replicated to Salesforce.
Whether there is a tight relationship between order data and an enterprise resource planning (ERP) application. For example, if the order data needs to be synchronized with the ERP system, it should be replicated to Salesforce.
The selection of the tool required to replicate the data. For example, Heroku Connect can be used to bi-directionally sync data between Heroku Postgres and Salesforce
NEW QUESTION # 75
NTO has decided to franchise its brand. Upon implementation, 1000 franchisees will be able to access BTO's product information and track large customer sales and opportunities through a portal. The Franchisees will also be able to run monthly and quarterly sales reports and projections as well as view the reports in dashboards.
Which licenses does NTO need to provide these features to the Franchisees?
- A. Lightning Platform license
- B. Partner Community license
- C. Customer Community license
- D. Salesforce Sales Cloud license
Answer: B
NEW QUESTION # 76
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. Make sure the query doesn't contain NULL in any filter criteria.
- B. Create a formula field instead of having multiple filter criteria.
- C. Create custom indexes on the fields used in the filter criteria.
- D. Modify the integration users' profile to have View All Data.
Answer: A,C
NEW QUESTION # 77
Universal Containers (UC) is concerned about the accuracy of their Customer information in Salesforce. They have recently created an enterprise-wide trusted source MDM for Customer data which they have certified to be accurate. UC has over 20 million unique customer records in the trusted source and Salesforce. What should an Architect recommend to ensure the data in Salesforce is identical to the MDM?
- A. Load the Trusted Source data into Salesforce and run an Apex Batch job to find difference.
- B. Leave the data in Salesforce alone and assume that it will auto-correct itself over time.
- C. Extract the Salesforce data into Excel and manually compare this against the trusted source.
- D. Use an AppExchange package for Data Quality to match Salesforce data against the Trusted source.
Answer: D
NEW QUESTION # 78
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. Duplicate Contact records exist in the system.
- B. Customer phone number has changed on the Contact record.
- C. Missing phone number on the Contact record.
- D. Duplicate Activity records on a Contact.
Answer: A
NEW QUESTION # 79
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 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.
- B. 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.
- C. 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.
- D. 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.
Answer: A
NEW QUESTION # 80
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. Contact Salesforce support to enable skinny table for cases.
- D. Move data off of the platform and run reporting outside Salesforce, and give access to reports.
Answer: A
NEW QUESTION # 81
In their legacy system. Universal Containers has a monthly accounts receivable report that compiles data from Accounts, Contacts, Opportunities, Orders. and Order Line Items. What difficulty will an architect run into when implementing this in Salesforce?
- A. Custom report types cannot contain Opportunity data.
- B. A report cannot contain data from Accounts and Contacts.
- C. Salesforce allows up to four objects in a single report type.
- D. Salesforce does not support Orders or Order Line Items.
Answer: C
NEW QUESTION # 82
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. Write an Apex trigger that checks each field when records are saved.
- B. Use a validation rule for each field that takes the Stage into consideration.
- C. Update these Opportunity field definitions in Setup to be required.
- D. Update the Opportunity page layout to mark these fields as required.
Answer: B
Explanation:
Using a validation rule for each field that takes the Stage into consideration is the simplest approach to handle this new requirement. A validation rule can enforce the field requirements based on the logic and criteria that you define, and display an error message when users try to save a record that does not meet the requirements.
Updating the Opportunity page layout to mark these fields as required will not work because page layouts do not support conditional field requirements. Updating these Opportunity field definitions in Setup to be required will not work because it will apply to all stages and records. Writing an Apex trigger that checks each field when records are saved is not the simplest approach because it requires coding and testing
NEW QUESTION # 83
Universal Containers (UC) has a requirement to create an Account plan object that is related to the Account object. Each Account plan needs to have an Account object, but the accessibility requirement of the Account plan is different from the Account object. What should an Architect recommend?
- A. Create an account plan object with a lookup relationship to Account with validation rules to enforce the Account association.
- B. Create a custom account plan object as detail with Account as mater in a master-detail relationship.
- C. Create an account plan object with a lookup relations to Account without any validation rules to enforce the Account association.
- D. Create a custom account plan object as detail with Account as master with additional sharing rules to allow access.
Answer: A
NEW QUESTION # 84
An Architect needs information about who is creating, changing, or deleting certain fields within the past four months.
How can the Architect access this information?
- A. Remove "customize application" permissions from everyone else.
- B. After exporting the setup audit trail, find the fields in question.
- C. Create a field history report for the fields in question.
- D. After exporting the metadata, search it for the fields in question.
Answer: B
NEW QUESTION # 85
Universal Container (UC) has around 200,000 Customers (stored in Account object). They get 1 or 2 Orders every month from each Customer. Orders are stored in a custom object called "Order c"; this has about 50 fields. UC is expecting a growth of 10% year -over -year. What are two considerations an architect should consider to improve the performance of SOQL queries that retrieve data from the Order _c object? Choose 2 answers
- A. Reduce the number of triggers on Order _c object.
- B. Use SOQL queries without WHERE conditions.
- C. Make the queries more selective using indexed fields.
- D. Work with Salesforce Support to enable Skinny Tables.
Answer: C,D
Explanation:
To improve the performance of SOQL queries that retrieve data from the Order_c object, the data architect should work with Salesforce Support to enable Skinny Tables and make the queries more selective using indexed fields. Skinny Tables are custom tables that contain frequently used fields and are kept in sync with the base tables3. They can improve performance by reducing the number of table joins and using indexes. Making the queries more selective using indexed fields can also improve performance by reducing the query execution time and avoiding query timeouts4. The other options are not effective or recommended for improving SOQL performance.
NEW QUESTION # 86
An Architect needs information about who is creating, changing, or deleting certain fields within the past four months.
How can the Architect access this information?
- A. Remove "customize application" permissions from everyone else.
- B. After exporting the setup audit trail, find the fields in question.
- C. Create a field history report for the fields in question.
- D. After exporting the metadata, search it for the fields in question.
Answer: B
Explanation:
Exporting the setup audit trail can provide information about who is creating, changing, or deleting certain fields within the past four months. The setup audit trail tracks the recent setup changes that administrators and other users have made to the organization. The setup audit trail history shows up to 20 most recent changes in the Setup area, but administrators can download a report (in CSV format) of up to six months of setup history.
NEW QUESTION # 87
......
Data-Architect Dumps With 100% Verified Q&As - Pass Guarantee or Full Refund: https://actualtests.vceengine.com/Data-Architect-vce-test-engine.html
