Database Management & SQL Flashcards

An admin needs to track multiple phone numbers for a single contact (e.g., mobile and office). Which approach is correct in HubSpot?

Answer: Use the built-in multiple phone number fields (Phone Number, Mobile Phone Number)

HubSpot provides separate built-in properties (Phone Number, Mobile Phone Number, etc.) to store multiple phone numbers on one contact.

What is the correct SQL syntax element used in HubSpot Datasets to filter rows AFTER aggregation?

Answer: HAVING

HAVING filters rows after a GROUP BY aggregation, unlike WHERE which filters before aggregation.

Which HubSpot object is most appropriate for tracking an ongoing relationship or recurring service contract with a customer?

Answer: Custom object

Custom objects are ideal for modeling unique business concepts like service contracts that don't map cleanly to standard HubSpot objects.

In HubSpot's data sync, what does 'sync direction' control?

Answer: Whether data flows one-way or bidirectionally between HubSpot and an integrated app

Sync direction determines if data flows only from HubSpot to the external app, only inbound, or in both directions simultaneously.

Which HubSpot property stores the exact timestamp when a contact record was originally created?

Answer: Create date

The 'Create date' system property records the UTC timestamp when the contact record was first created in HubSpot.

What does 'property versioning history' allow a HubSpot admin to do?

Answer: View the historical values a property has held for a given record

Property history lets admins see every past value a specific property has held for a record, including who changed it and when.

When building a HubSpot Dataset, which JOIN type should you use to return ONLY records that exist in both the contacts table and the deals table?

Answer: INNER JOIN

An INNER JOIN returns only rows where a matching record exists in both joined tables, excluding non-matching rows from either side.