Salesforce Data-Architect Question Answers

What is Salesforce Data-Architect?

Salesforce Data-Architect is a necessary certification exam to get certified. The certification is a reward to the deserving candidate with perfect results. The Application Architect Certification validates a candidate's expertise to work with Salesforce. In this fast-paced world, a certification is the quickest way to gain your employer's approval. Try your luck in passing the Salesforce Certified Data Architect (SU24) Exam and becoming a certified professional today. Salesforcexamdumps.com is always eager to extend a helping hand by providing approved and accepted Salesforce Data-Architect Practice Questions. Passing Salesforce Certified Data Architect (SU24) will be your ticket to a better future!

Pass with Salesforce Data-Architect Braindumps!

Contrary to the belief that certification exams are generally hard to get through, passing Salesforce Certified Data Architect (SU24) is incredibly easy. Provided you have access to a reliable resource such as Salesforcexamdumps.com Salesforce Data-Architect PDF. We have been in this business long enough to understand where most of the resources went wrong. Passing Salesforce Application Architect certification is all about having the right information. Hence, we filled our Salesforce Data-Architect Dumps with all the necessary data you need to pass. These carefully curated sets of Salesforce Certified Data Architect (SU24) Practice Questions target the most repeated exam questions. So, you know they are essential and can ensure passing results. Stop wasting your time waiting around and order your set of Salesforce Data-Architect Braindumps now!

We aim to provide all Application Architect certification exam candidates with the best resources at minimum rates. You can check out our free demo before pressing down the download to ensure Salesforce Data-Architect Practice Questions are what you wanted. And do not forget about the discount. We always provide our customers with a little extra.

Why Choose Salesforce Data-Architect PDF?

Unlike other websites, Salesforcexamdumps.com prioritize the benefits of the Salesforce Certified Data Architect (SU24) candidates. Not every Salesforce exam candidate has full-time access to the internet. Plus, it's hard to sit in front of computer screens for too many hours. Are you also one of them? We understand that's why we are here with the Application Architect solutions. Salesforce Data-Architect Question Answers offers two different formats PDF and Online Test Engine. One is for customers who like online platforms for real-like Exam stimulation. The other is for ones who prefer keeping their material close at hand. Moreover, you can download or print Salesforce Data-Architect Dumps with ease.

If you still have some queries, our team of experts is 24/7 in service to answer your questions. Just leave us a quick message in the chat-box below or email at support@salesforcexamdumps.com.

Question # 1

Universals Containers’ system administrators have been complaining that they are not able to make changes to its users’ record, including moving them to new territories without getting “unable to lock row” errors. This is causing the system admins to spend hours updating user records every day.   What should the data architect do to prevent the error?

A.    Reduce number of users updated concurrently.   
B.    Enable granular locking.   
C.    Analyze Splunk query to spot offending records.  
 D.    Increase CPU for the Salesforce org.  

Show / Hide Answer

---

Question # 2

A large automobile manufacturer has decided to use Salesforce as its CRM. It needs to maintain the following dealer types in their CRM: Local dealers Regional distributor State distributor Service dealer The attributes are different for each of the customer types. The CRM users should be allowed to enter only attributes related to the customer types. The processes and business rules for each of the customer types could be different.   How should the different dealers be maintained in Salesforce?  

A.    Use Accounts for dealers, and create record types for each of the dealer types.   
B.    Create dealers as Accounts, and build custom views for each of the dealer types.   
C.    Use Accounts for dealers and custom picklist field for each of the dealer types   
D.    Create Custom objects for each dealer types and custom fields for dealer attributes.  

Show / Hide Answer

---

Question # 3

Universal Container 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 a data architect recommends to give the sales team visibility into order status?  

A.    Leverage Canvas to bring the order management UI in to the Salesforce tab.   
B.    Build batch jobs to push order line items to salesforce.   
C.    leverage Salesforce Connect top bring the order line item from the legacy system to Salesforce.
D.    Build real-time integration to pull order line items into Salesforce when viewing orders.   

Show / Hide Answer

---

Question # 4

Northern Trail Outfitters would like to report on the type of customers. A custom field for customer type was created in Account object. Users need to be limited to the following defined choices when entering information in this field: 1.  High Value  2.  Medium Value   3.  Low Value   Which strategy should a data architect recommend to configure customer type?  

A.    Lookup to a custom object with defined choices.   
B.    Single-select restricted picklist with defined choices.   
C.    Provide help text to guide users with defined choices.   
D.    Create a validation rule to limit entry to defined choices.  

Show / Hide Answer

---

Question # 5

Universal 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?

A.          Configure Page Layout marking attributes as required fields.   
B.          Create validation rules to check If the required attributes are entered.   
C.          Mark Fields for the attributes as required under Setup.   
D.          Build validation in Integration with MDM to check required attributes.  

Show / Hide Answer

---

Question # 6

Northern Trail Outfitters is concerned because some of its data is sensitive and needs to be identified for access.   What should be used to provide ways to filter and identify the sensitive data?  

A.    Define data grouping metadata.   
B.    Implement field-level security.   
C.    Custom checkbox denoting sensitive data.
D.    Define data classification metadata.  

Show / Hide Answer

---

Question # 7

