HAC Database Management & SQL 3 — Questions and Answers
Question 1: An administrator wants to automatically merge duplicate contacts in HubSpot. Which setting enables this automation?
- Workflow-based deduplication action
- Automatic contact deduplication toggle in settings (Correct answer)
- Third-party data enrichment
- Import duplicate handling rules
Correct answer: Automatic contact deduplication toggle in settings
HubSpot's automatic deduplication setting merges contacts that share the same email address without manual intervention.
Question 2: What does the HubSpot 'Record ID' property represent?
- A custom field set by the admin for internal tracking
- The system-generated unique numeric identifier for each CRM record (Correct answer)
- The HubSpot portal ID
- A user-defined alphanumeric code
Correct answer: The system-generated unique numeric identifier for each CRM record
The Record ID is HubSpot's auto-generated immutable numeric identifier unique to each individual CRM record.
Question 3: In HubSpot Datasets, which aggregation function would you use to count the total number of records in a group?
- SUM()
- AVG()
- COUNT() (Correct answer)
- MAX()
Correct answer: COUNT()
COUNT() returns the total number of rows (records) within a grouped dataset.
Question 4: Which HubSpot feature allows an admin to map incoming webhook or API data fields to specific CRM properties?
- Property mapping in workflows
- Data sync field mappings (Correct answer)
- Custom coded actions
- Import column mapping
Correct answer: Data sync field mappings
HubSpot's Data Sync (Operations Hub) field mappings define how external data fields correspond to HubSpot CRM properties.
Question 5: What happens to associated records when a company record is permanently deleted in HubSpot?
- All associated contacts and deals are also permanently deleted
- Associations are removed but associated records remain (Correct answer)
- Associated records are archived automatically
- Deletion is blocked until associations are removed manually
Correct answer: Associations are removed but associated records remain
Deleting a company removes the association links but does not delete the associated contact or deal records themselves.
Question 6: Which property field type in HubSpot is best suited for storing a predefined list of options where only ONE selection is allowed?
- Checkbox
- Multiple checkboxes
- Dropdown select (Correct answer)
- Radio select
Correct answer: Dropdown select
A Dropdown select property presents a list of options and allows exactly one value to be chosen.
Question 7: In a HubSpot custom report using Datasets, what is the purpose of a 'filter' applied at the Dataset level versus the report level?
- Dataset filters apply to all reports using that dataset; report filters apply only to that specific report (Correct answer)
- They are functionally identical
- Report-level filters are permanent; dataset filters are temporary
- Dataset filters only affect chart visualizations
Correct answer: Dataset filters apply to all reports using that dataset; report filters apply only to that specific report
Dataset-level filters restrict data globally for every report built on that dataset, while report-level filters scope only that individual report's results.
HAC Database Management & SQL 3
An administrator wants to automatically merge duplicate contacts in HubSpot.
Which setting enables this automation?