75 verified Data Engineer Wh Bigquery Execution Slots Cost interview questions — solve with answers, learn from explanations, test yourself in a real simulation.
Try the real simulation →SELECT * FROM orders;
-- vs
SELECT order_id, total_amount FROM orders;orders table with no WHERE clause. Why does the second query typically process fewer bytes than the first?SELECT * reads every column, while selecting two columns reads only those two, which is why it processes fewer bytes.events is NOT clustered or partitioned. You run SELECT * FROM events LIMIT 10. Compared to running the same query without the LIMIT, how many bytes does BigQuery process?logs has no partitioning or clustering defined. You run SELECT message FROM logs WHERE severity = 'ERROR'. Compared to a query without the WHERE clause but selecting the same column, what happens to the bytes scanned?message and severity, since severity is needed to evaluate WHERE) for every row and only then discard non-matching rows.Test yourself against the 1950-question Data Engineer bank.
Start interview