A casino is implementing salesforce and is planning to build a customer 360 view for a customer who visits its resorts. The casino currently maintained the following systems that records customer activity:   1.Point of sales system: All purchases for a customer.   2.Salesforce: All customer service activity and sales activity for a customer. 3.Mobile app: All bookings, preferences and browser activity for a customer. 4.Marketing: All email, SMS and social campaigns for a customer. Customer service agents using salesforce would like to view the activities from all system to provide supports to customers. The information has to be current and real time.   What strategy should the data architect implement to satisfy this requirement?

A.    Explore external data sources in salesforce to build 360 view of customer.  
 B.    Use a customer data mart to view the 360 view of customer.   
C.    Migrate customer activities from all 4 systems into salesforce.   
D.    Periodically upload summary information in salesforce to build 360 view.  

Show / Hide Answer

---

Question # 8

Based on government regulations, a Salesforce customer plans to implement the following in Salesforce for compliance: Access to customer information based on record ownership   Ability for customers to request removal of their information from Salesforce   Prevent users from accessing Salesforce from outside company network (virtual private network, or VPN) What should a data architect recommend to address these requirements?

A.    Contact Salesforce support to restrict access only with VPN and other requirements  
 B.    Allow users access to Salesforce through a custom web application hosted within VPN.   
C.    Implement IP restrictions, sharing settings, and custom Apex to support customer requests.   
D.    Implement Salesforce shield with Event Monitoring to address the requirement.  

Show / Hide Answer

---

Question # 9

Northern Trail Outfitters <NTO> is streaming IoT data from connected devices to a cloud database. Every 24 hours. 100,000 records are generated.   NIO employees will need to see these lol 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?

A.    Bidirectional integration   
B.    Unidirectional integration   
C.    Virtualization   
D.    Persistence  

Show / Hide Answer

---

Question # 10

Universal Containers (UC) is building a Service Cloud call center application and has a multi-system support solution. UC would like or ensure that all systems have access to the same customer information.   What solution should a data architect recommend?

A.          Make Salesforce the system of record for all data.   
B.          Implement a master data management (MDM) strategy for customer data.   
C.          Load customer data in all systems.   
D.          Let each system be an owner of data it generates.  

Show / Hide Answer

---

Question # 11

Universal Containers has been a customer of Salesforce for 10 years. Currently they have 2 million accounts in the system. Due to an erroneous integration built 3 years ago, it is estimated there are 500,000 duplicates in the system.   Which solution should a data architect recommend to remediate the duplication issue?

A.    Develop an ETL process that utilizers the merge API to merge the duplicate records   
B.    Utilize a data warehouse as the system of truth   
C.    Extract the data using data loader and use excel to merge the duplicate records   
D.    Implement duplicate rules  

Show / Hide Answer

---

Question # 12

All accounts and opportunities are created in Salesforce. Salesforce is integrated with three systems: •  An ERP system feeds order data into Salesforce and updates both Account and Opportunity records.   •  An accounting system feeds invoice data into Salesforce and updates both Account and Opportunity records.   •  A commission system feeds commission data into Salesforce and updates both Account and Opportunity records.   How should the architect determine which of these systems is the system of record?

A.          Account and opportunity data originates in Salesforce, and therefore Salesforce is the system of record.   
B.          Whatever system updates the attribute or object should be the system of record for that field or object.   
C.          Whatever integration data flow runs last will, by default, determine which system is the system of record.   
D.          Data flows should be reviewed with the business users to determine the system of record per object or field.   

Show / Hide Answer

---

Question # 13

UC is migrating individual customers (B2C) data from legacy systems to SF. There are millions of customers stored as accounts and contacts in legacy database.   Which object model should a data architect configure within SF?  

A.    Leverage person account object in Salesforce   
B.    Leverage custom person account object in SF   
C.    Leverage custom account and contact object in SF   
D.    Leverage standard account and contact object in SF  

Show / Hide Answer

---

Question # 14

Universal Containers (UC) is in the process of selling half of its company. As part of this split, UC's main Salesforce org will be divided into two org:org A and org B, UC has delivered these requirements to its data architect   1.      The data model for Org B will drastically change with different objects, fields, and picklist values.   2.      Three million records will need to be migrated from org A to org B for compliance reasons.   3.      The migrate will need occur within the next two month, prior to be split.   Which migrate strategy should a data architect use to successfully migrate the date?

A.    use as ETL tool to orchestrate the migration.   
B.    Use Data Loader for export and Data Import Wizard for import  
 C.    Write a script to use the Bulk API   
D.    Use the Salesforces CLI to query, export, and import  

Show / Hide Answer

---

Question # 15

Universal 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?

A.    Archive records to a data warehouse and run analytics on the data warehouse.   
B.    Leverage big objects to archive records and Einstein Analytics to run reports.   
C.      Leverage custom objects to store aggregate data and run analytics
D.    Leverage out-of-the-box reports and dashboard on case and interactive voice response (IVR) custom object.  

Show / Hide Answer

---

Question # 16

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?

A.    Improve existing point-to-point integrations   
B.    Data cleanse each system  
A.    Perform a onetime synchronization to level set the built up inconsistencies   
B.     An MDM solution as the customer master, with centralized integrations to ensure consistency across all systems.   

Show / Hide Answer

---

Question # 17

Universal Containers (UC) manages Vehicle and Service History in Salesforce. Vehicle (Vehicle      c) and Service History (Service-History      c) are both custom objects related through a lookup relationship.   Every week a batch synchronization process updates the Vehicle and Service History records in Salesforce. UC has two hours of migration window every week and is facing locking issues as part of the data migration process.   What should a data architect recommend to avoid locking issues without affecting performance of data migration?

