DA2 Flashcards

1
Q

A large multinational B2C Salesforce customer is looking to implement their distributor management application in Salesforce. The application has the following capabilities:

  1. Distributors create sales orders in salesforce
  2. Sales orders are based on product prices applicable to their region
  3. Sales orders are closed once they are fulfilled
  4. It is decided to maintain the order in opportunity object

How should the data architect model this requirement?

A. Create a lookup to the Custom Price object and share with distributors.

B. Configure price books for each region and share with distributors.

C. Manually update Opportunities with Prices application to distributors.

D. Add custom fields in Opportunity and use triggers to update prices.

A

B. Configure price books for each region and share with distributors.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

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.

A

C. Create a mashup page that will present the billing system records within Salesforce.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

North Trail Outfitters (NTO) operates a majority of its business from a central Salesforce org, NTO also owns several secondary orgs that the service, finance, and marketing teams work out of, At the moment, there is no integration between central and secondary orgs, leading to data-visibility issues.

Moving forward, NTO has identified that a hub-and-spoke model is the proper architect to manage its data, where the central org is the hub and the secondary orgs are the spokes.

Which tool should a data architect use to orchestrate data between the hub org and spoke orgs?

A. A middleware solution that extracts and distributes data across both the hub and spokes.

B. Develop custom APIs to poll the hub org for change data and push into the spoke orgs.

C. Develop custom APIs to poll the spoke for change data and push into the org.

D. A backup and archive solution that extracts and restores data across orgs.

A

A. A middleware solution that extracts and distributes data across both the hub and spokes.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Universal Containers (UC) is transitioning from Classic to Lightning Experience.

What does UC need to do to ensure users have access to its notices and attachments in Lightning Experience?

A. Add Notes and Attachments Related List to page Layout in Lighting Experience.

B. Manually upload Notes in Lighting Experience.

C. Migrate Notes and Attachment to Enhanced Notes and Files using a migration tool.

D. Manually upload Attachments in Lighting Experience.

A

C. Migrate Notes and Attachment to Enhanced Notes and Files using a migration tool.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Northern Trail Outfitters has these simple requirements for a data export process:

  1. File format should be in CSV.
  2. Process should be scheduled and run once per week.
  3. The export should be configurable through the Salesforce UI.

Which tool should a data architect leverage to accomplish these requirements?

A. Bulk API

B. Data export wizard

C. Third-party ETL tool

D. Data loader

A

B. Data export wizard

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

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 updated by users. A majority of the automation tools within UC’s org were not designed to run during a data load. UC is importing 100,000 records into Salesforce across several objects over the weekend.

What should a data architect do to mitigate any unwanted results during the import?

A. Ensure validation rules, triggers and other automation tools are disabled.

B. Ensure duplication and matching rules are defined.

C. Import the data in smaller batches over a 24-hour period.

D. Bulkily the trigger to handle import leads.

A

A. Ensure validation rules, triggers and other automation tools are disabled.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Universal Containers (UC) is going through a major reorganization of their sales team. This would require changes to a large number of group members and sharing rules. UC’s administrator is concerned about long processing time and failure during the process.

What should a Data architect implement to make changes efficiently?

A. Log a case with salesforce to make sharing rule changes.

B. Enable Defer Sharing Calculation prior to making sharing rule changes.

C. Delete old sharing rules and build new sharing rules

D. Log out all users and make changes to sharing rules.

A

B. Enable Defer Sharing Calculation prior to making sharing rule changes.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Universal Container has implemented Sales Cloud to manage patient and related health records. During a recent security audit of the system it was discovered that some standard and custom fields need to be encrypted.

Which solution should a data architect recommend to encrypt existing fields?

A. Use Apex Crypto Class to encrypt customer and standard fields.

B. Implement classic encryption to encrypt custom and standard fields.

C. Implement shield platform encryption to encrypt custom and standard fields.

D. Export data out of Salesforce and encrypt custom and standard fields.

A

