UW Scourge Part 2

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. A. Use Workflow, Validation Rules, and Force.com code (Apex) to enforce critical business processes. B. Store all data in an external system and set up an integration to Salesforce for view - only access. C. Schedule a weekly dashboard displaying records that are missing information to be sent to managers for review. D. Schedule reports that will automatically catch duplicates and merge or delete the records every week.

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.). A. Enable Update Records with Inactive Owners Permission. B. Enable modify all and view all permission. C. Enable Set Audit Fields upon Record Creation Permission. D. Log a case with Salesforce to allow updating these fields.

Universal Container (UC) has accumulated data over years and has never deleted data from its Salesforce org. UC is now exceeding the storage allocations in the org. UC is now looking for option to delete unused from the org. Which three recommendations should a data architect make is order to reduce the number of records from the org? Choose 3 answers. A. Archive the records in enterprise data warehouse (EDW) before deleting from Salesforce. B. Use Rest API to permanently delete records from the Salesforce org. C. Identify records in objects that have not been modified or used In last 3 years. D. Use hard delete in Bulk API to permanently delete records from Salesforce. E. Use hard delete in batch Apex to permanently delete records from Salesforce.

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?. A. Patients as Person Accounts, Payment providers as Accounts, & Doctors as Contacts. B. Patients as Contacts, Payment providers as Accounts, & Doctors as Accounts. C. Patients as Person Accounts, Payment providers as Accounts, & Doctors as Person Account. D. Patients as Accounts, Payment providers as Accounts, & Doctors as Person Accounts.

Universal Containers (UC) is implementing a formal, cross -business -unit data governance program As part of the program, UC will implement a team to make decisions on enterprise-wide data governance. Which two roles are appropriate as members of this team? Choose 2 answers. A. Data Domain Stewards. B. Analytics/BI Owners. C. Salesforce Administrators. D. Operational Data Users.

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

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 Standard order object to maintain Sale Orders in Salesforce. B. Us custom objects to maintain Sales Orders in Salesforce. C. Use external objects to maintain Sales Order in Salesforce. D. Use custom big objects to maintain Sales Orders in Salesforce.

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. A. Data standardization. B. Data completeness. C. Data accuracy and quality. D. Data loss and recovery. E. Data duplication.

A company has 12 million records, and a nightly integration queries these records. Which two areas should a Data Architect investigate during troubleshooting if queries are timing out? (Choose two.). A. Make sure the query doesn't contain NULL in any filter criteria. B. Create a formula field instead of having multiple filter criteria. C. Create custom indexes on the fields used in the filter criteria. D. Modify the integration users' profile to have View All Data.

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?. A. Set Customer-Reference_c as an External ID (unique). B. Implement an archiving process for shipment records created after five years. C. Set Customer-Reference_c as an External ID (non-unique). D. Implement an archiving process for shipment records created after three years.

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?. A. Enable "Set Audit Fields" and assign the permission to the user loading the data for the duration of the migration. B. After the data is migrated, perform an update on all records to set the original date in a standard CreatedDate field. C. Create a new field on Contact object to capture the Created Date. Hide the standard CreatedDate field using Field -Level Security. D. Write an Apex trigger on the Contact object, before insert event to set the original value in a standard CreatedDate field.

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?. A. Run a report which shows the last time the key fields were updated. B. Run one report per key field, grouped by that field, to understand its data variability. C. Run a report that shows the percentage of blanks for the important fields. D. Run a process that can fill in default values for blank fields.

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?. A. Create reports to identify which fields users are leaving blank, and use external data sources to augment the missing data. B. Create validation rules with error messages to explain why the field is used. C. Create and manage a data dictionary, and use a governance process for changes made to common objects. D. Add description fields to explain why the field is used, and mark the fields as Required.

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: 1. 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 Salesforce 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?. A. Use a customer data mart to create the 360 degree view of the customer. B. Migrate customer activities fro, all four system into Salesforce. C. Explore external data sources in Salesforce to build a 360 degree view of the customer. D. Periodically upload summary information in Salesforce to build a 360 degree view.

NTO need to extract 50 million records from a custom object everyday from its Salesforce org. NTO is facing query timeout issues while extracting these records. What should a data architect recommend in order to get around the time out issue?. A. Use ETL tool for extraction of records. B. Use a custom auto number and formula field and use that to chunk records while extracting data. C. The REST API to extract data as it automatically chunks records by 200. D. Ask SF support to increase the query timeout value.

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 deformalizing this data model into a single Conference object with a Venue picklist? Choose 2 answers. A. Limitations on master -detail relationships. B. Bulk API limitations on picklist fields. C. Org data storage limitations. D. Standard list view in -line editing.

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?. A. Load all individual consumers as Account records and avoid using the Contact object. B. Create a Custom object IndividualConsumer_c to load all individual consumers. C. Load one Account record and one Contact record for each individual consumer. D. Create one Account and load individual consumers as Contacts linked to that one Account.

