Summer Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: ecus65

Google Professional-Data-Engineer - Google Professional Data Engineer Exam

Google Professional-Data-Engineer Premium Access     Download Demo    
Page: 1 / 8
Total 383 questions

Suppose you have a table that includes a nested column called "city" inside a column called "person", but when you try to submit the following query in BigQuery, it gives you an error.

SELECT person FROM `project1.example.table1` WHERE city = "London"

How would you correct the error?

A.

Add ", UNNEST(person)" before the WHERE clause.

B.

Change "person" to "person.city".

C.

Change "person" to "city.person".

D.

Add ", UNNEST(city)" before the WHERE clause.

MJTelco is building a custom interface to share data. They have these requirements:

They need to do aggregations over their petabyte-scale datasets.

They need to scan specific time range rows with a very fast response time (milliseconds).

Which combination of Google Cloud Platform products should you recommend?

A.

Cloud Datastore and Cloud Bigtable

B.

Cloud Bigtable and Cloud SQL

C.

BigQuery and Cloud Bigtable

D.

BigQuery and Cloud Storage

Which of these operations can you perform from the BigQuery Web UI?

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.

Which of the following is not possible using primitive roles?

A.

Give a user viewer access to BigQuery and owner access to Google Compute Engine instances.

B.

Give UserA owner access and UserB editor access for all datasets in a project.

C.

Give a user access to view all datasets in a project, but not run queries on them.

D.

Give GroupA owner access and GroupB editor access for all datasets in a project.

What Dataflow concept determines when a Window's contents should be output based on certain criteria being met?

A.

Sessions

B.

OutputCriteria

C.

Windows

D.

Triggers

What is the general recommendation when designing your row keys for a Cloud Bigtable schema?

A.

Include multiple time series values within the row key

B.

Keep the row keep as an 8 bit integer

C.

Keep your row key reasonably short

D.

Keep your row key as long as the field permits

What is the HBase Shell for Cloud Bigtable?

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.

What are two methods that can be used to denormalize tables in BigQuery?

A.

1) Split table into multiple tables; 2) Use a partitioned table

B.

1) Join tables into one table; 2) Use nested repeated fields

C.

1) Use a partitioned table; 2) Join tables into one table

D.

1) Use nested repeated fields; 2) Use a partitioned table

Which of the following IAM roles does your Compute Engine account require to be able to run pipeline jobs?

A.

dataflow.worker

B.

dataflow.compute

C.

dataflow.developer

D.

dataflow.viewer

When you design a Google Cloud Bigtable schema it is recommended that you _________.

A.

Avoid schema designs that are based on NoSQL concepts

B.

Create schema designs that are based on a relational database design

C.

Avoid schema designs that require atomicity across rows

D.

Create schema designs that require atomicity across rows