C. Implement shield platform encryption to encrypt custom and standard fields.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Universal Containers (UC) is in the process of migrating legacy inventory data from an enterprise resources planning (ERP) system into Sales Cloud with the following requirements:

  1. Legacy inventory data will be stored in a custom child object called Inventory_c.
  2. Inventory data should be related to the standard Account object.
  3. The Inventory_c object should Inhent the same sharing rules as the Account object.
  4. Anytime an Account record is deleted in Salesforce, the related Inventory_c record(s) should be deleted as well.

What type of relationship field should a data architect recommend in this scenario?

A. Master-detail relationship field on Account, related to Inventory_c

B. Master-detail relationship field on Inventory_c, related to Account

C. Indirect lookup relationship field on Account, related to Inventory_c

D. Lookup relationship fields on Inventory related to Account

A

A. Master-detail relationship field on Account, related to Inventory_c

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

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 orgs: org A and org B. UC has delivered these requirements to its data architect:

  1. The data model for Org B will drastically change with different objects, fields, and picklist values.
  2. Three million records will need to be migrated from org A to org B for compliance reasons.
  3. The migration will need occur within the next two month, prior to be split.

Which migration strategy should a data architect use to successfully migrate the data?

A. Use an 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

C. Write a script to use the Bulk API

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
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 access this inventory data to Sales Cloud without an import. UC has asked its data architect to determine if Salesforce Connect is needed.

Which three considerations should the data architect make when evaluating the need for Salesforce Connect?

Choose 3 answers

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 access small amounts of external data at any one time.

A

A. You want real-time access to the latest data, from other systems.

D. You have a large amount of data that you don’t want to copy into your Salesforce org.

E. You need to access small amounts of external data at any one time.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Northern Trail Outfitters (NTO) wants to implement backup and restore for Salesforce data, Currently, it has data backup processes that runs weekly, which back-up all Salesforce data to an enterprise data warehouse (EDW). NTO wants to move to daily backups and provide restore capability to avoid any data loss in case of outage.

What should a data architect recommend for a daily backup and restore solution?

A. Use an AppExchange package for backup and restore.

B. Use ETL for backup and restore from EDW.

C. Use Bulk API to extract data on a daily basis to EDW and REST API for restore.

D. Change weekly backup process to daily backup, and implement a custom restore solution.

A

A. Use an AppExchange package for backup and restore.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

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

A. Embed the keywords FOR UPDATE after SOQL statements.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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 the 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 requirements?

A. Leverage real-time integration to pull records into Salesforce.

B. Bring all data to Salesforce, and delete it after a year.

C. Leverage a mashup to display historical records in Salesforce.

D. Build a chair solution to go the legacy system and display records.

A

C. Leverage a mashup to display historical records in Salesforce.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

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 Salesforce 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 job to move all records off platform, and delete all records from Salesforce.

C. Build a batch job to move two-year-old records off platform, and delete records from Salesforce.

D. Build a batch job to move all records off platform, and delete old records from Salesforce.

A

A. Use a third-party backup solution to backup all data off platform.

Tengo dudas

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Universal Container requires all customers to provide either a phone number or an email address when registering for an account.

What should the data architect use to ensure this requirement is met?

A. Validation Rule

B. Required Fields

C. Apex Class

D. Process Builder

A

A. Validation Rule

17
Q

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 options to delete unused data 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 the last 3 years.

D. Use Rest API to permanently delete records from the Salesforce org.

E. Archive the records in an enterprise data warehouse (EDW) before deleting them from Salesforce.

A

A. Use hard delete in Bulk API to permanently delete records from Salesforce.

C. Identify records in objects that have not been modified or used in the last 3 years.

E. Archive the records in an enterprise data warehouse (EDW) before deleting them from Salesforce.

18
Q

A custom pricing engine for a Salesforce customer has to be decided by factors with the following hierarchy:

  1. State in which the customer is located
  2. City in which the customer is located if available
  3. Zip code In which the customer is located if available
  4. Changes to this information should have minimum code 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 the customer pricing engine.

C. Maintain required pricing criteria in custom metadata types.

D. Configure the pricing criteria in price books.

A

C. Maintain required pricing criteria in custom metadata types.

19
Q

Universal container (UC) would like to build a Human resources application on Salesforce to manage employee details, payroll, and hiring efforts. To adequately and store the relevant data, the application will need to leverage 45 custom objects. In addition to this, UC expects roughly 20,000 API calls into Salesfoce from an on-premises application daily.

