Free Google Professional Data Engineer Exam Practice Questions

A.  

The HBase shell is a GUI based interface that performs administrative tasks, such as creating and deleting tables.

B.  

The HBase shell is a command-line tool that performs administrative tasks, such as creating and deleting tables.

C.  

The HBase shell is a hypervisor based shell that performs administrative tasks, such as creating and deleting new virtualized instances.

D.  

The HBase shell is a command-line tool that performs only user account management functions to grant access to Cloud Bigtable instances.

A.  

Apache Spark

B.  

Apache Hadoop

C.  

Apache Kafka

D.  

Apache Beam

A.  

Upload a file in SQL format.

B.  

Load data with nested and repeated fields.

C.  

Upload a 20 MB file.

D.  

Upload multiple files using a wildcard.

A.  

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.

B.  

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".

C.  

Create a partitioned table and stream new records to it every day.

D.  

Use ORDER BY to put a table's rows into chronological order and then change the table's type to "Partitioned".

A.  

Workers

B.  

Masters, workers, and parameter servers

C.  

Workers and parameter servers

D.  

Parameter servers

A.  

A sequential numeric ID

B.  

A timestamp followed by a stock symbol

C.  

A non-sequential numeric ID

D.  

A stock symbol followed by a timestamp

A.  

Cancel

B.  

Drain

C.  

Stop

D.  

Finish

A.  

Hive

B.  

Pig

C.  

YARN

D.  

Spark

A.  

dataflow.worker

B.  

dataflow.compute

C.  

dataflow.developer

D.  

dataflow.viewer

A.  

By default, a query's results are not cached.

B.  

BigQuery caches query results for 48 hours.

C.  

Query results are cached even if you specify a destination table.

D.  

There is no charge for a query that retrieves its results from cache.