Zuora, Zuora, Zuora
Count the Grain
Invoice Impossible
Primary Membership Pipeline
Cancel Culture
100
What Zuora UI status can appear as “Active” even when the member’s coverage has already expired?
Active Out of Term
100
Looking at this subscription version history, how many rows would exist in the account table?
1
100
If you have a monthly subscription and make all payments successfully, how many invoices should you receive in a year?
12
100
What is the entry point model for the membership pipeline?
rv_membership_raw
100
What primary membership model consolidates cancellation rules, dates, statuses, and cancellation categories?
rv_membership_primary_cancellation
200
What Zuora view is the primary place to troubleshoot changes made to a subscription over time?
Subscription Change History
200
Looking at this subscription version history, how many rows would exist in the product_rate_plan table?
4
200
One payment links to multiple invoices. True or False
False
200
What fragile but effective method uses flags to detect movement between primary membership and CCM?
The 1s and 0s logic
200
For auto-cancel, what date represents the last day of payment or the first failure that led to cancellation?
end_date
300
What does every renewal, cancellation, or rate plan change create?
A new subscription version
300
Looking at this subscription version history, how many rows would exist in the subscription table?
6
300
When a payment fails, Zuora may retry payment multiple times against what same billing object?
Invoice
300
What naming convention does Noah prefix his fields with when doing min/max in the primary and spouse logic?
latest_ and earliest_
300
For auto-cancel, what date represents the final coverage or cancellation date after the failure sequence?
cancel_date
400
When reviewing subscription history, what field should be used for ordering changes instead of a create_date?
Version number
400
Looking at this subscription version history, how many rows would exist in the amendment table?
5
400
What year did the invoice-payment connector logic change, requiring payment history to account for both old and new structures?
2024
400
Which model is responsible for establishing the 1s and 0s?
A. rv_membership_primary
B. rv_membership_primary_membership_version
C. rv_membership_primary_membership
D. rv_membership_primary_cancellation
C. rv_membership_primary_membership
400
What would cause a member to have an end_date but no cancel_date?
Their membership expired
500
What date should be checked against the current date to determine whether a member is truly active or is out of term?
subscription_end_date/term_end_date
500
Looking at this subscription version history, how many rows would exist in the rate_plan table?
19
1+2+3+4+4+5
500
Which two tables must be unioned to get complete payment history across the invoice-payment model change?
invoice_item and payment_part
500
What window function is used when establishing the version group number?
DENSE_RANK()
500
What 14-day process begins when someone auto-cancels?
Winback