ExamTopics Logo
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 (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
jvg637
Highly Voted 5 years, 1 month ago
I think we need a pipeline, so it's B to me.
upvoted 29 times
...
[Removed]
Highly Voted 5 years, 1 month ago
Correct - B
upvoted 16 times
...
Erg_de
Most Recent 5 months, 3 weeks 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
1 year, 4 months 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, 8 months ago
ANSWER b. FULL question ihave if you nee mail me neonitin6ATtherate......
upvoted 3 times
aryaavinash
1 year, 7 months ago
full email id please ?
upvoted 1 times
...
...
Oleksandr0501
2 years ago
Selected Answer: B
I think we need a pipeline, so it's B to me.))
upvoted 3 times
...
votinhluombikip
2 years ago
Selected Answer: B
I think we need a pipeline, so it's B to me.
upvoted 2 times
...
JANCAI
2 years, 1 month ago
Why the answer from the <reveal answer> is C??
upvoted 1 times
...
zellck
2 years, 4 months ago
Selected Answer: B
B is the answer.
upvoted 1 times
...
Prasha123
2 years, 5 months ago
Selected Answer: B
Need pipeline so its B
upvoted 1 times
...
sedado77
2 years, 7 months ago
Selected Answer: B
I got this question on sept 2022. Answer is B
upvoted 7 times
...
medeis_jar
3 years, 3 months ago
Selected Answer: B
omg. B only
upvoted 2 times
...
MaxNRG
3 years, 3 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
3 years, 4 months ago
Selected Answer: B
B, streaming with dataflow
upvoted 3 times
...
JG123
3 years, 5 months ago
Wrong answer shown again by examtopics.com Ans: B
upvoted 1 times
...
Ysance_AGS
3 years, 7 months ago
B => with dataflow you can parallelize data ingestion
upvoted 2 times
szefco
3 years, 5 months ago
And make it streaming
upvoted 1 times
...
...
sandipk91
3 years, 8 months ago
B is the right answer
upvoted 2 times
...
Load full discussion...
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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago