Manage the Data Model PL-200 Practice Questions (Page 5)

Questions 21–25

1. 21foundation · medium

   Which of the following is a valid use case for a formula column?

   • ACalculating the total sales amount from all related opportunities
   • BCombining a first name and last name into a full name
   • CDisplaying data from an external SQL database
   • DStoring a user-entered phone number
   Reveal Solution Discussion Select an answer first
2. 22application · medium

   A nonprofit organization tracks volunteers and the events they assist with. A volunteer can help at many events, and each event can have many volunteers. The organization also needs to record, for each volunteer-event pairing, the specific role the volunteer performed (e.g., registration, cleanup). Which data modeling approach should you recommend?

   • ACreate two separate many-to-many relationships: one between Volunteer and Event, and another between Volunteer and Role.
   • BCreate a custom intersection table named VolunteerEvent with lookup columns to Volunteer and Event, plus a Role column, and configure a many-to-many relationship using that table.
   • CCreate a one-to-many relationship from Event to Volunteer and store Role on the Volunteer table.
   • DCreate a many-to-many relationship between Volunteer and Event, and add a Role column to the Volunteer table.
   Reveal Solution Discussion Select an answer first
4. 23application · medium

   A sales organization has an Opportunity table and a custom Invoice table. Each opportunity can have multiple invoices. The sales team wants to see, on the Opportunity form, the total value of all invoices associated with that opportunity. The total must update automatically as invoices are added or changed. What should you create?

   • AA rollup column on the Opportunity table that sums the Invoice Amount column from related Invoice records.
   • BA workflow that updates a total column on the Opportunity whenever an invoice is created or changed.
   • CA calculated column on the Invoice table that sums the Invoice Amount column for the related opportunity.
   • DA formula column on the Opportunity table that sums the Invoice Amount column from related Invoice records.
   Reveal Solution Discussion Select an answer first
5. 24application · medium

   A company uses the standard Activity table to track customer service calls. They need to add a custom column to capture the call duration in minutes. The column should appear on the Activity form and be available in views. What should you do?

   • AAdd a new column to the Activity table and include it on the Activity form and views.
   • BUse the existing Subject column to store the duration as text.
   • CCreate a new custom activity table named Service Call and add the Duration column to it.
   • DCreate a separate custom table for call durations and relate it to the Activity table.
   Reveal Solution Discussion Select an answer first
6. 25application · medium

   A company stores Product records with Unit Price and Quantity On Hand columns. They want a new column that calculates the inventory value (Unit Price × Quantity On Hand) for each product. The value should always be current and should not require any manual update. What should you do?

   • ACreate a whole number column and use a Power Automate flow to update it after each save.
   • BCreate a rollup column that multiplies Unit Price by Quantity On Hand.
   • CCreate a calculated column using a workflow that runs when the record is saved.
   • DCreate a formula column of type Currency that multiplies Unit Price by Quantity On Hand.
   Reveal Solution Discussion Select an answer first