Professional Data Engineer exam

You designed a database for patient records as a pilot project to cover a few hundred patients in three clinics. Your design used a single database table to represent all patients and their visits, and you used self-joins to generate reports. The server resource utilization was at 50%. Since then,...

Flowlogistic’s management has determined that the current Apache Kafka servers cannot handle the data volume for their real-time inventory tracking system. You need to build a new system on Google Cloud Platform (GCP) that will feed the proprietary tracking software. The system must be able to ingest data from a...

Flowlogistic is rolling out their real-time inventory tracking system. The tracking devices will all send package-tracking messages, which will now go to a single Google Cloud Pub/Sub topic instead of the Apache Kafka cluster. A subscriber application will then process the messages for real-time reporting and store them in Google...

You have Google Cloud Dataflow streaming pipeline running with a Google Cloud Pub/Sub subscription as the source. You need to make an update to the code that will make the new Cloud Dataflow pipeline incompatible with the current version. You do not want to lose any data when making this...

Which software libraries are supported by Cloud Machine Learning Engine?A . Theano and TensorFlowB . Theano and TorchC . TensorFlowD . TensorFlow and TorchView AnswerAnswer: C Explanation: Cloud ML Engine mainly does two things: Enables you to train machine learning models at scale by running TensorFlow training applications in the...

Which of these are examples of a value in a sparse vector? (Select 2 answers.)A . [0, 5, 0, 0, 0, 0]B . [0, 0, 0, 1, 0, 0, 1]C . [0, 1]D . [1, 0, 0, 0, 0, 0, 0]View AnswerAnswer: C,D Explanation: Categorical features in linear models are...

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.)A . There are very few occurrences of mutations...

You want to use Google Stackdriver Logging to monitor Google BigQuery usage. You need an instant notification to be sent to your monitoring tool when new data is appended to a certain table using an insert job, but you do not want to receive notifications for other tables. What should...

MJTelco needs you to create a schema in Google Bigtable that will allow for the historical analysis of the last 2 years of records. Each record that comes in is sent every 15 minutes, and contains a unique identifier of the device and a data record. The most common query...

Your company is streaming real-time sensor data from their factory floor into Bigtable and they have noticed extremely poor performance. How should the row key be redesigned to improve Bigtable performance on queries that populate real-time dashboards?A . Use a row key of the form <timestamp>.B . Use a row...