Q1. How does BigQuery separate storage and compute?
BigQuery is a serverless, columnar data warehouse built on a separation of storage and compute. - Storage: data lives in Capacitor, a columnar format backed by Colossus d...
Technical Question Bank · Peer-Reviewed
Job Interview Questions and Answers Directory
Search and filter frequently asked interview questions across technical, programming, and behavioral domains. Tailor your interview preparation by difficulty for freshers or experienced developers (5 available).
Active:
Tag: cost ×
Q2. Explain Azure Blob Storage access tiers.
Blob Storage offers tiers that trade storage cost against access cost and latency. - Hot: frequent access, highest storage cost, lowest access cost. - Cool: infrequent ac...
Q3. Compare the GCP Cloud Storage classes.
Cloud Storage classes trade storage cost for retrieval cost and minimum storage duration. - Standard: frequent access, no minimum duration. Best for hot data and serving ...
Q4. Explain S3 storage classes and lifecycle policies.
S3 storage classes trade retrieval cost and latency against storage cost. - S3 Standard is for frequent access with low latency. - S3 Intelligent-Tiering automatically mo...
Q5. How do you optimise BigQuery query cost and performance?
Cost in on-demand BigQuery is driven by bytes scanned, so reduce what each query reads. - Partition tables, usually by date, and add partition filters so only relevant pa...