πŸ”

PDE β€” questions

Page 4 of 18 Β· 341 total questions.

Topic 1 Β· Question 61

Your analytics team wants to build a simple statistical model to determine which customers are most likely to work with your company again, based on a few different metrics. They want to run the model on Apache Spark, using data housed in Google Cloud Storage, and you have recommended using Google Cloud Dataproc to execute this job. Testing has shown that this workload can run in approximately 30 minutes on a 15-node cluster, outputting the results into Google BigQuery. The plan is to run this workload weekly. How should you optimize the cluster for cost?

  • AMigrate the workload to Google Cloud Dataflow
  • BUse pre-emptible virtual machines (VMs) for the cluster (correct answer)
  • CUse a higher-memory node so that the job runs faster
  • DUse SSDs on the worker nodes so that the job can run faster
Reveal answer & explanation
Correct answer: B

The correct answer is B. Option B: Use pre-emptible virtual machines (VMs) for the cluster.

Topic 1 Β· Question 62

Your company receives both batch- and stream-based event data. You want to process the data using Google Cloud Dataflow over a predictable time period. However, you realize that in some instances data can arrive late or out of order. How should you design your Cloud Dataflow pipeline to handle data that is late or out of order?

  • ASet a single global window to capture all the data.
  • BSet sliding windows to capture all the lagged data.
  • CUse watermarks and timestamps to capture the lagged data. (correct answer)
  • DEnsure every datasource type (stream or batch) has a timestamp, and use the timestamps to define the logic for lagged data.
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: Use watermarks and timestamps to capture the lagged data.

Topic 1 Β· Question 63

You have some data, which is shown in the graphic below. The two dimensions are X and Y, and the shade of each dot represents what class it is. You want to classify this data accurately using a linear algorithm. To do this you need to add a synthetic feature. What should the value of that feature be?

  • AX2+Y2 (correct answer)
  • BX2
  • CY2
  • Dcos(X)
Reveal answer & explanation
Correct answer: A

The correct answer is A. Option A: X2+Y2.

Topic 1 Β· Question 64

You are integrating one of your internal IT applications and Google BigQuery, so users can query BigQuery from the application's interface. You do not want individual users to authenticate to BigQuery and you do not want to give them access to the dataset. You need to securely access BigQuery from your IT application. What should you do?

  • ACreate groups for your users and give those groups access to the dataset
  • BIntegrate with a single sign-on (SSO) platform, and pass each user's credentials along with the query request
  • CCreate a service account and grant dataset access to that account. Use the service account's private key to access the dataset (correct answer)
  • DCreate a dummy user and grant dataset access to that user. Store the username and password for that user in a file on the files system, and use those credentials to access the BigQuery dataset
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: Create a service account and grant dataset access to that account. Use the service account's private key to access the dataset

Explanation

A service account provides an identity for workloads to access Google Cloud APIs securely.

Topic 1 Β· Question 65

You are building a data pipeline on Google Cloud. You need to prepare data using a casual method for a machine-learning process. You want to support a logistic regression model. You also need to monitor and adjust for null values, which must remain real-valued and cannot be removed. What should you do?

  • AUse Cloud Dataprep to find null values in sample source data. Convert all nulls to 'none' using a Cloud Dataproc job.
  • BUse Cloud Dataprep to find null values in sample source data. Convert all nulls to 0 using a Cloud Dataprep job. (correct answer)
  • CUse Cloud Dataflow to find null values in sample source data. Convert all nulls to 'none' using a Cloud Dataprep job.
  • DUse Cloud Dataflow to find null values in sample source data. Convert all nulls to 0 using a custom script.
Reveal answer & explanation
Correct answer: B

The correct answer is B. Option B: Use Cloud Dataprep to find null values in sample source data. Convert all nulls to 0 using a Cloud Dataprep job.

Explanation

Dataprep visually explores, cleans, and prepares data for analysis with no code.

Topic 1 Β· Question 66

