Question 1

A financial institution collects data from various sources and categorizes it as follows:

Transaction records stored in a relational database, containing fields like transaction ID, amount, date, and account number.

Customer support chat logs saved in text documents.

Financial reports received from third-party vendors in XML format.

Based on the descriptions, how should you classify each data type?

Options :

A : Structured data: transaction records; semi-structured data: customer support chat logs; structured data: financial reports

B : Unstructured data: transaction records; structured data: customer support chat logs; semi-structured data: financial reports

C : Structured data: transaction records; semi-structured data: customer support chat logs; unstructured data: financial reports

D : Structured data: transaction records; unstructured data: customer support chat logs; semi-structured data: financial reports

Answer: D

Question 2

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 3

Your organization uses a BigQuery table that is partitioned by ingestion time. You need to remove data that is older than one year to reduce your organizations storage costs. You want to use the most efficient approach while minimizing cost. What should you do?

Options :

A :

Create a scheduled query that periodically runs an update statement in SQL that sets the œdeleted" column to œyes for data that is more than one year old. Create a view that filters out rows that have been marked deleted.

B : Create a view that filters out rows that are older than one year.

C : Require users to specify a partition filter using the alter table statement in SQL.

D : Set the table partition expiration period to one year using the ALTER TABLE statement in SQL.

Answer: D

Question 4

A company wants to ensure that its data remains secure while stored in Cloud Storage and during transmission to clients. Which combination of measures should the company implement to meet these requirements?

Options :

A : Client-side encryption only

B : Encryption at rest only

C : Encryption in transit and encryption at rest

D : Encryption in transit only

Answer: C

Question 5

A financial services company is exploring encryption options for their data in BigQuery. They require that encryption keys are managed entirely outside of Google Cloud to maintain complete control over encryption keys and to meet specific regulatory standards. Which encryption key option is most suitable for this use case?

Options :

A : Use default data masking within BigQuery for enhanced security without external encryption.

B : Customer-managed encryption keys (CMEK) to ensure encryption keys remain within Google Cloud but under customer control.

C : Google-managed encryption keys (GMEK) for fully automated encryption management.

D : Customer-supplied encryption keys (CSEK) to keep encryption keys outside of Google Cloud infrastructure and retain full control.

Answer: D