Examtopics

Professional Data Engineer

  • Topic 1 Question 285

    You have 100 GB of data stored in a BigQuery table. This data is outdated and will only be accessed one or two times a year for analytics with SQL. For backup purposes, you want to store this data to be immutable for 3 years. You want to minimize storage costs. What should you do?

      1. Create a BigQuery table clone.
      2. Query the clone when you need to perform analytics.
      1. Create a BigQuery table snapshot.
      2. Restore the snapshot when you need to perform analytics.
      1. Perform a BigQuery export to a Cloud Storage bucket with archive storage class.
      2. Enable versioning on the bucket.
      3. Create a BigQuery external table on the exported files.
      1. Perform a BigQuery export to a Cloud Storage bucket with archive storage class.
      2. Set a locked retention policy on the bucket.
      3. Create a BigQuery external table on the exported files.
    シャッフルモード