Examtopics

Professional Data Engineer

14
16

Topic 2 Question 15
Which methods can be used to reduce the number of rows processed by BigQuery?
- Splitting tables into multiple tables; putting data in partitions
- Splitting tables into multiple tables; putting data in partitions; using the LIMIT clause
- Putting data in partitions; using the LIMIT clause
- Splitting tables into multiple tables; using the LIMIT clause
解説
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
コメント(4)
- Answer: A Description: Others options are with Limit, limit cannot stop from checking all the rows in bigquery
  
  👍 12
  [Removed]2020/03/28
- Answer : A
  
  👍 7
  [Removed]2020/03/21
- Answer B While LIMIT does not affect the cost of the query (in terms of amount of data read from the storage), it does influence the resource used: --an example: SELECT * FROM table --slot time consumed 33s
  
  SELECT * FROM table LIMIT 10 --slot time consumed 0.051s
  
  👍 2
  merkur2021/09/29
シャッフルモード

14
16