Data Modeling Flashcards
“Cosmic Cosmetics would like to use an AppExchange application for financial management. The company has 50 million invoice records that are currently stored in an internal database. Five million new invoice records are likely to be generated every month in the future. The AppExchange application will be used to manage these records in Salesforce. Which of the following is an important consideration with regard to its impact on Salesforce performance?↵Choose 1 answer.”
A. The custom object used for invoice records should be indexed.
B. Data Loader should be used to insert existing invoice records on a regular basis.
C. A big object would be essential for storing invoice records in Salesforce.
D. A data archiving strategy should be used to remove old records from Salesforce.
D
“Cosmic Supermarket uses an ERP system to store information about products and invoices. The sales and support users of the company also use Salesforce to create and update product information. Although both systems contain the same products, the names and descriptions entered in the two systems are often different. The product data from the systems are pushed to a data warehouse used for reference and reporting. Customers often complain about inaccurate or incomplete product names and descriptions on quotes and invoices that are generated based on the data stored in the data warehouse. The company would like to prevent this data inconsistency. What should a data architect recommend?↵Choose 1 answer.”
A. Use custom fields in Salesforce to store product data retrieved from the ERP system.
B. Create an Apex trigger to ensure that correct names and descriptions are entered.
C. Use a third-party AppExchange application to validate product data in quotes and invoices.
D. Define a data taxonomy for the products created and updated in the two systems.
D
“Cosmic Circle Goods uses a Salesforce org with two custom objects called ‘Sold Product’ and ‘Product Part’. The ‘Sold Product’ object stores information about each product sold to a customer and is related to the ‘Account’ object through a master-detail relationship. The ‘Product Part’ object stores information about the details of each part associated with a particular product, such as the name of the part and the cost of producing the part. The ‘Product Part’ object is the child of the ‘Sold Product’ object in a master-detail relationship. The sales director of the company would like to view the total cost of producing all the products that are sold to a customer on the customer’s account record. What solution should a Data Architect recommend for this requirement?↵Choose 1 answer.”
A. Create a flow to calculate the total cost, and add a button to the Account detail page to allow users to trigger the flow.
B. Create an Apex trigger on the Account object to calculate the total cost.
C. Create one roll-up summary field on the ‘Account’ object and another one on the ‘Sold Product’ object to calculate the total cost.
D. Create one roll-up summary field on the ‘Account’ object to calculate the total cost.
C
“Cosmic Tools stores sales orders in an external system. There are 20 million sales orders, and the company receives one million new sales orders every month. The sales director has asked the system administrator of the company to display all the related sales orders on each customer’s account record. Which solution should a data architect recommend for this requirement?↵Choose 1 answer.”
A. Use Salesforce Connect to define an external object, and create a lookup relationship field on the object.
B. Use Data Loader to import sales orders into a custom object, and create a lookup relationship field on the object.
C. Use Apex and Visualforce to design a custom integration that displays sales orders on each account record.
D. Use an AppExchange application to retrieve and display related sales orders on each account record.
A
“Tim is a Sales Development Representative at Eco Phones, a company that recycles phones. Tim’s user is set as the default Lead owner for any lead created by the Web-to-Lead form on Eco Phones’ website. Due to the popularity of recycling phones, Tim has more than 10,000 leads assigned to his user and he manually assigns these leads to his qualified colleagues. Tim’s user is subjected to ownership data skew and whenever a lead is deleted or updated, it takes a while for sharing to be recalculated. In the current Eco Phones’ role hierarchy, Tim reports to his manager who is in the Sales EMEA role, and Tim has 3 subordinates in the SDR Assistant role. For reporting purposes, Tim’s user needs to have a role assigned, but there are no extra licenses available to create a dummy user to own the Web-to-Lead leads. What can a Salesforce Architect do to minimize the impact of the ownership skew?↵Choose 1 answer.”
A. Delete an old lead when new lead comes in to stay below the 10,000 threshold
B. Put Tim in a top-level role of the hierarchy separated from other roles
C. Set Sharing settings for the Lead object to Private to avoid sharing calculations
D. Ask Salesforce to create a skinny table for the Leads object
B
“Cosmic Catfood is a thriving business that specializes in online gourmet cat food, with a 24-hour delivery guarantee. Their business is growing at more than 10% a year. Customers can make a one-off order or can subscribe to a weekly delivery of cat food. Cosmic Catfood has been using Salesforce as their CRM for 5 years, and it also houses all their order records, as well as all records of all customers who’ve ever made an order, even if this was more than 4 years ago. The company has realized that due to their growth, some adjustments need to be made with the large volume of records that Salesforce contains, as some queries run slowly. Some consulting assistance is required, and the company advised that they wish to retain all data within Salesforce. What advice could the company be given to meet this requirement?↵Choose 1 answer.”
A. Move data from the objects that are now very large to custom big objects, and configure so that all data remains accessible.
B. Move data from the objects that are now very large to the standard big object FieldHistoryArchive, and configure so that all data remains accessible.
C. Move data from the objects that are now very large to internal virtualized sObjects, and configure so that all data remains accessible.
D. Move data from the objects that are now very large to external objects, and configure so that all data remains accessible.
A
“Which of the following statements are correct in the consideration of using SOQL to query a big object?↵Choose 2 answers.”
A. The SOQL query must include all the big object’s index fields.
B. The SOQL query can list the big object’s index query fields in any order.
C. EXCLUDES and INCLUDES operators are not permitted big object SOQL operators.
D. A SOQL query filter must list the big object’s index fields in index field order
C & D
“Roxanne is a data architect hired by Cosmic Tools to evaluate and recommend solutions for the Salesforce org used by the company. A custom object named ‘Account Award’ has been created to store awards related to accounts. A lookup relationship field has also been defined on the Account object, which looks up to the ‘Account Award’ object. Each account reward contains detailed information about the award via several custom fields. There are 30 account awards and almost 500,000 account records in Salesforce. The administrator of the company recently tried to update the value of the lookup relationship field on all the account records using Bulk API but encountered record locking errors. Which of the following actions should be recommended by the data architect to mitigate the issue that is causing the errors?↵Choose 3 answers.”
A. Use asynchronous processing for any Apex code that’s not required immediately.
B. Mark the lookup relationship field on the Account object as required.
C. Identify skewed records and add additional lookup values for skew distribution.
D. Create a multi-select picklist field on the Account object to store the account rewards.
E. Remove any unnecessary workflow rules and trigger logic.
A, C, & E
“Cosmic Enterprises would like to have two custom objects called ‘Policy’ and ‘Documentation’. A policy or documentation record can be related to multiple account records. Each account must have a policy and a documentation specified on it, and it should not be possible to delete the parent policy or documentation record when it is related to at least one account record. Also, the owner of an account record can be different from the owner of a policy or documentation. In order to meet this requirement by relating the Account object to the two custom objects, which type of relationship can be utilized?↵Choose 1 answer.”
A. Required Lookup Relationship
B. Optional Lookup Relationship
C. Indirect Lookup Relationship
D. Master-Detail Relationship
A
“Cosmic Gardening is a garden center that uses Sales Cloud to manage customer data. When a new customer buys a product, they are added in Salesforce as a new account. In order to keep track of seasonal sales data, a custom object called ‘Season’ has been created. It stores four records, each containing the name of one of the four seasons only. For each new account, a sales representative needs to select the current season in the ‘Season’ field, which is a lookup relationship field to the ‘Season’ object. On several occasions, Salesforce users have complained about records being locked when they try to edit them. What action can the company’s Salesforce architect take to eliminate the issue?↵Choose 1 answer.”
A. Apply a filter to the ‘Season’ field on the Account object.
B. Create a custom text area field that requires sales representatives to type the season.
C. Change the sharing settings of the ‘Season’ object.
D. Create a custom picklist field with the four seasons as values.
D
“Cosmic Manufacturing Solutions uses multiple enterprise systems, such as Salesforce, product lifecycle management (PLM) system, supply chain management (SCM) system, and enterprise resource planning (ERP) system. The IT department of the company is required to document the data architecture of these systems and the inter-relationships among them in order to plan for future implementations. Which of the following artifacts can be used for this requirement?↵Choose 2 answers.”
A. Integration Design Document
B. Solution Design Document
C. Data Model
D. Data Definition Language
A & C
“Cosmic Picture Framers have a large customer database, stored in Salesforce, going back many years. They would now like to archive customer information where a customer’s last interaction with them was more than 5 years ago. The use of big objects has been suggested due to the volume of records, but there may be some further decisions required if this approach is to be implemented. Which of the following statements is correct in terms of what the company needs to consider?↵Choose 1 answer.”
A. Record values in URL field types from the original records will need to be inserted as text fields in a big object.
B. The big object standard field Name is required, so whatever field is identified for mapping from the source data, all records must have a value.
C. Record values in picklist field types from the original records will need to be inserted as text fields in a big object.
D. Encrypted text fields are supported, and can be directly mapped to the equivalent big object encrypted text field.
C
“Cosmic Solutions would like to use Salesforce to manage sales orders. Sales users of the company should be able to specify the status of each sales order. The status can be one of twelve possible values, such as ‘Pending’, ‘Awaiting Payment’, ‘Awaiting Fulfillment’, and ‘Shipped’. Which of the following can be utilized for this use case in order to ensure high data quality?↵Choose 1 answer.”
A. Master-Detail Relationship Field
B. Multi-Select Picklist Field
C. Custom Object
D. Picklist Field
D
“Which of the following statements are correct in considering the creation of a new big object and the construction of its index, where the new big object is based on an existing custom object that already exists inside Salesforce?↵Choose 2 answers.”
A. The maximum length of a big object index, which includes all the index fields, is 100 characters.
B. The maximum length of a big object index, which includes all the index fields, is 150 characters.
C. The maximum number of fields used in the index is 5.
D. Any big object index field must be marked as unique to be used in the index.
A & C
“Cosmic Enterprises uses the ‘Discount’ object to store various discounts provided to customers. For any future discounts, the sales director would like to see the sum of all the discounts provided to each customer on the customer’s account record. Which relationship field can be created on the ‘Discount’ object to the ‘Account’ object to assist in meeting this requirement?↵Choose 1 answer.”
A. Hierarchical Relationship
B. Indirect Lookup Relationship
C. Master-Detail Relationship
D. Lookup Relationship
C
“Which of the following statements with respect to inserting data into a big object data is correct?↵Choose 2 answers.”
A. The big object standard record display page can be used to insert data into the big object.
B. Salesforce Connect functionality can be used to insert data into the big object.
C. Data Loader can be used to insert data into the big object.
D. The insertImmediate Apex method can be used to insert data into the big object.
C & D
“Cosmic Persona is a startup company that sells household goods in large quantities to other companies in the United States. The Account object in Salesforce is used to store information about other companies. The company would like to start selling goods to individual consumers and store the related information in Salesforce. What should a Data Architect recommend for this requirement?↵Choose 1 answer.”
A. Use Person Accounts to store information about individual consumers.
B. Create a new record type on the Account object for individual consumers.
C. Define a new custom object to store information about individual consumers.
D. Define a new custom field on the Account object to indicate whether a customer is an individual.
A
“The sales users of Cosmic Enterprises attach various kinds of documents to account records in Salesforce. The sales director of the company would like to allow users to specify details related to the attachment using certain custom fields. What should an architect recommend for this requirement?↵Choose 1 answer.”
A. Create custom fields in the Account object to store information about related attachments.
B. Use the standard Attachment object and create custom fields in it.
C. Create a Visualforce page that allows storing details about related attachments.
D. Add custom fields to the Files or ContentVersion object to track the additional information
D
“Cosmic Freight Solutions creates thousands of new contacts every year that need to be assigned to a generic account because of business rules. The data architect needs to ensure that assigning a large number of contacts to a single account won’t cause performance issues. What solutions should the data architect consider for this use case?↵Choose 2 answers.”
A. Use person accounts instead of business accounts to relate the contacts.
B. Create round-robin logic to ensure that new contacts are not automatically assigned to the same account.
C. Create multiple generic accounts so that no single account has more than 10,000 contacts related to it.
D. Create multiple generic accounts so that no single account has more than 1,000 contacts related to it.
B & C
“Cosmic Enterprises would like to store information about documents that are sent to customers. The Salesforce Architect of the company has suggested the creation of a custom object called ‘Customer Documentation’ for this requirement. The Sales Director would like to ensure that a sales user specifies the name of the account while creating a customer documentation record. A customer documentation record can be owned by a user other than the owner of the parent account record. Which type of relationship can be created between the Account object and the Customer Documentation object for this requirement?↵Choose 1 answer.”
A. Hierarchical Relationship
B. Self Relationship
C. Master-Detail Relationship
D. Required Lookup Relationship
D
“Cosmic Repair Services would like to store information about repair jobs and repair sites. There are almost 300 repair sites in different states throughout the country. The company is currently using an internal database to store information about repairs conducted at these repair sites. The repair sites are fixed company locations where repairs are performed by technicians. More than a million new repair jobs are created every month. Other than the name of the repair site and the state where it is located, no other information about a repair site needs to be stored for a particular repair job. Which of the following should be used to store the information in Salesforce?↵Choose 1 answer.”
A. A custom object with a multi-select picklist field
B. A custom object with a picklist field
C. A custom object with dependent and controlling picklist fields
D. Two custom objects and a master-detail relationship field
C
“The IT manager of Cosmic Solutions would like to build a data dictionary that defines how different data entities are stored in various enterprise systems including Salesforce. The data dictionary should cover all the main applications and business domains used within the company. Which of the following can be utilized for building a data dictionary that includes the data entities in Salesforce?↵Choose 2 answers.”
A. SOAP API
B. Metadata API
C. Entity Relationship Diagram
D. SOQL
B & C
“Cosmic Repair Solutions has grown its global customer base from a few thousand to more than a million customers over the last few years. The ‘Account’ object is used to store information about customers in Salesforce. The org used to work perfectly until the number of account records reached one million. As a result, batch jobs and triggers, especially those with complex queries based on the Account object, are now failing. Which of the following measures can be taken for resolution?↵Choose 2 answers.”
A. Minimize the number of objects that are related to Account by deleting look-up and master-detail relationship fields.
B. Identify query filters that use non-indexed custom fields and request custom indexing from Salesforce Support.
C. Bulkify Apex triggers and batch jobs to improve query performance.
D. Ensure queries are using indexed fields in their filter conditions.
B & D
“The administrator of Cosmic Innovation has created a master-detail relationship between two custom objects called ‘Sales Order’ and ‘Shipment’. Each sales order can have multiple Shipment records associated with it. The company has recently started shipping items to other businesses, but the related shipments are not associated with any particular sales order. As a result, the sales director would like to allow users to create shipment records without specifying a sales order. What should a solution architect recommend for this use case?↵Choose 1 answer.”
A. Convert the master-detail relationship to an optional lookup relationship.
B. Make the master-detail relationship field optional by editing the field on the ‘Shipment’ object.
C. Create another custom object to store shipment records for businesses.
D. Delete the master-detail relationship field to allow the creation of unrelated records.
A