Question 1

Which of the following is the best use case for using BigQuery ML to develop a machine learning model?

Options :

A : Creating a customer segmentation model based on historical purchasing data

B : Creating a recommendation system that requires complex custom neural networks

C : Performing real-time fraud detection on incoming transactions

D : Running complex object recognition on a video stream using deep learning models

Answer: A

Question 2

You have a Dataproc cluster that performs batch processing on data stored in Cloud Storage. You need to schedule a daily Spark job to generate a report that will be emailed to stakeholders. You need a fully-managed solution that is easy to implement and minimizes complexity. What should you do?

Options :

A : Use Cloud Composer to orchestrate the Spark job and email the report.

B : Use Dataproc workflow templates to define and schedule the Spark job, and to email the report.

C : Use Cloud Run functions to trigger the Spark job and email the report.

D : Use Cloud Scheduler to trigger the Spark job. and use Cloud Run functions to email the report.

Answer: B

Question 3

Your organization is assessing its data security requirements on Google Cloud. Which of the following statements accurately describes encryption at rest and its purpose?

Options :

A : Encryption at rest protects data during storage and ensures it cannot be accessed if a device is physically removed or stolen.

B : Encryption at rest uses only asymmetric encryption algorithms for all Google Cloud storage services.

C : Encryption at rest ensures that data is protected from unauthorized access during network transfers to other Google Cloud services.

D : Encryption at rest only encrypts data on databases, while encryption in transit protects data stored on all other storage types.

Answer: A

Question 4

A financial institution needs to prepare data from different transactional systems for machine learning. The data needs initial filtering and validation before loading into BigQuery, where additional, complex transformations will be applied. Which data processing methodology best suits this requirement?

Options :

A : ETL (Extract, Transform, Load)

B : ETLT (Extract, Transform, Load, Transform)

C : ELT (Extract, Load, Transform)

D : Manual data preparation using Google Sheets

Answer: B

Question 5

Your team uses Cloud SQL to manage an application database that requires both high availability and disaster recovery. Which of the following configurations will best support these requirements?

Options :

A : Enable automated backups and choose a Multi-Zone configuration.

B : Configure a read replica in a different region.

C : Choose Coldline Storage for backups.

D : Use the standard Cloud SQL instance configuration without any additional settings.

Answer: A