Google Data Engineer - GCP-DE FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

You are a retailer that wants to integrate your online sales capabilities with different in-home assistants, such as Google Home. You need to interpret customer voice commands and issue an order to the backend systems. Which solutions should you choose?

A. Cloud AutoML Natural Language B. Cloud Speech-to-Text API C. Cloud Natural Language API D. Dialogflow Enterprise Edition

Discussion 0

Correct Answer: A Vote an answer

Question 2

You are building a new application that you need to collect data from in a scalable way. Data arrives continuously from the application throughout the day, and you expect to generate approximately 150 GB of JSON data per day by the end of the year. Your requirements are: Decoupling producer from consumer Space and cost-efficient storage of the raw ingested data, which is to be stored indefinitely Near real-time SQL query Maintain at least 2 years of historical data, which will be queried with SQ Which pipeline should you use to meet these requirements?

A. Create an application that publishes events to Cloud Pub/Sub, and create a Cloud Dataflow pipeline that transforms the JSON event payloads to Avro, writing the data to Cloud Storage and BigQuery. B. Create an application that provides an AP C. Create an application that publishes events to Cloud Pub/Sub, and create Spark jobs on Cloud Dataproc to convert the JSON data to Avro format, stored on HDFS on Persistent Disk. D. Create an application that writes to a Cloud SQL database to store the dat E. Set up periodic exports of the database to write to Cloud Storage and load into BigQuery. F. Write a tool to poll the API and write data to Cloud Storage as gzipped JSON files.

Discussion 0

Correct Answer: B Vote an answer

Question 3

You work for a mid-sized enterprise that needs to move its operational system transaction data from an on-premises database to GCP. The database is about 20 TB in size. Which database should you choose?

A. Cloud Spanner B. Cloud Bigtable C. Cloud Datastore D. Cloud SQL

Discussion 0

Correct Answer: D Vote an answer

Question 4

You receive data files in CSV format monthly from a third party. You need to cleanse this data, but every third month the schema of the files changes. Your requirements for implementing these transformations include:
Executing the transformations on a schedule
Enabling non-developer analysts to modify transformations
Providing a graphical tool for designing transformations
What should you do?

A. Merge the transformed tables together with a SQL query B. Load each month's CSV data into BigQuery, and write a SQL query to transform the data to a standard scheme C. The Python code should be stored in a revision control system and modified as the incoming data's schema changes D. Help the analysts write a Cloud Dataflow pipeline in Python to perform the transformatio E. Use Cloud Dataprep to build and maintain the transformation recipes, and execute them on a scheduled basis F. Use Apache Spark on Cloud Dataproc to infer the schema of the CSV file before creating a Dataframe.Then implement the transformations in Spark SQL before writing the data out to Cloud Storage and loading into BigQuery

Discussion 0

Correct Answer: D Vote an answer

Question 5

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. Use the service account's private key to access the dataset D. Integrate with a single sign-on (SSO) platform, and pass each user's credentials along with the query request E. Create a dummy user and grant dataset access to that use F. Create groups for your users and give those groups access to the dataset

Discussion 0

Correct Answer: B Vote an answer

Question 6

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 Stackdriver Monitoring dashboard based on the BigQuery metric slots/allocated_for_project C. 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 D. Create a Stackdriver Monitoring dashboard based on the BigQuery metric query/scanned_bytes

Discussion 0

Correct Answer: A Vote an answer

Question 7

Question 8

You work for a shipping company that uses handheld scanners to read shipping labels. Your company has strict data privacy standards that require scanners to only transmit recipients' personally identifiable information (PII) to analytics systems, which violates user privacy rules. You want to quickly build a scalable solution using cloud-native managed services to prevent exposure of PII to the analytics systems. What should you do?

A. Use Stackdriver logging to analyze the data passed through the total pipeline to identify transactions that may contain sensitive information. B. Use the tagging and confidence levels to either pass or quarantine the data in a bucket for review. C. Build a Cloud Function that reads the topics and makes a call to the Cloud Data Loss Prevention AP D. Install a third-party data validation tool on Compute Engine virtual machines to check the incoming data for sensitive information. E. Create an authorized view in BigQuery to restrict access to tables with sensitive data.

Discussion 0

Correct Answer: E Vote an answer