Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us[email protected]
Menu
Google Discussions
exam questions

Exam Professional Data Engineer All Questions

View all questions & answers for the Professional Data Engineer exam
Go to Exam

Exam Professional Data Engineer topic 1 question 100 discussion

Actual exam question from Google's Professional Data Engineer
Question #: 100
Topic #: 1
[All Professional Data Engineer Questions]

You have a requirement to insert minute-resolution data from 50,000 sensors into a BigQuery table. You expect significant growth in data volume and need the data to be available within 1 minute of ingestion for real-time analysis of aggregated trends. What should you do?

  • A. Use bq load to load a batch of sensor data every 60 seconds.
  • B. Use a Cloud Dataflow pipeline to stream data into the BigQuery table.
  • C. Use the INSERT statement to insert a batch of data every 60 seconds.
  • D. Use the MERGE statement to apply updates in batch every 60 seconds.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by jvg637 at March 19, 2020, 5:39 p.m.

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
jvg637
Highly Voted 4 years, 8 months ago
I think we need a pipeline, so it's B to me.
upvoted 29 times
...
[Removed]
Highly Voted 4 years, 8 months ago
Correct - B
upvoted 16 times
...
Erg_de
Most Recent 2 weeks, 5 days ago
Selected Answer: B
For real-time analysis and quick data availability, the appropriate option is the combination of the pipeline with BigQuery.
upvoted 1 times
...
Helinia
11 months, 3 weeks ago
“need the data to be available within 1 minute of ingestion for real-time analysis” → low latency requirement → Dataflow streaming The database can either be BQ or BigTable for this kind of requirement in data volume and latency. But it mentioned that the destination has to be BQ, so B.
upvoted 1 times
...
NeoNitin
1 year, 3 months ago
ANSWER b. FULL question ihave if you nee mail me neonitin6ATtherate......
upvoted 3 times
aryaavinash
1 year, 2 months ago
full email id please ?
upvoted 1 times
...
...
Oleksandr0501
1 year, 7 months ago
Selected Answer: B
I think we need a pipeline, so it's B to me.))
upvoted 3 times
...
votinhluombikip
1 year, 7 months ago
Selected Answer: B
I think we need a pipeline, so it's B to me.
upvoted 2 times
...
JANCAI
1 year, 8 months ago
Why the answer from the <reveal answer> is C??
upvoted 1 times
...
zellck
1 year, 11 months ago
Selected Answer: B
B is the answer.
upvoted 1 times
...
Prasha123
2 years ago
Selected Answer: B
Need pipeline so its B
upvoted 1 times
...
sedado77
2 years, 2 months ago
Selected Answer: B
I got this question on sept 2022. Answer is B
upvoted 7 times
...
medeis_jar
2 years, 10 months ago
Selected Answer: B
omg. B only
upvoted 2 times
...
MaxNRG
2 years, 10 months ago
Selected Answer: B
Is B, if we expect a growth we’ll need some buffer (that will be pub-sub) and the dataflow pipeline to stream data in big query. The tabledata.insertAll method is not valid here.
upvoted 7 times
...
hendrixlives
2 years, 11 months ago
Selected Answer: B
B, streaming with dataflow
upvoted 3 times
...
JG123
2 years, 12 months ago
Wrong answer shown again by examtopics.com Ans: B
upvoted 1 times
...
Ysance_AGS
3 years, 1 month ago
B => with dataflow you can parallelize data ingestion
upvoted 2 times
szefco
3 years ago
And make it streaming
upvoted 1 times
...
...
sandipk91
3 years, 3 months ago
B is the right answer
upvoted 2 times
...
Load full discussion...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
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