Professional-Data-Engineer Exam Question 6

Your organization has two Google Cloud projects, project A and project B. In project A, you have a Pub/Sub topic that receives data from confidential sources. Only the resources in project A should be able to access the data in that topic. You want to ensure that project B and any future project cannot access data in the project A topic. What should you do?
  • Professional-Data-Engineer Exam Question 7

    You set up a streaming data insert into a Redis cluster via a Kafka cluster. Both clusters are running on Compute Engine instances. You need to encrypt data at rest with encryption keys that you can create, rotate, and destroy as needed. What should you do?
  • Professional-Data-Engineer Exam Question 8

    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?
  • Professional-Data-Engineer Exam Question 9

    Flowlogistic's CEO wants to gain rapid insight into their customer base so his sales team can be better informed in the field. This team is not very technical, so they've purchased a visualization tool to simplify the creation of BigQuery reports. However, they've been overwhelmed by all the data in the table, and are spending a lot of money on queries trying to find the data they need. You want to solve their problem in the most cost-effective way. What should you do?
  • Professional-Data-Engineer Exam Question 10

    You want to use a database of information about tissue samples to classify future tissue samples as either normal or mutated. You are evaluating an unsupervised anomaly detection method for classifying the tissue samples. Which two characteristic support this method? (Choose two.)