Which of these statements about exporting data from BigQuery is false?
Answer(s): C
Data can be exported in CSV, JSON, or Avro format. If you are exporting nested or repeated data, then CSV format is not supported.
https://cloud.google.com/bigquery/docs/exporting-data
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?
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
Share your comments for Google Professional Data Engineer exam with other users:
just took the comptia cybersecurity analyst (cysa+) - wished id seeing this before my exam
very helpful
i need this exam
nice questions... are these questions the same of the exam?
need to view
highly appreciate for your sharing.
kindly share this dump. thank you
link plz for download
data quality oecd
rman is one good recovery technology
need it thx
good questions
good one nice revision
i love this thank you i need
question # 142: data governance is not one of the deliverables in the document and content management context diagram.
most answers not correct here
what % of questions do we get in the real exam?
i just want to tell you. i took my microsoft az-104 exam and passed it. your program was awesome. i especially liked your detailed questions and answers and practice tests that made me well-prepared for the exam. thanks to this website!!!
all the best
very usefull document
nice and helpful questions
i found the questions helpful
q 105 . ans is d
i have interest to get a sybase iq dba certification
want to pass exm.
are the answers correct?
good morning, could you please upload this exam again, i need it to test my knowledge in sd-wan with version 7.0.
very nice question
i have learning disability and this exam dumps allowed me to focus on the actual questions and not worry about notes and the those other study materials.
165 should be apt
please upload the dumps, real need of them
any recent feeedback?
question number 2 is indicating you are giving proper questions. observe and change properly.
passed today.40% questions were new.litwere case study,lots of new questions on afd,ratelimit,tm,lb,app gatway.got 2 set series of questions which are not present here.questions on azure cyclecloud, no.of vnet/vms required for implimentation,blueprints assignment/management group etc