Database Management & SQL Flashcards

An administrator wants to automatically merge duplicate contacts in HubSpot. Which setting enables this automation?

Answer: Automatic contact deduplication toggle in settings

HubSpot's automatic deduplication setting merges contacts that share the same email address without manual intervention.

What does the HubSpot 'Record ID' property represent?

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.

In HubSpot Datasets, which aggregation function would you use to count the total number of records in a group?

Answer: COUNT()

COUNT() returns the total number of rows (records) within a grouped dataset.

Which HubSpot feature allows an admin to map incoming webhook or API data fields to specific CRM properties?

Answer: Data sync field mappings

HubSpot's Data Sync (Operations Hub) field mappings define how external data fields correspond to HubSpot CRM properties.

What happens to associated records when a company record is permanently deleted in HubSpot?

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.

Which property field type in HubSpot is best suited for storing a predefined list of options where only ONE selection is allowed?

Answer: Dropdown select

A Dropdown select property presents a list of options and allows exactly one value to be chosen.

In a HubSpot custom report using Datasets, what is the purpose of a 'filter' applied at the Dataset level versus the report level?

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.