GoogleCloudProfessionalDataEngineerPract.epub

this data. What should you do? A. Use BigQuery for storage. Provide format files for data load. Update the format files as needed. B. Use BigQuery for storage. Select "Automatically detect" in the Schema section. C. Use Cloud Storage for storage. Link data as temporary tables in BigQuery and turn on the "Automatically detect" option in the Schema section of BigQuery. D. Use Cloud Storage for storage. Link data as permanent tables in BigQuery and turn on the "Automatically detect" option in the Schema section of BigQuery. Answer: B Correct answer is B as the requirement is to support occasionally (schema) changing JSON files and aggregate ANSI SQL queries: you need to use BigQuery, and it is quickest to use 'Automatically detect' for schema changes. Refer GCP documentation - BigQuery Auto-Detection: - https://cloud.google.com/bigquery/docs/schema-detect; Schema auto-detection is available when you load data into BigQuery, and when you query an external data source. When auto-detection is enabled, BigQuery starts the inference process by selecting a random file in the data source and scanning up to 100 rows of data to use as a represen......