Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.

Unlimited Access

Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.

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 Hide Answer
Suggested Answer: C 🗳️

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
KouShikyou
Highly Voted 4 years, 6 months 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 41 times
nitinz
3 years, 1 month ago
C, partition the data and expire it in big query and use life cycle on GS bucket.
upvoted 3 times
...
AMohanty
1 year, 8 months ago
There is Nothing as Storage Class as NONE
upvoted 3 times
...
mister
4 years, 6 months ago
why not A
upvoted 2 times
tartar
3 years, 8 months ago
C is ok
upvoted 11 times
...
VishalB
2 years, 9 months ago
bcoz you would land up creating a table for each day which is not a good practice
upvoted 2 times
Wonka
2 years, 3 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
3 years, 4 months ago
C is the correct ans.
upvoted 2 times
...
...
techalik
3 years, 5 months 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 23 times
...
...
MeasService
Highly Voted 4 years, 6 months ago
answer C is the right choice here. Table expiration in BigQuery and life cycle management in GSC
upvoted 24 times
passnow
4 years, 4 months ago
i vote C
upvoted 4 times
...
...
thamaster
Most Recent 1 year, 3 months 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, 5 months ago
Selected Answer: C
ok for C
upvoted 1 times
...
Mahmoud_E
1 year, 6 months ago
Selected Answer: C
C is correct
upvoted 1 times
...
AzureDP900
1 year, 9 months ago
C is right
upvoted 2 times
...
amxexam
1 year, 11 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
2 years, 3 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
2 years, 3 months ago
I made a mistake in the question to post a comment
upvoted 1 times
kimharsh
1 year, 10 months ago
you also screwed up the percentage of the correct answers now :P
upvoted 3 times
...
...
...
vincy2202
2 years, 4 months ago
Selected Answer: C
C is the correct answer
upvoted 1 times
...
joe2211
2 years, 5 months ago
Selected Answer: C
vote C
upvoted 1 times
...
MaxNRG
2 years, 6 months 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, 6 months ago
C is correct. Time-partioned tables AND DELETE data after 36 months using GCS life cycle management.
upvoted 2 times
...
victory108
2 years, 9 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, 9 months ago
Answer is C
upvoted 1 times
...
Ausias18
3 years ago
Answer is C
upvoted 1 times
...
lynx256
3 years 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
3 years, 4 months ago
C is the right answer
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...