Google Professional Data Engineer Exam - Topic 5 Question 46 Discussion

Actual exam question for Google's Professional Data Engineer exam

Question #: 46
Topic #: 5

[All Professional Data Engineer Questions]

You decided to use Cloud Datastore to ingest vehicle telemetry data in real time. You want to build a storage system that will account for the long-term data growth, while keeping the costs low. You also want to create snapshots of the data periodically, so that you can make a point-in-time (PIT) recovery, or clone a copy of the data for Cloud Datastore in a different environment. You want to archive these snapshots for a long time. Which two methods can accomplish this? Choose 2 answers.

AUse managed export, and store the data in a Cloud Storage bucket using Nearline or Coldline class.

BUse managed exportm, and then import to Cloud Datastore in a separate project under a unique namespace reserved for that export.

CUse managed export, and then import the data into a BigQuery table created just for that export, and delete temporary export files.

DWrite an application that uses Cloud Datastore client libraries to read all the entities. Treat each entity as a BigQuery table row via BigQuery streaming insert. Assign an export timestamp for each export, and attach it as an extra column for each row. Make sure that the BigQuery table is partitioned using the export timestamp column.

EWrite an application that uses Cloud Datastore client libraries to read all the entities. Format the exported data into a JSON file. Apply compression before storing the data in Cloud Source Repositories.

Show Suggested Answer

Suggested Answer: C, E

by Aja at May 06, 2022, 11:15 PM

Limited Time Offer

25%

Off

Get Premium Professional Data Engineer Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Matthew

4 months ago

B seems unnecessary, just export to Cloud Storage directly!

upvoted 0 times

...

Zona

4 months ago

Wait, can you really use Nearline for long-term storage?

upvoted 0 times

...

Allene

4 months ago

I’m not sure about C, isn’t BigQuery more expensive?

upvoted 0 times

...

Ty

4 months ago

Totally agree, A is definitely the way to go.

upvoted 0 times

...

Ellsworth

5 months ago

A and C are the best options for this!

upvoted 0 times

...

Laurel

5 months ago

I recall something about using BigQuery for exports, but I’m not sure if it’s necessary to delete temporary files afterward. That seems a bit tricky!

upvoted 0 times

...

Nakisha

5 months ago

I practiced a similar question about exporting data, and I feel like option B could be a valid choice, but I’m not confident about the namespace part.

upvoted 0 times

...

Delpha

5 months ago

I think using managed export to Cloud Storage makes sense, especially for archiving, but I’m a bit confused about the differences between the storage classes.

upvoted 0 times

...

Celeste

5 months ago

I remember studying managed exports, but I'm not entirely sure if Nearline or Coldline is the best choice for long-term storage.

upvoted 0 times

...

Apolonia

5 months ago

Okay, let's see. Elastic Cloud Service, Elastically scalable cloud services, and Virtual private cloud all sound like they could be computing cloud services. Bare Metal Service is the one that stands out as potentially not being a computing cloud service. I'll go with that.

upvoted 0 times

...

Howard

5 months ago

Okay, I've got it! Since the devices are hybrid Azure AD-joined, the solution is to enable single sign-on (SSO) from Azure AD Connect. That should reduce the number of times users have to enter their passwords.

upvoted 0 times

...

Sarah

5 months ago

Hmm, this one's tricky. I'm not entirely confident, but I think the correct answer might be option A - Information to clarify a viable Brief. I'll have to double-check my notes to be sure.

upvoted 0 times

...