A.    Use Bulk API parallel mode for data migration   
B.    Use Bulk API serial mode for data migration  
 C.    Insert the order in another custom object and use Batch Apex to move the records to Service_ Order    c object. 
D.    Change the lookup configuration to "Clear the value of this field" when lookup record is deleted.  

Show / Hide Answer

---

Question # 18

Universal Containers (UC) is migrating from a legacy system to Salesforce CRM, UC is concerned about the quality of data being entered by users and through external integrations.   Which two solutions should a data architect recommend to mitigate data quality issues?

A.    Leverage picklist and lookup fields where possible   
B.    Leverage Apex to validate the format of data being entered via a mobile device.   
C.    Leverage validation rules and workflows.   
D.    Leverage third-party- AppExchange tools  

Show / Hide Answer

---

Question # 19

Cloud Kicks has the following requirements: -  Data needs to be sent from Salesforce to an external system to generate invoices from their Order Management System (OMS).   -  A Salesforce administrator must be able to customize which fields will be sent to the external system without changing code.   What are two approaches for fulfilling these requirements? (Choose two.)

A.    A set<sobjectFieldset> to determine which fields to send in an HTTP callout.   
B.    An Outbound Message to determine which fields to send to the OMS.
C.    A Field Set that determines which fields to send in an HTTP callout.   
D.     Enable the field -level security permissions for the fields to send.  

Show / Hide Answer

---

Question # 20

Northern 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?  

A.    Create custom fields for contact preferences in Lead, Person Account, and Users objects.   
B.    Create case for contact preferences, and use this to validate the preferences for Lead, Person Accounts, and Users.   
C.    Create a custom object to maintain preferences and build relationships to Lead, Person Account, and Users.   
D.    Use Individual objects to maintain the preferences with relationships to Lead, Person Account, and Users.   

Show / Hide Answer

---

Question # 21

Northern 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

A.          Identify a location to store archived data and use scheduled batch jobs to migrate and purge the aged data on a nightly basis,   
B.          Identify a location to store archived data, and move data to the location using a time-based workflow.   
C.          Use 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.   
D.          Create a full copy sandbox, and use it as a source for retaining archived data.  

Show / Hide Answer

---

Question # 22

Universal Containers (UC) has implemented a master data management strategy, which uses a central system of truth, to ensure the entire company has the same customer information in all systems. UC customer data changes need to be accurate at all times in all of the systems. Salesforce is the identified system of record for this information.  What is the correct solution for ensuring all systems using customer data are kept up to date?  

A.          Send customer data nightly to the system of truth in a scheduled batch job.   
B.          Send customer record changes from Salesforce to each system in a nightly batch job.   
C.          Send customer record changes from Salesforce to the system of truth in real time.   
D.          Have each system pull the record changes from Salesforce using change data capture.  

Show / Hide Answer

---

Question # 23

Universal 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?

A.          Migrate legacy data to a staging database for mapping then leverage an ETL tool to transform the data and load into Salesforce.   
B.          Export legacy data into the staging database and leverage stored procedures to transform data types before loading into Salesforce.   
C.          Migrate the legacy data leveraging an ETL tool to transform data types and load data into Salesforce.   
D.          Export legacy data into CSV files and leverage data loader to load data into Salesforce.   

Show / Hide Answer

---

Question # 24

A health care provider wishes to use salesforce to track patient care. The following actions are in Salesforce Payment Providers: Orgas who pay for the care 2 patients 1.      Doctors: They provide care plan for patients and need to support multiple patients, they are provided access to patient information.  2.      Patients: They are individuals who need care.   A data architect needs to map the actor to Sf objects. What should be the optimal selection by the data architect?

A.          Patients as Contacts, Payment providers as Accounts, & Doctors as Accounts   
B.          Patients as Person Accounts, Payment providers as Accounts, & Doctors as Contacts   
C.          Patients as Person Accounts, Payment providers as Accounts, & Doctors as Person Account   
D.          Patients as Accounts, Payment providers as Accounts, & Doctors as Person Accounts   

Show / Hide Answer

---

Question # 25

Universal Containers keeps its Account data in Salesforce and its Invoice data in a third -party ERP system. They have connected the Invoice data through a Salesforce external object. They want data from both Accounts and Invoices visible in one report in one place. What two approaches should an architect suggest for achieving this solution? Choose 2 answers

A.          Create a report in an external system combining Salesforce Account data and Invoice data from the ERP.   
B.           Create a report combining data from the Account standard object and the Invoices external object
C.         Create a Visualforce page combining Salesforce Account data and Invoice external object data.   
D.           Create a separate Salesforce report for Accounts and Invoices and combine them in a dashboard.  

Show / Hide Answer

---

Question # 26

The data architect for UC 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 usages 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 performat?

A.    Remove description from the requested field set.   
B.    Change query to SOSL.   
C.    Add limit 100 to the query.   
D.    Change the where clause to filter by a deterministic defined value.

Show / Hide Answer

---

Question # 27

Ursa Major Solar's legacy system has a quarterly accounts receivable report that compiles data from the following:   -  Accounts   -  Contacts   -  Opportunities   -  Orders   -  Order Line Items   Which issue will an architect have when implementing this in Salesforce?

A.          Custom report types CANNOT contain Opportunity data.   
B.          Salesforce does NOT support Orders or Order Line Items.   
C.          Salesforce does NOT allow more than four objects in a single report type.   
D.          A report CANNOT contain data from Accounts and Contacts.  