Universal Container (US) is replacing a home grown CRM solution with Salesforce, UC has decided to migrate operational (Open and active) records to Salesforce, while keeping historical records in legacy system, UC would like historical records to be available in Salesforce on an as needed basis. Which solution should a data architect recommend to meet business requirement?. A. Bring all data Salesforce, and delete it after a year. B. Leverage real-time integration to pull records into Salesforce. C. Build a chair solution to go the legacy system and display records. D. Leverage mashup to display historical records in Salesforce.

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: A. Define data duplication standards and rules. B. Define key fields in staging database for data cleansing. C. Finalize an extract transform load (ETL) tool for data migration. D. Measure data timeliness and consistency. E. Measure data completeness and accuracy.

UC has millions of Cases and are running out of storage. Some user groups need to have access to historical cases for up to 7 years. Which 2 solutions should a data architect recommend in order to minimize performance and storage issues? Choose 2 answers: A. Leverage on premise data archival and build integration to view archived data. B. Leverage big object to archive case data and lightning components to show archived data. C. Export data out of salesforce and store in Flat files on external system. D. Create a custom object to store case history and run reports on it.

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?. A. Enable granular locking. B. Ask salesforce support for addition CPU power. C. Remove SOQL statements from APEX loops. D. Enable sharing recalculations.

Universal Containers (UC) has deployed Salesforce to manage Marketing. Sales, and Support efforts in a multi -system ERP environment After reaching the limits of native reports & dashboards. UC leadership is looking to understand what options can be used to provide more analytical insights. What two approaches should an architect recommend? Choose 2 answers. A. Setup Audit Trails. B. Wave Analytics. C. AppExchange Apps. D. Weekly Snapshots.

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.). A. How many systems are integrating with each other?. B. Will Salesforce replace a legacy system?. C. Does the system of record change for different tables?. D. Are the systems cloud-based or on-premise?.

Universal Containers (UC) wants to ensure their data on 100,000 Accounts pertaining mostly to US-based companies is enriched and cleansed on an ongoing basis. UC is looking for a solution that allows easy monitoring of key data quality metrics. What should be the recommended solution to meet this requirement?. A. Implement Batch Apex that calls out a third-party data quality API in order to monitor Account data quality. B. Use declarative approach by installing and configuring Data.com Prospector to monitor Account data quality. C. Use a declarative approach by installing and configuring Data.com Clean to monitor Account data quality. D. Implement an Apex Trigger on Account that queries a third-party data quality API to monitor Account data quality.

NTO uses salesforce to manage relationships and track sales opportunities. It has 10 million customers and 100 million opportunities. The CEO has been complaining 10 minutes to run and sometimes failed to load, throwing a time out error. Which 3 options should help improve the dashboard performance? Choose 3 answers: A. Run the dashboard for CEO and send it via email. B. De-normalize the data by reducing the number of joins. C. Remove widgets from the dashboard to reduce the number of graphics loaded. D. Use selective queries to reduce the amount of data being returned. E. Reduce the amount of data queried by archiving unused opportunity records.

UC has one SF org (Org A) and recently acquired a secondary company with its own Salesforce org (Org B). UC has decided to keep the orgs running separately but would like to bidirectionally share opportunities between the orgs in near-real time. Which 3 options should a data architect recommend to share data between Org A and Org B? Choose 3 answers. A. Develop an Apex class that pushes opportunity data between orgs daily via the Apex schedule. B. Leverage Heroku Connect and Heroku Postgres to bidirectionally sync Opportunities. C. Leverage middleware tools to bidirectionally send Opportunity data across orgs. D. Install a 3rd party AppExchange tool to handle the data sharing. E. Use Salesforce Connect and the cross-org adapter to visualize Opportunities into external objects.

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?. A. Limit data loading to the 2000 most recently created records. B. Load only the data that the users is permitted to access. C. Create a skinny table to represent account and contact objects. D. Add custom indexes on frequently searched account and contact objects fields.

Universal Containers (UC) maintains a collection of several million Account records that represent business in the United Sates. As a logistics company, this list is one of the most valuable and important components of UC's business, and the accuracy of shipping addresses is paramount. Recently it has been noticed that too many of the addresses of these businesses are inaccurate, or the businesses don't exist. Which two scalable strategies should UC consider to improve the quality of their Account addresses?. A. Integrate with a third-party database or services for address validation and enrichment. B. Build a team of employees that validate Accounts by searching the web and making phone calls. C. Leverage Data.com Clean to clean up Account address fields with the D&B database. D. Contact each business on the list and ask them to review and update their address information.

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?. A. Salesforce License. B. Lightning Platform Starter License. C. Service Cloud License. D. Sales Cloud License.

Universal Containers has received complaints that customers are being called by multiple Sales Reps where the second Sales Rep that calls is unaware of the previous call by their coworker. What is a data quality problem that could cause this?. A. Duplicate Contact records exist in the system. B. Missing phone number on the Contact record. C. Duplicate Activity records on a Contact. D. Customer phone number has changed on the Contact record.

