Topic 1 Question 30
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?
Add a node to the MySQL cluster and build an OLAP cube there.
Use an ETL tool to load the data from MySQL into Google BigQuery.
Connect an on-premises Apache Hadoop cluster to MySQL and perform ETL.
Mount the backups to Google Cloud SQL, and then process the data using Google Cloud Dataproc.
ユーザの投票
コメント(17)
It is a GOOGLE exam. The answer won't be on-premise or OLAP cubes even if it is the easiest. The answer is B
👍 94HectorLeon20992020/12/07Answer: D Description: Easy and it won’t affect processing
👍 38[Removed]2020/03/27- 正解だと思う選択肢: B
Bigquery is most suitable for analytical purposes and the question is asking about 'minimal impact' on current DB
👍 3PrashantGupta16162022/12/26
シャッフルモード