Show / Hide Answer

---

Question # 28

Northern Trail Outfitters (NTO) has implemented Salesforce for its sales users. The opportunity management in Saiesforce Is implemented as follows:   1.  Sales users enter their opportunities in Salesforce for forecasting and reporting purposes.   2.  NTO has a product pricing system (PPS) that is used to update the Opportunity Amount field on opportunities on a daily basis.   3.  PPS is the trusted source within NTO for Opportunity Amount.   4.  NTO uses Opportunity Forecast for its sales planning and management.   Sales users have noticed that their updates to the Opportunity Amount field are overwritten when PPS updates their opportunities.   How should a data architect address this overwriting issue?

A.    Create a custom field for Opportunity amount that PSS updates separating the field sales user updates.   
B.    Change PSS integration to update only Opportunity Amount field when the value is null.   
C.    Change Opportunity Amount field access to Read Only for sales users field-level security.   
D.    Create a custom field for Opportunity amount that sales users update separating the field that PPS updates.   

Show / Hide Answer

---

Question # 29

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 opportunity amount field on opportunities on a daily basis.   PPS is the trusted source within the 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 overriding issue?

A.          Create a custom field for opportunity amount that sales users update separating the fields that PPS updates.   
B.          Create a custom field for opportunity amount that PPS updates separating the field that sales user updates.   
C.          Change opportunity amount field access to read only for sales users using field level security.   
D.          Change PPS integration to update only opportunity amount fields when values is NULL.  

Show / Hide Answer

---

Question # 30

Universal 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?

A.    Work Flow Rules  
 B.    Formatted Fields   
C.    Apex Trigger   
D.    Validation Rules  

Show / Hide Answer

---

Question # 31

Universal Containers (UC) needs to move millions of records from an external enterprise resource planning (ERP) system into Salesforce.   What should a data architect recommend to be done while using the Bulk API in serial mode instead of parallel mode?

A.    Placing 20 batches on the queue for upset jobs.   
B.    Inserting 1 million orders distributed across a variety of accounts with potential lock exceptions.   
C.    Leveraging a controlled feed load with 10 batches per job.   
D.    Inserting 1 million orders distributed across a variety of accounts with lock exceptions eliminated and managed.  

Show / Hide Answer

---

Question # 32

A large telecommunication provider that provides internet services to both residence and business has the following attributes:   A customer who purchases its services for their home will be created as an Account in Salesforce. Individuals within the same house address will be created as Contact in Salesforce. Businesses are created as Accounts in Salesforce.   Some of the customers have both services at their home and business. What should a data architect recommend for a single view of these customers without creating multiple customer records?  

A.    Customers are created as Contacts and related to Business and Residential Accounts using the Account Contact Relationships.   
B.    Customers are created as Person Accounts and related to Business and Residential Accounts using the Account Contact relationship.   
C.    Customer are created as individual objects and relate with Accounts for Business and Residence accounts.   
D.    Costumers are created as Accounts for Residence Account and use Parent Account to relate Business Account.   

Show / Hide Answer

---

Question # 33

Universal Containers (UC) owns several Salesforce orgs across a variety of business units. UC management has declared that it needs the ability to report on Accounts and Opportunities from each org in one place. Once the data is brought together into a global view, management would like to use advanced Al-driven analytics on the dataset.   Which tool should a data architect recommend to accomplish this reporting requirement?

A.    Run standard reports and dashboards.   
B.    Install a third-party AppExchange tool for multi-org reporting.   
C.    Use Einstein Analytics for multi-org.   
D.    Write a Python script to aggregate and visualize the data.  

Show / Hide Answer

---

Question # 34

Universal Containers (UC) has built a custom application on Salesforce to help track shipments around the world. A majority of the shipping records are stored on premise in an external data source. UC needs shipment details to be exposed to the custom application, and the data needs to be accessible in real time. The external data source is not OData enabled, and UC does not own a middleware tool.   Which Salesforce Connect procedure should a data architect use to ensure UC's requirements are met?

A.    Write an Apex class that makes a REST callout to the external API.   
B.    Develop a process that calls an inviable web service method.   
C.    Migrate the data to Heroku and register Postgres as a data source.   
D.    Write a custom adapter with the Apex Connector Framework.  

Show / Hide Answer

---

Question # 35

A 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 whencreating the custom VTOTime c object?

A.    Lookup Field on Project_c to VTOTime_c displaying a list of VTOTime c in a related list. 
B.    Lookup field on VTOTime_c to Project_c with formula filed on Project     c showing Sum of hours from VTOTime c records. 
C.    Master Detail Field on VTOTime_ c to Project_c with rollup summary field on Project c showing sum of hours from VTOTime_c records.   
D.    Master Detail field on Project _c to VTOTime _c showing a list of VTOTime_c Records in a related list.

Show / Hide Answer

---

Question # 36

Cloud Kicks has the following requirements: • Their Shipment custom object must always relate to a Product, a Sender, and a Receiver (all separate custom objects). • If a Shipment is currently associated with a Product, Sender, or Receiver, deletion of those records should not be allowed. • Each custom object must have separate sharing models. What should an Architect do to fulfill these requirements? 

A. Associate the Shipment to each parent record by using a VLOOKUP formula field. 
B. Create a required Lookup relationship to each of the three parent records. 
C. Create a Master-Detail relationship to each of the three parent records. 
D. Create two Master-Detail and one Lookup relationship to the parent records. 

