You Operate a Database That Stores Stock Trades and an Application

question 223

Multiple Choice

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?

• A) Change the row key syntax in your Cloud Bigtable table to begin with the stock symbol.
• B) Change the row key syntax in your Cloud Bigtable table to begin with a random number per second.
• C) Change the data pipeline to use BigQuery for storing stock trades, and update your application.
• D) Use Cloud Dataflow to write summary of each day's stock trades to an Avro file on Cloud Storage. Update your application to read from Cloud Storage and Cloud Bigtable to compute the responses.

Describe the properties and uses of stem-and-leaf plots.

Understand the concept and calculation of relative frequency.

Describe methods and considerations in constructing relative frequency histograms.

Differentiate between types of descriptive statistical methods and their applications.

---

Definitions:

Reticular Activating System

A network of neurons located in the brainstem that is crucial for regulating wakefulness and sleep-wake transitions.

Biological Explanations

Explores the physiological and genetic underpinnings of behavior and mental processes.

Introvert

An individual who tends to be inward-turning, focusing on internal thoughts, feelings, and moods rather than seeking external stimulation.

Overaroused

A state of heightened physiological and psychological activity, often leading to anxiety or restlessness.