Free GCP-DE Questions for Google GCP-DE Exam

Question #1

You work for a large fast food restaurant chain with over 400,000 employees. You store employee information in Google BigQuery in a Users table consisting of a FirstName field and a LastName field. A member of IT is building an application and asks you to modify the schema and data in BigQuery so the application can query a FullName field consisting of the value of the FirstName field concatenated with a space, followed by the value of the LastName field for each employee. How can you make that data available while minimizing cost?

A. Create a Google Cloud Dataproc job to process the CSV file and output a new CSV file containing the proper values for FirstName, LastName and FullNam G. Run a BigQuery load job to load the new CSV file into BigQuery.

B. Use BigQuery to export the data for the table to a CSV fil

C. Add a new column called FullName to the Users tabl

D. Create a Google Cloud Dataflow job that queries BigQuery for the entire Users table, concatenates the FirstName value and LastName value for each user, and loads the proper values for FirstName, LastName, and FullName into a new table in BigQuery.

E. Create a view in BigQuery that concatenates the FirstName and LastName field values to produce the FullName.

F. Run an UPDATE statement that updates the FullName column for each user with the concatenation of the FirstName and LastName values.

Discussion 0

Correct Answer: F Vote an answer

Question #2

You are planning to use Google's Dataflow SDK to analyze customer data such as displayed below. Your project requirement is to extract only the customer name Passing Certification Exams Made Easy visit - https://www.2PassEasy.com from the data source and then write to an output PCollection.
Tom,555 X street Tim,553 Y street Sam, 111 Z street
Which operation is best suited for the above data processing requirement?

A. Source API

B. ParDo

C. Data extraction

D. Sink API

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Question #3

You work for a shipping company that uses handheld scanners to read shipping labels. Your company has strict data privacy standards that require scanners to only transmit recipients' personally identifiable information (PII) to analytics systems, which violates user privacy rules. You want to quickly build a scalable solution using cloud-native managed services to prevent exposure of PII to the analytics systems. What should you do?

A. Create an authorized view in BigQuery to restrict access to tables with sensitive data.

B. Install a third-party data validation tool on Compute Engine virtual machines to check the incoming data for sensitive information.

C. Build a Cloud Function that reads the topics and makes a call to the Cloud Data Loss Prevention AP

D. Use the tagging and confidence levels to either pass or quarantine the data in a bucket for review.

E. Use Stackdriver logging to analyze the data passed through the total pipeline to identify transactions that may contain sensitive information.

Discussion 0

Correct Answer: A Vote an answer

Question #4

Question #5

The YARN ResourceManager and the HDFS NameNode interfaces are available on a Cloud Dataproc cluster .

A. worker node

B. master node

C. application node

D. conditional node

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Question #6

Which of the following is NOT true about Dataflow pipelines?

A. Dataflow pipelines can consume data from other Google Cloud services

B. Dataflow pipelines can be programmed in Java

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

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

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Question #7

Which is not a valid reason for poor Cloud Bigtable performance?

A. The workload isn't appropriate for Cloud Bigtable.

B. The Cloud Bigtable cluster has too many nodes.

C. The table's schema is not designed correctly.

D. There are issues with the network connection.

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Question #8

When a Cloud Bigtable node fails, is lost.

A. no data

B. the time dimension

C. all data

D. the last transaction

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Free GCP-DE Questions for Google Data Engineer GCP-DE Exam as PDF & Practice Test Engine

Download Free Google GCP-DE Demo