Professional Data Engineer V1

MJTelco is building a custom interface to share data. They have these requirements: They need to do aggregations over their petabyte-scale datasets. 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?A . Cloud Datastore...

You work for a manufacturing plant that batches application log files together into a single log file once a day at 2:00 AM. You have written a Google Cloud Dataflow job to process that log file. You need to make sure the log file in processed once per day as...

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

Does Dataflow process batch data pipelines or streaming data pipelines?A . Only Batch Data PipelinesB . Both Batch and Streaming Data PipelinesC . Only Streaming Data PipelinesD . None of the aboveView AnswerAnswer: B Explanation: Dataflow is a unified processing model, and can execute both streaming and batch data pipelines...

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

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

You are building a model to predict whether or not it will rain on a given day. You have thousands of input features and want to see if you can improve training speed by removing some features while having a minimum effect on model accuracy. What can you do?A ....

You work for a large fast food restaurant chain with over 400,000 employees. You store employee information in Google BigQuery in a Users table consisting of a FirstName field and a LastName field. A member of IT is building an application and asks you to modify the schema and data...

An external customer provides you with a daily dump of data from their database. The data flows into Google Cloud Storage GCS as comma-separated values (CSV) files. You want to analyze this data in Google BigQuery, but the data could have rows that are formatted incorrectly or corrupted. How should...

Which of the following statements about Legacy SQL and Standard SQL is not true?A . Standard SQL is the preferred query language for BigQuery.B . If you write a query in Legacy SQL, it might generate an error if you try to run it with Standard SQL.C . One difference...