Professional-Data-Engineer Exam Question 126

Your company is selecting a system to centralize data ingestion and delivery. You are considering messaging and data integration systems to address the requirements. The key requirements are:
* The ability to seek to a particular offset in a topic, possibly back to the start of all data ever captured
* Support for publish/subscribe semantics on hundreds of topics
* Retain per-key ordering
Which system should you choose?
  • Professional-Data-Engineer Exam Question 127

    For the best possible performance, what is the recommended zone for your Compute Engine instance and Cloud Bigtable instance?
  • Professional-Data-Engineer Exam Question 128

    You are selecting services to write and transform JSON messages from Cloud Pub/Sub to BigQuery for a
    data pipeline on Google Cloud. You want to minimize service costs. You also want to monitor and
    accommodate input data volume that will vary in size with minimal manual intervention. What should you
    do?
  • Professional-Data-Engineer Exam Question 129

    You have a query that filters a BigQuery table using a WHERE clause on timestamp and ID columns. By using bq query - -dry_run you learn that the query triggers a full scan of the table, even though the filter on timestamp and ID select a tiny fraction of the overall data. You want to reduce the amount of data scanned by BigQuery with minimal changes to existing SQL queries. What should you do?
  • Professional-Data-Engineer Exam Question 130

    You plan to deploy Cloud SQL using MySQL. You need to ensure high availability in the event of a zone failure.
    What should you do?