
Data-Architect Practice Test Give You First Time Success with 100% Money Back Guarantee!
All Obstacles During Data-Architect Exam Preparation with Data-Architect Real Test Questions
NEW QUESTION # 42
Universal Containers would like to remove data silos and connect their legacy CRM together with their ERP and with Salesforce. Most of their sales team has already migrated to Salesforce for daily use, although a few users are still on the old CRM until some functionality they require is completed. Which two techniques should be used for smooth interoperability now and in the future.
- A. Specify the legacy CRM as the system of record during transition until it is removed from operation and fully replaced by Salesforce.
- B. Work with stakeholders to establish a Master Data Management plan for the system of record for specific objects, records, and fields.
- C. Replicate ongoing changes in the legacy CRM to Salesforce to facilitate a smooth transition when the legacy CRM is eventually retired.
- D. Do not connect Salesforce and the legacy CRM to each other during this transition period, but do allow both to interact with the ERP.
Answer: A,B
Explanation:
Specify the legacy CRM as the system of record during transition until it is removed from operation and fully replaced by Salesforce. This is a good technique to ensure data consistency and avoid conflicts between the two systems. Work with stakeholders to establish a Master Data Management plan for the system of record for specific objects, records, and fields. This is another good technique to define the data governance and stewardship policies and processes for managing data quality and integrity across multiple systems
NEW QUESTION # 43
As part of addressing general data protection regulation (GDPR) requirements, UC plans to implement a data classification policy for all its internal systems that stores customer information including salesforce.
What should a data architect recommend so that UC can easily classify consumer information maintained in salesforce under both standard and custom objects?
- A. Create a custom picklist field to capture classification of information on customer.
- B. Use data classification metadata fields available in field definition.
- C. Use App Exchange products to classify fields based on policy.
- D. Build reports for customer information and validate.
Answer: B
NEW QUESTION # 44
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 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. Use AppExchange package for backup and restore.
Answer: D
NEW QUESTION # 45
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. Lightning platform starter license.
- B. Sales cloud license
- C. Service cloud license.
- D. Salesforce license.
Answer: C
NEW QUESTION # 46
Northern trail Outfitters (NTO) uses Sales Cloud and service Cloud to manage sales and support processes.
Some of NTOs team are complaining they see new fields on their page unsure of which values need be input.
NTO is concerned about lack of governance in making changes to Salesforce.
Which governance measure should a data architect recommend to solve this issue?
- A. Create validation rules with error messages to explain why the fields is used
- B. Add description fields to explain why the field is used, and mark the field as required.
- C. Create reports to identify which users are leaving blank, and use external data sources o agreement the missing data.
- D. Create and manage a data dictionary and ups a governance process for changes made to common objects.
Answer: D
Explanation:
To solve the issue of lack of governance in making changes to Salesforce, a data architect should recommend creating and managing a data dictionary and setting up a governance process for changes made to common objects. A data dictionary is a document that defines the metadata, structure, and relationship of each object and field in Salesforce. A governance process is a set of rules and procedures that govern how changes are proposed, reviewed, approved, and deployed in Salesforce. These measures will help NTO to maintain consistency, quality, and clarity of their data model and avoid confusion and errors among users. Option A is incorrect because adding description fields to explain why the field is used, and marking the field as required will not prevent unauthorized or unnecessary changes to Salesforce. Option C is incorrect because creating reports to identify which users are leaving blank, and using external data sources to augment the missing data will not address the root cause of the issue, which is the lack of governance in making changes to Salesforce.
Option D is incorrect because creating validation rules with error messages to explain why the fields are used will not stop users from seeing new fields on their page that they are unsure of.
NEW QUESTION # 47
Northern Trail Outfitters (NTO) has implemented Salesforce for its sales users. The opportunity management in Saiesforce Is implemented as follows:
1. Sales users enter their opportunities in Salesforce for forecasting and reporting purposes.
2. NTO has a product pricing system (PPS) that is used to update the Opportunity Amount field on opportunities on a daily basis.
3. PPS is the trusted source within NTO for Opportunity Amount.
4. NTO uses Opportunity Forecast for its sales planning and management.
Sales users have noticed that their updates to the Opportunity Amount field are overwritten when PPS updates their opportunities.
How should a data architect address this overwriting issue?
- A. Create a custom field for Opportunity amount that PSS updates separating the field sales user updates.
- B. Create a custom field for Opportunity amount that sales users update separating the field that PPS updates.
- C. Change Opportunity Amount field access to Read Only for sales users field-level security.
- D. Change PSS integration to update only Opportunity Amount field when the value is null.
Answer: C
Explanation:
Changing Opportunity Amount field access to Read Only for sales users field-level security (option C) is the best way to address the overwriting issue, as it prevents sales users from updating the field that is controlled by PPS, and ensures data consistency and accuracy. Creating a custom field for Opportunity amount that PSS updates separating the field sales user updates (option A) or creating a custom field for Opportunity amount that sales users update separating the field that PPS updates (option D) are not good solutions, as they may create confusion and inconsistency with the Opportunity Forecast feature. Changing PSS integration to update only Opportunity Amount field when the value is null (option B) is also not a good solution, as it may cause data loss or conflicts with the sales users' inputs.
NEW QUESTION # 48
Cloud Kicks has the following requirements:
- Data needs to be sent from Salesforce to an external system to generate invoices from their Order Management System (OMS).
- A Salesforce administrator must be able to customize which fields will be sent to the external system without changing code.
What are two approaches for fulfilling these requirements? (Choose two.)
- A. An Outbound Message to determine which fields to send to the OMS.
- B. A set<sobjectFieldset> to determine which fields to send in an HTTP callout.
- C. A Field Set that determines which fields to send in an HTTP callout.
- D. Enable the field -level security permissions for the fields to send.
Answer: A,C
Explanation:
An Outbound Message is a native Salesforce feature that allows sending data to an external system without code. It can be configured to include any fields from the source object3. A Field Set is a collection of fields that can be used in Visualforce pages or Apex classes to dynamically determine the fields to send in an HTTP callout. Both of these approaches meet the requirements of Cloud Kicks.
NEW QUESTION # 49
Universal Containers (UC) is in the process of selling half of its company. As part of this split, UC's main Salesforce org will be divided into two org:org A and org B, UC has delivered these requirements to its data architect
1. The data model for Org B will drastically change with different objects, fields, and picklist values.
2. Three million records will need to be migrated from org A to org B for compliance reasons.
3. The migrate will need occur within the next two month, prior to be split.
Which migrate strategy should a data architect use to successfully migrate the date?
- A. Use the Salesforces CLI to query, export, and import
- B. Write a script to use the Bulk API
- C. Use Data Loader for export and Data Import Wizard for import
- D. use as ETL tool to orchestrate the migration.
Answer: B
NEW QUESTION # 50
Northern Trail Outfitters (NTO) has multiple Salesforce orgs based on regions. Users need read-only access to customers across all Salesforce orgs.
Which feature in Salesforce can be used to provide access to customer records across all NTO orgs?
- A. Salesforce Connect
- B. Federated Search
- C. Salesforce 2 Salesforce
- D. External APIs
Answer: A
Explanation:
Salesforce Connect is a feature that allows users to access data from external sources and multiple Salesforce orgs, using either clicks or code. Salesforce Connect can provide read-only access to customer records across all NTO orgs, without replicating or storing the data in Salesforce.
NEW QUESTION # 51
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. Use Apex services to email failures to business when error occurs.
- B. Save Apex errors in a custom object, and allow access to this object for reporting.
- C. Use Custom Object to store leads, and allow unprocessed leads to be reported.
- D. Use AppExchange package to clean lead information before Apex job processes them.
Answer: A
NEW QUESTION # 52
Northern Trail Outfitters has these simple requirements for a data export process:
File format should be in CSV.
Process should be scheduled and run once per week.
The expert should be configurable through the Salesforce UI.
Which tool should a data architect leverage to accomplish these requirements?
- A. Data loader
- B. Third-party ETL tool
- C. Bulk API
- D. Data export wizard
Answer: D
Explanation:
The correct answer is B, data export wizard. The data export wizard is a tool that allows you to export your data in CSV format, schedule the export process to run once per week, and configure the export settings through the Salesforce UI. The data export wizard can handle up to 51 million records per export. The bulk API, third-party ETL tools, and data loader are also tools that can export data, but they are not as simple or user-friendly as the data export wizard.
NEW QUESTION # 53
A casino is implementing salesforce and is planning to build a customer 360 view for a customer who visits its resorts. The casino currently maintained the following systems that records customer activity:
1.Point of sales system: All purchases for a customer.
2.Salesforce: All customer service activity and sales activity for a customer.
3.Mobile app: All bookings, preferences and browser activity for a customer.
4.Marketing: All email, SMS and social campaigns for a customer.
Customer service agents using salesforce would like to view the activities from all system to provide supports to customers. The information has to be current and real time.
What strategy should the data architect implement to satisfy this requirement?
- A. Migrate customer activities from all 4 systems into salesforce.
- B. Periodically upload summary information in salesforce to build 360 view.
- C. Explore external data sources in salesforce to build 360 view of customer.
- D. Use a customer data mart to view the 360 view of customer.
Answer: C
Explanation:
Exploring external data sources in Salesforce to build 360 view of customer is the best strategy to satisfy the requirement, as it allows real-time access to data from other systems without storing it in Salesforce3. Using a customer data mart may not provide real-time information or may require additional integration efforts.
Migrating customer activities from all 4 systems into Salesforce may exceed the storage limits or cause data quality issues. Periodically uploading summary information in Salesforce may not provide current or detailed information.
NEW QUESTION # 54
Universal Containers (UC) is migrating from a legacy system to Salesforce CRM, UC is concerned about the quality of data being entered by users and through external integrations.
Which two solution should a data architect recommend to mitigate data quality issues?
- A. Leverage third-party- AppExchange tools
- B. Leverage Apex to validate the format of data being entered via a mobile device.
- C. Leverage picklist and lookup fields where possible
- D. Leverage validation rules and workflows.
Answer: C,D
NEW QUESTION # 55
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. Import the data concurrently.
- B. Clean data before importing to Salesforce.
- C. Use Salesforce matching and duplicate rules.
- D. Use a workflow to check and prevent duplicates.
Answer: B,C
NEW QUESTION # 56
Universal Containers (UC) has implemented Sales Cloud and it has been noticed that Sales reps are not entering enough data to run insightful reports and dashboards. UC executives would like to monitor and measure data quality metrics. What solution addresses this requirement?
- A. Export the data to an enterprise data warehouse and use BI tools for data quality.
- B. Generate reports to view the quality of sample data.
- C. Use custom objects and fields to calculate data quality.
- D. Use third-party AppExchange tools to monitor and measure data quality.
Answer: D
Explanation:
Using third-party AppExchange tools to monitor and measure data quality can address the requirement of UC executives by providing features such as data cleansing, deduplication, validation, enrichment, and scoring. These tools can help improve the accuracy, completeness, and consistency of the data entered by sales reps .
NEW QUESTION # 57
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. Set data access to Private to hide old data from Sales Reps.
- B. Archive and purge old data from Salesforce on a monthly basis.
- C. Create a Permission Set to hide old data from Sales Reps.
- D. Use Batch Apex to archive old data on a rolling nightly basis.
Answer: B
NEW QUESTION # 58
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. Partner Community license
- B. Customer Community license
- C. Salesforce Sales Cloud license
- D. Lightning Platform license
Answer: A
Explanation:
The best license to provide these features to the franchisees is the Partner Community license. Partner Community licenses are designed for external users who collaborate with your sales team on deals, such as resellers, distributors, or brokers. Partner Community users can access standard CRM objects, such as accounts, contacts, leads, opportunities, campaigns, and reports. They can also access custom objects and run dashboards12. Salesforce Sales Cloud license is not a good option because it is intended for internal users who need full access to standard CRM and custom apps. Lightning Platform license is not a good option because it is intended for users who need access to custom apps but not to standard CRM functionality. Customer Community license is not a good option because it is intended for external users who need access to customer support features, such as cases and knowledge articles, but not to sales features
NEW QUESTION # 59
UC is rolling out Sales App globally to bring sales teams together on one platform. UC expects millions of opportunities and accounts to be creates and is concerned about the performance of the application.
Which 3 recommendations should the data architect make to avoid the data skew? Choose 3 answers.
- A. Limit assigning one user 10000 records ownership.
- B. Limit associating 10000 opportunities to one account.
- C. Use picklist fields rather than lookup to custom object.
- D. Assign 10000 opportunities to one account.
- E. Limit associating 10000 records looking up to same records.
Answer: A,B,E
NEW QUESTION # 60
A large automobile company has implemented Salesforce for its sales associates. Leads flow from its website to Salesforce using a batch integration in Salesforce. The batch job converts the leads to Accounts in Salesforce. Customers visiting their retail stores are also created in Salesforce as Accounts.
The company has noticed a large number of duplicate Accounts in Salesforce. On analysis, it was found that certain customers could interact with its website and also visit the store. The sales associates use Global Search to search for customers in Salesforce before they create the customers.
Which option should a data architect choose to implement to avoid duplicates?
- A. leverage duplicate rules in Salesforce to validate duplicates during the account creation process.
- B. Develop an Apex class that searches for duplicates and removes them nightly.
- C. Implement an MDM solution to validate the customer information before creating Salesforce.
- D. Build a custom search functionality that allows sales associates to search for customer in real time upon visiting their retail stores.
Answer: A
NEW QUESTION # 61
A customer needs a sales model that allows the following:
Opportunities need to be assigned to sales people based on the zip code.
Each sales person can be assigned to multiple zip codes.
Each zip code is assigned to a sales area definition. Sales is aggregated by sales area for reporting.
What should a data architect recommend?
- A. Assign opportunities using list views using zip code.
- B. Add custom fields in opportunities for zip code and use assignment rules.
- C. Configure territory management feature to support opportunity assignment.
- D. Allow sales users to manually assign opportunity ownership based on zip code.
Answer: C
Explanation:
The best solution to assign opportunities based on zip code and sales area is to configure territory management feature to support opportunity assignment. Territory management is a feature that allows you to organize your sales team into territories based on criteria such as geography, industry, product line, or customer segment. You can assign accounts and opportunities to territories using assignment rules or manual sharing. You can also define forecast managers and roll up forecasts by territory45. Assign opportunities using list views using zip code is not a good solution because it is inefficient and does not support reporting by sales area. Add custom fields in opportunities for zip code and use assignment rules is not a good solution because it requires creating additional fields and does not support reporting by sales area. Allow sales users to manually assign opportunity ownership based on zip code is not a good solution because it is prone to errors and does not support reporting by sales area.
NEW QUESTION # 62
UC is rolling out Sales App globally to bring sales teams together on one platform. UC expects millions of opportunities and accounts to be creates and is concerned about the performance of the application.
Which 3 recommendations should the data architect make to avoid the data skew? Choose 3 answers.
- A. Limit assigning one user 10000 records ownership.
- B. Limit associating 10000 opportunities to one account.
- C. Use picklist fields rather than lookup to custom object.
- D. Assign 10000 opportunities to one account.
- E. Limit associating 10000 records looking up to same records.
Answer: A,B,E
Explanation:
Data skew occurs when a large number of child records are associated with a single parent record, or when a single user owns a large number of records. This can cause performance issues and lock contention. To avoid data skew, the data architect should limit assigning one user 10,000 records ownership, limit associating 10,000 opportunities to one account, and limit associating 10,000 records looking up to the same record
NEW QUESTION # 63
Northern Trail Outfitters (NTO) has multiple Salesforce orgs based on regions. Users need read-only access to customers across all Salesforce orgs.
Which feature in Salesforce can be used to provide access to customer records across all NTO orgs?
- A. Salesforce Connect
- B. Federated Search
- C. Salesforce 2 Salesforce
- D. External APIs
Answer: A
NEW QUESTION # 64
Northern Trail Outfitters would like to report on the type of customers. A custom field for customer type was created in Account object. Users need to be limited to the following defined choices when entering information in this field:
1. High Value
2. Medium Value
3. Low Value
Which strategy should a data architect recommend to configure customer type?
- A. Single-select restricted picklist with defined choices.
- B. Provide help text to guide users with defined choices.
- C. Lookup to a custom object with defined choices.
- D. Create a validation rule to limit entry to defined choices.
Answer: A
NEW QUESTION # 65
UC has millions of case records with case history and SLA dat
a. UC's compliance team would like historical cases to be accessible for 10 years for Audit purpose.
What solution should a data architect recommend?
- A. Archive Case data using Salesforce Archiving process
- B. Purchase more data storage to support case object
- C. Use a custom Big object to store archived case data.
- D. Use a custom object to store archived case data.
Answer: C
Explanation:
The best solution to store historical cases for 10 years for audit purpose is to use a custom Big object to store archived case data. Big objects are a type of custom object that can store massive amounts of data on the Salesforce platform without affecting performance or storage limits. They also support point-and-click tools, triggers, and Apex code. Big objects can be used for archiving historical data that needs to be retained for compliance or analytics purposes3. Archiving case data using Salesforce Archiving process is not a good option because it only supports archiving cases that are closed for more than one year, and it does not allow customizing the archival criteria or accessing the archived data via Apex or APIs4. Purchasing more data storage to support case object is expensive and may impact performance. Using a custom object to store archived case data is not scalable and may consume a lot of storage space.
NEW QUESTION # 66
Universal Containers (UC) has implemented Sales Cloud and it has been noticed that Sales reps are not entering enough data to run insightful reports and dashboards. UC executives would like to monitor and measure data quality metrics. What solution addresses this requirement?
- A. Export the data to an enterprise data warehouse and use BI tools for data quality.
- B. Generate reports to view the quality of sample data.
- C. Use custom objects and fields to calculate data quality.
- D. Use third-party AppExchange tools to monitor and measure data quality.
Answer: D
Explanation:
Using third-party AppExchange tools to monitor and measure data quality can address the requirement of UC executives by providing features such as data cleansing, deduplication, validation, enrichment, and scoring.
These tools can help improve the accuracy, completeness, and consistency of the data entered by sales reps .
NEW QUESTION # 67
......
Fully Updated Free Actual Salesforce Data-Architect Exam Questions: https://actualtests.trainingquiz.com/Data-Architect-training-materials.html

