Quiz
DA 1
Create a free account to finish this quiz
Save your progress and see your final score.
Already have an account? Sign in
Questions in this quiz (185)
1Northern 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?- AChange the lookup relationship to master-detail relationship.
- BCreate a custom object to maintain the relationship between products and customers.
- CSelect Clear the value of this field option while configuring the lookup relationship.
- DCreate multiple similar products and distribute the skew across those products.
2Universal 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 orgs: 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 migration will need occur within the next two months, prior to the spilt.
Which migration strategy should a data architect use to successfully migrate the data?- AUse Data Loader for export and Data Import Wizard for import.
- BWrite a script to use the Bulk API.
- CUse an ETL, tool to orchestrate the migration.
- DUse the Salesforce CLI to query, export, and import.
3A 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?- ABuild a custom search functionality that allows sales associates to search for customer in real time upon visiting their retail stores.
- BLeverage duplicate rules in Salesforce to validate duplicates during the account creation process.
- CDevelop an Apex class that searches for duplicates and removes them nightly.
- DImplement an MDM solution to validate the customer Information before creating Accounts in Salesforce.
4A large multinational B2C Salesforce customer is looking to implement their distributor management application in Salesforce. The application has the following capabilities:
1. Distributors create Sales Orders in Salesforce.
2. Sales Orders are based on Product prices applicable to their region.
3. Sales Orders are closed once they are fulfilled.
4. It is decided to maintain Sales Orders in Opportunities object.
How should the data architect model this requirement?- ACreate lookup to Custom Price object and share with distributors.
- BAdd custom fields in Opportunity and use triggers to update prices.
- CConfigure Price Books for each region and share with distributors.
- DManually update Opportunities with Prices applicable to distributors.
5Universal Containers is experiencing frequent and persistent group membership locking issues that severely restricts its ability to manage manual and automated updates at the same time.
What should a data architect do in order to resolve the issue?- AEnable defer sharing calculation.
- BEnable granular locking.
- CEnable parallel sharing rule calculation.
- DEnable implicit sharing. to distributors.
6
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?- AHave the users manually clean the data in the old system prior to migration.
- BMigrate the data as is, and use Salesforce's de-duplicating feature.
- CStore the data in a staging database, and de-duplicate identical records.
- DHire an intern manually de-duplicate the records after migrating to Salesforce.
7Universal Containers (UC) is transitioning from Classic to Lightning Experience.
What does UC need to do to ensure users have access to its notes and attachments in Lightning Experience?- AAdd Notes and Attachments Related Lists to Page Layouts in Lightning Experience.
- BManually upload Notes in Lightning Experience.
- CManually upload Attachments in Lightning Experience.
- DMigrate Notes and Attachments to Enhanced Notes and Files using a migration tool.
8Universal Containers is implementing Sales Cloud for patient management and would like to encrypt sensitive patient records being stored in files.
Which solution should a data architect recommend to solve this requirement?- AImplement a third-party AppExchange app to encrypt files.
- BStore files outside of Salesforce and access them in real time.
- CUse classic encryption to encrypt files.
- DImplement Shield Platform Encryption to encrypt files.
9Northern 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?- AExternal APIs
- BFederated Search
- CSalesforce Connect
- DSalesforce 2 Salesforce
10Northern Trail Outfitters (NTO) runs its entire business out of an enterprise data warehouse (EDW). NTO's sales team is starting to use Salesforce after a recent implementation, but currently lacks the data required to advance leads and opportunities to the next stage.
NTO's management has researched Salesforce Connect and would like to use it to virtualize and report on data from the EDW within Salesforce. NTO will be running thousands of reports per day across 10 to 15 external objects.
What should a data architect consider before implementing Salesforce Connect for reporting?- AOData callout limits per day
- BMaximum page size for server-driven paging
- CMaximum number of records returned C
- DMaximum external objects per org
11Universal 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?- ASave Apex errors in a custom object, and allow access to this object for reporting.
- BUse AppExchange package to clean lead information before Apex job processes them.
- CUse Custom Object to store leads, and allow unprocessed leads to be reported.
- DUse Apex services to email failures to business when error occurs.
12Universal Containers (UC) owns multiple Salesforce orgs that are distributed across regional branches. Each branch stores local customer data inside of its org's Account and Contact objects. This creates a scenario where UC is unable to view customers across all orgs.
UC has an initiative to create a 360 degree view of the customer, as UC would like to see Account and Contact data from all of its orgs in one place.
Which solution should a data architect suggest to achieve a 360 degree view of the customer?- ABuild a bidirectional integration between all orgs.
- BUse an ETL tool to migrate gap Accounts and Contacts into each org.
- CUse the Salesforce Connect cross-org adapter.
- DConsolidate the data from each org into a centralized datastore.
13Northern Trail Outfitters (NTO) operates a majority of its business from a central Salesforce org. NTO also owns several secondary orgs that the service, finance, and marketing teams work out of. At the moment, there is no integration between central and secondary orgs, leading to data-visibility issues.
Moving forward, NTO has identified that a hub-and-spoke model is the proper architecture to manage its data, where the central org is the hub and the secondary orgs are the spokes.
Which tool should a data architect use to orchestrate data between the hub org and spoke orgs?- ADevelop custom APIs to poll the spoke org for change data and push into the hub org.
- BA backup and archive solution that extracts and restores data across orgs.
- CDevelop custom APIs to poll the hub org for change data and push into the spoke orgs.
- DA middleware solution that extracts and distributes data across both the hub and spokes.
14
Northern Trail Outfitters (NTO) needs to extract 50 million records from a custom object every day from its Salesforce org. NTO is facing query time-out issues while extracting these records.
What should a data architect recommend in order to get around the time-out issue?- AUse the Rest API to extract data as it automatically chunks records by 200.
- BUse extract, transform, load (ETL) tool for extraction of records.
- CUse a PK Chunking within the Bulk API.
- DAsk Salesforce support to increase the query timeout value.
15Universal Containers is preparing to implement Sales Cloud and would like 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?- ACreate an owner-based sharing rule.
- BImplicit sharing will automatically handle this with standard functionality.
- CCreate a criteria-based sharing rule.
- DAdd appropriate users to the Account team.
16Universal Containers (UC) is implementing Salesforce for lead management. UC procures lead data from multiple sources and would like to make sure lead data has company profile and location information.
Which solution should a data architect recommend to make sure lead data has both profile and location information?- AExport data out of Salesforce and send to another team to populate company profile and location data.
- BAsk sales people to search for and populate company profile and location data.
- CLeverage external data providers to populate company profile and location data.
- DRun reports to identify records which do not have company profile and location data.
17Universal Containers's system administrators have been complaining that they are not able to make changes to its users' records, 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 errors?- AEnable granular locking.
- BAnalyze Splunk query to spot offending records.
- CIncrease CPU for the Salesforce org.
- DReduce number of users updated concurrently.
18Universal Containers (UC) has millions of case records with case history and service level agreement data. UC's compliance team would like historical cases to be accessible for 10 years for audit purposes.
What solution should a data architect recommend?- AArchive case data using a Salesforce Archival solution.
- BUse a custom object to store archived case data.
- CUse a custom big object to store archived case data.
- DPurchase more data storage to support the case object.
19What should a data architect do to provide additional guidance for users when they enter information in a Standard field?
- AAdd custom help text in default value for the field.
- BCreate a custom page with help text for user guidance.
- CAdd a label field with help text adjacent to the custom field.
- DProvide custom help text under field properties.
20Universal Containers (UC) is migrating data from legacy system to Salesforce. During data analysis it was discovered that data types of fields being migrated do not match with Salesforce data types.
Which solution should a data architect use to ensure successful data migrations?- AExport legacy data into the staging database and leverage stored procedures to transform data types before loading into Salesforce.
- BMigrate legacy data to a staging database for mapping then leverage an ETL tool to transform the data and load into Salesforce.
- CExport legacy data into CSV files and leverage data loader to load data into Salesforce.
- DMigrate the legacy data leveraging an ETL tool to transform data types and load data into Salesforce.
21Universal Containers has provided a web order form for its customer and has noticed invalid data coming in on orders.
What should be used to mitigate this problem?- AWork Flow Rules
- BApex Trigger
- CFormatted Fields
- DValidation Rules
22A large retail company has recently chosen Salesforce as its CRM solution. They have the following record counts:
2,500,000 Accounts
25,000,000 Contacts
When doing an initial performance test, the data architect noticed an extremely slow response-time for reports and list views.
What should a data architect do to solve the performance Issues?- AAdd Custom Indexes on frequently searched Account and Contact fields.
- BLimit data loading to the 2,000 most recently created records.
- CLoad only data that the user is permitted to access.
- DCreate a Skinny Table to represent Account and Contact objects.
23Universal 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?- APerform a batch job in parallel mode and reduce the batch size.
- BLeverage Data Loader's platform API to load data.
- CPerform a batch job in serial mode and reduce the batch size.
- DDefer rollup summary field calculation during data migration.
24Universal 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?- AMove data off of the platform and run reporting outside Salesforce, and give access to reports.
- BBuild reports using custom Lightning components.
- CCreate a custom object to store aggregate data and run reports.
- DContact Salesforce support to enable skinny table for cases.
25
Universal Containers (UC) is going through major reorganization of their sales team. This would require changes to a large a number of group membership and sharing rules. UCs administrator is concerned about long processing time and failures during the process.
What should a Data Architect implement to make changes efficiently?- AEnable Defer Sharing Calculation prior to making sharing rule changes.
- BDelete old sharing rules and build new sharing rules.
- CLog a case with salesforce to make sharing rule changes.
- DLog out all users and make change to sharing rules.
26Northern Trail Outfitters has decided that it is going to build a channel sales portal with the following requirements:
1. External resellers are able to authenticate to the portal with a login.
2. Lead data, Opportunity data, and Order data are available to authenticated users.
3. Authenticated users may need to run reports and dashboards.
4. There is no need for more than 10 custom objects or additional file storage.
Which Community Cloud license type should a data architect recommend to meet the portal requirements?- ALightning External Apps Starter
- BPartner Community
- CCustomer Community Plus
- DCustomer Community
27Universal Containers (UC) owns a complex Salesforce org with many Apex classes, triggers, and automated processes that will modify records if available. UC has identified that, in its current development state, UC runs chance of encountering race conditions on the same record.
What should a data architect recommend to guarantee that records are not being updated at the same time?- ADisable classes or triggers that have the potential to obtain the same record.
- BRefactor or optimize classes and triggers for maximum CPU performance.
- CEmbed the keywords FOR UPDATE after SOQL statements.
- DMigrate programmatic logic to processes and flows.
28
A large healthcare provider wishes to use Salesforce to track patient care. The following actors are in Salesforce:
1. Payment providers: Organizations who pay for the care to patients.
2. Doctors: They provide care plans for patients and need to support multiple patients. They are provided access to patient information.
3. Patients: These are individuals who need care.
A data architect needs to map the actors to Salesforce objects.
What should be the optimal selection by the data architect?- APatients as Contacts, Payment providers as Accounts, and Doctors as Accounts
- BPatients as Person Accounts, Payment providers as Accounts, and Doctors as Person Accounts
- CPatients as Person Accounts, Payment providers as Accounts, and Doctors as Contacts
- DPatients as Accounts, Payment providers as Accounts, and Doctors as Person Accounts
29Universal Containers is establishing a call center that will use Salesforce. UC receives 10 million calls and creates 100 million cases every month. Cases are linked to a custom call object using lookup relationship. UC would like to run reports and dashboard to better understand different case types being created on calls to better serve customers.
What solution should a data architect recommend to meet the business requirement?- ALeverage big objects to archive records and Einstein Analytics to run reports.
- BArchive records to a data warehouse and run analytics on the data warehouse.
- CLeverage out-of-the-box reports and dashboard on case and interactive voice response (IVR) custom object.
- DLeverage custom objects to store aggregate data and run analytics.
30Northern Trail Outfitters needs to implement an archive solution for Salesforce data. This archive solution needs to help NTO do the following:
1. Remove outdated information not required on a day-to-day basis.
2. Improve Salesforce performance.
Which solution should be used to meet these requirements?- ACreate a full copy sandbox, and use it as a source for retaining archived data.
- BIdentify a location to store archived data and use scheduled batch jobs to migrate and purge the aged data on a nightly basis.
- CUse a formula field that shows true when a record reaches a defined age and use that field to run a report and export a report into SharePoint.
- DIdentify a location to store archived data, and move data to the location using a time-based workflow.
31Universal Containers is migrating individual customers (B2C) data from legacy systems to Salesforce. There are millions of customers stored as accounts and contacts in the legacy database.
Which object model should a data architect configure within Salesforce?- ALeverage a custom person account object in Salesforce.
- BLeverage the person account object in Salesforce.
- CLeverage the standard account and contact object in Salesforce.
- DLeverage a custom account and contact object in Salesforce.
32Which API should a data architect use if exporting 1 million records from Salesforce?
- AREST API
- BStreaming API
- CBulk API
- DSOAP API
33
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?- ASingle-select restricted picklist with defined choices.
- BLookup to a custom object with defined choices.
- CProvide help text to guide users with defined choices.
- DCreate a validation rule to limit entry to defined choices.
34Universal Containers (UC) has a Salesforce org with multiple automated processes defined for group membership processing. UC also has multiple admins on staff that perform manual adjustments to the role hierarchy. The automated tasks and manual tasks overlap daily, and UC is experiencing "lock errors" consistently.
What should a data architect recommend to mitigate these errors?- ARemove SOQL statements from Apex Loops.
- BAsk Salesforce support for additional CPU power.
- CEnable sharing recalculations.
- DEnable granular locking.
35Universal Containers is building a Salesforce application to track Contacts and the respective Conferences that they have attended with the following requirements:
1. Contacts will be stored in the standard Contact object.
2. Conferences will be stored in a custom Conference__c object.
3. Each Contact may attend multiple Conferences and each Conference may be related to multiple Contacts.
How should a data architect model the relationship between the Contact and Conference__c objects?- ACreate a master-detail relationship field on the Conference__c object.
- BCreate a lookup relationship field on the Contact object.
- CImplement a Contact Conference junction object with master-detail relationships to both Contact and Conference__c.
- DCreate a master-detail relationship field on the Contact object.
36Universal Containers (UC) has decided that they are going to retire a homegrown CRM application and move to Salesforce. As part of the implementation, they will need to migrate 5 billion records in a series of batches. The records are a collection of Accounts, Contacts, Opportunities, Products, and Orders.
Since the legacy CRM application and Salesforce have different data models, the data will need to be transformed and normalized before it is loaded into the system.
What should a data architect recommend as a migration and storage strategy?- AMigrate data to a centralized datastore first with ETL tools.
- BImport all data into custom objects with middleware.
- CImport all data into custom objects with data loader.
- DUse an ETL tool to extract and transform the data, then load into standard objects.
37Universal Containers (UC) has implemented Salesforce. UC is running out of storage and needs to have an archiving solution. UC would like to maintain two years of data in Salesforce and archive older data out of Salesforce.
Which solution should a data architect recommend as an archiving solution?- ABuild a batch job to move two-year-old records off platform, and delete old records from Salesforce.
- BBuild a batch job to move all records off platform, and delete old records from Salesforce.
- CUse a third-party backup solution to back up all data off platform.
- DBuild a batch job to move all records off platform, and delete all records from Salesforce.
38Universal 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?- ASend customer record changes from Salesforce to each system in a nightly batch job.
- BSend customer record changes from Salesforce to the system of truth in real time.
- CSend customer data nightly to the system of truth in a scheduled batch job.
- DHave each system pull the record changes from Salesforce using change data capture.
39Universal Containers (UC) is replacing a home grown CRM solution with Salesforce. UC has decided to migrate operational (open and active) records to Salesforce, while keeping historical records in legacy system. UC would like historical records to be available in Salesforce on an as needed basis.
Which solution should a data architect recommend to meet business requirement?- ABuild a swivel chair solution to go into the legacy system and display records.
- BLeverage real-time integration to pull records into Salesforce.
- CBring all data in Salesforce, and delete it after a year.
- DLeverage mashup to display historical records in Salesforce.
40The data architect for Universal Containers has written a SOQL query that will return all records from the Task object that do not have a value in the whatID field:
SELECT ID, Description, Subject FRON Task WHERE WhatId = NULL
When the data architect uses the query to select values for a process, a time-out error occurs.
What does the data architect need to change to make this query more performant?- ARemove description from the requested field set.
- BChange query to SOSL.
- CAdd LIMIT 100 to the query.
- DChange the WHERE clause to filter by a deterministic defined value.
41Northern Trail Outfitters (NTO) plans to maintain contact preferences for customers and employees. NTO has implemented the following:
1. Customers are Person Accounts for their retail business.
2. Customers are represented as Contacts for their commercial business.
3. Employees are maintained as Users.
4. Prospects are maintained as Leads.
NTO needs to Implement a standard communication preference management model for Person Accounts, Contacts, Users, and Leads.
Which option should the data architect recommend NTO to satisfy this requirement?- ACreate a custom object to maintain preferences and build relationships to Lead, Person Account, and Users.
- BCreate custom fields for contact preferences in Lead, Person Account, and Users objects.
- CCreate case for contact preferences, and use this to validate the preferences for Lead, Person Accounts, and Users.
- DUse Individual objects to maintain the preferences with relationships to Lead, Person Account, and Users.
42Universal Containers (UC) is implementing Salesforce and will be using Salesforce to track customer complaints, provide white papers on products, and provide subscription based support.
Which license type will UC users need to fulfill UC's requirements?- ASales Cloud License
- BSalesforce License
- CLightning Platform Starter License
- DService Cloud License
43A national nonprofit organization is using Salesforce to recruit members. The recruitment process requires a member to be matched with a volunteer opportunity. Given the following:
1. A record is created in Project_c and used to track the project through completion.
2. The member may then start volunteering and is required to track their volunteer hours, which is stored in VTOTime_c object related to the project.
3. Ability to view or edit the VTOTime_c object needs to be the same as the Project_c record.
4. Managers must see total hours volunteered while viewing the Project c record.
Which data relationship should the data architect use to support this requirement when creating the custom VTOTime_c object?- ALookUp field on VTOTime_c to Project_c with formula filed on Project_c showing Sum of hours from VTOTime c records.
- BMaster Detail Field on VTOTime_c to Project_c with rollup summary field on Project_c showing sum of hours from VTOTime_c records.
- CLookup Field on Project_c to VTOTime_C displaying a list of VTOTime_C in a related list.
- DMaster Detail field on Project_c to VTOTime_c showing a list of VTOTime_c Records in a related list.
44
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?- AUse the Customer 360 data manager to sync product and pricing information from product master database to Salesforce.
- BBuild a custom integration for one way sync of product and pricing information from product master to Salesforce.
- CBuild a custom integration for two-way sync of product and pricing information between product master to Salesforce.
- DImplement a manual process to update the products from an extract from the products master on a weekly basis.
45Universal Containers (UC) has the following systems:
1. Billing system
2. Customer support system
3. CRM system
UC has been having trouble with business intelligence across the different systems. Recently UC 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?- AGlobally Unique Identifier
- BFull name
- CPhone number
- DEmail address
46Universal Containers (UC) has adopted Salesforce as its primary sales automation tool. UC has 100,000 customers with a growth rate of 10% a year. UC uses an on-premise web-based billing and invoice system that generates over 1 million invoices a year supporting a monthly billing cycle.
The UC sales team needs to be able to pull up a customer record and view their account status, invoice history, and open opportunities without navigating outside of Salesforce.
What should a data architect use to provide the sales team with the required functionality?- AWrite an Apex callout and populate a related list to display on the account record.
- BCreate a custom object and migrate the last 12 months of invoice data into Salesforce so it can be displayed on the Account layout.
- CCreate a mashup page that will present the billing system records within Salesforce.
- DCreate a visual force tab with the billing system encapsulated within an iframe.
47A consumer products company has decided to use Salesforce for its contact center. The contact center agents need access to the following Information in Service Console when a customer contacts them:
1. Customer browsing activity on its website stored on its on-premise system
2. Customer Interactions with sales associates at its retail stores maintained in Salesforce
3. Contact center interactions maintained in Salesforce
4. Email campaign activity to customer from its marketing systems.
What should a data architect do to fulfill these requirements with minimum development effort in Salesforce?- ABuild customer view in Service Console with components that show website data and marketing data as mashup.
- BUse Salesforce Connect to integrate the website and the marketing system into Service Console using external objects.
- CCreate web tabs in Service Console to show website and marketing activities.
- DBuild custom components in Service Console to bring information from the marketing and website information.
48Universal Containers (UC) has implemented Sales Cloud for its entire sales organization. UC has built a custom object called Projects_c that stores customer project details and employee billable hours.
The following requirements are needed:
1. A subset of individuals from the finance team will need access to the Projects object for reporting and adjusting employee utilization.
2. The finance users will not need access to any sales objects, but they will need to interact with the custom object.
Which license type should a data architect recommend for the finance team that best meets the requirements?- ALightning Platform Starter
- BService Cloud
- CSales Cloud
- DLightning Platform Plus
49
Northern Trail Outfitters is planning to build a consent form to record customer authorization for marketing purposes.
What should a data architect recommend to fulfill this requirement?- AUse custom fields to capture the authorization details.
- BCreate a custom object to maintain the authorization.
- CUtilize the Authorization Form Consent object to capture the consent.
- DUse AppExchange solution to address the requirement.
50
Northern Trail Outfitters (NTO) uses Sales Cloud and Service Cloud to manage their sales and support processes. Some of NTOs teams are complaining they see new fields on their page and are 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?- ACreate validation rules with error messages to explain why the field is used.
- BCreate reports to identify which fields users are leaving blank, and use external data sources to augment the missing data.
- CAdd description fields to explain why the field is used, and mark the fields as Required.
- DCreate and manage a data dictionary, and use a governance process for changes made to common objects.
51Northern Trail Outfitters (NTO) has implemented Salesforce for its sales users. The opportunity management in Salesforce 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?- AChange PPS integration to update only Opportunity Amount field when the value is null.
- BCreate a custom field for Opportunity Amount that sales users update separating the field that PPS updates.
- CChange Opportunity Amount field access to Read Only for sales users using field-level security.
- DCreate a custom field for Opportunity amount that PPS updates separating the field sales user updates.
52Northern Trail Outfitters has these simple requirements for a data export process:
1. File format should be in CSV.
2. Process should be scheduled and run once per week.
3. The export should be configurable through the Salesforce UI.
Which tool should a data architect leverage to accomplish these requirements?- ABulk API
- BData loader
- CData export wizard
- DThird-party ETL tool
53Northern 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?- ALoad data in external database and provide access to database to sales users.
- BUse the Excel connector to Salesforce to sync data from individual Excel files.
- CDefine a standard mapping and train sales users to import opportunity data.
- DCreate a chatter group and upload all Excel files to the group.
54
Northern Trail Outfitters (NTO) wants to start a loyalty program to reward repeat customers. The program will track every item a customer has bought and grants them points for discounts. The following conditions will exist upon implementation:
1. Data will be used to drive marketing and product development initiatives.
2. NTO estimates that the program will generate 100 million rows of data monthly.
3. NTO will use Salesforce's Einstein Analytics and Discovery to leverage their data and make business and marketing decisions.
What should the Data Architect do to store, collect, and use the reward program data?- ACreate a custom object in Salesforce that will be used to capture the Reward Program data.
- BCreate a big object in Einstein Analytics to capture the Loyalty Program data.
- CCreate a custom big object in Salesforce which will be used to capture the Reward Program data for consumption by Einstein.
- DHave Einstein connect to the point of sales system to capture the Reward Program data.
55
During the implementation of Salesforce, a customer has the following requirements for Sales Order:
1. Sales Order information needs to be shown to users in Salesforce.
2. Sales Orders are maintained in the on-premise enterprise resource planning (ERP).
3. Sales Order information has more than 150 million records.
4. Sales Orders will not be updated in Salesforce.
What should a data architect recommend for maintaining Sales Orders In Salesforce?- AUse external objects to maintain Sales Orders in Salesforce.
- BUse custom big objects to maintain Sales Orders in Salesforce.
- CUse Standard Order object to maintain Sale Orders in Salesforce.
- DUse custom objects to maintain Sales Orders in Salesforce.
56Universal Containers (UC) is building a Service Cloud call center application and has a multi-system support solution. UC would like to ensure that all systems have access to the same customer information.
What solution should a data architect recommend?- AMake Salesforce the system of record for all data.
- BImplement a master data management (MDM) strategy for customer data.
- CLoad customer data in all systems.
- DLet each system be an owner of data it generates.
57Universal Containers has a Sales Cloud implementation for a sales team and an enterprise resource planning (ERP) as a customer master. Sales teams are complaining about duplicate account records and data quality issues with account data.
Which solution should a data architect recommend to resolve the complaints?- ABuild a nightly sync job from ERP to Salesforce.
- BDo a bulk delete of all account records in Salesforce and a complete reload from the ERP.
- CBuild a nightly batch job to de-dupe data, and merge account records.
- DImplement a de-dupe solution and establish account ownership in Salesforce.
58Universal Containers has implemented Salesforce for its operations. In order for customers to be created in their MDM solution, the customer record needs to have the following attributes:
1. First Name
2. Last Name
3. Email
Which option should the data architect recommend to mandate this when customers are created in Salesforce?- AConfigure Page Layout marking attributes as required fields.
- BMark Fields for the attributes as required under Setup.
- CCreate validation rules to check if the required attributes are entered.
- DBuild validation in Integration with MDM to check required attributes.
59Universal Containers (UC) has a requirement to migrate 100 million order records from a legacy enterprise resource planning (ERP) application into the Salesforce platform. UC does not have any requirements around reporting on the migrated data.
What should a data architect recommend to reduce performance degradation of the platform?- AImplement a custom big object to store the data.
- BUse the standard "Order" object to store the data.
- CCreate a custom object to store the data.
- DUse a standard big object defined by Salesforce
60As part of addressing General Data Protection Regulation (GDPR) requirements, Universal Containers (UC) plans to implement a data classification policy for all of its internal systems that store customer information including Salesforce.
What should a data architect recommend so that UC can easily classify customer information maintained in Salesforce under both standard and custom objects?- ACreate a custom picklist field to capture classification of information on the Contact object.
- BBuild reports that contain customer data and classify manually.
- CUse an AppExchange product to classify fields based on policy.
- DUse Data Classification metadata fields available in Field definition.
61A custom pricing engine for a Salesforce customer has to be decided by factors with the following hierarchy:
1. State in which the customer is located
2. City in which the customer is located if available
3. Zip code in which the customer is located if available
4. Changes to this information should have minimum code change
What should a data architect recommend to maintain this information for the custom pricing engine that is to be built in Salesforce?- AAssign the pricing criteria within custom pricing engine.
- BConfigure the pricing criteria in price books.
- CMaintain required pricing criteria in custom metadata types.
- DCreate a custom object to maintain the pricing criteria.
62
United Containers (UC) has released a new disaster recovery (DR) policy that states that cloud solutions need a business continuity plan in place separate from the cloud provider's built-in data recovery solution.
Which solution should a data architect use to comply with the DR policy?- ALeverage Salesforce weekly exports, and store data in flat files on a protected system.
- BLeverage a third-party tool that extracts Salesforce data/metadata, and stores the information in an external protected system.
- CWrite a custom batch job to extract data changes nightly, and store on an external protected system.
- DUtilize an ETL tool to migrate data to an on-premise archival solution.
63
Northern Trail Outfitters (NTO) is streaming IoT data from connected devices to a cloud database. Every 24 hours, 100,000 records are generated.
NTO employees will need to see these IoT records within Salesforce and generate weekly reports on it. Developers may also need to write programmatic logic to aggregate the records and incorporate them into workflows.
Which data pattern will allow a data architect to satisfy these requirements, while also keeping limits in mind?- ABidirectional integration
- BPersistence
- CUnidirectional integration
- DVirtualization
64
Universal Containers has multiple systems all containing and maintaining customer data. Although point-to-point integrations are in place, customers are complaining about consistency in the data.
What solution should the data architect recommend?- APerform a one time synchronization to level set the built up inconsistencies
- BData cleanse each system
- CAn MDM solution as the customer master, with centralized integrations to ensure consistency across all systems.
- DImprove existing point-to-point integrations
65Universal Containers (UC) needs to aggregate monthly and yearly metrics using standard reports. UC's monthly and yearly details are stored in custom objects with four million monthly records and nine million yearly records. The reports are aggregating millions of records across the two objects and taking long time to return results.
What solution should a data architect recommend to improve report performance?- AMove data out of Salesforce and run reporting on it.
- BCreate an aggregation custom object that summarized the monthly and yearly values.
- CLeverage big object to store data and run reports on it.
- DDelete old data from Salesforce and run reports on it.
66Northern Trail Outfitters is migrating to Salesforce from a legacy CRM system that identifies the agent relationships in a look-up table.
What should the data architect do in order to migrate the data to Salesforce?- ACreate custom object to store agent relationships.
- BAssign record owners based on relationship.
- CMigrate the data and assign to a non-person system user.
- DMigrate to Salesforce without a record owner.
67Northern Trail Outfitters has implemented Salesforce for its sales associates nationwide. Senior management is concemed that the executive dashboards are not reliable for their real-time decision-making. On analysis, the team found the following issues with data entered in Salesforce:
1. Information in certain records is incomplete.
2. Incorrect entry in certain fields causes records to be excluded in report filters.
3. Duplicate entries cause incorrect counts.
Which three steps should a data architect recommend to address the Issues?
Choose 3 answers- ALeverage Salesforce features, such as validation rules, to avoid incomplete and incorrect records.
- BBuild a sales data warehouse with purpose-built data marts for dashboards and senior management reporting.
- CExplore third-party data providers to enrich and augment information entered in Salesforce.
- DPeriodically export data to cleanse data and import them back into Salesforce for executive reports.
- EDesign and implement data-quality dashboard to monitor and act on records that are incomplete or incorrect.
68During the implementation of Salesforce, a customer has the following requirements for Sales Order:
1. Sales Order information needs to be shown to users in Salesforce.
2. Sales Orders are maintained in the on-premise enterprise resource planning (ERP).
3. Sales Order information has more than 150 million records.
4. Sales Orders will not be updated in Salesforce.
What should a data architect recommend for maintaining Sales Orders In Salesforce?- AUse custom objects to maintain Sales Orders in Salesforce.
- BUse custom big objects to maintain Sales Orders in Salesforce.
- CUse Standard Order object to maintain Sale Orders in Salesforce.
- DUse external objects to maintain Sales Orders in Salesforce.
69A large multinational B2C Salesforce customer is looking to implement their distributor management application in Salesforce. The application has the following capabilities:
1. Distributors create Sales Orders in Salesforce.
2. Sales Orders are based on Product prices applicable to their region.
3. Sales Orders are closed once they are fulfilled.
4. It is decided to maintain Sales Orders in Opportunities object.
How should the data architect model this requirement?- AConfigure Price Books for each region and share with distributors.
- BManually update Opportunities with Prices applicable to distributors.
- CCreate lookup to Custom Price object and share with distributors.
- DAdd custom fields in Opportunity and use triggers to update prices.
70Universal Containers (UC) stores 10 million rows of inventory data in a cloud database. As part of creating a connected experience in Salesforce, UC would like to expose this inventory data to Sales Cloud without a direct import. UC has asked its data architect to determine if Salesforce Connect is needed.
Which three considerations should the data architect make when evaluating the need for Salesforce Connect?
Choose 3 answers- AYou need small amounts of external data at any one time.
- BYou have a large amount of data and would like to copy subsets of it into Salesforce.
- CYou have a large amount of data that you don't want to copy into your Salesforce org.
- DYou want real-time access to the latest data from other systems.
- EYou need to expose data via a virtual private connection.
71Northern Trail Outfitters (NTO) runs its entire business out of an enterprise data warehouse (EDW). NTO's sales team is starting to use Salesforce after a recent implementation, but currently lacks the data required to advance leads and opportunities to the next stage.
NTO's management has researched Salesforce Connect and would like to use it to virtualize and report on data from the EDW within Salesforce. NTO will be running thousands of reports per day across 10 to 15 external objects.
What should a data architect consider before implementing Salesforce Connect for reporting?- AMaximum number of records returned
- BOData callout limits per day
- CMaximum page size for server-driven paging
- DMaximum external objects per org
72Universal Containers needs to load a large volume of leads into Salesforce on a weekly basis. During this process the validation rules are disabled.
What should a data architect recommend to ensure data quality is maintained in Salesforce?- AActivate validation rules once the leads are loaded into Salesforce to maintain quality.
- BAllow validation rules to be activated during the load of leads into Salesforce.
- CDevelop a custom Batch Apex process to improve quality once the load is completed.
- DEnsure the lead data is preprocessed for quality before loading into Salesforce
73Universal Containers (UC) has implemented Salesforce. UC is running out of storage and needs to have an archiving solution. UC would like to maintain two years of data in Salesforce and archive older data out of Salesforce.
Which solution should a data architect recommend as an archiving solution?- ABuild a batch job to move all records off platform, and delete old records from Salesforce.
- BBuild a batch job to move all records off platform, and delete all records from Salesforce.
- CUse a third-party backup solution to back up all data off platform.
- DBuild a batch job to move two-year-old records off platform, and delete old records from Salesforce.
74Universal Containers developers have created a new Lightning component that leverages an Apex controller using a SOQL query to populate a custom list view. Users are complaining that the component often fails to load and returns a timeout error.
What tool should a data architect use to identify why the query is taking too long?- AEnable and use the Query Plan tool in the developer console.
- BOpen a ticket with Salesforce support to retrieve transaction logs to be analyzed for processing time.
- CUse Splunk to query the system logs looking for transaction time and CPU usage.
- DUse Salesforce's query optimizer to analyze the query in the developer console.orce.
75A customer is operating in a highly regulated industry and is planning to implement Salesforce. The customer information maintained in Salesforce, includes the following:
1. Personally identifiable information (PII)
2. IP restrictions on profiles organized by geographic location
3. Financial records that need to be private and accessible only by the assigned sales associate
Enterprise Security has mandated access to be restricted to users within a specific geography with detailed monitoring of user activity. Additionally, users should not be allowed to export information from Salesforce.
Which three Salesforce Shield capabilities should a data architect recommend?
Choose 3 answers- ARestrict access to Salesforce from users outside specific geography.
- BPrevent sales users access to customer PII information.
- CTransaction Security policies to prevent export of Salesforce data.
- DEncrypt sensitive customer information maintained in Salesforce
76Universal Containers (UC) uses the following Salesforce products:
Sales Cloud for customer management.
Marketing Cloud for marketing.
Einstein Analytics for business reporting.
UC occasionally gets a list of prospects from third-party sources as comma-separated values (CSV) files for marketing purposes. Historically, UC would load these contacts into Lead object in Salesforce and sync to Marketing Cloud to send marketing communications. The number of records in the Lead object has grown over time and has been consuming large amounts of storage in Sales Cloud. UC is looking for recommendations to reduce the storage and advice on how to optimize the marketing process.
What should a data architect recommend to UC in order to immediately avold storage issues in the future?- ALoad the contacts directly to Marketing Cloud and have a reconciliation process to track prospects that are converted to customers.
- BLoad the CSV files in Einstein Analytics and sync with Marketing Cloud prior to sending marketing communications.
- CLoad the CSV files in an external database and sync with
77Northern Trail Outfitters (NTO) has been using Salesforce for Sales and Service for 10 years. For the past two years, the marketing group has noticed a rise from 0% to 35% in returned mail when sending mail using the contact information stored in Salesforce.
Which solution should the data architect use to reduce the amount of returned mail?- ADelete contacts when the mail is returned to save postal costs for NTO.
- BHave the sales team call all existing customers and ask to verify the contact details.
- CUse a third-party data source to update the contact information in Salesforce.
- DEmail all customers and ask them to verify their information and to call NTO if their address is incorrect.
78Universal 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?- ADefer rollup summary field calculation during data migration.
- BPerform a batch job in parallel mode and reduce the batch size.
- CLeverage Data Loader's platform API to load data.
- DPerform a batch job in serial mode and reduce the batch size.
79
Universal Containers (UC) is transitioning from Classic to Lightning Experience.
What does UC need to do to ensure users have access to its notes and attachments in Lightning Experience?- AAdd Notes and Attachments Related Lists to Page Layouts in Lightning Experience.
- BMigrate Notes and Attachments to Enhanced Notes and Files using a migration tool.
- CManually upload Notes in Lightning Experience.
- DManually upload Attachments in Lightning Experience.
80Universal Containers is migrating 100,000 accounts from an enterprise resource planning (ERP) to Salesforce and is concerned about ownership skew and performances.
Which three recommendations should a data architect provide to prevent ownership skew?
Choose 3 answers- AKeep users out of public groups that can be used as the source for sharing rules.
- BAssign a default user as owner of accounts and assign them a role in the hierarchy.
- CAssign a default user as owner of accounts and assign the user to the top most role in the hierarchy.
- DAssign a default user as owner of accounts and do not assign any role to the default user.
- EAssign View All permissions to a group of users for the Account object.
81Universal Containers (UC) is in the process of migrating legacy inventory data from an enterprise resource planning (ERP) system into
Sales Cloud with the following requirements:
1. Legacy inventory data will be stored in a custom child object called Inventory_c.
2. Inventory data should be related to the standard Account object.
3. The Inventory_c object should inherit the same sharing rules as the Account object.
4. Anytime an Account record is deleted in Salesforce, the related Inventory c record(s) should be deleted as well.
What type of relationship field should a data architect recommend in this scenario?- AIndirect lookup relationship field on Account, related to Inventory_c
- BMaster-detail relationship field on Account, related to Inventory_c
- CMaster-detail relationship field on Inventory_c, related to Account
- DLookup relationship field on Inventory_c, related to Account
82Universal Containers (UC) has a very large and complex Salesforce org with hundreds of validation rules and triggers. The triggers are responsible for system updates and data manipulation as records are created or updated by users. A majority of the automation tools within UC's org were not designed to run during a data load. UC is importing 100,000 records into Salesforce across several objects over the weekend.
What should a data architect do to mitigate any unwanted results during the import?- AEnsure validation rules, triggers, and other automation tools are disabled.
- BImport the data in smaller batches over a 24-hour period.
- CBulkify the triggers to handle import loads.
- DEnsure duplication and matching rules are defined.
83Universal Containers (UC) would like to build a Human Resources application on Salesforce to manage employee details, payroll, and hiring efforts. To adequately maintain and store the relevant data, the application will need to leverage 45 custom objects. In addition to this, UC expects roughly 20,000 API calls into Salesforce from an on-premise application daily.
Which license type should a data architect recommend that best fits these requirements?- ALightning Platform Plus
- BService Cloud
- CLightning Platform Starter
- DLightning External Apps Starter
84Universal Container has implemented Sales Cloud to manage patient and related health records. During a recent security audit of the system, it was discovered that some standard and custom fields need to encrypted.
Which solution should a data architect recommend to encrypt existing fields?- AImplement classic encryption to encrypt custom and standard fields.
- BUse Apex Crypto Class to encrypt custom and standard fields.
- CExport data out of Salesforce and encrypt custom and standard fields.
- DImplement shield platform encryption to encrypt custom and standard fields.
85A custom pricing engine for a Salesforce customer has to be decided by factors with the following hierarchy:
1. State in which the customer is located
2. City in which the customer is located if available
3. Zip code in which the customer is located if available
4. Changes to this information should have minimum code change
What should a data architect recommend to maintain this information for the custom pricing engine that is to be built in Salesforce?- AConfigure the pricing criteria in price books.
- BCreate a custom object to maintain the pricing criteria.
- CMaintain required pricing criteria in custom metadata types.
- DAssign the pricing criteria within custom pricing engine.
86Universal Containers (UC) has adopted Salesforce as its primary sales automation tool. UC has 100,000 customers with a growth rate of 10% a year. UC uses an on-premise web-based billing and invoice system that generates over 1 million invoices a year supporting a monthly billing cycle.
The UC sales team needs to be able to pull up a customer record and view their account status, invoice history, and open opportunities without navigating outside of Salesforce.
What should a data architect use to provide the sales team with the required functionality?- ACreate a visual force tab with the billing system encapsulated within an iframe.
- BCreate a mashup page that will present the billing system records within Salesforce.
- CCreate a custom object and migrate the last 12 months of invoice data into Salesforce so it can be displayed on the Account layout.
- DWrite an Apex callout and populate a related list to display on the account record.
87Universal 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?
Choose 2 answers- ALeverage picklist and lookup fields where possible.
- BLeverage Apex to validate the format of data being entered via a mobile device.
- CLeverage third-party AppExchange tools.
- DLeverage validation rules and workflows.
88The data architect for Universal Containers has written a SOQL query that will return all records from the Task object that do not have a value in the whatID field:
SELECT ID, Description, Subject FROM Task WHERE WhatId = NULL
When the data architect uses the query to select values for a process, a time-out error occurs.
What does the data architect need to change to make this query more performant?- AAdd LIMIT 100 to the query.
- BChange the WHERE clause to filter by a deterministic defined value.
- CChange query to SOSL
- DRemove description from the requested field set.
89Universal Containers (UC) has one Salesforce 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 orgs in near-real time.
Which three options should a data architect recommend to share data between Org A and Org B?
Choose 3 answers- ALeverage Heroku Connect and Heroku Postgres to bidirectionally sync Opportunities.
- BInstall a third-party AppExchange tool to handle the data sharing.
- CLeverage middleware tools to bidirectionally send Opportunity data across orgs.
- DDevelop an Apex class that pushes Opportunity data between orgs daily via the Apex scheduler.
- EUse Salesforce Connect and the cross-org adapter to virtualize Opportunities into external objects.
90
Northern Trail Outfitters (NTO) uses Sales Cloud and Service Cloud to manage their sales and support processes. Some of NTOs teams are complaining they see new fields on their page and are 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?- ACreate reports to identify which fields users are leaving blank, and use external data sources to augment the missing data.
- BAdd description fields to explain why the field is used, and mark the fields as Required.
- CCreate and manage a data dictionary, and use a governance process for changes made to common objects.
- DCreate validation rules with error messages to explain why the field is used.
91Universal Containers (UC) is replacing a home grown CRM solution with Salesforce. UC has decided to migrate operational (open and active) records to Salesforce, while keeping historical records in legacy system. UC would like historical records to be available in Salesforce on an as needed basis.
Which solution should a data architect recommend to meet business requirement?- ABring all data in Salesforce, and delete it after a year.
- BBuild a swivel chair solution to go into the legacy system and display records.
- CLeverage mashup to display historical records in Salesforce.
- DLeverage real-time integration to pull records into Salesforce.
92A large retail company has recently chosen Salesforce as its CRM solution. They have the following record counts:
2,500,000 Accounts
25,000,000 Contacts
When doing an initial performance test, the data architect noticed an extremely slow response-time for reports and list views.
What should a data architect do to solve the performance issues?- ACreate a Skinny Table to represent Account and Contact objects.
- BLimit data loading to the 2,000 most recently created records.
- CLoad only data that the user is permitted to access.
- DAdd Custom Indexes on frequently searched Account and Contact fields.
93A 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?- ABuild a custom search functionality that allows sales associates to search for customer in real time upon visiting their retail stores.
- BLeverage duplicate rules in Salesforce to validate duplicates during the account creation process.
- CImplement an MDM solution to validate the customer information before creating Accounts in Salesforce.
- DDevelop an Apex class that searches for duplicates and removes them nightly.
94As part of addressing General Data Protection Regulation (GDPR) requirements, Universal Containers (UC) plans to implement a data classification policy for all of its internal systems that store customer information including Salesforce.
What should a data architect recommend so that UC can easily classify customer information maintained in Salesforce under both standard and custom objects?- ABuild reports that contain customer data and classify manually.
- BCreate a custom picklist field to capture classification of information on the Contact object.
- CUse Data Classification metadata fields available in Field definition.
- DUse an AppExchange product to classify fields based on policy.
95
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?- AMove data off of the platform and run reporting outside Salesforce, and give access to reports.
- BBuild reports using custom Lightning components.
- CContact Salesforce support to enable skinny table for cases.
- DCreate a custom object to store aggregate data and run reports.
96A large retail B2C customer wants to build a 360-degree view of its customers for its call center agents. The customer information is currently maintained in the following systems:
1. Salesforce CRM
2. Custom billing solution
3. Customer master data management (MDM)
4. Contract management system
5. Marketing solution
What should a data architect recommend that would help uniquely Identify the customer across multiple systems?- AStore the Salesforce ID in all the solutions to identify the customer.
- BCreate a custom object that will serve as a cross-reference for the customer ID.
- CCreate a customer database, and use this ID in all systems.
- DCreate a custom field as external ID to maintain the customer ID from the MDM solution.
97Universal Containers (UC) has implemented Sales Cloud for its entire sales organization. UC has built a custom object called Projects_c that stores customer project details and employee billable hours.
The following requirements are needed:
1. A subset of individuals from the finance team will need access to the Projects object for reporting and adjusting employee utilization.
2. The finance users will not need access to any sales objects, but they will need to interact with the custom object.
Which license type should a data architect recommend for the finance team that best meets the requirements?- AService Cloud
- BSales Cloud
- CLightning Platform Starter
- DLightning Platform Plus
98Universal Containers has a Sales Cloud implementation for a sales team and an enterprise resource planning (ERP) as a customer master. Sales teams are complaining about duplicate account records and data quality issues with account data.
Which two solutions should a data architect recommend to resolve the complaints?
Choose 2 answers- AImplement a de-dupe solution and establish account ownership in Salesforce.
- BBuild a nightly sync job from ERP to Salesforce.
- CIntegrate Salesforce with ERP, and make ERP as system of truth.
- DBuild a nightly batch job to de-dupe data, and merge account records.
99
Universal Containers requires all customers to provide either a phone number or an email address when registering for an account.
What should the data architect use to ensure this requirement is met?- ARequired Fields
- BProcess Builder
- CApex Class
- DValidation Rule
100
Universal Containers has a requirement to store more than 100 million records in Salesforce and needs to create a custom big object to support this business requirement.
Which two tools should a data architect use to build custom big object?
Choose 2 answers- AGo to Big Object in Setup and select new to create big object.
- BGo to Object Manager in Setup and select new to create big object.
- CUse Metadata API to create big object.
- DUse DX to create big object.
101Northern Trail Outfitters (NTO) wants to implement backup and restore for Salesforce data. Currently, it has data backup processes that runs weekly, which backs 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?- AChange weekly backup process to daily backup, and implement a custom restore solution.
- BUse ETL tool for backup and restore from EDW.
- CUse Bulk API to extract data on daily basis to EDW and REST API for restore.
- DUse AppExchange package for backup and restore.
102Universal Containers is using Salesforce for Opportunity management and enterprise resource planning (ERP) for order management. Sales reps do not have access to the ERP and have no visibility into order status.
What solution should a data architect recommend to give the sales team visibility into order status?- ALeverage Canvas to bring the order management UI in to the Salesforce tab.
- BLeverage Salesforce Connect to bring the order line item from the legacy system to Salesforce.
- CBuild batch jobs to push order line items to Salesforce.
- DBuild real-time integration to pull order line items into Salesforce when viewing orders.
103Universal Containers is experiencing frequent and persistent group membership locking issues that severely restricts its ability to manage manual and automated updates at the same time.
What should a data architect do in order to resolve the issue?- AEnable implicit sharing.
- BEnable granular locking.
- CEnable parallel sharing rule calculation.
- DEnable defer sharing calculation.
104Universal Containers (UC) is in the process of implementing an enterprise data warehouse (EDW). UC needs to extract 100 million records from Salesforce for migration to the EDW.
What data extraction strategy should a data architect use for maximum performance?- AUse the Bulk API in parallel mode.
- BUtilize PK Chunking with the Bulk API.
- CCall the REST API in successive queries.
- DInstall a third-party AppExchange tool.
105A customer wants to maintain geographic location information including latitude and longitude in a custom object.
What should a data architect recommend to satisfy this requirement?- ARecommend AppExchange packages to support this requirement.
- BCreate custom fields to maintain latitude and longitude information.
- CCreate a geolocation custom field to maintain this requirement.
- DCreate formula fields with geolocation functions for this requirement.
106Northern Trail Outfitters (NTO) is in the process of evaluating big objects to store large amounts of asset data from an external system. NTO will need to report on this asset data weekly.
Which two native tools should a data architect recommend to achieve this reporting requirement?
Choose 2 answers- AEinstein Analytics
- BStandard SOQL queries
- CAsync SOQL with a custom object
- DStandard reports and dashboards
107Northern Trail Outfitters (NTO) has a loyalty program to reward repeat customers. The following conditions exist:
1. Reward levels are earned based on the amount spent during the previous 12 months.
2. The program will track every item a customer has bought and grant them points for discounts.
3. The program generates 100 million records each month.
NTO Customer Support would like to see a summary of a customer's recent transactions and the reward level(s) they have attained.
Which solution should the data architect use to provide the information within Salesforce for the customer support agents?- ACapture the reward program data in an external data store, and present the 12-month trailing summary in Salesforce using Salesforce Connect and an external object.
- BProvide a button so that the agent can quickly open the point-of-sale system that displays the customer's history.
- CCreate a custom object in Salesforce to capture and store all reward programs, populate nightly from the point-of-sale system, and present on the customer record.
- DCreate a custom big object to capture the reward program data, display it on the contact record, and update nightly from the point-of-sale system.
108A large insurance provider is looking to implement Salesforce. The following conditions exist:
1. Multiple channels for lead acquisition
2. Duplicate leads across channels
3. Poor customer experience and higher costs
On analysis, It was found that there are duplicate leads that are resulting in multiple quotes and opportunities.
Which three actions should a data architect recommend to mitigate the Issues?
Choose 3 answers- ABuild process to manually search and merge duplicates.
- BImplement third-party solution to clean and enrich lead data.
- CStandardize lead information across all channels.
- DImplement de-duplication strategy to prevent duplicate leads.
- EBuild a custom solution to identify and merge duplicate leads.
109Universal Containers (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 options to delete unused records from the org.
Which three recommendations should a data architect make in order to reduce the number of records from the org?
Choose 3 answers- AUse hard delete in Batch Apex to permanently delete records from Salesforce.
- BUse Rest API to permanently delete records from the Salesforce org.
- CUse hard delete in Bulk API to permanently delete records from Salesforce.
- DIdentify records in objects that have not been modified or used in last 3 years.
- EArchive the records in enterprise data warehouse (EDW) before deleting from Salesforce.
110Universal Containers (UC) has a Salesforce org with multiple automated processes defined for group membership processing. UC also has multiple admins on staff that perform manual adjustments to the role hierarchy. The automated tasks and manual tasks overlap daily, and UC is experiencing "lock errors" consistently.
What should a data architect recommend to mitigate these errors?- AEnable granular locking.
- BAsk Salesforce support for additional CPU power.
- CRemove SOQL statements from Apex Loops.
- DEnable sharing recalculations.
111Northern Trail Outfitters (NTO) operates a majority of its business from a central Salesforce org. NTO also owns several secondary orgs that the service, finance, and marketing teams work out of. At the moment, there is no integration between central and secondary orgs, leading to data-visibility issues.
Moving forward, NTO has identified that a hub-and-spoke model is the proper architecture to manage its data, where the central org is the hub and the secondary orgs are the spokes.
Which tool should a data architect use to orchestrate data between the hub org and spoke orgs?- AA middleware solution that extracts and distributes data across both the hub and spokes.
- BDevelop custom APIs to poll the hub org for change data and push into the spoke orgs.
- CDevelop custom APIs to poll the spoke org for change data and push into the hub org.
- DA backup and archive solution that extracts and restores data across orgs.
112Universal Containers (UC) is going through major reorganization of their sales team. This would require changes to a large a number of group membership and sharing rules. UCs administrator is concerned about long processing time and failures during the process.
What should a Data Architect implement to make changes efficiently?- ALog a case with salesforce to make sharing rule changes.
- BEnable Defer Sharing Calculation prior to making sharing rule changes.
- CLog out all users and make change to sharing rules.
- DDelete old sharing rules and build new sharing rules.
113Universal Containers (UC) owns a complex Salesforce org with many Apex classes, triggers, and automated processes that will modify records if available. UC has identified that, in its current development state, UC runs chance of encountering race conditions on the same record.
What should a data architect recommend to guarantee that records are not being updated at the same time?- AMigrate programmatic logic to processes and flows.
- BDisable classes or triggers that have the potential to obtain the same record.
- CEmbed the keywords FOR UPDATE after SOQL statements.
- DRefactor or optimize classes and triggers for maximum CPU performance.
114Northern Trail Outfitters (NTO) has the following systems:
Customer master-source of truth for customer information
Service cloud-customer support
Marketing cloud-marketing communications
Enterprise data warehouse-business reporting
The customer data is duplicated across all these systems and are not kept in sync. Customers are also complaining that they get repeated marketing emails and have to call in to update their information.
NTO is planning to implement a master data management (MDM) solution across the enterprise.
Which three data issues will an MDM tool solve?
Choose 3 answers- AData standardization
- BData accuracy and quality
- CData duplication
- DData loss and recovery
- EData completeness
115A casino is implementing Salesforce and is planning to build a customer 360 degree view for a customer who visits its resorts. The casino currently maintains the following systems that record customer activity:
1. Point-of-sale system: All purchases for a customer
2. Salesforce: All customer service activity and sales activities 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 four systems to provide support to customers. The information has to be current and real time.
What strategy should the data architect implement to satisfy this requirement?- APeriodically upload summary information in Salesforce to build a 360 degree view.
- BUse a customer data mart to create the 360 degree view of the customer.
- CExplore external data sources in Salesforce to build a 360 degree view of the customer.
- DMigrate customer activities from all four systems into Salesforce.
116To address different compliance requirements such as General Data Protection Regulation (GDPR), personally identifiable information (PII), Health Insurance Portability and Accountability Act (HIPPA) and others, a Salesforce customer decided to categorize each data element in Salesforce with the following:
1. Data owner
2. Security level (i.e. confidential)
3. Compliance type (i.e. GDPR, PII, HIPAA)
A compliance audit would require Salesforce admins to generate reports to manage compliance.
What should a data architect recommend to address this requirement?- ABuild reports for field information, then export the information to classify and report for audits.
- BUse the Metadata API to extract field attribute information and use the extract to classify and build reports.
- CUse field metadata attributes for compliance categorization, data owner, and data sensitivity level.
- DCreate a custom object and field to capture necessary compliance information and build custom reports.
117Universal Containers is implementing Salesforce and needs to migrate data from two legacy systems. UC would like to clean and deduplicate data before migrating to Salesforce.
Which solution should a data architect recommend a clean migration?- ADefine external IDs for an object, insert data from one database, and use upsert for a second database.
- BDefine deduplicate rules in Salesforce, and load data into Salesforce from both databases.
- CSet up staging data base, and define external IDs to merge, clean, deduplicate data, and load into Salesforce.
- DDefine external IDs for an object, migrate second database to first database, and load into Salesforce.
118Northern Trail Outfitters uses Salesforce to manage relationships and track sales opportunities. It has 10 million customers and 100 million opportunities. The CEO has been complaining that a dashboard is taking 10 minutes to run and sometimes fails to load, throwing a time-out error.
Which three options should help improve the dashboard performance?
Choose 3 answers- ARemove widgets from the dashboard to reduce the number of graphics loaded.
- BDenormalize the data by reducing the number of joins.
- CReduce the amount of data queried by archiving unused opportunity records.
- DRun the dashboard for the CEO and send it via email.
- EUse selective queries to reduce the amount of data being returned.
119
Universal Containers has a legacy client server app that has a relational database that needs to be migrated to Salesforce.
What are the three key actions that should be done when data modeling in Salesforce?
Choose 3 answers- AMap legacy data to custom metadata types.
- BIdentify data elements to be persisted in Salesforce.
- CImplement the legacy data model within Salesforce using custom fields.
- DMap legacy data to Salesforce objects.
- EWork with legacy application owner to analyze the legacy data model.
120Northern Trail Outfitters (NTO) has a variety of customers that include households, businesses, and individuals.
The following conditions exist within its system:
1. NTO has a total of five million customers.
2. Duplicate records exist, which is replicated across many systems, including Salesforce.
Given these conditions, there is a lack of consistent presentation and clear Identification of a customer record.
Which three options should a data architect perform to resolve the issues with the customer data?
Choose 3 answers- ACreate a customer master database external to Salesforce as a system of truth and sync the customer data with all systems.
- BInvest in data duplication tool to de-dupe and merge duplicate records across all systems.
- CDuplicate customer records across the systems and provide a two-way sync of data between the systems.
- DCreate a unique global customer ID for each customer and store that in all systems for referential identity.
121Northern Trail Outfitters has these simple requirements for a data export process:
1. File format should be in CSV.
2. Process should be scheduled and run once per week.
3. The export should be configurable through the Salesforce UI.
Which tool should a data architect leverage to accomplish these requirements?- AThird-party ETL tool
- BData loader
- CBulk API
- DData export wizard
122Universal Containers (UC) is planning a massive Salesforce 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?- AEnable defer sharing calculations and suspend sharing rule calculations.
- BEnable granular locking to avoid the "UNABLE_TO_LOCK_ROW" error.
- CLoad the data through Data Loader and turn on parallel processing.
- DLeverage the Bulk API and concurrent processes with multiple batches.
123Universal Containers is preparing to implement Sales Cloud and would like 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?- ACreate an owner-based sharing rule.
- BImplicit sharing will automatically handle this with standard functionality.
- CAdd appropriate users to the Account team.
- DCreate a criteria-based sharing rule.
124Universal Containers (UC) has the following systems:
1. Billing system
2. Customer support system
3. CRM system
UC has been having trouble with business Intelligence across the different systems. Recently UC 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?- AEmail address
- BPhone number
- CGlobally Unique Identifier
- DFull name
125Universal 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 orgs: 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 migration will need occur within the next two months, prior to the spilt.
Which migration strategy should a data architect use to successfully migrate the data?- AUse an ETL tool to orchestrate the migration.
- BUse the Salesforce CLI to query, export, and import.
- CWrite a script to use the Bulk API.
- DUse Data Loader for export and Data Import Wizard for import.
126Universal Containers (UC) has millions of case records with case history and service level agreement data. UC's compliance team would like historical cases to be accessible for 10 years for audit purposes.
What solution should a data architect recommend?- AUse a custom big object to store archived case data.
- BUse a custom object to store archived case data.
- CPurchase more data storage to support the case object.
- DArchive case data using a Salesforce Archival solution.
127Northern Trail Outfitters (NTO) has decided to franchise its brand. Upon implementation 1,000 franchisees will be able to access NTO'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 license does NTO need to provide these features to the franchisees?- ACustomer Community License
- BLighting Platform License
- CSalesforce Sales Cloud License
- DPartner Community License
128Universal Containers (UC) is migrating data from a legacy system to Salesforce. UC would like to preserve the following information on records being migrated:
1. Date time stamps for created date and last modified date
2. Ownership of records belonging to inactive users being migrated to Salesforce
Which two solutions should a data architect recommend to preserve date timestamps and ownership on records?
Choose 2 answers- ALog a case with Salesforce to allow updating these fields.
- BEnable Set Audit Fields upon Record Creation permission.
- CEnable Modify All and View All permissions.
- DEnable Update Records with Inactive Owners permission.
129A 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?- ALeverage duplicate rules in Salesforce to validate duplicates during the account creation process.
- BDevelop an Apex class that searches for duplicates and removes them nightly.
- CBuild a custom search functionality that allows sales associates to search for customer in real time upon visiting their retail stores.
- DImplement an MDM solution to validate the customer information before creating Accounts in Salesforce.
130Universal Containers has millions of cases and are running out storage. Some user groups need to have access to historical cases for up to seven years.
Which two solutions should a data architect recommend in order to minimize performance and storage issues?
Choose 2 answers- ALeverage Salesforce Privacy Center to archive case data and view archived cases through an external object.
- BCreate a custom object to store case history and run reports on it.
- CExport data out of Salesforce and store in flat files on external system.
- DLeverage big objects to archive case data and Lightning components to show archived data.
131Universal Containers uses classic encryption for custom fields and is leveraging weekly data export for data backups. During a validation process, UC discovered that encrypted field values are still being exported as part of the data export.
What should a data architect recommend to make sure decrypted values are exported during data export?- ACreate another field to copy data from the encrypted field, and use this field in export.
- BSet up a custom profile for the data migration user, and assign View Encrypted Data.
- CSet up a standard profile for the data migration user, and assign View Encrypted Data.
- DLeverage an Apex class to decrypt data before exporting it.
132The data architect for Universal Containers has written a SOQL query that will return all records from the Task object that do not have a value in the whatID field:
SELECT ID, Description, Subject FRON Task HERE whatid NULL
When the data architect uses the query to select values for a process, a time-out error occurs.
What does the data architect need to change to make this query more performant?- AChange the WHERE clause to filter by a deterministic defined value.
- BChange query to SOSL.
- CRemove description from the requested field set.
- DAdd LIMIT 100 to the query.
133Northern Trail Outfitters (NTO) has a complex Salesforce org which has been developed over the past five years. Internal users are complaining about multiple data issues, including incomplete and duplicate data in the org. NTO has decided to engage a data architect to analyze and define data quality standards.
Which three key factors should a data architect consider while defining data quality standards?
Choose 3 answers- AMeasure data timeliness and consistency.
- BIdentify an extract, transform, load (ETL) tool for more complete data migrations.
- CMeasure data completeness and accuracy.
- DDefine data duplication standards and rules.
- EDefine key fields in a staging database for data cleansing.
134Universal Containers is building a Salesforce application to track Contacts and the respective Conferences that they have attended with the following requirements:
1. Contacts will be stored in the standard Contact object.
2. Conferences will be stored in a custom Conference_c object.
3. Each Contact may attend multiple Conferences and each Conference may be related to multiple Contacts.
How should a data architect model the relationship between the Contact and Conference c objects?- ACreate a master-detail relationship field on the Contact object.
- BImplement a Contact Conference junction object with master-detail relationships to both Contact and Conference_c.
- CCreate a master-detail relationship field on the Conference_c object.
- DCreate a lookup relationship field on the Contact object.
135Universal Containers (UC) has a variety of systems across its technology landscape, including Salesforce, legacy enterprise resource planning (ERP) applications, and homegrown CRM tools. UC has decided that they would like to consolidate all customer, opportunity, and order data into Salesforce as part of its master data management strategy.
What are the three key steps that a data architect should take when merging data from multiple systems into Salesforce?
Choose 3 answers- AInstall a third-party AppExchange tool to handle the merger.
- BAnalyze each system's data model and perform gap analysis.
- CWork with stakeholders to define record and field survivorship rules.
- DCreate new fields to store additional values from all of the systems.
- EUtilize an ETL tool to migrate, transform, and deduplicate data.
136Universal Containers (UC) recently migrated 1 billion customer related records from a legacy datastore to Heroku Postgres. A subset of the data needs to be synchronized with Salesforce so that service agents are able to support customers directly within the service console. The remaining non-synchronized set of data will need to be accessed by Salesforce at any point in time, but UC management is concerned about storage limitations.
What should a data architect recommend to meet these requirements with minimal effort?- AVirtuallize the remaining set of data with Salesforce Connect and external objects.
- BAs needed, make callouts into Heroku Postgres and persist the data in Salesforce.
- CUse Heroku Connect to bidirectionally sync all data between systems.
- DMigrate the data to big objects and leverage Async SOQL with custom objects.
137To address different compliance requirements such as General Data Protection Regulation (GDPR), personally identifiable information (PII), Health Insurance Portability and Accountability Act (HIPPA) and others, a Salesforce customer decided to categorize each data element in Salesforce with the following:
1. Data owner
2. Security level (i.e. confidential)
3. Compliance type (i.e. GDPR, PII, HIPAA)
A compliance audit would require Salesforce admins to generate reports to manage compliance.
What should a data architect recommend to address this requirement?- AUse the Metadata API to extract field attribute information and use the extract to classify and build reports.
- BCreate a custom object and field to capture necessary compliance information and build custom reports.
- CBuild reports for field information, then export the information to classify and report for audits.
- DUse field metadata attributes for compliance categorization, data owner, and data sensitivity level.
138A customer needs a sales model that allows the following:
1. Opportunities need to be assigned to sales people based on the zip code.
2. Each salesperson can be assigned to multiple zip codes.
3. Each zip code is assigned to a sales area definition. Sales are aggregated by sales area for reporting.
What should a data architect recommend?- AAssign opportunities using list views using zip code.
- BAdd custom fields in opportunities for zip code and use assignment rules.
- CConfigure the Territory Management feature to support opportunity assignment.
- DAllow sales users to manually assign opportunity ownership based on zip code.
139Northern Trail Outfitters (NTO) has multiple Salesforce orgs based on geographical regions (AMER, EMEA, APAC). NTO products are mastered in the AMER org and need to be created in the EMEA and APAC orgs after the products are approved.
Which two features should a data architect recommend to share records between Salesforce orgs?
Choose 2 answers- AChange Data Capture (CDC)
- BSalesforce Connect
- CSalesforce 2 Salesforce
- DFederated Search
140 A customer is operating in a highly regulated industry and is planning to implement Salesforce. The customer information maintained in Salesforce, includes the following:
1. Personally identifiable information (PII)
2. IP restrictions on profiles organized by geographic location
3. Financial records that need to be private and accessible only by the assigned sales associate
Enterprise Security has mandated access to be restricted to users within a specific geography with detailed monitoring of user activity. Additionally, users should not be allowed to export information from Salesforce.
Which three Salesforce Shield capabilities should a data architect recommend?
Choose 3 answers- ATransaction Security policies to prevent export of Salesforce data.
- BEncrypt sensitive customer information maintained in Salesforce.
- CRestrict access to Salesforce from users outside specific geography.
- DPrevent sales users access to customer PII information.
- EEvent monitoring to monitor all user activity.
141Universal Containers (UC) is implementing Salesforce and will be using Salesforce to track customer complaints, provide white papers on products, and provide subscription based support.
Which license type will UC users need to fulfill UC's requirements?- ASales Cloud License
- BLightning Platform Starter License
- CService Cloud License
- DSalesforce License
142Universal 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?- ADefer rollup summary field calculation during data migration.
- BPerform a batch job in serial mode and reduce the batch size.
- CPerform a batch job in parallel mode and reduce the batch size.
- DLeverage Data Loader's platform API to load data.
143Universal Containers is migrating individual customers (B2C) data from legacy systems to Salesforce. There are millions of customers stored as accounts and contacts in the legacy database.
Which object model should a data architect configure within Salesforce?- ALeverage the standard account and contact object in Salesforce.
- BLeverage a custom account and contact object in Salesforce.
- CLeverage a custom person account object in Salesforce.
- DLeverage the person account object in Salesforce.
144United Containers (UC) has released a new disaster recovery (DR) policy that states that cloud solutions need a business continuity plan in place separate from the cloud provider's built-in data recovery solution.
Which solution should a data architect use to comply with the DR policy?- ALeverage Salesforce weekly exports, and store data in flat files on a protected system.
- BLeverage a third-party tool that extracts Salesforce data/metadata, and stores the information in an external protected system.
- CUtilize an ETL tool to migrate data to an on-premise archival solution.
- DWrite a custom batch job to extract data changes nightly, and store on an external protected system.
145 Universal Containers has a legacy client server app that has a relational database that needs to be migrated to Salesforce.
What are the three key actions that should be done when data modeling in Salesforce?
Choose 3 answers- AMap legacy data to Salesforce objects.
- BIdentify data elements to be persisted in Salesforce.
- CWork with legacy application owner to analyze the legacy data model.
- DMap legacy data to custom metadata types.
- EImplement the legacy data model within Salesforce using custom fields.
146What should a data architect do to provide additional guidance for users when they enter information in a Standard field?
- AProvide custom help text under field properties.
- BAdd custom help text in default value for the field.
- CAdd a label field with help text adjacent to the custom field.
- DCreate a custom page with help text for user guidance.
147Universal Containers (UC) has the following systems:
1. Billing system
2. Customer support system
3. CRM system
UC has been having trouble with business intelligence across the different systems. Recently UC 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?- AEmail address
- BPhone number
- CGlobally Unique Identifier
- DFull name
148Northern Trail Outfitters (NTO) has one million customer records spanning 25 years. As part of its new Salesforce project, NTO would like to create a master data management strategy to help preserve the history and relevance of its customer data.
Which three activities will be required to identify a successful master data management strategy?
Choose 3 answers- AInstall a data warehouse.
- BChoose a business intelligence tool.
- CIdentify data to be replicated.
- DDefine the system of record for critical data.
- ECreate a data archive strategy.
149Universal Containers has a large number of orders coming in from its online portal. Historically all orders are assigned to a generic user.
Which two measures should a data architect recommend to avoid any performance issues while working with a large number of order records?
Choose 2 answers- AClear the role field in the generic user record.
- BCreate a pool of generic users and distribute the assignment of owners to the pool of users.
- CSalesforce handles the assignment of orders automatically and there is no performance impact.
- DCreate a role at the top of the role hierarchy and assign the role to the generic user.
150Universal Containers is rolling out a Sales App globally to bring sales teams together on one platform. UC expects millions of opportunities and accounts to be created and is concerned about the performance of the application.
Which three recommendations should the data architect make to avoid data skew?
Choose 3 answers- ALimit assigning one user ownership of 10,000 records.
- BLimit associating 10,000 Opportunities to one account.
- CAssign 10,000 opportunities to one account.
- DLimit associating 10,000 records looking up to same records.
- EUse picklist fields rather than a lookup to a custom object.
151A large retail B2C customer wants to build a 360-degree view of its customers for its call center agents. The customer information is currently maintained in the following systems:
1. Salesforce CRM
2. Custom billing solution
3. Customer master data management (MDM)
4. Contract management system
5. Marketing solution
What should a data architect recommend that would help uniquely identify the customer across multiple systems?- ACreate a customer database, and use this ID in all systems.
- BCreate a custom field as external ID to maintain the customer ID from the MDM solution.
- CStore the Salesforce ID in all the solutions to identify the customer.
- DCreate a custom object that will serve as a cross-reference for the customer ID.
152Northern Trail Outfitters (NTO) has outgrown its current Salesforce org and will be migrating to a new org shortly. As part of this process, NTO will be migrating all of its metadata and data. NTO's data model in the source org has a complex relationship hierarchy with several master-detail and lookup relationships across objects, which should be maintained in the target org.
Which three things should a data architect do to maintain the relationship hierarchy during migration?
Choose 3 answers- AReplace source record IDs with new record IDs from the target org in the import file.
- BRedefine the master-detail relationship fields to lookup relationship fields in the target org.
- CKeep the relationship fields populated with the source record IDs in the import file.
- DCreate an external ID field for each object in the target org and map source record IDs to this field.
- EUse Data Loader to export the data from the source org and then import/upsert into the target org in sequential order.
153Northern Trail Outfitters (NTO) has been using Salesforce for Sales and Service for 10 years. For the past two years, the marketing group has noticed a rise from 0% to 35% in returned mail
when sending mail using the contact information stored in Salesforce.
Which solution should the data architect use to reduce the amount of returned mail?- AHave the sales team call all existing customers and ask to verify the contact details.
- BDelete contacts when the mail is returned to save postal costs for NTO.
- CUse a third-party data source to update the contact information in Salesforce.
- DEmail all customers and ask them to verify their information and to call NTO if their address is incorrect.
154Universal Containers (UC) has one Salesforce 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 orgs in near-real time.
Which three options should a data architect recommend to share data between Org A and Org B?
Choose 3 answers- ADevelop an Apex class that pushes Opportunity data between orgs daily via the Apex scheduler.
- BLeverage middleware tools to bidirectionally send Opportunity data across orgs. B.
- CUse Salesforce Connect and the cross-org adapter to virtualize Opportunities into external objects.
- DLeverage Heroku Connect and Heroku Postgres to bidirectionally sync Opportunities.
- EInstall a third-party AppExchange tool to handle the data sharing.
155Northern Trail Outfitters (NTO) has multiple systems across its enterprise landscape, including Salesforce, with disparate versions of the customer record. In Salesforce, the customer is represented by the Contact object. NTO utilizes a master data management (MDM) solution with these attributes:
1. The MDM solution keeps track of the Customer Master with a Master Key.
2. The Master Key is a map to the record IDs from each external system that customer data is stored within.
3. The MDM solution provides deduplication features, so it acts as the Single Source of Truth.
How should a Data Architect implement the storage of the Master Key within Salesforce?- ACreate an external object to store the Master Key with a lookup field to Contact.
- BCreate a custom object to store the Master Key with a lookup field to Contact.
- CStore the Master Key on the Contact object as an External ID field for referential integrity.
- DStore the Master Key in Heroku Postgres and use Heroku Connect for synchronization.
156Universal Containers is migrating 100,000 accounts from an enterprise resource planning (ERP) to Salesforce and is concerned about ownership skew and performances.
Which three recommendations should a data architect provide to prevent ownership skew?
Choose 3 answers- AKeep users out of public groups that can be used as the source for sharing rules.
- BAssign View All permissions to a group of users for the Account object.
- CAssign a default user as owner of accounts and assign the user to the top most role in the hierarchy
- DAssign a default user as owner of accounts and assign them a role in the hierarchy.
- EAssign a default user as owner of accounts and do not assign any role to the default user.
157Universal Containers needs to load a large volume of leads into Salesforce on a weekly basis. During this process the validation rules are disabled.
What should a data architect recommend to ensure data quality is maintained in Salesforce?- AAllow validation rules to be activated during the load of leads into Salesforce.
- BDevelop a custom Batch Apex process to improve quality once the load is completed.
- CEnsure the lead data is preprocessed for quality before loading into Salesforce
- DActivate validation rules once the leads are loaded into Salesforce to maintain quality.
158Universal Containers (UC) has migrated its back-office data into an on-premise database with REST API access. UC recently implemented Sales Cloud for its sales organization, but users are complaining about a lack of order data inside Salesforce.
UC is concerned about Salesforce storage limits but would still like Sales Cloud to have access to the data.
Which design pattern should a data architect select to satisfy the requirement?- AUse Salesforce Connect to virtualize the data in Salesforce and avoid storage limits.
- BBuild a UI for the on-premise system and iframe it in Salesforce.
- CMigrate and persist the data in Salesforce to take advantage of native functionality.
- DDevelop a bidirectional integration between the on-premise system and Salesforce.
159Universal Containers (UC) needs to run monthly and yearly reports on opportunities and orders for sales reporting. There are 5 million opportunities and 10 million orders. Sales users are complaining that the report will regularly timeout.
What is the fastest and most effective way for a data architect to solve the time-out issue?- ACreate a skinny table in Salesforce, and copy order and opportunity fields into the skinny table and create the required reports on it.
- BCreate custom fields on opportunity, and copy data from order into those custom fields and run all reports on Opportunity object.
- CExtract opportunity and order data from Salesforce, and use a third-party reporting tool to run reports outside of Salesforce.
- DCreate an aggregate custom object that summarizes the monthly and yearly values into the required format for the required reports.
160 Northern Trail Outfitters has decided that it is going to build a channel sales portal with the following requirements:
1. External resellers are able to authenticate to the portal with a login.
2. Lead data, Opportunity data, and Order data are available to authenticated users.
3. Authenticated users may need to run reports and dashboards.
4. There is no need for more than 10 custom objects or additional file storage.
Which Community Cloud license type should a data architect recommend to meet the portal requirements?- APartner Community
- BCustomer Community Plus
- CCustomer Community
- DLightning External Apps Starter
161Northern Trail Outfitters would like to retrieve their Salesforce org's metadata programmatically for backup within a version control system.
Which API is the best fit for accomplishing this task?- ASOAP API
- BMetadata API
- CBulk API in serial mode
- DTooling API
162A large retail company has recently chosen Salesforce as its CRM solution. They have the following record counts:
2,500,000 Accounts
25,000,000 Contacts
When doing an initial performance test, the data architect noticed an extremely slow response-time for reports and list views.
What should a data architect do to solve the performance issues?- ALoad only data that the user is permitted to access.
- BCreate a Skinny Table to represent Account and Contact objects.
- CLimit data loading to the 2,000 most recently created records.
- DAdd Custom Indexes on frequently searched Account and Contact fields.
163Universal Containers (UC) has a Salesforce org with multiple automated processes defined for group membership processing. UC also has multiple admins on staff that perform manual adjustments to the role hierarchy. The automated tasks and manual tasks overlap daily, and UC is experiencing "lock errors" consistently.
What should a data architect recommend to mitigate these errors?- AEnable granular locking.
- BRemove SOQL statements from Apex Loops.
- CEnable sharing recalculations.
- DAsk Salesforce support for additional CPU power.
164Universal Containers (UC) has a requirement to migrate 100 million order records from a legacy enterprise resource planning (ERP) application into the Salesforce platform. UC does not have any requirements around reporting on the migrated data.
What should a data architect recommend to reduce performance degradation of the platform?- AImplement a custom big object to store the data.
- BCreate a custom object to store the data.
- CUse the standard "Order" object to store the data.
- DUse a standard big object defined by Salesforce
165Universal Containers (UC) owns multiple Salesforce orgs that are distributed across regional branches. Each branch stores local customer data inside of its org's Account and Contact objects. This
creates a scenario where UC is unable to view customers across all orgs.
UC has an initiative to create a 360 degree view of the customer, as UC would like to see Account and Contact data from all of its orgs in one place.
Which solution should a data architect suggest to achieve a 360 degree view of the customer?- AUse an ETL tool to migrate gap Accounts and Contacts into each org.
- BUse the Salesforce Connect cross-org adapter.
- CBuild a bidirectional integration between all orgs.
- DConsolidate the data from each org into a centralized datastore.
166Which two data management policies does the Data Classification feature allow customers to classify in Salesforce?
Choose 2 answers- AReference Data policy
- BCompliance Categorization policy B.
- CData Sensitivity Level
- DData Governance policy
167Universal Containers has been using Salesforce for 10 years. Lately, users have noticed that the pages load slowly when viewing customer and account list views.
To mitigate, UC will implement a data archival strategy to reduce the amount of data actively loaded.
Which two tasks are required to define the strategy?
Choose 2 answers- AIdentify the data retention requirements.
- BIdentify how the archived data will be accessed and used.
- CIdentify the recovery point objective.
- DIdentify the recovery time objective.
168Northern Trail Outfitters (NTO) has a loyalty program to reward repeat customers. The following conditions exist:
1. Reward levels are earned based on the amount spent during the previous 12 months.
2. The program will track every item a customer has bought and grant them points for discounts.
3. The program generates 100 million records each month.
NTO Customer Support would like to see a summary of a customer's recent transactions and the reward level(s) they have attained.
Which solution should the data architect use to provide the information within Salesforce for the customer support agents?- ACreate a custom object in Salesforce to capture and store all reward programs, populate nightly from the point-of-sale system, and present on the customer record.
- BCapture the reward program data in an external data store, and present the 12-month trailing summary in Salesforce using Salesforce Connect and an external object.
- CProvide a button so that the agent can quickly open the point-of-sale system that displays the customer's history.
- DCreate a custom big object to capture the reward program data, display it on the contact record, and update nightly from the point-of-sale system.
169A customer wants to maintain geographic location information including latitude and longitude in a custom object.
What should a data architect recommend to satisfy this requirement?- ACreate custom fields to maintain latitude and longitude information.
- BCreate formula fields with geolocation functions for this requirement.
- CRecommend AppExchange packages to support this requirement.
- DCreate a geolocation custom field to maintain this requirement.
170 Northern Trail Outfitters (NTO) needs to extract 50 million records from a custom object every day from its Salesforce org. NTO is facing query time-out issues while extracting these records.
What should a data architect recommend in order to get around the time-out issue?- AAsk Salesforce support to increase the query timeout value.
- BUse extract, transform, load (ETL) tool for extraction of records.
- CUse the Rest API to extract data as it automatically chunks records by 200.
- DUse a custom auto number and formula field to chunk records while extracting data.
171A large healthcare provider wishes to use Salesforce to track patient care. The following actors are in Salesforce:
1. Payment providers: Organizations who pay for the care to patients.
2. Doctors: They provide care plans for patients and need to support multiple patients. They are provided access to patient information.
3. Patients: These are individuals who need care.
A data architect needs to map the actors to Salesforce objects.
What should be the optimal selection by the data architect?- APatients as Accounts, Payment providers as Accounts, and Doctors as Person Accounts
- BPatients as Person Accounts, Payment providers as Accounts, and Doctors as Person Accounts
- CPatients as Contacts, Payment providers as Accounts, and Doctors as Accounts
- DPatients as Person Accounts, Payment providers as Accounts, and Doctors as Contacts
172Universal Containers (UC) is planning a massive Salesforce 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?- ALeverage the Bulk API and concurrent processes with multiple batches.
- BEnable granular locking to avoid the "UNABLE_TO_LOCK_ROW" error.
- CEnable defer sharing calculations and suspend sharing rule calculations.
- DLoad the data through Data Loader and turn on parallel processing.
173Northern Trail Outfitters uses Salesforce to manage relationships and track sales opportunities. It has 10 million customers and 100 million opportunities. The CEO has been complaining that a dashboard is taking 10 minutes to run and sometimes fails to load, throwing a time-out error.
Which three options should help improve the dashboard performance?
Choose 3 answers- ARun the dashboard for the CEO and send it via email.
- BDenormalize the data by reducing the number of joins.
- CUse selective queries to reduce the amount of data being returned.
- DReduce the amount of data queried by archiving unused opportunity records.
- ERemove widgets from the dashboard to reduce the number of graphics loaded.
174Universal Containers developers have created a new Lightning component that leverages an Apex controller using a SOQL query to populate a custom list view. Users are complaining that the component often fails to load and returns a timeout error.
What tool should a data architect use to identify why the query is taking too long?- AUse Splunk to query the system logs looking for transaction time and CPU usage.
- BUse Salesforce's query optimizer to analyze the query in the developer console.
- CEnable and use the Query Plan tool in the developer console.
- DOpen a ticket with Salesforce support to retrieve transaction logs to be analyzed for processing time.
175Universal Containers (UC) is using Salesforce CRM. UC sales managers are complaining about data quality and would like to monitor and measure the data that is input in to the system.
Which two solutions should a data architect recommend to monitor and measure data quality?
Choose 2 answers- AExport data and check for data completeness outside of Salesforce.
- BUse custom objects and fields to identify issues.
- CInstall and run the "Data Quality Analysis" dashboard app.
- DReview the data quality reports and dashboards.
176As part of addressing General Data Protection Regulation (GDPR) requirements, Universal Containers (UC) plans to implement a data classification policy for all of its internal systems that store customer information including Salesforce.
What should a data architect recommend so that UC can easily classify customer information maintained in Salesforce under both standard and custom objects?- ACreate a custom picklist field to capture classification of information on the Contact object.
- BBuild reports that contain customer data and classify manually.
- CUse Data Classification metadata fields available in Field definition.
- DUse an AppExchange product to classify fields based on policy.
177Northern Trail Outfitters (NTO) processes orders from its website via an order management system (OMS). The OMS stores over 2 million historical records and is currently not integrated with Salesforce.
The sales team at NTO is using Sales Cloud and would like visibility into related customer orders, yet they do not want to persist millions of records directly in Salesforce. NTO has asked the data architect to evaluate Salesforce Connect and the concept of data virtualization.
Which three key considerations are needed prior to a Salesforce Connect implementation?
Choose 3 answers- ADevelop an object relationship strategy.
- BCreate a second system admin user for authentication to the external source.
- CConfigure a middleware tool to poll external table data.
- DIdentify the external tables to sync into external objects.
- EAssess whether the external data source is reachable via an OData endpoint.
178Northern Trail Outfitters (NTO) has implemented Salesforce for its sales users. The opportunity management in Salesforce 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?- ACreate a custom field for Opportunity Amount that sales users update separating the field that PPS updates.
- BCreate a custom field for Opportunity amount that PPS updates separating the field sales user updates.
- CChange Opportunity Amount field access to Read Only for sales users using field-level security.
- DChange PPS integration to update only Opportunity Amount field when the value is null.
179 Universal Containers (UC) has 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 this data into Salesforce so that Salesforce can now act as the System of Record.
What are the three considerations that a data architect should weigh before implementing this requirement?
Choose 3 answers- AEnsure the data is CRM-centric and able to populate standard or custom objects.
- BDetermine if the data is a driver of key processes implemented within Salesforce.
- CEnsure there is a tight relationship between order data and an enterprise resource planning (ERP) application.
- DA selection of the tool required to replicate the data.
- EConsider whether the data is required for sales reports, dashboards, and KPIs.
180Universal 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?- AHave the users manually clean the data in the old system prior to migration.
- BMigrate the data as is, and use Salesforce's de-duplicating feature.
- CHire an intern manually de-duplicate the records after migrating to Salesforce.
- DStore the data in a staging database, and de-duplicate identical records.
181A casino is implementing Salesforce and is planning to build a customer 360 degree view for a customer who visits its resorts. The casino currently maintains the following systems that record
customer activity:
1. Point-of-sale system: All purchases for a customer
2. Salesforce: All customer service activity and sales activities 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 four systems to provide support to customers. The information has to be current and real time.
What strategy should the data architect implement to satisfy this requirement?- AMigrate customer activities from all four systems into Salesforce.
- BUse a customer data mart to create the 360 degree view of the customer.
- CPeriodically upload summary information in Salesforce to build a 360 degree view.
- DExplore external data sources in Salesforce to build a 360 degree view of the customer.
182Universal Containers (UC) is implementing Salesforce for lead management. UC procures lead data from multiple sources and would like to make sure lead data has company profile and location information.
Which solution should a data architect recommend to make sure lead data has both profile and location information?- AExport data out of Salesforce and send to another team to populate company profile and location data.
- BRun reports to identify records which do not have company profile and location data.
- CAsk sales people to search for and populate company profile and location data.
- DLeverage external data providers to populate company profile and location data.
183Universal Containers is preparing to implement Sales Cloud and would like 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?- AImplicit sharing will automatically handle this with standard functionality.
- BCreate an owner-based sharing rule.
- CAdd appropriate users to the Account team.
- DCreate a criteria-based sharing rule.
184 Universal Containers (UC) requires 2 years of customer related cases to be available on Salesforce for operational reporting. Any cases older than 2 years and up to 7 years need to be available on demand to service agents. UC creates 5 million cases per year.
Which two data archiving strategies should a data architect recommend?
Choose 2 answers- AUse Custom objects for cases older than 2 years and use a nightly batch to move them.
- BSync cases older than 2 years to an external database and provide service agents access to the database.
- CUse Big objects for cases older than 2 years and use a nightly batch to move them.
- DUse Heroku and external objects to display cases older than 2 years and the Bulk API to hard delete them from Salesforce.
185Universal Containers is implementing Sales Cloud for patient management and would like to encrypt sensitive patient records being stored in files.
Which solution should a data architect recommend to solve this requirement?- AImplement a third-party AppExchange app to encrypt files.
- BUse classic encryption to encrypt files.
- CImplement Shield Platform Encryption to encrypt files.
- DStore files outside of Salesforce and access them in real time.
Information
- Description
- Informática Quiz on DA 1, created by Ricardo Diaz Batalla on 02/01/2026.
- Author
- Ricardo Diaz Batalla
- Language
- English
- Views
- 84
- Tags
- Rating
- No ratings yet Rate this quiz