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

Professional-Data-Engineer Google Professional Data Engineer Exam is now Stable and With Pass Result | Test Your Knowledge for Free

Professional-Data-Engineer Practice Questions

Google Professional Data Engineer Exam

Last Update 1 day ago
Total Questions : 400

Dive into our fully updated and stable Professional-Data-Engineer practice test platform, featuring all the latest Google Cloud Certified exam questions added this week. Our preparation tool is more than just a Google study aid; it's a strategic advantage.

Our free Google Cloud Certified practice questions crafted to reflect the domains and difficulty of the actual exam. The detailed rationales explain the 'why' behind each answer, reinforcing key concepts about Professional-Data-Engineer. Use this test to pinpoint which areas you need to focus your study on.

Professional-Data-Engineer PDF

Professional-Data-Engineer PDF (Printable)
$43.75
$124.99

Professional-Data-Engineer Testing Engine

Professional-Data-Engineer PDF (Printable)
$50.75
$144.99

Professional-Data-Engineer PDF + Testing Engine

Professional-Data-Engineer PDF (Printable)
$63.7
$181.99
Question # 1

Which of the following is NOT true about Dataflow pipelines?

Options:

A.  

Dataflow pipelines are tied to Dataflow, and cannot be run on any other runner

B.  

Dataflow pipelines can consume data from other Google Cloud services

C.  

Dataflow pipelines can be programmed in Java

D.  

Dataflow pipelines use a unified programming model, so can work both with streaming and batch data sources

Discussion 0
Question # 2

Flowlogistic wants to use Google BigQuery as their primary analysis system, but they still have Apache Hadoop and Spark workloads that they cannot move to BigQuery. Flowlogistic does not know how to store the data that is common to both workloads. What should they do?

Options:

A.  

Store the common data in BigQuery as partitioned tables.

B.  

Store the common data in BigQuery and expose authorized views.

C.  

Store the common data encoded as Avro in Google Cloud Storage.

D.  

Store he common data in the HDFS storage for a Google Cloud Dataproc cluster.

Discussion 0
Question # 3

You work for an economic consulting firm that helps companies identify economic trends as they happen. As part of your analysis, you use Google BigQuery to correlate customer data with the average prices of the 100 most common goods sold, including bread, gasoline, milk, and others. The average prices of these goods are updated every 30 minutes. You want to make sure this data stays up to date so you can combine it with other data in BigQuery as cheaply as possible. What should you do?

Options:

A.  

Load the data every 30 minutes into a new partitioned table in BigQuery.

B.  

Store and update the data in a regional Google Cloud Storage bucket and create a federated data source in BigQuery

C.  

Store the data in Google Cloud Datastore. Use Google Cloud Dataflow to query BigQuery and combine the data programmatically with the data stored in Cloud Datastore

D.  

Store the data in a file in a regional Google Cloud Storage bucket. Use Cloud Dataflow to query BigQuery and combine the data programmatically with the data stored in Google Cloud Storage.

Discussion 0
Question # 4

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?

Options:

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.

Discussion 0
Question # 5

You are choosing a NoSQL database to handle telemetry data submitted from millions of Internet-of-Things (IoT) devices. The volume of data is growing at 100 TB per year, and each data entry has about 100 attributes. The data processing pipeline does not require atomicity, consistency, isolation, and durability (ACID). However, high availability and low latency are required.

You need to analyze the data by querying against individual fields. Which three databases meet your requirements? (Choose three.)

Options:

A.  

Redis

B.  

HBase

C.  

MySQL

D.  

MongoDB

E.  

Cassandra

F.  

HDFS with Hive

Discussion 0
Question # 6

You have Google Cloud Dataflow streaming pipeline running with a Google Cloud Pub/Sub subscription as the source. You need to make an update to the code that will make the new Cloud Dataflow pipeline incompatible with the current version. You do not want to lose any data when making this update. What should you do?

Options:

A.  

Update the current pipeline and use the drain flag.

B.  

Update the current pipeline and provide the transform mapping JSON object.

C.  

Create a new pipeline that has the same Cloud Pub/Sub subscription and cancel the old pipeline.

D.  

Create a new pipeline that has a new Cloud Pub/Sub subscription and cancel the old pipeline.

Discussion 0
Question # 7

To give a user read permission for only the first three columns of a table, which access control method would you use?

Options:

A.  

Primitive role

B.  

Predefined role

C.  

Authorized view

D.  

It's not possible to give access to only the first three columns of a table.

Discussion 0
Question # 8

Which Google Cloud Platform service is an alternative to Hadoop with Hive?

Options:

A.  

Cloud Dataflow

B.  

Cloud Bigtable

C.  

BigQuery

D.  

Cloud Datastore

Discussion 0
Question # 9

In order to securely transfer web traffic data from your computer's web browser to the Cloud Dataproc cluster you should use a(n) _____.

Options:

A.  

VPN connection

B.  

Special browser

C.  

SSH tunnel

D.  

FTP connection

Discussion 0
Question # 10

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

Options:

A.  

Sessions

B.  

OutputCriteria

C.  

Windows

D.  

Triggers

Discussion 0
Get Professional-Data-Engineer dumps and pass your exam in 24 hours!

Free Exams Sample Questions