Cisco®
CompTIA
Checkpoint
ISC
EC-Council
EXIN
Fortinet
ITIL®
Juniper
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk®
MuleSoft
All Vendors
  2. Home
  3. Exams
  4. Google
  5. Professional Data Engineer

Free Professional Data Engineer Exam Braindumps (page: 35)

Page 9 of 95
PDF with 375 Questions

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?

  1. Use a row key of the form <timestamp>.
  2. Use a row key of the form <sensorid>.
  3. Use a row key of the form <timestamp>#<sensorid>.
  4. Use a row key of the form >#<sensorid>#<timestamp>.

Answer(s): A



Your company's customer and order databases are often under heavy load. This makes performing analytics against them difficult without harming operations. The databases are in a MySQL cluster, with nightly backups taken using mysqldump. You want to perform analytics with minimal impact on operations.
What should you do?

  1. Add a node to the MySQL cluster and build an OLAP cube there.
  2. Use an ETL tool to load the data from MySQL into Google BigQuery.
  3. Connect an on-premises Apache Hadoop cluster to MySQL and perform ETL.
  4. Mount the backups to Google Cloud SQL, and then process the data using Google Cloud Dataproc.

Answer(s): C



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 update.
What should you do?

  1. Update the current pipeline and use the drain flag.
  2. Update the current pipeline and provide the transform mapping JSON object.
  3. Create a new pipeline that has the same Cloud Pub/Sub subscription and cancel the old pipeline.
  4. Create a new pipeline that has a new Cloud Pub/Sub subscription and cancel the old pipeline.

Answer(s): D



Your company is running their first dynamic campaign, serving different offers by analyzing real-time data during the holiday season. The data scientists are collecting terabytes of data that rapidly grows every hour during their 30-day campaign. They are using Google Cloud Dataflow to preprocess the data and collect the feature (signals) data that is needed for the machine learning model in Google Cloud Bigtable. The team is observing suboptimal performance with reads and writes of their initial load of 10 TB of dat

  1. They want to improve this performance while minimizing cost.
    What should they do?
  2. Redefine the schema by evenly distributing reads and writes across the row space of the table.
  3. The performance issue should be resolved over time as the site of the BigDate cluster is increased.
  4. Redesign the schema to use a single row key to identify values that need to be updated frequently in the cluster.
  5. Redesign the schema to use row keys based on numeric IDs that increase sequentially per user viewing the offers.

Answer(s): A






Post your Comments and Discuss Google Professional Data Engineer exam prep with other Community members:

Professional Data Engineer Exam Discussions & Posts