Which license type should a data architect recommend that best fits these requirements?

A. Service Cloud

B. Lightning Platform Starter

C. Lightning Platform Plus

D. Lightning External Apps Starts

A

C. Lightning Platform Plus

https://help.salesforce.com/s/articleView?id=sf.users_license_types_communities_lightning_platform_details.htm&type=5

20
Q

Universal Containers (UC) has implemented Sales Cloud for its entire sales organization. UC has built a custom object called projects_c that stores customers’ project detail and employee billable hours.

The following requirements are needed:

  1. A subnet of individuals from the finance team will need access to the projects__c object for reporting and adjusting employee utilization.

2 . The finance users will not have access to any sales objects, but they will need to interact with the custom object.

Which license type should a data architect recommend for the finance team that best meets the requirements?

A. Service Cloud

B. Sales Cloud

C. Lightning Platform Starter

D. Lightning Platform Plus

A

C. Lightning Platform Starter

21
Q

A large insurance provider is looking to implement Salesforce. The following conditions exist:

  1. Multiple channels for lead acquisition
  2. Duplicate leads across channels
  3. Poor customer experience and higher costs

On analysis, it was found that there are duplicate leads that are resulting in multiple quotes and opportunities.

Which three actions should a data architect recommend to mitigate the issues?

Choose three.

A. Build process to manually search and merge duplicates.

B. Standardize lead information across all channels.

C. Build a custom solution to identify and merge duplicate leads.

D. Implement third-party solution to clean and enrich lead data.

E. Implement de-duplication strategy to prevent duplicate leads

A

B. Standardize lead information across all channels.

D. Implement third-party solution to clean and enrich lead data.

E. Implement de-duplication strategy to prevent duplicate leads

22
Q

Universal Containers has a Sales Cloud implementation for a sales team and an enterprise resource planning (ERP) as a customer master. Sales teams are complaining about duplicate accounts 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-duplicate data, and merge account records.

B. Integrate Salesforce with ERP, and make ERP as the system of truth.

C. Build a nightly sync job from ERP to Salesforce.

D. Implement a deduplication solution and establish account ownership in Salesforce

A

B. Integrate Salesforce with ERP, and make ERP as the system of truth.

D. Implement a deduplication solution and establish account ownership in Salesforce

23
Q

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 a custom big object?

A. Use DX to create a big object.

B. Use the Metadata API to create a big object.

C. Go to Big Objects in Setup, select New to create a big object.

D. Go to Object Manager in Setup and select New to create a big object.

A

B. Use the Metadata API to create a big object.

C. Go to Big Objects in Setup, select New to create a big object.

24
Q

Universal Container is Implementing salesforce and needs to migrate data from two legacy systems. UC would like to clean and de-duplicate data before migrating to Salesforce.

Which solution should a data architect recommend for 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 database, 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

A

D. Define external IDs for an object, insert data from one database, and use upsert for a second database

25
Q

Northern Trail Outfitters (NTO) uses Sales Cloud and Service Cloud to manage their sales and support processes. Some of NTOs teams are complaining they see new fields on their page and are unsure of which values need to be input. NTO is concerned about a 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 use a governance process for changes made to common objects.

C. Create reports to identify which users are leaving blank, and use external data sources to

augment the missing data.

D. Create validation rules with error messages to explain why the field is used

A

B. Create and manage a data dictionary and use a governance process for changes made to common objects.

26
Q

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.

A

C. Utilize PK Chunking with the Bulk API.

27
Q

Northern Trail Outfitters (NTO) runs its entire out of an enterprise data warehouse (EDW). NTO’s sales team is starting to use Salesforce after a recent implementation, but currently lacks data required to advance an opportunity to the next stage. NTO’s management has researched Salesforce Connect and would like to use It to virtualize and report on data from the EDW within Salesforce. NTO will be running thousands of reports per day across 10 to 15 external objects.

What should a data architect consider before implementing Salesforce Connect for reporting?

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

A

B. OData callout limits per day

28
Q

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. Use 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

A

C. Use external objects to maintain Sales Order in Salesforce.

29
Q

