Given a Scenario, Describe Data Modeling Concepts and Implications of Database Design and Modeling. TECHNICAL-ARCHITECT Practice Questions (Page 1)

Questions 1–5

1. 1application · medium

   A sales organization wants to report on the total value of all Opportunities related to each Account. They currently have a custom field 'Total Opportunity Value' on Account that is manually updated. They want to automate this and ensure it is always accurate. What should they do?

   • AUse a workflow rule to update the Account field whenever an Opportunity is created or edited.
   • BUse a formula field on Account that references the Opportunity Amount.
   • CUse a process builder to sum all Opportunities and update the Account field.
   • DUse a roll-up summary field on Account that sums the Amount of related Opportunities.
   Reveal Solution Discussion Select an answer first
2. 2foundation · easy

   What is the purpose of an external ID field in Salesforce integration?

   • ATo store a formula that calculates a value from other fields
   • BTo create a relationship between two Salesforce objects
   • CTo store a unique identifier from an external system for upsert operations
   • DTo encrypt data at rest in Salesforce
   Reveal Solution Discussion Select an answer first
4. 3foundation · easy

   Why is it considered a best practice to use standard objects instead of creating custom objects when possible?

   • AStandard objects are always faster than custom objects
   • BStandard objects cannot be customized, so they are simpler
   • CCustom objects are not supported in Salesforce
   • DStandard objects come with built-in functionality, relationships, and reporting that reduce custom development
   Reveal Solution Discussion Select an answer first
5. 4application · medium

   A company wants to track the industry of their customers. They currently use the standard Account object. They are considering creating a custom object 'Industry' and a lookup from Account to Industry. What is the best practice?

   • ACreate the custom object 'Industry' and a lookup from Account to Industry.
   • BUse the standard Industry field on Account instead of creating a custom object.
   • CUse a formula field on Account to derive the industry from other fields.
   • DCreate a custom field on Account to store the industry as text.
   Reveal Solution Discussion Select an answer first
6. 5expert · hard

   A company has a custom object 'Project' with a master-detail relationship to Account. They want to allow users in the 'Project Viewer' role to view all Project records, but not edit them. The OWD for Project is Private. What should they do?

   • ACreate a sharing rule that grants Read Only access to Project records for the 'Project Viewer' role.
   • BUse field-level security to hide the edit button for the 'Project Viewer' role.
   • CChange the OWD for Project to Public Read Only.
   • DCreate a permission set that grants Read Only access to the Project object for the 'Project Viewer' role.
   Reveal Solution Discussion Select an answer first