Cisco®
CompTIA
Checkpoint
ISC
EC-Council
EXIN
Fortinet
ITIL®
Juniper
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk®
MuleSoft
All Vendors
  2. Home
  3. Exams
  4. Google
  5. Professional Data Engineer

Free Professional Data Engineer Exam Braindumps (page: 4)

Page 4 of 95
PDF with 375 Questions

Your company is using WHILECARD tables to query data across multiple tables with similar names. The SQL statement is currently failing with the following error:

# Syntax error : Expected end of statement but got "-" at [4:11]

SELECT age

FROM

bigquery-public-data.noaa_gsod.gsod

WHERE

age != 99

AND_TABLE_SUFFIX = `1929'

ORDER BY

age DESC

Which table name will make the SQL statement work correctly?

  1. `bigquery-public-data.noaa_gsod.gsod`
  2. bigquery-public-data.noaa_gsod.gsod*
  3. `bigquery-public-data.noaa_gsod.gsod'*
  4. `bigquery-public-data.noaa_gsod.gsod*`

Answer(s): D



Your company is in a highly regulated industry. One of your requirements is to ensure individual users have access only to the minimum amount of information required to do their jobs. You want to enforce this requirement with Google BigQuery.
Which three approaches can you take? (Choose three.)

  1. Disable writes to certain tables.
  2. Restrict access to tables by role.
  3. Ensure that the data is encrypted at all times.
  4. Restrict BigQuery API access to approved users.
  5. Segregate data across multiple tables or databases.
  6. Use Google Stackdriver Audit Logging to determine policy violations.

Answer(s): B,D,F



You are designing a basket abandonment system for an ecommerce company. The system will send a message to a user based on these rules:

No interaction by the user on the site for 1 hour

Has added more than $30 worth of products to the basket

Has not completed a transaction

You use Google Cloud Dataflow to process the data and decide if a message should be sent. How should you design the pipeline?

  1. Use a fixed-time window with a duration of 60 minutes.
  2. Use a sliding time window with a duration of 60 minutes.
  3. Use a session window with a gap time duration of 60 minutes.
  4. Use a global window with a time based trigger with a delay of 60 minutes.

Answer(s): C



Your company handles data processing for a number of different clients. Each client prefers to use their own suite of analytics tools, with some allowing direct query access via Google BigQuery. You need to secure the data so that clients cannot see each other's dat

  1. You want to ensure appropriate access to the data.
    Which three steps should you take? (Choose three.)
  2. Load data into different partitions.
  3. Load data into a different dataset for each client.
  4. Put each client's BigQuery dataset into a different table.
  5. Restrict a client's dataset to approved users.
  6. Only allow a service account to access the datasets.
  7. Use the appropriate identity and access management (IAM) roles for each client's users.

Answer(s): B,D,F






Post your Comments and Discuss Google Professional Data Engineer exam prep with other Community members:

Professional Data Engineer Exam Discussions & Posts