Professional Data Engineer V2

Your startup has never implemented a formal security policy. Currently, everyone in the company has access to the datasets stored in Google BigQuery. Teams have freedom to use the service as they see fit, and they have not documented their use cases. You have been asked to secure the data...

You want to use Google Stackdriver Logging to monitor Google BigQuery usage. You need an instant notification to be sent to your monitoring tool when new data is appended to a certain table using an insert job, but you do not want to receive notifications for other tables. What should...

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?A . Unsupervised learningB . RegressorC . ClassifierD . Clustering estimatorView AnswerAnswer: B Explanation: Regression is the supervised learning task for...

Which of these sources can you not load data into BigQuery from?A . File uploadB . Google DriveC . Google Cloud StorageD . Google Cloud SQLView AnswerAnswer: D Explanation: You can load data into BigQuery from a file upload, Google Cloud Storage, Google Drive, or Google Cloud Bigtable. It is...

Which of the following are examples of hyperparameters? (Select 2 answers.)A . Number of hidden layersB . Number of nodes in each hidden layerC . BiasesD . WeightsView AnswerAnswer: AB Explanation: If model parameters are variables that get adjusted by training with existing data, your hyperparameters are the variables about...

You are designing a basket abandonment system for an ecommerce company. The system will send a message to a user based on these rules: - No interaction by the user on the site for 1 hour - Has added more than $30 worth of products to the basket - Has...

Flowlogistic’s management has determined that the current Apache Kafka servers cannot handle the data volume for their real-time inventory tracking system. You need to build a new system on Google Cloud Platform (GCP) that will feed the proprietary tracking software. The system must be able to ingest data from a...

You work for a car manufacturer and have set up a data pipeline using Google Cloud Pub/Sub to capture anomalous sensor events. You are using a push subscription in Cloud Pub/Sub that calls a custom HTTPS endpoint that you have created to take action of these anomalous events as they...

You work for an economic consulting firm that helps companies identify economic trends as they happen. As part of your analysis, you use Google BigQuery to correlate customer data with the average prices of the 100 most common goods sold, including bread, gasoline, milk, and others. The average prices of...

You have Google Cloud Dataflow streaming pipeline running with a Google Cloud Pub/Sub subscription as the source. You need to make an update to the code that will make the new Cloud Dataflow pipeline incompatible with the current version. You do not want to lose any data when making this...