You migrated ORC files to a Cloud Storage bucket and want to use Hive on a Dataproc cluster, optionally replicating data into HDFS for performance. Which two methods let you start using Hive on Dataproc? (Choose two.)
Choose an answer
Tap an option to check your answer.
Correct answer: Run gsutil to transfer all ORC files from the Cloud Storage bucket to the master node, then use Hadoop utilities to copy them into HDFS and mount the Hive tables from HDFS, Use the Cloud Storage connector for Hadoop to expose the ORC files as external Hive tables, and then replicate those external tables to native Hive tables.
Why this is the answer
The first correct method involves manually transferring the ORC files from Cloud Storage to the Dataproc cluster's HDFS. You would use gsutil to copy files to a master node, then hadoop fs -put to move them into HDFS. Once in HDFS, you can create Hive tables that point to these HDFS locations. This directly addresses the "replicate data into HDFS" requirement. The second correct method leverages the Cloud Storage connector for Hadoop, which is built into Dataproc. This allows Hive to directly read ORC files stored in Cloud Storage as external tables without needing to copy them into HDFS first. If replication to HDFS is desired for performance, you can then create native Hive tables from these external tables, effectively copying the data into HDFS. The incorrect options either suggest transferring files directly into HDFS using gsutil (which isn't how gsutil interacts with HDFS), copying to an arbitrary node (which doesn't guarantee HDFS integration), or using BigQuery, which is not directly related to using ORC files with Hive on Dataproc.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed