Which methods can be used to reduce the number of rows processed by BigQuery?
Which methods can be used to reduce the number of rows processed by BigQuery?
A . Splitting tables into multiple tables; putting data in partitions
B . Splitting tables into multiple tables; putting data in partitions; using the LIMIT clause
C . Putting data in partitions; using the LIMIT clause
D . Splitting tables into multiple tables; using the LIMIT clause
Answer: A
Explanation:
If you split a table into multiple tables (such as one table for each day), then you can limit your query to the data in specific tables (such as for particular days). A better method is to use a partitioned table, as long as your data can be separated by the day.
If you use the LIMIT clause, BigQuery will still process the entire table.
Reference: https://cloud.google.com/bigquery/docs/partitioned-tables
Latest Professional Data Engineer Dumps Valid Version with 160 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund