What are all of the BigQuery operations that Google charges for?
Answer(s): A
Google charges for storage, queries, and streaming inserts. Loading data from a file and exporting data are free operations.
https://cloud.google.com/bigquery/pricing
Which of the following is not possible using primitive roles?
Answer(s): C
Primitive roles can be used to give owner, editor, or viewer access to a user or group, but they can't be used to separate data access permissions from job-running permissions.
https://cloud.google.com/bigquery/docs/access-control#primitive_iam_roles
Which of these statements about BigQuery caching is true?
Answer(s): D
When query results are retrieved from a cached results table, you are not charged for the query.BigQuery caches query results for 24 hours, not 48 hours.Query results are not cached if you specify a destination table.A query's results are always cached except under certain conditions, such as if you specify a destination table.
https://cloud.google.com/bigquery/querying-data#query-caching
Which of these sources can you not load data into BigQuery from?
You can load data into BigQuery from a file upload, Google Cloud Storage, Google Drive, or Google Cloud Bigtable. It is not possible to load data into BigQuery directly from Google Cloud SQL. One way to get data from Cloud SQL to BigQuery would be to export data from Cloud SQL to Cloud Storage and then load it from there.
https://cloud.google.com/bigquery/loading-data
Post your Comments and Discuss Google Professional Data Engineer exam with other Community members:
madhan Commented on June 16, 2023 next question EUROPEAN UNION
To protect our content from bots for real learners like you, we ask you to register for free. Sign in or sign up now to continue with the Professional Data Engineer material!