EMT Practice Test

1. Question Content...

---

Question1: Universal Containers uses Salesforce to track its sales opportunities The Sales VP would like to better understand key relevant performance figures and help the Sales Managers take corrective actions where appropriate. What reporting option should be considered?

Question2: Ursa Major Solar has 4 million rows of data in Salesforce that are used in reports to assess historical trends. Both performance and data storage limits have become an issue.
Which two strategies are appropriate when discussing the issue with stakeholders? (Choose two.)

Question3: 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.

What should the Architect consider in this situation?

Question4: Cloud Kicks has a system environment that is complex, and they plan on creating a data governance program for the first time.
What are two initial actions Cloud Kicks should take to initiate an assessment of data architecture? (Choose two.)

Question5: 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:

Question6: Universal Containers (UC) is planning to launch its Customer Community. The community will allow user to register shipment requests which are then processed by UC employees. Shipment requests contain header information, and then a list of no more than 5 items being shipped. UC will initially roll out its community to
5,000 customers in Europe, and will ultimately roll out to 20,000 customers worldwide within the next two years. UC expects an average of 10 shipment requests per week per customer. UC wants customers to be able to view up to three years of shipment requests and use Saleforce reports. What is the recommended solution for UC's Data Architect to address the requirements?

Question7: 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
When doing an initial performance test, the data architect noticed an extremely slow response for reports and list views.
What should a data architect do to solve the performance issues?

Question8: What should a data architect do to provide additional guidance for users when they enter information in a standard field?

Question9: A large insurance provider is looking to implement Salesforce. The following exist.
1. Multiple channel for lead acquisition
2. Duplication leads across channels
3. Poor customer experience and higher costs
On analysis, it found that there are duplicate leads that are resulting to mitigate the issues?

Question10: Universal Containers (UC) has multi -level account hierarchies that represent departments within their major Accounts. Users are creating duplicate Contacts across multiple departments. UC wants to clean the data so as to have a single Contact across departments. What two solutions should UC implement to cleanse their data? Choose 2 answers

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

Question12: Universal Containers is exporting 40 million Account records from Salesforce using Informatica Cloud. The ETL tool fails and the query log indicates a full table scan time-out failure. What is the recommended solution?

Question13: Universal Containers (UC) is implementing Salesforce Sales Cloud and Service Cloud. As part of their implementation, they are planning to create a new custom object (Shipments), which will have a lookup relationship to Opportunities. When creating shipment records, Salesforce users need to manually input a customer reference, which is provided by customers, and will be stored in the Customer_Reference__c text custom field. Support agents will likely use this customer reference to search for Shipment records when resolving shipping issues. UC is expecting to have around 5 million shipment records created per year. What is the recommended solution to ensure that support agents using global search and reports can quickly find shipment records?

Question14: 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.

Question15: 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?

Question16: 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?

Question17: 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?

Question18: 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?

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

Question20: 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?

Question21: In their legacy system. Universal Containers has a monthly accounts receivable report that compiles data from Accounts, Contacts, Opportunities, Orders. and Order Line Items. What difficulty will an architect run into when implementing this in Salesforce?

Question22: 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?

Question23: NTO (Northern Trail Outlets) has a complex Salesforce org which has been developed over past 5 years.
Internal users are complaining abt 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 3 key factors should a data architect consider while defining data quality standards? Choose 3 answers:

Question24: 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.

Question25: Universal Containers is using Salesforce for Opportunity management and enterprise resource planning (ERP) for order management. Sales reps do not have access to the ERP and have no visibility into order status.
What solution should a data architect recommend to give the sales team visibility into order status?

Question26: 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

Question27: 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?

Question28: 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?

Question29: Universal Containers has a public website with several forms that create Lead records in Salesforce using the REST API. When designing these forms, which two techniques will help maintain a high level of data quality?

Question30: NTO has outgrown its current salesforce org and will be migrating to new org shortly. As part of this process NTO will be migrating all of its metadata and dat a. 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 target org.
What 3 things should a data architect do to maintain the relationship hierarchy during migration?
Choose 3 answers:

Question31: 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

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

Question33: Northern Trail Outfitters (NTO) uses Sales Cloud and Service Cloud to manage their sales and support processes. Some of NTOs teams are complaining they see new fields on their page and are unsure of which values need be input. NTO is concerned about lack of governance in making changes to Salesforce.
Which governance measure should a data architect recommend to solve this issue?

Question34: Ursa Major Solar has the following two systems:
- Salesforce
- On-premise ERP system
Opportunity records need to be copied 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.
An Architect needs to recommend a real-time approach that fulfills these requirements.
Which recommendation is appropriate?

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

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