Show / Hide Answer

---

Question # 37

Universal Containers (UC) management has identified a total of ten text fields on the Contact object as important to capture any changes made to these fields, such as who made the change, when they made the change, what is the old value, and what is the new value. UC needs to be able to report on these field data changes within Salesforce for the past 3 months. What are two approaches that will meet this requirement? Choose 2 answers 

A. Create a workflow to evaluate the rule when a record is created and use field update actions to store previous values for these ten fields in ten new fields. 
B. Write an Apex trigger on Contact after insert event and after update events and store the old values in another custom object.
 C. Turn on field Contact object history tracking for these ten fields, then create reports on contact history. 
D. Create a Contact report including these ten fields and Salesforce Id, then schedule the report to run once a day and send email to the admin. 

Show / Hide Answer

---

Question # 38

The data architect for UC 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 usages 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? 

A. Remove description from the requested field set. 
B. Change query to SOSL. ?? 
C. Add limit 100 to the query. 
D. Change the where clause to filter by a deterministic defined value. 

Show / Hide Answer

---

Question # 39

NTO 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 many 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? 

A. Customer community.
 B. Lightning external apps starter.
 C. Customer community plus. 
D. Partner community. 

Show / Hide Answer

---

Question # 40

Northern Trail Outfitters (NTO) has implemented Salesforce for its sales users. The opportunity management in Saiesforce Is implemented as follows: 1. Sales users enter their opportunities in Salesforce for forecasting and reporting purposes. 2. NTO has a product pricing system (PPS) that is used to update the Opportunity Amount field on opportunities on a daily basis. 3. PPS is the trusted source within NTO for Opportunity Amount. 4. NTO uses Opportunity Forecast for its sales planning and management. Sales users have noticed that their updates to the Opportunity Amount field are overwritten when PPS updates their opportunities. How should a data architect address this overwriting issue?

A. Create a custom field for Opportunity amount that PSS updates separating the field sales user updates. 
B. Change PSS integration to update only Opportunity Amount field when the value is null. 
C. Change Opportunity Amount field access to Read Only for sales users field-level security. 
D. Create a custom field for Opportunity amount that sales users update separating the field that PPS updates. 

Show / Hide Answer

---

Question # 41

Developers at Universal Containers need to build a report for the business which displays Accounts opened in the past year grouped by industry. This report will also include information from contacts, opportunities, and orders. There are several million Accounts in the system. Which two options should be recommended to make this report perform well and satisfy the business need?

 A. Use triggers to populate denormalized related fields on the Account. 
B. Use an indexed data field with bounded data filters. 
C. Use Formula fields to surface information I related entities on the report.
 D. Use unbounded date ranges to filter the report. 

Show / Hide Answer

---

Question # 42

Universal Containers wants to implement a data -quality process to monitor the data that users are manually entering into the system through the Salesforce UI. Which approach should the architect recommend?

A. Allow users to import their data using the Salesforce Import tools.
 B. Utilize a 3rd -party solution from the AppExchange for data uploads. 
C. Utilize an app from the AppExchange to create data -quality dashboards. 
D. Use Apex to validate the format of phone numbers and postal codes. 

Show / Hide Answer

---

Question # 43

NTO has been using salesforce for sales and service for 10 years. For the past 2 years, the marketing group has noticed a raise 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 mails? 

A. Use a 3rd-party data source to update contact information in salesforce. 
B. Email all customer and asked them to verify their information and to call NTO if their address is incorrect. 
C. Delete contacts when the mail is returned to save postal cost to NTO. 
D. Have the sales team to call all existing customers and ask to verify the contact details.

Show / Hide Answer

---

Question # 44

A large Automobile company has implemented SF for its Sales Associates. Leads flow from its website to SF using a batch integration in SF. The Batch job connects the leads to Accounts in SF. Customer visiting their retail stores are also created in SF as Accounts. The company has noticed a large number of duplicate accounts in SF. 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 scalable option should a data Architect choose to implement to avoid duplicates? 

A. Create duplicate rules in SF to validate duplicates during the account creation process 
B. Implement a MDM solution to validate the customer information before creating Accounts in SF. 
C. Build Custom search based on fields on Accounts which can be matched with customer when they visit the store 
D. Customize Account creation process to search if customer exists before creating an Account. 

Show / Hide Answer

---

Question # 45

Universal Containers (UC) has implemented Sales Cloud for its entire sales organization, UC has built a custom object called projects_c that stores customers project detail and employee bitable hours. The following requirements are needed: A subnet of individuals from the finance team will need to access to the projects object for reporting and adjusting employee utilization. The finance users will not access to any sales objects, but they will need to interact with the custom object. Which license type a data architect recommend for the finance team that best meets the requirements? 

A. Service Cloud 
B. Sales Cloud 
C. Light Platform Start 
D. Lighting platform plus 

Show / Hide Answer

---

Question # 46

An architect has been asked to provide error messages when a future date is detected in a custom Birthdate _c field on the Contact object. The client wants the ability to translate the error messages. What are two approaches the architect should use to achieve this solution? Choose 2 answers 

A. Implement a third -party validation process with translate functionality. 
B. Create a trigger on Contact and add an error to the record with a custom label. 
C. Create a workflow field update to set the standard ErrorMessage field. 
D. Create a validation rule and translate the error message with translation workbench. 

Show / Hide Answer

---

Question # 47

