Free Google GCP-DE Practice Test & Real Exam Questions, Page 4

Question #25

You have a data stored in BigQuery. The data in the BigQuery dataset must be highly available. You need to define a storage, backup, and recovery strategy of this data that minimizes cost. How should you configure the BigQuery table?

Discussion 0

Correct Answer: C Vote an answer

Question #26

You are operating a Cloud Dataflow streaming pipeline. The pipeline aggregates events from a Cloud Pub/Sub subscription source, within a window, and sinks the resulting aggregation to a Cloud Storage bucket. The source has consistent throughput. You want to monitor an alert on behavior of the pipeline with Cloud Stackdriver to ensure that it is processing dat a. Which Stackdriver alerts should you create?

A. An alert based on an increase of instance/storage/used_bytes for the source and a rate of change decrease of subscription/num_undelivered_messages for the destination

B. An alert based on a decrease of instance/storage/used_bytes for the source and a rate of change increase of subscription/num_undelivered_messages for the destination

C. An alert based on a decrease of subscription/num_undelivered_messages for the source and a rate of change increase of instance/storage/used_bytes for the destination

D. An alert based on an increase of subscription/num_undelivered_messages for the source and a rate of change decrease of instance/storage/used_bytes for the destination

Discussion 0

Correct Answer: D Vote an answer

Question #27

You architect a system to analyze seismic dat
a. Your extract, transform, and load (ETL) process runs as a series of MapReduce jobs on an Apache Hadoop cluster. The ETL process takes days to process a data set because some steps are computationally expensive. Then you discover that a sensor calibration step has been omitted. How should you change your ETL process to carry out sensor calibration systematically in the future?

A. Introduce a new MapReduce job to apply sensor calibration to raw data, and ensure all other MapReduce jobs are chained after this.

B. Add sensor calibration data to the output of the ETL process, and document that all users need to apply sensor calibration themselves.

C. Modify the transformMapReduce jobs to apply sensor calibration before they do anything else.

D. Develop an algorithm through simulation to predict variance of data output from the last MapReduce job based on calibration factors, and apply the correction to all data.

Discussion 0

Correct Answer: C Vote an answer

Question #28

You are creating a new pipeline in Google Cloud to stream IoT data from Cloud Pub/Sub through Cloud Dataflow to BigQuery. While previewing the data, you notice that roughly 2% of the data appears to be corrupt. You need to modify the Cloud Dataflow pipeline to filter out this corrupt data. What should you do?

A. Add a SideInput that returns a Boolean if the element is corrupt.

B. Add a ParDo transform in Cloud Dataflow to discard corrupt elements.

C. Add a GroupByKey transform in Cloud Dataflow to group all of the valid data together and discard the rest.

D. Add a Partition transform in Cloud Dataflow to separate valid data from corrupt data.

Discussion 0

Correct Answer: B Vote an answer

Question #29

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

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

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

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

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

Discussion 0

Correct Answer: A Vote an answer

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

Question #30

You have developed three data processing jobs. One executes a Cloud Dataflow pipeline that transforms data uploaded to Cloud Storage and writes results to BigQuery. The second ingests data from on-premises servers and uploads it to Cloud Storage. The third is a Cloud Dataflow pipeline that gets information from third-party data providers and uploads the information to Cloud Storage. You need to be able to schedule and monitor the execution of these three workflows and manually execute them when needed. What should you do?

A. Use Stackdriver Monitoring and set up an alert with a Webhook notification to trigger the jobs.

B. Set up cron jobs in a Compute Engine instance to schedule and monitor the pipelines using GCP API calls.

C. Create a Direct Acyclic Graph in Cloud Composer to schedule and monitor the jobs.

D. Develop an App Engine application to schedule and request the status of the jobs using GCP API calls.

Discussion 0

Correct Answer: B Vote an answer

Question #31

By default, which of the following windowing behavior does Dataflow apply to unbounded data sets?

A. Single, Global Window

B. Windows at every 100 MB of data

C. Windows at every 10 minutes

D. Windows at every 1 minute

Discussion 0

Correct Answer: A Vote an answer

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

Question #32

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

A. Keep your row key as long as the field permits

B. Keep the row keep as an 8 bit integer

C. Include multiple time series values within the row key

D. Keep your row key reasonably short

Discussion 0

Correct Answer: D Vote an answer

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

Free Google GCP-DE Practice Test & Real Exam Questions

Download Free Google GCP-DE Demo