Google Professional Cloud Data Engineer PR000111 Practice Exam Part 2
gcp-examquestions2020-08-27T21:24:30+07:00Notes: Hi all, Google Professional Cloud Data Engineer Practice Exam will familiarize you with types of questions you may encounter on the certification exam and help you determine your readiness or if you need more preparation and/or experience. Successful completion of the practice exam does not guarantee you will pass the certification exam as the actual exam is longer and covers a wider range of topics. We highly recommend you should take Google Professional Cloud Data Engineer Guarantee Part because it includes real questions and highlighted answers are collected in our exam. It will help you pass the exam in an easier way.
For PDF Version: https://gcp-examquestions.com/gcp-pro-data-engineer-practice/
Part 1: gcp-pro-data-engineer-practice-exam-part-1
Part 2: gcp-pro-data-engineer-practice-exam-part-2
Part 3: gcp-pro-data-engineer-practice-exam-part-3
Quiz-summary
0 of 40 questions completed
Questions:
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- 37
- 38
- 39
- 40
Information
GCP-CLOUD-DATA-PART2
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading...
You must sign in or sign up to start the quiz.
You have to finish following quiz, to start this quiz:
Results
0 of 40 questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 points, (0)
Categories
- Not categorized 0%
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- 37
- 38
- 39
- 40
- Answered
- Review
- Question 1 of 40
1. Question
To give a user read permission for only the first three columns of a table, which access control method would you use?
CorrectIncorrectHint
Answer: C
- Question 2 of 40
2. Question
What are two methods that can be used to denormalize tables in BigQuery?
CorrectIncorrectHint
Answer: B
- Question 3 of 40
3. Question
Which of these is not a supported method of putting data into a partitioned table?
CorrectIncorrectHint
Answer: D
- Question 4 of 40
4. Question
Which of these operations can you perform from the BigQuery Web UI?
CorrectIncorrectHint
Answer: BD
- Question 5 of 40
5. Question
Which methods can be used to reduce the number of rows processed by BigQuery?
CorrectIncorrectHint
Answer: A
- Question 6 of 40
6. Question
Why do you need to split a machine learning dataset into training data and test data?
CorrectIncorrectHint
Answer: B
- Question 7 of 40
7. Question
Which of these numbers are adjusted by a neural network as it learns from a training dataset (select 2 answers)?
CorrectIncorrectHint
Answer: AB
- Question 8 of 40
8. Question
The CUSTOM tier for Cloud Machine Learning Engine allows you to specify the number of which types of cluster nodes?
CorrectIncorrectHint
Answer: C
- Question 9 of 40
9. Question
Which software libraries are supported by Cloud Machine Learning Engine?
CorrectIncorrectHint
Answer: C
- Question 10 of 40
10. Question
Which TensorFlow function can you use to configure a categorical column if you don’t know all of the possible values for that column?
CorrectIncorrectHint
Answer: B
- Question 11 of 40
11. Question
Which of the following statements about the Wide & Deep Learning model are true? (Select 2 answers.)
CorrectIncorrectHint
Answer: AB
- Question 12 of 40
12. Question
To run a TensorFlow training job on your own computer using Cloud Machine Learning Engine, what would your command start with?
CorrectIncorrectHint
Answer: A
- Question 13 of 40
13. Question
If you want to create a machine learning model that predicts the price of a particular stock based on its recent price history, what type of estimator should you use?
CorrectIncorrectHint
Answer: B
- Question 14 of 40
14. Question
Suppose you have a dataset of images that are each labeled as to whether or not they contain a human face. To create a neural network that recognizes human faces in images using this labeled dataset, what approach would likely be the most effective?
CorrectIncorrectHint
Answer: C
- Question 15 of 40
15. Question
What are two of the characteristics of using online prediction rather than batch prediction?
CorrectIncorrectHint
Answer: BD
- Question 16 of 40
16. Question
Which of these are examples of a value in a sparse vector? (Select 2 answers.)
CorrectIncorrectHint
Answer: CD
- Question 17 of 40
17. Question
How can you get a neural network to learn about relationships between categories in a categorical feature?
CorrectIncorrectHint
Answer: D
- Question 18 of 40
18. Question
If a dataset contains rows with individual people and columns for year of birth, country, and income, how many of the columns are continuous and how many are categorical?
CorrectIncorrectHint
Answer: D
- Question 19 of 40
19. Question
Which of the following are examples of hyperparameters? (Select 2 answers.)
CorrectIncorrectHint
Answer: AB
- Question 20 of 40
20. Question
Which of the following are feature engineering techniques? (Select 2 answers)
CorrectIncorrectHint
Answer: CD
- Question 21 of 40
21. Question
You want to use a BigQuery table as a data sink. In which writing mode(s) can you use BigQuery as a sink?
CorrectIncorrectHint
Answer: A
- Question 22 of 40
22. Question
You have a job that you want to cancel. It is a streaming pipeline, and you want to ensure that any data that is in-flight is processed and written to the output. Which of the following commands can you use on the Dataflow monitoring console to stop the pipeline job?
CorrectIncorrectHint
Answer: B
- Question 23 of 40
23. Question
When running a pipeline that has a BigQuery source, on your local machine, you continue to get permission denied errors. What could be the reason for that?
CorrectIncorrectHint
Answer: A
- Question 24 of 40
24. Question
What Dataflow concept determines when a Window’s contents should be output based on certain criteria being met?
CorrectIncorrectHint
Answer: D
- Question 25 of 40
25. Question
Which of the following is NOT one of the three main types of triggers that Dataflow supports?
CorrectIncorrectHint
Answer: A
- Question 26 of 40
26. Question
Which Java SDK class can you use to run your Dataflow programs locally?
CorrectIncorrectHint
Answer: B
- Question 27 of 40
27. Question
The Dataflow SDKs have been recently transitioned into which Apache service?
CorrectIncorrectHint
Answer: D
- Question 28 of 40
28. Question
The _________ for Cloud Bigtable makes it possible to use Cloud Bigtable in a Cloud Dataflow pipeline.
CorrectIncorrectHint
Answer: A
- Question 29 of 40
29. Question
Does Dataflow process batch data pipelines or streaming data pipelines?
CorrectIncorrectHint
Answer: B
- Question 30 of 40
30. Question
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 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?CorrectIncorrectHint
Answer: A
- Question 31 of 40
31. Question
Which Cloud Dataflow / Beam feature should you use to aggregate data in an unbounded data source every hour based on the time when the data entered the pipeline?
CorrectIncorrectHint
Answer: D
- Question 32 of 40
32. Question
Which of the following is NOT true about Dataflow pipelines?
CorrectIncorrectHint
Answer: A
- Question 33 of 40
33. Question
You are developing a software application using Google’s Dataflow SDK, and want to use conditional, for loops and other complex programming structures to create a branching pipeline. Which component will be used for the data processing operation?
CorrectIncorrectHint
Answer: B
- Question 34 of 40
34. Question
Which of the following IAM roles does your Compute Engine account require to be able to run pipeline jobs?
CorrectIncorrectHint
Answer: A
- Question 35 of 40
35. Question
Which of the following is not true about Dataflow pipelines?
CorrectIncorrectHint
Answer: D
- Question 36 of 40
36. Question
By default, which of the following windowing behavior does Dataflow apply to unbounded data sets?
CorrectIncorrectHint
Answer: B
- Question 37 of 40
37. Question
Which of the following job types are supported by Cloud Dataproc (select 3 answers)?
CorrectIncorrectHint
Answer: ABD
- Question 38 of 40
38. Question
What are the minimum permissions needed for a service account used with Google Dataproc?
CorrectIncorrectHint
Answer: D
- Question 39 of 40
39. Question
Which role must be assigned to a service account used by the virtual machines in a Dataproc cluster so they can execute jobs?
CorrectIncorrectHint
Answer: A
- Question 40 of 40
40. Question
When creating a new Cloud Dataproc cluster with the projects.regions.clusters.create operation, these four values are required: project, region, name, and ____.
CorrectIncorrectHint
Answer: A
Leave a Reply