Practice Test 2 | Google Cloud Certified Professional Data Engineer | Dumps | Mock Test

An e-commerce company uses BigQuery as its main data warehouse. One of the tables stores customers details such as name, address, email and phone number. Data team wants to modify the table’s schema and add a new column called ‘zipcode’ which is previously included in address column. You are asked to modify the table’s schema and do necessary changes. You need to perform the changes with minimal costs. What should you do?

A. Add a new column called ‘zipcode’ to customers table. Run an update statement to extract zip code from address column and set it to the new column.
B. Create a view in BigQuery that extracts zip code from address as a new column.
C. Export table data from BigQuery to Google Storage. Use Dataproc to transform data and extract the zip code from addresses and append it as a new column. Create a new table for customers with new column ‘zipcode.’ Import transformed data to new table.
D. Create a Dataflow pipeline to read data from BigQuery, extract zip code from address column, then write data to a newly created table in BigQuery with ‘zipcode’ column.