Practice Test 3 | Google Cloud Certified Professional Data Engineer | Dumps | Mock Test
A company uses Apache Hive for querying data of 200TB which resides in Google Storage. Apache Hive is installed in on-premise infrastructure.
A decision was made to stop maintaining the on-premise Hive cluster since it incurs outsourcing charges and to find a solution on Google Cloud to replace the Hive cluster as the data warehouse.
The migration should be done in a short time period and cost should be considered.
Which of the following approaches is the most appropriate for this?
A. Use BigQuery as the new data warehouse. Import data from Google Storage to BigQuery.
B. Use BigQuery as the new data warehouse. Create external tables referencing to data in Google Storage.
C. Use Dataproc as an alternative to the on-premise Apache Hive cluster.
D. Use Bigtable as the new data warehouse. Import data from Google Storage to Bigtable.
Correct Answer: B
Native tables in BigQuery are tables that import the full data inside Google BigQuery as you do in any other common database system. In contrast, external tables are tables that do not store the data in Google BigQuery, instead, reference the data from an external source, such as a data lake.
The advantages of creating external tables are that they are fast to create so you skip the part of importing data and no additional monthly billing storage costs are accrued to your account since you only get charged for the data that is stored in the data lake, which is comparatively cheaper than storing it in BigQuery.
Option A is incorrect: Importing data into BigQuery from Google Storage may take more time compared to creating external tables on data. Additional storage costs by BigQuery is another issue that can be more expensive than Google Storage.
Option C is incorrect: Using Dataproc we are still required to use Apache Hive. Our objective is to decommission Apache Hive. Hence this is not a correct solution
Option D is incorrect: Bigtable is not recommended for this scenario.
Source(s):
BigQuery – Introduction to external data sources:
Comments are closed, but trackbacks and pingbacks are open.