Regenerate Google Professional Data Engineer Exam Professional-Data-Engineer Free Exam

NEW QUESTION 1

Flowlogistic is rolling out their real-time inventory tracking system. The tracking devices will all send package-tracking messages, which will now go to a single Google Cloud Pub/Sub topic instead of the Apache Kafka cluster. A subscriber application will then process the messages for real-time reporting and store them in Google BigQuery for historical analysis. You want to ensure the package data can be analyzed over time.
Which approach should you take?

• A. Attach the timestamp on each message in the Cloud Pub/Sub subscriber application as they are received.
• B. Attach the timestamp and Package ID on the outbound message from each publisher device as they are sent to Clod Pub/Sub.
• C. Use the NOW () function in BigQuery to record the event’s time.
• D. Use the automatically generated timestamp from Cloud Pub/Sub to order the data.

Answer: B

NEW QUESTION 2

What is the recommended action to do in order to switch between SSD and HDD storage for your Google Cloud Bigtable instance?

• A. create a third instance and sync the data from the two storage types via batch jobs
• B. export the data from the existing instance and import the data into a new instance
• C. run parallel instances where one is HDD and the other is SDD
• D. the selection is final and you must resume using the same storage type

Answer: B

Explanation:
When you create a Cloud Bigtable instance and cluster, your choice of SSD or HDD storage for the cluster is permanent. You cannot use the Google Cloud Platform Console to change the type of storage that is used for the cluster.
If you need to convert an existing HDD cluster to SSD, or vice-versa, you can export the data from the existing instance and import the data into a new instance. Alternatively, you can write
a Cloud Dataflow or Hadoop MapReduce job that copies the data from one instance to another. Reference: https://cloud.google.com/bigtable/docs/choosing-ssd-hdd–

NEW QUESTION 3

You need to deploy additional dependencies to all of a Cloud Dataproc cluster at startup using an existing initialization action. Company security policies require that Cloud Dataproc nodes do not have access to the
Internet so public initialization actions cannot fetch resources. What should you do?

• A. Deploy the Cloud SQL Proxy on the Cloud Dataproc master
• B. Use an SSH tunnel to give the Cloud Dataproc cluster access to the Internet
• C. Copy all dependencies to a Cloud Storage bucket within your VPC security perimeter
• D. Use Resource Manager to add the service account used by the Cloud Dataproc cluster to the Network User role

Answer: D

NEW QUESTION 4

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 schema. Which Google Cloud Platform product should you use?

• A. BigQuery
• B. Cloud SQL
• C. Cloud Bigtable
• D. Cloud Datastore

Answer: A

NEW QUESTION 5

What are two of the characteristics of using online prediction rather than batch prediction?

• A. It is optimized to handle a high volume of data instances in a job and to run more complex models.
• B. Predictions are returned in the response message.
• C. Predictions are written to output files in a Cloud Storage location that you specify.
• D. It is optimized to minimize the latency of serving predictions.

Answer: BD

Explanation:
Online prediction
Optimized to minimize the latency of serving predictions. Predictions returned in the response message.
Batch prediction
Optimized to handle a high volume of instances in a job and to run more complex models. Predictions written to output files in a Cloud Storage location that you specify.
Reference:
https://cloud.google.com/ml-engine/docs/prediction-overview#online_prediction_versus_batch_prediction

NEW QUESTION 6

You use a dataset in BigQuery for analysis. You want to provide third-party companies with access to the same dataset. You need to keep the costs of data sharing low and ensure that the data is current. Which solution should you choose?

• A. Create an authorized view on the BigQuery table to control data access, and provide third-party companies with access to that view.
• B. Use Cloud Scheduler to export the data on a regular basis to Cloud Storage, and provide third-party companies with access to the bucket.
• C. Create a separate dataset in BigQuery that contains the relevant data to share, and provide third-party companies with access to the new dataset.
• D. Create a Cloud Dataflow job that reads the data in frequent time intervals, and writes it to the relevant BigQuery dataset or Cloud Storage bucket for third-party companies to use.

Answer: B

NEW QUESTION 7

Which of the following is not true about Dataflow pipelines?

• A. Pipelines are a set of operations
• B. Pipelines represent a data processing job
• C. Pipelines represent a directed graph of steps
• D. Pipelines can share data between instances

Answer: D

Explanation:
The data and transforms in a pipeline are unique to, and owned by, that pipeline. While your program can create multiple pipelines, pipelines cannot share data or transforms
Reference: https://cloud.google.com/dataflow/model/pipelines

NEW QUESTION 8

