PROFESSIONAL-DATA-ENGINEER · Question #15
PROFESSIONAL-DATA-ENGINEER Question #15: Real Exam Question with Answer & Explanation
Sign in or unlock PROFESSIONAL-DATA-ENGINEER to reveal the answer and full explanation for question #15. The question stem and answer options stay visible for context.
Question
You need to store and analyze social media postings in Google BigQuery at a rate of 10,000 messages per minute in near real-time. Initially, design the application to use streaming inserts for individual postings. Your application also performs data aggregations right after the streaming inserts. You discover that the queries after streaming inserts do not exhibit strong consistency, and reports from the queries might miss in-flight data. How can you adjust your application design?
Options
- ARe-write the application to load accumulated data every 2 minutes.
- BConvert the streaming insert code to batch load for individual messages.
- CLoad the original message to Google Cloud SQL, and export the table every hour to BigQuery via streaming inserts.
- DEstimate the average latency for data availability after streaming inserts, and always run queries after waiting twice as long.
Unlock PROFESSIONAL-DATA-ENGINEER to see the answer
You've previewed enough free PROFESSIONAL-DATA-ENGINEER questions. Unlock PROFESSIONAL-DATA-ENGINEER for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.