Data Engineer (GCP-DE) Free Practice Test

Question 1

You are designing the database schema for a machine learning-based food ordering service that will predict what users want to eat. Here is some of the information you need to store:
The user profile: What the user likes and doesn't like to eat
The user account information: Name, address, preferred meal times
The order information: When orders are made, from where, to whom
The database will be used to store all the transactional data of the product. You want to optimize the data schem a. Which Google Cloud Platform product should you use?

A. BigQuery

B. Cloud Bigtable

C. Cloud Datastore

D. Cloud SQL

Correct Answer: A

Question 2

What are the minimum permissions needed for a service account used with Google Dataproc?

A. Execute to Google Cloud Storage; write to Google Cloud Logging

B. Read and write to Google Cloud Storage; write to Google Cloud Logging

C. Write to Google Cloud Storage; read to Google Cloud Logging

D. Execute to Google Cloud Storage; execute to Google Cloud Logging

Correct Answer: B

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 3

Each analytics team in your organization is running BigQuery jobs in their own projects. You want to enable each team to monitor slot usage within their projects. What should you do?

A. Create an aggregated log export at the organization level, capture the BigQuery job execution logs, create a custom metric based on the totalSlotMs, and create a Stackdriver Monitoring dashboard based on the custom metric

B. Create a log export for each project, capture the BigQuery job execution logs, create a custom metric based on the totalSlotMs, and create a Stackdriver Monitoring dashboard based on the custom metric

C. Create a Stackdriver Monitoring dashboard based on the BigQuery metric query/scanned_bytes

D. Create a Stackdriver Monitoring dashboard based on the BigQuery metric slots/allocated_for_project

Correct Answer: A

Question 4

An online retailer has built their current application on Google App Engine. A new initiative at the company mandates that they extend their application to allow their customers to transact directly via the application.
They need to manage their shopping transactions and analyze combined data from multiple datasets using a business intelligence (BI) tool. They want to use only a single database for this purpose. Which Google Cloud database should they choose?

A. Cloud BigTable

B. BigQuery

C. Cloud Datastore

D. Cloud SQL

Correct Answer: A

Question 5

You are planning to use Google's Dataflow SDK to analyze customer data such as displayed below. Your project requirement is to extract only the customer name Passing Certification Exams Made Easy visit - https://www.2PassEasy.com from the data source and then write to an output PCollection.
Tom,555 X street Tim,553 Y street Sam, 111 Z street
Which operation is best suited for the above data processing requirement?

A. Sink API

B. Source API

C. Data extraction

D. ParDo

Correct Answer: D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 6

You work for a manufacturing company that sources up to 750 different components, each from a different supplier. You've collected a labeled dataset that has on average 1000 examples for each unique component. Your team wants to implement an app to help warehouse workers recognize incoming components based on a photo of the component. You want to implement the first working version of this app (as Proof-Of-Concept) within a few working days. What should you do?

A. Use Cloud Vision AutoML, but reduce your dataset twice.

B. Use Cloud Vision AutoML with the existing dataset.

C. Use Cloud Vision API by providing custom labels as recognition hints.

D. Train your own image recognition model leveraging transfer learning techniques.

Correct Answer: B

Question 7

If you're running a performance test that depends upon Cloud Bigtable, all the choices except one below are recommended steps. Which is NOT a recommended step to follow?

A. Use at least 300 GB of data.

B. Do not use a production instance.

C. Before you test, run a heavy pre-test for several minutes.

D. Run your test for at least 10 minutes.

Correct Answer: B

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 8

You are integrating one of your internal IT applications and Google BigQuery, so users can query BigQuery from the application's interface. You do not want individual users to authenticate to BigQuery and you do not want to give them access to the dataset. You need to securely access BigQuery from your IT application.
What should you do?

A. Store the username and password for that user in a file on the files system, and use those credentials to access the BigQuery dataset

B. Create a service account and grant dataset access to that accoun

C. Integrate with a single sign-on (SSO) platform, and pass each user's credentials along with the query request

D. Use the service account's private key to access the dataset

E. Create groups for your users and give those groups access to the dataset

F. Create a dummy user and grant dataset access to that use

Correct Answer: B

Welcome to TestSimulate

Google Data Engineer (GCP-DE) Free Practice Test