DATA ARCHITECTURE AND MANAGEMENT DESIGNER Flashcards
Cloud Kicks has the following requirements:
• Their Shipment custom object must always relate to a Product, a Sender, and a Receiver (all separate custom objects).
• If a Shipment is currently associated with a Product, Sender, or Receiver, deletion of those records should not be allowed.
• Each custom object must have separate sharing models.
What should an Architect do to fulfill these requirements?
A. Associate the Shipment to each parent record by using a VLOOKUP formula field.
B. Create a required Lookup relationship to each of the three parent records.
C. Create a Master-Detail relationship to each of the three parent records.
D. Create two Master-Detail and one Lookup relationship to the parent records.
Answer: B
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. After the data is migrated, perform an update on all records to set the original date in a standard CreatedDate field.
B. Create a new field on Contact object to capture the Created Date. Hide the standard CreatedDate field using Field -Level Security.
C. Enable “Set Audit Fields” and assign the permission to the user loading the data for the duration of the migration.
D. Write an Apex trigger on the Contact object, before insert event to set the original value in a standard CreatedDate field.
Answer: C
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
A. Implement a third-party validation process with translate functionality.
B. Create a trigger on Contact and add an error to the record with a custom label.
C. Create a workflow field update to set the standard ErrorMessage field.
D. Create a validation rule and translate the error message with the translation workbench.
Answer: B, D
What is an advantage of using Custom metadata type over Custom setting?
A. Custom metadata records are not copied from production to sandbox.
B. Custom metadata types are available for reporting.
C. Custom metadata records are deployable using packages.
D. Custom metadata records are editable in Apex.
Answer: C
Get Cloudy Consulting uses an invoicing system that has specific requirements. One requirement is that attachments associated with the Invoice_c custom object be classified by Types (i.e., ““Purchase Order””, ““Receipt””, etc.) so that reporting can be performed on invoices showing the number of attachments grouped by Type. What should an Architect do to categorize the attachments to fulfill these requirements?
A. Add additional options to the standard ContentType picklist field for the Attachment object.
B. Add a ContentType picklist field to the Attachment layout and create additional picklist options.
C. Create a custom picklist field for the Type on the standard Attachment object with the values.
D. Create a custom object related to the Invoice object with a picklist field for the Type.
Answer: D
Universal Containers has a legacy system that captures Conferences and Venues. These Conferences can occur at any Venue. They create hundreds of thousands of Conferences per year. Historically, they have only used 20 Venues. Which two things should the data architect consider when denormalizing this data model into a single Conference object with a Venue picklist? Choose 2 answers
A. Limitations on master-detail relationships.
B. Org data storage limitations.
C. Bulk API limitations on picklist fields.
D. Standard list view in-line editing.
Answer: C,D
Universal Container (UC) has around 200,000 Customers (stored in Account object). They get 1 or 2 Orders every month from each Customer. Orders are stored in a custom object called “Order c”; this has about 50 fields. UC is expecting a growth of 10% year -over -year. What are two considerations an architect should consider to improve the performance of SOQL queries that retrieve data from the Order _c object?
Choose 2 answers
A. Use SOQL queries without WHERE conditions.
B. Work with Salesforce Support to enable Skinny Tables.
C. Reduce the number of triggers on Order_c object.
D. Make the queries more selective using indexed fields.
Answer: B, D
Universal Containers (UC) provides shipping services to its customers. They use Opportunities to track customer shipments. At any given time, shipping status can be one of the 10 values. UC has 200,000 Opportunity records. When creating a new field to track shipping status on the opportunity, what should the architect do to improve data quality and avoid data skew?
A. Create a picklist field, values sorted alphabetically.
B. Create a Master-Detail to custom object ShippingStatus c.
C. Create a Lookup to custom object ShippingStatus c.
D. Create a text field and make it an external ID.
Answer: A
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
A. Create a workflow to evaluate the rule when a record is created and use field update actions to store previous values for these ten fields in ten new fields.
B. Write an Apex trigger on Contact after insert event and after update events and store the old values in another custom object.
C. Turn on-field Contact object history tracking for these ten fields, then create reports on contact
history.
D. Create a Contact report including these ten fields and Salesforce Id, then schedule the report to run once a day and send an email to the admin.
Answer: B, C
Universal Containers (UC) has an open sharing model for its Salesforce users to allow all its Salesforce internal users to edit all contacts, regardless of who owns the contact. However, UC management wants to allow only the owner of a contact record to delete that contact. If a user does not own the contact, then the user should not be allowed to delete the record. How should the architect approach the project so that the requirements are met?
A. Create a “before delete” trigger to check if the current user is not the owner.
B. Set the Sharing settings as Public Read Only for the Contact object.
C. Set the profile of the users to remove delete a permission from the Contact object.
D. Create a validation rule on the Contact object to check if the current user is not the owner.
Answer: A
Universal Containers (UC) uses Salesforce for tracking opportunities (Opportunity). UC uses an internal ERP system for tracking deliveries and invoicing. The ERP system supports SOAP API and OData for bi-directional integration between Salesforce and the ERP system. UC has about one million opportunities. For each opportunity, UC sends 12 invoices, one per month. UC sales reps have requirements to view current invoice status and invoice amount from the opportunity page. When creating an object to model invoices, what should the architect recommend, considering performance and data storage space?
A. Use Streaming API to get the current status from the ERP and display on the Opportunity page.
B. Create an external object Invoice _x with a Lookup relationship with Opportunity.
C. Create a custom object Invoice _c with a master-detail relationship with Opportunity.
D. Create a custom object Invoice _c with a Lookup relationship with Opportunity.
Answer: B
Universal Containers has a large number of Opportunity fields (100) that they want to track field history on. Which two actions should an architect perform in order to meet this requirement?
Choose 2 answers
A. Create a custom object to store a copy of the record when changed.
B. Create a custom object to store the previous and new field values.
C. Use Analytic Snapshots to store a copy of the record when changed.
D. Select the 100 fields in the Opportunity Set History Tracking page.
Answer: A, B
DreamHouse Realty has a Salesforce org that is used to manage Contacts.
What are two things an Architect should consider using to maintain data quality in this situation?
(Choose two.)
A. Use the private sharing model.
B. Use Salesforce duplicate management.
C. Use validation rules on new record create and edit.
D. Use workflow to delete duplicate records.
Answer: B, C
Universal Containers is looking to use Salesforce to manage their sales organization. They will be migrating legacy account data from two aging systems into Salesforce. Which two design considerations should an architect take to minimize data duplication?
Choose 2 answers
A. Use a workflow to check and prevent duplicates.
B. Clean data before importing to Salesforce.
C. Use Salesforce matching and duplicate rules.
D. Import the data concurrently.
Answer: B, C
Universal Containers (UC) has a Salesforce instance with over 10.000 Account records. They have noticed similar, but not identical. Account names and addresses. What should UC do to ensure proper data quality?
A. Use a service to standardize Account addresses, then use a 3rd -party tool to merge Accounts based on rules.
B. Run a report, find Accounts whose name starts with the same five characters, then merge those Accounts.
C. Enable Account de -duplication by creating matching rules in Salesforce, which will mass merge duplicate Accounts.
D. Make the Account Owner clean their Accounts’ addresses, then merge Accounts with the same address.
Answer: C
Cloud Kicks stores Invoice records in a custom object. Invoice records are being sent to the Accounting department with missing States and incorrectly formatted Postal Codes.
Which two actions should Cloud Kicks take to improve data quality?
(Choose two.)
A. Change each address field to required on the Page Layout.
B. Write an Apex Trigger to require all fields to be populated.
C. Utilize a Validation Rule with a REGEX operator on Postal Code.
D. Utilize a Validation Rule with a CONTAINS operator on address fields.
Answer: C,D
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
A. Make use of a third-party tool to help merge duplicate Contacts across Accounts.
B. Use Data.com to standardize Contact address information to help identify duplicates.
C. Use Workflow rules to standardize Contact information to identify and prevent duplicates.
D. Make use of the Merge Contacts feature of Salesforce to merge duplicates for an Account.
Answer: A, B
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. Schedule a weekly dashboard displaying records that are missing information to be sent to managers for review.
B. Use Workflow, Validation Rules, and Force.com code (Apex) to enforce critical business processes.
C. Schedule reports that will automatically catch duplicates and merge or delete the records every week.
D. Store all data in an external system and set up an integration to Salesforce for view-only access
Answer: A, B
Universal Containers wants to implement a data -quality process to monitor the data that users are manually entering into the system through the Salesforce UI. Which approach should the architect recommend?
A. Allow users to import their data using the Salesforce Import tools.
B. Utilize a 3rd -party solution from the AppExchange for data uploads.
C. Utilize an app from the AppExchange to create data -quality dashboards.
D. Use Apex to validate the format of phone numbers and postal codes.
Answer: C
A manager at Cloud Kicks is importing Leads into Salesforce and needs to avoid creating duplicate records.
Which two approaches should the manager take to achieve this goal?
(Choose two.)
A. Acquire an AppExchange Lead de-duplication application.
B. Implement Salesforce Matching and Duplicate Rules.
C. Run the Salesforce Lead Mass de-duplication tool.
D. Create a Workflow Rule to check for duplicate records.
Answer: A,B
DreamHouse Realty has an integration that creates records in a Salesforce Custom Object. The Custom Object has a field marked as required on the page layout.
DreamHouse Realty has noticed that many of the records coming from the external system are missing data in this field.
The Architect needs to ensure this field always contains data coming from the source system. Which two approaches should the Architect take?
Choose 2 answers
A. Set up a Validation Rule to prevent blank values.
B. Create a Workflow to default a value into this field.
C. Mark the field required in setup at the field level.
D. Blame the customer’s external system for bad data.
Answer: A, C
Universal Containers has two systems. Salesforce and an on -premise ERP system. An architect has been tasked with copying Opportunity records to the ERP once they reach a Closed/Won Stage. The
Opportunity record in the ERP system will be read-only for all fields copied in from Salesforce. What is the optimal real-time approach that achieves this solution?
A. Implement a Master Data Management system to determine system of record.
B. Implement a workflow rule that sends Opportunity data through Outbound Messaging.
C. Have the ERP poll Salesforce nightly and bring in the desired Opportunities.
D. Implement an hourly integration to send Salesforce Opportunities to the ERP system.
Answer: B
Universal Containers (UC) has three systems: Salesforce, a cloud -based ERP system, and an on - premise Order Management System (OMS). An architect has been tasked with creating a solution that uses Salesforce as the system of record for Leads and the OMS as the system of record for Account and Contacts. UC wants Accounts and Contacts to be able to maintain their names in each system (i.e., “John Doe” in the OMS and “Johnny Doe” in Salesforce), but wants to have a consolidated data store which links referenced records across the systems. What approach should an architect suggest so the requirements are met?
A. Have Salesforce poll the OMS nightly and bring in the desired Accounts and Contacts.
B. Implement an integration tool to send OMS Accounts and Contacts to Salesforce.
C. Implement a Master Data Management strategy to reconcile Leads, Accounts, and Contacts.
D. Use the Streaming API to send Account and Contact data from Salesforce to the OMS.
Answer: C
An architect has been asked by a client to develop a solution that will integrate data and resolve duplicates and discrepancies between Salesforce and one or more external systems. What two factors should the architect take into consideration when deciding whether or not to use a Master Data Management system to achieve this solution?
Choose 2 answers
A. Whether the systems are cloud-based or on-premise.
B. Whether or not Salesforce replaced a legacy CRM.
C. Whether the system of record changes for different tables.
D. The number of systems that are integrating with each other.
Answer: C, D
Get Cloud Consulting needs to integrate two different systems with customer records into the Salesforce Account object. So that no duplicate records are created in Salesforce, Master Data
Management will be used.
An Architect needs to determine which system is the system of record on a field level. What should the Architect do to achieve this goal?
A. Master Data Management systems determine system of record, and the Architect doesn’t have to think about what data is controlled by what system.
B. Key stakeholders should review any fields that share the same purpose between systems to see how they will be used in Salesforce.
C. The database schema for each external system should be reviewed, and fields with different names should always be separate fields in Salesforce.
D. Any field that is an input field in either external system will be overwritten by the last record integrated and can never have a system of record.
Answer: C
Salesforce is being deployed in Ursa Major Solar’s disparate, multi-system ERP environment. Ursa major Solar wants to maintain data synchronization between systems.
Which two techniques should be used to achieve this goal?
(Choose two.)
A. Integrate Salesforce with the ERP environment.
B. Utilize workbench to update files within systems.
C. Utilize an MDM strategy to outline a single source of truth.
D. Build synchronization reports and dashboards.
Answer: A,C
All accounts and opportunities are created in Salesforce. Salesforce is integrated with three systems:
• An ERP system feeds order data into Salesforce and updates both Account and Opportunity records.
• An accounting system feeds invoice data into Salesforce and updates both Account and Opportunity records.
• A commission system feeds commission data into Salesforce and updates both Account and Opportunity records.
How should the architect determine which of these systems is the system of record?
A. Account and opportunity data originates in Salesforce, and therefore Salesforce is the system of record.
B. Whatever system updates the attribute or object should be the system of record for that field or object.
C. Whatever integration data flow runs last will, by default, determine which system is the system of record.
D. Data flows should be reviewed with the business users to determine the system of record per object or field.
Answer: D
A company wants to document the data architecture of a Salesforce organization.
What are two valid metadata types that should be included?
(Choose two.)
A. RecordType
B. Document
C. CustomField
D. Security settings
Answer: A, C
An Architect needs to document the data architecture for a multi-system, enterprise Salesforce implementation.
Which two key artifacts should the Architect use?
(Choose two.)
A. User stories
B. Data model
C. Integration specification
D. Non-functional requirements
Answer: B,C
As part of a phased Salesforce rollout. there will be 3 deployments spread out over the year. The requirements have been carefully documented. Which two methods should an architect use to trace back configuration changes to the detailed requirements?
Choose 2 answers
A. Review the setup audit trail for configuration changes.
B. Put the business purpose in the Description of each field.
C. Maintain a data dictionary with the justification for each field.
D. Use the Force.com IDE to save the metadata files in source control.
Answer: B, C
How can an architect find information about who is creating, changing, or deleting certain fields within the past two months?
A. Remove “customize application” permissions from everyone else.
B. Export the metadata and search it for the fields in question.
C. Create a field history report for the fields in question.
D. Export the setup audit trail and find the fields in question.
Answer: D
Universal Containers wants to automatically archive all inactive Account data that is older than 3 years. The information does not need to remain accessible within the application. Which two methods should be recommended to meet this requirement?
Choose 2 answers
A. Use the Force.com Workbench to export the data.
B. Schedule a weekly export file from the Salesforce UI.
C. Schedule jobs to export and delete using an ETL tool.
D. Schedule jobs to export and delete using the Data Loader.
Answer: C, D
Cloud Kicks needs to purge detailed transactional records from Salesforce. The data should be aggregated at a summary level and available in Salesforce.
What are two automated approaches to fulfill this goal?
(Choose two.)
A. Third-party Integration Tool (ETL)
B. Schedulable Batch Apex
C. Third-party Business Intelligence system
D. Apex Triggers
Answer: A,B
Universal Containers (UC) is concerned that data is being corrupted daily either through negligence or maliciousness. They want to implement a backup strategy to help recover any corrupted data or data mistakenly changed or even deleted. What should the data architect consider when designing a field-level audit and recovery plan?
A. Reduce data storage by purging old data.
B. Implement an AppExchange package.
C. Review projected data storage needs.
D. Schedule a weekly export file.
Answer: A
Every year, Ursa Major Solar has more than 1 million orders. Each order contains an average of 10 line items. The Chief Executive Officer (CEO) needs the Sales Reps to see how much money each customer generates year-over-year. However, data storage is running low in Salesforce. Which approach for data archiving is appropriate for this scenario?
A. 1. Annually export and delete order line items. 2. Store them in a zip file in case the data is needed later.
B. 1. Annually aggregate order amount data to store in a custom object. 2. Delete those orders and order line items.
C. 1. Annually export and delete orders and order line items. 2. Store them in a zip file in case the data is needed later.
D. 1. Annually delete orders and order line items. 2. Ensure the customer has order information in another system.
Answer: B
Get Cloudy Consulting monitors 15,000 servers, and these servers automatically record their status every 10 minutes. Because of company policy, these status reports must be maintained for 5 years. Managers at Get Cloudy Consulting need access to up to one week’s worth of these status reports with all of their details.
An Architect is recommending what data should be integrated into Salesforce and for how long it should be stored in Salesforce.
Which two limits should the Architect be aware of?
(Choose two.)
A. Data storage limits
B. Workflow rule limits
C. API Request limits
D. Webservice callout limits
Answer: A,C
A Salesforce customer has plenty of data storage. Sales Reps are complaining that searches are bringing back old records that aren’t relevant any longer. Sales Managers need the data for their historical reporting. What strategy should a data architect use to ensure a better user experience for the Sales Reps?
A. Create a Permission Set to hide old data from Sales Reps.
B. Use Batch Apex to archive old data on a rolling nightly basis.
C. Archive and purge old data from Salesforce on a monthly basis.
D. Set data access to Private to hide old data from Sales Reps.
Answer: C
Universal Containers (UC) is implementing a formal, cross-business-unit data governance program As part of the program, UC will implement a team to make decisions on enterprise-wide data governance. Which two roles are appropriate as members of this team?
Choose 2 answers
A. Analytics/BI Owners
B. Data Domain Stewards
C. Salesforce Administrators
D. Operational Data Users
Answer: A, B
Universal Containers (UC) has a complex system landscape and is implementing a data governance program for the first time Which two first steps would be appropriate for UC to initiate an assessment of data architecture?
Choose 2 answers
A. Engage with IT program managers to assess the current velocity of projects in the pipeline.
B. Engage with database administrators to assess current database performance metrics.
C. Engage with executive sponsorship to assess enterprise data strategy and goals.
D. Engage with business units and IT to assess current operational systems and data models.
Answer: C, D
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 metadata xml files for redundant fields to consolidate.
B. Determine if any integration points create records in Salesforce.
C. Run key reports to determine what fields should be required.
D. Export the setup audit trail to review what fields are being used.
E. Review the sharing model to determine impact on duplicate records.
Answer: A, C, E
To avoid creating duplicate Contacts, a customer frequently uses Data Loader to upsert Contact records into Salesforce. What common error should the data architect be aware of when using upsert?
A. Errors with duplicate external Id values within the same CSV file.
B. Errors with records being updated and inserted in the same CSV file.
C. Errors when a duplicate Contact name is found cause upsert to fail.
D. Errors with using the wrong external Id will cause the load to fail.
Answer: A
Universal Containers has deployed Salesforce for case management The company is having difficulty understanding what percentage of cases are resolved from the initial call to their support organization. What first step is recommended to implement a reporting solution to measure the support rep’s case closure rates?
A. Enable field history tracking on the Case object.
B. Create a report on Case analytic snapshots.
C. Install AppExchange packages for available reports.
D. Create Contact and Opportunity Reports and Dashboards.
Answer: A
The head of sales at Get Cloudy Consulting wants to understand key relevant performance figures and help managers take corrective actions where appropriate.
What is one reporting option Get Cloudy Consulting should consider?
A. Case SLA performance report
B. Sales KPI Dashboard
C. Opportunity analytic snapshot
D. Lead conversion rate report
Answer: B
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?
A. Salesforce allows up to four objects in a single report type.
B. Salesforce does not support Orders or Order Line Items.
C. A report cannot contain data from Accounts and Contacts.
D. Custom report types cannot contain Opportunity data.
Answer: A
Universal Containers keeps its Account data in Salesforce and its Invoice data in a third -party ERP system. They have connected the Invoice data through a Salesforce external object. They want data from both Accounts and Invoices visible in one report in one place. What two approaches should an architect suggest for achieving this solution?
Choose 2 answers
A. Create a report in an external system combining Salesforce Account data and Invoice data from the ERP.
B. Create a report combining data from the Account standard object and the Invoices external object.
C. Create a Visualforce page combining Salesforce Account data and Invoice external object data.
D. Create a separate Salesforce report for Accounts and Invoices and combine them in a dashboard.
Answer: A, C
Universal Containers wishes to maintain Lead data from Leads even after they are deleted and cleared from the Recycle Bin. What approach should be implemented to achieve this solution?
A. Use a Lead standard report and filter on the IsDeleted standard field.
B. Use a Converted Lead report to display data on Leads that have been deleted.
C. Query Salesforce with the queryAll API method or using the ALL ROWS SOQL keywords.
D. Send data to a Data Warehouse and mark Leads as deleted in that system.
Answer: D
Universal Containers (UC) has deployed Salesforce to manage Marketing. Sales, and Support efforts in a multi-system ERP environment After reaching the limits of native reports & dashboards. UC leadership is looking to understand what options can be used to provide more analytical insights. What two approaches should an architect recommend?
Choose 2 answers
A. AppExchange Apps
B. Wave Analytics
C. Weekly Snapshots
D. Setup Audit Trails
Answer: A, B
Universal Containers is setting up an external Business Intelligence (BI) system and wants to extract 1,000,000 Contact records. What should be recommended to avoid timeouts during the export process?
A. Use the SOAP API to export data.
B. Utilize the Bulk API to export the data.
C. Use GZIP compression to export the data.
D. Schedule a Batch Apex job to export the data.
Answer: C
Universal Containers (UC) is a business that works directly with individual consumers (B2C). They are moving from a current home-grown CRM system to Salesforce. UC has about one million consumer records. What should the architect recommend for optimal use of Salesforce functionality and also to avoid data loading issues?
A. Create a Custom Object Individual Consumer c to load all individual consumers.
B. Load all individual consumers as Account records and avoid using the Contact object.
C. Load one Account record and one Contact record for each individual consumer.
D. Create one Account and load individual consumers as Contacts linked to that one Account.
Answer: C
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?
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.
Answer: A
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.)
A. Create the users, upload all data, and then deploy the sharing rules.
B. Contact Salesforce to activate indexing before uploading the data.
C. First, load all account records, and then load all user records.
D. Defer sharing calculations until the data has finished uploading.
Answer: A, D
Cloud Kicks has the following requirements:
- Data needs to be sent from Salesforce to an external system to generate invoices from their Order Management System (OMS).
- A Salesforce administrator must be able to customize which fields will be sent to the external system without changing code.
What are two approaches for fulfilling these requirements?
(Choose two.)
A. A set to determine which fields to send in an HTTP callout.
B. An Outbound Message to determine which fields to send to the OMS.
C. A Field Set that determines which fields to send in an HTTP callout.
D. Enable the field-level security permissions for the fields to send.
Answer: B, C
The architect is planning a large data migration for Universal Containers from their legacy CRM system to Salesforce. What three things should the architect consider to optimize the performance of the data migration?
Choose 3 answers
A. Review of the time zones of the User loading the data.
B. Remove custom indexes on the data being loaded.
C. Determine if the legacy system is still in use.
D. Defer sharing calculations of the Salesforce Org.
E. Deactivate approval processes and workflow rules.
Answer: B, D, E
Universal Containers has a large volume of Contact data going into Salesforce.com. There are 100,000 existing contact records. 200,000 new contacts will be loaded. The Contact object has an external ID field that is unique and must be populated for all existing records. What should the architect recommend to reduce data load processing time?
A. Load Contact records together using the Streaming API via the Upsert operation.
B. Delete all existing records, and then load all records together via the Insert operation.
C. Load all records via the Upsert operation to determine new records vs. existing records.
D. Load new records via the Insert operation and existing records via the Update operation.
Answer: D
An architect is planning on having different batches to load one million Opportunities into Salesforce using the Bulk API in parallel mode. What should be considered when loading the Opportunity records?
A. Create indexes on Opportunity object text fields.
B. Group batches by the AccountId field.
C. Sort batches by Name field values.
D. Order batches by Auto -number field.
Answer: D
DreamHouse Realty has 15 million records in the Order_c custom object. When running a bulk query, the query times out.
What should be considered to address this issue?
A. Tooling API
B. PK Chunking
C. Metadata API
D. Streaming API
Answer: B
Company S was recently acquired by Company T. As part of the acquisition, all of the data for Company S’s Salesforce instance (source) must be migrated into Company T’s Salesforce instance (target). Company S has 6 million Case records.
An Architect has been tasked with optimizing the data load time.
What should the Architect consider to achieve this goal?
A. Pre-process the data, then use Data Loader with SOAP API to upsert with zip compression enabled.
B. Directly leverage Salesforce-to-Salesforce functionality to load Case data.
C. Load the data in multiple sets using Bulk API parallel processes.
D. Utilize the Salesforce Org Migration Tool from the Setup Data Management menu.
Answer: A
Universal Containers (UC) has users complaining about reports timing out or simply taking too long to run What two actions should the data architect recommend to improve the reporting experience?
Choose 2 answers
A. Index key fields used in report criteria.
B. Enable Divisions for large data objects.
C. Create one skinny table per report.
D. Share each report with fewer users.
Answer: A, C
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.
Answer: A,C
Universal Containers (UC) is implementing a Salesforce project with large volumes of data and daily transactions. The solution includes both real-time web service integrations and Visualforce mash - ups with back -end systems. The Salesforce Full sandbox used by the project integrates with full-scale back -end testing systems. What two types of performance testing are appropriate for this project?
Choose 2 answers
A. Pre -go -live automated page -load testing against the Salesforce Full sandbox.
B. Post go -live automated page -load testing against the Salesforce Production org.
C. Pre -go -live unit testing in the Salesforce Full sandbox.
D. Stress testing against the web services hosted by the integration middleware.
Answer: A, D
Developers at Universal Containers need to build a report for the business which displays Accounts opened in the past year grouped by industry. This report will also include information from contacts, opportunities, and orders. There are several million Accounts in the system. Which two options should be recommended to make this report perform well and satisfy the business need?
Choose 2
A. Use triggers to populate denormalized related fields on the Account.
B. Use an indexed data field with bounded data filters.
C. Use Formula fields to surface information I related entities on the report.
D. Use unbounded date ranges to filter the report.
Answer: B, D
A customer wishes to migrate 700,000 Account records in a single migration into Salesforce. What is the recommended solution to migrate these records while minimizing migration time?
A. Use Salesforce Soap API in parallel mode.
B. Use Salesforce Bulk API in serial mode.
C. Use Salesforce Bulk API in parallel mode.
D. Use Salesforce Soap API in serial mode.
Answer: C
Universal Containers has millions of rows of data in Salesforce that are being used in reports to evaluate historical trends. Performance has become an issue, as well as data storage limits. Which two strategies should be recommended when talking with stakeholders?
Choose 2
A. Use scheduled batch Apex to copy aggregate information into a custom object and delete the original records.
B. Combine Analytics Snapshots with a purging plan by reporting on the snapshot data and deleting the original records.
C. Use Data Loader to extract data, aggregate it, and write it back to a custom object, then delete the original records.
D. Configure the Salesforce Archiving feature to archive older records and remove them from the data storage limits.
Answer: A, D
Universal Containers (UC) has implemented Sales Cloud and it has been noticed that Sales reps are not entering enough data to run insightful reports and dashboards. UC executives would like to monitor and measure data quality metrics. What solution addresses this requirement?
A. Use third-party AppExchange tools to monitor and measure data quality.
B. Generate reports to view the quality of sample data.
C. Use custom objects and fields to calculate data quality.
D. Export the data to an enterprise data warehouse and use BI tools for data quality.
Answer: A
A shipping and logistics company has created a large number of reports within Sales Cloud since Salesforce was introduced. Some of these reports analyze large amounts of data regarding the whereabouts of the company’s containers, and they are starting to time out when users are trying to run the reports. What is a recommended approach to avoid these time-out issues?
A. Improve reporting performance by creating a custom Visualforce report that is using a cache of the records in the report.
B. Improve reporting performance by replacing the existing reports in Sales Cloud with new reports based on Analytics Cloud.
C. Improve reporting performance by creating an Apex trigger for the Report object that will prefetch data before the report is run.
D. Improve reporting performance by creating a dashboard that is scheduled to run the reports only once per day.
Answer: B
Due to security requirements, Universal Containers needs to capture specific user actions, such as login, logout, file attachment download, package install, etc. What is the recommended approach for defining a solution for this requirement?
A. Use a field audit trail to capture field changes.
B. Use a custom object and trigger to capture changes.
C. Use Event Monitoring to capture these changes.
D. Use a third-party AppExchange app to capture changes.
Answer: C
Universal Containers (UC) is concerned about the accuracy of their customer information in Salesforce. They have recently created an enterprise-wide trusted source MDM for Customer data which they have certified to be accurate. UC has over 20 million unique customer records in the trusted source and Salesforce. What should an Architect recommend to ensure the data in Salesforce is identical to the MDM?
A. Extract the Salesforce data into Excel and manually compare this against the trusted source.
B. Load the Trusted Source data into Salesforce and run an Apex Batch job to find difference.
C. Use an AppExchange package for Data Quality to match Salesforce data against the Trusted source.
D. Leave the data in Salesforce alone and assume that it will auto-correct itself over time.
Answer: C
Which two statements are accurate with respect to performance testing a Force.com application?
pick 2
A. All Force.com applications must be performance tested in a sandbox as well as production.
B. A performance test plan must be created and submitted to Salesforce customer support.
C. Applications with highly customized code or large volumes should be performance tested.
D. Application performance benchmarked in a sandbox can also be expected in production.
Answer: B, C
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?
A. Ensure invoice line items simply reference existing Opportunity line items.
B. Ensure the account product vendor includes Wave Analytics in their offering.
C. Ensure the account product vendor provides a sound data archiving strategy.
D. Ensure the accounting product runs 100% natively on the Salesforce platform.
Answer: C
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?
A. Mandate the selection of a custom product for each discount request.
B. Create a placeholder product record for the generic discount request.
C. Remove the master-detail relationship and keep the objects separate.
D. Change the master-detail relationship to a lookup relationship.
Answer: D
Get Cloudy Consulting needs to evaluate the completeness and consistency of contact information in Salesforce. Their sales reps often have incomplete information about their accounts and contacts. Additionally, they are not able to interpret the information in a consistent manner. Get Cloudy Consulting has identified certain ““key”” fields which are important to their sales reps.
What are two actions Get Cloudy Consulting can take to review their data for completeness and consistency?
(Choose two.)
A. Run a report which shows the last time the key fields were updated.
B. Run one report per key field, grouped by that field, to understand its data variability.
C. Run a report that shows the percentage of blanks for the important fields.
D. Run a process that can fill in default values for blank fields.
Answer: A, C
Universal Containers (UC) is facing data quality issues where Sales Reps are creating duplicate customer accounts, contacts, and leads. UC wants to fix this issue immediately by prompting users about a record that possibly exists in Salesforce. UC wants a report regarding duplicate records. What would be the recommended approach to help UC start immediately?
A. Create an after insert and update trigger on the account, contact and lead, and send an error if a duplicate is found using a custom matching criteria.
B. Create a duplicate rule for account, lead, and contact, use standard matching rules for these objects, and set the action to report and alert for both creates and edits.
C. Create a duplicate rule for account, lead, and contact, use standard matching rules for these objects, and set the action to block for both creates and edits.
D. Create a before insert and update trigger on account, contact, and lead, and send an error if a duplicate is found using a custom matching criteria.
Answer: B
Universal Containers (UC) wants to ensure their data on 100,000 Accounts pertaining mostly to US based companies is enriched and cleansed on an ongoing basis. UC is looking for a solution that allows easy monitoring of key data quality metrics. What should be the recommended solution to meet this requirement?
A. Use a declarative approach by installing and configuring Data.com Clean to monitor Account data quality.
B. Implement Batch Apex that calls out a third-party data quality API in order to monitor Account data quality.
C. Use declarative approach by installing and configuring Data.com Prospector to monitor Account data quality.
D. Implement an Apex Trigger on Account that queries a third-party data quality API to monitor Account data quality.
Answer: A
Universal Containers (UC) has a requirement to create an Account plan object that is related to the Account object. Each Account plan needs to have an Account object, but the accessibility requirement of the Account plan is different from the Account object. What should an Architect recommend?
A. Create a custom account plan object as detail with Account as mater in a master-detail relationship.
B. Create a custom account plan object as detail with Account as master with additional sharing rules to allow access.
C. Create an account plan object with a lookup relations to Account without any validation rules to enforce the Account association.
D. Create an account plan object with a lookup relationship to Account with validation rules to enforce the Account association.
Answer: D
Universal Containers (UC) is using Salesforce Sales & Service Cloud for B2C sales and customer service but they are experiencing a lot of duplicate customers in the system. Which are two recommended approaches for UC to avoid duplicate data and increase the level of data quality?
Pick 2
A. Use Duplicate Management.
B. Use an Enterprise Service Bus.
C. Use Data.com Clean
D. Use a data wharehouse.
Answer: A, C
Universal Containers (UC) has several custom Visualforce applications have been developed in which users are able to edit Opportunity records. UC struggles with data completeness on their Opportunity records and has decided to make certain fields required that have not been in the past. The newly required fields are dependent on the Stage of the Opportunity, such that certain fields are only required once an Opportunity advances to later stages. There are two fields. What is the simplest approach to handle this new requirement?
A. Update the Opportunity page layout to mark these fields as required.
B. Use a validation rule for each field that takes the Stage into consideration.
C. Update these Opportunity field definitions in Setup to be required.
D. Write an Apex trigger that checks each field when records are saved.
Answer: B
A Customer is migrating 10 million order and 30 million order lines into Salesforce using Bulk API. The Engineer is experiencing time-out errors or long delays querying parents order IDs in Salesforce before importing related order line items. What is the recommended solution?
A. Query only indexed ID field values on the imported order to import related order lines.
B. Leverage an External ID from source system orders to import related order lines.
C. Leverage Batch Apex to update order ID on related order lines after import.
D. Leverage a sequence of numbers on the imported orders to import related order lines.
Answer: B
Universal Containers would like to remove data silos and connect their legacy CRM together with their ERP and with Salesforce. Most of their sales team has already migrated to Salesforce for daily use, although a few users are still on the old CRM until some functionality they require is completed. Which two techniques should be used for smooth interoperability now and in the future.
Pick 2
A. Replicate ongoing changes in the legacy CRM to Salesforce to facilitate a smooth transition when the legacy CRM is eventually retired.
B. Specify the legacy CRM as the system of record during transition until it is removed from operation and fully replaced by Salesforce.
C. Work with stakeholders to establish a Master Data Management plan for the system of record for specific objects, records, and fields.
D. Do not connect Salesforce and the legacy CRM to each other during this transition period, but do allow both to interact with the ERP.
Answer: B, C
UC is trying to switch from legacy CRM to salesforce and wants to keep legacy CRM and salesforce in place till all the functionality is deployed in salesforce. The want to keep data in synch b/w Salesforce, legacy CRM and SAP. What is the recommendation.
Pick 2
A. Integrate legacy CRM to salesforce and keep data in synch till new functionality is in place
B. Do not integrate legacy CRM to Salesforce, but integrate salesforce to SAP
C. Integrate SAP with Salesforce, SAP to legacy CRM but not legacy CRM to Salesforce
D. Suggest MDM solution and link MDM to salesforce and SAP
Answer: C, D
Universal Containers (UC) has an Application custom object, which has tens of millions of records created in the past 5 years. UC needs the last 5 years of data to exist in Salesforce at all times for reporting and queries. UC is currently encountering performance issues when reporting and running queries on this Object using date ranges as filters. Which two options can be used to improve report performance?
(2)
A. Ask support to create a skinny table for Application with the necessary reporting fields.
B. Add custom indexes to all fields on Application without a standard index.
C. Run multiple reports to get different pieces of the data and combine them.
D. Add custom indexes to the Date fields used for filtering the report.
Answer: A, D
Universal Containers (UC) is expecting to have nearly 5 million shipments records in its Salesforce org. Each shipment record has up to 10 child shipment item records. The Shipment custom object has an Organization-wide Default (OWD) sharing model set to Private and the Shipment Item custom object has a Master-Detail relationship to Shipment. There are 25 sharing rules set on the Shipment custom object, which allow shipment records to be shared to each of UC’s 25 business areas around the globe. These sharing rules use public groups, one for each business area plus a number of groups for management and support roles. UC has a high turnover of Sales Reps and often needs to move Sales Reps between business areas in order to meet local demand. What feature would ensure that performance, when moving Sales Reps between regions, remains adequate while meeting existing requirements?
A. Implement data archiving for old Shipment records.
B. Contact Salesforce to create Skinny tables on Shipment.
C. Configure shipment OWD to Public Read/Write.
D. Contact Salesforce to enable Defer Sharing Rules
Answer: D
A customer is facing locking issued when importing large data volumes of order records that are children in a master-detail relationship with the Account object. What is the recommended way to avoid locking issues during import?
A. Import Account records first followed by order records after sorting order by OrderID.
B. Import Account records first followed by order records after sorting orders by AccountID.
C. Change the relationship to Lookup and update the relationship to master-detail after import.
D. Import Order records and Account records separately and populate AccountID in orders using batch Apex.
Answer: B
Universal Containers wants to develop a dashboard in Salesforce that will allow Sales Managers to do data exploration using their mobile device (i.e., drill down into sales-related data) and have the
possibility of adding ad-hoc filters while on the move. What is a recommended solution for building data exploration dashboards in Salesforce?
A. Create a Dashboard in an external reporting tool, export data to the tool, and add link to the dashboard in Salesforce.
B. Create a Dashboard in an external reporting tool, export data to the tool, and embed the dashboard in Salesforce using the Canval toolkit.
C. Create a standard Salesforce Dashboard and connect it to reports with the appropriate filters.
D. Create a Dashboard using Analytics Cloud that will allow the user to create ad-hoc lenses and drill down.
Answer: D
DreamHouse Realty has a legacy system that captures Branch Offices and Transactions. DreamHouse Realty has 15 Branch Offices. Transactions can relate to any Branch Office. DreamHouse Realty has created hundreds of thousands of Transactions per year.
A Data Architect needs to denormalize this data model into a single Transaction object with a Branch Office picklist.
What are two important considerations for the Data Architect in this scenario?
(Choose two.)
A. Standard list view in-line editing.
B. Limitations on Org data storage.
C. Bulk API limitations on picklist fields.
D. Limitations on master-detail relationships.
Answer: B,C
Cloud Kicks is launching a Partner Community, which will allow users to register shipment requests that are then processed by Cloud Kicks employees. Shipment requests contain header information, and then a list of no more than 5 items being shipped.
First, Cloud Kicks will introduce its community to 6,000 customers in North America, and then to 24,000 customers worldwide within the next two years. Cloud Kicks expects 12 shipment requests per week per customer, on average, and wants customers to be able to view up to three years of shipment requests and use Salesforce reports.
What is the recommended solution for the Cloud Kicks Data Architect to address the requirements?
A. Create an external custom object to track shipment requests and a child external object to track shipment items. External objects are stored off-platform in Heroku’s Postgres database.
B. Create an external custom object to track shipment requests with five lookup custom fields for each item being shipped. External objects are stored off-platform in Heroku’s Postgres database.
C. Create a custom object to track shipment requests and a child custom object to track shipment items. Implement an archiving process that moves data off-platform after three years.
D. Create a custom object to track shipment requests with five lookup custom fields for each item being shipped Implement an archiving process that moves data off-platform after three years.
Answer: C
