Question 1

You want to use a BigQuery table as a data sink. In which writing mode(s) can you use BigQuery as a sink?

Options :

A : Both batch and streaming

B : BigQuery cannot be used as a sink

C : Only batch

D : Only streaming

Answer: A

Question 2

Analysts are using Cloud Data Studio for analyzing data sets. They would like to improve the performance of the time required to update tables and charts when working with the data. What would you recommend they try to improve performance?

Options :

A : Use an imported data source

B : Use a blended data source

C : Use a live data source

D : Use an extracted data source

Answer: D

Question 3

You work for a bank. You have a labelled dataset that contains information on already granted loan application and whether these applications have been defaulted. You have been asked to train a model to predict default rates for credit applicants. What should you do?

Options :

A : Increase the size of the dataset by collecting additional data.

B : Train a linear regression to predict a credit default risk score.

C : Remove the bias from the data and collect applications that have been declined loans.

D : Match loan applicants with their social profiles to enable feature engineering.

Answer: B

Question 4

Which methods can be used to reduce the number of rows processed by BigQuery?

Options :

A : Splitting tables into multiple tables; putting data in partitions

B : Splitting tables into multiple tables; putting data in partitions; using the LIMIT clause

C : Putting data in partitions; using the LIMIT clause

D : Splitting tables into multiple tables; using the LIMIT clause

Answer: A

Question 5

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