Question 287 of 307
Single answerYou created an analytics environment on Google Cloud so that your data scientist team can explore data without impacting the on-premises Apache Hadoop solution. The data in the on-premises Hadoop Distributed File System (HDFS) cluster is in Optimized Row Columnar (ORC) formatted files with multiple columns of Hive partitioning. The data scientist team needs to be able to explore the data in a similar way as they used the on-premises HDFS cluster with SQL on the Hive query engine. You need to choose the most cost-effective storage and processing solution. What should you do?
AImport the ORC files to Bigtable tables for the data scientist team.
BImport the ORC files to BigQuery tables for the data scientist team.
CCopy the ORC files on Cloud Storage, then deploy a Dataproc cluster for the data scientist team.
✓DCopy the ORC files on Cloud Storage, then create external BigQuery tables for the data scientist team.
✓
Correct Answer: D
Copy the ORC files on Cloud Storage, then create external BigQuery tables for the data scientist team.
▥
Explanation
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Google certification topics.