Google Cloud Certified Professional Data Engineer Dumps - Practice Questions - Post 20
1. Which action can a Cloud Dataproc Viewer perform?
Page: Page 23
Option A: Submit a job.
Option B: Create a cluster.
Option C: Delete a cluster.
Option D: List the jobs.
Answer(s):
Explanation:
SEO Keywords: SEO keywords not available
2. How would you query specific partitions in a BigQuery table?
Page: Page 23
Option A: Use the DAY column in the WHERE clause
Option B: Use the EXTRACT(DAY) clause
Option C: Use the __PARTITIONTIME pseudo-column in the WHERE clause
Option D: Use DATE BETWEEN in the WHERE clause
Answer(s):
Explanation:
SEO Keywords: SEO keywords not available
3. 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?
Page: Page 24
Option A: 1 continuous and 2 categorical
Option B: 3 categorical
Option C: 3 continuous
Option D: 2 continuous and 1 categorical
Answer(s):
Explanation:
SEO Keywords: SEO keywords not available
4. What are the minimum permissions needed for a service account used with Google Dataproc?
Page: Page 24
Option A: Execute to Google Cloud Storage; write to Google Cloud Logging
Option B: Write to Google Cloud Storage; read to Google Cloud Logging
Option C: Execute to Google Cloud Storage; execute to Google Cloud Logging
Option D: Read and write to Google Cloud Storage; write to Google Cloud Logging
Answer(s):
Explanation:
SEO Keywords: SEO keywords not available
5. Dataproc clusters contain many configuration files. To update these files, you will need to use the --properties option. The format for the option is: file_prefix:property=_____.
Page: Page 24
Option A: details
Option B: value
Option C: null
Option D: id
Answer(s):
Explanation:
SEO Keywords: SEO keywords not available
6. 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?
Page: Page 24
Option A: ParDo
Option B: Sink API
Option C: Source API
Option D: Data extraction
Answer(s):
Explanation:
SEO Keywords: SEO keywords not available
7. Which of these are examples of a value in a sparse vector? (Select 2 answers.)
Page: Page 25
Option A: [0, 5, 0, 0, 0, 0]
Option B: [0, 0, 0, 1, 0, 0, 1]
Option C: [0, 1]
Option D: [1, 0, 0, 0, 0, 0, 0]
Answer(s):
Explanation:
SEO Keywords: SEO keywords not available
8. Which software libraries are supported by Cloud Machine Learning Engine?
Page: Page 25
Option A: Theano and TensorFlow
Option B: Theano and Torch
Option C: TensorFlow
Option D: TensorFlow and Torch
Answer(s):
Explanation:
SEO Keywords: SEO keywords not available
9. Which of the following statements about Legacy SQL and Standard SQL is not true?
Page: Page 25
Option A: Standard SQL is the preferred query language for BigQuery.
Option B: If you write a query in Legacy SQL, it might generate an error if you try to run it with Standard SQL.
Option C: One difference between the two query languages is how you specify fully-qualified table names (i.e. table names that include their associated project name).
Option D: You need to set a query language for each dataset and the default is Standard SQL.
Answer(s):
Explanation:
SEO Keywords: SEO keywords not available
10. Which of these is not a supported method of putting data into a partitioned table?
Page: Page 25
Option A: If you have existing data in a separate file for each day, then create a partitioned table and upload each file into the appropriate partition.
Option B: Run a query to get the records for a specific day from an existing table and for the destination table, specify a partitioned table ending with the day in the format "$YYYYMMDD".
Option C: Create a partitioned table and stream new records to it every day.
Option D: Use ORDER BY to put a table's rows into chronological order and then change the table's type to "Partitioned".
Answer(s):
Explanation:
SEO Keywords: SEO keywords not available
11. 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?
Page: Page 26
Option A: Add ", UNNEST(person)" before the WHERE clause.
Option B: Change "person" to "person.city".
Option C: Change "person" to "city.person".
Option D: Add ", UNNEST(city)" before the WHERE clause.
Answer(s):
Explanation:
SEO Keywords: SEO keywords not available
12. Which of these statements about BigQuery caching is true?
Page: Page 26
Option A: By default, a query's results are not cached.
Option B: BigQuery caches query results for 48 hours.
Option C: Query results are cached even if you specify a destination table.
Option D: There is no charge for a query that retrieves its results from cache.
Answer(s):
Explanation:
SEO Keywords: SEO keywords not available
13. Which Google Cloud Platform service is an alternative to Hadoop with Hive?
Page: Page 26
Option A: Cloud Dataflow
Option B: Cloud Bigtable
Option C: BigQuery
Option D: Cloud Datastore
Answer(s):
Explanation:
SEO Keywords: SEO keywords not available
14. What are all of the BigQuery operations that Google charges for?
Page: Page 26
Option A: Storage, queries, and streaming inserts
Option B: Storage, queries, and loading data from a file
Option C: Storage, queries, and exporting data
Option D: Queries and streaming inserts
Answer(s):
Explanation:
SEO Keywords: SEO keywords not available
15. When using Cloud Dataproc clusters, you can access the YARN web interface by configuring a browser to connect through a ____ proxy.
Page: Page 27
Option A: HTTPS
Option B: VPN
Option C: SOCKS
Option D: HTTP
Answer(s):
Explanation:
SEO Keywords: SEO keywords not available
16. In order to securely transfer web traffic data from your computer's web browser to the Cloud Dataproc cluster you should use a(n) _____.
Page: Page 27
Option A: VPN connection
Option B: Special browser
Option C: SSH tunnel
Option D: FTP connection
Answer(s):
Explanation:
SEO Keywords: SEO keywords not available
17. Which of the following is NOT one of the three main types of triggers that Dataflow supports?
Page: Page 27
Option A: Trigger based on element size in bytes
Option B: Trigger that is a combination of other triggers
Option C: Trigger based on element count
Option D: Trigger based on time
Answer(s):
Explanation:
SEO Keywords: SEO keywords not available
18. Does Dataflow process batch data pipelines or streaming data pipelines?
Page: Page 27
Option A: Only Batch Data Pipelines
Option B: Both Batch and Streaming Data Pipelines
Option C: Only Streaming Data Pipelines
Option D: None of the above
Answer(s):
Explanation:
SEO Keywords: SEO keywords not available
19. Which of the following is not true about Dataflow pipelines?
Page: Page 28
Option A: Pipelines are a set of operations
Option B: Pipelines represent a data processing job
Option C: Pipelines represent a directed graph of steps
Option D: Pipelines can share data between instances
Answer(s):
Explanation:
SEO Keywords: SEO keywords not available
20. What are two of the benefits of using denormalized data structures in BigQuery?
Page: Page 28
Option A: Reduces the amount of data processed, reduces the amount of storage required
Option B: Increases query speed, makes queries simpler
Option C: Reduces the amount of storage required, increases query speed
Option D: Reduces the amount of data processed, increases query speed
Answer(s):
Explanation:
SEO Keywords: SEO keywords not available
21. Which of the following are examples of hyperparameters? (Select 2 answers.)
Page: Page 28
Option A: Number of hidden layers
Option B: Number of nodes in each hidden layer
Option C: Biases
Option D: Weights
Answer(s):
Explanation:
SEO Keywords: SEO keywords not available
22. What are two methods that can be used to denormalize tables in BigQuery?
Page: Page 28
Option A: 1) Split table into multiple tables; 2) Use a partitioned table
Option B: 1) Join tables into one table; 2) Use nested repeated fields
Option C: 1) Use a partitioned table; 2) Join tables into one table
Option D: 1) Use nested repeated fields; 2) Use a partitioned table
Answer(s):
Explanation:
SEO Keywords: SEO keywords not available
23. Which of these numbers are adjusted by a neural network as it learns from a training dataset (select 2 answers)?
Page: Page 29
Option A: Weights
Option B: Biases
Option C: Continuous features
Option D: Input values
Answer(s):
Explanation:
SEO Keywords: SEO keywords not available
24. Google Cloud Bigtable indexes a single value in each row. This value is called the _______.
Page: Page 29
Option A: primary key
Option B: unique key
Option C: row key
Option D: master key
Answer(s):
Explanation:
SEO Keywords: SEO keywords not available
25. Cloud Dataproc charges you only for what you really use with _____ billing.
Page: Page 29
Option A: month-by-month
Option B: minute-by-minute
Option C: week-by-week
Option D: hour-by-hour
Answer(s):
Explanation:
SEO Keywords: SEO keywords not available
26. What is the recommended action to do in order to switch between SSD and HDD storage for your Google Cloud Bigtable instance?
Page: Page 29
Option A: create a third instance and sync the data from the two storage types via batch jobs
Option B: export the data from the existing instance and import the data into a new instance
Option C: run parallel instances where one is HDD and the other is SDD
Option D: the selection is final and you must resume using the same storage type
Answer(s):
Explanation:
SEO Keywords: SEO keywords not available
27. Which row keys are likely to cause a disproportionate number of reads and/or writes on a particular node in a Bigtable cluster (select 2 answers)?
Page: Page 30
Option A: A sequential numeric ID
Option B: A timestamp followed by a stock symbol
Option C: A non-sequential numeric ID
Option D: A stock symbol followed by a timestamp
Answer(s):
Explanation:
SEO Keywords: SEO keywords not available
28. Which of these is NOT a way to customize the software on Dataproc cluster instances?
Page: Page 30
Option A: Set initialization actions
Option B: Modify configuration files using cluster properties
Option C: Configure the cluster using Cloud Deployment Manager
Option D: Log into the master node and make changes from there
Answer(s):
Explanation:
SEO Keywords: SEO keywords not available
29. Which of the following are feature engineering techniques? (Select 2 answers)
Page: Page 30
Option A: Hidden feature layers
Option B: Feature prioritization
Option C: Crossed feature columns
Option D: Bucketization of a continuous feature
Answer(s):
Explanation:
SEO Keywords: SEO keywords not available
30. How can you get a neural network to learn about relationships between categories in a categorical feature?
Page: Page 30
Option A: Create a multi-hot column
Option B: Create a one-hot column
Option C: Create a hash bucket
Option D: Create an embedding column
Answer(s):
Explanation:
SEO Keywords: SEO keywords not available
Post a Comment