DA3 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.
B. Create a required Lookup relationship to each of the three parent records.
When creating a new custom lookup field or modifying an existing one, there’s a section called ‘What to do if the lookup record is deleted?’ with a few radio buttons as follows:
- Clear the value of this field (this option is unavailable if the field is required)
- Don’t allow deletion of the lookup record that’s part of a lookup relationship
- Delete this record
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.
C. Enable “Set Audit Fields” and assign the permission to the user loading the data for the duration of the migration.
Data Loader allows you to specify in audit fields when you insert or import new records from a different org or other external data source. The audit fields are: Created By, Created Date, Last Modified By ID, Last Modified Date.
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 translation workbench.
B. Create a trigger on Contact and add an error to the record with a custom label.
D. Create a validation rule and translate the error message with translation workbench.
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.
C. Custom metadata records are deployable using packages.
Main difference between custom metadata and custom setting is that custom metadata records are deployable and packagable.
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.
D. Create a custom object related to the Invoice object with a picklist field for the Type.
The Attachment standard object does not support custom fields. Creating a new custom object is the only viable option.
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.
C. Bulk API limitations on picklist fields.
D. Standard list view in-line editing.
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.
B. Work with Salesforce Support to enable Skinny Tables.
D. Make the queries more selective using indexed fields.
- So one way of improving performance is using skinny tables. It stores the frequently used fields and avoids joins. Skinny tables are in sync with their source tables when the source tables are modified.*
- Use Skinny table if performance is not good enough even after using custom indexes.*
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 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.
A. Create a picklist field, values sorted alphabetically.
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 email to the admin.
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.
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 permission from the Contact object.
D. Create a validation rule on the Contact object to check if the current user is not the owner.
A. Create a “before delete” trigger to check if the current user is not the owner.
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.
B. Create an external object Invoice_x with a Lookup relationship with Opportunity.
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.
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.
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 2 answers
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.
B. Use Salesforce duplicate management.
C. Use validation rules on new record create and edit.
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.
B. Clean data before importing to Salesforce.
C. Use Salesforce matching and duplicate rules.
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.
C. Enable Account de-duplication by creating matching rules in Salesforce, which will mass merge duplicate Accounts.
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 2 answers
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.
C. Utilize a Validation Rule with a REGEX operator on Postal Code.
D. Utilize a Validation Rule with a CONTAINS operator on address fields.
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.
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.
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.
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.
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.
C. Utilize an app from the AppExchange to create data-quality dashboards.
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 answers
A. Acquire an AppExchange Lead deduplication application.
B. Implement Salesforce Matching and Duplicate Rules.
C. Run the Salesforce Lead Mass deduplication tool.
D. Create a Workflow Rule to check for duplicate records.
A. Acquire an AppExchange Lead deduplication application.
B. Implement Salesforce Matching and Duplicate Rules.
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.
A. Set up a Validation Rule to prevent blank values.
C. Mark the field required in setup at the field level.
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 the 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.
B. Implement a workflow rule that sends Opportunity data through Outbound Messaging.
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.
C. Implement a Master Data Management strategy to reconcile Leads, Accounts, and Contacts.
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.
C. Whether the system of record changes for different tables.
D. The number of systems that are integrating with each other.