Which of the following statements is NOT true regarding Bigtable access roles?

• A. Using IAM roles, you cannot give a user access to only one table in a project, rather than all tables in a project.
• B. To give a user access to only one table in a project, grant the user the Bigtable Editor role for that table.
• C. You can configure access control only at the project level.
• D. To give a user access to only one table in a project, you must configure access through your application.

Answer: B

Explanation:
For Cloud Bigtable, you can configure access control at the project level. For example, you can grant the ability to:
Read from, but not write to, any table within the project.
Read from and write to any table within the project, but not manage instances. Read from and write to any table within the project, and manage instances. Reference: https://cloud.google.com/bigtable/docs/access-control

NEW QUESTION 9

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. Create groups for your users and give those groups access to the dataset
• B. Integrate with a single sign-on (SSO) platform, and pass each user’s credentials along with the query request
• C. Create a service account and grant dataset access to that accoun
• D. Use the service account’s private key to access the dataset
• E. Create a dummy user and grant dataset access to that use
• F. Store the username and password for that user in a file on the files system, and use those credentials to access the BigQuery dataset

Answer: C

NEW QUESTION 10

Flowlogistic wants to use Google BigQuery as their primary analysis system, but they still have Apache Hadoop and Spark workloads that they cannot move to BigQuery. Flowlogistic does not know how to store the data that is common to both workloads. What should they do?

• A. Store the common data in BigQuery as partitioned tables.
• B. Store the common data in BigQuery and expose authorized views.
• C. Store the common data encoded as Avro in Google Cloud Storage.
• D. Store he common data in the HDFS storage for a Google Cloud Dataproc cluster.

Answer: B

NEW QUESTION 11

Data Analysts in your company have the Cloud IAM Owner role assigned to them in their projects to allow them to work with multiple GCP products in their projects. Your organization requires that all BigQuery data access logs be retained for 6 months. You need to ensure that only audit personnel in your company can access the data access logs for all projects. What should you do?

• A. Enable data access logs in each Data Analyst’s projec
• B. Restrict access to Stackdriver Logging via Cloud IAM roles.
• C. Export the data access logs via a project-level export sink to a Cloud Storage bucket in the Data Analysts’ project
• D. Restrict access to the Cloud Storage bucket.
• E. Export the data access logs via a project-level export sink to a Cloud Storage bucket in a newly created projects for audit log
• F. Restrict access to the project with the exported logs.
• G. Export the data access logs via an aggregated export sink to a Cloud Storage bucket in a newly created project for audit log
• H. Restrict access to the project that contains the exported logs.

Answer: D

NEW QUESTION 12

To give a user read permission for only the first three columns of a table, which access control method would you use?

• A. Primitive role
• B. Predefined role
• C. Authorized view
• D. It's not possible to give access to only the first three columns of a table.

Answer: C

Explanation:
An authorized view allows you to share query results with particular users and groups without giving them
read access to the underlying tables. Authorized views can only be created in a dataset that does not contain the tables queried by the view.
When you create an authorized view, you use the view's SQL query to restrict access to only the rows and columns you want the users to see.
Reference: https://cloud.google.com/bigquery/docs/views#authorized-views

NEW QUESTION 13

You need to migrate a 2TB relational database to Google Cloud Platform. You do not have the resources to significantly refactor the application that uses this database and cost to operate is of primary concern.
Which service do you select for storing and serving your data?

• A. Cloud Spanner
• B. Cloud Bigtable
• C. Cloud Firestore
• D. Cloud SQL

Answer: D

NEW QUESTION 14

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 Speech-to-Text API
• B. Cloud Natural Language API
• C. Dialogflow Enterprise Edition
• D. Cloud AutoML Natural Language

Answer: D

NEW QUESTION 15

Suppose you have a table that includes a nested column called "city" inside a column called "person", but when you try to submit the following query in BigQuery, it gives you an error.
SELECT person FROM `project1.example.table1` WHERE city = "London"
How would you correct the error?

• A. Add ", UNNEST(person)" before the WHERE clause.
• B. Change "person" to "person.city".
• C. Change "person" to "city.person".
• D. Add ", UNNEST(city)" before the WHERE clause.

Answer: A

Explanation:
To access the person.city column, you need to "UNNEST(person)" and JOIN it to table1 using a comma. Reference:
https://cloud.google.com/bigquery/docs/reference/standard-sql/migrating-from-legacy-sql#nested_repeated_resu

NEW QUESTION 16

MJTelco is building a custom interface to share data. They have these requirements:
They need to do aggregations over their petabyte-scale datasets.
They need to scan specific time range rows with a very fast response time (milliseconds). Which combination of Google Cloud Platform products should you recommend?

