PROFESSIONAL-DATA-ENGINEER · Question #202
PROFESSIONAL-DATA-ENGINEER Question #202: Real Exam Question with Answer & Explanation
Sign in or unlock PROFESSIONAL-DATA-ENGINEER to reveal the answer and full explanation for question #202. The question stem and answer options stay visible for context.
Question
You operate a database that stores stock trades and an application that retrieves average stock price for a given company over an adjustable window of time. The data is stored in Cloud Bigtable where the datetime of the stock trade is the beginning of the row key. Your application has thousands of concurrent users, and you notice that performance is starting to degrade as more stocks are added. What should you do to improve the performance of your application?
Options
- AChange the row key syntax in your Cloud Bigtable table to begin with the stock symbol.
- BChange the row key syntax in your Cloud Bigtable table to begin with a random number per second.
- CChange the data pipeline to use BigQuery for storing stock trades, and update your application.
- DUse Cloud Dataflow to write summary of each day's stock trades to an Avro file on Cloud Storage.
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.