Examtopics

Professional Data Engineer

  • Topic 1 Question 130

    The marketing team at your organization provides regular updates of a segment of your customer dataset. The marketing team has given you a CSV with 1 million records that must be updated in BigQuery. When you use the UPDATE statement in BigQuery, you receive a quotaExceeded error. What should you do?

    • Reduce the number of records updated each day to stay within the BigQuery UPDATE DML statement limit.

    • Increase the BigQuery UPDATE DML statement limit in the Quota management section of the Google Cloud Platform Console.

    • Split the source CSV file into smaller CSV files in Cloud Storage to reduce the number of BigQuery UPDATE DML statements per BigQuery job.

    • Import the new records from the CSV file into a new BigQuery table. Create a BigQuery job that merges the new records with the existing records and writes the results to a new BigQuery table.

    シャッフルモード