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?

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...

September 20, 2024No CommentsREAD MORE +

Which of these sources can you not load data into BigQuery from?

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...

September 19, 2024No CommentsREAD MORE +

Which of the following are examples of hyperparameters? (Select 2 answers.)

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...

September 19, 2024No CommentsREAD MORE +

How should you design the pipeline?

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...

September 19, 2024No CommentsREAD MORE +

Which combination of GCP products should you choose?

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...

September 19, 2024No CommentsREAD MORE +

What is the most likely cause of these duplicate messages?

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...

September 19, 2024No CommentsREAD MORE +

What should you do?

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...

September 18, 2024No CommentsREAD MORE +

What should you do?

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...

September 17, 2024No CommentsREAD MORE +

Which table name will make the SQL statement work correctly?

Your company is using WHILECARD tables to query data across multiple tables with similar names. The SQL statement is currently failing with the following error: # Syntax error : Expected end of statement but got “-“ at [4:11] SELECT age FROM bigquery-public-data.noaa_gsod.gsod WHERE age != 99 AND_TABLE_SUFFIX = ‘1929’ ORDER...

September 16, 2024No CommentsREAD MORE +

Which methods can be used to reduce the number of rows processed by BigQuery?

Which methods can be used to reduce the number of rows processed by BigQuery?A . Splitting tables into multiple tables; putting data in partitionsB . Splitting tables into multiple tables; putting data in partitions; using the LIMIT clauseC . Putting data in partitions; using the LIMIT clauseD . Splitting tables...

September 15, 2024No CommentsREAD MORE +