Google professional-data-engineer

Choose your answer

• A

  Run a local version of Jupiter on the laptop.

• B

  Grant the user access to Google Cloud Shell.

• C

  Host a visualization tool on a VM on Google Compute Engine.

• D

  Deploy Google Cloud Datalab to a virtual machine (VM) on Google Compute Engine.

Pick an answer to check it, or press Show answer to see the correct one.

Choose your answer

• A

  Send the data to Google Cloud Datastore and then export to BigQuery.

• B

  Send the data to Google Cloud Pub/Sub, stream Cloud Pub/Sub to Google Cloud Dataflow, and store the data in Google BigQuery.

• C

  Send the data to Cloud Storage and then spin up an Apache Hadoop cluster as needed in Google Cloud Dataproc whenever analysis is required.

• D

  Export logs in batch to Google Cloud Storage and then spin up a Google Cloud SQL instance, import the data from Cloud Storage, and run an analysis as needed.

Pick an answer to check it, or press Show answer to see the correct one.

Choose your answer

• A

  Delete the table CLICK_STREAM, and then re-create it such that the column DT is of the TIMESTAMP 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.

• 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.

• 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.

• 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.

Pick an answer to check it, or press Show answer to see the correct one.

Choose your answer

• A

  Make a call to the Stackdriver API to list all logs, and apply an advanced filter.

• B

  In the Stackdriver logging admin interface, and enable a log sink export to BigQuery.

• C

  In the Stackdriver logging admin interface, enable a log sink export to Google Cloud Pub/Sub, and subscribe to the topic from your monitoring tool.

• D

  Using the Stackdriver API, create a project sink with advanced log filter to export to Pub/Sub, and subscribe to the topic from your monitoring tool.

Pick an answer to check it, or press Show answer to see the correct one.

Choose your answer

• A

  Grant the consultant the Viewer role on the project.

• B

  Grant the consultant the Cloud Dataflow Developer role on the project.

• C

  Create a service account and allow the consultant to log on with it.

• D

  Create an anonymized sample of the data for the consultant to work with in a different project.

Pick an answer to check it, or press Show answer to see the correct one.