Google Data Engineer Sample Questions:
1. Which Google Cloud Platform service is an alternative to Hadoop with Hive?
A) BigQuery
B) Cloud Datastore
C) Cloud Bigtable
D) Cloud Dataflow
2. What are the minimum permissions needed for a service account used with Google Dataproc?
A) Execute to Google Cloud Storage; write to Google Cloud Logging
B) Read and write to Google Cloud Storage; write to Google Cloud Logging
C) Execute to Google Cloud Storage; execute to Google Cloud Logging
D) Write to Google Cloud Storage; read to Google Cloud Logging
3. Which of the following is NOT one of the three main types of triggers that Dataflow supports?
A) Trigger based on time
B) Trigger based on element size in bytes
C) Trigger based on element count
D) Trigger that is a combination of other triggers
4. You work for a global shipping company. You want to train a model on 40 TB of data to predict which ships in each geographic region are likely to cause delivery delays on any given day. The model will be based on multiple attributes collected from multiple sources. Telemetry data, including location in GeoJSON format, will be pulled from each ship and loaded every hour. You want to have a dashboard that shows how many and which ships are likely to cause delays within a region. You want to use a storage solution that has native functionality for prediction and geospatial processing. Which storage solution should you use?
A) BigQuery
B) Cloud Datastore
C) Cloud Bigtable
D) Cloud SQL for PostgreSQL
5. Which of these is not a supported method of putting data into a partitioned table?
A) Create a partitioned table and stream new records to it every day.
B) If you have existing data in a separate file for each day, then create a partitioned table and upload each file into the appropriate partition.
C) Run a query to get the records for a specific day from an existing table and for the destination table, specify a partitioned table ending with the day in the format "$YYYYMMDD".
D) Use ORDER BY to put a table's rows into chronological order and then change the table's type to "Partitioned".
Solutions:
| Question # 1 Answer: A | Question # 2 Answer: B | Question # 3 Answer: B | Question # 4 Answer: A | Question # 5 Answer: D |
We're so confident of our products that we provide no hassle product exchange.


By Rex