You set up a streaming data insert into a Redis cluster via a Kafka cluster. Both clusters are running on Compute Engine instances. You need to encrypt data at rest with encryption keys that you can create, rotate, and destroy as needed. What should you do?

  • ACreate a dedicated service account, and use encryption at rest to reference your data stored in your Compute Engine cluster instances as part of your API service calls.
  • BCreate encryption keys in Cloud Key Management Service. Use those keys to encrypt your data in all of the Compute Engine cluster instances. (correct answer)
  • CCreate encryption keys locally. Upload your encryption keys to Cloud Key Management Service. Use those keys to encrypt your data in all of the Compute Engine cluster instances.
  • DCreate encryption keys in Cloud Key Management Service. Reference those keys in your API service calls when accessing the data in your Compute Engine cluster instances.
Reveal answer & explanation
Correct answer: B

The correct answer is B. Option B: Create encryption keys in Cloud Key Management Service. Use those keys to encrypt your data in all of the Compute Engine cluster instances.

Explanation

Compute Engine provides configurable virtual machines when you need full control of the OS. This option meets the real-time / low-latency performance requirement.

Topic 1 Β· Question 67

You are developing an application that uses a recommendation engine on Google Cloud. Your solution should display new videos to customers based on past views. Your solution needs to generate labels for the entities in videos that the customer has viewed. Your design must be able to provide very fast filtering suggestions based on data from other customer preferences on several TB of data. What should you do?

  • ABuild and train a complex classification model with Spark MLlib to generate labels and filter the results. Deploy the models using Cloud Dataproc. Call the model from your application.
  • BBuild and train a classification model with Spark MLlib to generate labels. Build and train a second classification model with Spark MLlib to filter results to match customer preferences. Deploy the models using Cloud Dataproc. Call the models from your application.
  • CBuild an application that calls the Cloud Video Intelligence API to generate labels. Store data in Cloud Bigtable, and filter the predicted labels to match the user's viewing history to generate preferences. (correct answer)
  • DBuild an application that calls the Cloud Video Intelligence API to generate labels. Store data in Cloud SQL, and join and filter the predicted labels to match the user's viewing history to generate preferences.
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: Build an application that calls the Cloud Video Intelligence API to generate labels. Store data in Cloud Bigtable, and filter the predicted labels to match the user's viewing history to generate preferences.

Explanation

Cloud Bigtable is a managed, low-latency NoSQL wide-column store for very high-throughput workloads.

Topic 1 Β· Question 68

You are selecting services to write and transform JSON messages from Cloud Pub/Sub to BigQuery for a data pipeline on Google Cloud. You want to minimize service costs. You also want to monitor and accommodate input data volume that will vary in size with minimal manual intervention. What should you do?

  • AUse Cloud Dataproc to run your transformations. Monitor CPU utilization for the cluster. Resize the number of worker nodes in your cluster via the command line.
  • BUse Cloud Dataproc to run your transformations. Use the diagnose command to generate an operational output archive. Locate the bottleneck and adjust cluster resources.
  • CUse Cloud Dataflow to run your transformations. Monitor the job system lag with Stackdriver. Use the default autoscaling setting for worker instances. (correct answer)
  • DUse Cloud Dataflow to run your transformations. Monitor the total execution time for a sampling of jobs. Configure the job to use non-default Compute Engine machine types when needed.
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: Use Cloud Dataflow to run your transformations. Monitor the job system lag with Stackdriver. Use the default autoscaling setting for worker instances.

Explanation

Dataflow runs serverless Apache Beam pipelines for stream and batch data processing with autoscaling. Cloud Operations (formerly Stackdriver) provides monitoring, logging, and tracing for reliability.

Topic 1 Β· Question 69

Your infrastructure includes a set of YouTube channels. You have been tasked with creating a process for sending the YouTube channel data to Google Cloud for analysis. You want to design a solution that allows your world-wide marketing teams to perform ANSI SQL and other types of analysis on up-to-date YouTube channels log data. How should you set up the log data transfer into Google Cloud?

  • AUse Storage Transfer Service to transfer the offsite backup files to a Cloud Storage Multi-Regional storage bucket as a final destination. (correct answer)
  • BUse Storage Transfer Service to transfer the offsite backup files to a Cloud Storage Regional bucket as a final destination.
  • CUse BigQuery Data Transfer Service to transfer the offsite backup files to a Cloud Storage Multi-Regional storage bucket as a final destination.
  • DUse BigQuery Data Transfer Service to transfer the offsite backup files to a Cloud Storage Regional storage bucket as a final destination.
