You Need to Store and Analyze Social Media Postings in Google

question 137

Multiple Choice

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?

• A) Re-write the application to load accumulated data every 2 minutes.
• B) Convert the streaming insert code to batch load for individual messages.
• C) Load the original message to Google Cloud SQL, and export the table every hour to BigQuery via streaming inserts.
• D) Estimate the average latency for data availability after streaming inserts, and always run queries after waiting twice as long.

---

Definitions:

Timely Feedback

Prompt and relevant responses or evaluations provided soon after the occurrence of an action, intended to enhance understanding or performance.

Yield Ratios

Metrics used in recruitment to evaluate the effectiveness of the hiring process by comparing the number of applicants at various stages of the process to the number hired.

Cost Per Hire

A metric that calculates the total expenses involved in acquiring a new employee, including advertising, recruiting, and onboarding costs.

Forecasting

The process of making predictions about future events or trends based on data analysis and modeling.