Question 9

SELECT COUNT(*)
FROM `project-72a8918f-b826-4add-9a9.rides_dataset.yellow_taxi`;

How many bytes does it estimate will be read?

0 bytes

Why?

BigQuery already knows how many rows are in the table from its stored information (metadata). So when we run COUNT(*), it doesn’t need to read the actual data. That’s why the estimated bytes processed is 0 B.