To design a cost-effective BigQuery solution for occasional querying with immediate data availability, what pricing model and table type should you select?

*The most cost-effective approach for a BigQuery solution that is used occasionally but requires immediate data availability is on-demand pricing with Partitioned tables. On-demand pricing is ideal for occasional querying as it charges based on the amount of data processed by each query, avoiding the costs associated with continuous capacity as in flat-rate pricing. Partitioned tables in BigQuery enhance this cost-efficiency by enabling users to query only relevant subsets of data, further reducing the amount of data processed and charged per query. This setup offers the flexibility and cost-effectiveness needed for infrequent querying while ensuring that the data is always immediately accessible when needed. Alternative options like flat-rate pricing or external tables do not provide the same level of cost-effectiveness or immediate data availability for occasional use cases.*