You Have Spent a Few Days Loading Data from Comma-Separated

question 78

Multiple Choice

You have spent a few days loading data from comma-separated values (CSV) files into the Google BigQuery table CLICK_STREAM . The column DT stores the epoch time of click events. For convenience, you chose a simple schema where every field is treated as the STRING type. 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?

• A) Delete the table CLICK_STREAM , and then re-create it such that the column DT is of the TIMESTAMP type. Reload the data. Delete the table , and then re-create it such that the column is of the type. Reload the data.
• B) Add a column TS of the TIMESTAMP type to the table CLICK_STREAM , and populate the numeric values from the column TS for each row. Reference the column TS instead of the column DT from now on. Add a column TS of the type to the table , and populate the numeric values from the column for each row. Reference the column instead of the column from now on.
• C) Create a view CLICK _ STREAM _ V , where strings from the column DT are cast into TIMESTAMP values. Reference the view CLICK_STREAM_V instead of the table CLICK_STREAM from now on. Create a view CLICK _ STREAM V , where strings from the column are cast into values. Reference the view CLICK_STREAM_V instead of the table
• D) Add two columns to the table CLICK STREAM: TS of the TIMESTAMP type and IS_NEW of the BOOLEAN type. Reload all data in append mode. For each appended row, set the value of IS_NEW to true. For future queries, reference the column TS instead of the column DT , with the WHERE clause ensuring that the value of IS_NEW must be true. Add two columns to the table CLICK STREAM: TS type and IS_NEW BOOLEAN type. Reload all data in append mode. For each appended row, set the value of to true. For future queries, reference the column , with the WHERE clause ensuring that the value of must be true.
• E) Construct a query to return every row of the table CLICK_STREAM , while using the built-in function to cast strings from the column DT into TIMESTAMP values. Run the query into a destination table NEW_CLICK_STREAM , in which the column TS is the TIMESTAMP type. Reference the table NEW_CLICK_STREAM instead of the table CLICK_STREAM from now on. In the future, new data is loaded into the table NEW_CLICK_STREAM . Construct a query to return every row of the table , while using the built-in function to cast strings from the column into values. Run the query into a destination table NEW_CLICK_STREAM , in which the column is the type. Reference the table from now on. In the future, new data is loaded into the table .

---

Definitions:

Cortex

The outer layer of the cerebrum in the brain, associated with higher brain functions such as thought and action.

Smell

A sense that detects odors or scents through the olfactory system, typically perceived through the nose.

Supertasters

Individuals with a heightened sensitivity to tastes, especially bitter flavors, due to a higher number of taste papillae on their tongue.

Cardiovascular Disease

A class of diseases that involve the heart or blood vessels, including heart attack, stroke, and arteriosclerosis.