KO_DA2 Flashcards by A R

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 in the org. NTO has decided to engage a data architect to analyze and define data quality standards.
Which three key factors should a data architect consider while defining data quality standards? (Choose three.)

A. Measure data timeliness and consistency.
B. Define key fields in a staging database for data cleansing.
C. Identify an extract, transform, load (ETL) tool for more complete data migrations.
D. Measure data completeness and accuracy.
E. Define data duplication standards and rules.

A D E

How well did you know this?

Not at all

Perfectly

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. Store files outside of Salesforce and access them in real time.
C. Use classic encryption to encrypt files.
D. Implement Shield Platform Encryption to encrypt files.

How well did you know this?

Not at all

Perfectly

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 three.)

A. Choose a business intelligence tool.
B. Install a data warehouse.
C. Create a data archive strategy.
D. Identify data to be replicated.
E. Define the system of record for critical data.

C D E

How well did you know this?

Not at all

Perfectly

Universal Containers uses classic encryption for custom fields and Is leveraging weekly data export for data backups. During a validation process, UC discovered that encrypted field values are still being exported as part of the data export.
What should a data architect recommend to make sure decrypted values are exported during data export?

A. Set up a custom profile for the data migration user, and assign View Encrypted Data.
B. Set up a standard profile for the data migration user, and assign View Encrypted Data.
C. Create another field to copy data from the encrypted field, and use this field in export.
D. Leverage an Apex class to decrypt data before exporting it.

How well did you know this?

Not at all

Perfectly

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 two.)

A. Federated Search
B. Salesforce 2 Salesforce
C. Change Data Capture (CDC)
D. Salesforce Connect

C B

How well did you know this?

Not at all

Perfectly

A large healthcare provider wishes to use Salesforce to track patient care. The following actors are in Salesforce:
1. Payment providers: Organizations who pay for the care to patients.
2. Doctors: They provide care plans for patients and need to support multiple patients. They are provided access to patient information.
3. Patients: These are individuals who need care.
A data architect needs to map the actors to Salesforce objects.
What should be the optimal selection by the data architect?

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

How well did you know this?

Not at all

Perfectly

Universal Containers (UC) has a variety of systems across its technology landscape, including Salesforce, legacy enterprise resource planning (ERP) applications, and homegrown CRM tools. UC has decided that they would like to consolidate all customer, opportunity, and order data into Salesforce as part of its master data management strategy.
What are the three key steps that a data architect should take when merging data from multiple systems into Salesforce? (Choose three.)

A. Work with stakeholders to define record and field survivorship rules.
B. Analyze each system’s data model and perform gap analysis.
C. Utilize an ETL tool to migrate, transform, and deduplicate data.
D. Install a third-party AppExchange tool to handle the merger.
E. Create new fields to store additional values from all of the systems.

A B C

How well did you know this?

Not at all

Perfectly

Northern Trail Outfitters (NTO) has multiple systems across its enterprise landscape, including Salesforce, with disparate versions of the customer record. In Salesforce. the customer is represented by the Contact object. NTO utilizes a master data management (MDM) solution with these attributes:
1. The MDM solution keeps track of the Customer Master with a Master Key.
2. The Master Key is a map to the record IDs from each external system that customer data is stored within.
3. The MDM solution provides deduplication features, so it acts as the Single Source of Truth.
How should a Data Architect implement the storage of the Master Key within Salesforce?

A. Create a custom object to store the Master Key with a lookup field to Contact.
B. Store the Master Key in Heroku Postgres and use Heroku Connect for synchronization.
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 integrity.

How well did you know this?

Not at all

Perfectly

Northern Trail Outfitters (NTO) has decided to franchise its brand. Upon implementation 1,000 franchisees will be able to access NTO’s product information and track large customer sales and opportunities through a portal. The franchisees will also be able to run monthly and quarterly sales reports and projections as well as view the reports in dashboards.
Which license does NTO need to provide these features to the franchisees?

A. Customer Community License
B. Lighting Platform License
C. Salesforce Sales Cloud License
D. Partner Community License

How well did you know this?

Not at all

Perfectly

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 three.)

A. Ensure there is a tight relationship between order data and an enterprise resource planning (ERP) application.
B. Determine if the data is a driver of key processes implemented within Salesforce.
C. Consider whether the data is required for sales reports, dashboards, and KPIs.
D. Ensure the data is CRM-centric and able to populate standard or custom objects.
E. A selection of the tool required to replicate the data.