Universal Containers (UC) has 1,000 accounts and 50,000 opportunities. UC has an enterprise security requirement to export all sales data outside of Salesforce on a weekly basis. The security requirement also calls for exporting key operational data that includes events such as file downloads, logins, logouts, etc. Which two recommended approaches would address the above requirement?. A. Use Weekly Export to extract transactional data to on-premise systems. B. Use Event Monitoring to extract event data to on-premise systems. C. Use a custom built extract job to extract operational data to on-premise systems. D. Use Field Audit History to capture operational data and extract it to on-premise systems.

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. A. Load all data after deferring sharing calculations. B. Calculate summary values instead of Roll-Up by using workflow. C. Calculate summary values instead of Roll-Up by using triggers. D. Load all data using external IDs to link to parent records.

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

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?. A. Use a custom Big object to store archived case data. B. Purchase more data storage to support case object. C. Archive Case data using Salesforce Archiving process. D. Use a custom object to store archived case data.

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?. A. Use external objects to maintain Sales Orders in Salesforce. B. Use custom big objects to maintain Sales Orders in Salesforce. C. Use Standard Order object to maintain Sales Orders in Salesforce. D. Use custom objects to maintain Sales Orders in Salesforce.

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. A. Calculate summary values instead of Roll-Up by using triggers. B. Load all data after deferring sharing calculations. C. Load all data using external IDs to link to parent records. D. Calculate summary values instead of Roll-Up by using workflow.

Universal Containers (UC) has over 10 million accounts with an average of 20 opportunities with each account. A Sales Executive at UC needs to generate a daily report for all opportunities in a specific opportunity stage. Which two key considerations should be made to make sure the performance of the report is not degraded due to large data volume?. A. Number of records returned by report query. B. Number of characters in report query. C. Number of queries running at a time. D. Number of joins used in report query.

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?. A. Perform batch job in parallel mode, and reduce batch size. B. Defer rollup summary fields calculation during data migration. C. Leverage data loader platform API to load data. D. Perform batch job in serial mode, and reduce batch size.

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.). A. Work with business units and IT to assess current operational systems and data models. B. Work with database administrators to assess current database performance metrics. C. Work with IT program managers to assess current velocity of projects in the pipeline. D. Work with executive sponsorship to assess enterprise data strategy and goals.

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. Store the data in a staging database, and de-duplicate identical records. B. Migrate the data as is, and use Salesforce's de-duplicating feature. 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.

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?. A. Use an ETL tool to orchestrate the migration. B. Write a script to use the Bulk API. C. Use Data Loader for export and Data Import Wizard for import. D. Use the Salesforce CLI to query, export, and import.

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.). A. Before importing into Salesforce, clean the data. B. Check and prevent duplicates by using a workflow. C. Import the data concurrently. D. Use Salesforce matching and duplicate rules.

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?. A. Integrate Salesforce with ERP, and make ERP as system of truth. B. Implement a de-dupe solution and establish account ownership in Salesforce. C. Build a nightly sync job from ERP to Salesforce. D. Build a nightly batch job to de-dupe data, and merge account records.

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?. A. Modify the export query that includes standard index fields(s). B. Modify the export job header to specify Sforce-Enable-PKChunking. C. Modify the export job header to specify Export-in-Parallel. D. Modify the export query with LIMIT clause with Batch size 10,000.

UC is migrating data from legacy system to SF. UC would like to preserve the following information on records being migrated: Date time stamps for created date and last modified date. Ownership of records belonging to inactive users being migrated to Salesforce. Which 2 solutions should a data architect recommends to preserve the date timestamps and ownership on records? Choose 2 answers. A. Enable modify all and view all permission. B. Enable update records with Inactive Owners Permission. C. Log a case with SF to update these fields. D. Enable Set Audit fields upon Record Creation Permission.

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. A. Create custom indexes on the fields used in the filter criteria. B. Ensure the query doesn't contain NULL in any filter criteria. C. Change the integration users' profile to have View All Data. D. Create a formula field instead of having multiple filter criteria.

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?. A. Ask Salesforce support for additional CPU power. B. Enable sharing recalculations. C. Remove SOQL statements from Apex Loops. D. Enable granular locking.

Universal Containers is setting up an external Business Intelligence (BI) system and wants to extract 1,000,000 Contact records. What should be recommended to avoid timeouts during the export process?. A. Use the SOAP API to export data. B. Schedule a Batch Apex job to export the data. C. Use GZIP compression to export the data. D. Utilize the Bulk API to export the data.

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. A. Review the sharing model to determine impact on duplicate records. B. Determine if any integration points create records in Salesforce. C. Export the setup audit trail to review what fields are being used. D. Run key reports to determine what fields should be required. E. Review the metadata xml files for redundant fields to consolidate.