Northern Trail Outfitters (NTO) has the following systems:

  • Customer master-source of truth for customer information
  • Service cloud-customer support
  • Marketing cloud-marketing support
  • Enterprise data warehouse
  • Business reporting

The customer data is duplicated across all these systems and are not kept in sync. Customers are also complaining that they get repeated marketing emails and have to call in to update their information. NTO is planning to implement a master data management (MDM) solution across the enterprise.

Which three data will an MDM tool solve?

Choose 3 answers

A. Data completeness

B. Data loss and recovery

C. Data duplication

D. Data accuracy and quality

E. Data standardization

A

C. Data duplication

D. Data accuracy and quality

E. Data standardization

30
Q

Universal Containers is experiencing frequent and persistent group membership locking issues that severely restrict its ability to manage manual and 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

A. Enable granular locking

31
Q

Northern Trail Outfitter has implemented Salesforce for its associates nationwide. Senior management is concerned that the executive dashboards are not reliable for their real-time decision making. On analysis, the team found the following issues with data entered in Salesforce.

  • Information in certain records is incomplete.
  • Incorrect entry in certain fields causes records to be excluded in report fitters.
  • Duplicate entries cause incorrect counts.

Which three steps should a data architect recommend to address the issues?

A. Periodically export data to cleanse data and import them back into Salesforce for executive reports.

B. Build a sales data warehouse with purpose-build data marts for dashboards and senior

management reporting.

C. Explore third-party data providers to enrich and augment information entered in salesforce.

D. Leverage Salesforce features, such as validate rules, to avoid incomplete and incorrect records.

E. Design and implement data-quality dashboard to monitor and act on records that are incomplete or incorrect

A

B. Build a sales data warehouse with purpose-build data marts for dashboards and senior

management reporting.

C. Explore third-party data providers to enrich and augment information entered in salesforce.

D. Leverage Salesforce features, such as validate rules, to avoid incomplete and incorrect records.

32
Q

North Trail Outfitters (NTO) is in the process of evaluating big objects to store large amounts of asset data from an external system. NTO will need to report on this asset data weekly.

Which two native tools should a data architect recommend to achieve this reporting requirement?

A. Standard reports and dashboards

B. Async SOQL with a custom object

C. Standard SOQL queries

D. Einstein Analytics

A

B. Async SOQL with a custom object

D. Einstein Analytics

33
Q

Universal Containers (UC) is migrating from a legacy system to Salesforce CRM. UC is concerned about the quality of data being entered by users and through external integrations.

Which two solutions should a data architect recommend to mitigate data quality issues?

Choose 2 answers.

A. Leverage picklist and lookup fields where possible

B. Leverage Apex to validate the format of data being entered via a mobile device.

C. Leverage validation rules and workflows.

D. Leverage third-party- AppExchange tools

A

A. Leverage picklist and lookup fields where possible

C. Leverage validation rules and workflows.

34
Q

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 a 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 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.

A

A. Load the CSV files in Einstein Analytics and sync with Marketing Cloud prior to sending marketing communications.

35
Q

Northern Trail Outfitters (NTO) has a variety of customers that include householders, 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 options should a data architect perform to resolve the issues with the customer data?

Choose 3 answers.

A. Create a unique global customer ID for each customer and store that in all systems for referential identity.

B. Use Salesforce CDC to sync customer data across all systems to keep customer records in sync.

C. Invest in adata 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.

A

A. Create a unique global customer ID for each customer and store that in all systems for referential identity.

C. Invest in adata duplicate tool to de-dupe and merge duplicate records across all systems.

E. Create a customer master database external to Salesforce as a system of truth and sync the customer data with all systems.

36
Q

Universal Container is using Salesforce for Opportunity management and enterprise resource planning (ERP) for order management. Sales reps do not have access to the ERP and have no visibility into order status.

What solution should a data architect recommend to give the sales team visibility into order status?

A. Leverage Canvas to bring the order management UI into the Salesforce tab.

B. Build batch jobs to push order line items to salesforce.

C. Leverage Salesforce Connect to bring the order line item from the legacy system to Salesforce.

D. Build real-time integration to pull order line items into Salesforce when viewing orders.

A

C. Leverage Salesforce Connect to bring the order line item from the legacy system to Salesforce.