Question 46

Which of these is not a supported method of putting data into a partitioned table?
  • Question 47

    You are creating a model to predict housing prices. Due to budget constraints, you must run it on a single resource-constrained virtual machine. Which learning algorithm should you use?
  • Question 48

    You have spent a few days loading data from comma-separated values (CSV) files into the Google
    BigQuery table CLICK_STREAM. The column DTstores the epoch time of click events. For convenience,
    you chose a simple schema where every field is treated as the STRINGtype. Now, you want to compute
    web session durations of users who visit your site, and you want to change its data type to the
    TIMESTAMP. You want to minimize the migration effort without making future queries computationally
    expensive. What should you do?
  • Question 49

    You are building new real-time data warehouse for your company and will use Google BigQuery streaming inserts. There is no guarantee that data will only be sent in once but you do have a unique ID for each row of data and an event timestamp. You want to ensure that duplicates are not included while interactively querying data. Which query type should you use?
  • Question 50

    Which is the preferred method to use to avoid hotspotting in time series data in Bigtable?