- All Exams Instant Download
What should you do?
You need to compose visualization for operations teams with the following requirements: Telemetry must include data from all 50,000 installations for the most recent 6 weeks (sampling once every minute) The report must not be more than 3 hours delayed from live data. The actionable report should only show suboptimal...
Which of these statements about exporting data from BigQuery is false?
Which of these statements about exporting data from BigQuery is false?A . To export more than 1 GB of data, you need to put a wildcard in the destination filename.B . The only supported export destination is Google Cloud Storage.C . Data can only be exported in JSON or Avro...
Which of these statements about BigQuery caching is true?
Which of these statements about BigQuery caching is true?A . By default, a query's results are not cached.B . BigQuery caches query results for 48 hours.C . Query results are cached even if you specify a destination table.D . There is no charge for a query that retrieves its results...
How would you correct the error?
Topic 5, Practice Questions Suppose you have a table that includes a nested column called "city" inside a column called "person", but when you try to submit the following query in BigQuery, it gives you an error. SELECT person FROM `project1.example.table1` WHERE city = "London" How would you correct the...
Which of these is not a supported method of putting data into a partitioned table?
Which of these is not a supported method of putting data into a partitioned table?A . If you have existing data in a separate file for each day, then create a partitioned table and upload each file into the appropriate partition.B . Run a query to get the records for...
Which of the following IAM roles does your Compute Engine account require to be able to run pipeline jobs?
Which of the following IAM roles does your Compute Engine account require to be able to run pipeline jobs?A . dataflow.workerB . dataflow.computeC . dataflow.developerD . dataflow.viewerView AnswerAnswer: A Explanation: The dataflow.worker role provides the permissions necessary for a Compute Engine service account to execute work units for a Dataflow...
Which two actions should you take?
You create a new report for your large team in Google Data Studio 360. The report uses Google BigQuery as its data source. It is company policy to ensure employees can view only the data associated with their region, so you create and populate a table for each region. You...
Which of these are examples of a value in a sparse vector? (Select 2 answers.)
Which of these are examples of a value in a sparse vector? (Select 2 answers.)A . [0, 5, 0, 0, 0, 0]B . [0, 0, 0, 1, 0, 0, 1]C . [0, 1]D . [1, 0, 0, 0, 0, 0, 0]View AnswerAnswer: CD Explanation: Categorical features in linear models are...
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: AB Explanation: A neural network is a simple mechanism that’s implemented with basic math. The only difference between the...
Which of the following is not possible using primitive roles?
Which of the following is not possible using primitive roles?A . Give a user viewer access to BigQuery and owner access to Google Compute Engine instances.B . Give UserA owner access and UserB editor access for all datasets in a project.C . Give a user access to view all datasets...
