DATA-ARCHITECT Online Practice Questions and Answers
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. Define a standard mapping and train sales users to import opportunity data.
C. Load data in external database and provide access to database to sales users.
D. Create a chatter group and upload all Excel files to the group.
Based on government regulations, a Salesforce customer plans to implement the following in Salesforce for compliance:
Access to customer information based on record ownership Ability for customers to request removal of their information from Salesforce Prevent users from accessing Salesforce from outside company network (virtual private network, or VPN)
What should a data architect recommend to address these requirements?
A. Contact Salesforce support to restrict access only with VPN and other requirements
B. Allow users access to Salesforce through a custom web application hosted within VPN.
C. Implement IP restrictions, sharing settings, and custom Apex to support customer requests.
D. Implement Salesforce shield with Event Monitoring to address the requirement.
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. Salesforce allows up to four objects in a single report type.
B. Salesforce does not support Orders or Order Line Items.
C. A report cannot contain data from Accounts and Contacts.
D. Custom report types cannot contain Opportunity data.
Universal Containers (UC) has multi -level account hierarchies that represent departments within their major Accounts. Users are creating duplicate Contacts across multiple departments. UC wants to clean the data so as to have a single Contact across departments. What two solutions should UC implement to cleanse their data? Choose 2 answers
A. Make use of a third -party tool to help merge duplicate Contacts across Accounts.
B. Use Data.com to standardize Contact address information to help identify duplicates.
C. Use Workflow rules to standardize Contact information to identify and prevent duplicates.
D. Make use of the Merge Contacts feature of Salesforce to merge duplicates for an Account.
Universal Containers (UC) has a data model as shown in the image. The Project object has a private sharing model, and it has Roll -Up summary fields to calculate the number of resources assigned to the project, total hours for the project, and the number of work items associated to the project.
What should the architect consider, knowing there will be a large amount of time entry records to be loaded regularly from an external system into Salesforce.com?
A. Load all data using external IDs to link to parent records.
B. Use workflow to calculate summary values instead of Roll -Up.
C. Use triggers to calculate summary values instead of Roll -Up.
D. Load all data after deferring sharing calculations.
NTO uses salesforce to manage relationships and track sales opportunities. It has 10 million customers and 100 million opportunities. The CEO has been complaining 10 minutes to run and sometimes failed to load, throwing a time out error.
Which 3 options should help improve the dashboard performance?
Choose 3 answers:
A. Use selective queries to reduce the amount of data being returned.
B. De-normalize the data by reducing the number of joins.
C. Remove widgets from the dashboard to reduce the number of graphics loaded.
D. Run the dashboard for CEO and send it via email.
E. Reduce the amount of data queried by archiving unused opportunity records.
Universal container (UC) would like to build a Human resources application on Salesforce to manage employee details, payroll, and hiring efforts. To adequately and store the relevant data, the application will need to leverage 45 custom objects. In addition to this, UC expects roughly 20,00 API calls into Salesfoce from an n-premises application daily.
Which license type should a data architect recommend that best fits these requirements?
A. Service Cloud
B. Lightning platform Start
C. Lightning Platform plus
D. Lightning External Apps Starts
UC has large amount of orders coming in from its online portal. Historically all order are assigned to a generic user.
Which 2 measures should data architect recommend to avoid any performance issues while working with large number of order records? Choose 2 answers:
A. Clear the role field in the generic user record.
B. Salesforce handles the assignment of orders automatically and there is no performance impact.
C. Create a role at top of role hierarchy and assign the role to the generic user.
D. Create a pool of generic users and distribute the assignment of memory to the pool of users.
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 solutions should a data architect recommend to mitigate data quality issues?
A. Leverage picklist and lookup fields where possible
B. Leverage Apex to validate the format of data being entered via a mobile device.
C. Leverage validation rules and workflows.
D. Leverage third-party- AppExchange tools
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. Update the Opportunity page layout to mark these fields as required.
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. Write an Apex trigger that checks each field when records are saved.