exam questions

Exam Professional Cloud Database Engineer All Questions

View all questions & answers for the Professional Cloud Database Engineer exam

Exam Professional Cloud Database Engineer topic 1 question 39 discussion

Actual exam question from Google's Professional Cloud Database Engineer
Question #: 39
Topic #: 1
[All Professional Cloud Database Engineer Questions]

You are running an instance of Cloud Spanner as the backend of your ecommerce website. You learn that the quality assurance (QA) team has doubled the number of their test cases. You need to create a copy of your Cloud Spanner database in a new test environment to accommodate the additional test cases. You want to follow Google-recommended practices. What should you do?

  • A. Use Cloud Functions to run the export in Avro format.
  • B. Use Cloud Functions to run the export in text format.
  • C. Use Dataflow to run the export in Avro format.
  • D. Use Dataflow to run the export in text format.
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
dynamic_dba
Highly Voted 7 months, 2 weeks ago
C. A and B are wrong because Spanner exports are run as Dataflow jobs. The question says you need a copy of your entire database which means all the tables. You cannot export an entire database using the CSV (text) format, but you can using the Avro format. So that would make it the better option. https://cloud.google.com/spanner/docs/import-export-overview#file-format
upvoted 5 times
...
H_S
Most Recent 7 months, 3 weeks ago
Although I agree with C, I don't know why not D
upvoted 1 times
...
pk349
10 months, 1 week ago
C: Use Dataflow to run the export in Avro format.
upvoted 2 times
...
GCP72
10 months, 1 week ago
Selected Answer: C
Answer is C, Dataflow and Avro format. Cloud functions has timeout Gen-1 6mins Gen-2 1hr
upvoted 3 times
...
range9005
10 months, 1 week ago
Selected Answer: C
Use Dataflow to run the export in Avro format. . https://cloud.google.com/spanner/docs/export
upvoted 4 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 ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago