- All Exams Instant Download
How should you maintain users’ privacy?
You are working on a sensitive project involving private user data. You have set up a project on Google Cloud Platform to house your work internally. An external consultant is going to assist with coding a complex transformation in a Google Cloud Dataflow pipeline for your project. How should you...
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...
What should you do?
Your company is performing data preprocessing for a learning algorithm in Google Cloud Dataflow. Numerous data logs are being are being generated during this step, and the team wants to analyze them. Due to the dynamic nature of the campaign, the data is growing exponentially every hour. The data scientists...
Which of the following statements about the Wide & Deep Learning model are true? (Select 2 answers.)
Which of the following statements about the Wide & Deep Learning model are true? (Select 2 answers.)A . The wide model is used for memorization, while the deep model is used for generalization.B . A good use for the wide and deep model is a recommender system.C . The wide...
What should you do first?
Your startup has never implemented a formal security policy. Currently, everyone in the company has access to the datasets stored in Google BigQuery. Teams have freedom to use the service as they see fit, and they have not documented their use cases. You have been asked to secure the data...
Which approach meets the requirements?
You need to compose visualizations for operations teams with the following requirements: Which approach meets the requirements?A . Load the data into Google Sheets, use formulas to calculate a metric, and use filters/sorting to show only suboptimal links in a table.B . Load the data into Google BigQuery tables, write...
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 SQD . One difference...
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...
The CUSTOM tier for Cloud Machine Learning Engine allows you to specify the number of which types of cluster nodes?
The CUSTOM tier for Cloud Machine Learning Engine allows you to specify the number of which types of cluster nodes?A . WorkersB . Masters, workers, and parameter serversC . Workers and parameter serversD . Parameter serversView AnswerAnswer: C Explanation: The CUSTOM tier is not a set tier, but rather enables...
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...
