Study with Google : Professional-Data-Engineer Exam Torrent as your best preparation materials

Your company wants to be able to retrieve large result sets of medical information from your current system, which has over 10 TBs in the database, and store the data in new tables for further query. The database must have a low-maintenance architecture and be accessible via SQL. You need to implement a cost-effective solution that can support data analytics for large result sets. What should you do?

• A. Use a MySQL cluster installed on a Compute Engine managed instance group for scalability.
• B. Use Cloud SQL, but first organize the data into tables. Use JOIN in queries to retrieve data.
• C. Use Cloud Spanner to replicate the data across regions. Normalize the data in a series of tables.
• D. Use BigQuery as a data warehouse. Set output destinations for caching large queries.

When you store data in Cloud Bigtable, what is the recommended minimum amount of stored data?

• A. 500 GB
• B. 500 TB
• C. 1 TB
• D. 1 GB

Your organization has been collecting and analyzing data in Google BigQuery for 6 months. The majority of the data analyzed is placed in a time-partitioned table named events_partitioned. To reduce the cost of queries, your organization created a view called events, which queries only the last 14 days of data. The view is described in legacy SQL. Next month, existing applications will be connecting to BigQuery to read the events data via an ODBC connection. You need to ensure the applications can connect. Which two actions should you take? (Choose two.)

• A. Create a service account for the ODBC connection to use for authentication
• B. Create a new view over events_partitioned using standard SQL
• C. Create a new view over events using standard SQL
• D. Create a new partitioned table using a standard SQL query
• E. Create a Google Cloud Identity and Access Management (Cloud IAM) role for the ODBC connection and shared "events"

You are training a spam classifier. You notice that you are overfitting the training data. Which three actions can you take to resolve this problem? (Choose three.)

• A. Reduce the number of training examples
• B. Use a smaller set of features
• C. Get more training examples
• D. Use a larger set of features
• E. Decrease the regularization parameters
• F. Increase the regularization parameters

You work for a car manufacturer and have set up a data pipeline using Google Cloud Pub/Sub to capture anomalous sensor events. You are using a push subscription in Cloud Pub/Sub that calls a custom HTTPS endpoint that you have created to take action of these anomalous events as they occur. Your custom HTTPS endpoint keeps getting an inordinate amount of duplicate messages. What is the most likely cause of these duplicate messages?

• A. Your custom endpoint is not acknowledging messages within the acknowledgement deadline.
• B. Your custom endpoint has an out-of-date SSL certificate.
• C. The message body for the sensor event is too large.
• D. The Cloud Pub/Sub topic has too many messages published to it.