Question37: 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?

Question38: During the implementation of Salesforce a customer has the following requirements for Sales Order:
1. Sales Order information needs to be shown to users in Salesforce.
2. Sales Orders are maintained in the on-premise enterprise resource planning (ERP).
3. Sales Order information has more than 150 million records.
4. Sales Orders will not be updated in Salesforce.
What should a data architect recommend for maintaining Sales Orders in Salesforce?

Question39: Universal Containers has defined a new Data Quality Plan for their Salesforce data and wants to know how they can enforce it throughout the organization. Which two approaches should an architect recommend to enforce this new plan?
Choose 2 answers

Question40: 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?

Question41: Ursa Major Solar has defined a new Data Quality Plan for their Salesforce data.
Which two approaches should an Architect recommend to enforce the plan throughout the organization? (Choose two.)

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

Question43: 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?

Question44: UC recently migrated 1 Billion customer related records from a legacy data store to Heroku Postgres. A subset of the data need 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?

Question45: Universal Containers (UC) has a multi-level master-detail relationship for opportunities, a custom opportunity line item object, and a custom discount request. UC has opportunity as master and custom line item object as detail in master-detail relationship. UC also has a custom line item object as master and a custom discount request object as detail in another master-detail relationship. UC has a requirement to show all sums of discounts across line items at an opportunity level. What is the recommended solution to address these requirements?

Question46: Universal Containers (UC) is planning to move away from legacy CRM to Salesforce. As part of one-time data migration, UC will need to keep the original date when a contact was created in the legacy system. How should an Architect design the data migration solution to meet this requirement?

Question47: 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?

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

Question49: DreamHouse Realty needs an Architect to develop a solution that will integrate data and resolve duplicates and discrepancies between Salesforce and one or more external systems.
What are two important questions the Architect should answer when determining whether to use Master Data Management in the solution? (Choose two.)

Question50: Which two automated approaches should an architect recommend to purge old data out of Salesforce and aggregate that data in Salesforce? Choose 2 answers

Question51: Universal Containers has a rollup summary field on account to calculate the count of contacts associated with an account. During the account load, Salesforce is throwing an "Unable to lock a row" error.
Which solution should a data architect recommend to resolve the error?

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

Question53: 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.)

Question54: NTO has a loyalty program to reward repeat customers. The following conditions exists:
1. Reward levels are earned based on the amount spent during the previous 12 months.
2. The program will track every item a customer has bought and grant them points for discount.
3. The program generates 100 million records each month.
NTO customer support would like to see a summary of a customer's recent transaction and reward level(s) they have attained.
Which solution should the data architect use to provide the information within the salesforce for the customer support agents?

Question55: Universal Containers wishes to send data from Salesforce to an external system to generate invoices from their Order Management System (OMS). They want a Salesforce administrator to be able to customize which fields be sent to the external system without modifying code. What two approaches should an architect recommend to deliver the desired solution? Choose 2 answers

Question56: Northern Trail Outfitter has implemented Salesforce for its associates nationwide, Senior management is concerned that the executive dashboard are not reliable for their real-time decision-making. On analysis , the team 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?

Question57: Universal Container (UC) is migrating data from 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.)

Question58: Which two aspects of data does an Enterprise data governance program aim to improve?

Question59: Universal Containers (UC) has a Salesforce org with multiple automated processes defined for group membership processing, UC also has multiple admins on staff that perform manual adjustments to the role hierarchy. The automated tasks and manual tasks overlap daily, and UC is experiencing "lock errors" consistently.
What should a data architect recommend to mitigate these errors?

Question60: 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.)

Question61: UC has been using SF for 10 years. Lately, users have noticed, that the pages load slowly when viewing Customer and Account list view.
To mitigate, UC will implement a data archive strategy to reduce the amount of data actively loaded.
Which 2 tasks are required to define the strategy? Choose 2 answers:

Question62: Universal Containers (UC) has over 10 million records. They have a nightly integration that queries these records The queries are timing out What should the data architect do or look for when troubleshooting the queries?
Choose 2 answers

Question63: Northern Trail Outfitters (NTO) is in the process of evaluating big objects to store large amounts of asset data from an external system. NTO will need to report on this asset data weekly.
Which two native tools should a data architect recommend to achieve this reporting requirement? (Choose two.)

Question64: 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

Question65: 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 months, prior to the spilt.
Which migration strategy should a data architect use to successfully migrate the data?

Question66: Universal Container is using Salesforce for Opportunity management and enterprise resource planning (ERP) for order management. Sales reps do not have access to the ERP and have no visibility into order status.
What solution a data architect recommend to give the sales team visibility into order status?

Question67: 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?