UC has the following system: Billing system. Customer support system. CRM system. US has been having trouble with business intelligence across the different systems. Recently US 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? 

A. Global unique customer number. 
B. Email address. 
C. Phone number. 
D. Full name. 

Show / Hide Answer

---

Question # 48

Universal Containers is creating a new B2C service offering for consumers to ship goods across continents. This is in addition to their well-established B2B offering. Their current Salesforce org uses the standard Account object to track B2B customers. They are expecting to have over 50,000,000 consumers over the next five years across their 50 business regions. B2C customers will be individuals. Household data is not required to be stored. What is the recommended data model for consumer account data to be stored in Salesforce? 

A. Use the Account object with Person Accounts and a new B2C page layout.
 B. Use the Account object with a newly created Record Type for B2C customers. 
C. Create a new picklist value for B2C customers on the Account Type field. 
D. Use 50 umbrella Accounts for each region, with customers as associated Contacts.

Show / Hide Answer

---

Question # 49

Universal Containers (UC) is implementing its new Internet of Things technology, which consists of smart containers that provide information on container temperature and humidity updated every 10 minutes back to UC. There are roughly 10,000 containers equipped with this technology with the number expected to increase to 50,000 across the next five years. It is essential that Salesforce user have access to current and historical temperature and humidity data for each container. What is the recommended solution? 

A. Create new custom fields for temperature and humidity in the existing Container custom object, as well as an external ID field that is unique for each container. These custom fields are updated when a new measure is received. 
B. Create a new Container Reading custom object, which is created when a new measure is received for a specific container. The Container Reading custom object has a masterdetail relationship to the container object. 
C. Create a new Lightning Component that displays last humidity and temperature data for a specific container and can also display historical trends obtaining relevant data from UC’s existing data warehouse. 
D. Create a new Container Reading custom object with a master-detail relationship to  Container which is created when a new measure is received for a specific container. Implement an archiving process that runs every hour. 

Show / Hide Answer

---

Question # 50

Universal Container require all customers to provide either a phone number of an email address when registering for an account. What should the data architect use to ensure this requirement is met? 

A. validation Rule 
B. required Fields
 C. Apex Class 
D. Process Builder 

Show / Hide Answer

---

Question # 51

Universal Containers (UC) maintains a collection of several million Account records that represent business in the United Sates. As a logistics company, this list is one of the most valuable and important components of UC's business, and the accuracy of shipping addresses is paramount. Recently it has been noticed that too many of the addresses of these businesses are inaccurate, or the businesses don't exist. Which two scalable strategies should UC consider to improve the quality of their Account addresses? 

A. Contact each business on the list and ask them to review and update their address information. 
B. Build a team of employees that validate Accounts by searching the web and making phone calls. 
C. Integrate with a third-party database or services for address validation and enrichment. 
D. Leverage Data.com Clean to clean up Account address fields with the D&B database. 

Show / Hide Answer

---

Question # 52

What is an advantage of using Custom metadata type over Custom setting? 

A. Custom metadata records are not copied from production to sandbox. 
B. Custom metadata types are available for reporting. 
C. Custom metadata records are deployable using packages. 
D. Custom metadata records are editable in Apex. 

Show / Hide Answer

---

Question # 53

A large automobile company has implemented Salesforce for its sales associates. Leads flow from its website to Salesforce using a batch integration in Salesforce. The batch job converts the leads to Accounts in Salesforce. Customers visiting their retail stores are also created in Salesforce as Accounts. The company has noticed a large number of duplicate Accounts in Salesforce. On analysis, it was found that certain customers could interact with its website and also visit the store. The sales associates use Global Search to search for customers in Salesforce before they create the customers. Which option should a data architect choose to implement to avoid duplicates?  

A. leverage duplicate rules in Salesforce to validate duplicates during the account creation process. 
B. Develop an Apex class that searches for duplicates and removes them nightly. 
C. Implement an MDM solution to validate the customer information before creating Salesforce. 
D. Build a custom search functionality that allows sales associates to search for customer in real time upon visiting their retail stores. 

Show / Hide Answer

---

Question # 54

Universal Containers (UC) has a complex system landscape and is implementing a data governance program for the first time Which two first steps would be appropriate for UC to initiate an assessment of data architecture? Choose 2 answers 

A. Engage with IT program managers to assess current velocity of projects in the pipeline. 
B. Engage with database administrators to assess current database performance metrics. 
C. Engage with executive sponsorship to assess enterprise data strategy and goals. 
D. Engage with business units and IT to assess current operational systems and data models. 

Show / Hide Answer

---

Question # 55

NTO need to extract 50 million records from a custom object everyday from its Salesforce org. NTO is facing query timeout issues while extracting these records. What should a data architect recommend in order to get around the time out issue? 

A. Use a custom auto number and formula field and use that to chunk records while extracting data. 
B. The REST API to extract data as it automatically chunks records by 200. 
C. Use ETL tool for extraction of records. 
D. Ask SF support to increase the query timeout value. 

Show / Hide Answer

---

Question # 56

Universal Containers has deployed Salesforce for case management The company is having difficulty understanding what percentage of cases are resolved from the initial call to their support organization. What first step is recommended to implement a reporting solution to measure the support reps case closure rates? 

A. Enable field history tracking on the Case object. 
B. Create a report on Case analytic snapshots. 
C. Install AppExchange packages for available reports. 
D. Create Contact and Opportunity Reports and Dashboards. 

Show / Hide Answer

---

Question # 57

