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

What are two methods that can be used to denormalize tables in BigQuery?A . 1) Split table into multiple tables; 2) Use a partitioned tableB . 1) Join tables into one table; 2) Use nested repeated fieldsC . 1) Use a partitioned table; 2) Join tables into one tableD ....

October 2, 2021 No Comments READ MORE +

Which of these operations can you perform from the BigQuery Web UI?

Which of these operations can you perform from the BigQuery Web UI?A . Upload a file in SQL format.B . Load data with nested and repeated fields.C . Upload a 20 MB file.D . Upload multiple files using a wildcard.View AnswerAnswer: B Explanation: You can load data with nested and...

October 2, 2021 No Comments READ MORE +

What should you do next?

Your software uses a simple JSON format for all messages. These messages are published to Google Cloud Pub/Sub, then processed with Google Cloud Dataflow to create a real-time dashboard for the CFO. During testing, you notice that some messages are missing in the dashboard. You check the logs, and all...

October 2, 2021 No Comments READ MORE +

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

October 2, 2021 No Comments READ MORE +

Which of these numbers are adjusted by a neural network as it learns from a training dataset (select 2 answers)?

Which of these numbers are adjusted by a neural network as it learns from a training dataset (select 2 answers)?A . WeightsB . BiasesC . Continuous featuresD . Input valuesView AnswerAnswer: A,B Explanation: A neural network is a simple mechanism that’s implemented with basic math. The only difference between the...

October 1, 2021 No Comments READ MORE +

How should you avoid a combinatorial explosion in the number of indexes?

You are deploying a new storage system for your mobile application, which is a media streaming service. You decide the best fit is Google Cloud Datastore. You have entities with multiple properties, some of which can take on multiple values. For example, in the entity ‘Movie’ the property ‘actors’ and...

October 1, 2021 No Comments READ MORE +

Which Google database service should you use?

You want to process payment transactions in a point-of-sale application that will run on Google Cloud Platform. Your user base could grow exponentially, but you do not want to manage infrastructure scaling. Which Google database service should you use?A . Cloud SQLB . BigQueryC . Cloud BigtableD . Cloud DatastoreView...

October 1, 2021 No Comments READ MORE +

What should you do?

Your company’s customer and order databases are often under heavy load. This makes performing analytics against them difficult without harming operations. The databases are in a MySQL cluster, with nightly backups taken using mysqldump. You want to perform analytics with minimal impact on operations. What should you do?A . Add...

October 1, 2021 No Comments READ MORE +

What is the most likely cause of this problem?

Your company is loading comma-separated values (CSV) files into Google BigQuery. The data is fully imported successfully; however, the imported data is not matching byte-to-byte to the source file. What is the most likely cause of this problem?A . The CSV data loaded in BigQuery is not flagged as CSC...

September 30, 2021 No Comments READ MORE +

To run a TensorFlow training job on your own computer using Cloud Machine Learning Engine, what would your command start with?

To run a TensorFlow training job on your own computer using Cloud Machine Learning Engine, what would your command start with?A . gcloud ml-engine local trainB . gcloud ml-engine jobs submit trainingC . gcloud ml-engine jobs submit training localD . You can't run a TensorFlow program on your own computer...

September 30, 2021 No Comments READ MORE +