Google Professional-Data-Engineer Google Cloud Data Engineer Professional Exam Practice Test Questions

• Question 1

  Which is not a valid reason for poor Cloud Bigtable performance?

  • The workload isn't appropriate for Cloud Bigtable.
  • The table's schema is not designed correctly.
  • The Cloud Bigtable cluster has too many nodes.
  • There are issues with the network connection.

  Show Answer Answer: C Next

• Question 2

  You create a new report for your large team in Google Data Studio 360. The report uses Google BigQuery as its data source. It is company policy to ensure employees can view only the data associated with their region, so you create and populate a table for each region. You need to enforce the regional access policy to the data.Which two actions should you take? (Choose two.)

  • Ensure all the tables are included in global dataset.
  • Ensure each table is included in a dataset for a region.
  • Adjust the settings for each table to allow a related region-based security group view access.
  • Adjust the settings for each view to allow a related region-based security group view access.
  • Adjust the settings for each dataset to allow a related region-based security group view access.

  Show Answer Answer: B,D Next

• Question 3

  You have Cloud Functions written in Node.js that pull messages from Cloud Pub/Sub and send the data to BigQuery. You observe that the message processing rate on the Pub/Sub topic is orders of magnitude higher than anticipated, but there is no error logged in Stackdriver Log Viewer. What are the two most likely causes of this problem? Choose 2 answers.

  • Publisher throughput quota is too small.
  • Total outstanding messages exceed the 10-MB maximum.
  • Error handling in the subscriber code is not handling run-time errors properly.
  • The subscriber code cannot keep up with the messages.
  • The subscriber code does not acknowledge the messages that it pulls.

  Show Answer Answer: C,D Next

• Question 4

  When using Cloud Dataproc clusters, you can access the YARN web interface by configuring a browser to connect through a proxy.

  • HTTPS
  • VPN
  • SOCKS
  • HTTP

  Show Answer Answer: C Next

• Question 5

  You are migrating your on-premises data warehouse to BigQuery. As part of the migration, you want to facilitate cross-team collaboration to get the most value out of the organization's data. You need to design an architecture that would allow teams within the organization to securely publish, discover, and subscribe to read-only data in a self-service manner. You need to minimize costs while also maximizing data freshness What should you do?

  • Create authorized datasets to publish shared data in the subscribing team's project.
  • Create a new dataset for sharing in each individual team's project. Grant the subscribing team the bigquery. dataViewer role on thedataset.
  • Use BigQuery Data Transfer Service to copy datasets to a centralized BigQuery project for sharing.
  • Use Analytics Hub to facilitate data sharing.

  Show Answer Answer: C Next