Online Access Free Professional-Data-Engineer Exam Questions

A TensorFlow machine learning model on Compute Engine virtual machines (n2-standard -32) takes two days to complete framing. The model has custom TensorFlow operations that must run partially on a CPU You want to reduce the training time in a cost-effective manner. What should you do?

• A.Change the VM type to n2-highmem-32
• B.Train the model using a VM with a TPU hardware accelerator
• C.Change the VM type to e2 standard-32
• D.Train the model using a VM with a GPU hardware accelerator

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, the scope of the project has expanded. The database must now store 100 times more patientrecords. You can no longer run the reports, because they either take too long or they encounter errors with insufficient compute resources. How should you adjust the database design?

• A.Add capacity (memory and disk space) to the database server by the order of 200.
• B.Normalize the master patient-record table into the patient table and the visits table, and create other necessary tables to avoid self-join.
• C.Partition the table into smaller tables, with one for each clinic. Run queries against the smaller table pairs, and use unions for consolidated reports.
• D.Shard the tables into smaller ones based on date ranges, and only generate reports with prespecified date ranges.

You are updating the code for a subscriber to a Put/Sub feed. You are concerned that upon deployment the subscriber may erroneously acknowledge messages, leading to message loss. You subscriber is not set up to retain acknowledged messages. What should you do to ensure that you can recover from errors after deployment?

• A.Enable dead-lettering on the Pub/Sub topic to capture messages that aren't successful acknowledged if an error occurs after deployment, re-deliver any messages captured by the dead-letter queue
• B.Create a Pub/Sub snapshot before deploying new subscriber code. Use a Seek operation to re-deliver messages that became available after the snapshot was created
• C.Use Cloud Build for your deployment if an error occurs after deployment, use a Seek operation to locate a tmestamp logged by Cloud Build at the start of the deployment
• D.Set up the Pub/Sub emulator on your local machine Validate the behavior of your new subscriber togs before deploying it to production

You are responsible for writing your company's ETL pipelines to run on an Apache Hadoop cluster. The pipeline will require some checkpointing and splitting pipelines. Which method should you use to write the pipelines?

• A.HiveQL using Hive
• B.Python using MapReduce
• C.PigLatin using Pig
• D.Java using MapReduce

You are using Cloud Bigtable to persist and serve stock market data for each of the major indices. To serve the trading application, you need to access only the most recent stock prices that are streaming in How should you design your row key and tables to ensure that you can access the data with the most simple query?

• A.Create one unique table for all of the indices, and then use the index and timestamp as the row key design
• B.For each index, have a separate table and use a timestamp as the row key design
• C.For each index, have a separate table and use a reverse timestamp as the row key design
• D.Create one unique table for all of the indices, and then use a reverse timestamp as the row key design.