- All Exams Instant Download
You want to use a BigQuery table as a data sink. In which writing mode(s) can you use BigQuery as a sink?
You want to use a BigQuery table as a data sink. In which writing mode(s) can you use BigQuery as a sink?A . Both batch and streamingB . BigQuery cannot be used as a sinkC . Only batchD . Only streamingView AnswerAnswer: A Explanation: When you apply a BigQueryIO.Write transform...
Which of the following statements about Legacy SQL and Standard SQL is not true?
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...
What can you do?
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 ....
How should the row key be redesigned to improve Bigtable performance on queries that populate real-time dashboards?
Your company is streaming real-time sensor data from their factory floor into Bigtable and they have noticed extremely poor performance. How should the row key be redesigned to improve Bigtable performance on queries that populate real-time dashboards?A . Use a row key of the form <timestamp>.B . Use a row...
Which two actions should you take?
Your company produces 20,000 files every hour. Each data file is formatted as a comma separated values (CSV) file that is less than 4 KB. All files must be ingested on Google Cloud Platform before they can be processed. Your company site has a 200 ms latency to Google Cloud,...
What should you do?
You are deploying 10,000 new Internet of Things devices to collect temperature data in your warehouses globally. You need to process, store and analyze these very large datasets in real time. What should you do?A . Send the data to Google Cloud Datastore and then export to BigQuery.B . Send...
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 ....
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...
By default, which of the following windowing behavior does Dataflow apply to unbounded data sets?
By default, which of the following windowing behavior does Dataflow apply to unbounded data sets?A . Windows at every 100 MB of dataB . Single, Global WindowC . Windows at every 1 minuteD . Windows at every 10 minutesView AnswerAnswer: B Explanation: Dataflow's default windowing behavior is to assign all...
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...
