Database Management & SQL Flashcards

In HubSpot, what does the 'Association Label' feature allow administrators to define?

Answer: Custom relationship types between associated records

Association Labels let admins define named relationship types (e.g., 'Decision Maker') between associated CRM records.

When importing contacts into HubSpot, which field is used as the default unique identifier to prevent duplicate records?

Answer: Email address

HubSpot uses email address as the primary unique identifier for contact records during imports and deduplication.

What is the maximum number of custom properties an administrator can create per object in HubSpot (Enterprise tier)?

Answer: 10,000

HubSpot Enterprise allows up to 10,000 custom properties per CRM object.

Which HubSpot feature allows admins to enforce that a property value must be set before a deal can move to a specific pipeline stage?

Answer: Required properties on deal stage

The 'Required properties on deal stage' feature blocks stage advancement until specified fields are populated.

In HubSpot's data model, which object type supports 'Line Items' as associated records?

Answer: Deals

Line Items are associated with Deal records to itemize products and pricing within a deal.

When using HubSpot's native SQL-like reporting query tool (Data Sets), what does a LEFT JOIN return?

Answer: All records from the left dataset plus matching records from the right

A LEFT JOIN returns all rows from the left (primary) dataset and matching rows from the right, with NULLs where no match exists.

Which HubSpot property type should an administrator use to store a date without a time component?

Answer: Date picker

The 'Date picker' property type stores only a date value (no time), suitable for birthdays or contract dates.