Reveal answer & explanation
Correct answer: A

The correct answer is A. Option A: Use Storage Transfer Service to transfer the offsite backup files to a Cloud Storage Multi-Regional storage bucket as a final destination.

Explanation

Cloud Storage provides durable, scalable object storage that is fully managed. Storage Transfer Service moves large datasets into Cloud Storage online with minimal effort.

Topic 1 Β· Question 70

You are designing storage for very large text files for a data pipeline on Google Cloud. You want to support ANSI SQL queries. You also want to support compression and parallel load from the input locations using Google recommended practices. What should you do?

  • ATransform text files to compressed Avro using Cloud Dataflow. Use BigQuery for storage and query.
  • BTransform text files to compressed Avro using Cloud Dataflow. Use Cloud Storage and BigQuery permanent linked tables for query. (correct answer)
  • CCompress text files to gzip using the Grid Computing Tools. Use BigQuery for storage and query.
  • DCompress text files to gzip using the Grid Computing Tools. Use Cloud Storage, and then import into Cloud Bigtable for query.
Reveal answer & explanation
Correct answer: B

The correct answer is B. Option B: Transform text files to compressed Avro using Cloud Dataflow. Use Cloud Storage and BigQuery permanent linked tables for query.

Explanation

Cloud Storage provides durable, scalable object storage that is fully managed. BigQuery is a serverless, petabyte-scale data warehouse for fast SQL analytics with no infrastructure to manage. Dataflow runs serverless Apache Beam pipelines for stream and batch data processing with autoscaling.

Topic 1 Β· Question 71

You are developing an application on Google Cloud that will automatically generate subject labels for users' blog posts. You are under competitive pressure to add this feature quickly, and you have no additional developer resources. No one on your team has experience with machine learning. What should you do?

  • ACall the Cloud Natural Language API from your application. Process the generated Entity Analysis as labels. (correct answer)
  • BCall the Cloud Natural Language API from your application. Process the generated Sentiment Analysis as labels.
  • CBuild and train a text classification model using TensorFlow. Deploy the model using Cloud Machine Learning Engine. Call the model from your application and process the results as labels.
  • DBuild and train a text classification model using TensorFlow. Deploy the model using a Kubernetes Engine cluster. Call the model from your application and process the results as labels.
Reveal answer & explanation
Correct answer: A

The correct answer is A. Option A: Call the Cloud Natural Language API from your application. Process the generated Entity Analysis as labels.

Explanation

Cloud NAT lets private instances reach the internet for outbound traffic without external IPs. Natural Language API extracts entities and sentiment from text.

Topic 1 Β· Question 72

You are designing storage for 20 TB of text files as part of deploying a data pipeline on Google Cloud. Your input data is in CSV format. You want to minimize the cost of querying aggregate values for multiple users who will query the data in Cloud Storage with multiple engines. Which storage service and schema design should you use?

  • AUse Cloud Bigtable for storage. Install the HBase shell on a Compute Engine instance to query the Cloud Bigtable data.
  • BUse Cloud Bigtable for storage. Link as permanent tables in BigQuery for query.
  • CUse Cloud Storage for storage. Link as permanent tables in BigQuery for query. (correct answer)
  • DUse Cloud Storage for storage. Link as temporary tables in BigQuery for query.
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: Use Cloud Storage for storage. Link as permanent tables in BigQuery for query.

Explanation

Cloud Storage provides durable, scalable object storage that is fully managed. BigQuery is a serverless, petabyte-scale data warehouse for fast SQL analytics with no infrastructure to manage.

Topic 1 Β· Question 73

