Exam Professional Cloud Architect All Questions

View all questions & answers for the Professional Cloud Architect exam

Exam Professional Cloud Architect topic 9 question 1 discussion

Actual exam question from Google's Professional Cloud Architect

Question #: 1
Topic #: 9

[All Professional Cloud Architect Questions]

For this question, refer to the TerramEarth case study. To be compliant with European GDPR regulation, TerramEarth is required to delete data generated from its
European customers after a period of 36 months when it contains personal data. In the new architecture, this data will be stored in both Cloud Storage and
BigQuery. What should you do?

A. Create a BigQuery table for the European data, and set the table retention period to 36 months. For Cloud Storage, use gsutil to enable lifecycle management using a DELETE action with an Age condition of 36 months.
B. Create a BigQuery table for the European data, and set the table retention period to 36 months. For Cloud Storage, use gsutil to create a SetStorageClass to NONE action when with an Age condition of 36 months.
C. Create a BigQuery time-partitioned table for the European data, and set the partition expiration period to 36 months. For Cloud Storage, use gsutil to enable lifecycle management using a DELETE action with an Age condition of 36 months.
D. Create a BigQuery time-partitioned table for the European data, and set the partition expiration period to 36 months. For Cloud Storage, use gsutil to create a SetStorageClass to NONE action with an Age condition of 36 months.

Show Suggested Answer

Suggested Answer: C 🗳️

by KouShikyou at Oct. 12, 2019, 12:56 p.m.

Comments

Submit Cancel

KouShikyou

Highly Voted 4 years, 1 month ago

I thought C was correct. SetStorageClass could not be set to NONE. After data expired, data should be deleted not table. any comment?

upvoted 42 times

techalik

3 years ago

C Enable a bucket lifecycle management rule to delete objects older than 36 months. Use partitioned tables in BigQuery and set the partition expiration period to 36 months. is the right answer. When you create a table partitioned by ingestion time, BigQuery automatically loads data into daily, date-based partitions that reflect the data's ingestion or arrival time. Ref: https://cloud.google.com/bigquery/docs/partitioned-tables#ingestion_time And Google recommends you configure the default table expiration for your datasets, configure the expiration time for your tables, and configure the partition expiration for partitioned tables. Ref: https://cloud.google.com/bigquery/docs/best-practices-storage#use_the_expiration_settings_to_remove_unneeded_tables_and_partitions If the partitioned table has a table expiration configured, all the partitions in it are deleted according to the table expiration settings. For our specific requirement, we could set the partition expiration to 36 months so that partitions older than 36 months (and the data within) are automatically deleted. Ref: https://cloud.google.com/bigquery/docs/managing-partitioned-tables#partition-expiration

upvoted 24 times

...

nitinz

2 years, 9 months ago

C, partition the data and expire it in big query and use life cycle on GS bucket.

upvoted 3 times

...

AMohanty

1 year, 3 months ago

There is Nothing as Storage Class as NONE

upvoted 3 times

...

mister

4 years, 1 month ago

why not A

upvoted 2 times

tartar

3 years, 3 months ago

C is ok

upvoted 11 times

...

VishalB

2 years, 4 months ago

bcoz you would land up creating a table for each day which is not a good practice

upvoted 2 times

Wonka

1 year, 11 months ago

or rather it will delete the entire table and all the data in it i.e. records less than 36 months old

upvoted 2 times

...

Pankonics

2 years, 11 months ago

C is the correct ans.

upvoted 2 times

...

Load full discussion...

...

MeasService

Highly Voted 4 years, 1 month ago

answer C is the right choice here. Table expiration in BigQuery and life cycle management in GSC

upvoted 24 times

passnow

3 years, 11 months ago

i vote C

upvoted 4 times

...

thamaster

Most Recent 11 months, 1 week ago

Selected Answer: C

it's C, I'm sure at 100% the other answer are incorrect there is no None as storage class and you need to actually delete data

upvoted 1 times

...

megumin

1 year, 1 month ago

Selected Answer: C

ok for C

upvoted 1 times

...

Mahmoud_E

1 year, 1 month ago

Selected Answer: C

C is correct

upvoted 1 times

...

AzureDP900

1 year, 5 months ago

C is right

upvoted 2 times

...

amxexam

1 year, 6 months ago

Selected Answer: C

partion is way to go with big query hence B & C. for block storage C isvtye waybto go. hence C.

upvoted 1 times

...

OrangeTiger

1 year, 11 months ago

Selected Answer: D

'Next year they want to use the data to train machine learning models.' I agree with D.

upvoted 1 times

OrangeTiger

1 year, 11 months ago

I made a mistake in the question to post a comment

upvoted 1 times

kimharsh

1 year, 5 months ago

you also screwed up the percentage of the correct answers now :P

upvoted 3 times

...

vincy2202

1 year, 12 months ago

Selected Answer: C

C is the correct answer

upvoted 1 times

...

joe2211

2 years ago

Selected Answer: C

vote C

upvoted 1 times

...

MaxNRG

2 years, 1 month ago

Correct Answer: C A – doesn’t work since there is no “retention period” for table, there is only “expiration time” after which it is removed completely. B/D – doesn’t work, since no such storage class like NONE.

upvoted 1 times

...

[Removed]

2 years, 1 month ago

C is correct. Time-partioned tables AND DELETE data after 36 months using GCS life cycle management.

upvoted 2 times

...

victory108

2 years, 4 months ago

C. Create a BigQuery time-partitioned table for the European data, and set the partition expiration period to 36 months. For Cloud Storage, use gsutil to enable lifecycle management using a DELETE action with an Age condition of 36 months.

upvoted 1 times

...

MamthaSJ

2 years, 4 months ago

Answer is C

upvoted 1 times

...

Ausias18

2 years, 8 months ago

Answer is C

upvoted 1 times

...

lynx256

2 years, 8 months ago

IMO - C is ok (assuming DAY or lower level time-partitioning). We want to delete only partitions older than 36 month not THE WHOLE tables when aged 36 months.

upvoted 1 times

...

okixavi

2 years, 11 months ago

C is the right answer

upvoted 2 times

...

Load full discussion...