Question 1

How would you query specific partitions in a BigQuery table?

Options :

A : Use the DAY column in the WHERE clause

B : Use the EXTRACT(DAY) clause

C : Use the __PARTITIONTIME pseudo-column in the WHERE clause

D : Use DATE BETWEEN in the WHERE clause

Answer: C

Question 2

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 3

Your software uses a simple JSON format for all messages. These messages are published to Google Cloud Pub/Sub, then processed with Google Cloud Dataflow to create a real-time dashboard for the CFO. During testing, you notice that some messages are missing in the dashboard. You check the logs, and all messages are being published to Cloud Pub/Sub successfully. What should you do next?

Options :

A : Check the dashboard application to see if it is not displaying correctly.

B : Run a fixed dataset through the Cloud Dataflow pipeline and analyze the output.

C : Use Google Stackdriver Monitoring on Cloud Pub/Sub to find the missing messages.

D : Switch Cloud Dataflow to pull messages from Cloud Pub/Sub instead of Cloud Pub/Sub pushing messages to Cloud Dataflow.

Answer: B

Question 4

You have some data, which is shown in the graphic below. The two dimensions are X and Y, and the shade of each dot represents what class it is. You want to classify this data accurately using a linear algorithm

To do this you need to add a synthetic feature. What should the value of that feature be?

Options :

A : X^2+Y^2

B : X^2

C : Y^2

D : cos(X)

Answer: D

Question 5

You are part of a healthcare organization where data is organized and managed by respective data owners in

various storage services. As a result of this decentralized ecosystem, discovering and managing data has

become difficult You need to quickly identify and implement a cost-optimized solution to assist your

organization with the following

• Data management and discovery

• Data lineage tracking

• Data quality validation

How should you build the solution?

Options :

A : Use BigLake to convert the current solution into a data lake architecture.

B :

Build a new data discovery tool on Google Kubernetes Engine that helps with new source onboarding and data lineage tracking

C :

Use BigOuery to track data lineage, and use Dataprep to manage data and perform data quality validation

D : Use Dataplex to manage data, track data lineage, and perform data quality validation.

Answer: D