Due to security requirements, Universal Containers needs to capture specific user actions, such as login, logout, file attachment download, package install, etc. What is the recommended approach for defining a solution for this requirement? 

A. Use a field audit trail to capture field changes. 
B. Use a custom object and trigger to capture changes. 
C. Use Event Monitoring to capture these changes. 
D. Use a third-party AppExchange app to capture changes. 

Show / Hide Answer

---

Question # 58

Universal Containers has successfully migrated 50 million records into five different objects multiple times in a full copy sandbox. The Integration Engineer wants to re-run the test again a month before it goes live into Production. What is the recommended approach to re-run the test? 

A. Truncate all 5 objects quickly and re-run the data migration test. 
B. Refresh the full copy sandbox and re-run the data migration test. 
C. Hard delete all 5 objects’ data and re-run the data migration test. 
D. Truncate all 5 objects and hard delete before running the migration test. 

Show / Hide Answer

---

Question # 59

UC is building a salesforce application to track contacts and their 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 objects? 

A. Implement a Contact Conference junction object with master detail relationship to both contact and conference__c. 
B. Create a master detail relationship field on the Contact object.
C. Create a master detail relationship field on the Conference object. 
D. Create a lookup relationship field on contact object. 

Show / Hide Answer

---

Question # 60

For a production cutover, a large number of Account records will be loaded into Salesforce from a legacy system. The legacy system does not have enough information to determine the Ownership for these Accounts upon initial load. Which two recommended options assign Account ownership to mitigate potential performance problems? 

A. Let a “system user” own all the Account records without assigning any role to this user in Role Hierarchy. 
B. Let a “system user” own the Account records and assign this user to the lowest-level role in the Role Hierarchy. 
C. Let the VP of the Sales department, who will report directly to the senior VP, own all the Account records. 
D. Let a “system user” own all the Account records and make this user part of the highestlevel role in the Role Hierarchy. 

Show / Hide Answer

---

Question # 61

Universal Containers (UC) has 1,000 accounts and 50,000 opportunities. UC has an enterprise security requirement to export all sales data outside of Salesforce on a weekly basis. The security requirement also calls for exporting key operational data that includes events such as file downloads, logins, logouts, etc. Which two recommended approaches would address the above requirement? 

A. Use Field Audit History to capture operational data and extract it to on-premise systems. 
B. Use Weekly Export to extract transactional data to on-premise systems. 
C. Use a custom built extract job to extract operational data to on-premise systems.
D. Use Event Monitoring to extract event data to on-premise systems. 

Show / Hide Answer

---

Question # 62

Which two best practices should be followed when using SOSL for searching?

 A. Use searches against single Objects for greater speed and accuracy. 
B. Keep searches specific and avoid wildcards where possible. 
C. Use SOSL option to ignore custom indexes as search fields are pre-indexed. 
D. Use Find in “ALL FIELDS” for faster searches. 

Show / Hide Answer

---

Question # 63

NTO uses salesforce to manage relationships and track sales opportunities. It has 10 million customers and 100 million opportunities. The CEO has been complaining 10 minutes to run and sometimes failed to load, throwing a time out error. Which 3 options should help improve the dashboard performance? Choose 3 answers: 

A. Use selective queries to reduce the amount of data being returned. 
B. De-normalize the data by reducing the number of joins.
C. Remove widgets from the dashboard to reduce the number of graphics loaded. 
D. Run the dashboard for CEO and send it via email. 
E. Reduce the amount of data queried by archiving unused opportunity records. 

Show / Hide Answer

---

Question # 64

Cloud Kicks has the following requirements: - Data needs to be sent from Salesforce to an external system to generate invoices from their Order Management System (OMS). - A Salesforce administrator must be able to customize which fields will be sent to the external system without changing code. What are two approaches for fulfilling these requirements? (Choose two.) 

A. A set to determine which fields to send in an HTTP callout. 
B. An Outbound Message to determine which fields to send to the OMS. 
C. A Field Set that determines which fields to send in an HTTP callout. 
D. Enable the field -level security permissions for the fields to send. 

Show / Hide Answer

---

Question # 65

Universal Containers (UC) has three systems: Salesforce, a cloud -based ERP system, and an on -premise Order Management System (OMS). An architect has been tasked with creating a solution that uses Salesforce as the system of record for Leads and the OMS as the system of record for Account and Contacts. UC wants Accounts and Contacts to be able to maintain their names in each system (i.e., "John Doe" in the OMS and "Johnny Doe" in Salesforce), but wants to have a consolidated data store which links referenced records across the systems. What approach should an architect suggest so the requirements are met?

A. Have Salesforce poll the OMS nightly and bring in the desired Accounts and Contacts. 
B. Implement an integration tool to send OMS Accounts and Contacts to Salesforce.
 C. Implement a Master Data Management strategy to reconcile Leads, Accounts, and Contacts. 
D. Use the Streaming API to send Account and Contact data from Salesforce to the OMS. 

Show / Hide Answer

---

Question # 66

DreamHouse Realty has a Salesforce org that is used to manage Contacts. What are two things an Architect should consider using to maintain data quality in this situation? (Choose two.)

 A. Use the private sharing model. 
B. Use Salesforce duplicate management.
 C. Use validation rules on new record create and edit.
 D. Use workflow to delete duplicate records. 

Show / Hide Answer

---

Question # 67

