Free Professional Data Engineer Exam Braindumps
Google Cloud Data Engineer Professional Questions 171–175 (page: 36)

You have a data pipeline that writes data to Cloud Bigtable using well-designed row keys. You want to monitor your pipeline to determine when to increase the size of you Cloud Bigtable cluster.
Which two actions can you take to accomplish this? Choose 2 answers.

You want to analyze hundreds of thousands of social media posts daily at the lowest cost and with the fewest steps.

You have the following requirements:

You will batch-load the posts once per day and run them through the Cloud Natural Language API.

You will extract topics and sentiment from the posts.

You must store the raw posts for archiving and reprocessing.

You will create dashboards to be shared with people both inside and outside your organization.

You need to store both the data extracted from the API to perform analysis as well as the raw social media posts for historical archiving.
What should you do?

You store historic data in Cloud Storage. You need to perform analytics on the historic dat

Your company needs to upload their historic data to Cloud Storage. The security rules don't allow access from external IPs to their on-premises resources. After an initial upload, they will add new data from existing on-premises applications every day.
What should they do?

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 dat