B C D

How well did you know this?

Not at all

Perfectly

Universal Containers has millions of cases and are running out storage. Some user groups need to have access to historical cases for up to seven years.
Which two solutions should a data architect recommend in order to minimize performance and storage issues? (Choose two.)

A. Export data out of Salesforce and store in flat files on external system.
B. Leverage Salesforce Privacy Center to archive case data and view archived cases through an external object.
C. Create a custom object to store case history and run reports on it.
D. Leverage big objects to archive case data and Lightning components to show archived data.

A D

How well did you know this?

Not at all

Perfectly

United Containers (UC) has released a new disaster recovery (DR) policy that states that cloud solutions need a business continuity plan in place separate from the cloud provider’s built-in data recovery solution.
Which solution should a data architect use to comply with the DR policy?

A. Leverage a third-party tool that extracts Salesforce data/metadata, and stores the information in an external protected system.
B. Utilize an ETL tool to migrate data to an on-premise archival solution.
C. Leverage Salesforce weekly exports, and store data in flat files on a protected system.
D. Write a custom batch Job to extract data changes nightly, and store on an external protected system.

How well did you know this?

Not at all

Perfectly

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. Extract opportunity and order data from Salesforce, and use a third-party reporting tool to run reports outside of Salesforce.
C. Create custom fields on opportunity, and copy data from order into those custom fields and run all reports on Opportunity object.
D. Create an aggregate custom object that summarizes the monthly and yearly values into the required format for the required reports.`

How well did you know this?

Not at all

Perfectly

Northern Trail Outfitters (NTO) has outgrown its current Salesforce org and will be migrating to a new org shortly. As part of this process, NTO will be migrating all of its metadata and data. NTO’s data model in the source org has a complex relationship hierarchy with several master-detail and lookup relationships across objects, which should be maintained in the target org.
Which three things should a data architect do to maintain the relationship hierarchy during migration? (Choose three.)

A. Redefine the master-detail relationship fields to lookup relationship fields in the target org.
B. Use Data Loader to export the data from the source org and then import/upsert into the target org in sequential order.
C. Keep the relationship fields populated with the source record IDs in the import file.
D. Replace source record IDs with new record IDs from the target org in the import file.
E. Create an external ID field for each object in the target org and map source record IDs to this field.

B D E

How well did you know this?

Not at all

Perfectly

Universal Containers (UC) has millions of case records with case history and service level agreement data. UC’s compliance team would like historical cases to be accessible for 10 years for audit purposes.
What solution should a data architect recommend?

A. Purchase more data storage to support the case object.
B. Use a custom big object to store archived case data.
C. Archive case data using a Salesforce Archival solution.
D. Use a custom object to store archived case data.

How well did you know this?

Not at all

Perfectly

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 two.)

A. Salesforce handles the assignment of orders automatically and there is no performance impact.
B. Clear the role field in the generic user record.
C. Create a pool of generic users and distribute the assignment of owners to the pool of users.
D. Create a role at the top of the role hierarchy and assign the role to the generic user.

C D

How well did you know this?

Not at all

Perfectly

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 three.)

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

B D E

How well did you know this?

Not at all

Perfectly

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. Migrate the data to big objects and leverage Async SOQL with custom objects.
B. Use Heroku Connect to bidirectionally sync all data between systems.
C. Virtualize the remaining set of data with Salesforce Connect and external objects.
D. As needed, make callouts into Heroku Postgres and persist the data in Salesforce.

How well did you know this?

Not at all

Perfectly

Universal Containers has been using Salesforce for 10 years. Lately, users have noticed that the pages load slowly when viewing customer and account list views.
To mitigate. UC will implement a data archival strategy to reduce the amount of data actively loaded.
Which two tasks are required to define the strategy? (Choose two.)

A. Identify the recovery point objective.
B. Identify the data retention requirements.
C. Identify how the archived data will be accessed and used.
D. Identify the recovery time objective.

B C

How well did you know this?

Not at all

Perfectly

Universal Containers (UC) requires 2 years of customer related cases to be available on Salesforce for operational reporting. Any cases older than 2 years and up to 7 years need to be available on demand to service agents. UC creates 5 million cases per year.
Which two data archiving strategies should a data architect recommend? (Choose two.)

A. Sync cases older than 2 years to an external database and provide service agents access to the database.
B. Use Custom objects for cases older than 2 years and use a nightly batch to move them.
C. Use Heroku and external objects to display cases older than 2 years and the Bulk API to hard delete them from Salesforce.
D. Use Big objects for cases older than 2 years and use a nightly batch to move them.

A D

How well did you know this?

Not at all

Perfectly

Universal Containers (UC) is implementing Salesforce for lead management. UC procures lead data from multiple sources and would like to make sure lead data has company profile and location information.
Which solution should a data architect recommend to make sure lead data has both profile and location information?

A. Export data out of Salesforce and send to another team to populate company profile and location data.
B. Leverage external data providers to populate company profile and location data.
C. Run reports to identify records which do not have company profile and location data.
D. Ask sales people to search for and populate company profile and location data.

How well did you know this?

Not at all

Perfectly

Universal Containers (UC) owns multiple Salesforce orgs that are distributed across regional branches. Each branch stores local customer data inside of its org s Account and Contact objects. This creates a scenario where UC is unable to view customers across all orgs.
UC has an initiative to create a 360-degree view of the customer, as UC would like to see Account and Contact data from all of its orgs in one place.
Which solution should a data architect suggest to achieve a 360-degree view of the customer?

A. Build a bidirectional integration between all orgs.
B. Use the Salesforce Connect cross-org adapter.
C. Use an ETL tool to migrate gap Accounts and Contacts into each org.
D. Consolidate the data from each org into a centralized datastore.

How well did you know this?

Not at all

Perfectly

Universal Containers (UC) Is migrating data from a legacy system to Salesforce. UC would like to preserve the following information on records being migrated:
1. Date time stamps for created date and last modified date
2. Ownership of records belonging to inactive users being migrated to Salesforce
Which two solutions should a data architect recommend to preserve date timestamps and ownership on records? (Choose two.)

A. Log a case with Salesforce to allow updating these fields.
B. Enable Modify All and View All permissions.
C. Enable Update Records with Inactive Owners permission.
D. Enable Set Audit Fields upon Record Creation permission.

C D

How well did you know this?

Not at all

Perfectly

Universal Containers (UC) is implementing Salesforce and will be using Salesforce to track customer complaints, provide white papers on products, and provide subscription based support.
Which license type will UC users need to fulfill UC’s requirements?

A. Sales Cloud License
B. Salesforce License
C. Service Cloud License
D. Lightning Platform Starter License

How well did you know this?

Not at all

Perfectly

Which two data management policies does the Data Classification feature allow customers to classify in Salesforce? (Choose two.) A. Data Governance policy B. Data Sensitivity Level C. Reference Data policy D. Compliance Categorization policy

B D

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. Use the standard 'Order' object to store the data. B. Create a custom object to store the data. C. Implement a custom big object to store the data. D. Use a standard big object defined by Salesforce

What should a data architect do to provide additional guidance for users when they enter information in a Standard field? A. Add a label field with help text adjacent to the custom field. B. Add custom help text in default value for the field. C. Provide custom help text under field properties. D. Create a custom page with help text for user guidance.

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 input in to the system. Which two solutions should a data architect recommend to monitor and measure data quality? (Choose two.) A. Review the data quality reports and dashboards. B. Export data and check for data completeness outside of Salesforce. C. Use custom objects and fields to identify issues. D. Install and run the “Data Quality Analysis” dashboard app.

A D

Northern Trail Outfitters has decided that it is going to build a channel sales portal with the following requirements: 1. External resellers are able to authenticate to the portal with a login. 2. Lead data. Opportunity data, and Order data are available to authenticated users. 3. Authenticated users may need to run reports and dashboards. 4. There is no need for more than 10 custom objects or additional file storage. Which Community Cloud license type should a data architect recommend to meet the portal requirements? A. Lightning External Apps Starter B. Customer Community Plus C. Partner Community D. Customer Community

Northern Trail Outfitters (NTO) needs to extract 50 million records from a custom object every day from its Salesforce org. NTO is facing query time-out issues while extracting these records. What should a data architect recommend in order to get around the time-out issue? A. Use a custom auto number and formula field to chunk records while extracting data, B. Use the Rest API to extract data as it automatically chunks records by 200. C. Use extract, transform, load (ETL) tool for extraction of records. D. Ask Salesforce support to increase the query timeout value.

Universal Containers (UC) is migrating from an on-premise homegrown customer relationship management (CRM) system. During analysis, UC users highlight a pain point that there are multiple versions of many customers. What should the data architect do for a successful migration to mitigate the pain point? A. Migrate the data as is, and use Salesforce's de-duplicating feature. B. Store the data in a staging database, and de-duplicate identical records. C. Hire an intern manually de-duplicate the records after migrating to Salesforce. D. Have the users manually clean the data in the old system prior to migration.

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, yet they do not want to persist millions of records directly in Salesforce. NTO has asked the data architect to evaluate Salesforce Connect and the concept of data virtualization. Which three key considerations are needed prior to a Salesforce Connect implementation? (Choose three.) A. Assess whether the external data source is reachable via an OData endpoint. B. Identify the external tables to sync into external objects. C. Develop an object relationship strategy. D. Create a second system admin user for authentication to the external source. E. Configure a middleware tool to poll external table data.

A B C

Universal Containers (UC) has migrated its back-office data into an on-premise database with REST API access. UC recently implemented Sales Cloud for its sales organization, but users are complaining about a lack of order data inside Salesforce. UC is concerned about Salesforce storage limits but would still like Sales Cloud to have access to the data. Which design pattern should a data architect select to satisfy the requirement? A. Develop a bidirectional integration between the on-premise system and Salesforce. B. Use Salesforce Connect to virtualize the data in Salesforce and avoid storage limits. C. Build a UI for the on-premise system and iframe it in Salesforce. D. Migrate and persist the data in Salesforce to take advantage of native functionality.

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. Tooling API B. SOAP API C. Bulk API in serial mode D. Metadata API

A customer needs a sales model that allows the following: 1. Opportunities need to be assigned to sales people based on the zip code. 2. Each salesperson can be assigned to multiple zip codes. 3. Each zip code is assigned to a sales area definition. Sales are aggregated by sales area for reporting. What should a data architect recommend? A. Configure the Territory Management feature to support opportunity assignment. B. Allow sales users to manually assign opportunity ownership based on zip code. C. Add custom fields in opportunities for zip code and use assignment rules. D. Assign opportunities using list views using zip code.

Northern Trail Outfitters (NTO) has implemented Salesforce for its sales users. The opportunity management in Salesforce is implemented as follows: 1. Sales users enter their opportunities in Salesforce for forecasting and reporting purposes. 2. NTO has a product pricing system (PPS) that is used to update the Opportunity Amount field on opportunities on a daily basis. 3. PPS is the trusted source within NTO for Opportunity Amount. 4. NTO uses Opportunity Forecast for its sales planning and management. Sales users have noticed that their updates to the Opportunity Amount field are overwritten when PPS updates their opportunities. How should a data architect address this overwriting issue? A. Change PPS integration to update only Opportunity Amount field when the value is null. B. Create a custom field for Opportunity Amount that sales users update separating the field that PPS updates. C. Create a custom field for Opportunity amount that PPS updates separating the field sales user updates. D. Change Opportunity Amount field access to Read Only for sales users using field-level security.

Universal Containers is building a Salesforce application to track Contacts and the respective Conferences that they have attended with the following requirements: 1. Contacts will be stored in the standard Contact object. 2. Conferences will be stored in a custom Conference__c object. 3. Each Contact may attend multiple Conferences and each Conference may be related to multiple Contacts. How should a data architect model the relationship between the Contact and Conference__c objects? A. Create a lookup relationship field on the Contact object. B. Create a master-detail relationship field on the Contact object. C. Create a master-detail relationship field on the Conference__c object. D. Implement a Contact Conference Junction object with master-detail relationships to both Contact and Conference__c.

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 a custom person account object in Salesforce. B. Leverage a custom account and contact object in Salesforce. C. Leverage the standard account and contact object in Salesforce. D. Leverage the person account object in Salesforce.

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. Assign dummy user to highest role in role hierarchy. C. Periodically delete leads to reduce number of leads. D. Create multiple dummy user and assign leads to them.

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. Migrate the legacy data leveraging an ETL tool to transform data types and load data into Salesforce. C. Export legacy data into CSV files and leverage data loader to load data into Salesforce. D. Export legacy data into the staging database and leverage stored procedures to transform data types before loading into Salesforce.

Universal Containers (UC) owns several Salesforce orgs across a variety of business units. UC management has declared that it needs the ability to report on Accounts and Opportunities from each org in one place. Once the data is brought together into a global view, management would like to use advanced AI-driven analytics on the dataset. Which tool should a data architect recommend to accomplish this reporting requirement? A. Use Einstein Analytics for multi-org. B. Install a third-party AppExchange tool for multi-org reporting. C. Run standard reports and dashboards. D. Write a Python script to aggregate and visualize the data.

Based on government regulations, a Salesforce customer plans to implement the following in Salesforce for compliance: 1. Access to customer information based on record ownership 2. Ability for customers to request removal of their information from Salesforce 3. Prevent users from accessing Salesforce from outside company network (virtual private network, or VPN) What should a data architect recommend to address these requirements? A. Allow users access to Salesforce through a custom web application hosted within VPN. B. Implement Salesforce shield with Event Monitoring to address the requirement. C. Implement IP restrictions, sharing settings, and custom Apex to support customer requests. D. Contact Salesforce support to restrict access only with VPN and other requirements.

Northern Trail Outfitters (NTO) has recently implemented Salesforce to track opportunities across all their regions. NTO sales teams across all regions have historically managed their sales process in Microsoft Excel. NTO sales teams are complaining that their data from the Excel files were not migrated as part of the implementation and NTO is now facing low Salesforce adoption. What should a data architect recommend to increase Salesforce adoption? A. Create a chatter group and upload all Excel files to the group. B. Load data in external database and provide access to database to sales users. C. Define a standard mapping and train sales users to import opportunity data. D. Use the Excel connector to Salesforce to sync data from individual Excel files.

Northern Trail Outfitters needs to implement an archive solution for Salesforce data. This archive solution needs to help NTO do the following: 1. Remove outdated information not required on a day-to-day basis. 2. Improve Salesforce performance. Which solution should be used to meet these requirements? A. 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. B. Identify a location to store archived data, and move data to the location using a time-based workflow. C. Create a full copy sandbox, and use it as a source for retaining archived data. D. Identify a location to store archived data and use scheduled batch jobs to migrate and purge the aged data on a nightly basis.

Universal Containers has been a customer of Salesforce for 10 years. Currently they have 2 million accounts in the system. Due to an erroneous integration built 3 years ago, it is estimated there are 500,000 duplicates in the system. Which solution should a data architect recommend to remediate the duplication issue? A. Extract the data using data loader and use excel to merge the duplicate records B. Utilize a data warehouse as the system of truth C. Develop an ETL process that utilizes the merge API to merge the duplicate records D. Implement duplicate rules

Northern Trail Outfitters (NTO) has an external product master system that syncs product and pricing information with Salesforce. Users have been complaining that they are seeing discrepancies in product and pricing information displayed on the NTO website and Salesforce. As a data architect, which action is recommended to avoid data sync issues? A. Implement a manual process to update the products from an extract from the products master on a weekly basis. B. Build a custom integration for two-way sync of product and pricing information between product master to Salesforce. C. Use the Customer 360 data manager to sync product and pricing information from product master database to Salesforce. D. Build a custom integration for one way sync of product and pricing information from product master to Salesforce.

Universal Containers's system administrators have been complaining that they are not able to make changes to its users' records, including moving them to new territories without getting "unable to lock row" errors. This is causing the system admins to spend hours updating user records every day. What should the data architect do to prevent the errors? A. Increase CPU for the Salesforce org. B. Analyze Splunk query to spot offending records. C. Reduce number of users updated concurrently. D. Enable granular locking.

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

A large telecommunication provider that provides internet services to both residences and businesses has the following attributes: 1. A customer who purchases its services for their home will be created as an Account in Salesforce. 2. Individuals within the same house address will be created as Contact in Salesforce. 3. 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 Accounts for Residence Account and use Parent Account to relate Business Account. C. Customers are created as Individual objects and relate with Accounts for Business and Residence accounts. D. Customers are created as Person Accounts and related to Business and Residential Accounts using the Account Contact relationship.

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. Leveraging a controlled feed load with 10 batches per job. B. Inserting 1 million orders distributed across a variety of accounts with lock exceptions eliminated and managed. C. Inserting 1 million orders distributed across a variety of accounts with potential lock exceptions. D. Placing 20 batches on the queue for upsert jobs.

Universal Containers (UC) has implemented a master data management strategy, which uses a central system of truth, to ensure the entire company has the same customer information in all systems. UC customer data changes need to be accurate at all times in all of the systems. Salesforce is the identified system of record for this information. What is the correct solution for ensuring all systems using customer data are kept up to date? A. Send customer record changes from Salesforce to the system of truth in real time. B. Send customer data nightly to the system of truth in a scheduled batch job. C. Have each system pull the record changes from Salesforce using change data capture. D. Send customer record changes from Salesforce to each system in a nightly batch job.

Northern Trail Outfitters (NTO) wants to start a loyalty program to reward repeat customers. The program will track every item a customer has bought and grants them points for discounts. The following conditions will exist upon implementation: 1. Data will be used to drive marketing and product development initiatives. 2. NTO estimates that the program will generate 100 million rows of data monthly. 3. NTO will use Salesforce's Einstein Analytics and Discovery to leverage their data and make business and marketing decisions. What should the Data Architect do to store, collect, and use the reward program data? A. Have Einstein connect to the point of sales system to capture the Reward Program data. B. Create a custom big object in Salesforce which will be used to capture the Reward Program data for consumption by Einstein. 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 large automobile manufacturer has decided to use Salesforce as its CRM. It needs to maintain the following dealer types in their CRM: 1. Local dealers 2. Regional distributor 3. State distributor 4. Service dealer The attributes are different for each of the customer types. The CRM users should be allowed to enter only attributes related to the customer types. The processes and business rules for each of the customer types could be different. How should the different dealers be maintained in Salesforce? A. Create dealers as Accounts, and build custom views for each of the dealer types. B. Create Custom objects for each dealer types and custom fields for dealer attributes. C. Use Accounts for dealers, and create record types for each of the dealer types. D. Use Accounts for dealers and custom picklist field for each of the dealer types.

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 account records and data quality issues with account data. Which solution should a data architect recommend to resolve the complaints? A. Do a bulk delete of all account records in Salesforce and a complete reload from the ERP. B. Build a nightly sync job from ERP to Salesforce. C. Build a nightly batch job to de-dupe data, and merge account records. D. Implement a de-dupe solution and establish account ownership in Salesforce.

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 a custom adapter with the Apex Connector Framework. B. Write an Apex class that makes a REST callout to the external API. C. Develop a process that calls an invocable web service method. D. Migrate the data to Heroku and register Postgres as a data source.

Northern Trail Outfitters is concerned because some of its data is sensitive and needs to be identified for access. What should be used to provide ways to filter and identify the sensitive data? A. Define data classification metadata. B. Implement field-level security. C. Custom checkbox denoting sensitive data. D. Define data grouping metadata.

Universal Containers (UC) has SO million customers and stores customer order history on an ERP system. UC also uses Salesforce to manage opportunities and customer support. In order to provide seamless customer support, UC would like to see the customers order history when viewing the customer record during a sales or support call. What should a data architect do in order to provide this functionality, while preserving the user experience? A. Import the order history into a custom Salesforce object, update nightly. B. Embed the ERP system in an iframe and display on a custom tab. C. Use an Apex callout to populate a text area field for displaying the order history. D. Use Salesforce Connect and an external object to display the order history in Salesforce.

Universal Containers (UC) plans to implement consent management for its customers to be compliant with General Data Protection Regulation (GDPR). UC has the following requirements: 1. UC uses Person Accounts and Contacts in Salesforce for its customers. 2. Data Protection and Privacy is enabled in Salesforce. 3. Consent should be maintained in both these objects. 4. UC plans to verify the consent provided by customers before contacting them through email or phone. Which option should the data architect recommend to implement these requirements? A. Configure custom fields in Person Account and Contact to store consent provided by customers, and validate consent against the fields. B. Delete contact information from customers who have declined consent to be contacted. C. Build Custom Object to store consent information in Person Account and Contact; validate against this object before contacting customers. D. Use the Consent Management feature to validate consent provided under the Person Account and Contact that is provided by the customer.

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. Contacts C. Person Accounts D. Account Contact

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 serial mode for data migration. B. Insert the order in another custom object and use Batch Apex to move the records to Service_Order__c object. C. Use Bulk API parallel mode for data migration. D. Change the lookup configuration to "Clear the value of this field" when lookup record is deleted.

KO_DA2 Flashcards

(60 cards)