Universal Containers (UC) is implementing a formal, cross -business -unit data governance program As part of the program, UC will implement a team to make decisions on enterprise -wide data governance. Which two roles are appropriate as members of this team? Choose 2 answers

 A. Analytics/BI Owners 
B. Data Domain Stewards 
C. Salesforce Administrators
 D. Operational Data Users 

Show / Hide Answer

---

Question # 68

UC has a legacy client server app that as a relational data base that needs to be migrated to salesforce. What are the 3 key actions that should be done when data modeling in salesforce? Choose 3 answers:

A. Identify data elements to be persisted in salesforce.
 B. Map legacy data to salesforce objects.
C. Map legacy data to salesforce custom objects. 
D. Work with legacy application owner to analysis legacy data model. 
E. Implement legacy data model within salesforce using custom fields. 

Show / Hide Answer

---

Question # 69

UC is rolling out Sales App globally to bring sales teams together on one platform. UC expects millions of opportunities and accounts to be creates and is concerned about the performance of the application. Which 3 recommendations should the data architect make to avoid the data skew? Choose 3 answers. 

A. Use picklist fields rather than lookup to custom object.
 B. Limit assigning one user 10000 records ownership. 
C. Assign 10000 opportunities to one account. 
D. Limit associating 10000 opportunities to one account. 
E. Limit associating 10000 records looking up to same records.

Show / Hide Answer

---

Question # 70

Universal Containers (UC) is a major supplier of office supplies. Some products are produced by UC and some by other manufacturers. Recently, a number of customers have complained that product descriptions on the invoices do not match the descriptions in the online catalog and on some of the order confirmations (e.g., "ballpoint pen" in the catalog and "pen" on the invoice, and item color labels are inconsistent: "what vs. "White" or "blk" vs. "Black"). All product data is consolidated in the company data warehouse and pushed to Salesforce to generate quotes and invoices. The online catalog and webshop is a Salesforce Customer Community solution. What is a correct technique UC should use to solve the data inconsistency? 

A. Change integration to let product master systems update product data directly in Salesforce via the Salesforce API. 
B. Add custom fields to the Product standard object in Salesforce to store data from the different source systems. 
C. Define a data taxonomy for product data and apply the taxonomy to the product data in the data warehouse. 
D. Build Apex Triggers in Salesforce that ensure products have the correct names and labels after data is loaded into salesforce. 

Show / Hide Answer

---

Question # 71

Universal 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 updates by users. A majority of the automation tool within UC’’ 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? 

A. Ensure validation rules, triggers and other automation tools are disabled. 
B. Ensure duplication and matching rules and defined. 
C. Import the data in smaller batches over a 24-hour period. 
D. Bulkily the trigger to handle import leads. 

Show / Hide Answer

---

Question # 72

Universal Containers (UC) wants to ensure their data on 100,000 Accounts pertaining mostly to US-based companies is enriched and cleansed on an ongoing basis. UC is looking for a solution that allows easy monitoring of key data quality metrics. What should be the recommended solution to meet this requirement? 

A. Use a declarative approach by installing and configuring Data.com Clean to monitor Account data quality. 
B. Implement Batch Apex that calls out a third-party data quality API in order to monitor Account data quality. 
C. Use declarative approach by installing and configuring Data.com Prospector to monitor Account data quality. 
D. Implement an Apex Trigger on Account that queries a third-party data quality API to monitor Account data quality. 

Show / Hide Answer

---

Question # 73

Universal Containers (UC) has over 10 million accounts with an average of 20 opportunities with each account. A Sales Executive at UC needs to generate a daily report for all opportunities in a specific opportunity stage. Which two key considerations should be made to make sure the performance of the report is not degraded due to large data volume?

 A. Number of queries running at a time. 
B. Number of joins used in report query. 
C. Number of records returned by report query. 
D. Number of characters in report query. 

Show / Hide Answer

---

Question # 74

DreamHouse Realty has an integration that creates records in a Salesforce Custom Object. The Custom Object has a field marked as required on the page layout. DreamHouse Realty has noticed that many of the records coming from the external system are missing data in this field. The Architect needs to ensure this field always contains data coming from the source system. Which two approaches should the Architect take? Choose 2 answers 

A. Set up a Validation Rule to prevent blank values. 
B. Create a Workflow to default a value into this field. 
C. Mark the field required in setup at the field level. 
D. Blame the customer's external system for bad data. 

Show / Hide Answer

---

Question # 75

Universal Containers (UC) is in the process of migrating lagacy inventory data from an enterprise resources planning (ERP) system into Sales Cloud with the following requirements: Legacy inventory data will be stored in a custom child objects called Inventory_c. Inventory data should be related to the standard Account object. The Inventory_c object should Inhent the same sharing rules as the Account object. 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? 

A. Master-detail relationship filed on Account, related to Inventory_c 
B. Master-detail relationship filed on Inventory_c, related to Account 
C. Indirect lookup relationship field on Account, related to Inventory_c 
D. Lookup relationship fields on Inventory related to Account

Show / Hide Answer

---

Question # 76

A company has 12 million records, and a nightly integration queries these records. Which two areas should a Data Architect investigate during troubleshooting if queries are timing out? (Choose two.) 

A. Make sure the query doesn't contain NULL in any filter criteria. 
B. Create a formula field instead of having multiple filter criteria. 
C. Create custom indexes on the fields used in the filter criteria. 
D. Modify the integration users' profile to have View All Data. 

Show / Hide Answer

---

Salesforce Data-Architect Frequently Asked Questions