Skip to content
ExamCup

Google

Google professional-data-engineer

Professional Data Engineer

Practice questions with verified answers, detailed explanations, and community discussions.

336
Questions
today
Last updated
Guest
Your plan

25 free questions

Unlock more questions
Show
Question map
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. 10
  11. 11
  12. 12
  13. 13
  14. 14
  15. 15
  16. 16
  17. 17
  18. 18
  19. 19
  20. 20
  21. 21
  22. 22
  23. 23
  24. 24
  25. 25

  • Question 6 of 336

    Topic 1: Professional Data Engineer

    Topic 1: Professional Data Engineer

    Your weather app queries a database every 15 minutes to get the current temperature. The frontend is powered by Google App Engine and server millions of

    users. How should you design the frontend to respond to a database failure?

    Choose your answer

    Pick an answer to check it, or press Show answer to see the correct one.

  • Question 7 of 336

    Topic 1: Professional Data Engineer

    Topic 1: Professional Data Engineer

    You are creating a model to predict housing prices. Due to budget constraints, you must run it on a single resource-constrained virtual machine. Which learning

    algorithm should you use?

    Choose your answer

    Pick an answer to check it, or press Show answer to see the correct one.

  • Question 8 of 336

    Topic 1: Professional Data Engineer

    Topic 1: Professional Data Engineer

    You are building new real-time data warehouse for your company and will use Google BigQuery streaming inserts. There is no guarantee that data will only be

    sent in once but you do have a unique ID for each row of data and an event timestamp. You want to ensure that duplicates are not included while interactively

    querying data. Which query type should you use?

    Choose your answer

    Pick an answer to check it, or press Show answer to see the correct one.

  • Question 9 of 336

    Topic 1: Professional Data Engineer

    Topic 1: Professional Data Engineer

    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.)

    Choose your answer

    Pick an answer to check it, or press Show answer to see the correct one.

  • Question 10 of 336

    Topic 1: Professional Data Engineer

    Topic 1: Professional Data Engineer

    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?

    Choose your answer

    Pick an answer to check it, or press Show answer to see the correct one.