HAC Database Management & SQL 2 — Questions and Answers
Question 1: In HubSpot, what does the 'Association Label' feature allow administrators to define?
- The display name for a property field
- Custom relationship types between associated records (Correct answer)
- The label shown on deal pipelines
- Naming conventions for contact lists
Correct answer: Custom relationship types between associated records
Association Labels let admins define named relationship types (e.g., 'Decision Maker') between associated CRM records.
Question 2: When importing contacts into HubSpot, which field is used as the default unique identifier to prevent duplicate records?
- Phone number
- Contact owner
- Email address (Correct answer)
- First and last name combined
Correct answer: Email address
HubSpot uses email address as the primary unique identifier for contact records during imports and deduplication.
Question 3: What is the maximum number of custom properties an administrator can create per object in HubSpot (Enterprise tier)?
- 500
- 1,000
- 10,000 (Correct answer)
- Unlimited
Correct answer: 10,000
HubSpot Enterprise allows up to 10,000 custom properties per CRM object.
Question 4: Which HubSpot feature allows admins to enforce that a property value must be set before a deal can move to a specific pipeline stage?
- Required properties on deal stage (Correct answer)
- Deal validation rules
- Property dependency gates
- Conditional logic triggers
Correct answer: Required properties on deal stage
The 'Required properties on deal stage' feature blocks stage advancement until specified fields are populated.
Question 5: In HubSpot's data model, which object type supports 'Line Items' as associated records?
- Contacts
- Companies
- Deals (Correct answer)
- Tickets
Correct answer: Deals
Line Items are associated with Deal records to itemize products and pricing within a deal.
Question 6: When using HubSpot's native SQL-like reporting query tool (Data Sets), what does a LEFT JOIN return?
- Only records present in both datasets
- All records from the left dataset plus matching records from the right (Correct answer)
- Only records in the right dataset
- All records from both datasets regardless of match
Correct 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.
Question 7: Which HubSpot property type should an administrator use to store a date without a time component?
- Date and time
- Date picker (Correct answer)
- Number
- Single-line text
Correct answer: Date picker
The 'Date picker' property type stores only a date value (no time), suitable for birthdays or contract dates.
HAC Database Management & SQL 2
In HubSpot, what does the 'Association Label' feature allow administrators to define?