Question 1

You are constructing a data pipeline to process sensitive customer data stored in a Cloud Storage bucket. You need to ensure that this data remains accessible, even in the event of a single-zone outage. What should you do?

Options :

A : Set up a Cloud CDN in front of the bucket.

B : Enable Object Versioning on the bucket.

C : Store the data in a multi-region bucket

D : Store the data in Nearline storaqe.

Answer: C

Question 2

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 3

Which of the following metrics is most appropriate for evaluating a binary classification model when the dataset has an imbalanced distribution of classes?

Options :

A : Precision

B : Accuracy

C : F1 Score

D : Recall

Answer: C

Question 4

An online retailer needs to load and transform transactional data from their e-commerce platform to perform near real-time analytics on customer purchasing patterns in BigQuery. Which data pipeline approach is most appropriate to meet these requirements?

Options :

A : ETL with Dataflow for real-time streaming transformations to BigQuery

B : Exporting data to Cloud Storage, then manually uploading it to BigQuery

C : Batch ETL process that loads data to BigQuery every 24 hours

D : ELT with scheduled transformations in BigQuery every hour

Answer: A

Question 5

A team is designing a pipeline to ingest large amounts of raw data from multiple external sources into BigQuery for further analysis. They plan to perform basic data transformations, such as removing duplicates and standardizing date formats, before loading the data. Which data manipulation methodology is most suitable for this scenario?

Options :

A : ELT (Extract, Load, Transform)

B : ETB (Extract, Transform, Backup)

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

D : ETL (Extract, Transform, Load)

Answer: D