You are designing storage for two relational tables that are part of a 10-TB database on Google Cloud. You want to support transactions that scale horizontally. You also want to optimize data for range queries on non-key columns. What should you do?

  • AUse Cloud SQL for storage. Add secondary indexes to support query patterns.
  • BUse Cloud SQL for storage. Use Cloud Dataflow to transform data to support query patterns.
  • CUse Cloud Spanner for storage. Add secondary indexes to support query patterns. (correct answer)
  • DUse Cloud Spanner for storage. Use Cloud Dataflow to transform data to support query patterns.
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: Use Cloud Spanner for storage. Add secondary indexes to support query patterns.

Explanation

Cloud Spanner is a horizontally scalable, strongly consistent relational database with global reach.

Topic 1 Β· Question 74

Your financial services company is moving to cloud technology and wants to store 50 TB of financial time-series data in the cloud. This data is updated frequently and new data will be streaming in all the time. Your company also wants to move their existing Apache Hadoop jobs to the cloud to get insights into this data. Which product should they use to store the data?

  • ACloud Bigtable (correct answer)
  • BGoogle BigQuery
  • CGoogle Cloud Storage
  • DGoogle Cloud Datastore
Reveal answer & explanation
Correct answer: A

The correct answer is A. Option A: Cloud Bigtable

Explanation

Cloud Bigtable is a managed, low-latency NoSQL wide-column store for very high-throughput workloads. This option meets the real-time / low-latency performance requirement.

Topic 1 Β· Question 75

An organization maintains a Google BigQuery dataset that contains tables with user-level data. They want to expose aggregates of this data to other Google Cloud projects, while still controlling access to the user-level data. Additionally, they need to minimize their overall storage cost and ensure the analysis cost for other projects is assigned to those projects. What should they do?

  • ACreate and share an authorized view that provides the aggregate results. (correct answer)
  • BCreate and share a new dataset and view that provides the aggregate results.
  • CCreate and share a new dataset and table that contains the aggregate results.
  • DCreate dataViewer Identity and Access Management (IAM) roles on the dataset to enable sharing.
Reveal answer & explanation
Correct answer: A

The correct answer is A. Option A: Create and share an authorized view that provides the aggregate results.

Topic 1 Β· Question 76

Government regulations in your industry mandate that you have to maintain an auditable record of access to certain types of data. Assuming that all expiring logs will be archived correctly, where should you store data that is subject to that mandate?

  • AEncrypted on Cloud Storage with user-supplied encryption keys. A separate decryption key will be given to each authorized user.
  • BIn a BigQuery dataset that is viewable only by authorized personnel, with the Data Access log used to provide the auditability. (correct answer)
  • CIn Cloud SQL, with separate database user names to each user. The Cloud SQL Admin activity logs will be used to provide the auditability.
  • DIn a bucket on Cloud Storage that is accessible only by an AppEngine service that collects user information and logs the access before providing a link to the bucket.
Reveal answer & explanation
Correct answer: B

The correct answer is B. Option B: In a BigQuery dataset that is viewable only by authorized personnel, with the Data Access log used to provide the auditability.

Explanation

BigQuery is a serverless, petabyte-scale data warehouse for fast SQL analytics with no infrastructure to manage.

Topic 1 Β· Question 77

Your neural network model is taking days to train. You want to increase the training speed. What can you do?

  • ASubsample your test dataset.
  • BSubsample your training dataset. (correct answer)
  • CIncrease the number of input features to your model.
  • DIncrease the number of layers in your neural network.
Reveal answer & explanation
Correct answer: B

The correct answer is B. Option B: Subsample your training dataset.

Topic 1 Β· Question 78

You are responsible for writing your company's ETL pipelines to run on an Apache Hadoop cluster. The pipeline will require some checkpointing and splitting pipelines. Which method should you use to write the pipelines?

  • APigLatin using Pig (correct answer)
  • BHiveQL using Hive
  • CJava using MapReduce
  • DPython using MapReduce
Reveal answer & explanation
Correct answer: A

The correct answer is A. Option A: PigLatin using Pig.

Topic 1 Β· Question 79

