Free Professional Data Engineer Exam Braindumps (page: 23)

Page 22 of 68

Which SQL keyword can be used to reduce the number of columns processed by BigQuery?

  1. BETWEEN
  2. WHERE
  3. SELECT
  4. LIMIT

Answer(s): C

Explanation:

SELECT allows you to query specific columns rather than the whole table. LIMIT, BETWEEN, and WHERE clauses will not reduce the number of columns processed by
BigQuery.


Reference:

https://cloud.google.com/bigquery/launch- checklist#architecture_design_and_development_checklist



Which of these statements about exporting data from BigQuery is false?

  1. To export more than 1 GB of data, you need to put a wildcard in the destination filename.
  2. The only supported export destination is Google Cloud Storage.
  3. Data can only be exported in JSON or Avro format.
  4. The only compression option available is GZIP.

Answer(s): C

Explanation:

Data can be exported in CSV, JSON, or Avro format. If you are exporting nested or repeated data, then CSV format is not supported.


Reference:

https://cloud.google.com/bigquery/docs/exporting-data



What is the HBase Shell for Cloud Bigtable?

  1. The HBase shell is a GUI based interface that performs administrative tasks, such as creating and deleting tables.
  2. The HBase shell is a command-line tool that performs administrative tasks, such as creating and deleting tables.
  3. The HBase shell is a hypervisor based shell that performs administrative tasks, such as creating and deleting new virtualized instances.
  4. The HBase shell is a command-line tool that performs only user account management functions to grant access to Cloud Bigtable instances.

Answer(s): B

Explanation:

The HBase shell is a command-line tool that performs administrative tasks, such as creating and deleting tables. The Cloud Bigtable HBase client for Java makes it possible to use the HBase shell to connect to Cloud Bigtable.


Reference:

https://cloud.google.com/bigtable/docs/installing-hbase-shell



Which of these sources can you not load data into BigQuery from?

  1. File upload
  2. Google Drive
  3. Google Cloud Storage
  4. Google Cloud SQL

Answer(s): D

Explanation:

You can load data into BigQuery from a file upload, Google Cloud Storage, Google Drive, or Google Cloud Bigtable. It is not possible to load data into BigQuery directly from Google Cloud SQL. One way to get data from Cloud SQL to BigQuery would be to export data from Cloud SQL to Cloud Storage and then load it from there.


Reference:

https://cloud.google.com/bigquery/loading-data






Post your Comments and Discuss Google Professional Data Engineer exam with other Community members:

Professional Data Engineer Exam Discussions & Posts