Database Management & SQL Flashcards
7 cards from real HAC practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 7 Database Management & SQL flashcards as text
What is the primary purpose of HubSpot's 'Data Quality Command Center' (Operations Hub)?
Answer: To identify and fix data health issues like duplicates, missing values, and formatting errors
The Data Quality Command Center surfaces data health issues across the CRM, helping admins proactively fix duplicates, formatting problems, and missing properties.
In HubSpot, which property type allows an admin to create dependent fields that only appear when a parent property has a specific value?
Answer: Conditional property logic
Conditional property logic shows or hides dependent fields on forms based on the value selected in a parent property.
What does the HubSpot 'Calculated property' type do?
Answer: Automatically computes a value based on other existing property values using a formula
Calculated properties use a formula engine to derive a value dynamically from other numeric or date properties on the same record.
An administrator notices that contact records imported via API are missing the 'Original Source' value. What is the most likely cause?
Answer: Original Source must be passed explicitly in the API payload or it defaults to 'API'
HubSpot sets Original Source to 'API' for records created via API unless a specific source is explicitly provided in the request payload.
Which SQL clause in HubSpot Datasets is used to sort the result set in descending order by a specific column?
Answer: ORDER BY column DESC
ORDER BY column DESC sorts the query results from highest to lowest (descending) based on the specified column.
When an admin configures a HubSpot workflow to copy a contact property value to an associated company record, which action type is used?
Answer: Copy property value to associated record
The 'Copy property value to associated record' workflow action propagates a property value from the enrolled record to a specified associated object.
What is the maximum number of associations a single HubSpot record can have with records of the same object type (e.g., contact-to-contact) in Enterprise?
Answer: There is no fixed limit documented; HubSpot enforces API rate limits instead
HubSpot does not publish a hard cap on same-object associations per record; practical limits are governed by API rate limits and performance.
How this page was made: written with AI tools. We have not yet matched this exam's facts to an official source, so confirm fees, dates and rules with the exam body. Not reviewed by a subject-matter expert. Editorial policy