1
Q
UC is planning a massive SF 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?
A. Enable defer sharing calculations, and suspend sharing rule calculations
B. Load the data through data loader, and turn on parallel processing.
C. Leverage the Bulk API and concurrent processing with multiple batches
D. Enable granular locking to avoid “UNABLE _TO_LOCK_ROW” error.
A
A
2
Q
UC has millions of case records with case history and SLA data. UC’s compliance team would
like historical cases to be accessible for 10 years for Audit purpose.
What solution should a data architect recommend?
A. Archive Case data using Salesforce Archiving process
B. Purchase more data storage to support case object
C. Use a custom object to store archived case data.
D. Use a custom Big object to store archived case data.
A
D
3
Q
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.
A
B
4
Q
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.
A
BC
5
Q
A customer is facing locking issued when importing large data volumes of order records that are children in a master-detail relationship with the Account object. What is the recommended way to avoid locking issues during import?
A. Import Account records first followed by order records after sorting order by OrderID.
B. Import Account records first followed by order records after sorting orders by AccountID.
C. Change the relationship to Lookup and update the relationship to master-detail after import.
D. Import Order records and Account records separately and populate AccountID in orders using batch Apex.
A
B
6
Q
To address different compliance requirements, such as general data protection regulation (GDPR), personally identifiable information (PII), of health insurance Portability and Accountability Act (HIPPA) and others, a SF customer decided to categorize each data element in SF with the following:
Data owner
Security Level, such as confidential
Compliance types such as GDPR, PII, HIPPA
A compliance audit would require SF admins to generate reports to manage compliance.
What should a data architect recommend to address this requirement?
A. Use metadata API, to extract field attribute information and use the extract to classify and build reports
B. Use field metadata attributes for compliance categorization, data owner, and data sensitivity level.
C. Create a custom object and field to capture necessary compliance information and build custom reports.
D. Build reports for field information, then export the information to classify and report for Audits.
A
B
7
Q
UC has one SF 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 the orgs in near-real time.
Which 3 options should a data architect recommend to share data between Org A and Org B?
Choose 3 answers.
A. Leverage Heroku Connect and Heroku Postgres to bidirectionally sync Opportunities.
B. Install a 3rd party AppExchange tool to handle the data sharing
C. Develop an Apex class that pushes opportunity data between orgs daily via the Apex schedule.
D. Leverage middleware tools to bidirectionally send Opportunity data across orgs.
E. Use Salesforce Connect and the cross-org adapter to visualize Opportunities into external objects
A
BDE
8
Q
A large healthcare provider wishes to use Salesforce to track patient care. The following actors are in Salesforce:
- Payment providers: Organizations who pay for the care to patients.
- Doctors: They provide care plans for patients and need to support multiple patients. They are provided access to patient information.
- Patients: These are individuals who need care.
A data architect needs to map these actors to Salesforce objects.
What should be the optimal selection by the data architect?
A. Patients as Accounts, Payment providers as Accounts, and Doctors as Person Accounts
B. Patients as Person Accounts, Payment providers as Accounts, and Doctors as Person Accounts
C. Patients as Contacts, Payment providers as Accounts, and Doctors as Accounts
D. Patients as Person Accounts, Payment providers as Accounts, and Doctors as Contacts
A
B
9
Q
As part of addressing general data protection regulation (GDPR) requirements, UC plans to implement a data classification policy for all its internal systems that stores customer information including salesforce.
What should a data architect recommend so that UC can easily classify consumer information maintained in salesforce under both standard and custom objects?
A. Use App Exchange products to classify fields based on policy.
B. Use data classification metadata fields available in field definition.
C. Create a custom picklist field to capture classification of information on customer.
D. Build reports for customer information and validate.
A
B
10
Q
UC is trying to switch from legacy CRM to salesforce and wants to keep legacy CRM and salesforce in place till all the functionality is deployed in salesforce. The want to keep data in synch b/w Salesforce, legacy CRM and SAP. What is the recommendation.
A. Integrate legacy CRM to salesforce and keep data in synch till new functionality is in place
B. Do not integrate legacy CRM to Salesforce, but integrate salesforce to SAP
C. Integrate SAP with Salesforce, SAP to legacy CRM but not legacy CRM to Salesforce
D. Suggest MDM solution and link MDM to salesforce and SAP
2 answers possible
A
cd
11
Q
Universal Containers has two systems. Salesforce and an on -premise ERP system. An architect has been tasked with copying Opportunity records to the ERP once they reach a Closed/Won Stage. The Opportunity record in the ERP system will be read-only for all fields copied in from Salesforce. What is the optimal real-time approach that achieves this solution?
A. Implement a Master Data Management system to determine system of record.
B. Implement a workflow rule that sends Opportunity data through Outbound Messaging.
C. Have the ERP poll Salesforce nightly and bring in the desired Opportunities.
D. Implement an hourly integration to send Salesforce Opportunities to the ERP system.
A
b
12
Q
Universal Containers (UC) is facing data quality issues where Sales Reps are creating duplicate customer accounts, contacts, and leads. UC wants to fix this issue immediately by prompting users about a record that possibly exists in Salesforce. UC wants a report regarding duplicate records. What would be the recommended approach to help UC start immediately?
A. Create an after insert and update trigger on the account, contact and lead, and send an error if a duplicate is found using a custom matching criteria.
B. Create a duplicate rule for account, lead, and contact, use standard matching rules for these objects, and set the action to report and alert for both creates and edits.
C. Create a duplicate rule for account, lead, and contact, use standard matching rules for these objects, and set the action to block for both creates and edits.
D. Create a before insert and update trigger on account, contact, and lead, and send an error if a duplicate is found using a custom matching criteria.
A
b
13
Q
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.
A
ab
14
Q
Universal Container (US) 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?
A. Leverage real-time integration to pull records into Salesforce.
B. Bring all data Salesforce, and delete it after a year.
C. Leverage mashup to display historical records in Salesforce.
D. Build a chair solution to go the legacy system and display records.
A
c
15
Q
A manager at Cloud Kicks is importing Leads into Salesforce and needs to avoid creating duplicate records.
Which two approaches should the manager take to achieve this goal? (Choose two.)
A. Acquire an AppExchange Lead de-duplication application.
B. Implement Salesforce Matching and Duplicate Rules.
C. Run the Salesforce Lead Mass de-duplication tool.
D. Create a Workflow Rule to check for duplicate records.
A
ab
16
Q
Universal Containers (UC) loads bulk leads and campaigns from third-party lead aggregators on a weekly and monthly basis. The expected lead record volume is 500K records per week, and the expected campaign records volume is 10K campaigns per week. After the upload, Lead records are shared with various sales agents via sharing rules and added as Campaign members via Apex triggers on Lead creation. UC agents work on leads for 6 months, but want to keep the records in the system for at least 1 year for reference. Compliance requires them to be stored for a minimum of 3 years. After that, data can be deleted. What statement is true with respect to a data archiving strategy for UC?
A. UC can store long-term lead records in custom storage objects to avoid counting against storage limits.
B. UC can leverage the Salesforce Data Backup and Recovery feature for data archival needs.
C. UC can leverage recycle bin capability, which guarantees record storage for 15 days after deletion.
D. UC can leverage a “tier”-based approach to classify the record storage need.
A
d
17
Q
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.
A
D
18
Q
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:
Data will be used to drive marketing and product development initiatives.
NTO estimates that the program will generate 100 million rows of date monthly.
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?
A. Create a custom big object in Salesforce which will be used to capture the Reward Program data for consumption by Einstein.
B. Have Einstein connect to the point of sales system to capture the Reward Program data.
C. Create a big object in Einstein Analytics to capture the Loyalty Program data.
D. Create a custom object in Salesforce that will be used to capture the Reward Program data.
A
a
19
Q
Cloud Kicks is launching a Partner Community, which will allow users to register shipment requests that are then processed by Cloud Kicks employees. Shipment requests contain header information, and then a list of no more than 5 items being shipped.
First, Cloud Kicks will introduce its community to 6,000 customers in North America, and then to 24,000 customers worldwide within the next two years. Cloud Kicks expects 12 shipment requests per week per customer, on average, and wants customers to be able to view up to three years of shipment requests and use Salesforce reports.
What is the recommended solution for the Cloud Kicks Data Architect to address the requirements?
A. Create an external custom object to track shipment requests and a child external object to track shipment items. External objects are stored off-platform in Heroku’s Postgres database.
B. Create an external custom object to track shipment requests with five lookup custom fields for each item being shipped. External objects are stored off-platform in Heroku’s Postgres database.
C. Create a custom object to track shipment requests and a child custom object to track shipment items.
Implement an archiving process that moves data off-platform after three years.
D. Create a custom object to track shipment requests with five lookup custom fields for each item being shipped Implement an archiving process that moves data off-platform after three years.
A
c
20
Q
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.
A
b
21
Q
NTO has multiple systems across its enterprise landscape including salesforce, with disparate version the customer records.
In salesforce, the customer is represented by the contact object.
NTO utilizes an MDM solution with these attributes:
1.The MDM solution keeps track of customer master with a master key.
2.The master key is a map to the record ID’s from each external system that customer data is stored within.
3.The MDM solution provides de-duplication features, so it acts as the single source of truth.
How should a data architect implement the storage of master key within salesforce?
A. Store the master key in Heroku postgres and use Heroku connect for synchronization.
B. Create a custom object to store the master key with a lookup field to contact.
C. Create an external object to store the master key with a lookup field to contact.
D. Store the master key on the contact object as an external ID (Field for referential imports)
A
d
22
Q
Universal Containers (UC) has an open sharing model for its Salesforce users to allow all its Salesforce internal users to edit all contacts, regardless of who owns the contact. However, UC management wants to allow only the owner of a contact record to delete that contact. If a user does not own the contact, then the user should not be allowed to delete the record. How should the architect approach the project so that the requirements are met?
A. Create a “before delete” trigger to check if the current user is not the owner.
B. Set the Sharing settings as Public Read Only for the Contact object.
C. Set the profile of the users to remove delete permission from the Contact object.
D. Create a validation rule on the Contact object to check if the current user is not the owner.
A
a
23
Q
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.
A
cd
24
Q
Universal Container (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 this inventory data to Sales Cloud without a import. UC has asked its data architect to determine if Salesforce Connect is needed.
Which three consideration should the data architect make when evaluating the need for Salesforce Connect?
A. You want real-time access to the latest data, from other systems.
B. You have a large amount of data and would like to copy subsets of it into Salesforce.
C. You need to expose data via a virtual private connection.
D. You have a large amount of data that you don’t want to copy into your Salesforce org.
E. You need to small amounts of external data at any one time.
A
ade
25
Universal Containers (UC) is expecting to have nearly 5 million shipments records in its Salesforce org. Each shipment record has up to 10 child shipment item records. The Shipment custom object has an Organization-wide Default (OWD) sharing model set to Private and the Shipment Item custom object has a Master-Detail relationship to Shipment. There are 25 sharing rules set on the Shipment custom object, which allow shipment records to be shared to each of UC's 25 business areas around the globe. These sharing rules use public groups, one for each business area plus a number of groups for management and support roles. UC has a high turnover of Sales Reps and often needs to move Sales Reps between business areas in order to meet local demand. What feature would ensure that performance, when moving Sales Reps between regions, remains adequate while meeting existing requirements?
A. Implement data archiving for old Shipment records.
B. Contact Salesforce to create Skinny tables on Shipment.
C. Configure shipment OWD to Public Read/Write.
D. Contact Salesforce to enable Defer Sharing Rules
d
26
Universal Containers is planning out their archiving and purging plans going forward for their custom objects Topic__c and Comment__c. Several options are being considered, including analytics snapshots, offsite storage, scheduled purges, etc. Which three questions should be considered when designing an appropriate archiving strategy?
A. How many fields are defined on the custom objects that need to be archived?
B. Which profiles and users currently have access to these custom object records?
C. If reporting is necessary, can the information be aggregated into fewer, summary records?
D. Will the data being archived need to be reported on or accessed in any way in the future?
E. Are there any regulatory restrictions that will influence the archiving and purging plans?
cde
27
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.
a
28
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 object?
A. Use DX to create big object.
B. Use Metadata API to create big object.
C. Go to Big Object in setup select new to create big object.
D. Go to Object Manager in setup and select new to create big object.
bc
29
Universal Containers has 30 million case records. The Case object has 80 fields. Agents are reporting reports in the Salesforce org.
Which solution should a data architect recommend to improve reporting performance?
A. Create a custom object to store aggregate data and run reports.
B. Contact Salesforce support to enable skinny table for cases.
C. Move data off of the platform and run reporting outside Salesforce, and give access to reports.
D. Build reports using custom Lightning components.
b
30
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.
bc
31
Universal Containers has a large volume of Contact data going into Salesforce.com. There are 100,000 existing contact records. 200,000 new contacts will be loaded. The Contact object has an external ID field that is unique and must be populated for all existing records. What should the architect recommend to reduce data load processing time?
A. Load Contact records together using the Streaming API via the Upsert operation.
B. Delete all existing records, and then load all records together via the Insert operation.
C. Load all records via the Upsert operation to determine new records vs. existing records.
D. Load new records via the Insert operation and existing records via the Update operation.
d
32
Northern Trail Outfitters needs to implement an archive solution for Salesforce dat a. 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.
a
33
Universal Container is Implementing salesforce and needs to migrate data from two legacy systems. UC would like to clean and duplicate data before migrate to Salesforce.
Which solution should a data architect recommend a clean migration?
A. Define external IDs for an object, migrate second database to first database, and load into Salesforce.
B. Define duplicate rules in Salesforce, and load data into Salesforce from both databases.
C. Set up staging data base, and define external IDs to merge, clean duplicate data, and load into Salesforce.
D. Define external IDs for an object, Insert data from one database, and use upsert for a second database
c
34
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.
d
35
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.
cd
36
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
ab
37
Universal Containers (UC) has users complaining about reports timing out or simply taking too long to run What two actions should the data architect recommend to improve the reporting experience? Choose 2 answers
A. Index key fields used in report criteria.
B. Enable Divisions for large data objects.
C. Create one skinny table per report.
D. Share each report with fewer users.
ab
38
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?
A. Utilize the Authorization Form Consent object to capture the consent.
B. Use AppExchange solution to address the requirement.
C. Create a custom object to maintain the authorization.
D. Use custom fields to capture the authorization details.
a
39
Northern Trail Outfitters has these simple requirements for a data export process:
File format should be in CSV.
Process should be scheduled and run once per week.
The expert should be configurable through the Salesforce UI.
Which tool should a data architect leverage to accomplish these requirements?
A. Bulk API
B. Data export wizard
C. Third-party ETL tool
D. Data loader
b
40
Salesforce is being deployed in Ursa Major Solar's disparate, multi-system ERP environment. Ursa major Solar wants to maintain data synchronization between systems.
Which two techniques should be used to achieve this goal? (Choose two.)
A. Integrate Salesforce with the ERP environment.
B. Utilize workbench to update files within systems.
C. Utilize an MDM strategy to outline a single source of truth.
D. Build synchronization reports and dashboards.
ac
41
Universal Containers (UC) has lead assignment rules to assign leads to owners. Leads not routed by assignment rules are assigned to a dummy user. Sales rep are complaining of high load times and issues with accessing leads assigned to the dummy user.
What should a data architect recommend to solve these performance issues?
A. Assign dummy user last role in role hierarchy
B. Create multiple dummy user and assign leads to them
C. Assign dummy user to highest role in role hierarchy
D. Periodically delete leads to reduce number of leads
b
42
A customer is operating in a highly reputated industry and is planning to implement SF. The customer information maintained in SF, includes the following:
* Personally, identifiable information (PII)
* IP restrictions on profiles organized by Geographic location
* Financial records that need to be private and accessible only by the assigned Sales associate.
* User should not be allowed to export information from Salesforce.
Enterprise security has mandate access to be restricted to users within a specific geography and detail monitoring of user activity. Which 3 Salesforce shield capabilities should a data architect recommend? Choose
3 answers:
A. Event monitoring to monitor all user activities
B. Restrict access to SF from users outside specific geography
C. Prevent Sales users access to customer PII information
D. Transaction security policies to prevent export of SF Data.
E. Encrypt Sensitive Customer information maintained in SF.
ade
43
Universal Container (UC) has accumulated data over years and has never deleted data from its Salesforce org.
UC is now exceeding the storage allocations in the org. UC is now looking for option to delete unused from the org.
Which three recommendations should a data architect make is order to reduce the number of records from the org?
Choose 3 answers
A. Use hard delete in Bulk API to permanently delete records from Salesforce.
B. Use hard delete in batch Apex to permanently delete records from Salesforce.
C. Identify records in objects that have not been modified or used In last 3 years.
D. Use Rest API to permanently delete records from the Salesforce org.
E. Archive the records in enterprise data warehouse (EDW) before deleting from Salesforce.
ace
44
What makes Skinny tables fast? Choose three answers.
A. They do not include soft-deleted records
B. They avoid resource intensive joins
C. Their tables are kept in sync with their source tables when the source tables are modified
D. They can contain fields from other objects
E. They support up to a max of 100 of columns
abc
45
Universal Containers (UC) has a data model as shown in the image. The Project object has a private sharing model, and it has Roll -Up summary fields to calculate the number of resources assigned to the project, total hours for the project, and the number of work items associated to the project. What should the architect consider, knowing there will be a large amount of time entry records to be loaded regularly from an external system into Salesforce.com?
A. Load all data using external IDs to link to parent records.
B. Use workflow to calculate summary values instead of Roll -Up.
C. Use triggers to calculate summary values instead of Roll -Up.
D. Load all data after deferring sharing calculations.
d
46
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.
a
47
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.
c
48
Northern trail Outfitters (NTO) uses Sales Cloud and service Cloud to manage sales and support processes.
Some of NTOs team are complaining they see new fields on their page unsure of which values need be input.
NTO is concerned about lack of governance in making changes to Salesforce.
Which governance measure should a data architect recommend to solve this issue?
A. Add description fields to explain why the field is used, and mark the field as required.
B. Create and manage a data dictionary and ups a governance process for changes made to common objects.
C. Create reports to identify which users are leaving blank, and use external data sources o agreement the missing data.
D. Create validation rules with error messages to explain why the fields is used
b
49
Universal 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 change of encountering race condition on the same record.
What should a data architect recommend to guarantee that records are not being updated at the same time?
A. Embed the keywords FOR UPDATE after SOQL statements.
B. Disable classes or triggers that have the potential to obtain the same record.
C. Migrate programmatic logic to processes and flows.
D. Refactor or optimize classes and trigger for maximum CPU performance.
a
50
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.
abd
51
UC has millions of Cases and are running out of storage. Some user groups need to have access to historical cases for up to 7 years.
Which 2 solutions should a data architect recommend in order to minimize performance and storage issues?
Choose 2 answers:
A. Export data out of salesforce and store in Flat files on external system.
B. Create a custom object to store case history and run reports on it.
C. Leverage on premise data archival and build integration to view archived data.
D. Leverage big object to archive case data and lightning components to show archived data.
cd
52
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.
c
53
Universal Containers has millions of rows of data in Salesforce that are being used in reports to evaluate historical trends. Performance has become an issue, as well as data storage limits. Which two strategies should be recommended when talking with stakeholders?
A. Use scheduled batch Apex to copy aggregate information into a custom object and delete the original records.
B. Combine Analytics Snapshots with a purging plan by reporting on the snapshot data and deleting the original records.
C. Use Data Loader to extract data, aggregate it, and write it back to a custom object, then delete the original records.
D. Configure the Salesforce Archiving feature to archive older records and remove them from the data storage limits.
ad
54
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.
a
55
Universal Containers (UC) is a business that works directly with individual consumers (B2C). They are moving from a current home-grown CRM system to Salesforce. UC has about one million consumer records.
What should the architect recommend for optimal use of Salesforce functionality and also to avoid data loading issues?
A. Create a Custom Object Individual Consumer c to load all individual consumers.
B. Load all individual consumers as Account records and avoid using the Contact object.
C. Load one Account record and one Contact record for each individual consumer.
D. Create one Account and load individual consumers as Contacts linked to that one Account.
c
56
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
a
57
Get Cloudy Consulting uses an invoicing system that has specific requirements. One requirement is that attachments associated with the Invoice_c custom object be classified by Types (i.e., ""Purchase Order"",
""Receipt"", etc.) so that reporting can be performed on invoices showing the number of attachments grouped by Type.
What should an Architect do to categorize the attachments to fulfill these requirements?
A. Add additional options to the standard ContentType picklist field for the Attachment object.
B. Add a ContentType picklist field to the Attachment layout and create additional picklist options.
C. Create a custom picklist field for the Type on the standard Attachment object with the values.
D. Create a custom object related to the Invoice object with a picklist field for the Type.
C
58
Universal Containers (UC) has adopted Salesforce as its primary sales automated tool. UC has 100,00 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 a customer record and view their account status, Invoice history, and opportunities without navigating outside of Salesforce.
What should a data architect use to provide the sales team with the required functionality?
A. Create a custom object and migrate the last 12 months of Invoice data into Salesforce so it can be displayed on the Account layout.
B. Write an Apex callout and populate a related list to display on the account record.
C. Create a mashup page that will present the billing system records within Salesforce.
D. Create a visual force tab with the billing system encapsulated within an iframe.
c
59
Universal Containers (UC) uses Salesforce for tracking opportunities (Opportunity). UC uses an internal ERP system for tracking deliveries and invoicing. The ERP system supports SOAP API and OData for bi-directional integration between Salesforce and the ERP system. UC has about one million opportunities. For each opportunity, UC sends 12 invoices, one per month. UC sales reps have requirements to view current invoice status and invoice amount from the opportunity page. When creating an object to model invoices, what should the architect recommend, considering performance and data storage space?
A. Use Streaming API to get the current status from the ERP and display on the Opportunity page.
B. Create an external object Invoice _x with a Lookup relationship with Opportunity.
C. Create a custom object Invoice _c with a master -detail relationship with Opportunity.
D. Create a custom object Invoice _c with a Lookup relationship with Opportunity.
b
60
A customer wants to maintain geographic location information including latitude and longitude in a custom object. What would a data architect recommend to satisfy this requirement?
A. Create formula fields with geolocation function for this requirement.
B. Create custom fields to maintain latitude and longitude information
C. Create a geolocation custom field to maintain this requirement
D. Recommend app exchange packages to support this requirement.
c
61
Universal containers is implementing Salesforce lead management. UC Procure lead data from multiple sources and would like to make sure lead data as company profile and location information. Which solution should a data architect recommend to make sure lead data has both profile and location information?
A. Ask sales people to search for populating company profile and location data
B. Run reports to identify records which does not have company profile and location data
C. Leverage external data providers populate company profile and location data
D. Export data out of Salesforce and send to another team to populate company profile and location data
c
62
Universal Containers has a legacy system that captures Conferences and Venues. These Conferences can occur at any Venue. They create hundreds of thousands of Conferences per year. Historically, they have only used
20 Venues. Which two things should the data architect consider when denormalizing this data model into a single Conference object with a Venue picklist? Choose 2 answers
A. Limitations on master -detail relationships.
B. Org data storage limitations.
C. Bulk API limitations on picklist fields.
D. Standard list view in -line editing.
cd
63
Universal Containers (CU) 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?
A. Install a third-party AppExchange tool.
B. Call the REST API in successive queries.
C. Utilize PK Chunking with the Bulk API.
D. Use the Bulk API in parallel mode.
c
64
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.
c
65
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.
b
66
Universal Containers (UC) has a requirement to create an Account plan object that is related to the Account object. Each Account plan needs to have an Account object, but the accessibility requirement of the Account plan is different from the Account object. What should an Architect recommend?
A. Create a custom account plan object as detail with Account as mater in a master-detail relationship.
B. Create a custom account plan object as detail with Account as master with additional sharing rules to allow access.
C. Create an account plan object with a lookup relations to Account without any validation rules to enforce the Account association.
D. Create an account plan object with a lookup relationship to Account with validation rules to enforce the Account association.
d
67
Universal Containers (UC) provides shipping services to its customers. They use Opportunities to track customer shipments. At any given time, shipping status can be one of the 10 values. UC has 200,000 Opportunity records. When creating a new field to track shipping status on opportunity, what should the architect do to improve data quality and avoid data skew?
A. Create a picklist field, values sorted alphabetically.
B. Create a Master -Detail to custom object ShippingStatus c.
C. Create a Lookup to custom object ShippingStatus c.
D. Create a text field and make it an external ID.
a
68
Universal Containers has a roll-up 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?
A. Defer roll-up summary field calculation during data migration.
B. Perform a batch job in serial mode and reduce the batch size.
C. Perform a batch job in parallel mode and reduce the batch size.
D. Leverage Data Loader’s platform API to load data.
B
69
Universal Containers (UC) is implementing Salesforce and will be using Salesforce to:
* Track customer complaints
* Provide white papers on products
* Provide subscription-based support
Which license type will UC users need to fulfill UC’s requirements?
A. Sales Cloud License
B. Lightning Platform Starter License
C. Service Cloud License
D. Salesforce License
C
70
The architect is planning a large data migration for Universal Containers from their legacy CRM system to Salesforce. What three things should the architect consider to optimize performance of the data migration?
Choose 3 answers
A. Review the time zones of the User loading the data.
B. Remove custom indexes on the data being loaded.
C. Determine if the legacy system is still in use.
D. Defer sharing calculations of the Salesforce Org.
E. Deactivate approval processes and workflow rules.
BDE
71
Universal Containers wants to develop a dashboard in Salesforce that will allow Sales Managers to do data exploration using their mobile device (i.e., drill down into sales-related data) and have the possibility of adding ad-hoc filters while on the move. What is a recommended solution for building data exploration dashboards in Salesforce?
A. Create a Dashboard in an external reporting tool, export data to the tool, and add link to the dashboard in Salesforce.
B. Create a Dashboard in an external reporting tool, export data to the tool, and embed the dashboard in Salesforce using the Canval toolkit.
C. Create a standard Salesforce Dashboard and connect it to reports with the appropriate filters.
D. Create a Dashboard using Analytics Cloud that will allow the user to create ad-hoc lenses and drill down.
d
72
UC has a classic encryption for Custom fields and is leveraging weekly data reports for data backups. During the data validation of exported data UC discovered that encrypted field values are still being exported as part of data exported. What should a data architect recommend to make sure decrypted values are exported during data export?
A. Set a standard profile for Data Migration user, and assign view encrypted data
B. Create another field to copy data from encrypted field and use this field in export
C. Leverage Apex class to decrypt data before exporting it.
D. Set up a custom profile for data migration user and assign view encrypted data.
d
73
Universal Containers (UC) wants to store product data in Salesforce, but the standard Product object does not support the more complex hierarchical structure which is currently being used in the product master system.
How can UC modify the standard Product object model to support a hierarchical data structure in order to synchronize product data from the source system to Salesforce?
A. Create a custom lookup filed on the standard Product to reference the child record in the hierarchy.
B. Create a custom lookup field on the standard Product to reference the parent record in the hierarchy.
C. Create a custom master-detail field on the standard Product to reference the child record in the hierarchy.
D. Create an Apex trigger to synchronize the Product Family standard picklist field on the Product object.
b
74
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.
a
75
Which three characteristics of a skinny table help improve report and query performance?
A. Skinny tables can contain frequently used fields and thereby help avoid joins.
B. Skinny tables can be used to create custom indexes on multi-select picklist fields.
C. Skinny tables provide a view across multiple objects for easy access to combined data.
D. Skinny tables are kept in sync with changes to data in the source tables.
E. Skinny tables do not include records that are available in the recycle bin.
ade
76
Get Cloudy Consulting needs to evaluate the completeness and consistency of contact information in Salesforce. Their sales reps often have incomplete information about their accounts and contacts. Additionally, they are not able to interpret the information in a consistent manner. Get Cloudy Consulting has identified certain ""key"" fields which are important to their sales reps.
What are two actions Get Cloudy Consulting can take to review their data for completeness and consistency?
(Choose two.)
A. Run a report which shows the last time the key fields were updated.
B. Run one report per key field, grouped by that field, to understand its data variability.
C. Run a report that shows the percentage of blanks for the important fields.
D. Run a process that can fill in default values for blank fields.
bc
77
A custom pricing engine for a Salesforce customer has to be decided by factors with the following hierarchy:
State in which the customer is located
City in which the customer is located if available
Zip code in which the customer is located if available
Changes to this information should have minimum code changes
What should a data architect recommend to maintain this information for the custom pricing engine that is to be built in Salesforce?
A. Create a custom object to maintain the pricing criteria.
B. Assign the pricing criteria within customer pricing engine.
C. Maintain require pricing criteria in custom metadata types.
D. Configure the pricing criteria in price books.
c
78
Universal Containers wants to automatically archive all inactive Account data that is older than 3 years. The information does not need to remain accessible within the application. Which two methods should be recommended to meet this requirement? Choose 2 answers
A. Use the Force.com Workbench to export the data.
B. Schedule a weekly export file from the Salesforce UI.
C. Schedule jobs to export and delete using an ETL tool.
D. Schedule jobs to export and delete using the Data Loader.
CD
79
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.
b
80
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.
d
81
Universal Containers (UC) wants to capture information on how data entities are stored within the different applications and systems used within the company. For that purpose, the architecture team decided to create a data dictionary covering the main business domains within UC. Which two common techniques are used building a data dictionary to store information on how business entities are defined?
A. Use Salesforce Object Query Language.
B. Use a data definition language.
C. Use an entity relationship diagram.
D. Use the Salesforce Metadata API.
cd
82
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
C. Perform a onetime synchronization to level set the built up inconsistencies
D. An MDM solution as the customer master, with centralized integrations to ensure consistency across all systems.
d
83
Universal 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 Saleforce and archive older data out of Salesforce.
Which solution should a data architect recommend as an archiving solution?
A. Use a third-party backup solution to backup all data off platform.
B. Build a batch join move all records off platform, and delete all records from Salesforce.
C. Build a batch join to move two-year-old records off platform, and delete records from Salesforce.
D. Build a batch job to move all restore off platform, and delete old records from Salesforce.
c
84
UC is migrating data from legacy system to SF. UC would like to preserve the following information on records being migrated:
Date time stamps for created date and last modified date.
Ownership of records belonging to inactive users being migrated to Salesforce.
Which 2 solutions should a data architect recommends to preserve the date timestamps and ownership on records? Choose 2 answers.
A. Log a case with SF to update these fields
B. Enable update records with Inactive Owners Permission
C. Enable Set Audit fields upon Record Creation Permission
D. Enable modify all and view all permission.
bc
85
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.
C
86
Universal 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 source as comma-separated values (CSV) files for marketing purposes. Historically, UC would load contact 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 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 avoid storage issues in the future?
A. Load the CSV files in Einstein Analytics and sync with Marketing Cloud prior to sending marketing communications;
B. Load the CSV files in an external database and sync with Marketing Cloud prior to sending marketing communications.
C. Load the contacts directly to Marketing Cloud and have a reconciliation process to track prospects that are converted to customers.
D. Continue to use the existing process to use Lead object to sync with Marketing Cloud and delete Lead records from Sales after the sync is complete.
c
87
Northern trail Outfitters (NTO) runs its entire out of an enterprise data warehouse (EDW), NTD's sales team starting to use Salesforce after a recent implementation, but currently lacks data required to advanced and opportunity to the next stage.
NTO's management has research 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?
A. Maximum number for records returned
B. OData callout limits per day
C. Maximum page size for server-driven paging
D. Maximum external objects per org
b
88
DreamHouse Realty has a data model as shown in the image. The Project object has a private sharing model, and it has Roll-Up summary fields to calculate the number of resources assigned to the project, total hours for the project, and the number of work items associated to the project.
There will be a large amount of time entry records to be loaded regularly from an external system into Salesforce. https://www.freecram.net/question/Salesforce.Data-Architect.v2024-07-02.q124/dreamhouse-realty-has-a-data-model-as-shown-in-the-image-the-project-object-has-a-private-sharing-model
What should the Architect consider in this situation?
A. Load all data after deferring sharing calculations.
B. Calculate summary values instead of Roll-Up by using workflow.
C. Calculate summary values instead of Roll-Up by using triggers.
D. Load all data using external IDs to link to parent records.
a
89
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.
a
90
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.
a
91
Northern Trail Outfitters (NTO) has a variety of customers that include householder, businesses, and individuals.
The following conditions exist within its system:
NTO has a total of five million customers.
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 option should a data architect perform to resolve the issues with the customer data?
A. Create a unique global customer ID for each customer and store that in all system for referential identity.
B. Use Salesforce CDC to sync customer data cross all systems to keep customer record in sync.
C. Invest in data duplicate tool to de-dupe and merge duplicate records across all systems.
D. Duplicate customer records across the system and provide a two-way sync of data between the systems.
E. Create a customer master database external to Salesforce as a system of truth and sync the customer data with all systems.
ace
92
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.
c
93
What 2 data management policies does the data classification feature allow customers to classify in salesforce?
Choose 2 answers:
A. Reference data policy.
B. Data governance policy.
C. Data sensitivity level
D. Compliance categorization policy.
cd
94
Universal Container has a Sales Cloud implementation for a sales team and an enterprise resource planning (ERP) as a customer master Sales team are complaining about duplicate account and data quality issues with account data.
Which two solutions should a data architect recommend to resolve the complaints?
A. Build a nightly batch job to de-dupe data, and merge account records.
B. Integrate Salesforce with ERP, and make ERP as system of truth.
C. Build a nightly sync job from ERP to Salesforce.
D. Implement a de-dupe solution and establish account ownership in Salesforce
bd
95
During the implementation of Salesforce, a customer has the following requirements for Sales Orders:
1. Sales Order information needs to be shown to users in Salesforce.
2. Sales Orders are maintained in the on-premises 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?
A. Us custom objects to maintain Sales Orders in Salesforce.
B. Use custom big objects to maintain Sales Orders in Salesforce.
C. Use external objects to maintain Sales Order in Salesforce.
D. Use Standard order object to maintain Sale Orders in Salesforce
c
96
Get Cloudy Consulting monitors 15,000 servers, and these servers automatically record their status every 10 minutes. Because of company policy, these status reports must be maintained for 5 years. Managers at Get Cloudy Consulting need access to up to one week's worth of these status reports with all of their details.
An Architect is recommending what data should be integrated into Salesforce and for how long it should be stored in Salesforce.
Which two limits should the Architect be aware of? (Choose two.)
A. Data storage limits
B. Workflow rule limits
C. API Request limits
D. Webservice callout limits
ac
97
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.
d
98
UC 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.
A. Activate validation rules once the leads are loaded into salesforce to maintain quality.
B. Allow validation rules to be activated during the load of leads into salesforce.
C. Develop custom APEX batch process to improve quality once the load is completed.
D. Ensure the lead data is preprocessed for quality before loading into salesforce.
d
99
Universal Containers (UC) is using Salesforce Sales & Service Cloud for B2C sales and customer service but they are experiencing a lot of duplicate customers in the system. Which are two recommended approaches for UC to avoid duplicate data and increase the level of data quality?
A. Use Duplicate Management.
B. Use an Enterprise Service Bus.
C. Use Data.com Clean
D. Use a data warehouse.
ac
100
Universal Containers uses Apex jobs to create leads in Salesforce. The business team has requested that lead creation failures should be reported to them.
Which option does Apex provide to report errors from this Apex job?
A. Use Custom Object to store leads, and allow unprocessed leads to be reported.
B. Save Apex errors in a custom object, and allow access to this object for reporting.
C. Use Apex services to email failures to business when error occurs.
D. Use AppExchange package to clean lead information before Apex job processes them.
b
101
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.
a
102
Universal Containers is setting up an external Business Intelligence (BI) system and wants to extract 1,000,000 Contact records. What should be recommended to avoid timeouts during the export process?
A. Use the SOAP API to export data.
B. Utilize the Bulk API to export the data.
C. Use GZIP compression to export the data.
D. Schedule a Batch Apex job to export the data.
b
103
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 highest-level role in the Role Hierarchy.
## Footnote
Choose 2 answers
AD
104
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.
ac
105
As part of a phased Salesforce rollout. there will be 3 deployments spread out over the year. The requirements have been carefully documented. Which two methods should an architect use to trace back configuration changes to the detailed requirements? Choose 2 answers
A. Review the setup audit trail for configuration changes.
B. Put the business purpose in the Description of each field.
C. Maintain a data dictionary with the justification for each field.
D. Use the Force.com IDE to save the metadata files in source control.
BC
106
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.
B
107
Universal Containers is experiencing frequent and persistent group membership locking issues that severely restricts its ability to manage manual and a automated updates at the same time.
What should a data architect do in order to restore the issue?
A. Enable granular locking
B. Enable parallel sharing rule calculation.
C. Enable defer sharing calculation
D. Enable implicit sharing
a
108
NTO has decided to franchise its brand. Upon implementation, 1000 franchisees will be able to access BTO's product information and track large customer sales and opportunities through a portal. The Franchisees will also be able to run monthly and quarterly sales reports and projections as well as view the reports in dashboards.
Which licenses does NTO need to provide these features to the Franchisees?
A. Salesforce Sales Cloud license
B. Lightning Platform license
C. Customer Community license
D. Partner Community license
d
109
Universal Containers (UC) has deployed Salesforce to manage Marketing. Sales, and Support efforts in a multi
-system ERP environment After reaching the limits of native reports & dashboards. UC leadership is looking to understand what options can be used to provide more analytical insights. What two approaches should an architect recommend? Choose 2 answers
A. AppExchange Apps
B. Wave Analytics
C. Weekly Snapshots
D. Setup Audit Trails
ab
110
North Trail Outfitters (NTD) 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?
A. Standard reports and dashboards
B. Async SOQL with a custom object
C. Standard SOQL queries
D. Einstein Analytics
bd
111
Universal Containers is looking to use Salesforce to manage their sales organization. They will be migrating legacy account data from two aging systems into Salesforce. Which two design considerations should an architect take to minimize data duplication? Choose 2 answers
A. Use a workflow to check and prevent duplicates.
B. Clean data before importing to Salesforce.
C. Use Salesforce matching and duplicate rules.
D. Import the data concurrently.
BC
112
Two million Opportunities need to be loaded in different batches into Salesforce using the Bulk API in parallel mode.
What should an Architect consider when loading the Opportunity records?
A. Use the Name field values to sort batches.
B. Order batches by Auto-number field.
C. Create indexes on Opportunity object text fields.
D. Group batches by the AccountId field.
d
113
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 master-detail 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.
d
114
To avoid creating duplicate Contacts, a customer frequently uses Data Loader to upsert Contact records into Salesforce. What common error should the data architect be aware of when using upsert?
A. Errors with duplicate external Id values within the same CSV file.
B. Errors with records being updated and inserted in the same CSV file.
C. Errors when a duplicate Contact name is found cause upsert to fail.
D. Errors with using the wrong external Id will cause the load to fail.
a
115
Which two aspects of data does an Enterprise data governance program aim to improve? (Choose two)
A. Data integrity
B. Data distribution
C. Data usability
D. Data modeling
ac
116
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.
bc
117
Universal Containers (UC) loads bulk leads and campaigns from third-party lead aggregators on a weekly and monthly basis. The expected lead record volume is 500K records per week, and the expected campaign records volume is 10K campaigns per week. After the upload, Lead records are shared with various sales agents via sharing rules and added as Campaign members via Apex triggers on Lead creation. UC agents work on leads for 6 months, but want to keep the records in the system for at least 1 year for reference. Compliance requires them to be stored for a minimum of 3 years. After that, data can be deleted. What statement is true with respect to a data archiving strategy for UC?
A. UC can leverage the Salesforce Data Backup and Recovery feature for data archival needs.
B. UC can store long-term lead records in custom storage objects to avoid counting against storage limits.
C. UC can leverage recycle bin capability, which guarantees record storage for 15 days after deletion.
D. UC can leverage a "tier"-based approach to classify the record storage need.
d
118
Universal Containers (UC) is implementing a new customer categorization process where customers should be assigned to a Gold, Silver, or Bronze category if they've purchased UC's new support service. Customers are expected to be evenly distributed across all three categories. Currently, UC has around 500,000 customers, and is expecting 1% of existing non-categorized customers to purchase UC's new support service every month over the next five years. What is the recommended solution to ensure long-term performance, bearing in mind the above requirements?
A. Implement a new global picklist custom field with Gold, Silver, and Bronze values and enable it in Account.
B. Implement a new picklist custom field in the Account object with Gold, Silver, and Bronze values.
C. Implement a new Categories custom object and a master-detail relationship from Account to Category.
D. Implement a new Categories custom object and create a lookup field from Account to Category.
b
119
Get Cloud Consulting needs to integrate two different systems with customer records into the Salesforce Account object. So that no duplicate records are created in Salesforce, Master Data Management will be used.
An Architect needs to determine which system is the system of record on a field level.
What should the Architect do to achieve this goal?
A. Master Data Management systems determine system of record, and the Architect doesn't have to think about what data is controlled by what system.
B. Key stakeholders should review any fields that share the same purpose between systems to see how they will be used in Salesforce.
C. The database schema for each external system should be reviewed, and fields with different names should always be separate fields in Salesforce.
D. Any field that is an input field in either external system will be overwritten by the last record integrated and can never have a system of record.
b
120
Universal Containers has a large number of Opportunity fields (100) that they want to track field history on.
Which two actions should an architect perform in order to meet this requirement? Choose 2 answers
A. Create a custom object to store a copy of the record when changed.
B. Create a custom object to store the previous and new field values.
C. Use Analytic Snapshots to store a copy of the record when changed.
D. Select the 100 fields in the Opportunity Set History Tracking page.
ab
121
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?
A. Use custom fields to capture the authorization details.
B. Create a custom object to maintain the authorization.
C. Utilize the Authorization Form Consent object to capture the consent.
D. Use AppExchange solution to address the requirement.
c
122
Universal Containers has received complaints that customers are being called by multiple Sales Reps where the second Sales Rep that calls is unaware of the previous call by their coworker. What is a data quality problem that could cause this?
A. Missing phone number on the Contact record.
B. Customer phone number has changed on the Contact record.
C. Duplicate Contact records exist in the system.
D. Duplicate Activity records on a Contact.
c
123
A data architect is working with a large B2C retailer and needs to model the consumer account structure in Salesforce.
What standard feature should be selected in this scenario?
A. Individual Accounts
B. Account Contact
C. Contacts
D. Person Accounts
d
124
Universal Containers (UC) requires 2 years of customer related cases to be available on SF for operational reporting. Any cases older than 2 years and upto 7 years need to be available on demand to the Service agents.
UC creates 5 million cases per yr.
Which 2 data archiving strategies should a data architect recommend? Choose 2 options:
A. Use custom objects for cases older than 2 years and use nightly batch to move them.
B. Sync cases older than 2 years to an external database, and provide access to Service agents to the database
C. Use Big objects for cases older than 2 years, and use nightly batch to move them.
D. Use Heroku and external objects to display cases older than 2 years and bulk API to hard delete from Salesforce.
bc
125
The 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?
A. Change the WHERE clause to filter by a deterministic defined value.
B. Change the query to SOSL.
C. Remove Description from the requested field set.
D. Add LIMIT 100 to the query.
A
126
Northern 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. NTO has decided to engage a data architect to analyze and define data quality standards.
Which three key factors should a data architect consider when defining data quality standards?
Choose 3 answers.
A. Measure data timeliness and consistency.
B. Identify an extract, transform, load (ETL) tool for more complete data migrations.
C. Measure data completeness and accuracy.
D. Define data duplication standards and rules.
E. Define key fields in a staging database for data cleansing.
ACD
127
Universal Containers (UC) has a variety of systems across its technology landscape, including Salesforce, legacy 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.
A. Install a third-party AppExchange tool to handle the merger.
B. Analyze each system’s data model and perform gap analysis.
C. Work with stakeholders to define record and field survivorship rules.
D. Create new fields to store additional values from all of the systems.
E. Utilize an ETL tool to migrate, transform, and deduplicate data.
BCE
128
Universal 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?
A. Virtualize the remaining set of data with Salesforce Connect and external objects.
B. As needed, make callouts into Heroku Postgres and persist the data in Salesforce.
C. Use Heroku Connect to bidirectionally sync all data between systems.
D. Migrate the data to big objects and leverage Async SOQL with custom objects.
A
129
A customer needs a sales model that allows the following:
1. Opportunities need to be assigned to salespeople based on 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?
A. Assign opportunities using list views using ZIP code.
B. Add custom fields in opportunities for ZIP code and use assignment rules.
C. Configure the Territory Management feature to support opportunity assignment.
D. Allow sales users to manually assign opportunity ownership based on ZIP code.
C
130
Northern 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.
A. Change Data Capture (CDC)
B. Salesforce Connect
C. Salesforce-to-Salesforce
D. Federated Search
BC
131
Universal 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?
A. Leverage the standard Account and Contact objects in Salesforce.
B. Leverage a custom Account and Contact object in Salesforce.
C. Leverage a custom person account object in Salesforce.
D. Leverage the Person Account object in Salesforce.
D
132
Universal 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?
A. Leverage Salesforce weekly exports, and store data in flat files on a protected system.
B. Leverage a third-party tool that extracts Salesforce data/metadata and stores the information in an external protected system.
C. Utilize an ETL tool to migrate data to an on-premise archival solution.
D. Write a custom batch job to extract data changes nightly and store on an external protected system.
B
133
Northern 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.
A. Install a data warehouse.
B. Choose a business intelligence tool.
C. Identify data to be replicated.
D. Define the system of record for critical data.
E. Create a data archive strategy.
CDE
133
What should a data architect do to provide additional guidance for users when they enter information in a standard field?
A. Provide custom help text under field properties.
B. Add custom help text in default value for the field.
C. Add a label field with help text adjacent to the custom field.
D. Create a custom page with help text for user guidance.
A
134
Universal 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.
A. Clear the role field in the generic user record.
B. Create a pool of generic users and distribute the assignment of owners to the pool of users.
C. Salesforce handles the assignment of orders automatically and there is no performance impact.
D. Create a role at the top of the role hierarchy and assign the role to the generic user.
AB
135
Universal 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.
A. Limit assigning one user ownership of 10,000 records.
B. Limit associating 10,000 opportunities to one account.
C. Assign 10,000 opportunities to one account.
D. Limit associating 10,000 records looking up to same records.
E. Use picklist fields rather than a lookup to a custom object.
ABD
136
A 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:
* Salesforce CRM
* Custom billing solution
* Customer master data management (MDM)
* Contract management system
* Marketing solution
What should a data architect recommend that would help uniquely identify the customer across multiple systems?
A. Create a customer database, and use this ID in all systems.
B. Create a custom field as an external ID to maintain the customer ID from the MDM solution.
C. Store the Salesforce ID in all the solutions to identify the customer.
D. Create a custom object that will serve as a cross-reference for the customer ID.
B
137
Northern Trail Outfitters (NTO) has outgrown its current Salesforce org and will be migrating to a new org. As part of this process, NTO will be migrating all metadata and data. NTO’s data model has a complex relationship hierarchy with several master-detail and lookup relationships across objects, which must be preserved in the target org.
Which three things should a data architect do to maintain the relationship hierarchy during migration?
Choose 3 answers.
A. Replace source record IDs with new record IDs from the target org in the import file.
B. Redefine the master-detail relationship fields to lookup relationship fields in the target org.
C. Keep the relationship fields populated with the source record IDs in the import file.
D. Create an external ID field for each object in the target org and map source record IDs to this field.
E. Use Data Loader to export the data from the source org and then import/parent into the target org in sequential order.
CDE
138
Northern 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 physical mail using the contact information stored in Salesforce.
Which solution should the data architect use to reduce the amount of returned mail?
A. Have the sales team call all existing customers and ask to verify the contact details.
B. Delete contacts when mail is returned to save postal costs for NTO.
C. Use a third-party data source to update the contact information in Salesforce.
D. Email all customers and ask them to verify their information and to call NTO if their address is incorrect.
C
139
Universal Containers is migrating 100,000 accounts from an ERP into Salesforce and is concerned about ownership skew and resulting performance issues.
Which three recommendations should a data architect provide to prevent ownership skew?
Choose 3 answers.
A. Keep users out of public groups that can be used as the source for sharing rules.
B. Assign View All permissions to a group of users for the Account object.
C. Assign a default user as owner of accounts and assign the user to the top-most role in the hierarchy.
D. Assign a default user as owner of accounts and assign them a role in the hierarchy.
E. Assign a default user as owner of accounts and do not assign any role to the default user.
ABE
140
Universal Containers (UC) has migrated its back-office data into an on-premise database with REST API access. UC recently implemented Sales Cloud, but users are complaining because order data is not available inside Salesforce.
UC is concerned about Salesforce storage limits but still wants Sales Cloud users to access the order data.
Which design pattern should a data architect recommend?
A. Use Salesforce Connect to virtualize the data in Salesforce and avoid storage limits.
B. Build a UI for the on-premise system and frame it in Salesforce.
C. Migrate and persist the data in Salesforce to leverage native functionality.
D. Develop bi-directional integration between the on-premise system and Salesforce.
A
141
Universal 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?
A. Create a skinny table in Salesforce, and copy order and opportunity fields into the skinny table and create the required reports on it.
B. Create custom fields on Opportunity, and copy data from Order into those custom fields and run all reports on the Opportunity object.
C. Extract Opportunity and Order data from Salesforce, and use a third-party reporting tool to run reports outside of Salesforce.
D. Create an aggregate custom object that summarizes the monthly and yearly values into the required format for the required reports.
D
142
Northern Trail Outfitters has decided that it is going to build a channel sales portal with the following requirements:
* External resellers must be able to authenticate to the portal with a login.
* Lead, Opportunity, and Order data must be available to authenticated users.
* Authenticated users may need to run reports and dashboards.
* 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. Partner Community
B. Customer Community Plus
C. Customer Community
D. Lightning External Apps Starter
A
143
Northern 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?
A. SOAP API
B. Metadata API
C. Bulk API in serial mode
D. Tooling API
B
144
A 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
During an initial performance test, the data architect noticed extremely slow response times for reports and list views.
What should a data architect do to solve the performance issues?
A. Load only data that the user is permitted to access.
B. Create a Skinny Table to represent Account and Contact objects.
C. Limit data loading to the 2,000 most recently created records.
D. Add custom indexes on frequently searched Account and Contact fields.
D
145
Universal Containers (UC) has a Salesforce org with multiple automated processes defined for group membership processing. UC also has multiple admins who 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?
A. Enable granular locking.
B. Remove SOQL statements from Apex loops.
C. Enable sharing recalculations.
D. Ask Salesforce Support for additional CPU power.
A
146
Universal 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?
A. Implement a custom big object to store the data.
B. Create a custom object to store the data.
C. Use the standard “Order” object to store the data.
D. Use a standard big object defined by Salesforce.
A
147
Universal Containers (UC) owns multiple Salesforce orgs distributed across regional branches. Each branch stores local customer data inside 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, meaning they want to see Account and Contact data from all Salesforce orgs in a single place.
Which solution should a data architect suggest to achieve a 360-degree view of the customer?
A. Use an ETL tool to migrate org Accounts and Contacts into each org.
B. Use the Salesforce Connect cross-org adapter.
C. Build a bidirectional integration between all orgs.
D. Consolidate the data from each org into a centralized datastore.
B
148
Universal Containers has been using Salesforce for 10 years. Lately, users have noticed that pages load slowly when viewing customer and account list views.
To mitigate this, UC will implement a data archival strategy to reduce the amount of data actively loaded.
Which two tasks are required to define the archival strategy?
Choose 2 answers.
A. Identify the data retention requirements.
B. Identify how the archived data will be accessed and used.
C. Identify the recovery point objective.
D. Identify the recovery time objective.
AB
149
Northern Trail Outfitters (NTO) has a loyalty program to reward repeat customers. The following conditions exist:
* Reward levels are earned based on the amount spent during the previous 12 months.
* The program will track every item a customer has bought and grant them points for discounts.
* 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 a data architect use to provide this information within Salesforce for customer support agents?
A. Create 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.
B. Capture 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.
C. Provide a button so that the agent can quickly open the point-of-sale system that displays the customer’s history.
D. Create 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.
B
150
Northern 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.
A. Run the dashboard for the CEO and send it via email.
B. Denormalize the data by reducing the number of joins.
C. Use selective queries to reduce the amount of data being returned.
D. Reduce the amount of data queried by archiving unused opportunity records.
E. Remove widgets from the dashboard to reduce the number of graphics loaded.
BCD
151
Universal Containers developers have created a new Lightning component that uses an Apex controller with a SOQL query to populate a custom list view.
Users report 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?
A. Use Splunk to query the system logs looking for transaction time and CPU usage.
B. Use Salesforce's query optimizer to analyze the query in the developer console.
C. Enable and use the Query Plan tool in the developer console.
D. Open a ticket with Salesforce support to retrieve transaction logs for analysis.
C
152
Universal 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 being entered into the system.
Which two solutions should a data architect recommend to monitor and measure data quality?
Choose 2 answers.
A. Export data and check for data completeness outside of Salesforce.
B. Use custom objects and fields to identify issues.
C. Install and run the "Data Quality Analysis" dashboard app.
D. Review the data quality reports and dashboards.
CD
153
Northern 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, but they do not want to persist millions of records in Salesforce. NTO has asked the data architect to evaluate Salesforce Connect and data virtualization.
Which three key considerations are needed prior to a Salesforce Connect implementation?
Choose 3 answers.
A. Develop an object relationship strategy.
B. Create a second system admin user for authentication to the external source.
C. Configure a middleware tool to poll external table data.
D. Identify the external tables to sync into external objects.
E. Assess whether the external data source is reachable via an OData endpoint.
ADE
154
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.
A. Ensure the data is CRM-centric and able to populate standard or custom objects.
B. Determine if the data is a driver of key processes implemented within Salesforce.
C. Ensure there is a tight relationship between order data and an ERP application.
D. A selection of the tool required to replicate the data.
E. Consider whether the data is required for sales reports, dashboards, and KPIs.
ABE
155
Universal Containers (UC) is migrating from an on-premise homegrown customer relationship management (CRM) system. During analysis, UC users highlight a major pain point: there are multiple versions of many customers.
What should the data architect do for a successful migration to mitigate this pain point?
A. Have the users manually clean the data in the old system prior to migration.
B. Migrate the data as-is, and use Salesforce’s de-duplicating feature.
C. Hire an intern to manually de-duplicate the records after migrating to Salesforce.
D. Store the data in a staging database, and de-duplicate identical records.
D
156
Universal Containers (UC) is implementing Salesforce for lead management. UC procures lead data from multiple sources and would like to ensure lead data includes company profile and location information.
Which solution should a data architect recommend to make sure lead data has both profile and location information?
A. Export data out of Salesforce and send to another team to populate company profile and location data.
B. Run reports to identify records which do not have company profile and location data.
C. Ask salespeople to search for and populate company profile and location data.
D. Leverage external data providers to populate company profile and location data.
D
157
Universal Containers is preparing to implement Sales Cloud and wants its users to have Read-Only access to an Account record if they have access to its child Opportunity record.
How should a data architect implement this sharing requirement between objects?
A. Implicit sharing will automatically handle this with standard functionality.
B. Create an owner-based sharing rule.
C. Add appropriate users to the Account team.
D. Create a criteria-based sharing rule.
A
158
Universal 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?
A. Implement a third-party AppExchange app to encrypt files.
B. Use Classic Encryption to encrypt files.
C. Implement Shield Platform Encryption to encrypt files.
D. Store files outside of Salesforce and access them in real time.
C
SF Data Architect
flashcards
Decks in class (1)
# Cards