• A. Cloud Datastore and Cloud Bigtable
• B. Cloud Bigtable and Cloud SQL
• C. BigQuery and Cloud Bigtable
• D. BigQuery and Cloud Storage

Answer: C

NEW QUESTION 17

Does Dataflow process batch data pipelines or streaming data pipelines?

• A. Only Batch Data Pipelines
• B. Both Batch and Streaming Data Pipelines
• C. Only Streaming Data Pipelines
• D. None of the above

Answer: B

Explanation:
Dataflow is a unified processing model, and can execute both streaming and batch data pipelines Reference: https://cloud.google.com/dataflow/

NEW QUESTION 18

You want to migrate an on-premises Hadoop system to Cloud Dataproc. Hive is the primary tool in use, and the data format is Optimized Row Columnar (ORC). All ORC files have been successfully copied to a Cloud Storage bucket. You need to replicate some data to the cluster’s local Hadoop Distributed File System (HDFS) to maximize performance. What are two ways to start using Hive in Cloud Dataproc? (Choose two.)

• A. Run the gsutil utility to transfer all ORC files from the Cloud Storage bucket to HDF
• B. Mount the Hive tables locally.
• C. Run the gsutil utility to transfer all ORC files from the Cloud Storage bucket to any node of the Dataproc cluste
• D. Mount the Hive tables locally.
• E. Run the gsutil utility to transfer all ORC files from the Cloud Storage bucket to the master node of the Dataproc cluste
• F. Then run the Hadoop utility to copy them do HDF
• G. Mount the Hive tables from HDFS.
• H. Leverage Cloud Storage connector for Hadoop to mount the ORC files as external Hive table
• I. Replicate external Hive tables to the native ones.
• J. Load the ORC files into BigQuer
• K. Leverage BigQuery connector for Hadoop to mount the BigQuery tables as external Hive table
• L. Replicate external Hive tables to the native ones.

Answer: BC

NEW QUESTION 19

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?

• A. Use a row key of the form <timestamp>.
• B. Use a row key of the form <sensorid>.
• C. Use a row key of the form <timestamp>#<sensorid>.
• D. Use a row key of the form >#<sensorid>#<timestamp>.

Answer: A

NEW QUESTION 20

Cloud Dataproc charges you only for what you really use with billing.

• A. month-by-month
• B. minute-by-minute
• C. week-by-week
• D. hour-by-hour

Answer: B

Explanation:
One of the advantages of Cloud Dataproc is its low cost. Dataproc charges for what you really use with minute-by-minute billing and a low, ten-minute-minimum billing period.
Reference: https://cloud.google.com/dataproc/docs/concepts/overview

NEW QUESTION 21

You are building new real-time data warehouse for your company and will use Google BigQuery streaming inserts. There is no guarantee that data will only be sent in once but you do have a unique ID for each row of data and an event timestamp. You want to ensure that duplicates are not included while interactively querying data. Which query type should you use?

• A. Include ORDER BY DESK on timestamp column and LIMIT to 1.
• B. Use GROUP BY on the unique ID column and timestamp column and SUM on the values.
• C. Use the LAG window function with PARTITION by unique ID along with WHERE LAG IS NOT NULL.
• D. Use the ROW_NUMBER window function with PARTITION by unique ID along with WHERE row equals 1.

Answer: D

NEW QUESTION 22

Your neural network model is taking days to train. You want to increase the training speed. What can you do?

• A. Subsample your test dataset.
• B. Subsample your training dataset.
• C. Increase the number of input features to your model.
• D. Increase the number of layers in your neural network.

Answer: D

Explanation:
Reference: https://towardsdatascience.com/how-to-increase-the-accuracy-of-a-neural-network-9f5d1c6f407d

NEW QUESTION 23

Flowlogistic’s management has determined that the current Apache Kafka servers cannot handle the data volume for their real-time inventory tracking system. You need to build a new system on Google Cloud Platform (GCP) that will feed the proprietary tracking software. The system must be able to ingest data from a variety of global sources, process and query in real-time, and store the data reliably. Which combination of GCP products should you choose?

• A. Cloud Pub/Sub, Cloud Dataflow, and Cloud Storage
• B. Cloud Pub/Sub, Cloud Dataflow, and Local SSD
• C. Cloud Pub/Sub, Cloud SQL, and Cloud Storage
• D. Cloud Load Balancing, Cloud Dataflow, and Cloud Storage

Answer: C

NEW QUESTION 24
......