Your Company's Customer and Order Databases Are Often Under Heavy

question 4

Multiple Choice

Your company's customer and order databases are often under heavy load. This makes performing analytics against them difficult without harming operations. The databases are in a MySQL cluster, with nightly backups taken using mysqldump. You want to perform analytics with minimal impact on operations. What should you do?

• A) Add a node to the MySQL cluster and build an OLAP cube there.
• B) Use an ETL tool to load the data from MySQL into Google BigQuery.
• C) Connect an on-premises Apache Hadoop cluster to MySQL and perform ETL.
• D) Mount the backups to Google Cloud SQL, and then process the data using Google Cloud Dataproc.

---

Definitions:

Research And Development Stage

A phase in product development focusing on experimentation, exploration, and innovation to create new products or improve existing ones.

Venture Growth

This describes the expansion and scaling process of a new business endeavor, focusing on increasing size, revenue, and market presence.

Entrepreneurial Leaders

Individuals who combine the vision and innovation of an entrepreneur with leadership skills to develop, organize, and manage a business.

Good Performance

The achievement of a set of standards or goals, often measured by productivity, efficiency, and quality, in any given task or job.