Question68: Ursa Major Solar plans to use Salesforce to manage their sales organization. However, the company has legacy account data from two aging systems that must be migrated into Salesforce. The Chief Technology Officer (CTO) at Ursa Major Solar is concerned about data duplication and needs it minimized.
What are two design considerations an Architect should take in this scenario? (Choose two.)

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

Question70: 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

Question71: 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

Question72: Universal Containers (UC) has a custom discount request object set as a detail object with a custom product object as the master. There is a requirement to allow the creation of generic discount requests without the custom product object as its master record. What solution should an Architect recommend to UC?

Question73: 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?

Question74: 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

Question75: Which three options can prevent your SOQL queries from being selective?

Question76: 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?

Question77: 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

Question78: Northern Trail outfitters in migrating to salesforce from a legacy CRM system that identifies the agent relationships in a look-up table.
What should the data architect do in order to migrate the data to Salesfoce?

Question79: 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.)

Question80: 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?

Question81: 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.

Question82: 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.

Question83: 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?

Question84: A large retail company has recently chosen SF as its CRM solution. They have the following record counts:
2500000 accounts
25000000 contacts
When doing an initial performance test, the data architect noticed an extremely slow response for reports and list views.
What should a data architect do to solve the performance issue?

Question85: 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 same standard and custom fields need to encrypted.
Which solution should a data architect recommend to encrypt existing fields?

Question86: UC has millions of case records with case history and SLA dat
a. UC's compliance team would like historical cases to be accessible for 10 years for Audit purpose.
What solution should a data architect recommend?

Question87: Managers at Universal Containers (UC) have noticed that shipment records (a custom object) are being sent to the shipping department with bad address data Specifically, addresses have missing data like City and poorly formatted Postal codes. Which two approaches will solve this issue? Choose 2 answers

Question88: 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?

Question89: How can an architect find information about who is creating, changing, or deleting certain fields within the past two months?

Question90: 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 system and are not kept in sync. Customers are also complaining that they get repeated marketing emails and have to call into update their information.
NTO is planning to implement master data management (MDM) solution across the enterprise.
Which three data will an MDM tool solve?
Choose 3 answers

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

Question92: 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.)

Question93: Universal Containers (UC) is launching an RFP to acquire a new accounting product available on AppExchange. UC is expecting to issue 5 million invoices per year, with each invoice containing an average of 10 line items. What should UC's Data Architect recommend to ensure scalability?

Question94: 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?

Question95: Universal Containers (UC) wants to assess the completeness and consistency of contact information in Salesforce. They are finding that their sales reps in many caes do not have enough information about their accounts and contacts. Also, in many cases they are not able to interpret the information in a consistent manner. They have identified certain "key" fields which are important to their sales reps. Which two steps can UC implement to assess their data for completeness and consistency?

Question96: 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?

Question97: Northern Trail Outfitters is migrating to Salesforce from a legacy CRM system that identifies the agent relationships in a look-up table.
What should the data architect do in order to migrate the data to Salesforce?

Question98: DreamHouse Realty uses Custom Metadata Types instead of Custom setting.
What is an advantage of this decision?

Question99: 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?

Question100: DreamHouse Realty uses Custom Metadata Types instead of Custom setting.
What is an advantage of this decision?

Question101: UC has a requirement to migrate 100 million order records from a legacy 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 the performance degradation of the platform?

Question102: A data architect has been tasked with optimizing a data stewardship engagement for a Salesforce instance Which three areas of Salesforce should the architect review before proposing any design recommendation?
Choose 3 answers

Question103: 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 solution should a data architect recommend to resolve the complaints?

Question104: 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?

Question105: 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.)

Question106: UC has a salesforce org with multiple automated processes defined for group membership process. UC also have multiple admins on staff that perform manual adjustments to the role hierarchy. The automated task and manual task overlap daily and UC is experiencing "Lock errors" consistently.
What should a data architect recommend mitigate these errors?

Question107: Get Cloudy Consulting is migrating their legacy system's users and data to Salesforce. They will be creating 15,000 users, 1.5 million Account records, and 15 million Invoice records. The visibility of these records is controlled by a 50 owner and criteria-based sharing rules.
Get Cloudy Consulting needs to minimize data loading time during this migration to a new organization.
Which two approaches will accomplish this goal? (Choose two.)

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

Question109: Which two statements are accurate with respect to performance testing a Force.com application?

Question110: A business that works directly with individual consumers (B2C) currently has a home-grown CRM system, but they are moving to Salesforce. The business has 1.2 million consumer records and wants assistance with achieving optimal use of Salesforce functionality while also avoiding data loading issues.
What should an Architect recommend?

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