Your company maintains a hybrid deployment with GCP, where analytics are performed on your anonymized customer data. The data are imported to Cloud Storage from your data center through parallel uploads to a data transfer server running on GCP. Management informs you that the daily transfers take too long and have asked you to fix the problem. You want to maximize transfer speeds. Which action should you take?

  • AIncrease the CPU size on your server.
  • BIncrease the size of the Google Persistent Disk on your server.
  • CIncrease your network bandwidth from your datacenter to GCP. (correct answer)
  • DIncrease your network bandwidth from Compute Engine to Cloud Storage.
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: Increase your network bandwidth from your datacenter to GCP.

Topic 1 Β· Question 80

MJTelco Case Study - Company Overview - MJTelco is a startup that plans to build networks in rapidly growing, underserved markets around the world. The company has patents for innovative optical communications hardware. Based on these patents, they can create many reliable, high-speed backbone links with inexpensive hardware. Company Background - Founded by experienced telecom executives, MJTelco uses technologies originally developed to overcome communications challenges in space. Fundamental to their operation, they need to create a distributed data infrastructure that drives real-time analysis and incorporates machine learning to continuously optimize their topologies. Because their hardware is inexpensive, they plan to overdeploy the network allowing them to account for the impact of dynamic regional politics on location availability and cost. Their management and operations teams are situated all around the globe creating many-to-many relationship between data consumers and provides in their system. After careful consideration, they decided public cloud is the perfect environment to support their needs. Solution Concept - MJTelco is running a successful proof-of-concept (PoC) project in its labs. They have two primary needs: β€’ Scale and harden their PoC to support significantly more data flows generated when they ramp to more than 50,000 installations. β€’ Refine their machine-learning cycles to verify and improve the dynamic models they use to control topology definition. MJTelco will also use three separate operating environments `" development/test, staging, and production `" to meet the needs of running experiments, deploying new features, and serving production customers. Business Requirements - β€’ Scale up their production environment with minimal cost, instantiating resources when and where needed in an unpredictable, distributed telecom user community. β€’ Ensure security of their proprietary data to protect their leading-edge machine learning and analysis. β€’ Provide reliable and timely access to data for analysis from distributed research workers β€’ Maintain isolated environments that support rapid iteration of their machine-learning models without affecting their customers. Technical Requirements - Ensure secure and efficient transport and storage of telemetry data Rapidly scale instances to support between 10,000 and 100,000 data providers with multiple flows each. Allow analysis and presentation against data tables tracking up to 2 years of data storing approximately 100m records/day Support rapid iteration of monitoring infrastructure focused on awareness of data pipeline problems both in telemetry flows and in production learning cycles. CEO Statement - Our business model relies on our patents, analytics and dynamic machine learning. Our inexpensive hardware is organized to be highly reliable, which gives us cost advantages. We need to quickly stabilize our large distributed data pipelines to meet our reliability and capacity commitments. CTO Statement - Our public cloud services must operate as advertised. We need resources that scale and keep our data secure. We also need environments in which our data scientists can carefully study and quickly adapt our models. Because we rely on automation to process our data, we also need our development and test environments to work as we iterate. CFO Statement - The project is too large for us to maintain the hardware and software required for the data and analysis. Also, we cannot afford to staff an operations team to monitor so many data feeds, so we will rely on automation and infrastructure. Google Cloud's machine learning will allow our quantitative researchers to work on our high-value problems instead of problems with our data pipelines. MJTelco is building a custom interface to share data. They have these requirements: 1. They need to do aggregations over their petabyte-scale datasets. 2. They need to scan specific time range rows with a very fast response time (milliseconds). Which combination of Google Cloud Platform products should you recommend?

  • ACloud Datastore and Cloud Bigtable
  • BCloud Bigtable and Cloud SQL
  • CBigQuery and Cloud Bigtable (correct answer)
  • DBigQuery and Cloud Storage
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: BigQuery and Cloud Bigtable

Explanation

Cloud Bigtable is a managed, low-latency NoSQL wide-column store for very high-throughput workloads. BigQuery is a serverless, petabyte-scale data warehouse for fast SQL analytics with no infrastructure to manage. This option meets the real-time / low-latency performance requirement.

Showing questions 61–80 of 341 Β· Page 4 of 18