Question 1

Each analytics team in your organization is running BigQuery jobs in their own projects. You want to enable each team to monitor slot usage within their projects. What should you do?

Options :

A : Create a Stackdriver Monitoring dashboard based on the BigQuery metric query/scanned_bytes

B : Create a Stackdriver Monitoring dashboard based on the BigQuery metric slots/allocated_for_project

C : Create a log export for each project, capture the BigQuery job execution logs, create a custom metric based on the totalSlotMs, and create a Stackdriver Monitoring dashboard based on the custom metric

D : Create an aggregated log export at the organization level, capture the BigQuery job execution logs, create a custom metric based on the totalSlotMs, and create a Stackdriver Monitoring dashboard based on the custom metric

Answer: D

Question 2

A team of data scientists has been using an on-premises cluster running Hadoop and HBase. They want to migrate to a managed service in Google Cloud. They also want to minimize changes to programs that make extensive use of the HBase API. What GCP service would you recommend?

Options :

A : Bigtable

B : BigQuery

C : Cloud Spanner

D : Cloud Dataflow

Answer: A

Question 3

A data pipeline uses Cloud Pub/Sub for ingesting data. The data is stored in topics and a Dataflow workflow reads from a subscription to that topic, processes the data, and writes output to BigQuery. What is the recommended way to authenticate when reading data from Cloud Pub/Sub?

Options :

A : Custom role

B : Google Workspace Identity

C : Use service accounts

D : Basic role

Answer: C

Question 4

An online brokerage company requires a high volume trade processing architecture. You need to create a secure queuing system that triggers jobs. The jobs will run in Google Cloud and cat the company's Python API to execute trades. You need to efficiently implement a solution. What should you do?

Options :

A : Use Cloud Composer to subscribe to a Pub/Sub tope and can the Python API.

B : Use a Pub/Sub push subscription to trigger a Cloud Function to pass the data to tie Python API.

C : Write an application that makes a queue in a NoSQL database

D : Write an application hosted on a Compute Engine instance that makes a push subscription to the Pub/Sub topic

Answer: C

Question 5

You are loading CSV files from Cloud Storage to BigQuery. The files have known data quality issues,including mismatched data types, such as STRINGS and INT64s in the same column, and inconsistentformatting of values such as phone numbers or addresses. You need to create the data pipeline to maintain data quality and perform the required cleansing and transformation. What should you do?

Options :

A : Use Data Fusion to transform the data before loading it into BigQuery.

B : Load the CSV files into a staging table with the desired schema, perform the transformations with SQL. and then write the results to the final destination table.

C : Create a table with the desired schema, toad the CSV files into the table, and perform the transformations in place using SQL.

D : Use Data Fusion to convert the CSV files lo a self-describing data formal, such as AVRO. before loading the data to BigOuery.

Answer: A

Confidently Practice Online with Free Professional-Data-Engineer Exam Cram

Buying Options: