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
“Cosmic Solutions is implementing a new program and needs to associate records of a custom object called ‘Equipment’ as children to generic accounts based on geographic area. Each geographic area is expected to have 12,000 - 70,000 equipment records related to it. What options should the data architect consider when defining the data model to reduce performance and sharing issues?↵Choose 3 answers.”
A. Set the organization-wide default sharing setting of the Equipment object to ‘Controlled by Parent’.
B. Disable search capabilities on the Equipment object.
C. Establish multiple generic accounts so that each account has fewer than 10,000 related Equipment records.
D. Use a ‘Public Read/Write’ sharing model for Account and Equipment.
E. Use a ‘Private’ sharing model for Account and Equipment and open up visibility via criteria-based sharing rules.
A, C & D
“Cosmic Harvest is a company that manufactures and sells products such as olive oil and various kinds of protein. Products are sold to individual consumers as well as local farmers. The company uses a custom object called ‘Health Product’ in Salesforce to store information about more than 100 different types of products. The director of the company would like to allow Salesforce users to relate two health products together since one product can be manufactured from another. For example, a collagen supplement should be related to a poultry product like organic chicken since the latter is used to manufacture the former. Which solution should a Data Architect recommend for this requirement?↵Choose 1 answer.”
A. Create a lookup relationship field on the ‘Health Product’ object to form a self-relationship with the object.
B. Create a master-detail relationship field on the ‘Health Product’ object to form a self-relationship with the object.
C. Create a validation rule on the ‘Health Product’ object to ensure that the name of a related health product is specified in a custom text field.
D. Define a formula field on the ‘Health Product’ object to automatically populate the related health product.
A
“Cosmic Repair Solutions has dozens of repair centers in the United States. The company uses Salesforce to store millions of ‘Repair Job’ records; each record is related to a repair request from a particular customer. The service agents receive thousands of requests every day. The service operations director of the company has asked the administrator to allow users to specify the status of a repair job at any time. What solution should an architect recommend to make it easy for users to specify the status and ensure data consistency?↵Choose 1 answer.”
A. Create a custom multi-select picklist field on the ‘Repair Job’ object to allow tracking status.
B. Create a custom text field on the ‘Repair Job’ object to allow users to specify status.
C. Create a custom object related to the ‘Repair Job’ object to allow creating status records.
D. Create a custom picklist field on the ‘Repair Job’ object to allow tracking status.
D
“Cosmic Electronics would like to copy Opportunity records to an on-premise ERP system once they reach the ‘Closed Won’ Stage in Salesforce. As the company has limited development resources, one of its system administrators should be able to configure and maintain the data transfer setup without using code. Which native solution can be utilized for this requirement?↵Choose 1 answer.”
A. Create an Apex trigger that sends an outbound message whenever the Stage field of an opportunity is set to ‘Closed Won’.
B. Create a process using Process Builder that sends an outbound message whenever the Stage field of an opportunity is set to ‘Closed Won’.
C. Configure a workflow rule that sends an outbound message whenever the Stage field of an opportunity is set to ‘Closed Won’.
D. Configure a flow that sends an outbound message whenever the Stage field of an opportunity is set to ‘Closed Won’.
C
“Cosmic Harvest is a company that would like to design a scalable data model that can accommodate a large number of account records. The company has more than five million accounts and nine million related contacts that will be imported into Salesforce. There are several accounts with more than 10,000 related contacts. Based on this information alone, which of the following is an important consideration for designing the data model?↵Choose 2 answers.”
A. Account data skew will negatively affect performance and cause record locking.
B. Relationship skew will cause lock exceptions that will cause failures while trying to insert contact records.
C. Ownership skew will cause performance issues due to sharing calculations.
D. Contacts related to a particular account can be distributed across multiple accounts.
A & D
“Cosmic Circle Goods has a custom object called ‘Repair Request’ which is used to store all the requests from customers related to the repair of goods sold by the company. This object is related to the ‘Account’ object through a master-detail relationship field. Since the company has recently started receiving repair requests from individuals and businesses that are not customers, the sales director would like to allow users to create a repair request without specifying the name of the account. Which solution should a Solution Architect recommend for this requirement?↵Choose 1 answer.”
A. Create another custom object to store repair requests by people who are not customers.
B. Convert the master-detail relationship to a lookup relationship.
C. Convert the master-detail relationship to a hierarchical relationship.
D. Make the master-detail relationship field optional on the ‘Repair Request’ page layout.
B
“Cosmic Service Solutions will soon migrate millions of account records from its legacy CRM system to Salesforce. The sales director has asked the administrator to ensure that the migrated account records in Salesforce use the original ‘Created Date’ that is currently specified in the legacy system. Which user permission should the company’s Solution Architect recommend for this requirement?↵Choose 1 answer.”
A. Set Audit Fields upon Record Creation
B. Set System Fields upon Record Creation
C. Edit Audit Fields upon Record Creation
D. Edit System Fields upon Record Creation
A
“Cosmic Innovations is a company that sells smart home products. It uses a custom object called ‘Smart Solution’ in Salesforce to store data about smart home products sold by the company. The director of the company is interested in the implementation of a categorization approach for the products. A smart home product can be a ‘Device’, ‘System’ or ‘Gadget’. What should a Solution Architect recommend for this requirement?↵Choose 1 answer.”
A. Define a self-relationship using a lookup relationship field on the ‘Smart Solution’ object.
B. Define a new custom picklist field on the ‘Smart Solution’ object.
C. Create three new custom objects to store information about the types of smart home products.
D. Create a new custom object with a master-detail relationship field.
B
“Cosmic Innovation is a startup company that would like to store information about smart home solutions in Salesforce. These are products that go through the company’s product development lifecycle. However, a smart home solution may or may not be sold to customers. Each smart home solution should include fields such as status, type, specifications, description, installation procedure, etc. The ‘Product’ object will be used to store smart home solutions that reach the end of the development lifecycle and are approved for selling to customers. The smart home solutions that are sold to customers require a completely different set of fields and will be added to opportunities by the sales agents of the company. What should a data architect recommend to store and manage the smart home solutions that go through the product development lifecycle?↵Choose 1 answer.”
A. Create a new custom object to store the information.
B. Use the standard ‘Solution’ object to store the information.
C. Use an external object to store the information.
D. Use the standard ‘Product’ object to store the information.
A
“Cosmic Enterprises uses the Account object in Salesforce to store information about B2B and B2C customers. Sales orders are managed in an external system that supports REST API. Tens of thousands of account records are added to Salesforce every month. Information about the creation of a sales order is sent to the external system when an opportunity is won. The company generally receives more than 500,000 sales orders each month. The sales director of the company would like to make it possible for sales representatives to view sales orders when required in Salesforce. He would prefer not paying extra for storage capacity in Salesforce. What should an architect recommend for this requirement?↵Choose 1 answer.”
A. Create a custom object to store sales orders in Salesforce.
B. Create a big object to store sales orders in Salesforce.
C. Create an external object to allow ‘View’ access to sales orders.
D. Use a data warehouse to store existing and new sales orders.
C
“Cosmic Fitness Solutions has a custom object named ‘Equipment__c’ which is used to store information about various types of fitness equipment sold to specific customers. When a piece of particular fitness equipment is sold to a customer, it should appear on the customer’s account record in Salesforce. The owner of an account should be able to view and edit all the related equipment records. When a customer is inactive for a period of more than 5 years, their account record is deleted. This should also delete all the related equipment records. Which type of relationship can be utilized to meet this requirement?↵Choose 1 answer.”
A. Lookup Relationship
B. Master-Detail Relationship
C. Hierarchical Relationship
D. Self Relationship
B
“Cosmic Cosmetics currently uses the Account object for B2B customers. A custom page layout has been defined on the Account object. The company also sells its products to individual customers, but the related information is not stored in Salesforce. There are 10 million B2C records that are currently stored in an internal database, and this number is expected to increase by 10% every three months. The sales director of the company has decided to begin using Salesforce for this data. Which of the following represents an appropriate solution for this requirement?↵Choose 1 answer.”
A. Enable ‘Person Accounts’ and define a new page layout for B2C accounts.
B. Create a new record type to store B2C customers and use the page layout that is used for B2B accounts.
C. Create a new record type to store B2C customers and define a new page layout for B2C accounts.
D. Enable ‘Contacts to Multiple Accounts’ and use the page layout that is used for B2B accounts.
A
“Cosmic Electronics would like to use a production org of Salesforce to store only events that are conducted throughout the world in company offices and external venues. The internal database of the company contains more than one million internal and external events, and it is planning to conduct more than 1,000 new events every month. If it would like to use the Enterprise edition of Salesforce, which of the following is true about storing this information?↵Choose 1 answer.”
A. An archiving policy will need to be implemented to store the information.
B. Unlimited edition of Salesforce will be required to store the information.
C. Storage will not be an issue if there are no additional requirements.
D. The company will need to contact Salesforce support and add more storage.
C
“Cosmic HR Solutions is a human services agency that is considering an AppExchange application for managing service records. There are currently 50 million records of a custom object that is used for managing services provided to customers by the agency, most of which are archived and do not require additional updates. This number is expected to increase by 5% every month due to the expanding customer base. The CEO of the company is willing to pay for additional storage. What should an architect recommend to ensure scalability while choosing a suitable AppExchange application?↵Choose 1 answer.”
A. The application should make use of Big Objects.
B. The application should support the use of Heroku and External Objects.
C. The application should include reports and dashboards.
D. The application should include a custom setting for service records.
A
“The data architect of Cosmic Service Solutions has been asked to document the data architecture of the various enterprise systems used by the company. While documenting the Salesforce data architecture, which of the following metadata types can be utilized?↵Choose 3 answers.”
A. Flow
B. CustomObject
C. CustomField
D. RecordType
E. ApexTrigger
B, C, & D
“Cosmic Clothing is a large and growing clothing manufacturer. The company has been using Salesforce for many years, and has recently started to utilize big objects to archive records that are more than 2 years old. The company would now like to view some of the archived records in reports and dashboards. Which of the following statements is correct for how the Cosmic Clothing Salesforce team can work with a big object to achieve the company’s reporting requirements, as the team considers whether to use SOQL or Async SOQL?↵Choose 1 answer.”
A. Async SOQL allows the extraction of big object data into an sObject. Salesforce reports and dashboards can then be built on the sObject.
B. Salesforce reports and dashboards can be built using the big object directly, using SOQL.
C. Salesforce reports and dashboards can be built using the big object directly, using Async SOQL.
D. SOQL allows the extraction of big object data into the sObject. Salesforce reports and dashboards can then be built on the sObject.
A
“Cosmic Creations has an integration with an external system. To facilitate data transfer from the system, records are placed in a custom object named ‘Data Staging’. All records in this object are owned by the integration user, and the organization-wide default sharing setting of the object is set to ‘Public Read Only’. The integration processes 10,000 - 40,000 Data Staging records per day and performs frequent inserts and updates of the data. What implementation options should the data architect consider to reduce sharing recalculations?↵Choose 2 answers.”
A. Ensure that the integration has an API-only profile.
B. Place the integration user at the top of the role hierarchy.
C. Place the integration user at the bottom of the role hierarchy.
D. Do NOT assign a role to the integration user.
B & D
