Question 1

You are a data practitioner working for a healthcare organization that stores sensitive patient data in Cloud Storage. To comply with regulatory requirements, you need to restrict access to this data and monitor any changes to permissions. Which access configuration is the most appropriate to ensure restricted access and governance?

Options :

A : Enable Object Versioning to automatically track changes in access controls.

B : Assign the Storage Admin role to all users who need read access.

C : Grant the Viewer role to each user individually on the bucket.

D : Use a group-based IAM policy that grants the Storage Object Viewer role only to a designated group with read permissions.

Answer: D

Question 2

Your team needs to regularly extract and load data from multiple Google Ads accounts into BigQuery for analysis and reporting. The solution must handle incremental updates automatically, and you prefer a fully managed tool to avoid creating custom pipelines. Which tool should you choose?

Options :

A : BigQuery Data Transfer Service

B : Dataflow

C : Cloud Data Fusion

D : Cloud Storage Transfer Service

Answer: A

Question 3

Your organization has a petabyte of application logs stored as Parquet files in Cloud Storage. You need to quickly perform a one-time SQL-based analysis of the files and join them to data that already resides in BigQuery. What should you do?

Options :

A : Create a Dataproc cluster, and write a PySpark job to join the data from BigQuery to the files in Cloud Storage.

B : Launch a Cloud Data Fusion environment, use plugins to connect to BigQuery and Cloud Storage, and use the SQL join operation to analyze the data.

C : Create external tables over the files in Cloud Storage, and perform SQL joins to tables in BigQuery to analyze the data

D : Use the bq load command to load the Parquet files into BigQuery, and perform SQL joins to analyze the data.

Answer: C

Question 4

You are planning an ML project to predict housing prices based on various features (e.g., square footage, location, number of bedrooms). Which of the following is the best approach to ensure a successful ML project outcome in terms of planning the data collection, model training, and evaluation?

Options :

A : Begin with data collection, then train several models, and finally decide on the project’s objectives based on initial results.

B : Train a simple model first without defining evaluation metrics, as this allows for flexibility in metrics later.

C : Start by selecting a complex deep learning model to ensure high accuracy, then collect data to match the model’s requirements.

D : First, define the project’s objectives, then determine data collection methods to gather relevant and high-quality data.

Answer: D

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

Free Associate-Data-Practitioner Mock Exam – Practice Online Confidently

Buying Options: