Data-Architect Exam Practice Questions prepared by Salesforce Professionals
Use Valid New Data-Architect Questions - Top choice Help You Gain Success
Salesforce Data-Architect Certification Exam is a proctored, multiple-choice exam that consists of 60 questions. Candidates have 105 minutes to complete the exam and must achieve a passing score of 63% or higher. Data-Architect exam is administered online and can be taken from anywhere with a reliable internet connection.
NEW QUESTION # 114
A custom pricing engine for a Salesforce customer has to be decided by factors with the following hierarchy:
State in which the customer is located
City in which the customer is located if available
Zip code in which the customer is located if available
Changes to this information should have minimum code changes
What should a data architect recommend to maintain this information for the custom pricing engine that is to be built in Salesforce?
- A. Create a custom object to maintain the pricing criteria.
- B. Maintain require pricing criteria in custom metadata types.
- C. Configure the pricing criteria in price books.
- D. Assign the pricing criteria within customer pricing engine.
Answer: B
Explanation:
According to the Get Started with Custom Metadata Types unit on Trailhead, one of the use cases for custom metadata types is to define custom charges for an accounting app. The unit states that "Say that your org uses a standard accounting app. You can create a custom metadata type that defines custom charges, like duties and VAT rates. Then you can write some Apex code that calculates the total amount due for each invoice by using the metadata from your custom metadata type." Therefore, a similar approach can be used to maintain the pricing criteria for a custom pricing engine in Salesforce.
NEW QUESTION # 115
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. Manually update Opportunities with Prices application to distributors.
- B. Configure price Books for each region and share with distributors.
- C. Create lookup to Custom Price object and share with distributors.
- D. Add custom fields in Opportunity and use triggers to update prices.
Answer: B
NEW QUESTION # 116
UC has millions of Cases and are running out of storage. Some user groups need to have access to historical cases for up to 7 years.
Which 2 solutions should a data architect recommend in order to minimize performance and storage issues?
Choose 2 answers:
- A. Create a custom object to store case history and run reports on it.
- B. Leverage big object to archive case data and lightning components to show archived data.
- C. Leverage on premise data archival and build integration to view archived data.
- D. Export data out of salesforce and store in Flat files on external system.
Answer: B,C
Explanation:
The correct answer is C and D. To minimize performance and storage issues, a data architect should recommend leveraging on premise data archival and building integration to view archived data, and leveraging big object to archive case data and lightning components to show archived data. These solutions will allow some user groups to access historical cases for up to 7 years without consuming too much storage space or affecting the performance of queries and reports. Option A is incorrect because exporting data out of salesforce and storing it in flat files on external system will make it difficult to access and query the data.
Option B is incorrect because creating a custom object to store case history and run reports on it will still consume a lot of storage space and impact the performance of queries and reports.
NEW QUESTION # 117
Universal Containers wants to develop a dashboard in Salesforce that will allow Sales Managers to do data exploration using their mobile device (i.e., drill down into sales-related data) and have the possibility of adding ad-hoc filters while on the move. What is a recommended solution for building data exploration dashboards in Salesforce?
- A. Create a Dashboard in an external reporting tool, export data to the tool, and embed the dashboard in Salesforce using the Canval toolkit.
- B. Create a standard Salesforce Dashboard and connect it to reports with the appropriate filters.
- C. Create a Dashboard in an external reporting tool, export data to the tool, and add link to the dashboard in Salesforce.
- D. Create a Dashboard using Analytics Cloud that will allow the user to create ad-hoc lenses and drill down.
Answer: D
Explanation:
Creating a Dashboard using Analytics Cloud that will allow the user to create ad-hoc lenses and drill down is a recommended solution for building data exploration dashboards in Salesforce. Analytics Cloud is a powerful data analysis tool that enables users to explore data using interactive dashboards, charts, graphs, and tables on any device. Users can also create lenses, which are ad-hoc data queries that can be saved and reused, and drill down into data details using filters and facets. Creating a Dashboard in an external reporting tool, exporting data to the tool, and adding link to the dashboard in Salesforce will not provide a seamless user experience and may require additional data integration and security considerations. Creating a Dashboard in an external reporting tool, exporting data to the tool, and embedding the dashboard in Salesforce using the Canval toolkit will not provide a native Salesforce solution and may require additional data integration and security considerations. Creating a standard Salesforce Dashboard and connecting it to reports with the appropriate filters will not allow the user to create ad-hoc lenses and drill down into data details on their mobile device.
NEW QUESTION # 118
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. Allow sales users to manually assign opportunity ownership based on zip code.
- C. Add custom fields in opportunities for zip code and use assignment rules.
- D. Configure territory management feature to support opportunity assignment.
Answer: D
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 # 119
An architect is planning on having different batches to load one million Opportunities into Salesforce using the Bulk API in parallel mode. What should be considered when loading the Opportunity records?
- A. Create indexes on Opportunity object text fields.
- B. Sort batches by Name field values.
- C. Order batches by Auto -number field.
- D. Group batches by the AccountId field.
Answer: C
Explanation:
Ordering batches by Auto-number field will ensure that the records are processed in a sequential order and avoid any locking issues that might occur when loading related records in parallel mode. Creating indexes, grouping batches by AccountId, or sorting batches by Name field values are not necessary or beneficial for loading Opportunity records using the Bulk API.
NEW QUESTION # 120
Universal Containers (UC) has a complex system landscape and is implementing a data governance program for the first time Which two first steps would be appropriate for UC to initiate an assessment of data architecture? Choose 2 answers
- A. Engage with business units and IT to assess current operational systems and data models.
- B. Engage with IT program managers to assess current velocity of projects in the pipeline.
- C. Engage with executive sponsorship to assess enterprise data strategy and goals.
- D. Engage with database administrators to assess current database performance metrics.
Answer: A,C
Explanation:
Engaging with executive sponsorship to assess enterprise data strategy and goals, and engaging with business units and IT to assess current operational systems and data models are two first steps that would be appropriate for UC to initiate an assessment of data architecture. These steps will help to understand the current state of data management, the business needs and expectations, and the gaps and opportunities for improvement. Engaging with IT program managers to assess current velocity of projects in the pipeline, and engaging with database administrators to assess current database performance metrics are not relevant steps for assessing data architecture, as they are more related to project management and technical performance.
NEW QUESTION # 121
Universal Containers (UC) is launching an RFP to acquire a new accounting product available on AppExchange. UC is expecting to issue 5 million invoices per year, with each invoice containing an average of 10 line items. What should UC's Data Architect recommend to ensure scalability?
- A. Ensure invoice line items simply reference existing Opportunity line items.
- B. Ensure the account product vendor includes Wave Analytics in their offering.
- C. Ensure the account product vendor provides a sound data archiving strategy.
- D. Ensure the accounting product runs 100% natively on the Salesforce platform.
Answer: C
NEW QUESTION # 122
Northern Trail Outfitters (NTO) has recently implemented Salesforce to track opportunities across all their regions. NTO sales teams across all regions have historically managed their sales process in Microsoft Excel.
NTO sales teams are complaining that their data from the Excel files were not migrated as part of the implementation and NTO is now facing low Salesforce adoption.
What should a data architect recommend to increase Salesforce adoption?
- A. Use the Excel connector to Salesforce to sync data from individual Excel files.
- B. Create a chatter group and upload all Excel files to the group.
- C. Load data in external database and provide access to database to sales users.
- D. Define a standard mapping and train sales users to import opportunity data.
Answer: D
Explanation:
According to Trailhead2, one of the best practices to increase Salesforce adoption is to migrate existing data from legacy systems or spreadsheets into Salesforce, so that users can access all their data in one place and leverage the features and functionality of Salesforce. Option B is the correct answer because it suggests defining a standard mapping and training sales users to import opportunity data from Excel files into Salesforce, which can help them transition from their old process and increase their confidence and satisfaction with Salesforce. Option A is incorrect because using the Excel connector to Salesforce does not migrate the data into Salesforce, but only syncs it between Excel and Salesforce, which can cause data inconsistency and duplication issues. Option C is incorrect because loading data in an external database and providing access to it does not increase Salesforce adoption, but rather creates another system for users to manage and switch between. Option D is incorrect because creating a chatter group and uploading all Excel files to it does not migrate the data into Salesforce, but only stores it as attachments, which cannot be used for reporting or analysis purposes.
NEW QUESTION # 123
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. Develop an Apex class that searches for duplicates and removes them nightly.
- B. leverage duplicate rules in Salesforce to validate duplicates during the account creation process.
- 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: B
NEW QUESTION # 124
Universal Containers (UC) is migrating from an on-premise homegrown customer relationship management (CRM) system- During analysis, UC users highlight a pain point that there are multiple versions of many customers.
What should the data architect do for a successful migration to mitigate the pain point?
- A. Migrate the data as is, and use Salesforce's de-duplicating feature.
- B. Hire an intern manually de-duplicate the records after migrating to Salesforce.
- C. Store the data in a staging database, and de-duplicate identical records.
- D. Have the users manually clean the data in the old system prior to migration.
Answer: C
Explanation:
Storing the data in a staging database and de-duplicating identical records (option D) is the best solution for a successful migration to mitigate the pain point, as it allows the data architect to identify and merge duplicate customers before they are imported into Salesforce. Hiring an intern manually de-duplicate the records after migrating to Salesforce (option A) is not a good solution, as it may be time-consuming and error-prone, and it does not prevent duplicate records from being created in Salesforce. Migrating the data as is and using Salesforce's de-duplicating feature (option B) is also not a good solution, as it may cause data quality issues and conflicts, and it does not address the root cause of the duplication. Having the users manually clean the data in the old system prior to migration (option C) is also not a good solution, as it may be unrealistic and impractical, and it does not leverage any automated tools or processes.
NEW QUESTION # 125
Universal Containers has two systems. Salesforce and an on -premise ERP system. An architect has been tasked with copying Opportunity records to the ERP once they reach a Closed/Won Stage. The Opportunity record in the ERP system will be read-only for all fields copied in from Salesforce. What is the optimal real-time approach that achieves this solution?
- A. Have the ERP poll Salesforce nightly and bring in the desired Opportunities.
- B. Implement a workflow rule that sends Opportunity data through Outbound Messaging.
- C. Implement a Master Data Management system to determine system of record.
- D. Implement an hourly integration to send Salesforce Opportunities to the ERP system.
Answer: B
NEW QUESTION # 126
A customer wants to maintain geographic location information including latitude and longitude in a custom object. What would a data architect recommend to satisfy this requirement?
- A. Recommend app exchange packages to support this requirement.
- B. Create custom fields to maintain latitude and longitude information
- C. Create formula fields with geolocation function for this requirement.
- D. Create a geolocation custom field to maintain this requirement
Answer: C
NEW QUESTION # 127
A company wants to document the data architecture of a Salesforce organization.
What are two valid metadata types that should be included? (Choose two.)
- A. CustomField
- B. Document
- C. RecordType
- D. SecuritySettings
Answer: A,C
NEW QUESTION # 128
Universal Container (UC) has accumulated data over years and has never deleted data from its Salesforce org. UC is now exceeding the storage allocations in the org. UC is now looking for option to delete unused from the org.
Which three recommendations should a data architect make is order to reduce the number of records from the org?
Choose 3 answers
- A. Use hard delete in batch Apex to permanently delete records from Salesforce.
- B. Use Rest API to permanently delete records from the Salesforce org.
- C. Archive the records in enterprise data warehouse (EDW) before deleting from Salesforce.
- D. Use hard delete in Bulk API to permanently delete records from Salesforce.
- E. Identify records in objects that have not been modified or used In last 3 years.
Answer: C,D,E
NEW QUESTION # 129
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. Post go -live automated page -load testing against the Salesforce Production org.
- C. Pre -go -live automated page -load testing against the Salesforce Full sandbox.
- D. Pre -go -live unit testing in the Salesforce Full sandbox.
Answer: A,C
Explanation:
Pre-go-live automated page-load testing against the Salesforce Full sandbox can help identify and resolve any performance bottlenecks or issues before deploying the solution to production. The Full sandbox is an ideal environment for performance testing as it replicates the production org in terms of data, metadata, and integrations. Stress testing against the web services hosted by the integration middleware can also help evaluate the scalability and reliability of the integration solution under high load conditions.
NEW QUESTION # 130
Universals Containers' system administrators have been complaining that they are not able to make changes to its users' record, including moving them to new territories without getting "unable to lock row" errors. This is causing the system admins to spend hours updating user records every day.
What should the data architect do to prevent the error?
- A. Enable granular locking.
- B. Increase CPU for the Salesforce org.
- C. Reduce number of users updated concurrently.
- D. Analyze Splunk query to spot offending records.
Answer: A
Explanation:
Enabling granular locking (option B) is the best option to prevent the error, as it allows finer control over how records are locked during automated or manual processes, and reduces the chances of lock contention or deadlock. Reducing number of users updated concurrently (option A) is not a good option, as it may limit the productivity and efficiency of the system admins, and it does not address the root cause of the error. Analyzing Splunk query to spot offending records (option C) is also not a good option, as it may require more time and effort, and it does not provide a permanent solution for the error. Increasing CPU for the Salesforce org (option D) is also not a good option, as it may introduce additional cost and complexity, and it does not solve the root cause of the error.
NEW QUESTION # 131
Ursa Major Solar has defined a new Data Quality Plan for their Salesforce data.
Which two approaches should an Architect recommend to enforce the plan throughout the organization?
(Choose two.)
- A. Ensure all data is stored in an external system and set up an integration to Salesforce for view-only access.
- B. Enforce critical business processes by using Workflow, Validation Rules, and Apex code.
- C. Schedule a weekly dashboard displaying records that are missing information to be sent to managers for review.
- D. Schedule reports that will automatically catch duplicates and merge or delete the records every week.
Answer: B,C
Explanation:
Enforcing critical business processes by using Workflow, Validation Rules, and Apex code can help ensure data quality and consistency by applying rules and logic to the data entry and update3. Scheduling a weekly dashboard displaying records that are missing information to be sent to managers for review can help identify and fix data quality issues by providing visibility and accountability4.
NEW QUESTION # 132
Universal Containers (UC) has over 10 million accounts with an average of 20 opportunities with each account. A Sales Executive at UC needs to generate a daily report for all opportunities in a specific opportunity stage.
Which two key considerations should be made to make sure the performance of the report is not degraded due to large data volume?
- A. Number of joins used in report query.
- B. Number of characters in report query.
- C. Number of records returned by report query.
- D. Number of queries running at a time.
Answer: A,C
NEW QUESTION # 133
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. Move data off of the platform and run reporting outside Salesforce, and give access to reports.
- B. Create a custom object to store aggregate data and run reports.
- C. Build reports using custom Lightning components.
- D. Contact Salesforce support to enable skinny table for cases.
Answer: D
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 # 134
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 Custom Object to store leads, and allow unprocessed leads to be reported.
- D. Use Apex services to email failures to business when error occurs.
Answer: D
Explanation:
saving Apex errors in a custom object can be a way to report errors from an Apex job. The article provides an example of how to create a custom object called AsyncApexError__c and use a trigger to insert error records into it. The custom object can then be used for reporting or notification purposes.
NEW QUESTION # 135
UC is preparing to implement sales cloud and would like to its users to have read only access to an account record if they have access to its child opportunity record. How would a data architect implement this sharing requirement between objects?
- A. Implicit sharing will automatically handle with standard functionality.
- B. Create a criteria-based sharing rule.
- C. Create an owner-based sharing rule.
- D. Add appropriate users to the account team.
Answer: A
Explanation:
Implicit sharing will automatically handle this sharing requirement with standard functionality, as it grants read-only access to parent accounts when users have access to child opportunities. This is also known as account-opportunity sharing3. Creating a criteria-based sharing rule (option A) or an owner-based sharing rule (option D) is not necessary, as they are used to grant additional access based on record criteria or ownership.
Adding appropriate users to the account team (option C) is also not required, as it is used to grant access to specific users or groups for individual accounts.
NEW QUESTION # 136
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. After exporting the setup audit trail, find the fields in question.
- B. After exporting the metadata, search it for the fields in question.
- C. Remove "customize application" permissions from everyone else.
- D. Create a field history report for the fields in question.
Answer: A
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 # 137
Universal Containers would like to have a Service-Level Agreement (SLA) of 1 day for any data loss due to unintentional or malicious updates of records in Salesforce. What approach should be suggested to address this requirement?
- A. Build a daily extract job and extract data to on-premise systems for long-term backup and archival purposes.
- B. Evaluate a third-party AppExchange app, such as OwnBackup or Spanning, etc., for backup and archival purposes.
- C. Store all data in shadow custom objects on any updates and deletes, and extract them as needed .
- D. Schedule a Weekly Extract Service for key objects and extract data in XL sheets to on-premise systems.
Answer: B
Explanation:
Evaluating a third-party AppExchange app, such as OwnBackup or Spanning, etc., for backup and archival purposes is the best approach to address the requirement of having a one-day SLA for any data loss. These apps can provide automated backups, granular restores, and compliance features that can help UC recover from any data loss or corruption scenarios.
NEW QUESTION # 138
......
Salesforce Data-Architect certification exam is designed to test the skills and knowledge required to design and implement data solutions on the Salesforce platform. Data-Architect exam covers various topics such as data modeling, data integration, data migration, data governance, and data security. Data-Architect exam is designed to test the candidate's ability to design and implement scalable, robust, and efficient data solutions on the Salesforce platform.
Salesforce Certified Data Architect certification exam is a comprehensive test that covers a wide range of topics including data modeling, data integration, data governance, data security, and data management. Data-Architect exam is designed to assess the candidate's ability to design and implement complex data solutions in the Salesforce platform. Data-Architect exam consists of multiple-choice questions and performance-based scenarios that test the candidate's knowledge and skills.
Data-Architect Exam Practice Materials Collection: https://freecert.test4sure.com/Data-Architect-exam-materials.html